Skip to Content
0
Former Member
Jun 26, 2009 at 06:23 AM

OPEN SQL (SELECT DATA)

43 Views

Hi, everybody!

Recent i found a few code but i don't know this mean of code. fllows as.

SELECT BMATNR BWERKS E~MTARP AS MTART

CSPART DMAKTX

APPENDING CORRESPONDING FIELDS

OF TABLE LT_PMAT

FROM STPO AS A

INNER JOIN MAST AS B

ON BSTLNR = ASTLNR

INNER JOIN MARA AS C

ON CMATNR = BMATNR

INNER JOIN MARC AS E

ON EMATNR = BMATNR

AND EWERKS = BWERKS

LEFT OUTER JOIN MAKT AS D

ON DMATNR = BMATNR

AND D~SPRAS = C_E

FOR ALL ENTRIES IN LT_CMAT

WHERE A~STLTY EQ C_M "Material Bom

AND A~IDNRK EQ LT_CMAT-MATNR

AND B~WERKS IN R_WERKS

AND B~STLAN IN R_STLAN

AND B~STLAL IN R_STLAL

%_HINTS ORACLE

'LEADING(T_00) USE_NL(T_00 T_01 T_02 T_03 T_04)'.

look bold-face!

I don't know what is "%" and code of last-line !

Please help me!

Thanks Advanced!