Skip to Content
0
Jun 10, 2020 at 01:46 PM

Excluding all the Archived Purchasing document

77 Views

I am getting all the Purchasing document that is archived and I'm getting an error that "The work area "I_TAB" has fewer fields than selected." Can you tell me what is wrong with my code below?

TYPES: BEGIN OF t_tab,
ebeln LIKE ekpo-ebeln,
loekz LIKE ekko-loekz,
matnr LIKE ekpo-matnr,
werks LIKE ekpo-werks,
ewebaz LIKE ekpo-webaz,
eplifz LIKE ekpo-plifz,
END OF t_tab

DATA: i_tab TYPE STANDARD TABLE OF t_tab,
wa_tab TYPE t_tab.

SELECT
a~ebeln,
a~matnr,
a~werks,
a~webaz,
a~plifz,
b~ebeln,
b~loekz
INTO TABLE @i_tab
FROM ekpo AS a
LEFT OUTER JOIN
ekko AS b
ON a~ebeln EQ b~ebeln
WHERE
b~loekz NE 'X'.