Skip to Content
avatar image
Former Member

BSIK-belnr = RSEG-BELNR?

Hi,

Is the belnr in bsik same with the belnr in rseg?

Or is it the augbl of bsik same with the belnr in rseg?

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    May 02, 2008 at 10:02 AM

    Hi

    No! I don't believe:

    BSIK-BELNR is the accounting document number

    RSEG-BELNR is the incoming invoice number

    The link beetween the two document is in BKPF-AWTYP and BKPF-AWKEY

    It should be:

    BKPF-AWTYP = 'RMRP'
    BKPF-AWKEY =  RBKP-BELNR + RBKP-GJAHR.
    
    SELECT * FROM BSIK WHERE .......
        
       SELECT SINGLE * FROM BKPF WHERE BUKRS = BSIK-BUKRS
                                                              AND BELNR = BSIK-BELNR
                                                              AND GJAHR = BSIK-GJAHR
    
            SELECT * FROM RSEG WHERE BELNR = BKPF-AWKEY(10)
                                                      AND GJAHR = BKPF-AWKEY+10(4)

    Anyway perhaps the incoming invoice is written on XBLNR or ZUONR field, but that depends on your customizing.

    Max

    Max

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2008 at 09:57 AM

    Hi Navi,

    BELNR of BSIK is same as that of BELNR of RSEG.

    Both refer to same DAta Element BELNR_D i.e. of TYPE CHAR and LENGTH 10 and both are Accounting Document Number.

    Reward if Helpful.

    Regards,

    Sunil.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2008 at 10:07 AM

    hi navi

    it is same dear in both the tabel and also it is a part of primary key in both the table so if u want to stablish any relation between this two u can go ahead

    reward if helpfull

    snehi chouhan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 02, 2008 at 10:08 AM

    Hi,

    Hi it is BSIK-BELNR = BSEG-BELNR

    Regards

    Sandipan

    Add comment
    10|10000 characters needed characters exceeded