Skip to Content
avatar image
Former Member

Coding in SQ02 for compare the BKPF and RSEG Tables

Hi Expects ,

I am going to develop report for getting Accounting document from RSEG Table with comparison of BKPF  ,

But in RSEG  Reference filed contain docno+year  and BKPF Contain onyy Docno , how can i compare and where can i write the code please.

Regards,

Suman Baina

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Dec 29, 2014 at 08:10 AM

    Hi Suman,

    Both table have field Accounting document number,you use this field for your comparions.

    field name:BELNR and other common field GJAHR for both table.

    With regards,

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Sir,

      As per my observations RSEG Contain Only MIRO Document Numbers not MIRO Accounting Document number .

      I need accounting Documents number against the MIRO Document Please.

      Regards,

      Suman

  • Dec 29, 2014 at 08:12 AM

    Dear Suman,

    Kindly try the same with reference field(XBLNR) instead of reference key (AWKEY).

    Else you need to use BSEG table along with field SGTXT for finding GR number.

    Regards,

    Karna J

    Add comment
    10|10000 characters needed characters exceeded