Skip to Content
0
Former Member
May 23, 2016 at 11:02 AM

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

617 Views

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.