SAP ERP 6.0
Data architecture for SAP ERP 6.0 and SAP R/3 systems. Defines field mappings for FI-AR master data (KNA1, KNB1), open items (BSID/BSAD), and payment documents via RFC/IDoc interfaces.
Fields
Inbound
Aufträge
| Field | Table | Description | Mandatory |
|---|
ARKTX | VBAK/VBAP | Short Text for Sales Order Item | Nein |
AUART | VBAK/VBAP | Sales Document Type | Ja |
AUDAT | VBAK/VBAP | Document Date | Nein |
KUNNR | VBAK/VBAP | Sold-To Party | Ja |
KWMENG | VBAK/VBAP | Cumulative Order Quantity | Ja |
MATNR | VBAK/VBAP | Material Number | Ja |
NETWR | VBAK/VBAP | Net Value of the Sales Order | Nein |
POSNR | VBAK/VBAP | Item number of the SD document | Ja |
SPART | VBAK/VBAP | Division | Nein |
VBELN | VBAK/VBAP | Sales and Distribution Document Number | Ja |
VKORG | VBAK/VBAP | Sales Organization | Ja |
VRKME | VBAK/VBAP | Sales Unit | Nein |
VTWEG | VBAK/VBAP | Distribution Channel | Nein |
WAERK | VBAK/VBAP | SD Document Currency | Nein |
Bewegungsdaten
| Field | Table | Description | Mandatory |
|---|
AUGBL | BSID/BSAD | Clearing Document Number | Bedingt |
AUGDT | BSID/BSAD | Day of Clearing | Bedingt |
AUGGJ | BSID/BSAD | Fiscal Year of Clearing | Bedingt |
BELNR | BSID/BSAD | Document Number | Ja |
BLART | BSID/BSAD | Document Type or Posting Key | Ja |
BLDAT | BSID/BSAD | Document Date | Ja |
BUKRS | BSID/BSAD | Company Code | Ja |
BUZEI | BSID/BSAD | Number of Line Item | Ja |
CPUDT | BSID/BSAD | Entered on Date | Ja |
DMSHB | BSID/BSAD | Amount in LC with +/- Signs | Ja |
DUEDATE | BSID/BSAD | Net due date | Ja |
GJAHR | BSID/BSAD | Fiscal Year | Ja |
HWAER | BSID/BSAD | Local Currency | Ja |
KUNNR | BSID/BSAD | Customer Number | Ja |
MANSP | BSID/BSAD | Dunning block | Nein |
MANST | BSID/BSAD | Dunning level | Nein |
NAME | BSID/BSAD | Customer Name | Nein |
SGTXT | BSID/BSAD | Text | Nein |
VKGRP | BSID/BSAD | Sales group | Nein |
VKORG | BSID/BSAD | Sales region | Nein |
XBLNR | BSID/BSAD | Reference | Nein |
XREF1 | BSID/BSAD | Reference field 1 | Nein |
XREF2 | BSID/BSAD | Reference field 2 | Nein |
XREF3 | BSID/BSAD | Reference field 3 | Nein |
ZTERM | BSID/BSAD | Payment Terms | Nein |
ZUONR | BSID/BSAD | Assignment | Nein |
Stammdaten
| Field | Table | Description | Mandatory |
|---|
AKONT | KNA1 | Reconciliation Account | Nein |
ANRED | KNA1 | Title | Nein |
BUKRS | KNA1 | Company Code | Nein |
CTLPC | KNA1 | Risk Category | Nein |
ERDAT | KNA1 | External Created at field | Nein |
INTAD | KNA1 | Clerk's Internet (Email) | Nein |
KDGRP | KNA1 | Customer Group | Nein |
KLIMK | KNA1 | Full limit | Nein |
KUNNR | KNA1 | Customer, Business Partner | Ja |
LAND1 | KNA1 | Country Key (ISO) | Nein |
NAME1 | KNA1 | Name 1 | Nein |
NAME2 | KNA1 | Name 2 | Nein |
NAME3 | KNA1 | Name 3 | Nein |
NAME4 | KNA1 | Name 4 | Nein |
ORT01 | KNA1 | City | Nein |
PSTLZ | KNA1 | Postal Code | Nein |
STCEG | KNA1 | VAT Registration Number | Nein |
STRAS | KNA1 | House number and street | Nein |
TELF1 | KNA1 | First telephone number | Nein |
TELF2 | KNA1 | Second telephone number | Nein |
VKGRP | KNA1 | Salesorganization | Nein |
VLIBB | KNA1 | Amount insured | Nein |
VRSNR | KNA1 | Policy Number | Nein |
ZWELS | KNA1 | Payment method | Nein |