Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 0 Answers
- 3332 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How can successful and thorough systems planning, analysis, and design be ruined by poor systems construction and implementation? How can poor systems analysis or design ruin a smooth construction and implementation? For both questions, list some consequences
how to stop execution of step 3 in a job mainframe
what is the use of check point
Which method protects back button to retrieve old value from previous page in Struts.
can any method return type may be constructor , or that method name allow
A combination of multiple keys defined in a physical file or logical file is called a _________ key
How to set fixed width in particular <td> in html? if i type more character in this <td> it will not push near <td>. this is my question. can u tell me the answer...
why not instantiating servet using new operator?
what is the difference between an OS(operating system) and Framework?
in cobol,wat is the difference in using 'set index in occurs clause' ....and 'occurs depending-on clause'
What language / script is used to validate web page
Building Quotation engine program
C 
