Answer Posted / t chinna shareef

SQL>set serveroutput on;
SQL>begin
2 dbms_output.put_line("ARCHANA");
3 end;
4 /

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

3089

---

suppose we have ten members of a physical file but we want the output of last 5 members only.how to achieve that?

1726

---

Given a set. Write the pseudo code to get all the subsets for the given set. Eg. Input : {1,2} Output : (),(1),(2),(1,2)

2435

---

Tell me the jobs for the MCA Fresher in delhi, Noida..

2125

---

Diffrence between 2.0,3.0,3.5,4.0. versions of .net?

2933

---

---

Given an array of size n. It contains numbers in the range 1 to n. Each number is present at least once except for 1 number. Find the missing number

911

---

Difference between delegates and Events?

1879

---

1.what is the vesition managment.

1892

---

how will you code the subfile which is in editing mode (multiple case subfile)?

1796

---

hoe to data grid use in sql server 2000?

1826

---

Hi I am Rathnam, How To Remove the duplicates with out using remove duplicate stage in the datastage

1702

---

Write a program that prints the numbers from 1 to 100. But for multiples of three print "Fit" instead of the number and for the multiples of five print "Bit". For numbers which are multiples of both three and five print "FitBit".

2158

---

What ports must be open for DCOM over a firewall? What is the purpose of Port 135?

7487

---

< No Frames > tag is used for

2303

---

3 members in a pf.how we read 3 members without using ovrdbf.using rg pgms....

1879

---