Shulou(Shulou.com)06/01 Report--

SAP S4HANA How to get the condition type value in the 'Condition' tab of the purchase order ITEM, I believe many inexperienced people are helpless about this, for this reason this article summarizes the causes and solutions of the problem, through this article I hope you can solve this problem.

SAP S4HANA How to get the condition type value in the 'Conditions' tab of purchase order ITEM?

Recently enhanced function spec in preparation for a purchase order line item. There is a logic section that fetches the value of a specified condition type in the purchase order line item condition. For this logic, the author spent some time, took some detours, the author thinks can be recorded, convenient for their own reference and peer reference.

For example, when placing a purchase order, if you want to capture the value of ZPI2 condition type (12 CNY/PC) in the condition tab of ITEM 10, how should you capture it?

After research and investigation, the logic of obtaining a certain condition type according to the purchase order number is as follows:

1) According to the purchase order number, go to the EKKO table to retrieve the EKKO-KNUMV field value,

Take the value 1000031806 to the EKKO-KNUMV field.

2) Get data from PRCD_ELEMENTS table according to EKKO-KNUMV field value,

Enter 1000031806 for the value of 'Voucher Condition' field;

The 'Item' field value is the line item number in the purchase order, which is 10 in this case. Execute and get the following interface:

You can see that the price of ZPI2 condition type is 12 CNY/PC, as shown in the above picture.

3)The condition record in the purchase order exists in the table PRCD_ELEMENTS, which is the difference between S4HANA system and ECC system. When I was preparing this logic, I went to the Internet to look up information. Some of the tables I found, such as KONV/KOMP/KONH, could not find the data I wanted in S4HANA system!

After reading the above, do you know how SAP S4HANA gets the condition type value in the 'Conditions' tab of purchase order ITEM? If you still want to learn more skills or want to know more related content, welcome to pay attention to the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.