SELECT A~FTRMI
A~AUFNR
B~MATNR
D~MAKTX
B~PSMNG
B~WEMNG
C~MTART
E~CHARG
C~MATKL
C~SPART
R~BWART
R~CHARG
R~MATNR
E~BWART
R~BDMNG
INTO TABLE ITAB
FROM AFKO AS A INNER JOIN AFPO AS B ON A~AUFNR = B~AUFNR
* INNER JOIN AFVC AS A1 ON A~AUFPL = A1~AUFPL AND B~DWERK =
A1~WERKS
INNER JOIN MARA AS C ON B~MATNR = C~MATNR
INNER JOIN MAKT AS D ON C~MATNR = D~MATNR
INNER JOIN MSEG AS E ON B~MATNR = E~MATNR AND A~AUFNR =
E~AUFNR AND B~DWERK = E~WERKS
INNER JOIN RESB AS R ON A~AUFNR = R~AUFNR AND E~AUFNR =
R~AUFNR AND R~RSNUM = A~RSNUM
AND R~WERKS = E~WERKS AND R~BAUGR = E~MATNR
INNER JOIN MARA AS C1 ON R~MATNR = C1~MATNR
WHERE A~FTRMI IN S_DATE AND A~AUFNR IN S_AUFNR AND C~MTART
IN S_TYPE AND C~MATKL = 'T'
AND R~BWART ='261' AND E~BWART = '101'
AND R~XWAOK ='X' AND B~DWERK = '2000'
AND R~XLOEK EQ SPACE AND E~KZBEW ='F' AND D~SPRAS = 'E' AND
R~KZEAR = 'X' AND C~MATNR IN S_MATNR.
This query gives repetative records from RESB.There must be
some common field which i am not taking thats why its
giving repetative records. If u find any solution pls lety
me know ASAP.
Thanks
Swati Ghadge
No Answer is Posted For this Question
Be the First to Post Answer
What is the effect of the OPTIONS statement ERRORS=1?
3 Answers QSG, Quintiles, SAS,
in IT trend mantis meant what? how to know mantis in IT trends? detail description about mantis?
0 Answers Sacred Heart College,
1. What coding languages are you comfortable with?
what is difference between input parameter and output parameter.
why we use mantis? what u mean mantis in IT trends? addvantages of mantis?
0 Answers HCL, Sacred Heart College,
Compare any 4 software development life cycle paradigms with each other. Indicate at least one application for each of the paradigms that are suitable to developed using that paradigm.
EXPLAIN UNARY OPEARATORS
why you have to became a software developer?
diffrence between oracle apps , .NET , SAP
Code for display the images from drive using vb 6.0?
how to work search engine? plz detail answer me.
can any one suggestion me present which course(except java,.net) has huge demand in the market?