Answer / Anilkumarsingh

To prepare for a programming language interview, you can find valuable resources in the following places:<br><br>- [LeetCode](https://leetcode.com/) - A popular platform offering algorithmic challenges and solutions.<br>- [HackerRank](https://www.hackerrank.com/) - Another site featuring coding challenges, contests, and learning materials.<br>- [Project Euler](https://projecteuler.net/) - A collection of challenging mathematical/computer programming problems.<br>- [GeeksforGeeks](https://geeksforgeeks.org/) - A comprehensive resource for learning various topics in computer science.

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

1 Answers  

---

hi..this is kartheek..complted mca in 2009..but i dont have knowledge in programing..but to learn new language.. which one is suitable for me?is SAP or IBM mainframes is suitable for me..?if it suits how much will it costs..?pls answer...

1 Answers  

---

i want to insert textbox value to sql db. i have only one text box but store four values. ple give any one give sample code in asp.net c#..

1 Answers   Concentrix,

---

why Java is not purely object oriented?

9 Answers   Persistent,

---

what diffrence between procedure and function?

3 Answers  

---

What is the best action a system can take when deadlock is detected

2 Answers  

---

what are the steps for creating prompt table dynamically for the specified field

0 Answers  

---

What is the client concept in SAP? What is the meaning of client independent?

3 Answers  

---

Hi guyes, I have cleared 2 technical rounds with cts for liferay and java techonologies, i have client round next week, please tell me how to prepare for this what questions i should be ready to face?

1 Answers  

---

what is the difference between "types" and "data" in abap.

4 Answers   Tech Soft,

---

what is meaning of MDM in sap?let me know that meaning

1 Answers  

---

What is the difference between CriteriaQuery and CreateQuery in Hibernate???? Thanks in advance!!!!!!

1 Answers   Accenture,

---