Table of Settings for Mapping in EDI Subsystem
This table shows which data from the transmission has to be transmitted by the EDI subsystem to the various segments and fields of the IDoc GSVERF01.
Where the content and significance of an IDoc field is qualified by an "ID" or "Qualifier", the field plus qualifier should always be regarded as a unit.
For the purpose of the example, the table uses the record types, fields and descriptions of a common German standard, VDA 4908. Other standards, like the ANSI 820, work in a similar manner. You should regard the information as an example, and adapt it to your situation.
Record type / Field from VDA 4908 |
VDA description |
Target segment and field in GSVERF01 |
IDoc Segment/Qualifier lD or Identification |
Comment |
821 |
821 |
821 |
821 |
821 |
821 // 05 |
Old transmission number |
E1EDK02-BELNR |
E1EDK02-QUALF = 077 |
Predecessor of current transmission, no function directly based on this at present. |
821 // 06 |
New transmission number |
E1EDK02-BELNR |
E1EDK02-QUALF = 074 |
Per EDI partner and external transmission number, the system checks to see that the transmission number has not been used twice.See also: the field help in the transaction under
|
821 // 07 |
Transmission date |
E1EDK02-DATUM |
E1EDK02-QUALF = 074 |
The date entries that correspond to the transmission numbers. Transmission numbers and date are stored in the same segment E1EDK02, and qualifiers 074 and 077 respectively. |
821 // 04 |
Vendor number |
E1EDKA1-PARTN |
E1EDKA1-PARVW = LF |
The vendor number that refers to you in the self-billing document creator's system. It is only possible to determine the sold-to party if an entry has been made in this field. |
822 |
822 |
822 |
822 |
822 |
822 // 03 |
Self-billing document number |
E1EDK02-BELNR |
E1EDK02-QUALF = 073 |
The number assigned to the self-billing document by its creator. For test purposes, if you are directly linking MM/SD, the MM document number is written in E1EDK 01 -BELNR (without qualifier logic). |
822 // 05 |
Payment-due date |
E1EDK03-DATUM |
E1EDK03-IDDAT = 028 |
The significance of this date can be agreed between partners. Here it is shown for information purposes only. For test purposes, if you are directly linking MM/SD, the baseline payment date of the settlement document (self-billing document) is used here. |
822 // 12 |
Currency |
E1EDK01-CURCY |
No qualifier / ID |
The currency of the sent data must be the same as the currency used internally for the initial transaction. Exception: EURO. For Euro as currency, one partner can use Euros and the other use a participating currency. |
822 // 14 |
Self-billing type key 0 convert to → 1 convert to → 2 convert to → |
E1EDK01-ACTION 005 006 007 |
No qualifier / ID |
The self-billing type key and its ACTION code controls further processing, along with the posting key 824. See Table of ACTION Codes to Control Self-Billing/Retro-Billing . |
822 // 16 |
Accounts payable number (BMW) |
E1EDK02-BELNR |
E1EDK02-QUALF = 076 |
Special reference number for inbound payments at BMW |
823 |
823 |
823 |
823 |
823 |
823 // 03 |
Delivery note number |
E1EDK02-BELNR |
E1EDK02-QUALF = 012 (general delivery note) 061 (special delivery note) 062 (ESA order) 063 (ext. delivery note number (ESA)) 081 (collective daily delivery note for sequenced JIT calls) 082 (SD summarized JIT calls) |
This number serves mainly to determine the transaction in the recipient system. Which sort of transaction is used for a certain sold-to party can be set in the
See below for more information on sales document determination. |
823 // 04 |
Customer plant |
E1EDKA1-PARTN |
E1EDKA1-PARVW = WK |
Customer plant to which was delivered. This is the partner description used in Determination of EDI Sold-To Party . |
823 // 13 |
Unloading point |
E1EDKA1-PARTN |
E1EDKA1-PARVW = AB |
Unloading point in customer plant. This is the unloading point used in
|
824 |
824 |
824 |
824 |
824 |
824 // 03 |
Transaction/posting key 01 (Goods receipt) → 02 (Correction goods receipt) → 03 (Return delivery) → 04 (Consignment material) → 05 (Damages in transport) → 99 (Misc.) → "indirect" |
E1EDK01-ACTION 091 092 093 094 095 099 096 |
No qualifier / ID |
ACTION codes from 822 // 12 and 824 // 03 control the type of processing and automatic posting. See Table of ACTION Codes to Control Self-Billing/Retro-Billing . Qualifier 096 triggers a purely value-based clearing invoice. |
824 // 04 |
Customer's supplier reference number |
E1EDP19-IDTNR |
E1EDP19-QUALF = 001 Note: If qualifier 002 were used, the system would identify the material number at supplier (as used in that SAP system.) |
Number of the material as used in the system of the creator of the goods issue (of the customer from the point of view of the supplier). The customer material must be maintained in the corresponding order or SD scheduling agreements, and be contained in the delivery. |
824 // 05 |
Delivery quantity |
E1EDP01-MENGE |
No qualifier / ID |
Separate decimals with points. See below for details. |
824 // 06 |
Unit of measure |
E1EDP01-MENEE |
No qualifier / ID |
It must be possible to use this ISO-Code to find a unit of measure in the SAP system units of measure table. The unit of measure must either be the base or the sales unit of measure for the material. |
824 // 09 |
Total price / value |
E1EDP26-BETRG |
E1EDP26-QUALF = 003 |
Net value of delivery note item (with +/- sign according to +/- sign key.) The net item value is the only transmitted value that is included in the process. |
824 // 10 |
+/- sign key _: positive (or) 1: positive 2: negative |
The total price from 824 // 09 must have the correct +/- sign from 824 // 10. See also The +/- Sign in SD Self-Billing . |
||
824 // 11 |
Percentage cash discount |
This information cannot at present be included. |
||
824 // 12 |
Cash discount amount |
E1EDP26-BETRG |
E1EDP26-QUALF = 007 |
Net value of delivery note item (with +/- sign according to +/- sign key.) |
824 // 14 |
Sales tax amount |
E1EDP04-MWSBT |
Tax value of the item, used together with the net value to calculate the gross value in the Reporting Tool. |
|
- |
Percentage sales tax |
E1EDP04-MSATZ |
825 |
825 |
825 |
825 |
825 |
|---|---|---|---|---|
(825 // 03) |
(Key for surcharge/reduction) |
E1ED P 05-KSCHL(or. E1ED K 05, if at header level) |
Type of transmitted condition (4-figure field) Technical information: is stored in VSBCON-KONART_T. |
|
825 // 05 |
+/- sign key 1 = positive 2 = negative |
E1EDP05-ALCKZ(or E1EDK05) |
Must be converted to +/- sign. Technical information: is stored in VSBCON-SIGN_T. |
|
825 // 04 |
Surcharge/reduction amount |
E1EDP05-KOBETR(or E1EDK05) |
Condition value (total value of item for corresponding condition type.) Technical information: is stored in VSBCON-KWERT_T (in transaction currency) or in VSBCON-KWERTRL_T (in displayed currency). |
|
E1EDP05-KTEXT (or E1EDK05) |
Text for condition type. Technical information: is stored in VSBCON-KTEXT_T. |
|||
E1EDP05-KRATE(or E1EDK05) |
Condition amount. Technical information: is stored in VSBCON-KBETR_T (in transaction currency) or in VSBCON-KBETRRL-T (in displayed currency). |
|||
E1EDP05-KPERC(or E1EDK05) |
Percentage condition, alternative to condition amount. Technical information: is stored in VSBCON-KPERC_T. |
|||
E1EDP05-UPRBS (or E1EDK05) |
Condition price unit (Example: $100 / 10 pieces, where 10 is the price unit.) Technical information: is stored in VSBCON-KPEIN_T. |
|||
E1EDP05-MEAUN (or E1EDK05) |
Unit of measure for transmitted condition amount and for price unit. Technical information: is stored in VSBCON-KMEISO_T. |
Decimal points
If values with decimal places are transmitted to an IDoc segment field, they must be separated by a point. For example:
+/- sign |
Transmitted value |
In IDoc Segment Field |
positive |
100,24 |
100.24 |
negative |
50,78 |
-50.78 |