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

2959

How do you identify between actual alarm and false alarm in a Temperature Transmitter in SCADA based Control System

811

what do you mean by class PS CT and what are technical details needed for calculating it?

1599

What are the different methods of session maintenance in asp.net?

618

what is the BAM? where we can use it in BizTalk server?

1427

What are the different types of validation controls in asp.net?

605

How many types of functions are there in sql server?

528

How the exceptions are handled in struts?

595

How are Structure passing and returning implemented by the compiler?

688

Who am I command in linux?

629

What is an iframe?

328

What is the difference between Maintenance Order and Production Order. the point is i want to know the affection of Movement type 261 thru maintenance order and Production order. if i change any settings for Maintenance order it will affect to production order process also for 261 movement type ?

2098

What is intellisense?

674

How do you sort a map by key?

556

In cakephp, which function is first executed before every action in the controller?

3