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

3317

Which dialog boxes can you use in your android application?

939

What is the strongest bridge for a school contest?

1172

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1124

I have created a new vendor. Later I found that there were some mistakes and that I want that the system should not allow me to make any po or post any entries to this vendor. How to deactivate this vendor?

1091

What is the meaning of the enq command?

1078

what are "R-condition"and "T-condition" in the designation of Steels ??

2845

Where can I download the matlab source code for Mean-shift image segmentation method?

3155

Does ubuntu live usb save changes?

721

What are the network requirements for hadoop?

474

How to get registered through e-application?

1011

Where do you specify the Mapper Implementation?

981

Why do we need Interview?

2081

Have you ever sent a prospect a written communication that contained a spelling or grammatical error? : insurance sales

564

What are examples of structures?

1102