Custom Invoic Template Sap

Download as xls, pdf, or txt
Download as xls, pdf, or txt
You are on page 1of 41
At a glance
Powered by AI
The document describes how IDOC fields map to specific application scenarios in SAP. It provides mapping spreadsheets that show the relationship between IDOC segments, fields, qualifiers and SAP tables and fields.

The document provides mapping spreadsheets to describe how IDOC fields are used in specific application scenarios in SAP. The mappings show how IDOC data is posted to SAP tables and fields.

The columns show the IDOC segment, field, field description, qualifier, qualifier description, corresponding SAP table, SAP field, usage, and any further comments. This provides all the necessary information to understand how each IDOC field maps to SAP.

IDOC to Application Mapping

The spreadsheets presented describe how IDOC fields are used in a specific application scenario. The heading of each spreadsheet specifies the exact application scenario.

All mapping documents have the following columns: Segment Field Field description Qualf Qualifier description SAP table SAP field Usage Further comments

1) Segment All SAP IDOCs have several segments in it. Here, all the name of the segments are entered. They appear in the same sequence as they would appear on an IDOC with the exception of the inbound SD orders scenario. 2) Field These are the IDOC fields. Each segment entered in the previous column has certain fields in. These fields will be sent out by R/3 on outbound transactions and received by R/3 on inbound transactions.

3) Field description This is the SAP data element description of the fields in column field. 4) Qualf SAP uses qualifiers to distinguish the usage of a field. Column Qualf lists possible qualifiers. Note that these are SAP specific qualifiers and have no correlation to ANSI.X12 EDIFACT or any other EDI standards. 5) Qualifier description This column gives the meaning of a field when it goes with a qualifier. 6) SAP table This shows the SAP table from which the IDOC field is taken. 7) SAP field If any field name is entered here, then there always will be a table name entered in the previous column. Both these columns should be read together. It means that the field name in this column is taken from table mentioned in the previous column and then sent out on an outbound IDOC as a field named in column 6. 8) Usage Fields can be M (Mandatory), O (Optional) or N (Not Used). The usage column indicates whether a field is M, O or N. If a field is mandatory then the EDI subsystem must send this field otherwise the data will not be posted to the application and the IDOC will error out. Fields on outbound transactions are mandatory if the IDOC creation routines fails when the field is blank. All other fields are either not used or they are labeled Optional.

9) Further Comments The last column is used to enter any comments that SAP feels would help in understanding the mapping.

MM inbound invoice

EDI Inbound MM INVOICE IDOC-to-SAP Mapping Document


Updated: 3/6/2012

Segment Field E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDK01 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 ACTION ACTION ACTION ACTION ACTION ACTION KZABS KZABS CURCY HWAER WKURS ZTERM KUNDEUINR EIGENUINR BSART BELNR NTGEW BRGEW GEWEI FKART_RL ABLAD BSTZD VSART VSART_BEZ RECIPNT_NO PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARTN LIFNR NAME1 NAME2 NAME3 NAME4 STRAS

Field description Action code for the whole EDI message Action code for the whole EDI message Action code for the whole EDI message Action code for the whole EDI message Action code for the whole EDI message Action code for the whole EDI message Indicator for order acknowledgment requirement Indicator for order acknowledgment requirement Currency EDI local currency Exchange rate Terms of payment key VAT registration number VAT registration number Purchasing document type IDOC document number Net weight Net weight Weight unit Invoice list type Unloading point Purchase order number supplement Shipping type Description of the shipping type

Qualf

000 001 002 003 004 X

Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner number Vendor number at customer location Name 1 Name 2 Name 3 Name 4 Street and house number 1

AG LF WE RE SP RG EK ZM VR CC BE PA BA BB RS ME

Seite 3

MM inbound invoice

E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDKA1 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02 E1EDK02

STRS2 PFACH ORT01 COUNC PSTLZ PSTL2 LAND1 ABLAD PERNR PARNR TELF1 TELF2 TELBX TELFX TELTX TELX1 SPRAS ANRED ORT02 HAUSN STOCK REGIO PARGE ISOAL ISONU FCODE IHREZ BNAME PAORG ORGTX PAGRU QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF BELNR QUALF QUALF

Street and house number 2 PO box City County code Postal code Postal code of PO box Country key Unloading point Contact person's personnel number Contact person's number (not personnel number) 1st telephone number of contact person 2nd telephone number of contact person Telebox number Fax number Teletex number Telex number Language key Title District House number Floor Region Partner's sex Country ISO code Country ISO code Company key (France) Your reference (partner's) IDOC user name IDOC organization code IDOC organization code IDOC group code IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC document number IDOC qualifier reference document IDOC qualifier reference document 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 009 015

Seite 4

MM inbound invoice

E1EDK02 POSNR E1EDK02 DATUM E1EDK02 UZEIT E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 E1EDK03 IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT DATUM IDDAT IDDAT IDDAT IDDAT E1EDK03 UZEIT E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 ALCKZ ALCKZ KSCHL KOTXT BETRG KPERC KRATE UPRBS MEAUN KOBTR MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ

Item number IDOC: Date IDOC: Time Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment IDOC: Date Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment IDOC: Time Surcharge or discount indicator Surcharge or discount indicator Condition type (coded) Condition text Fixed surcharge/discount on total gross Condition percentage rate Condition record per unit Condition pricing unit, ANSI X.12 length Unit of measurement IDOC Condition end amount VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 012 016 024 026

+ -

001 002 003 004 005

Seite 5

MM inbound invoice

E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK05 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK04 E1EDK17 E1EDK17 E1EDK17 E1EDK17

MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MSATZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MSATZ MWSBT TXJCD QUALF QUALF LKOND LKTEXT

VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT rate VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT rate Value added tax amount Jurisdiction for tax calculation - tax jurisdiction code IDOC qualifier: Terms of delivery IDOC qualifier: Terms of delivery IDOC delivery condition code IDOC delivery condition text IDOC qualifier: Terms of payment IDOC qualifier: Terms of payment

TXC TXL TXS VAT 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020

001 002 003 004 005 TXC TXL TXS VAT 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020

001 002

E1EDK18 QUALF E1EDK18 QUALF

001 002

Seite 6

MM inbound invoice

E1EDK18 QUALF E1EDK18 TAGE E1EDK18 PRZNT QUALF TAGE PRZNT QUALF TAGE PRZNT QUALF TAGE E1EDK18 ZTERM_TXT E1EDK23 E1EDK23 E1EDK23 E1EDK23 E1EDK23 E1EDK23 E1EDK23 E1EDK23 E1EDK28 E1EDK28 E1EDK28 E1EDK28 E1EDK28 E1EDK28 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 QUALF QUALF QUALF WAERZ WAERQ KURS DATUM ZEIT BCOUN BRNUM BNAME BALOC ACNUM ACNAM EXNUM ALAND EXPVZ ZOLLA ZOLLB ZOLL1 ZOLL2 ZOLL3 ZOLL4 ZOLL5 ZOLL6 KZGBE KZABE STGBE STABE CONTA CONTA GRWCU GRWRT LAND1 LANDX LANDA XEGLD XEGLD FREIH FREIH FREIH

IDOC qualifier: Terms of payment IDOC Number of days IDOC percentage for terms of payment IDOC qualifier: Terms of payment IDOC Number of days IDOC percentage for terms of payment IDOC qualifier: Terms of payment IDOC Number of days IDOC percentage for terms of payment IDOC qualifier: Terms of payment IDOC Number of days Line of text Qualifier currency Qualifier currency Qualifier currency Currency Currency Exchange rate IDOC: Date IDOC: Time Country key Bank key Bank name Location of bank Account number in bank data Account holder in bank data Export data number Depart.country (country from which the goods are sent) Mode of transport (when goods cross border) Office of exit Office of destination Customs office 1 Customs office 2 Customs office 3 Customs office 4 Customs office 5 Customs office 6 Indicator for means of transport crossing the border Indicator for the means of transport at departure Origin of means of transport for crossing the border Country of origin of the means of transport at departure ID: Goods cross border in a container ID: Goods cross border in a container Currency of statistical values Overall value in totals segment for shipping notification Country key Country name Alternative country key Indicator: European Union member ? Indicator: European Union member ? ID for free trade area - export control ID for free trade area - export control ID for free trade area - export control

003

001

002

003

001 002 003

0 1

1 2

Seite 7

MM inbound invoice

E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDK29 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1 E1EDKT1

FREIH EWRCO EWRCO USC05 JAP05 ALANX ALANA LASTA LASTG ALSCH ALSRE LADEO TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TSSPRAS

ID for free trade area - export control ID: European Economic Zone (rel. for export control) ID: European Economic Zone (rel. for export control) SED: Four-digit country code (schedule C code) Country name Alternative country key Alternative country key Alternative country key Alternative country key Alternative country key

3 X

Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Language key Line of text IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC qualifer organization IDOC organization IDOC qualifer organization Item number Action code for the item Action code for the item Action code for the item Action code for the item Action code for the item

001 002 003 004 005 006 PMD BB1 BB2 BB3 BB4 BB5 BB6

E1EDKT2 TDLINE E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 E1EDK14 QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF ORGID QUALF POSEX ACTION ACTION ACTION ACTION ACTION

001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 011

E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01

001 002 003 004

Seite 8

MM inbound invoice

E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP01 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02 E1EDP02

ACTION PSTYP PSTYP PSTYP PSTYP PSTYP PSTYP KZABS KZABS MENGE MENEE BMNG2 PMENE ABFTZ VPREI PEINH NETWR ANETW SKFBP NTGEW GEWEI EINKZ EINKZ CURCY PREIS MATKL UEPOS GRKOR EVERS BPUMN BPUMZ QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF BELNR QUALF BELNR

Action code for the item Item category Item category Item category Item category Item category Item category Indicator for order acknowledgment requirement Indicator for order acknowledgment requirement Quantity Unit of measure Quantity in price unit Price unit of measure Agreed cumulative quantity Price (net) Condition pricing unit, ANSI X.12 length Item value (net) Absolute net value of item Amount qualifying for cash discount Net weight Weight unit Flag: More than one schedule line for the item Flag: More than one schedule line for the item Currency Gross price IDOC material class Higher-level item in BOM structures Delivery group (items delivered together) Shipping instructions Character field of length 6 Character field of length 6 IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC qualifier reference document IDOC document number IDOC qualifier reference document IDOC document number

005 0 1 2 3 5 X

001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 001

Seite 9

MM inbound invoice

ZEILE QUALF BELNR E1EDP02 ZEILE E1EDP02 DATUM E1EDP02 UZEIT E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP03 E1EDP19 E1EDP19 E1EDP19 E1EDP19 E1EDP19 E1EDP19 E1EDP19 E1EDP19 E1EDP19 E1EDP19 IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT IDDAT DATUM UZEIT QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF QUALF IDTNR QUALF IDTNR IDTNR QUALF IDTNR QUALF

Item number IDOC qualifier reference document IDOC document number Item number IDOC: Date IDOC: Time Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Qualifier for IDOC date segment Date Time IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC object identification such as material no.,customer IDOC material ID IDOC object identification such as material no.,customer IDOC material ID IDOC material ID IDOC object identification such as material no.,customer IDOC material ID IDOC object identification such as material no.,customer

021

001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030

001 002 003 004 005 006 007 010 011 001

002 003

Seite 10

MM inbound invoice

IDTNR E1EDP19 KTEXT E1EDP26 E1EDP26 E1EDP26 E1EDP26 E1EDP26 E1EDP26 E1EDP26 E1EDP26 QUALF QUALF QUALF QUALF QUALF QUALF QUALF BETRG QUALF QUALF QUALF PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARVW PARTN LIFNR NAME1 NAME2 NAME3 NAME4 STRAS STRS2 PFACH ORT01 COUNC PSTLZ PSTL2 LAND1 ABLAD PERNR PARNR TELF1 TELF2 TELBX TELFX TELTX TELX1 SPRAS ANRED

IDOC material ID IDOC short text Qualifier amount Qualifier amount Qualifier amount Qualifier amount Qualifier amount Qualifier amount Qualifier amount Overall value in totals segment for shipping notification Qualifier amount Qualifier amount Qualifier amount Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner function (e.g. sold-to party, ship-to party, ...) Partner number Vendor number at customer location Name 1 Name 2 Name 3 Name 4 Street and house number 1 Street and house number 2 PO box City County code Postal code Postal code of PO box Country key Unloading point Contact person's personnel number Contact person's number (not personnel number) 1st telephone number of contact person 2nd telephone number of contact person Telebox number Fax number Teletex number Telex number Language key Title 001 002 003 004 005 006 007 002 003 005 AG LF WE RE SP RG EK ZM VR CC BE PA BA BB RS ME

E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1

Seite 11

MM inbound invoice

E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDPA1 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP05 E1EDP04 E1EDP04 E1EDP04 E1EDP04

ORT02 HAUSN STOCK REGIO PARGE ISOAL ISONU FCODE IHREZ BNAME PAORG ORGTX PAGRU ALCKZ ALCKZ KSCHL KOTXT BETRG KPERC KRATE UPRBS MEAUN KOBTR MENGE PREIS MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MSATZ MWSKZ MWSKZ MWSKZ MWSKZ

District House number Floor Region Partner's sex Country ISO code Country ISO code Company key (France) Your reference (partner's) IDOC user name IDOC organization code IDOC organization code IDOC group code Surcharge or discount indicator Surcharge or discount indicator Condition type (coded) Condition text Fixed surcharge/discount on total gross Condition percentage rate Condition record per unit Condition pricing unit, ANSI X.12 length Unit of measurement IDOC Condition end amount Price scale quantity (SPEC2000) Price by unit of measure (SPEC2000) VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT rate VAT indicator VAT indicator VAT indicator VAT indicator + -

001 002 003 004 005 TXC TXL TXS VAT 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020

001 002 003 004

Seite 12

MM inbound invoice

E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP04 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28 E1EDP28

MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MWSKZ MSATZ MWSBT TXJCD EXNUM EXPOS STAWN EXPRF EXART HERKL HERKR HERTA HERTI STXT1 STXT2 STXT3 STXT4 STXT5 STXT6 STXT7 BEMAS PREFE PREFE PREFE PREFE PREFE PREFE BOLNR TRATY TRAID BRULO NETLO VEMEH

VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT indicator VAT rate Value added tax amount Jurisdiction for tax calculation - tax jurisdiction code Export data number Internal item number for export data Commodity code Export/import procedure Business transaction type Country of origin of material Region of origin Depart.country (country from which the goods are sent) Char 15

005 TXC TXL TXS VAT 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020

Preference ID in export/import Preference ID in export/import Preference ID in export/import Preference ID in export/import Preference ID in export/import Preference ID in export/import Bill of lading Transportation category Means of transport ID Total weight Net weight Field length of 3 bytes Hierarchy number Hierarchical parent ID

A B C D E F

E1EDP08 HLNUM E1EDP08 PARENT

Seite 13

MM inbound invoice

E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDP08 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1 E1EDPT1

LEVEL EXIDV VENUM VEMEH PCKAR PCKNR ANZAR VBELN POSNR BTGEW NTGEW TARAG GEWEI BTVOL NTVOL TAVOL VOLEH LAENG BREIT HOEHE MEABM MEINS VSTEL LSTEL PKNRS TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TDID TSSPRAS

Pack/subpack level ID External shipping unit ID Shipping unit number Field length of 3 bytes Packing type Customer number of shipping unit Number of products per shipping unit Delivery Delivery item Total weight Net weight Tare weight of shipping unit Weight unit Total volume of shipping unit Loading volume of shipping unit Tare volume of shipping unit Volume unit Length Width Height Unit for length/width/height Base unit of measure Shipping point Loading point Shipment number key for VDA/Odette Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Text ID Language key Line of text Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification 001 002 003 004 005 006 007 008 009 010 011 012 013 001 002 003 004 005 006 PMD BB1 BB2 BB3 BB4 BB5 BB6

E1EDPT2 TDLINE E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 SUMID SUMID SUMID SUMID SUMID SUMID SUMID SUMID SUMID SUMID SUMID SUMID SUMID

Seite 14

MM inbound invoice

E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01 E1EDS01

SUMID SUMID SUMID SUMID SUMID SUMID SUMID SUMME SUMID SUMID SUMID E1EDS01 SUNIT E1EDS01 WAERQ E1EDS01 WAERQ

Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Overall value in totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Qualifier for totals segment for shipping notification Total value unit for totals segment in the shipping notif. Currency Currency

014 015 016 017 018 019 020 010 011 012

Seite 15

MM inbound invoice

Qualifier description Initial: This field is not used in the message No particular action required Reverse entire document Changes in document header Changes in one or more items Changes in header and items Yes No

SAP table SAP field Usage N N N N N N N N O N N N N N N N N N N N N N N N N N O N O N N N N N N N N N N O N O O O N N N N

BKPF

WAERS

Sold-to party Vendor Ship-to party Bill-to party Carrier Payer Buyer Responsible employee Representative SPEC2000 customer code Beneficiary Partner for debit memo/direct debit/bank collection Bank sold-to party Bank beneficiary/partner for debit memo Invoicing party Declarant BSEG LIFNR

Seite 16

MM inbound invoice

N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N Customer purchase order Supplier order Customer inquiry Supplier quotation Customer contract number Supplier contract number Collective number for quotations Last purchase order number (SPEC2000 Acknowl.) Invoice number Internal number (document) Referenced document number Delivery number Internal PO number Accounting document Billing document number used by presenter of invoice Number of preceding document Assignment number Customer order number POR number Invoice list number ID for cost assignment BKPF Invoice number Billing document number used by presenter of invoice XBLNR N N N N N N N N N N N N N N N N N N N N N O N N

Seite 17

MM inbound invoice

N N N Delivery date (supplier) Requested delivery date (customer) Closing date for applications Deadline for submission of quotations Quotation/inquiry valid from Binding period for a quotation (valid to) Reconciliation date for agreed cumulative quantity First firm zone Second firm zone Shipping date Date IDOC created Document date Quotation date (supplier) Inquiry date (customer) Invoice posting date (Invoice tax point date) Invoice date Payment date Bill of exchange date Start of validity for outline agreement or inquiry End of validity for outline agreement or inquiry Billing date for invoice list Purchase order date Pricing date Fixed value date Created on Billing date for billing index and printout Date on which services rendered Due date Sales order date Goods receipt date Document date Invoice date Fixed value date Billing date for billing index and printout BKFP BLDAT N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N O N N O N N N N O O N N N N N N N N N N

BSEG

ZFBDT

ID: Increase ID: Reduction BSEG BSEG SGTXT WRBTR

VAT indicator 1 VAT indicator 2 VAT indicator 3 VAT indicator 4 VAT indicator 5

Seite 18

MM inbound invoice

County sales tax (SPEC2000) Local sales tax (SPEC2000) State sales tax (SPEC2000) Value-added tax (SPEC2000) VAT indicator 6 VAT indicator 7 VAT indicator 8 VAT indicator 9 VAT indicator 10 VAT indicator 11 VAT indicator 12 VAT indicator 13 VAT indicator 14 VAT indicator 15 VAT indicator 16 VAT indicator 17 VAT indicator 18 VAT indicator 19 VAT indicator 20

N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N

VAT indicator 1 VAT indicator 2 VAT indicator 3 VAT indicator 4 VAT indicator 5 County sales tax (SPEC2000) Local sales tax (SPEC2000) State sales tax (SPEC2000) Value-added tax (SPEC2000) VAT indicator 6 VAT indicator 7 VAT indicator 8 VAT indicator 9 VAT indicator 10 VAT indicator 11 VAT indicator 12 VAT indicator 13 VAT indicator 14 VAT indicator 15 VAT indicator 16 VAT indicator 17 VAT indicator 18 VAT indicator 19 VAT indicator 20

INCOTERMS part 1 INCOTERMS part 2

Payment term 1 Payment term 2

Seite 19

MM inbound invoice

Payment term 3

Payment term 1 BSEG BSEG Payment term 2 BSEG BSEG Payment term 3 BSEG ZBD3T ZBD2T ZBD2P ZBD1T ZBD1P

N N N N O O N O O N O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N

Document currency Local currency Statistics currency

Goods do not cross the border in a container Goods cross the border in a container

Yes No No free trading zone ASEAN EFTA

Seite 20

MM inbound invoice

NAFTA Yes No

N N N N N N N N N N N N N N N N N N N N N N N N N N N

Purchase order header Purchase order memos Sales order header text Sales order item text Bill header text Bill item text Reason for payment Rediscountable message Line 1 Rediscountable message Line 2 Rediscountable message Line 3 Rediscountable message Line 4 Rediscountable message Line 5 Rediscountable message Line 6

Business area Sales area Delivering company Plant in charge Delivering plant Division Distribution Channel Sales organization Purchasing group Sales group Company code Order type Ordering method Purchasing organization Billing type Sales office Unloading point BKPF Company code BUKRS

N N N N N N N N N N N N N N N N N O N N N N N N N

Initial: This field is not used in the message Item added Item changed Item cancelled Item not changed

Seite 21

MM inbound invoice

Item locked This field is not used Normal Provision of material Consignment Subcontracting Leg Yes No BSEG BSEG MENGE MEINS

BSEG BSEG

WRBTR WRBTR

Yes No

N N N N N N N N N O O N N N N N O O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N O

Customer purchase order Supplier order Customer inquiry Supplier quotation Customer contract number Supplier contract number Collective number for quotations Last purchase order number (SPEC2000 Acknowl.) Invoice number Internal number (document) Referenced document number Delivery number Internal PO number Accounting document Billing document number used by presenter of invoice Number of preceding document Assignment number Customer order number POR number Invoice list number ID for cost assignment Customer purchase order RM08R EBELN

Seite 22

MM inbound invoice

RM08R ID for cost assignment

EBELP

O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N O O N O N

Delivery date (supplier) Requested delivery date (customer) Closing date for applications Deadline for submission of quotations Quotation/inquiry valid from Binding period for a quotation (valid to) Reconciliation date for agreed cumulative quantity First firm zone Second firm zone Shipping date Date IDOC created Document date Quotation date (supplier) Inquiry date (customer) Invoice posting date (Invoice tax point date) Invoice date Payment date Bill of exchange date Start of validity for outline agreement or inquiry End of validity for outline agreement or inquiry Billing date for invoice list Purchase order date Pricing date Fixed value date Created on Billing date for billing index and printout Date on which services rendered Due date Sales order date Goods receipt date

Material number used by customer Material number used by supplier International Article number(EAN) Part number (SPEC2000) Interchanged part number (SPEC2000) Pricing reference material Commodity Code Batch number Country of origin of material Material number used by customer BSEG BSEG Material number used by supplier BSEG International Article number(EAN) MATNR MATNR DMATN

Seite 23

MM inbound invoice

BSEG

EANNR

O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N

Gross price Gross value Net value Amount qualifying for cash discount Absolute net value of item Net price Cash discount amount Gross value Net value Absolute net value of item Sold-to party Vendor Ship-to party Bill-to party Carrier Payer Buyer Responsible employee Representative SPEC2000 customer code Beneficiary Partner for debit memo/direct debit/bank collection Bank sold-to party Bank beneficiary/partner for debit memo Invoicing party Declarant

Seite 24

MM inbound invoice

N N N N N N N N N N N N N ID: Increase ID: Reduction BSEG BSEG SGTXT WRBTR N N N O O N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N O N N N

VAT indicator 1 VAT indicator 2 VAT indicator 3 VAT indicator 4 VAT indicator 5 County sales tax (SPEC2000) Local sales tax (SPEC2000) State sales tax (SPEC2000) Value-added tax (SPEC2000) VAT indicator 6 VAT indicator 7 VAT indicator 8 VAT indicator 9 VAT indicator 10 VAT indicator 11 VAT indicator 12 VAT indicator 13 VAT indicator 14 VAT indicator 15 VAT indicator 16 VAT indicator 17 VAT indicator 18 VAT indicator 19 VAT indicator 20

VAT indicator 1 VAT indicator 2 VAT indicator 3 VAT indicator 4

BSEG

MWSKZ

Seite 25

MM inbound invoice

VAT indicator 5 County sales tax (SPEC2000) Local sales tax (SPEC2000) State sales tax (SPEC2000) Value-added tax (SPEC2000) VAT indicator 6 VAT indicator 7 VAT indicator 8 VAT indicator 9 VAT indicator 10 VAT indicator 11 VAT indicator 12 VAT indicator 13 VAT indicator 14 VAT indicator 15 VAT indicator 16 VAT indicator 17 VAT indicator 18 VAT indicator 19 VAT indicator 20

N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N

Not checked Checked - Price influenced Generally allowed Generally not allowed Authorized for preference: set manually Authorized for preference: component of mixed origins

Seite 26

MM inbound invoice

N N N N N N N N N N N N N N N N N N N N N N N N N Purchase order header Purchase order memos Sales order header text Sales order item text Bill header text Bill item text Reason for payment Rediscountable message Line 1 Rediscountable message Line 2 Rediscountable message Line 3 Rediscountable message Line 4 Rediscountable message Line 5 Rediscountable message Line 6 N N N N N N N N N N N N N N N Number of items (Purchase order count in SPEC2000) Net document value Gross document value SPEC2000 Total control quantity (total of all quantities) Sales tax total Order values Sales tax Invoice values Target value for outline agreement Net invoice value Billed value Value qualifying for discount Cash discount amount 1 N N N N N N N N N N N N N

Seite 27

MM inbound invoice

Cash discount amount 2 Net values with sales tax ID Billed values with sales tax ID Total item net value Invoice list total Net value invoice list Total discounts/surcharges Net invoice value Billed value Value qualifying for discount

N N N N N N N N N N N N N N

Seite 28

MM inbound invoice

Further Comments

Used with PARTN,LIFNR,NAME1 to determine creditor number and company code Used with LIFNR or NAME1 to determine company code

Used with PARTN,LIFNR,NAME1 to determine creditor and company code Used with PARVW, LIFNR, NAME1 to determine creditor and company code Used with PARVW, PARTN, NAME1 to determine creditor and company code Used with PARVW,PARTN, LIFNR to determine creditor and company code

Seite 29

MM inbound invoice

Maximum length 20 Used by MM and FI Used by FI only

Seite 30

MM inbound invoice

Used by FI only Used by FI only

Maximum length 13

Seite 31

MM inbound invoice

Segment not currently used in program

Seite 32

MM inbound invoice

Maximum length 3 Maximum length 6 Maximum length 3 Maximum length 6 Maximum length 3 Maximum length 6 Maximum length 3

Uses currency found in E1EDK01

Used with BRNUM,ACNUM to determine partner number Used with BCOUN,ACNUM to determine partner number

Used with BCOUN,BRNUM to determine partner number

Segment not currently used in program

Seite 33

MM inbound invoice

Code currently commented out in program

Maximum length 5, only if bukrs not previously found

Seite 34

MM inbound invoice

Maximum length 12 Used in table T006 as lookup field Maximum length 12

Maximum length 14 Maximum length 13, MM only, if ANETW blank Maximum length 14, MM only Maximum length 13

MM only MM only

Seite 35

MM inbound invoice

MM only FI only FI only

Code currently commented out in program

FI only FI only

Seite 36

MM inbound invoice

FI only

Maximum length 13

Seite 37

MM inbound invoice

Used by FI only

Maximum length 13

Maximum length 3

Seite 38

MM inbound invoice

Maximum length 13

Segment currently not used in program

Segment currently not used in program

Seite 39

MM inbound invoice

Code commented out in program

Seite 40

MM inbound invoice

Maximum length 13

Seite 41

You might also like