Home
Forum 
Dictionary 
Reports
BDC
ABAP Objects Three tables inner join in SAP
Page 1 of 1
Three tables inner join in SAP
Uma_ABAP Thu May 03, 2012 4:47 pm
SELECT a~matnr INTO TABLE lt_mat
FROM mara AS a INNER JOIN marc AS c ON c~matnr = a~matnr
INNER JOIN mard AS d ON d~matnr = a~matnr
WHERE ( c~werks = p_werks AND d~lgort IN s_lgort ) AND matkl IN lt_mgreg AND
a~lvorm = ' ' AND c~lvorm = ' ' .
FROM mara AS a INNER JOIN marc AS c ON c~matnr = a~matnr
INNER JOIN mard AS d ON d~matnr = a~matnr
WHERE ( c~werks = p_werks AND d~lgort IN s_lgort ) AND matkl IN lt_mgreg AND
a~lvorm = ' ' AND c~lvorm = ' ' .
Uma_ABAP- Posts : 56
Join date : 2012-03-31
Similar topics» Difference between transparent tables and pooled tables?
» What is the difference between transparent tables and pooled tables?
» Inner join example in SAP-ABAP
» What are control tables in SAP?
» Using Internal tables in ABAP Objects
» What is the difference between transparent tables and pooled tables?
» Inner join example in SAP-ABAP
» What are control tables in SAP?
» Using Internal tables in ABAP Objects
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
» Difference between Type and Like
» How to handle table control fields in Module Pool program?
» Three tables inner join in SAP
» Creating table type in ABAP
» Creating user defined types and structures in ABAP
» Creating Dynamic Internal Table and Dynamic Field catalog in SAP-ABAP
» Copy Custom PF-Status from Standard program to Custom Program in ALV
» Calculate/find number of working days between two dates in SAP