SAP JOIN SYNTAX

SAP Join Syntax

 

SELECT a~bukrs,
a~land1,
b~kalsm,
c~mwskz,
c~mwart
FROM t001 AS a
INNER JOIN t005 AS b ON
a~land1 = b~land1
INNER JOIN t007a AS c ON
b~kalsm = c~kalsm
INTO TABLE @DATA(lt_tax_code)
FOR ALL ENTRIES IN @gt_file
WHERE bukrs = @gt_file-bukrs.

Leave a Reply

Your email address will not be published. Required fields are marked *