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

2838

hey frnds..i have taken an emergency interview date of 21st july and my school is starting from 8th sept...i was continuously checking the date from 10 days but was not able to get a normal date...so can i get a rejection on this, that i have taken an emergency date.??????

1357

what is object cache in neo4j?

1

What are the ways in which the file can be detected as being uploaded or not?

131

Is there any report or table in which user log off time is stored in sap?

682

What are the use of Sandboxed soultions in SharePoint?

430

How would you facet the data using ggplot2 package?

60

Why should pumping be not used in case of concreting work?

897

Do you know what protocols fall under the tcp/ip internet layer?

585

What are various advantages of utilizing xslt?

477

cgl2012 tier1 mein 62.50 marks they or mera naam TA wali list mein tha but mainey Auditor ko 1st prefernce choose kia tha tier2 mein maths mein 142 or english mein 104.50 marks aaye but fir bhi mera naam only list4 TA main tha or mujhey DEST typing test dena parha i want to know that agar main TA k liye typing test pass ahi kar pata to kya mujhey koi bhi post milegi. pls anybody knows tell me.

1633

What is Another name of Dynamically allocating memory.

557

a text item is there what r the different types of triggers associated with it

1514

Required amount of Steel bars, cement/ square feet for roofing of residential building upto 3rd floor.

1262

What is the difference between alternator and generator?

744