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

FieldTableDescriptionMandatory
ARKTXVBAK/VBAPShort Text for Sales Order ItemNein
AUARTVBAK/VBAPSales Document TypeJa
AUDATVBAK/VBAPDocument DateNein
KUNNRVBAK/VBAPSold-To PartyJa
KWMENGVBAK/VBAPCumulative Order QuantityJa
MATNRVBAK/VBAPMaterial NumberJa
NETWRVBAK/VBAPNet Value of the Sales OrderNein
POSNRVBAK/VBAPItem number of the SD documentJa
SPARTVBAK/VBAPDivisionNein
VBELNVBAK/VBAPSales and Distribution Document NumberJa
VKORGVBAK/VBAPSales OrganizationJa
VRKMEVBAK/VBAPSales UnitNein
VTWEGVBAK/VBAPDistribution ChannelNein
WAERKVBAK/VBAPSD Document CurrencyNein

Bewegungsdaten

FieldTableDescriptionMandatory
AUGBLBSID/BSADClearing Document NumberBedingt
AUGDTBSID/BSADDay of ClearingBedingt
AUGGJBSID/BSADFiscal Year of ClearingBedingt
BELNRBSID/BSADDocument NumberJa
BLARTBSID/BSADDocument Type or Posting KeyJa
BLDATBSID/BSADDocument DateJa
BUKRSBSID/BSADCompany CodeJa
BUZEIBSID/BSADNumber of Line ItemJa
CPUDTBSID/BSADEntered on DateJa
DMSHBBSID/BSADAmount in LC with +/- SignsJa
DUEDATEBSID/BSADNet due dateJa
GJAHRBSID/BSADFiscal YearJa
HWAERBSID/BSADLocal CurrencyJa
KUNNRBSID/BSADCustomer NumberJa
MANSPBSID/BSADDunning blockNein
MANSTBSID/BSADDunning levelNein
NAMEBSID/BSADCustomer NameNein
SGTXTBSID/BSADTextNein
VKGRPBSID/BSADSales groupNein
VKORGBSID/BSADSales regionNein
XBLNRBSID/BSADReferenceNein
XREF1BSID/BSADReference field 1Nein
XREF2BSID/BSADReference field 2Nein
XREF3BSID/BSADReference field 3Nein
ZTERMBSID/BSADPayment TermsNein
ZUONRBSID/BSADAssignmentNein

Stammdaten

FieldTableDescriptionMandatory
AKONTKNA1Reconciliation AccountNein
ANREDKNA1TitleNein
BUKRSKNA1Company CodeNein
CTLPCKNA1Risk CategoryNein
ERDATKNA1External Created at fieldNein
INTADKNA1Clerk's Internet (Email)Nein
KDGRPKNA1Customer GroupNein
KLIMKKNA1Full limitNein
KUNNRKNA1Customer, Business PartnerJa
LAND1KNA1Country Key (ISO)Nein
NAME1KNA1Name 1Nein
NAME2KNA1Name 2Nein
NAME3KNA1Name 3Nein
NAME4KNA1Name 4Nein
ORT01KNA1CityNein
PSTLZKNA1Postal CodeNein
STCEGKNA1VAT Registration NumberNein
STRASKNA1House number and streetNein
TELF1KNA1First telephone numberNein
TELF2KNA1Second telephone numberNein
VKGRPKNA1SalesorganizationNein
VLIBBKNA1Amount insuredNein
VRSNRKNA1Policy NumberNein
ZWELSKNA1Payment methodNein