Wrong table name or table alias name table alias name "RBKP"

[Former Member]

Hello All,

my following code is giving an error,

    IF r3 = 'X' OR r5 = 'X'.
   SELECT
     a~belnr
     a~gjahr
     a~budat
     a~rmwwr
     a~lifnr
     b~werks
     b~matnr
     b~bukrs
     b~buzei

     b~bklas
     b~lfbnr
     b~lfgja
     b~lfpos
     b~ebeln
     b~ebelp
     b~kschl
     b~wrbtr
     a~tcode
     a~stblg
     a~xblnr
     b~mwskz
     b~menge
     b~tbtkz
*  shkzg
    a~vgart
   
     FROM rbkp as a
     JOIN rseg as b ON ( rbkp~belnr eq rseg~belnr and rbkp~gjahr eq rseg~gjahr )
     INTO TABLE  it_rseg
     WHERE b~bukrs = p_bukrs
     AND a~gjahr = p_gjahr
*    AND budat IN s_budat
     AND a~lifnr IN s_lifnr
     AND b~matnr IN s_matnr
     AND b~bklas IN s_bklas
*    AND shkzg = 'H'
     AND b~mwskz IN s_mwskz1
     AND a~vgart NE 'KP'
     AND b~tbtkz = ' '.

error..

Wrong table name or table alias name table alias name "RBKP"

Thnks And Regards,

Nilesh.

[Ashg1402]

Hi,

Inspite of - rbkp~belnr eq rseg~belnr and rbkp~gjahr eq rseg~gjahr,   use  a~belnr eq  b~belnr and a~gjahr eq b~gjahr , and remove the brackets.

Regards

Ashish

[Former Member]

Thnks Ashish.