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

Less than a week after joining the SY project, he was unprepared to participate in an interface project between SRM and SAP systems to participate in the scenario of prefabricated invoices data transfer between SRM and SAP systems. From a technical point of view, it is necessary to find out the list of data fields transferred from the SRM system to the SAP system and from the SAP system to the SRM system in each scenario. The most complicated scenario in this requirement is that the business staff initiates the prefabricated invoice application on the SRM system. After examination and approval, the prefabricated invoice is passed to the SAP system through the API, and the prefabricated invoice is created in the SAP system, and then sent back to the SRM system. In addition, the business staff may modify the approved prefabricated invoice application in the SRM system, and this change will also be transferred to the SAP system through the API. In both scenarios, SAP accepts data from the SRM system.

I need to communicate with the SRM system operation and maintenance project team to tell SRM colleagues which parameters need to be passed to the SAP system in these two scenarios. The prefabricated invoice function is seldom used in the project that the author participates in, but it is used in a multinational enterprise operation and maintenance project a few years ago, but we only operate and maintain, and do not participate in the realization of the function. So this thing is still a relatively new thing for me. In order to meet the needs of work, and is an urgent need, the author looked up the information on the Internet and got the following piece of text, which is very helpful to the author and greatly reduces the time for the author to study and study.

The following English part of the text comes from the Internet

SAP MM BAPI_INCOMINGINVOICE_PARK-Invoice Verification: Park Incoming InvoiceFunctionality

You can use this method to park incoming invoices.

When header data is transferred, you use the field INVOICE_IND to determine whether the system generates a credit memo or an invoice. If you leave the field initial, the system generates a credit memo. If you enter X, the system generates an invoice.

You use this method if information on posting an invoice document is missing in the invoice document. The balance can be a value other than zero. As in the online transaction, the following updates take place: for example, informative PO history, advance tax return, index for checks re duplicate invoices, open creditor items from parked documents, log of document changes.

You can use this method to:

Park invoices with multiple account assignmentChange and park invoice account assignmentsPark invoices for blanket purchase orders (see also the documentation for the function module BAPI_INCOMINGINVOICE_CREATE) Park invoices for purchase orders with planned delivery costsPark invoices with unplanned delivery costsPark subsequent credits and debitsUse document types with external number rangesPark invoices with withholding taxPark invoices with several creditor lines and different methods and terms of paymentPark invoices for purchase orders for external servicesPark invoices with Gram L account postingsPark invoices with material account postingsPark invoices for an one-time supplierPark invoices with a different payeeCreate and post provisional/differential invoices and final invoices in the context of differential invoicing

(See also documentation for function module BAPI_INCOMINGINVOICE_CREATE (Invoice Verification: Post Incoming Invoice)) Constraints

You cannot post invoices for returns orders

The following fields in Financial Accounting are not passed on:

ISR subscriber number (ISR = inpayment slip with reference number) Bank detailsPayment referenceShort key for house bankService indicatorNotes

The following authorization object is checked with activity 77:

M_RECH_WRKPlant authorization for entering incoming invoicesInput parameters

You transfer the header data of the incoming invoice using the structure HeaderData.

The tables ItemData and AccountingData contain the item data of the incoming invoice. The TaxData table contains the tax information for the incoming invoice.

The GlAccountData table contains data for posting to G/L accounts, and the MaterialData table contains data for posting to material accounts.

You can use the WithTaxData table to pass on withholding tax information.

You can use the VendorItemSplitData table to distribute the gross amount among several vendor line items with different methods and terms of payment.

Output parameters

The document number of the invoice document and the fiscal year are returned as key fields of the incoming invoice.

Return messages

Messages are returned in the Return parameter. The parameter documentation shows the return codes and their meanings.

Further information

Example: Incoming Invoice

This example shows which header data you can park in the table HeaderData and which item data you can park in the table ItemData.

Purchase Order: 10 pc of material A @ 10 USD

Goods receipt: 10 pc of material A

For this purchase order, you receive an incoming invoice referencing PO number 4500007491, PO item 10, for a quantity of 10 pc of material An and an amount of 116 USD incl. 16% VAT. You enter the following data:

HeaderData table

INVOICE_IND (invoice/credit memo): XDOC_DATE (document date): 20.05.2000PSTNG_DATE (Posting date): 23.05.2000COMP_CODE (company code): 1000GROSS_AMOUNT (Gross amount): 116 CURRENCY (currency key): USDCALC_TAX_IND (calculate tax): XItemData table

INVOICE_DOC_ITEM (Invoice document item): 00001PO_NUMBER (purchase order number): 4500007491PO_ITEM (Purchase order item): 00010TAX_CODE (Tax code): VNITEM_AMOUNT (Item amount): 100QUANTITY (Quantity): 10PO_UNIT (Unit of measure): pcFor more information, see the parameter documentation for the HeaderData and ItemData tables.

Example: Incoming invoice with foreign currency, GR-based invoice verification, and tax information

This example specifies the header data that you need to enter in the HeaderData table, the item data that you need to enter in the Itemdata table, and the tax information that you need to enter in the TaxDatatable, in order to park an invoice in a foreign currency.

Purchase Order: 10 pc of material A @ 10.00 USD

Goods receipt 1: 4 pc of material A

Goods receipt 2: 6 pc of material A

For this purchase order, you receive an incoming invoice referencing PO no. 4500007505, PO item 10, goods receipt document 50010095, 2000, item 1.A quantity of 4 pc of material An and a gross amount of 46.60 USD and 16% tax (6.60 USD) is invoiced. You enter the following data:

HeaderData table

INVOICE_IND (invoice/credit memo): XDOC_DATE (document date): 20.05.2000PSTNG_DATE (Posting date): 23.05.2000COMP_CODE (company code): 1000CURRENCY (currency key): USDGROSS_AMOUNT (Gross amount): 46 miner 60ItemData table

INVOICE_DOC_ITEM (Invoice document item): 00001PO_NUMBER (purchase order number): 4500007505PO_ITEM (Purchase order item): 00010REF_DOC (GR document): 50010095REF_DOC_YEAR (fiscal year of current period): 2000REF_DOC_ITEM (Item in a GR document): 1TAX_CODE (Tax code): VNITEM_AMOUNT (Item amount): 40Power00QUANTITY (Quantity): 4PO_UNIT (Unit of measure): pcTaxData table

TAX_CODE (tax code): VNTAX_AMOUNT (tax amount in document currency): 6Jing 60For more information, see the parameter documentation for the HeaderData, ItemData, and TaxData tables.

Example: Change account assignments and add unplanned ones

This example shows which header data you enter in the HeaderData table, which item data you enter in the ItemData table, and which account assignment data you enter in the AccountingData table in order to be able to change account assignments for an incoming invoice. For you to be able to change account assignments, a non-valuated goods receipt or no goods receipt must exist. GR-based invoice verification takes place.

Purchase Order: 300 pc of material A @ 1.00 USD

Goods receipt: 300 pc of material A

For this purchase order with multiple account assignments, you receive an incoming invoice referencing PO number 4500006846, PO item 10, GR document 50008849, 2000, item 1.The quantity invoiced is 100pc of material A, for a gross amount of 116.00 USD including 16% VAT. You want to change the planned account assignment for the second account assignment object and add an unplanned account assignment. You enter the following data:

HeaderData table

INVOICE_IND (invoice/credit memo): XDOC_DATE (document date): 05.08.2000PSTNG_DATE (Posting date): 08.08.2000COMP_CODE (company code): 1000CURRENCY (currency key): USDGROSS_AMOUNT (Gross amount): 17lc 40CALC TAXIND (Automatically calculate tax): XPMNTTRMS (Payment terms key): 0001ItemData table

INVOICE_DOC_ITEM (Invoice document item): 00001PO_NUMBER (purchase order number): 4500006846PO_ITEM (Purchase order item): 00010REF_DOC (GR document): 500008849REF_DOC_YEAR (fiscal year of current period): 2000REF_DOC_ITEM (Item in a GR document): 1TAX_CODE (Tax code): VNITEM_AMOUNT (Item amount): 100QUANTITY (Quantity): 100PO_UNIT (Unit of measure): pcAccountingData table

Line 1: Change second account assignment item

INVOICE_DOC_ITEM (Document item in invoice document): 0001SERIAL_NO (Serial number for the account assignment): 02TAX_CODE (Tax code): VNITEM_AMOUNT (Amount in document currency): 10LQUANTITY (Quantity): 10PO_UNIT (purchase order unit): pcGL_ACCOUNT (pcGL_ACCOUNT L account number): 890000COSTCENTER (Cost center): 1200Line 2: Add unplanned account assignment

INVOICE_DOC_ITEM (Document item in invoice document): 0001XUNPL (Unplanned account assignment from Invoice Verification): XTAX_CODE (Tax code): VNITEM_AMOUNT (Amount in document currency): 5Jing 00QUANTITY (Quantity): 5PO_UNIT (purchase order unit): pcGL_ACCOUNT (pcGL_ACCOUNT L account number): 890000COSTCENTER (Cost center): 1200For more information, see the parameter documentation for the tables HeaderData, ItemData and AccountingData.

Example: Incoming invoice with planned delivery costs

This example shows the header data that you need to enter in the HeaderData table, the item data that you need to enter in the ItemData table, and the tax information that you need to enter in table TaxData to create an invoice containing planned delivery costs.

Purchase Order: 100 pc of material A @ 1.00 USD

Goods receipt: 100 pc of material A

For this purchase order, you receive an incoming invoice referencing PO no. 4500006986, PO item 10, for a quantity of 100 pc of material An and an amount of 136.00 USD incl. 16% VAT and 20.00 USD planned delivery costs. You enter the following data:

HeaderData table

INVOICE_IND (invoice/credit memo): XDOC_DATE (document date): 10.08.2000PSTNG_DATE (Posting date): 12.08.2000COMP_CODE (company code): 1000CURRENCY (currency key): USDGROSS_AMOUNT (Gross amount): 136 meme 00ItemData table

Line 1: Entry of PO item

INVOICE_DOC_ITEM (Invoice document item): 00001PO_NUMBER (purchase order number): 4500006986PO_ITEM (Purchase order item): 00010TAX_CODE (tax code): VNITEM_AMOUNT (Item amount): 100Power00QUANTITY (Quantity): 100PO_UNIT (Unit of measure): pcLine 2: Entry of planned delivery costs

INVOICE_DOC_ITEM (Invoice document item): 00002PO_NUMBER (purchase order number): 4500006986PO_ITEM (Purchase order item): 00010ITEM_AMOUNT (Item amount): 207.00QUANTITY (Quantity): 100PO_UNIT (Unit of measure): pcCOND_TYPE (condition type): FRB1TaxData table

TAX_CODE (tax code): VNTAX_AMOUNT (tax amount in document currency): 16je 00For more information, see the parameter documentation for the HeaderData, ItemData, and TaxData tables.

Example: Incoming invoice with withholding tax

This example shows which header data you can enter in the HeaderData table, which item data you can enter in the Itemdata table, and which withholding tax information you can enter in the WithTaxData table, in order to park an incoming invoice with withholding tax.

Purchase Order: 10 pc of material A @ 10.00 USD

Goods receipt: 10 pc of material A

For this purchase order, you receive an incoming invoice referencing PO no. 4500007505, PO item 10, goods receipt document 50010095, 2000, item 1. A quantity of 10 pc and a gross amount of 100.00 USD is invoiced. You have to pay 10% withholding tax on the gross amount. Enter the following data:

HeaderData table

INVOICE_IND (invoice/credit memo): XDOC_DATE (document date): 20.05.2000PSTNG_DATE (Posting date): 23.05.2000COMP_CODE (company code): WT01CURRENCY (currency key): USDGROSS_AMOUNT (Gross amount): 10000ItemData table

INVOICE_DOC_ITEM (Invoice document item): 00001PO_NUMBER (purchase order number): 4500007505PO_ITEM (Purchase order item): 00010REF_DOC (GR document): 50010095REF_DOC_YEAR (fiscal year of current period): 2000REF_DOC_ITEM (Item in a GR document): 1TAX_CODE (Tax code): V0ITEM_AMOUNT (Item amount): 100pr 00QUANTITY (Quantity): 10pm 00POUNIT (Unit of measure): pcWithTaxData table

SPLIT_KEY (grouping key for splitting withholding tax): 0001WI_TAX_TYPE (indicator for withholding tax type): R1WI_TAX_CODE (Withholding tax indicator): 01WI_TAX_BASE (Withholding tax base amount): 100WI_TAX_AMT (withholding tax amount in document currency): 10 for more information, see the parameter documentation for the HeaderData, ItemData and WithTaxData tables.

Example: Incoming invoice with amount split

This example shows which header data you enter in the HeaderData table, which item data you enter in the Itemdata table, and which information you enter in the VendorItemSplitData table, in order to generate an incoming invoice with an amount split.

Purchase Order: 10 pc of material A @ 10.00 USD

Goods receipt: 10 pc of material A

For this purchase order, you receive an incoming invoice referencing PO no. 4500007505, PO item 10, goods receipt document 50010095, 2000, item 1. A quantity of 10 pc and a gross amount of 100.00 USD is invoiced. You want to distribute the gross amount among two creditor lines. 40% of the gross amount is to be paid immediately by check, and the remaining 60% of the gross amount is to be paid within 14 days subject to 3% cash discount. You enter the following data:

HeaderData table

INVOICE_IND (invoice/credit memo): XDOC_DATE (document date): 20.05.2000PSTNG_DATE (Posting date): 23.05.2000COMP_CODE (company code): 0001CURRENCY (currency key): USDGROSS_AMOUNT (Gross amount): 10000ItemData table

INVOICE_DOC_ITEM (Invoice document item): 00001PO_NUMBER (purchase order number): 4500007505PO_ITEM (Purchase order item): 00010REF_DOC (GR document): 50010095REF_DOC_YEAR (fiscal year of current period): 2000REF_DOC_ITEM (Item in a GR document): 1TAX_CODE (Tax code): V0ITEM_AMOUNT (Item amount): 100pr 00QUANTITY (Quantity): 10pm 00POUNIT (Unit of measure): pcVendorItemSplitData table

Vendor line item 1

SPLIT_KEY (Grouping key for splitting creditor line): 0001SPLIT_AMOUNT (partial invoice amount in document currency): 40Magneto 00PYMT.Meth (payment method): STAX_CODE (tax code): V0PMNTTRMS (Payment terms key): 0001Vendor line item 2

SPLIT_KEY (Grouping key for splitting creditor line): 0002SPLIT_AMOUNT (partial invoice amount in document currency): 60Magneol 00PYMT.Meth (payment method): UTAX_CODE (tax code): V0PMNTTRMS (Payment terms key): 0003For more information, see the parameter documentation for the HeaderData, ItemData and VendorItemSplitData tables.

Example: Incoming invoice with G/L and material account posting.

This example shows you which header data you must enter in the HeaderData table, which item data you enter in the ItemData table, which G/L account information you enter in the GlAccountData table, and which material account information you enter in the MateralData table in order to park an incoming invoice.

You receive an invoice referencing PO no. 4500006846, PO item 10. A quantity of 150.80 pc of material A for a gross amount of 150.80 USD including 16% VAT is invoiced. This includes a G/L account posting of 10 USD to account 400000 in company code 1, and a material account posting of 20 USD to the material MAT01. You enter the following data:

HeaderData table

INVOICE_IND (post invoice/credit memo): XDOC_DATE (document date): 05.08.2000PSTNG_DATE (Posting date): 08.08.2000COMP_CODE (company code): 1000CURRENCY (currency key): USDGROSS_AMOUNT (Gross amount): 150 80CALC TAXIND (Automatically calculate tax): XPMNTTRMS (Payment terms key): 0001ItemData table

INVOICE_DOC_ITEM (Invoice document item): 00001PO_NUMBER (purchase order number): 4500006846PO_ITEM (Purchase order item): 00010TAX_CODE (Tax code): VNITEM_AMOUNT (Item amount): 100QUANTITY (Quantity): 100PO_UNIT (Unit of measure): pcGlAccountData table

INVOICE_DOC_ITEM (Document item in invoice document): 00001GL_ACCOUNT (Garcer L account): 400000ITEM_AMOUNT (Item amount): 10Mold 00DB crafted Ind (Debit/credit indicator): SCOMP_CODE (company code): 0001TAX_CODE (Tax code): VNCOSTCENTER (Cost center): 1MaterialData table

INVOICE_DOC_ITEM (Document item in invoice document): 0001MATERIAL (Material): MAT01PLANT (Valuation area): 0001DB_CR_INP (Debit/credit indicator): SITEM_AMOUNT (Item amount): 10Power00QUANTITY (MENGE_D): 1PO_UNIT (purchase order unit): pcTAX_CODE (Tax code): VNFor more information, see the parameter documentation for the tables HeaderData, ItemData, GlAccountData and MaterialData

Example: Incoming invoice for a purchase order for external services and service-based invoice verification

This example shows which header data you must enter in the HeaderData table, which item data you must enter in the ItemData table, and which account assignment data you must enter in the AccountingData table in order to enter and post an incoming invoice.

You receive an invoice referencing PO no. 4500000191, PO item 10. The invoice is for two services An and B, each with a quantity of six service units. Service A has a gross amount of 580 USD incl. 16% VAT. Service B has 812 USD including 16% VAT. 50% of service A was assigned to each of the cost centers 1000 and 2000. 50% of service B was assigned to each of the cost centers 1000 and 3000. The service acceptance is performed jointly for both services with the service entry sheet number 1000000022. The account assignments cannot be changed. You enter the following data:

HeaderData table

INVOICE_IND (post invoice/credit memo): XDOC_TYPE (Document type): REDOC_DATE (document date): 10.01.2002PSTNG_DATE (Posting date): 10.01.2002COMP_CODE (company code): 0001CURRENCY (currency key): USDGROSS_AMOUNT (Gross amount): 1392 Automatically calculate tax: XPMNTTRMS (Payment terms key): 0001ItemData table

First entry for service A:

INVOICE_DOC_ITEM (Invoice document item): 000001PO_NUMBER (purchase order number): 4500000191PO_ITEM (Purchase order item): 00010TAX_CODE (Tax code): V1ITEM_AMOUNT (Item amount): 250Power00Quantity (Quantity): 3PO_UNIT (Unit of measure): SUSHEET_NO (Entry sheet number): 1000000022SHEET_ITEM (Line number): 10Second entry for service A:

INVOICE_DOC_ITEM (Invoice document item): 000002PO_NUMBER (purchase order number): 4500000191PO_ITEM (Purchase order item): 00010TAX_CODE (Tax code): V1ITEM_AMOUNT (Item amount): 250Power00Quantity (Quantity): 3PO_UNIT (Unit of measure): SUSHEET_NO (Entry sheet number): 1000000022SHEET_ITEM (Line number): 10First entry for service B:

INVOICE_DOC_ITEM (Invoice document item): 000003PO_NUMBER (purchase order number): 4500000191PO_ITEM (Purchase order item): 00010TAX_CODE (Tax code): V1ITEM_AMOUNT (Item amount): 350 3PO_UNIT (Quantity): 3PO_UNIT (Unit of measure): SUSHEET_NO (Entry sheet number): 1000000022SHEET_ITEM (Line number): 20Second entry for service B:

INVOICE_DOC_ITEM (Invoice document item): 000004PO_NUMBER (purchase order number): 4500000191PO_ITEM (Purchase order item): 00010TAX_CODE (Tax code): V1ITEM_AMOUNT (Item amount): 350 authorship (Quantity): 3PO_UNIT (Unit of measure): SUSHEET_NO (Entry sheet number): 1000000022SHEET_ITEM (Line number): 20AccountingData table

First account assignment for service A:

INVOICE_DOC_ITEM (Document item in invoice document): 000001SERIAL_NO (Serial number for the account assignment): 01TAX_CODE (Tax code): V1ITEM_AMOUNT (Amount in document currency): 250Magna 00QUANTITY (Quantity): 3PO_UNIT (purchase order unit): SUSecond account assignment for service A:

INVOICE_DOC_ITEM (Document item in invoice document): 000002SERIAL_NO (Serial number for the account assignment): 02TAX_CODE (Tax code): V1ITEM_AMOUNT (Amount in document currency): 250Magna 00QUANTITY (Quantity): 3PO_UNIT (purchase order unit): SUFirst account assignment for service B:

INVOICE_DOC_ITEM (Document item in invoice document): 000003SERIAL_NO (Serial number for the account assignment): 01TAX_CODE (Tax code): V1ITEM_AMOUNT (Amount in document currency): 350 language 00QUANTITY (Quantity): 3PO_UNIT (purchase order unit): SUSecond account assignment for service B:

INVOICE_DOC_ITEM (Document item in invoice document): 000004SERIAL_NO (Serial number for the account assignment): 03TAX_CODE (Tax code): V1ITEM_AMOUNT (Amount in document currency): 350 see the parameter documentation for the tables HeaderData 00QUANTITY (Quantity): 3PO_UNIT (purchase order unit): SUFor more information, see the parameter documentation for the tables HeaderData, ItemData, and AccountingData.

Example: Incoming invoice for an one-time supplier

This example shows how to proceed in order to enter and post an invoice for an one-time supplier.

It is not necessary to populate the AddressData table. If you do not enter any data in the AddressData table, the address data for the one-time supplier from the purchase order is adopted 1:1 in the invoice.

If you use the AddressData table for the data transfer, the address data for the one-time supplier is read from the purchase order into the invoice and is then overwritten or supplemented by the fields in the AddressData table.

In the purchase order for the one-time supplier, the name is' SAP AG', the postal code is' 60000, and the street and building number are 'Neurottstrasse 16. You receive an invoice with the one-time supplier address as follows: Name 'SAP AG', postal code' 69190, and place 'Walldorf'. Enter the following data:

AddressData table

ACC_1_TIME (One-time supplier indicator): X

NAME (Name): SAP AG

POSTL_CODE (Postal code): 69190

CITY (Place): Walldorf

The invoice is posted with the following one-time supplier address data: Name 'SAP AG', street and building number' Neurottstrasse 16, postal code '69190, place' Walldorf'.

For more information, see the parameter documentation for the table AddressData.

Example: Incoming invoice for different payee

This example shows you which address data you must enter in the AddressData table in order to enter and post an invoice for a different payee.

You receive an invoice for the different payee with the name 'SAP AG', postal code' 69190, place 'Walldorf', bank number' 38070724, and account number '4711. Enter the following data:

AddressData table

ACC_1_TIME (One-time supplier indicator):''

NAME (Name): SAP AG

POSTL_CODE (Postal code): 69190

CITY (Place): Walldorf

BANK_NO (Bank number): 38070724

BANK_ACCT (Bank account number): 4711

For more information, see the parameter documentation for table AddressData.

Example: Provisional invoice/differential invoice

For an example of how to create invoices within differential invoicing, see the documentation for function module BAPI_INCOMINGINVOICE_CREATE (Invoice Verification: Post Incoming Invoice).

Https://www.consolut.com/nc/en/s/sap-ides-access/d/s/doc/F-BAPI_INCOMINGINVOICE_PARK.html

2018-05-25 was arranged in Shanghai.

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.