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

This article mainly introduces SAP how to query payment information report by purchase order. The content is detailed and easy to understand. The operation is simple and fast. It has certain reference value. I believe everyone will gain something after reading this SAP how to query payment information report by purchase order. Let's take a look at it together.

The author understands that FI module has a report FBL1N, which can query open or cleared payables. However, the author does not understand this report, with the user's question, the author is interested in studying the FBL1N report. In the customer's Quality system, the following results are obtained according to certain query conditions:

The author was pleasantly surprised to find that by adjusting the layout of the report, the "Purchase Order Number" field can be called up and displayed in the report.

However, the author was disappointed to find that the column "Purchase Order Number" in all open/cleared items in the report is empty, even if the relevant accounts payable financial voucher is related to an invoice related to a purchase order. As shown below:

Take the first line item 5100025794 as an example,

The relevant Invoice number is 5808387670/2014, and the Invoice information is displayed, as shown in the following figure:

It can be seen that this Invoice is related to a purchase order (8500529766). However, the purchase order number (8500529766) could not be displayed in the results of FBL1N. As we all know, SAP pays great attention to maintaining the Link relationship between documents. The purchase order number is displayed in the FBL1N report in an empty manner, which is not in SAP style.

What the hell is this? This again aroused the author's curiosity.

The author checked the information on the Internet and learned that this is the logic of standard SAP. Because the open item in FBL1N report is related to an invoice number, but multiple purchase order numbers may appear in an invoice, SAP system cannot capture the purchase order number and display it in FBL1N report results.

Some peers said that the purchase order number in the first item in the invoice can be displayed by enhancing the code. For example, one peer said:

I have done it with ABAP changes :

-change with trans. FIBF event 1650 : Function module LINE_ITEMS_GET_GKONT

- then change in FM get_gkont, so we get the first PO in that Field.

Some colleagues mentioned that they could consider displaying PO numbers in Assignment by defining Sort Key in vendor master data. We have the purchase order set at the sort key in the vendor master but the assignment field is coming thru as '00000' on FBL1N.

Combined with the results of querying information and consulting several senior FICO consultants, the author believes that there is no report in SAP system that meets this requirement of business.

About "SAP how to query payment information report according to purchase order" the content of this article is introduced here, thank you for reading! I believe everyone has a certain understanding of the knowledge of "SAP how to query payment information report according to purchase order." If you want to learn more knowledge, please pay attention to the industry information channel.

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.