sap tables

71
TABLE DEFINITIONS FOR AUDIT ANALYSIS - BKPF Field Data element Data Type Length Decimal MANDT MANDT CLNT 3 0 BUKRS BUKRS CHAR 4 0 BELNR BELNR_D CHAR 10 0 GJAHR GJAHR NUMC 4 0 BLART BLART CHAR 2 0 BLDAT BLDAT DATS 8 0 BUDAT BUDAT DATS 8 0 MONAT MONAT NUMC 2 0 CPUDT CPUDT DATS 8 0 CPUTM CPUTM TIMS 6 0 AEDAT AEDAT_BKPF DATS 8 0 UPDDT UPDDT DATS 8 0 WWERT WWERT_D DATS 8 0 USNAM USNAM CHAR 12 0 TCODE TCODE CHAR 20 0 BVORG BVORG CHAR 16 0 XBLNR XBLNR1 CHAR 16 0 DBBLG DBBLG CHAR 10 0 STBLG STBLG CHAR 10 0 STJAH STJAH NUMC 4 0 BKTXT BKTXT CHAR 25 0 WAERS WAERS CUKY 5 0 KURSF KURSF DEC 9 5 KZWRS KZWRS CUKY 5 0 KZKRS KZKRS DEC 9 5 BSTAT BSTAT_D CHAR 1 0 XNETB XNETB CHAR 1 0 FRATH FRATH CURR 13 2 XRUEB XRUEB CHAR 1 0 GLVOR GLVOR CHAR 4 0 GRPID GRPID_BKPF CHAR 12 0 DOKID DOKID_BKPF CHAR 40 0 ARCID EXTID_BKPF CHAR 10 0 ARCID EXTID_BKPF CHAR 10 0 IBLAR IBLAR CHAR 2 0 AWTYP AWTYP CHAR 5 0 AWKEY AWKEY CHAR 20 0 FIKRS FIKRS CHAR 4 0 HWAER HWAER CUKY 5 0 HWAE2 HWAE2 CUKY 5 0 HWAE3 HWAE3 CUKY 5 0 KURS2 KURS2 DEC 9 5 KURS3 KURS3 DEC 9 5 BASW2 CURSR CHAR 1 0 BASW3 CURSR CHAR 1 0 UMRD2 UMRD2 CHAR 1 0 UMRD3 UMRD3 CHAR 1 0

Upload: jason-dan-moore

Post on 14-Dec-2014

200 views

Category:

Documents


13 download

TRANSCRIPT

Page 1: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - BKPF

Field Data element Data TypeLength DecimalMANDT MANDT CLNT 3 0BUKRS BUKRS CHAR 4 0BELNR BELNR_D CHAR 10 0GJAHR GJAHR NUMC 4 0BLART BLART CHAR 2 0BLDAT BLDAT DATS 8 0BUDAT BUDAT DATS 8 0MONAT MONAT NUMC 2 0CPUDT CPUDT DATS 8 0CPUTM CPUTM TIMS 6 0AEDAT AEDAT_BKPF DATS 8 0UPDDT UPDDT DATS 8 0WWERT WWERT_D DATS 8 0USNAM USNAM CHAR 12 0TCODE TCODE CHAR 20 0BVORG BVORG CHAR 16 0XBLNR XBLNR1 CHAR 16 0DBBLG DBBLG CHAR 10 0STBLG STBLG CHAR 10 0STJAH STJAH NUMC 4 0BKTXT BKTXT CHAR 25 0WAERS WAERS CUKY 5 0KURSF KURSF DEC 9 5KZWRS KZWRS CUKY 5 0KZKRS KZKRS DEC 9 5BSTAT BSTAT_D CHAR 1 0XNETB XNETB CHAR 1 0FRATH FRATH CURR 13 2XRUEB XRUEB CHAR 1 0GLVOR GLVOR CHAR 4 0GRPID GRPID_BKPF CHAR 12 0DOKID DOKID_BKPF CHAR 40 0ARCID EXTID_BKPF CHAR 10 0ARCID EXTID_BKPF CHAR 10 0IBLAR IBLAR CHAR 2 0AWTYP AWTYP CHAR 5 0AWKEY AWKEY CHAR 20 0FIKRS FIKRS CHAR 4 0HWAER HWAER CUKY 5 0HWAE2 HWAE2 CUKY 5 0HWAE3 HWAE3 CUKY 5 0KURS2 KURS2 DEC 9 5KURS3 KURS3 DEC 9 5BASW2 CURSR CHAR 1 0BASW3 CURSR CHAR 1 0UMRD2 UMRD2 CHAR 1 0UMRD3 UMRD3 CHAR 1 0

Page 2: SAP Tables

XSTOV XSTOV CHAR 1 0STODT STODT DATS 8 0XMWST XMWST CHAR 1 0CURT2 CURT2 CHAR 2 0CURT3 CURT3 CHAR 2 0KUTY2 KURST CHAR 4 0KUTY3 KURST CHAR 4 0XSNET XSNET CHAR 1 0AUSBK AUSBK CHAR 4 0XUSVR XUSVR_BKPF CHAR 1 0DUEFL DUEFL_BKPF CHAR 1 0AWSYS LOGSYSTEM CHAR 10 0TXKRS TXKRS_BKPF DEC 9 5LOTKZ PSO_LOTKZ CHAR 10 0XWVOF XWVOF CHAR 1 0STGRD STGRD CHAR 2 0PPNAM PPNAM CHAR 12 0BRNCH J_1ABRNCH CHAR 4 0NUMPG J_1ANOPG NUMC 3 0ADISC J_1ADISC CHAR 1 0XREF1_HD XREF1_HD CHAR 20 0XREF2_HD XREF2_HD CHAR 20 0XREVERSALXREVERSAL CHAR 1 0REINDAT REINDAT DATS 8 0RLDNR FAGL_RLDNR CHAR 2 0LDGRP FAGL_LDGRP CHAR 4 0PROPMANO RE_MANDAT CHAR 13 0XBLNR_ALT XBLNR_ALT CHAR 26 0.APPEND ABKPF_PSO STRU 0 0.INCLUDE IBKPF_PSO STRU 0 0.INCLUDE IVBKPF_PSO STRU 0 0PSOTY PSOTY_D CHAR 2 0PSOAK PSOAK CHAR 10 0PSOKS PSOKS CHAR 10 0PSOSG PSOSG CHAR 1 0PSOFN PSOFN CHAR 30 0INTFORM FM_INTFORM CHAR 4 0INTDATE FM_INTDATE DATS 8 0PSOBT PSOBT DATS 8 0PSOZL PSOZL CHAR 1 0PSODT AEDAT DATS 8 0PSOTM PSOTM TIMS 6 0.APPEND ABKPF_UMB STRU 0 0FM_UMART FM_UMART CHAR 1 0.APPEND BKPF_CARD STRU 0 0.INCLUDE FCRD_VBKPF STRU 0 0CCINS CCINS_30F CHAR 4 0CCNUM CCNUM_30F CHAR 25 0.APPEND BKPF_USFED STRU 0 0SSBLK SSBLK CHAR 1 0

Page 3: SAP Tables

BATCH LOTKZ CHAR 10 0SNAME UNAME CHAR 12 0SAMPLED SAMPLED CHAR 1 0EXCLUDE_F EXCLUDE_FLGCHAR 1 0BLIND FM_BLIND CHAR 1 0OFFSET_STAFMFG_OFFSETCHAR 2 0OFFSET_REFFMFG_REFERRDATS 8 0PENRC PENRC CHAR 2 0.APPEND JVBKPF STRU 0 0KNUMV KNUMV CHAR 10 0.APPEND OILBKPF STRU 0 0OINETNUM OIA_NETNUM CHAR 10 0OINJAHR GJAHR NUMC 4 0OININD OIA_NET CHAR 1 0RECHN XRECH CHAR 1 0_______________________________________ _____________________________________________ ______

Page 4: SAP Tables

Short DescriptionClientCompany CodeAccounting Document NumberFiscal YearDocument TypeDocument Date in DocumentPosting Date in the DocumentFiscal PeriodDay On Which Accounting Document Was EnteredTime of EntryDate of the Last Document Change by TransactionDate of the Last Document UpdateTranslation DateUser NameTransaction CodeNumber of Cross-Company Code Posting TransactionReference Document NumberRecurring Entry Document NumberReverse Document NumberReverse document fiscal yearDocument Header TextCurrency KeyExchange rateCurrency Key for the Group CurrencyGroup Currency Exchange RateDocument StatusIndicator: Document posted net ?Unplanned delivery costsIndicator: Document is posted to a previous periodBusiness TransactionBatch Input Session NameDocument Name in the Archive SystemExtract ID Document HeaderExtract ID Document HeaderInternal Document Type for Document ControlReference TransactionReference KeyFinancial Management AreaLocal CurrencyCurrency Key of Second Local CurrencyCurrency Key of Third Local CurrencyExchange Rate for the Second Local CurrencyExchange Rate for the Third Local CurrencySource Currency for Currency TranslationSource Currency for Currency TranslationTranslation Date Type for Second Local CurrencyTranslation Date Type for Third Local Currency

Page 5: SAP Tables

Indicator: Document is flagged for reversalPlanned Date for the Reverse PostingCalculate tax automaticallyCurrency Type of Second Local CurrencyCurrency Type of Third Local CurrencyExchange Rate TypeExchange Rate TypeG/L account amounts entered exclude taxSource Company CodeIndicator: US taxes changed at detail level ?Status of Data Transfer into Subsequent ReleaseLogical SystemExchange Rate for TaxesLot Number for RequestsIndicator: Customer bill of exchange payment before due dateReason for ReversalName of User Who Parked this DocumentBranch NumberNumber of pages of invoiceIndicator: entry represents a discount documentReference Key 1 Internal for Document HeaderReference Key 2 Internal for Document HeaderSpecifies whether doc. is reversal doc. or reversed doc.Invoice Receipt DateLedger in General Ledger AccountingLedger GroupReal Estate Management MandateAlternative Reference NumberIS-PS: BKPF Append Structure for Payment RequestsIS-PS: Include Structure BKPF Payment Request Doc.HeaderIS-PS: Include for Append Parked Payment Request Doc.HeaderDocument category payment requestsReasonRegionReason for reversal - IS-PS requestsIS-PS: File numberInterest FormulaInterest Calc. DatePosting DayActual postingChanged OnLast changed atIS-PS: Append Structure for Transfer Transaction FMITPOType of Payment TransferCredit Card: Append for BKPFCredit Card: Include for Appends for BKPF, VBKPFPayment cards: Card typePayment cards: Card numberAppend structure for US federal governmentPayment Statistical Sampling Block

Page 6: SAP Tables

Lot Number for DocumentsUser NameSampled Invoice by Payment CertificationExcluding/Including IndicatorBudgetary Ledger IndicatorTreasury Offset StatusDate Record Referred to TreasuryReason for late paymentJoint Venture fieldsNumber of the document condition Exchange - netting document numberFiscal YearMovement-based netting indicatorIndicator: post invoice________________________________________________________________________________________________________________________

Page 7: SAP Tables

Column Field Data element Data TypeLength Decimal Short Description7 BUKRS BUKRS CHAR 4 7 0 Company Code

17 LIFNR LIFNR CHAR 10 17 0 Account Number of Vendor or Creditor19 UMSKZ UMSKZ CHAR 1 19 0 Special G/L Indicator27 AUGDT AUGDT DATS 8 ZLSCHZL 0 Clearing Date37 AUGBL AUGBL CHAR 10 #VALUE! 0 Document Number of the Clearing Document59 GJAHR GJAHR NUMC 4 #VALUE! 0 Fiscal Year69 BELNR BELNR_D CHAR 10 #VALUE! 0 Accounting Document Number80 BUDAT BUDAT DATS 8 #VALUE! 0 Posting Date in the Document88 BLDAT BLDAT DATS 8 #VALUE! 0 Document Date in Document

101 WAERS WAERS CUKY 5 #VALUE! 0 Currency Key117 XBLNR XBLNR1 CHAR 16 #VALUE! 0 Reference Document Number119 BLART BLART CHAR 2 #VALUE! 0 Document Type121 MONAT MONAT NUMC 2 #VALUE! 0 Fiscal Period125 SHKZG SHKZG CHAR 1 #VALUE! 0 Debit/Credit Indicator131 MWSKZ MWSKZ CHAR 2 #VALUE! 0 Sales Tax Code144 DMBTR DMBTR CURR 13 #VALUE! 2 Amount in Local Currency157 WRBTR WRBTR CURR 13 #VALUE! 2 Amount in document currency259 SGTXT SGTXT CHAR 50 #VALUE! 0 Item Text313 EBELN EBELN CHAR 10 #VALUE! 0 Purchasing Document Number363 ZTERM DZTERM CHAR 4 #VALUE! 0 Terms of Payment Key408 SKNTO SKNTO CURR 13 #VALUE! 2 Cash discount amount in local currency421 WSKTO WSKTO CURR 13 #VALUE! 2 Cash discount amount in document currency422 ZLSCH DZLSCH CHAR 1 #VALUE! 0 Payment Method423 ZLSPR DZLSPR CHAR 1 #VALUE! 0 Payment Block Key424 ZBFIX DZBFIX CHAR 1 #VALUE! 0 Fixed Payment Terms429 HBKID HBKID CHAR 5 #VALUE! 0 Short Key for a House Bank433 BVTYP BVTYP CHAR 4 #VALUE! 0 Partner Bank Type443 REBZG REBZG CHAR 10 #VALUE! 0 Number of the Invoice the Transaction Belongs to447 REBZJ REBZJ NUMC 4 #VALUE! 0 Fiscal Year of the Relevant Invoice (for Credit Memo)450 REBZZ REBZZ NUMC 3 #VALUE! 0 Line Item in the Relevant Invoice458 ZOLLT DZOLLT CHAR 8 #VALUE! 0 Customs Tariff Number466 ZOLLD DZOLLD DATS 8 #VALUE! 0 Customs Date469 LZBKZ LZBKZ CHAR 3 #VALUE! 0 State Central Bank Indicator472 LANDL LANDL CHAR 3 #VALUE! 0 Supplying Country473 DIEKZ DIEKZ CHAR 1 #VALUE! 0 Service Indicator (Foreign Payment)474 MANSP MANSP CHAR 1 #VALUE! 0 Dunning block475 MSCHL MSCHL CHAR 1 #VALUE! 0 Dunning key483 MADAT MADAT DATS 8 #VALUE! 0 Last dunned on484 MANST MAHNS_D NUMC 1 #VALUE! 0 Dunning level486 MABER MABER CHAR 2 #VALUE! 0 Dunning Area487 XNETB XNETB CHAR 1 #VALUE! 0 Indicator: Document posted net ?488 XANET XANET CHAR 1 #VALUE! 0 Indicator: Down payment in net procedure ?489 XCPDD XCPDD CHAR 1 #VALUE! 0 Indicator: Address and bank data set individually490 XESRD XESRD CHAR 1 #VALUE! 0 Indicator: Is any ISR data set in the document ?491 XZAHL XZAHL CHAR 1 #VALUE! 0 Indicator: Is the posting key used in a payment transaction?493 MWSK1 MWSKX CHAR 2 #VALUE! 0 Tax Code for Distribution506 DMBT1 DMBTX CURR 13 #VALUE! 2 Amount in Local Currency for Tax Distribution519 WRBT1 WRBTX CURR 13 #VALUE! 2 Amount in foreign currency for tax breakdown521 MWSK2 MWSKX CHAR 2 #VALUE! 0 Tax Code for Distribution534 DMBT2 DMBTX CURR 13 #VALUE! 2 Amount in Local Currency for Tax Distribution547 WRBT2 WRBTX CURR 13 #VALUE! 2 Amount in foreign currency for tax breakdown549 MWSK3 MWSKX CHAR 2 #VALUE! 0 Tax Code for Distribution562 DMBT3 DMBTX CURR 13 #VALUE! 2 Amount in Local Currency for Tax Distribution575 WRBT3 WRBTX CURR 13 #VALUE! 2 Amount in foreign currency for tax breakdown577 QSSKZ QSSKZ CHAR 2 #VALUE! 0 Withholding Tax Code590 QSSHB QSSHB CURR 13 #VALUE! 2 Withholding Tax Base Amount603 QBSHB QBSHB CURR 13 #VALUE! 2 Withholding Tax Amount (in Document Currency)604 BSTAT BSTAT_D CHAR 1 #VALUE! 0 Document Status614 ANFBN ANFBN CHAR 10 #VALUE! 0 Document Number of the Bill of Exchange Payment Request618 ANFBJ ANFBJ NUMC 4 #VALUE! 0 Fiscal Year of the Bill of Exchange Payment Request Document622 ANFBU ANFBU CHAR 4 #VALUE! 0 Company Code in Which Bill of Exch.Payment Request Is Posted628 VBUND RASSC CHAR 6 #VALUE! 0 Company ID of trading partner629 REBZT REBZT CHAR 1 #VALUE! 0 Follow-On Document Type649 STCEG STCEG CHAR 20 #VALUE! 0 VAT Registration Number652 EGBLD EGBLD CHAR 3 #VALUE! 0 Country of Destination for Delivery of Goods655 EGLLD EGLLD CHAR 3 #VALUE! 0 Supplying Country for Delivery of Goods665 QSZNR QSZNR CHAR 10 #VALUE! 0 Certificate Number of the Withholding Tax Exemption678 QSFBT QSFBT CURR 13 #VALUE! 2 Withholding Tax-Exempt Amount (in Document Currency)679 XINVE XINVE CHAR 1 #VALUE! 0 Indicator: Capital Goods Affected?687 PROJK PS_PSP_PNR NUMC 8 #VALUE! 0 Work Breakdown Structure Element (WBS Element)701 FIPOS FIPOS CHAR 14 #VALUE! 0 Commitment Item713 NPLNR NPLNR CHAR 12 #VALUE! 0 Network Number for Account Assignment723 AUFPL CO_AUFPL NUMC 10 #VALUE! 0 Routing number of operations in the order731 APLZL CIM_COUNT NUMC 8 #VALUE! 0 Internal counter732 XEGDR XEGDR CHAR 1 #VALUE! 0 Indicator: Triangular deal within the EU ?745 DMBE2 DMBE2 CURR 13 #VALUE! 2 Amount in Second Local Currency758 DMBE3 DMBE3 CURR 13 #VALUE! 2 Amount in Third Local Currency771 DMB21 DMB2X CURR 13 #VALUE! 2 Amount in Second Local Currency for Tax Breakdown784 DMB22 DMB2X CURR 13 #VALUE! 2 Amount in Second Local Currency for Tax Breakdown797 DMB23 DMB2X CURR 13 #VALUE! 2 Amount in Second Local Currency for Tax Breakdown810 DMB31 DMB3X CURR 13 #VALUE! 2 Amount in Third Local Currency for Tax Breakdown823 DMB32 DMB3X CURR 13 #VALUE! 2 Amount in Third Local Currency for Tax Breakdown836 DMB33 DMB3X CURR 13 #VALUE! 2 Amount in Third Local Currency for Tax Breakdown849 MWST2 MWST2 CURR 13 #VALUE! 2 Tax Amount in Second Local Currency862 MWST3 MWST3 CURR 13 #VALUE! 2 Tax Amount in Third Local Currency

Page 8: SAP Tables

875 SKNT2 SKNT2 CURR 13 #VALUE! 2 Cash Discount Amount in Second Local Currency888 SKNT3 SKNT3 CURR 13 #VALUE! 2 Cash Discount Amount in Third Local Currency901 BDIF3 BDIF3 CURR 13 #VALUE! 2 Valuation Difference for the Third Local Currency902 XRAGL XRAGL CHAR 1 #VALUE! 0 Indicator: Clearing was Reversed905 RSTGR RSTGR CHAR 3 #VALUE! 0 Reason Code for Payments907 UZAWE UZAWE CHAR 2 #VALUE! 0 Payment Method Supplement917 KOSTL KOSTL CHAR 10 #VALUE! 0 Cost Center922 LNRAN LNRAN NUMC 5 #VALUE! 0 Sequence number of asset line items in fiscal year923 XSTOV XSTOV CHAR 1 #VALUE! 0 Indicator: Document is flagged for reversal936 KZBTR KZBTR_FI CURR 13 #VALUE! 2 Original Reduction Amount in Local Currency948 XREF1 XREF1 CHAR 12 #VALUE! 0 Business partner reference key960 XREF2 XREF2 CHAR 12 #VALUE! 0 Business partner reference key961 XARCH XARCH CHAR 1 #VALUE! 0 Indicator: Document already archived ?966 PSWSL PSWSL CUKY 5 #VALUE! 0 Update Currency for General Ledger Transaction Figures979 PSWBT PSWBT CURR 13 #VALUE! 2 Amount for Updating in General Ledger987 IMKEY IMKEY CHAR 8 #VALUE! 0 Internal Key for Real Estate Object989 ZEKKN DZEKKN NUMC 2 #VALUE! 0 Sequential Number of Account Assignment

1005 FISTL FISTL CHAR 16 #VALUE! 0 Funds Center1015 GEBER BP_GEBER CHAR 10 #VALUE! 0 Fund1023 DABRZ DABRBEZ DATS 8 #VALUE! 0 Reference Date for Settlement1024 XNEGP XNEGP CHAR 1 #VALUE! 0 Indicator: Negative posting1034 EMPFB EMPFB CHAR 10 #VALUE! 0 Payee/Payer1044 PRCTR PRCTR CHAR 10 #VALUE! 0 Profit Center1064 XREF3 XREF3 CHAR 20 #VALUE! 0 Reference key for line item1066 DTWS1 DTAT16 NUMC 2 #VALUE! 0 Instruction key 11068 DTWS2 DTAT17 NUMC 2 #VALUE! 0 Instruction key 21070 DTWS3 DTAT18 NUMC 2 #VALUE! 0 Instruction key 31072 DTWS4 DTAT19 NUMC 2 #VALUE! 0 Instruction key 41073 XPYPR XPYPR CHAR 1 #VALUE! 0 Indicator: Payment Order Exists for this Item1103 KIDNO KIDNO CHAR 30 #VALUE! 0 Payment Reference1108 PYCUR PYCUR CUKY 5 #VALUE! 0 Currency for Automatic Payment1121 PYAMT PYAMT CURR 13 #VALUE! 2 Amount in Payment Currency1125 BUPLA BUPLA CHAR 4 #VALUE! 0 Business Place1129 SECCO SECCO CHAR 4 #VALUE! 0 Section Code1142 PPDIFF PPDIFF CURR 13 #VALUE! 2 Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)1155 PPDIF2 PPDIF2 CURR 13 #VALUE! 2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)1168 PPDIF3 PPDIF3 CURR 13 #VALUE! 2 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)1181 PENLC1 PENALTY1 CURR 13 #VALUE! 2 Penalty charge amount in first local currency1194 PENLC2 PENALTY2 CURR 13 #VALUE! 2 Penalty charge amount in second local currency1207 PENLC3 PENALTY3 CURR 13 #VALUE! 2 Penalty Charge Amount in Third Local Currency1220 PENFC PENALTY CURR 13 #VALUE! 2 Penalty charge amount in document currency1230 PENDAYS PDAYS INT4 10 #VALUE! 0 Number of days for penalty charge calculation1232 PENRC PENRC CHAR 2 #VALUE! 0 Reason for late payment1233 VERTT RANTYP CHAR 1 #VALUE! 0 Contract Type1246 VERTN RANL CHAR 13 #VALUE! 0 Contract Number1250 VBEWA SBEWART CHAR 4 #VALUE! 0 Flow Type1260 KBLNR KBLNR_FI CHAR 10 #VALUE! 0 Document Number for Earmarked Funds1263 KBLPOS KBLPOS NUMC 3 #VALUE! 0 Earmarked Funds: Document Item1283 GRANT_NBR GM_GRANT_NBR CHAR 20 #VALUE! 0 Grant1284 GMVKZ FM_GMVKZ CHAR 1 #VALUE! 0 Item is in Execution1286 SRTYPE FM_SRTYPE CHAR 2 #VALUE! 0 Type of Additional Receivable1296 LOTKZ PSO_LOTKZ CHAR 10 #VALUE! 0 Lot Number for Requests1298 ZINKZ DZINKZ CHAR 2 #VALUE! 0 Exempted from interest calculation1314 FKBER FKBER CHAR 16 #VALUE! 0 Functional Area1327 INTRENO VVINTRENO CHAR 13 #VALUE! 0 Internal Real Estate Master Data Code1337 PPRCT PPRCTR CHAR 10 #VALUE! 0 Partner Profit Center1338 BUZID BUZID CHAR 1 #VALUE! 0 Identification of the Line Item1342 AUGGJ AUGGJ NUMC 4 #VALUE! 0 Fiscal Year of Clearing Document1347 HKTID HKTID CHAR 5 #VALUE! 0 ID for account details1347 .APPEND ABSAK_PSO STRU 0 #VALUE! 0 IS-PS: Data appendix of cleared items vendor1349 KONTT KONTT_FI CHAR 2 #VALUE! 0 Account Assignment Category for Industry Solution1399 KONTL KONTL_FI CHAR 50 #VALUE! 0 Acct assignment string for industry-specific acct assignmnts1407 UEBGDAT UEBGDAT DATS 8 #VALUE! 0 Transfer date of an item to legal dunning proceeding1407 .APPEND JVBSAK STRU 0 #VALUE! 0 Joint Venture Fields1413 VNAME JV_NAME CHAR 6 #VALUE! 0 Joint Venture1416 EGRUP JV_EGROUP CHAR 3 #VALUE! 0 Equity group1418 BTYPE JV_BILIND CHAR 2 #VALUE! 0 Payroll Type1418 .APPEND OILBSAK STRU 0 #VALUE! 0 1418 .INCLUDE OIA_NETFI STRU 0 #VALUE! 0 Exchange Netting fields to be included in FI tables1428 OIEXGNUM OIA_EXGNUM CHAR 10 #VALUE! 0 Exchange agreement number1429 OINETCYC OIA_NETCYC CHAR 1 #VALUE! 0 Netting cycle (FI blocking indicator)1433 OIEXGTYP OIA_EXGTYP CHAR 4 #VALUE! 0 Exchange type1433 .APPEND REPR_BSAK STRU 0 #VALUE! 0 1433 .INCLUDE REPR_APPEND STRU 0 #VALUE! 0 1446 PROPMANO REHORECNNRM CHAR 13 #VALUE! 0

____________________________________________ _______________ #VALUE! ______ ____________________________________________________________

Page 9: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - BSEG

Field Data element Data TypeLength DecimalMANDT MANDT CLNT 3 0BUKRS BUKRS CHAR 4 0BELNR BELNR_D CHAR 10 0GJAHR GJAHR NUMC 4 0BUZEI BUZEI NUMC 3 0BUZID BUZID CHAR 1 0AUGDT AUGDT DATS 8 0AUGCP AUGCP DATS 8 0AUGBL AUGBL CHAR 10 0BSCHL BSCHL CHAR 2 0KOART KOART CHAR 1 0UMSKZ UMSKZ CHAR 1 0UMSKS UMSKS CHAR 1 0ZUMSK DZUMSK CHAR 1 0SHKZG SHKZG CHAR 1 0GSBER GSBER CHAR 4 0PARGB PARGB CHAR 4 0MWSKZ MWSKZ CHAR 2 0QSSKZ QSSKZ CHAR 2 0DMBTR DMBTR CURR 13 2WRBTR WRBTR CURR 13 2KZBTR KZBTR_FI CURR 13 2PSWBT PSWBT CURR 13 2PSWSL PSWSL CUKY 5 0TXBHW TXBHW CURR 13 2TXBFW TXBFW CURR 13 2MWSTS MWSTS CURR 13 2WMWST WMWST CURR 13 2HWBAS HWBAS CURR 13 2FWBAS FWBAS CURR 13 2HWZUZ HWZUZ CURR 13 2FWZUZ FWZUZ CURR 13 2SHZUZ SHZUZ CHAR 1 0STEKZ CHAR2 CHAR 2 0MWART MWART CHAR 1 0TXGRP TXGRP NUMC 3 0KTOSL KTOSL CHAR 3 0QSSHB QSSHB CURR 13 2KURSR KURSR DEC 9 5GBETR GBETR CURR 13 2BDIFF BDIFF CURR 13 2BDIF2 BDIF2 CURR 13 2VALUT VALUT DATS 8 0ZUONR DZUONR CHAR 18 0SGTXT SGTXT CHAR 50 0ZINKZ DZINKZ CHAR 2 0VBUND RASSC CHAR 6 0BEWAR RMVCT CHAR 3 0ALTKT BILKT_SKA1 CHAR 10 0VORGN VORGN CHAR 4 0FDLEV FDLEV CHAR 2 0

Page 10: SAP Tables

FDGRP FDGRP CHAR 10 0FDWBT FDWBT CURR 13 2FDTAG FDTAG DATS 8 0FKONT FIPLS NUMC 3 0KOKRS KOKRS CHAR 4 0KOSTL KOSTL CHAR 10 0PROJN PROJN CHAR 16 0AUFNR AUFNR CHAR 12 0VBELN VBELN_VF CHAR 10 0VBEL2 VBELN_VA CHAR 10 0POSN2 POSNR_VA NUMC 6 0ETEN2 ETENR NUMC 4 0ANLN1 ANLN1 CHAR 12 0ANLN2 ANLN2 CHAR 4 0ANBWA ANBWA CHAR 3 0BZDAT BZDAT DATS 8 0PERNR PERNR_D NUMC 8 0XUMSW XUMSW CHAR 1 0XHRES XHRES CHAR 1 0XKRES XKRES CHAR 1 0XOPVW XOPVW CHAR 1 0XCPDD XCPDD CHAR 1 0XSKST XSKST CHAR 1 0XSAUF XSAUF CHAR 1 0XSPRO XSPRO CHAR 1 0XSERG XSERG CHAR 1 0XFAKT XFAKT CHAR 1 0XUMAN XUMAN CHAR 1 0XANET XANET CHAR 1 0XSKRL XSKRL CHAR 1 0XINVE XINVE CHAR 1 0XPANZ XPANZ CHAR 1 0XAUTO XAUTO CHAR 1 0XNCOP XNCOP CHAR 1 0XZAHL XZAHL CHAR 1 0SAKNR SAKNR CHAR 10 0HKONT HKONT CHAR 10 0KUNNR KUNNR CHAR 10 0LIFNR LIFNR CHAR 10 0FILKD FILKD CHAR 10 0XBILK XBILK CHAR 1 0GVTYP GVTYP CHAR 2 0HZUON HZUON CHAR 18 0ZFBDT DZFBDT DATS 8 0ZTERM DZTERM CHAR 4 0ZBD1T DZBD1T DEC 3 0ZBD2T DZBD2T DEC 3 0ZBD3T DZBD3T DEC 3 0ZBD1P DZBD1P DEC 5 3ZBD2P DZBD2P DEC 5 3SKFBT SKFBT CURR 13 2SKNTO SKNTO CURR 13 2WSKTO WSKTO CURR 13 2ZLSCH SCHZW_BSEG CHAR 1 0

Page 11: SAP Tables

ZLSPR DZLSPR CHAR 1 0ZBFIX DZBFIX CHAR 1 0HBKID HBKID CHAR 5 0BVTYP BVTYP CHAR 4 0NEBTR NEBTR CURR 13 2MWSK1 MWSKX CHAR 2 0DMBT1 DMBTX CURR 13 2WRBT1 WRBTX CURR 13 2MWSK2 MWSKX CHAR 2 0DMBT2 DMBTX CURR 13 2WRBT2 WRBTX CURR 13 2MWSK3 MWSKX CHAR 2 0DMBT3 DMBTX CURR 13 2WRBT3 WRBTX CURR 13 2REBZG REBZG CHAR 10 0REBZJ REBZJ NUMC 4 0REBZZ REBZZ NUMC 3 0REBZT REBZT CHAR 1 0ZOLLT DZOLLT CHAR 8 0ZOLLD DZOLLD DATS 8 0LZBKZ LZBKZ CHAR 3 0LANDL LANDL CHAR 3 0DIEKZ DIEKZ CHAR 1 0SAMNR SAMNR NUMC 8 0ABPER ABPER_RF ACCP 6 0VRSKZ VRSKZ CHAR 1 0VRSDT VRSDT DATS 8 0DISBN DISBN CHAR 10 0DISBJ DISBJ NUMC 4 0DISBZ DISBZ NUMC 3 0WVERW WVERW CHAR 1 0ANFBN ANFBN CHAR 10 0ANFBJ ANFBJ NUMC 4 0ANFBU ANFBU CHAR 4 0ANFAE ANFAE DATS 8 0BLNBT BLNBT CURR 13 2BLNKZ BLNKZ CHAR 2 0BLNPZ BLNPZ DEC 7 2MSCHL MSCHL CHAR 1 0MANSP MANSP CHAR 1 0MADAT MADAT DATS 8 0MANST MAHNS_D NUMC 1 0MABER MABER CHAR 2 0ESRNR ESRNR CHAR 11 0ESRRE ESRRE CHAR 27 0ESRPZ ESRPZ CHAR 2 0KLIBT KLIBT CURR 13 2QSZNR QSZNR CHAR 10 0QBSHB QBSHB CURR 13 2QSFBT QSFBT CURR 13 2NAVHW NAVHW CURR 13 2NAVFW NAVFW CURR 13 2MATNR MATNR CHAR 18 0WERKS WERKS_D CHAR 4 0

Page 12: SAP Tables

MENGE MENGE_D QUAN 13 3MEINS MEINS UNIT 3 0ERFMG ERFMG QUAN 13 3ERFME ERFME UNIT 3 0BPMNG BPMNG QUAN 13 3BPRME BPRME UNIT 3 0EBELN EBELN CHAR 10 0EBELP EBELP NUMC 5 0ZEKKN DZEKKN NUMC 2 0ELIKZ ELIKZ CHAR 1 0VPRSV VPRSV CHAR 1 0PEINH PEINH DEC 5 0BWKEY BWKEY CHAR 4 0BWTAR BWTAR_D CHAR 10 0BUSTW BUSTW CHAR 4 0REWRT REEWR CURR 13 2REWWR REFWR CURR 13 2BONFB BONFB CURR 13 2BUALT BUALT CURR 13 2PSALT PSALT CHAR 1 0NPREI NPREI CURR 11 2TBTKZ TBTKZ CHAR 1 0SPGRP SPGRP CHAR 1 0SPGRM SPGRM CHAR 1 0SPGRT SPGRT CHAR 1 0SPGRG SPGRG CHAR 1 0SPGRV SPGRV CHAR 1 0SPGRQ SPGRQ CHAR 1 0STCEG STCEG CHAR 20 0EGBLD EGBLD CHAR 3 0EGLLD EGLLD CHAR 3 0RSTGR RSTGR CHAR 3 0RYACQ RYACQ CHAR 4 0RPACQ RPACQ NUMC 3 0RDIFF RDIFF CURR 13 2RDIF2 RDIF2 CURR 13 2PRCTR PRCTR CHAR 10 0XHKOM XHKOM CHAR 1 0VNAME JV_NAME CHAR 6 0RECID JV_RECIND CHAR 2 0EGRUP JV_EGROUP CHAR 3 0VPTNR JV_PART CHAR 10 0VERTT RANTYP CHAR 1 0VERTN RANL CHAR 13 0VBEWA SBEWART CHAR 4 0DEPOT RLDEPO CHAR 10 0TXJCD TXJCD CHAR 15 0IMKEY IMKEY CHAR 8 0DABRZ DABRBEZ DATS 8 0POPTS POPTSATZ DEC 9 6FIPOS FIPOS CHAR 14 0KSTRG KSTRG CHAR 12 0NPLNR NPLNR CHAR 12 0AUFPL AUFPL_CH NUMC 10 0

Page 13: SAP Tables

APLZL APLZL_CH NUMC 8 0PROJK PS_PSP_PNR NUMC 8 0PAOBJNR RKEOBJNR NUMC 10 0PASUBNR RKESUBNR NUMC 4 0SPGRS SPGRS CHAR 1 0SPGRC SPGRC CHAR 1 0BTYPE JV_BILIND CHAR 2 0ETYPE JV_ETYPE CHAR 3 0XEGDR XEGDR CHAR 1 0LNRAN LNRAN NUMC 5 0HRKFT HRKFT CHAR 4 0DMBE2 DMBE2 CURR 13 2DMBE3 DMBE3 CURR 13 2DMB21 DMB2X CURR 13 2DMB22 DMB2X CURR 13 2DMB23 DMB2X CURR 13 2DMB31 DMB3X CURR 13 2DMB32 DMB3X CURR 13 2DMB33 DMB3X CURR 13 2MWST2 MWST2 CURR 13 2MWST3 MWST3 CURR 13 2NAVH2 NAVH2 CURR 13 2NAVH3 NAVH3 CURR 13 2SKNT2 SKNT2 CURR 13 2SKNT3 SKNT3 CURR 13 2BDIF3 BDIF3 CURR 13 2RDIF3 RDIF3 CURR 13 2HWMET HWMET CHAR 1 0GLUPM GLUPM CHAR 1 0XRAGL XRAGL CHAR 1 0UZAWE UZAWE CHAR 2 0LOKKT ALTKT_SKB1 CHAR 10 0FISTL FISTL CHAR 16 0GEBER BP_GEBER CHAR 10 0STBUK STBUK CHAR 4 0TXBH2 TXBH2 CURR 13 2TXBH3 TXBH3 CURR 13 2PPRCT PPRCTR CHAR 10 0XREF1 XREF1 CHAR 12 0XREF2 XREF2 CHAR 12 0KBLNR KBLNR_FI CHAR 10 0KBLPOS KBLPOS NUMC 3 0STTAX STTAX CURR 13 2FKBER FKBER_SHORT CHAR 4 0OBZEI OBZEI NUMC 3 0XNEGP XNEGP CHAR 1 0RFZEI RFZEI_CC NUMC 3 0CCBTC CCBTC CHAR 10 0KKBER KKBER CHAR 4 0EMPFB EMPFB CHAR 10 0XREF3 XREF3 CHAR 20 0DTWS1 DTAT16 NUMC 2 0DTWS2 DTAT17 NUMC 2 0DTWS3 DTAT18 NUMC 2 0

Page 14: SAP Tables

DTWS4 DTAT19 NUMC 2 0GRICD J_1AGICD_D CHAR 2 0GRIRG REGIO CHAR 3 0GITYP J_1ADTYP_D CHAR 2 0XPYPR XPYPR CHAR 1 0KIDNO KIDNO CHAR 30 0ABSBT ABSBT CURR 13 2IDXSP J_1AINDXSP CHAR 5 0LINFV J_1ALINFVL DATS 8 0KONTT KONTT_FI CHAR 2 0KONTL KONTL_FI CHAR 50 0TXDAT TXDAT DATS 8 0AGZEI AGZEI DEC 5 0PYCUR PYCUR CUKY 5 0PYAMT PYAMT CURR 13 2BUPLA BUPLA CHAR 4 0SECCO SECCO CHAR 4 0LSTAR LSTAR CHAR 6 0CESSION_KZ CESSION_KZ CHAR 2 0PRZNR CO_PRZNR CHAR 12 0PPDIFF PPDIFF CURR 13 2PPDIF2 PPDIF2 CURR 13 2PPDIF3 PPDIF3 CURR 13 2PENLC1 PENALTY1 CURR 13 2PENLC2 PENALTY2 CURR 13 2PENLC3 PENALTY3 CURR 13 2PENFC PENALTY CURR 13 2PENDAYS PDAYS INT4 10 0PENRC PENRC CHAR 2 0GRANT_NBR GM_GRANT_NBR CHAR 20 0SCTAX SCTAX CURR 13 2FKBER_LONG FKBER CHAR 16 0GMVKZ FM_GMVKZ CHAR 1 0SRTYPE FM_SRTYPE CHAR 2 0INTRENO VVINTRENO CHAR 13 0MEASURE FM_MEASURE CHAR 24 0AUGGJ AUGGJ NUMC 4 0PPA_EX_IND EXCLUDE_FLG CHAR 1 0DOCLN DOCLN6 CHAR 6 0SEGMENT FB_SEGMENT CHAR 10 0PSEGMENT FB_PSEGMENT CHAR 10 0PFKBER SFKBER CHAR 16 0HKTID HKTID CHAR 5 0.APPEND JVA_BSEG STRU 0 0PRODPER JV_PRODPER DATS 8 0.APPEND OILBSEG STRU 0 0.INCLUDE OIBSEG STRU 0 0OITAXFROM OIH_TAXFRO CHAR 2 0OITAXTO OIH_TAXTO CHAR 2 0OIFULTAX OIH_FULTAX CURR 13 2OIHANTYPE OIH_HANTYP CHAR 2 0OITAXGRP OIH_TAXGRP CHAR 2 0OIPRICIE OIH_PRICIE CHAR 1 0OIINVREC OIH_INVREC CHAR 1 0

Page 15: SAP Tables

OITXVAL0 OIH_TXVAL0 CURR 13 2OITXVAL1 OIH_TXVAL1 CURR 13 2OITXVAL2 OIH_TXVAL2 CURR 13 2OITXVAL3 OIH_TXVAL3 CURR 13 2OITXVAL4 OIH_TXVAL4 CURR 13 2OITXVAL5 OIH_TXVAL5 CURR 13 2OITXVAL6 OIH_TXVAL6 CURR 13 2OIOILCON OIH_OILCON DEC 5 2OITAXCON OIH_TAXCON CURR 13 2OITAXVAL OIH_TAXVAL CURR 13 2OIOILCON2 OIH_OILCN2 DEC 5 2OIUOMQT OIH_UOMQT UNIT 3 0OITAXQT OIH_TAXQT QUAN 13 3OIFUTQT OIH_FUTQT QUAN 13 3OIFUTTX OIH_FUTTX CURR 13 2OIFUTDT OIH_FUTDT DATS 8 0OIFUTQT2 OIH_FUTQT2 QUAN 13 3OIFUTTX2 OIH_FUTTX2 CURR 13 2OIFUTDT2 OIH_FUTDT2 DATS 8 0OITAXGRP2 OIH_TAXGRP CHAR 2 0OICIMAP OIA_CIMAP CHAR 1 0.INCLUDE OIBSEG10A STRU 0 0OIHANTYP OIH_HANTYP CHAR 2 0OIVATH DMBTR CURR 13 2OIVATF WRBTR CURR 13 2.INCLUDE OIBSEG10B STRU 0 0OINETCYC OIA_NETCYC CHAR 1 0OIA_IPMVAT OIA_IPMVAT CHAR 1 0OIEXGNUM OIA_EXGNUM CHAR 10 0OIEXGTYP OIA_EXGTYP CHAR 4 0OINEGPSTG OIA_NGPSTL CHAR 1 0RECID_MAN CHAR 1 0.INCLUDE OIBSEG10C STRU 0 0OIPOSTZERO OIH_PSTZRO CHAR 1 0.INCLUDE OIBSEG40B STRU 0 0OIINVCYC OIA_INVCYC NUMC 1 0

Page 16: SAP Tables

Short DescriptionClientCompany CodeAccounting Document NumberFiscal YearNumber of Line Item Within Accounting DocumentIdentification of the Line ItemClearing DateClearing Entry DateDocument Number of the Clearing DocumentPosting KeyAccount TypeSpecial G/L IndicatorSpecial G/L Transaction TypeTarget Special G/L IndicatorDebit/Credit IndicatorBusiness AreaTrading partner's business areaSales Tax CodeWithholding Tax CodeAmount in Local CurrencyAmount in document currencyOriginal Reduction Amount in Local CurrencyAmount for Updating in General LedgerUpdate Currency for General Ledger Transaction FiguresOriginal Tax Base Amount in Local CurrencyOriginal Tax Base Amount in Document CurrencyTax Amount in Local CurrencyTax amount in document currencyTax Base Amount in Local CurrencyTax Base Amount in Document CurrencyProvision Amount in Local CurrencyAdditional Tax in Document CurrencyDebit/Credit Addition for Cash DiscountVersion Number ComponentTax TypeGroup Indicator for Tax Line ItemsTransaction KeyWithholding Tax Base AmountHedged Exchange RateHedged Amount in Foreign CurrencyValuation DifferenceValuation Difference for the Second Local CurrencyValue dateAssignment NumberItem TextExempted from interest calculationCompany ID of trading partnerTransaction TypeGroup account numberTransaction Type for General LedgerPlanning level

Page 17: SAP Tables

Planning GroupPlanning amount in document currencyPlanning dateFinancial Budget ItemControlling AreaCost CenterOld: Project number : No longer used --> PS_POSNROrder NumberBilling DocumentSales DocumentSales Document ItemDelivery Schedule Line NumberMain Asset NumberAsset SubnumberAsset Transaction TypeAsset value datePersonnel NumberIndicator: Sales-related item ?Indicator: Resident G/L account?Indicator: Can Line Items Be Displayed by Account?Indicator: Open item management?Indicator: Address and bank data set individuallyIndicator: Statistical posting to cost centerIndicator: Posting to order is statisticalIndicator: Posting to project is statisticalIndicator: Posting to prof.analysis is statisticalIndicator: Billing document update successful ?Indicator: Transfer posting from down payment ?Indicator: Down payment in net procedure ?Indicator: Line item not liable to cash discount?Indicator: Capital Goods Affected?Display itemIndicator: Line item automatically createdIndicator: Items cannot be copied?Indicator: Is the posting key used in a payment transaction?G/L Account NumberGeneral Ledger AccountCustomer Number 1Account Number of Vendor or CreditorAccount Number of the BranchIndicator: Account is a balance sheet account?P&L statement account typeAssignment Number for Special G/L AccountsBaseline Date for Due Date CalculationTerms of Payment KeyCash discount days 1Cash discount days 2Net Payment Terms PeriodCash Discount Percentage 1Cash Discount Percentage 2Amount Eligible for Cash Discount in Document CurrencyCash discount amount in local currencyCash discount amount in document currencyPayment Method

Page 18: SAP Tables

Payment Block KeyFixed Payment TermsShort Key for a House BankPartner Bank TypeNet Payment AmountTax Code for DistributionAmount in Local Currency for Tax DistributionAmount in foreign currency for tax breakdownTax Code for DistributionAmount in Local Currency for Tax DistributionAmount in foreign currency for tax breakdownTax Code for DistributionAmount in Local Currency for Tax DistributionAmount in foreign currency for tax breakdownNumber of the Invoice the Transaction Belongs toFiscal Year of the Relevant Invoice (for Credit Memo)Line Item in the Relevant InvoiceFollow-On Document TypeCustoms Tariff NumberCustoms DateState Central Bank IndicatorSupplying CountryService Indicator (Foreign Payment)Invoice List NumberSettlement periodInsurance indicatorInsurance dateNumber of Bill of Exchange Usage Document (Discount Doc.)Fiscal Year of Bill of Exchange Usage DocumentLine Item within the Bill of Exchange Usage DocumentBill of exchange usage typeDocument Number of the Bill of Exchange Payment RequestFiscal Year of the Bill of Exchange Payment Request DocumentCompany Code in Which Bill of Exch.Payment Request Is PostedBill of Exchange Payment Request Due DateBase Amount for Determining the Preference AmountSubsidy indicator for determining the reduction ratesPreference Percentage RateDunning keyDunning blockLast dunned onDunning levelDunning AreaISR Subscriber NumberISR Reference NumberISR Check DigitCredit Control AmountCertificate Number of the Withholding Tax ExemptionWithholding Tax Amount (in Document Currency)Withholding Tax-Exempt Amount (in Document Currency)Non-Deductible Input Tax (in Local Currency)Non-Deductible Input Tax (in Document Currency)Material NumberPlant

Page 19: SAP Tables

QuantityBase Unit of MeasureQuantity in Unit of EntryUnit of EntryQuantity in Purchase Order Price UnitOrder Price Unit (Purchasing)Purchasing Document NumberItem Number of Purchasing DocumentSequential Number of Account AssignmentDelivery Completed IndicatorPrice control indicatorPrice UnitValuation AreaValuation TypePosting string for valuesInvoice Value Entered (in Local Currency)Invoice value in foreign currencyAmount Qualifying for Bonus in Local CurrencyAmount posted in alternative price controlAlternative Price ControlNew priceIndicator: subsequent debit/creditBlocking reason: priceBlocking reason: quantityBlocking Reason: DateBlocking reason: order price quantityBlocking reason: project budgetManual Blocking ReasonVAT Registration NumberCountry of Destination for Delivery of GoodsSupplying Country for Delivery of GoodsReason Code for PaymentsYear of acquisitionPeriod of acquisitionExchange Rate Gain/Loss RealizedExchange Rate Difference Realized for Second Local CurrencyProfit CenterIndicator: G/L account assigned manually ?Joint VentureRecovery IndicatorEquity groupPartner account numberContract TypeContract NumberFlow TypeSecurities AccountTax JurisdictionInternal Key for Real Estate ObjectReference Date for SettlementReal estate option rateCommitment ItemCost ObjectNetwork Number for Account AssignmentTask list number for operations in order

Page 20: SAP Tables

General counter for orderWork Breakdown Structure Element (WBS Element)Profitability Segment Number (CO-PA)Profitability segment changes (CO-PA)Blocking Reason: Item AmountBlock.reason: qualityPayroll TypeEquity typeIndicator: Triangular deal within the EU ?Sequence number of asset line items in fiscal yearOrigin Group as Subdivision of Cost ElementAmount in Second Local CurrencyAmount in Third Local CurrencyAmount in Second Local Currency for Tax BreakdownAmount in Second Local Currency for Tax BreakdownAmount in Second Local Currency for Tax BreakdownAmount in Third Local Currency for Tax BreakdownAmount in Third Local Currency for Tax BreakdownAmount in Third Local Currency for Tax BreakdownTax Amount in Second Local CurrencyTax Amount in Third Local CurrencyNon-Deductible Input Tax in Second Local CurrencyNon-Deductible Input Tax in Third Local CurrencyCash Discount Amount in Second Local CurrencyCash Discount Amount in Third Local CurrencyValuation Difference for the Third Local CurrencyExchange Rate Difference Realized for Third Local CurrencyMethod with Which the Local Currency Amount Was DeterminedUpdate Method for FM - FI-CA IntegrationIndicator: Clearing was ReversedPayment Method SupplementAlternative account number in company codeFunds CenterFundTax Company CodeTax Base/Original Tax Base in Second Local CurrencyTax Base/Original Tax Base in Third Local CurrencyPartner Profit CenterBusiness partner reference keyBusiness partner reference keyDocument Number for Earmarked FundsEarmarked Funds: Document ItemTax amount as statistical information in document currencyFunctional AreaNumber of Line Item in Original DocumentIndicator: Negative postingPayment Card ItemPayment cards: Settlement runCredit control areaPayee/PayerReference key for line itemInstruction key 1Instruction key 2Instruction key 3

Page 21: SAP Tables

Instruction key 4Activity Code for Gross Income TaxRegion (State, Province, County)Distribution Type for Employment TaxIndicator: Payment Order Exists for this ItemPayment ReferenceCredit management: Hedged amountInflation IndexLast Adjustment DateAccount Assignment Category for Industry SolutionAcct assignment string for industry-specific acct assignmntsDate for defining tax ratesClearing ItemCurrency for Automatic PaymentAmount in Payment CurrencyBusiness PlaceSection CodeActivity TypeAccounts Receivable Pledging IndicatorBusiness ProcessRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)Penalty charge amount in first local currencyPenalty charge amount in second local currencyPenalty Charge Amount in Third Local CurrencyPenalty charge amount in document currencyNumber of days for penalty charge calculationReason for late paymentGrantTax portion FI-CA local currencyFunctional AreaItem is in ExecutionType of Additional ReceivableInternal Real Estate Master Data CodeFunded ProgramFiscal Year of Clearing DocumentExcluding/Including IndicatorSix-Character Posting Item for LedgerSegment for Segmental ReportingPartner Segment for Segmental ReportingPartner Functional AreaID for account detailsJoint Venture addtional doucment fieldsProduction Month (Date to find period and year)Cluster-Append of IS-Oil to BSEG (replaces former includes)IS-Oil Rel.2.2D - Do not append/add fieldsExcise duty tax key for 'from' locationExcise duty tax key for 'to' locationExcise duty tax value at the full rateExcise Duty Handling Type - Denotes Use of MaterialExcise duty tax group for material(s)ED pricing: external (indicator)Indicator whether ED pricing is external (not used?)

Page 22: SAP Tables

Excise duty tax value 0Excise duty tax value 1Excise duty tax value 2Excise duty tax value 3Excise duty tax value 4Excise duty tax value 5Excise duty tax value 6Oil content in a material as a percentageExcise duty tax from pricing conditionsExcise duty value in material inventory accountOil content of a material as a percentage (2)Base quantity for excise duty rate (e.g.per 1 or 100 UoM)Excise duty tax quantity in STBMEFuture tax quantityFuture tax valueFuture tax dateFuture tax quantity 2Future tax value 2Future tax date 2Excise duty tax group for material(s)Change internal moving average priceIS-Oil Rel.3.0A - Do not append/add fieldsExcise Duty Handling Type - Denotes Use of MaterialAmount in Local CurrencyAmount in document currencyIS-Oil Rel.3.0C - Do not append/add fieldsNetting cycle (FI blocking indicator)VAT on internally-posted materialExchange agreement numberExchange typeNegative posting line (exchange fees)Oil-JV:Dummy (<40B=JV_RECID_M)IS-Oil Rel.3.0D - Do not append/add fieldsPost zero amountsIS-Oil Rel.4.0B - Do not append/add fieldsInvoice cycle

Page 23: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - BSIK

Field Data element Data TypeLength DecimalMANDT MANDT CLNT 3 0BUKRS BUKRS CHAR 4 0LIFNR LIFNR CHAR 10 0UMSKS UMSKS CHAR 1 0UMSKZ UMSKZ CHAR 1 0AUGDT AUGDT DATS 8 0AUGBL AUGBL CHAR 10 0ZUONR DZUONR CHAR 18 0GJAHR GJAHR NUMC 4 0BELNR BELNR_D CHAR 10 0BUZEI BUZEI NUMC 3 0BUDAT BUDAT DATS 8 0BLDAT BLDAT DATS 8 0CPUDT CPUDT DATS 8 0WAERS WAERS CUKY 5 0XBLNR XBLNR1 CHAR 16 0BLART BLART CHAR 2 0MONAT MONAT NUMC 2 0BSCHL BSCHL CHAR 2 0ZUMSK DZUMSK CHAR 1 0SHKZG SHKZG CHAR 1 0GSBER GSBER CHAR 4 0MWSKZ MWSKZ CHAR 2 0DMBTR DMBTR CURR 13 2WRBTR WRBTR CURR 13 2MWSTS MWSTS CURR 13 2WMWST WMWST CURR 13 2BDIFF BDIFF CURR 13 2BDIF2 BDIF2 CURR 13 2SGTXT SGTXT CHAR 50 0PROJN PROJN CHAR 16 0AUFNR AUFNR CHAR 12 0ANLN1 ANLN1 CHAR 12 0ANLN2 ANLN2 CHAR 4 0EBELN EBELN CHAR 10 0EBELP EBELP NUMC 5 0SAKNR SAKNR CHAR 10 0HKONT HKONT CHAR 10 0FKONT FIPLS NUMC 3 0FILKD FILKD CHAR 10 0ZFBDT DZFBDT DATS 8 0ZTERM DZTERM CHAR 4 0ZBD1T DZBD1T DEC 3 0ZBD2T DZBD2T DEC 3 0ZBD3T DZBD3T DEC 3 0ZBD1P DZBD1P DEC 5 3ZBD2P DZBD2P DEC 5 3

Page 24: SAP Tables

SKFBT SKFBT CURR 13 2SKNTO SKNTO CURR 13 2WSKTO WSKTO CURR 13 2ZLSCH DZLSCH CHAR 1 0ZLSPR DZLSPR CHAR 1 0ZBFIX DZBFIX CHAR 1 0HBKID HBKID CHAR 5 0BVTYP BVTYP CHAR 4 0REBZG REBZG CHAR 10 0REBZJ REBZJ NUMC 4 0REBZZ REBZZ NUMC 3 0ZOLLT DZOLLT CHAR 8 0ZOLLD DZOLLD DATS 8 0LZBKZ LZBKZ CHAR 3 0LANDL LANDL CHAR 3 0DIEKZ DIEKZ CHAR 1 0MANSP MANSP CHAR 1 0MSCHL MSCHL CHAR 1 0MADAT MADAT DATS 8 0MANST MAHNS_D NUMC 1 0MABER MABER CHAR 2 0XNETB XNETB CHAR 1 0XANET XANET CHAR 1 0XCPDD XCPDD CHAR 1 0XESRD XESRD CHAR 1 0XZAHL XZAHL CHAR 1 0MWSK1 MWSKX CHAR 2 0DMBT1 DMBTX CURR 13 2WRBT1 WRBTX CURR 13 2MWSK2 MWSKX CHAR 2 0DMBT2 DMBTX CURR 13 2WRBT2 WRBTX CURR 13 2MWSK3 MWSKX CHAR 2 0DMBT3 DMBTX CURR 13 2WRBT3 WRBTX CURR 13 2QSSKZ QSSKZ CHAR 2 0QSSHB QSSHB CURR 13 2QBSHB QBSHB CURR 13 2BSTAT BSTAT_D CHAR 1 0ANFBN ANFBN CHAR 10 0ANFBJ ANFBJ NUMC 4 0ANFBU ANFBU CHAR 4 0VBUND RASSC CHAR 6 0REBZT REBZT CHAR 1 0STCEG STCEG CHAR 20 0EGBLD EGBLD CHAR 3 0EGLLD EGLLD CHAR 3 0QSZNR QSZNR CHAR 10 0QSFBT QSFBT CURR 13 2XINVE XINVE CHAR 1 0

Page 25: SAP Tables

PROJK PS_PSP_PNR NUMC 8 0FIPOS FIPOS CHAR 14 0NPLNR NPLNR CHAR 12 0AUFPL CO_AUFPL NUMC 10 0APLZL CIM_COUNT NUMC 8 0XEGDR XEGDR CHAR 1 0DMBE2 DMBE2 CURR 13 2DMBE3 DMBE3 CURR 13 2DMB21 DMB2X CURR 13 2DMB22 DMB2X CURR 13 2DMB23 DMB2X CURR 13 2DMB31 DMB3X CURR 13 2DMB32 DMB3X CURR 13 2DMB33 DMB3X CURR 13 2MWST2 MWST2 CURR 13 2MWST3 MWST3 CURR 13 2SKNT2 SKNT2 CURR 13 2SKNT3 SKNT3 CURR 13 2BDIF3 BDIF3 CURR 13 2XRAGL XRAGL CHAR 1 0RSTGR RSTGR CHAR 3 0UZAWE UZAWE CHAR 2 0KOSTL KOSTL CHAR 10 0LNRAN LNRAN NUMC 5 0XSTOV XSTOV CHAR 1 0KZBTR KZBTR_FI CURR 13 2XREF1 XREF1 CHAR 12 0XREF2 XREF2 CHAR 12 0XARCH XARCH CHAR 1 0PSWSL PSWSL CUKY 5 0PSWBT PSWBT CURR 13 2IMKEY IMKEY CHAR 8 0ZEKKN DZEKKN NUMC 2 0FISTL FISTL CHAR 16 0GEBER BP_GEBER CHAR 10 0DABRZ DABRBEZ DATS 8 0XNEGP XNEGP CHAR 1 0EMPFB EMPFB CHAR 10 0PRCTR PRCTR CHAR 10 0XREF3 XREF3 CHAR 20 0DTWS1 DTAT16 NUMC 2 0DTWS2 DTAT17 NUMC 2 0DTWS3 DTAT18 NUMC 2 0DTWS4 DTAT19 NUMC 2 0XPYPR XPYPR CHAR 1 0KIDNO KIDNO CHAR 30 0PYCUR PYCUR CUKY 5 0PYAMT PYAMT CURR 13 2BUPLA BUPLA CHAR 4 0SECCO SECCO CHAR 4 0

Page 26: SAP Tables

PPDIFF PPDIFF CURR 13 2PPDIF2 PPDIF2 CURR 13 2PPDIF3 PPDIF3 CURR 13 2PENLC1 PENALTY1 CURR 13 2PENLC2 PENALTY2 CURR 13 2PENLC3 PENALTY3 CURR 13 2PENFC PENALTY CURR 13 2PENDAYS PDAYS INT4 10 0PENRC PENRC CHAR 2 0VERTT RANTYP CHAR 1 0VERTN RANL CHAR 13 0VBEWA SBEWART CHAR 4 0KBLNR KBLNR_FI CHAR 10 0KBLPOS KBLPOS NUMC 3 0GRANT_NBR GM_GRANT_NBR CHAR 20 0GMVKZ FM_GMVKZ CHAR 1 0SRTYPE FM_SRTYPE CHAR 2 0LOTKZ PSO_LOTKZ CHAR 10 0ZINKZ DZINKZ CHAR 2 0FKBER FKBER CHAR 16 0INTRENO VVINTRENO CHAR 13 0PPRCT PPRCTR CHAR 10 0BUZID BUZID CHAR 1 0AUGGJ AUGGJ NUMC 4 0HKTID HKTID CHAR 5 0.APPEND ABSIK_PSO STRU 0 0KONTT KONTT_FI CHAR 2 0KONTL KONTL_FI CHAR 50 0UEBGDAT UEBGDAT DATS 8 0.APPEND JVBSIK STRU 0 0VNAME JV_NAME CHAR 6 0EGRUP JV_EGROUP CHAR 3 0BTYPE JV_BILIND CHAR 2 0.APPEND OILBSIK STRU 0 0.INCLUDE OIA_NETFI STRU 0 0OIEXGNUM OIA_EXGNUM CHAR 10 0OINETCYC OIA_NETCYC CHAR 1 0OIEXGTYP OIA_EXGTYP CHAR 4 0.APPEND REPR_BSIK STRU 0 0.INCLUDE REPR_APPEND STRU 0 0PROPMANO REHORECNNRM CHAR 13 0

Page 27: SAP Tables

Short DescriptionClientCompany CodeAccount Number of Vendor or CreditorSpecial G/L Transaction TypeSpecial G/L IndicatorClearing DateDocument Number of the Clearing DocumentAssignment NumberFiscal YearAccounting Document NumberNumber of Line Item Within Accounting DocumentPosting Date in the DocumentDocument Date in DocumentDay On Which Accounting Document Was EnteredCurrency KeyReference Document NumberDocument TypeFiscal PeriodPosting KeyTarget Special G/L IndicatorDebit/Credit IndicatorBusiness AreaSales Tax CodeAmount in Local CurrencyAmount in document currencyTax Amount in Local CurrencyTax amount in document currencyValuation DifferenceValuation Difference for the Second Local CurrencyItem TextOld: Project number : No longer used --> PS_POSNROrder NumberMain Asset NumberAsset SubnumberPurchasing Document NumberItem Number of Purchasing DocumentG/L Account NumberGeneral Ledger AccountFinancial Budget ItemAccount Number of the BranchBaseline Date for Due Date CalculationTerms of Payment KeyCash discount days 1Cash discount days 2Net Payment Terms PeriodCash Discount Percentage 1Cash Discount Percentage 2

Page 28: SAP Tables

Amount Eligible for Cash Discount in Document CurrencyCash discount amount in local currencyCash discount amount in document currencyPayment MethodPayment Block KeyFixed Payment TermsShort Key for a House BankPartner Bank TypeNumber of the Invoice the Transaction Belongs toFiscal Year of the Relevant Invoice (for Credit Memo)Line Item in the Relevant InvoiceCustoms Tariff NumberCustoms DateState Central Bank IndicatorSupplying CountryService Indicator (Foreign Payment)Dunning blockDunning keyLast dunned onDunning levelDunning AreaIndicator: Document posted net ?Indicator: Down payment in net procedure ?Indicator: Address and bank data set individuallyIndicator: Is any ISR data set in the document ?Indicator: Is the posting key used in a payment transaction?Tax Code for DistributionAmount in Local Currency for Tax DistributionAmount in foreign currency for tax breakdownTax Code for DistributionAmount in Local Currency for Tax DistributionAmount in foreign currency for tax breakdownTax Code for DistributionAmount in Local Currency for Tax DistributionAmount in foreign currency for tax breakdownWithholding Tax CodeWithholding Tax Base AmountWithholding Tax Amount (in Document Currency)Document StatusDocument Number of the Bill of Exchange Payment RequestFiscal Year of the Bill of Exchange Payment Request DocumentCompany Code in Which Bill of Exch.Payment Request Is PostedCompany ID of trading partnerFollow-On Document TypeVAT Registration NumberCountry of Destination for Delivery of GoodsSupplying Country for Delivery of GoodsCertificate Number of the Withholding Tax ExemptionWithholding Tax-Exempt Amount (in Document Currency)Indicator: Capital Goods Affected?

Page 29: SAP Tables

Work Breakdown Structure Element (WBS Element)Commitment ItemNetwork Number for Account AssignmentRouting number of operations in the orderInternal counterIndicator: Triangular deal within the EU ?Amount in Second Local CurrencyAmount in Third Local CurrencyAmount in Second Local Currency for Tax BreakdownAmount in Second Local Currency for Tax BreakdownAmount in Second Local Currency for Tax BreakdownAmount in Third Local Currency for Tax BreakdownAmount in Third Local Currency for Tax BreakdownAmount in Third Local Currency for Tax BreakdownTax Amount in Second Local CurrencyTax Amount in Third Local CurrencyCash Discount Amount in Second Local CurrencyCash Discount Amount in Third Local CurrencyValuation Difference for the Third Local CurrencyIndicator: Clearing was ReversedReason Code for PaymentsPayment Method SupplementCost CenterSequence number of asset line items in fiscal yearIndicator: Document is flagged for reversalOriginal Reduction Amount in Local CurrencyBusiness partner reference keyBusiness partner reference keyIndicator: Document already archived ?Update Currency for General Ledger Transaction FiguresAmount for Updating in General LedgerInternal Key for Real Estate ObjectSequential Number of Account AssignmentFunds CenterFundReference Date for SettlementIndicator: Negative postingPayee/PayerProfit CenterReference key for line itemInstruction key 1Instruction key 2Instruction key 3Instruction key 4Indicator: Payment Order Exists for this ItemPayment ReferenceCurrency for Automatic PaymentAmount in Payment CurrencyBusiness PlaceSection Code

Page 30: SAP Tables

Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)Penalty charge amount in first local currencyPenalty charge amount in second local currencyPenalty Charge Amount in Third Local CurrencyPenalty charge amount in document currencyNumber of days for penalty charge calculationReason for late paymentContract TypeContract NumberFlow TypeDocument Number for Earmarked FundsEarmarked Funds: Document ItemGrantItem is in ExecutionType of Additional ReceivableLot Number for RequestsExempted from interest calculationFunctional AreaInternal Real Estate Master Data CodePartner Profit CenterIdentification of the Line ItemFiscal Year of Clearing DocumentID for account detailsIS-PS: Data appendix of open items vendorsAccount Assignment Category for Industry SolutionAcct assignment string for industry-specific acct assignmntsTransfer date of an item to legal dunning proceedingJoint Venture FieldsJoint VentureEquity groupPayroll Type Exchange Netting fields to be included in FI tablesExchange agreement numberNetting cycle (FI blocking indicator)Exchange type

Page 31: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - EKBE

Field Data element Data TypeLength DecimalMANDT MANDT CLNT 3 0EBELN EBELN CHAR 10 0EBELP EBELP NUMC 5 0ZEKKN DZEKKN NUMC 2 0VGABE VGABE CHAR 1 0GJAHR MJAHR NUMC 4 0BELNR MBLNR CHAR 10 0BUZEI MBLPO NUMC 4 0.INCLUDE EKBEDATA STRU 0 0BEWTP BEWTP CHAR 1 0BWART BWART CHAR 3 0BUDAT BUDAT DATS 8 0MENGE MENGE_D QUAN 13 3BPMNG MENGE_BPR QUAN 13 3DMBTR DMBTR CURR 13 2WRBTR WRBTR CURR 13 2WAERS WAERS CUKY 5 0AREWR AREWR CURR 13 2WESBS WESBS QUAN 13 3BPWES BPWES QUAN 13 3SHKZG SHKZG CHAR 1 0BWTAR BWTAR_D CHAR 10 0ELIKZ ELIKZ CHAR 1 0XBLNR XBLNR1 CHAR 16 0LFGJA LFBJA NUMC 4 0LFBNR LFBNR CHAR 10 0LFPOS LFPOS NUMC 4 0GRUND MB_GRBEW NUMC 4 0CPUDT CPUDT DATS 8 0CPUTM CPUTM TIMS 6 0REEWR REEWR CURR 13 2EVERE EVERE CHAR 2 0REFWR REFWR CURR 13 2MATNR MATNR CHAR 18 0WERKS WERKS_D CHAR 4 0XWSBR XWSBR CHAR 1 0ETENS ETENS NUMC 4 0KNUMV KNUMV CHAR 10 0MWSKZ MWSKZ CHAR 2 0LSMNG LSMNG QUAN 13 3LSMEH LSMEH UNIT 3 0EMATN EMATNR CHAR 18 0AREWW AREWW CURR 13 2HSWAE HSWAE CUKY 5 0BAMNG MENGE_D QUAN 13 3CHARG CHARG_D CHAR 10 0BLDAT BLDAT DATS 8 0XWOFF XWOFF CHAR 1 0XUNPL XUNPL CHAR 1 0ERNAM ERNAM CHAR 12 0SRVPOS SRVPOS CHAR 18 0

Page 32: SAP Tables

PACKNO PACKNO_EKBE NUMC 10 0INTROW INTROW_EKBE NUMC 10 0BEKKN BEKKN NUMC 2 0LEMIN SRVRET CHAR 1 0AREWB AREWB CURR 13 2REWRB REWRB CURR 13 2SAPRL SAPRL CHAR 4 0MENGE_POP MENGE_D QUAN 13 3BPMNG_POP MENGE_BPR QUAN 13 3DMBTR_POP DMBTR CURR 13 2WRBTR_POP WRBTR CURR 13 2WESBB WESBB QUAN 13 3BPWEB BPWEB QUAN 13 3WEORA WEORA CHAR 1 0AREWR_POP AREWR CURR 13 2.APPEND OIA_EKBEDATA STRU 0 0.INCLUDE OIA_EKBE_STRUC STRU 0 0FRBNR FRBNR1 CHAR 16 0OIA_IPMVAT OIA_IPMVAT CHAR 1 0OIVATH DMBTR CURR 13 2OIVATF WRBTR CURR 13 2OIIMATV OIA_IMATV CURR 13 2.APPEND OIA_SI_EKBEDATA STRU 0 0.INCLUDE OIA_SI_EKBE_STRUC STRU 0 0OIMATCYC OIA_MATCYC NUMC 1 0.APPEND OIH_EKBEDATA STRU 0 0.INCLUDE OIH_EKBE_STRUC STRU 0 0OITAXVAL OIH_TAXVAL CURR 13 2OITAXCON OIH_TAXCON CURR 13 2OIEDCL OIH_EDCL CURR 13 2.INCLUDE RETURN_DELIVERY_EKBE STRU 0 0ET_UPD ET_UPD1 CHAR 1 0.APPEND /CWM/EKBE STRU 0 0/CWM/BAMNG /CWM/BAMNG QUAN 13 3/CWM/WESBS /CWM/WESBS QUAN 13 3.APPEND /SAPNEA/J_SC_EKBE1 STRU 0 0J_SC_DIE_COM/SAPNEA/J_SC_DIE_COMP_F CHAR 1 0____________________________________________ _______________ __________________________________________________ _______________ ______

Page 33: SAP Tables

Short DescriptionClientPurchasing Document NumberItem Number of Purchasing DocumentSequential Number of Account AssignmentTransaction/event type, purchase order historyMaterial Document YearNumber of Material DocumentItem in Material DocumentHistory per Purchasing DocumentPurchase Order History CategoryMovement Type (Inventory Management)Posting Date in the DocumentQuantityQuantity in purchase order price unitAmount in Local CurrencyAmount in document currencyCurrency KeyGR/IR account clearing value in local currencyGoods Receipt Blocked Stock in Order UnitQuantity in GR blocked stock in order price unitDebit/Credit IndicatorValuation TypeDelivery Completed IndicatorReference Document NumberFiscal Year of a Reference DocumentDocument No. of a Reference DocumentItem of a Reference DocumentReason for MovementDay On Which Accounting Document Was EnteredTime of EntryInvoice Value Entered (in Local Currency)Compliance with Shipping InstructionsInvoice value in foreign currencyMaterial NumberPlantReversal of GR allowed for GR-based IV despite invoiceSequential Number of Vendor ConfirmationNumber of the document conditionSales Tax CodeQuantity in Unit of Measure from Delivery NoteUnit of Measure From Delivery NoteMaterial NumberClearing value on GR/IR clearing account (transac. currency)Local currency keyQuantityBatch NumberDocument Date in DocumentCalculation of val. openUnplanned Account Assignment from Invoice VerificationName of Person who Created the ObjectService number

Page 34: SAP Tables

Package Number of ServiceLine Number of ServiceNumber of PO Account AssignmentReturns IndicatorClearing Value on GR/IR Account in PO CurrencyInvoice Amount in PO CurrencySAP ReleaseQuantityQuantity in purchase order price unitAmount in Local CurrencyAmount in document currencyValuated Goods Receipt Blocked Stock in Order UnitQuantity in Valuated GR Blocked Stock in Order Price UnitAcceptance At OriginGR/IR account clearing value in local currencyIS-Oil Exchanges append to structure EKBEDATAIS-Oil Exchanges data fields for EKBENumber of Bill of Lading at Time of Goods ReceiptVAT on internally-posted materialAmount in Local CurrencyAmount in document currencyInternal material valueIS-Oil Split Inv. append to structure EKBEDATAIS-Oil split Inv. data fields for EKBEInvoicing cycle for purchase material costsIS-Oil TDP append to structure EKBEDATAIS-Oil TDP data fields for EKBEExcise duty value in material inventory accountExcise duty tax from pricing conditionsExcise duty clearing valueReturn Delivery/Handling of Quantity DifferencesProcedure for Updating the Schedule Line Quantity/CWM/EKBEQuantity in Parallel Unit of MeasureGoods Receipt Blocked Stock in Base/Parallel Unit of MeasureSubcontracting ManagementDepreciation completion flag________________________________________________________________________________________________________________________

Page 35: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - EKKO

Field Data element Data TypeLength DecimalMANDT MANDT CLNT 3 0EBELN EBELN CHAR 10 0.INCLUDE EKKODATA STRU 0 0BUKRS BUKRS CHAR 4 0BSTYP EBSTYP CHAR 1 0BSART ESART CHAR 4 0BSAKZ BSAKZ CHAR 1 0LOEKZ ELOEK CHAR 1 0STATU ESTAK CHAR 1 0AEDAT ERDAT DATS 8 0ERNAM ERNAM CHAR 12 0PINCR PINCR NUMC 5 0LPONR LPONR NUMC 5 0LIFNR ELIFN CHAR 10 0SPRAS SPRAS LANG 1 0ZTERM DZTERM CHAR 4 0ZBD1T DZBDET DEC 3 0ZBD2T DZBDET DEC 3 0ZBD3T DZBDET DEC 3 0ZBD1P DZBD1P DEC 5 3ZBD2P DZBD2P DEC 5 3EKORG EKORG CHAR 4 0EKGRP BKGRP CHAR 3 0WAERS WAERS CUKY 5 0WKURS WKURS DEC 9 5KUFIX KUFIX CHAR 1 0BEDAT EBDAT DATS 8 0KDATB KDATB DATS 8 0KDATE KDATE DATS 8 0BWBDT BWBDT DATS 8 0ANGDT ANGAB DATS 8 0BNDDT EBNDT DATS 8 0GWLDT MM_GWLDT DATS 8 0AUSNR AUSCH CHAR 10 0ANGNR ANGNR CHAR 10 0IHRAN IHRAN DATS 8 0IHREZ IHREZ CHAR 12 0VERKF EVERK CHAR 30 0TELF1 TELF0 CHAR 16 0LLIEF LLIEF CHAR 10 0KUNNR KUNNR CHAR 10 0KONNR KONNR CHAR 10 0ABGRU ABDUM CHAR 2 0AUTLF KMPLF CHAR 1 0WEAKT WEAKT CHAR 1 0RESWK RESWK CHAR 4 0LBLIF LBLIF CHAR 10 0INCO1 INCO1 CHAR 3 0INCO2 INCO2 CHAR 28 0KTWRT KTWRT CURR 15 2SUBMI SUBMI CHAR 10 0

Page 36: SAP Tables

KNUMV KNUMV CHAR 10 0KALSM KALSM_D CHAR 6 0STAFO STAFO CHAR 6 0LIFRE LIFRE CHAR 10 0EXNUM EXNUM CHAR 10 0UNSEZ UNSEZ CHAR 12 0LOGSY LOGSYSTEM CHAR 10 0UPINC UPINC NUMC 5 0STAKO STAKO CHAR 1 0FRGGR FRGGR CHAR 2 0FRGSX FRGSX CHAR 2 0FRGKE FRGKE CHAR 1 0FRGZU FRGZU CHAR 8 0FRGRL FRGRL CHAR 1 0LANDS LAND1_STML CHAR 3 0LPHIS LPHIS CHAR 1 0ADRNR AD_ADDRNUM CHAR 10 0STCEG_L STCEG_L CHAR 3 0STCEG STCEG CHAR 20 0ABSGR ABSGR NUMC 2 0ADDNR ADDI_BELNR CHAR 10 0KORNR KORNR CHAR 1 0MEMORY MEMER CHAR 1 0PROCSTAT MEPROCSTATE CHAR 2 0RLWRT RLWRT CURR 15 2REVNO REVNO CHAR 8 0SCMPROC SCMPROC CHAR 1 0REASON_CODE/SAPPSPRO/_GR_REASON_CODE CHAR 4 0.APPEND /ISDFPS/EKKODATA STRU 0 0.INCLUDE /ISDFPS/ST_FDP_REL STRU 0 0FORCE_ID /ISDFPS/FORCE_ID CHAR 32 0FORCE_CNT /ISDFPS/FORCE_CNT NUMC 6 0RELOC_ID /ISDFPS/RELOC_ID CHAR 10 0RELOC_SEQ_ID/ISDFPS/RELOC_SEQ_ID CHAR 4 0.APPEND OIA_EKKODATA STRU 0 0OIEXGNUM OIA_EXGNUM CHAR 10 0OIEXGTYP OIA_EXGTYP CHAR 4 0OIAEVGTYPE OIA_EVTYPE CHAR 1 0.APPEND OID_EXTD_EKKODATA STRU 0 0.INCLUDE OIC_PIPE STRU 0 0OIPIPEVAL OID_PIPEV CHAR 1 0OIC_LIFNR LIFNR CHAR 10 0.INCLUDE OIC_DEST_ORIG STRU 0 0OIC_DCITYC OIC_DCITYC CHAR 4 0OIC_DCOUNC OIC_DCOUNC CHAR 3 0OIC_DREGIO OIC_DREGIO CHAR 3 0OIC_DLAND1 OIC_DLAND1 CHAR 3 0OIC_OCITYC OIC_OCITYC CHAR 4 0OIC_OCOUNC OIC_OCOUNC CHAR 3 0OIC_OREGIO OIC_OREGIO CHAR 3 0OIC_OLAND1 OIC_OLAND1 CHAR 3 0OIC_PORGIN OIC_PORGIN CHAR 15 0OIC_PDESTN OIC_PDESTN CHAR 15 0OIC_PTRIP OIC_PTRIP CHAR 16 0

Page 37: SAP Tables

OIC_PBATCH OIC_PBATCH CHAR 16 0OIC_MOT OIC_MOT CHAR 2 0OIC_AORGIN OIC_AORGIN CHAR 15 0OIC_ADESTN OIC_ADESTN CHAR 15 0OIC_TRUCKN OIC_TRUCKN CHAR 10 0OIA_BASELO OIA_BASELO CHAR 15 0.INCLUDE OID_EX STRU 0 0OID_EXTBOL OID_EXTBOL CHAR 16 0OID_MISCDL OID_MISCDL CHAR 16 0.INCLUDE CI_EKKODB STRU 0 0ZZAEDAT ERDAT DATS 8 0ZZERNAM ERNAM CHAR 12 0ZTEXT CRMCHAR250 CHAR 250 0ZDOC DOKNR CHAR 25 0ZSTATU ESTAK CHAR 1 0.APPEND WRF_PBAS_EKKO_ADDON_STY STRU 0 0.INCLUDE WRF_POHF_EKKO_ADDON_STY STRU 0 0POHF_TYPE WRF_POHF_TYPE CHAR 1 0EQ_EINDT WRF_POHF_EQ_EINDT DATS 8 0EQ_WERKS WRF_POHF_EQ_EWERK CHAR 4 0FIXPO WRF_POHF_FIXPO CHAR 1 0.INCLUDE WRF_POHF_GROUP_CRITERIA_STY STRU 0 0EKGRP_ALLOWWRF_POHF_EKGRP_ALLOW CHAR 1 0WERKS_ALLOWWRF_POHF_WERKS_ALLOW CHAR 1 0CONTRACT_AL WRF_POHF_CONTRACT_ALLOW CHAR 1 0PSTYP_ALLOW WRF_POHF_PSTYP_ALLOW CHAR 1 0FIXPO_ALLOW WRF_POHF_FIXPO_ALLOW CHAR 1 0KEY_ID_ALLOWWRF_POHF_KEY_ID_ALLOW CHAR 1 0AUREL_ALLOW WRF_POHF_AUREL_ALLOW CHAR 1 0DELPER_ALLOWWRF_POHF_DELPER_ALLOW CHAR 1 0EINDT_ALLOW WRF_POHF_EINDT_ALLOW CHAR 1 0.INCLUDE WRF_POTB_EKKO_ADDON_STY STRU 0 0OTB_LEVEL WRF_POTB_CHECK_LEVEL CHAR 1 0OTB_COND_TYPWRF_POTB_COND_TYPE CHAR 4 0.INCLUDE WRF_POTB_FEEDBACK_STY STRU 0 0KEY_ID WRF_BUDG_KEY_ID NUMC 16 0OTB_VALUE WRF_POTB_VALUE CURR 17 2.INCLUDE WRF_POTB_CURRENCY_STY STRU 0 0OTB_CURR WRF_POTB_CURRENCY CUKY 5 0OTB_RES_VALUWRF_POTB_RES_VALUE CURR 17 2OTB_SPEC_VALWRF_POTB_SPECIAL_VALUE CURR 17 2SPR_RSN_PROFWRF_POTB_SPR_RSN_PROFILE CHAR 4 0BUDG_TYPE WRF_BUDG_TYPE CHAR 2 0OTB_STATUS WRF_POTB_STATUS CHAR 1 0OTB_REASON WRF_POTB_STATUS_REASON CHAR 3 0CHECK_TYPE WRF_BUDG_OTB_CHECK CHAR 1 0.INCLUDE WRF_PCON_EKKO_ADDON_STY STRU 0 0CON_OTB_REQWRF_POTB_CON_REQ CHAR 1 0CON_PREBOOKWRF_POTB_PREBOOK_LEVEL CHAR 1 0CON_DISTR_LEWRF_POTB_DISTRIB_LEVEL CHAR 1 0

Page 38: SAP Tables

Short Description GroupClientPurchasing Document NumberPurchasing Document Header: Data PartCompany CodePurchasing Document CategoryPurchasing Document TypeControl indicator for purchasing document typeDeletion Indicator in Purchasing DocumentStatus of Purchasing DocumentDate on Which Record Was CreatedName of Person who Created the ObjectItem Number IntervalLast Item NumberVendor Account NumberLanguage KeyTerms of Payment KeyCash (Prompt Payment) Discount DaysCash (Prompt Payment) Discount DaysCash (Prompt Payment) Discount DaysCash Discount Percentage 1Cash Discount Percentage 2Purchasing OrganizationPurchasing GroupCurrency KeyExchange RateIndicator: Fixing of Exchange RatePurchasing Document DateStart of Validity PeriodEnd of Validity PeriodClosing Date for ApplicationsDeadline for Submission of Bid/QuotationBinding Period for QuotationWarranty DateBid invitation numberQuotation NumberQuotation Submission DateYour ReferenceResponsible Salesperson at Vendor's OfficeVendor's Telephone NumberSupplying VendorCustomer Number 1Number of Principal Purchase AgreementField Not UsedComplete Delivery Stipulated for Each Purchase OrderIndicator: Goods Receipt MessageSupplying (Issuing) Plant in Stock Transport OrderField not usedIncoterms (Part 1)Incoterms (Part 2)Cumulative Planned ValueCollective Number

Page 39: SAP Tables

Number of the document conditionProcedure (Pricing, Output Control, Acct. Det., Costing,...)Update group for statistics updateDifferent Invoicing PartyNumber of foreign trade data in MM and SD documentsOur ReferenceLogical SystemItem Number Interval for SubitemsDocument with time-dependent conditionsRelease groupRelease StrategyRelease Indicator: Purchasing DocumentRelease statusRelease Not Yet Completely EffectedCountry for Tax ReturnIndicator for scheduling agreement release documentationAddress numberCountry of Sales Tax ID NumberVAT Registration NumberReason for CancellationDocument number for additionalCorrection of miscellaneous provisionsPurchase order not yet completePurchasing document processing stateTotal value at time of releaseVersion number in PurchasingSCM Process That Created the Purchase OrderGoods Receipt Reason CodeAppend to EKKO for DFPSRelocation: Structure for Enhancing Logistics DocumentsInternal Key for Force ElementInternal (Version) CounterRelocation IDRelocation Step IDIS-Oil Exchanges append to structure EKKODATAExchange agreement numberExchange typeEvergreen typeIS-Oil ext.detals append to structure EKKODATAOrigin, Destination, Trip and ex Batch No for PipelineValidation indicator for pipeline fields (X=ON, blank=OFF)Account Number of Vendor or CreditorDestination/Origin: City,County,Region,Country + Tax OIC_DEST_ORIGDestination city codeDestination county codeDestination regionDestination countryOrigin city codeOrigin county codeOrigin regionOrigin countryTax originTax destinationPipeline trip number (external)

Page 40: SAP Tables

Pipeline operator´s external batch numberIS-OIL MAP external details mode of transportAlternate originAlternate destinationTruck numberBase locationExternal Bill of Lading and Misc. Deliv. NoExternal bill of ladingMiscellaneous delivery numberInclude Structure to Add Header Fields - OSS Note 364728Date on Which Record Was CreatedName of Person who Created the ObjectCharacter Field Length 250Document numberStatus of Purchasing DocumentEKKO Enhancement Seasonal Procurement: ProcurementEKKO Enhancement: PO Handling EKKO_POHFDocument for Seasonal Purchase Order ProcessingDelivery Date Header: All Items Have Same Delivery DatePlant Header: All Items Have Same Receiving PlantFirm Deal IndicatorStructure for Grouping Criteria GROUP_CRITERIATake Account of Purch. GroupTake Account of PlantsTake Account of ContractsTake Account of Item CategoriesTake Account of Fixed-Date Purchases IndicatorConsider BudgetTake Account of Alloc. Table RelevanceTake Account of Dlvy PeriodTake Account of Delivery DateEKKO Enhancement: OTB EKKO_POTBOTB Check LevelOTB Condition TypeOTB-Relevant DataUnique Number of BudgetRequired BudgetOTB CurrencyOTB CurrencyReserved Budget for OTB-Relevant Purchasing DocumentSpecial Release BudgetReason Profile for OTB Special ReleaseBudget TypeOTB Check StatusReason Indicator for OTB Check StatusType of OTB CheckAdd-On Data for Contracts EKKO_PCONOTB-Relevant ContractOTB Indicator Level for ContractsDistribution Using Target Value or Item Data

Page 41: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - EKPO

Field Data element Data TypeLength DecimalMANDT MANDT CLNT 3 0EBELN EBELN CHAR 10 0EBELP EBELP NUMC 5 0.INCLUDE EKPODATA STRU 0 0LOEKZ ELOEK CHAR 1 0STATU ASTAT CHAR 1 0AEDAT PAEDT DATS 8 0TXZ01 TXZ01 CHAR 40 0MATNR MATNR CHAR 18 0EMATN EMATNR CHAR 18 0BUKRS BUKRS CHAR 4 0WERKS EWERK CHAR 4 0LGORT LGORT_D CHAR 4 0BEDNR BEDNR CHAR 10 0MATKL MATKL CHAR 9 0INFNR INFNR CHAR 10 0IDNLF IDNLF CHAR 35 0KTMNG KTMNG QUAN 13 3MENGE BSTMG QUAN 13 3MEINS BSTME UNIT 3 0BPRME BBPRM UNIT 3 0BPUMZ BPUMZ DEC 5 0BPUMN BPUMN DEC 5 0UMREZ UMBSZ DEC 5 0UMREN UMBSN DEC 5 0NETPR BPREI CURR 11 2PEINH EPEIN DEC 5 0NETWR BWERT CURR 13 2BRTWR BBWERT CURR 13 2AGDAT ANGAB DATS 8 0WEBAZ WEBAZ DEC 3 0MWSKZ MWSKZ CHAR 2 0BONUS EBONU CHAR 2 0INSMK INSMK CHAR 1 0SPINF SPINF CHAR 1 0PRSDR PRSDR CHAR 1 0SCHPR SCHPR CHAR 1 0MAHNZ MAHNZ DEC 3 0MAHN1 MAHN1 DEC 3 0MAHN2 MAHN2 DEC 3 0MAHN3 MAHN3 DEC 3 0UEBTO UEBTO DEC 3 1UEBTK UEBTK CHAR 1 0UNTTO UNTTO DEC 3 1BWTAR BWTAR_D CHAR 10 0BWTTY BWTTY_D CHAR 1 0ABSKZ ABSKZ CHAR 1 0

Page 42: SAP Tables

AGMEM AGMEM CHAR 3 0ELIKZ ELIKZ CHAR 1 0EREKZ EREKZ CHAR 1 0PSTYP PSTYP CHAR 1 0KNTTP KNTTP CHAR 1 0KZVBR KZVBR CHAR 1 0VRTKZ VRTKZ CHAR 1 0TWRKZ TWRKZ CHAR 1 0WEPOS WEPOS CHAR 1 0WEUNB WEUNB CHAR 1 0REPOS REPOS CHAR 1 0WEBRE WEBRE CHAR 1 0KZABS KZABS CHAR 1 0LABNR LABNR CHAR 20 0KONNR KONNR CHAR 10 0KTPNR KTPNR NUMC 5 0ABDAT ABDAT DATS 8 0ABFTZ ABFTZ QUAN 13 3ETFZ1 ETFZ1 DEC 3 0ETFZ2 ETFZ2 DEC 3 0KZSTU MRPRE CHAR 1 0NOTKZ NOTKZ CHAR 1 0LMEIN LAGME UNIT 3 0EVERS EVERS CHAR 2 0ZWERT DZWERT CURR 13 2NAVNW NAVNW CURR 13 2ABMNG NORAM QUAN 13 3PRDAT PREDT DATS 8 0BSTYP BSTYP CHAR 1 0EFFWR EFFWR CURR 13 2XOBLR XOBLR CHAR 1 0KUNNR EKUNNR CHAR 10 0ADRNR ADRNR_MM CHAR 10 0EKKOL EKKOG CHAR 4 0SKTOF ESKTOF CHAR 1 0STAFO STAFO CHAR 6 0PLIFZ EPLIF DEC 3 0NTGEW ENTGE QUAN 13 3GEWEI EGEWE UNIT 3 0TXJCD TXJCD CHAR 15 0ETDRK ETDRK CHAR 1 0SOBKZ SOBKZ CHAR 1 0ARSNR ARSNR NUMC 10 0ARSPS ARSPS NUMC 4 0INSNC INSNC CHAR 1 0SSQSS QSSPUR CHAR 8 0ZGTYP QZGTYP CHAR 4 0EAN11 EAN11 CHAR 18 0BSTAE BSTAE CHAR 4 0REVLV REVLV CHAR 2 0

Page 43: SAP Tables

GEBER BP_GEBER CHAR 10 0FISTL FISTL CHAR 16 0FIPOS FIPOS CHAR 14 0KO_GSBER GSBER_GP CHAR 4 0KO_PARGB PARGB_GP CHAR 4 0KO_PRCTR PRCTR CHAR 10 0KO_PPRCTR PPRCTR CHAR 10 0MEPRF MEPRF CHAR 1 0BRGEW BRGEW QUAN 13 3VOLUM VOLUM QUAN 13 3VOLEH VOLEH UNIT 3 0INCO1 INCO1 CHAR 3 0INCO2 INCO2 CHAR 28 0VORAB VORAB CHAR 1 0KOLIF KOLIF CHAR 10 0LTSNR LTSNR CHAR 6 0PACKNO PACKNO NUMC 10 0FPLNR IPLNR CHAR 10 0GNETWR GNETWR CURR 13 2STAPO STAPO CHAR 1 0UEBPO UEBPO NUMC 5 0LEWED LEWED DATS 8 0EMLIF EMLIF CHAR 10 0LBLKZ LBLKZ CHAR 1 0SATNR SATNR CHAR 18 0ATTYP ATTYP CHAR 2 0KANBA KBNKZ CHAR 1 0ADRN2 ADRN2 CHAR 10 0CUOBJ CUOBJ NUMC 18 0XERSY XERSY CHAR 1 0EILDT EILDT DATS 8 0DRDAT DRDAT DATS 8 0DRUHR DRUHR TIMS 6 0DRUNR DRUNR NUMC 4 0AKTNR WAKTION CHAR 10 0ABELN ABELN CHAR 10 0ABELP ABELP NUMC 5 0ANZPU ANZPU QUAN 13 3PUNEI PUNEI UNIT 3 0SAISO SAISO CHAR 4 0SAISJ SAISJ CHAR 4 0EBON2 EBON2 CHAR 2 0EBON3 EBON3 CHAR 2 0EBONF EBONY CHAR 1 0MLMAA CK_ML_MAAC CHAR 1 0MHDRZ MHDRZ DEC 4 0ANFNR ANFNR CHAR 10 0ANFPS ANFPS NUMC 5 0KZKFG KZCUH CHAR 1 0USEQU USEQU CHAR 1 0

Page 44: SAP Tables

UMSOK UMSOK CHAR 1 0BANFN BANFN CHAR 10 0BNFPO BNFPO NUMC 5 0MTART MTART CHAR 4 0UPTYP UPTYP CHAR 1 0UPVOR UPVOR CHAR 1 0KZWI1 KZWI1 CURR 13 2KZWI2 KZWI2 CURR 13 2KZWI3 KZWI3 CURR 13 2KZWI4 KZWI4 CURR 13 2KZWI5 KZWI5 CURR 13 2KZWI6 KZWI6 CURR 13 2SIKGR SIKGR CHAR 3 0MFZHI MFZHI QUAN 15 3FFZHI FFZHI QUAN 15 3RETPO RETPO CHAR 1 0AUREL AUREL CHAR 1 0BSGRU BSGRU CHAR 3 0LFRET LFRET CHAR 4 0MFRGR MFRGR CHAR 8 0NRFHG NRFHG CHAR 1 0J_1BNBM J_1BNBMCO1 CHAR 16 0J_1BMATUSE J_1BMATUSE CHAR 1 0J_1BMATORG J_1BMATORG CHAR 1 0J_1BOWNPRO J_1BOWNPRO CHAR 1 0J_1BINDUST J_1BINDUS3 CHAR 2 0ABUEB ABUEB CHAR 4 0NLABD NLABD DATS 8 0NFABD NFABD DATS 8 0KZBWS KZBWS CHAR 1 0BONBA BONBA CURR 13 2FABKZ FABKZ CHAR 1 0J_1AINDXP J_1AINDXP CHAR 5 0J_1AIDATEP J_1AIDATEP DATS 8 0MPROF MPROF CHAR 4 0EGLKZ EGLKZ CHAR 1 0KZTLF KZTUL CHAR 1 0KZFME KZWSO CHAR 1 0RDPRF RDPRF CHAR 4 0TECHS TECHS CHAR 12 0CHG_SRV CHG_SRV CHAR 1 0CHG_FPLNR CHG_FPLNR CHAR 1 0MFRPN MFRPN CHAR 40 0MFRNR MFRNR CHAR 10 0EMNFR EMNFR CHAR 10 0NOVET NOVET CHAR 1 0AFNAM AFNAM CHAR 12 0TZONRC TSEGZONREC CHAR 6 0IPRKZ DATTP CHAR 1 0LEBRE LEBRE CHAR 1 0

Page 45: SAP Tables

BERID BERID CHAR 10 0XCONDITIONS XCONDITIONS CHAR 1 0APOMS APOMS CHAR 1 0CCOMP MMPUR_CCOMP CHAR 1 0GRANT_NBR GM_GRANT_NBR CHAR 20 0FKBER FKBER CHAR 16 0STATUS EPSTATU CHAR 1 0RESLO RESLO CHAR 4 0KBLNR KBLNR CHAR 10 0KBLPOS KBLPOS NUMC 3 0WEORA WEORA CHAR 1 0SRV_BAS_COMSRV_BAS_COM CHAR 1 0PRIO_URG PRIO_URG NUMC 2 0PRIO_REQ PRIO_REQ NUMC 3 0.INCLUDE /SPE/TPOP_CRM_DATA STRU 0 0SPE_ABGRU ABGRU CHAR 2 0SPE_CRM_SO /SPE/VBELN_CRM CHAR 10 0SPE_CRM_SO_I/SPE/POSNR_CRM NUMC 6 0SPE_CRM_REF_/SPE/REF_VBELN_CRM CHAR 35 0SPE_CRM_REF_/SPE/REF_POSNR_CRM CHAR 6 0SPE_CHNG_SYS/SPE/INB_CHNG_SYS CHAR 1 0SPE_INSMK_SR/SPE/INSMK_SRC CHAR 1 0SPE_CQ_CTRLT/SPE/CQ_CONTROL_TYPE CHAR 1 0SPE_CQ_NOCQ/SPE/CQ_NOCQ CHAR 1 0REASON_CODE/SAPPSPRO/_GR_REASON_CODE CHAR 4 0CQU_SAR CQU_SAR QUAN 15 3.APPEND /BEV1/NE_EKPODATA_A STRU 0 0/BEV1/NEGEN_I/BEV1/NEGEN_ITEM_FLAG CHAR 1 0/BEV1/NEDEPFR/BEV1/NEDEPFREE CHAR 1 0/BEV1/NESTRU /BEV1/NESTRUC_CAT CHAR 1 0.APPEND /CWM/EKPODATA STRU 0 0/CWM/WABWE WABWE CHAR 1 0.APPEND /ISDFPS/EKPO STRU 0 0ADVCODE /ISDFPS/ADVCODE CHAR 2 0.APPEND FMFG_EKPODATA STRU 0 0EXCPE EXCPE NUMC 2 0.APPEND OILEKPODATA STRU 0 0.INCLUDE OIC_PIPE STRU 0 0OIPIPEVAL OID_PIPEV CHAR 1 0OIC_LIFNR LIFNR CHAR 10 0.INCLUDE OIC_DEST_ORIG STRU 0 0OIC_DCITYC OIC_DCITYC CHAR 4 0OIC_DCOUNC OIC_DCOUNC CHAR 3 0OIC_DREGIO OIC_DREGIO CHAR 3 0OIC_DLAND1 OIC_DLAND1 CHAR 3 0OIC_OCITYC OIC_OCITYC CHAR 4 0OIC_OCOUNC OIC_OCOUNC CHAR 3 0OIC_OREGIO OIC_OREGIO CHAR 3 0OIC_OLAND1 OIC_OLAND1 CHAR 3 0OIC_PORGIN OIC_PORGIN CHAR 15 0

Page 46: SAP Tables

OIC_PDESTN OIC_PDESTN CHAR 15 0OIC_PTRIP OIC_PTRIP CHAR 16 0OIC_PBATCH OIC_PBATCH CHAR 16 0OIC_MOT OIC_MOT CHAR 2 0OIC_AORGIN OIC_AORGIN CHAR 15 0OIC_ADESTN OIC_ADESTN CHAR 15 0OIC_TRUCKN OIC_TRUCKN CHAR 10 0OIA_BASELO OIA_BASELO CHAR 15 0OITAXFROM OIH_TAXFRO CHAR 2 0OIHANTYP OIH_HANTYP CHAR 2 0OIPRICIE OIH_PRICIE CHAR 1 0OITAXTO OIH_TAXTO CHAR 2 0OITAXCON OIH_TAXCON CURR 13 2OITAXGRP OIH_TAXGRP CHAR 2 0OIOILCON OIH_OILCON DEC 5 2OIINEX OIH_INEX CHAR 2 0.INCLUDE OIA_INCDAT STRU 0 0OIEXGNUM OIA_EXGNUM CHAR 10 0OIEXGTYP OIA_EXGTYP CHAR 4 0OIFEETOT OIA_FEETOT CURR 13 2OIFEEDT OIA_FEEDT DATS 8 0OINETCYC OIA_NETCYC CHAR 1 0OIFERP OIA_FERP CHAR 1 0OIFEECH OIA_FEECH CHAR 1 0OIA_IPMVAT OIA_IPMVAT CHAR 1 0OIA_SPLTIV OIA_SPLTIV CHAR 1 0OIVATH DMBTR CURR 13 2OIVATF WRBTR CURR 13 2OISBREL OIA_SBREL NUMC 3 0OIBASPROD OIA_SBMAT CHAR 18 0.INCLUDE OIHBEFU STRU 0 0OITRKNR OIH_TRKNR CHAR 10 0OITRKJR OIH_TRKJR NUMC 4 0OIEXTNR OIH_EXTNR CHAR 18 0OIITMNR OIH_ITMNR NUMC 5 0OIFTIND OIH_FTIND CHAR 1 0OIPRIOP OIH_PRIOP CHAR 1 0OITRIND OIH_TRIND CHAR 1 0OIGHNDL OIH_GHNDL CHAR 1 0OIUMBAR OIH_UMBAR CHAR 10 0OITXCON1 OIH_TXCON1 CURR 13 2OITXCON2 OIH_TXCON2 CURR 13 2OITXCON3 OIH_TXCON3 CURR 13 2OITXCON4 OIH_TXCON4 CURR 13 2OITXCON5 OIH_TXCON5 CURR 13 2OITXCON6 OIH_TXCON6 CURR 13 2.INCLUDE OID_EX STRU 0 0OID_EXTBOL OID_EXTBOL CHAR 16 0OID_MISCDL OID_MISCDL CHAR 16 0OIMATCYC OIA_MATCYC NUMC 1 0

Page 47: SAP Tables

.APPEND OIOEKPODATA STRU 0 0

.INCLUDE ROIO_RN_EKPO STRU 0 0OIO_RFBLN OIO_RN_RFBLN CHAR 10 0OIO_RFBLP OIO_RN_RFBLP NUMC 5 0.INCLUDE CI_EKPODB STRU 0 0ZZREP ZMMD_REPAIR CHAR 3 0ZZSWP ZMMD_SERVICE CHAR 3 0ZZMBL ZMMD_MOVABLE CHAR 3 0ZZFMG MATKL CHAR 9 0REFSITE WREFSITE CHAR 4 0.APPEND WRF_PBAS_EKPO_ADDON_STY STRU 0 0.INCLUDE WRF_PSCD_EKPO_ADDON_STY STRU 0 0REF_ITEM WRF_PSCD_REF_ITEM NUMC 5 0.INCLUDE WRF_POHF_EKPO_ADDON_STY STRU 0 0.INCLUDE WRF_POHF_SOURCE_KEY_STY STRU 0 0SOURCE_ID WRF_POHF_SOURCE_ID CHAR 3 0SOURCE_KEY WRF_POHF_SOURCE_KEY CHAR 32 0PUT_BACK WRF_POHF_PUT_BACK_POG CHAR 1 0POL_ID WRF_POHF_POL_ID CHAR 10 0.INCLUDE WRF_CONSIGNMENT STRU 0 0CONS_ORDER WRF_CONS_ORDER CHAR 1 0

Page 48: SAP Tables

Short Description GroupClientPurchasing Document NumberItem Number of Purchasing DocumentPurchasing Document Item: Data PartDeletion Indicator in Purchasing DocumentRFQ statusPurchasing Document Item Change DateShort TextMaterial NumberMaterial NumberCompany CodePlantStorage LocationRequirement Tracking NumberMaterial GroupNumber of Purchasing Info RecordMaterial Number Used by VendorTarget QuantityPurchase Order QuantityPurchase Order Unit of MeasureOrder Price Unit (Purchasing)Numerator for Conversion of Order Price Unit into Order UnitDenominator for Conv. of Order Price Unit into Order UnitNumerator for Conversion of Order Unit to Base UnitDenominator for Conversion of Order Unit to Base UnitNet Price in Purchasing Document (in Document Currency)Price UnitNet Order Value in PO CurrencyGross order value in PO currencyDeadline for Submission of Bid/QuotationGoods Receipt Processing Time in DaysSales Tax CodeSettlement Group 1 (Purchasing)Stock TypeIndicator: Update Info RecordPrice PrintoutIndicator: Estimated PriceNumber of Reminders/ExpeditersNumber of Days for First Reminder/ExpediterNumber of Days for Second Reminder/ExpediterNumber of Days for Third Reminder/ExpediterOverdelivery Tolerance LimitIndicator: Unlimited Overdelivery AllowedUnderdelivery Tolerance LimitValuation TypeValuation CategoryRejection Indicator

Page 49: SAP Tables

Internal Comment on QuotationDelivery Completed IndicatorFinal Invoice IndicatorItem Category in Purchasing DocumentAccount Assignment CategoryConsumption PostingDistribution Indicator for Multiple Account AssignmentPartial Invoice IndicatorGoods Receipt IndicatorGoods Receipt, Non-ValuatedInvoice Receipt IndicatorIndicator: GR-Based Invoice VerificationOrder Acknowledgment RequirementOrder Acknowledgment NumberNumber of Principal Purchase AgreementItem Number of Principal Purchase AgreementReconciliation Date for Agreed Cumulative QuantityAgreed Cumulative QuantityFirm Zone (Go-Ahead for Production)Trade-Off Zone (Go-Ahead for Materials Procurement)Firm/Trade-Off Zones Binding with Regard to Mat. PlanningExclusion in Outline Agreement Item with Material ClassBase Unit of MeasureShipping InstructionsTarget Value for Outline Agreement in Document CurrencyNon-deductible input taxStandard release order quantityDate of Price DeterminationPurchasing Document CategoryEffective value of itemItem affects commitmentsCustomerManual address number in purchasing document itemCondition Group with VendorItem Does Not Qualify for Cash DiscountUpdate group for statistics updatePlanned Delivery Time in DaysNet WeightUnit of WeightTax JurisdictionIndicator: Print-relevant schedule lines existSpecial Stock IndicatorSettlement reservation numberItem number of the settlement reservationQuality inspection indicator cannot be changedControl Key for Quality Management in ProcurementCertificate TypeInternational Article Number (EAN/UPC)Confirmation Control KeyRevision Level

Page 50: SAP Tables

FundFunds CenterCommitment ItemBusiness area reported to the partnerassumed business area of the business partnerProfit CenterPartner Profit CenterPrice Determination (Pricing) Date ControlGross WeightVolumeVolume unitIncoterms (Part 1)Incoterms (Part 2)Advance procurement: project stockPrior VendorVendor SubrangePackage numberInvoicing plan numberCurrently not usedItem is statisticalHigher-Level Item in Purchasing DocumentsLatest Possible Goods ReceiptVendor to be supplied/who is to receive deliverySubcontracting vendorCross-Plant Configurable MaterialMaterial CategoryKanban IndicatorNumber of delivery addressConfiguration (internal object number)Evaluated Receipt Settlement (ERS)Start Date for GR-Based SettlementLast TransmissionTimeSequential NumberPromotionAllocation Table NumberItem number of allocation tableNumber of PointsPoints unitSeason CategorySeason YearSettlement Group 2 (Rebate Settlement, Purchasing)Settlement Group 3 (Rebate Settlement, Purchasing)Item Relevant to Subsequent (Period-End Rebate) SettlementMaterial ledger activated at material levelMinimum Remaining Shelf LifeRFQ NumberItem Number of RFQOrigin of ConfigurationQuota arrangement usage

Page 51: SAP Tables

Special Stock Indicator for Physical Stock TransferPurchase Requisition NumberItem Number of Purchase RequisitionMaterial TypeSubitem Category, Purchasing DocumentSubitems ExistSubtotal 1 from pricing procedure for conditionSubtotal 2 from pricing procedure for conditionSubtotal 3 from pricing procedure for conditionSubtotal 4 from pricing procedure for conditionSubtotal 5 from pricing procedure for conditionSubtotal 6 from pricing procedure for conditionProcessing key for sub-itemsMaximum Cumulative Material Go-Ahead QuantityMaximum Cumulative Production Go-Ahead QuantityReturns ItemRelevant to Allocation TableReason for OrderingDelivery Type for Returns to VendorsMaterial freight groupMaterial qualifies for discount in kindBrazilian NCM CodeUsage of the materialOrigin of the materialProduced in-houseMaterial CFOP categoryRelease Creation ProfileNext Forecast Delivery Schedule TransmissionNext JIT Delivery Schedule TransmissionValuation of Special StockRebate basis 1Indicator: Item Relevant to JIT Delivery SchedulesInflation IndexInflation Index DateManufacturer Part ProfileOutward Delivery Completed IndicatorPartial Delivery at Item Level (Stock Transfer)Units of measure usageRounding ProfileParameter Variant/Standard VariantConfiguration changedNo invoice for this item although not free of chargeManufacturer Part NumberNumber of a ManufacturerExternal manufacturer code name or numberItem blocked for SD deliveryName of Requisitioner/RequesterTime zone of recipient locationPeriod Indicator for Shelf Life Expiration DateIndicator for Service-Based Invoice Verification

Page 52: SAP Tables

MRP AreaConditions for item although no invoiceAPO as Planning SystemPosting Logic in the Case of Stock TransfersGrantFunctional AreaStatus of Purchasing Document ItemIssuing Storage Location for Stock Transport OrderDocument Number for Earmarked FundsEarmarked Funds: Document ItemAcceptance At OriginService-Based CommitmentRequirement UrgencyRequirement PriorityCRM data for TPOP processReason for rejection of quotations and sales ordersCRM Sales Order Number for TPOP ProcessCRM Sales Order Item Number in TPOP ProcessCRM Reference Order Number for TPOP ProcessCRM Reference Sales Order Item Number in TPOP ProcessLast Changer's System TypeStock Type of Source Storage Location in STOCQ Control TypeNo Transmission of Cumulative Quantities in SA ReleaseGoods Receipt Reason CodeCumulative Goods Receipts from Redirected Purchase OrdersEmpties Managment: EKPODATA EnhancementIndicator: Item Is GeneratedIndicator: Dependent Items Are Free of ChargeStructure Category for Material RelationshipAppend for EKPODATA (CWM)Indicator for GI-based goods receiptAppend to EKPO for DFPSAdvice CodeAdd on for Public SectorAcceptance Period Origin, Destination, Trip and ex Batch No for PipelineValidation indicator for pipeline fields (X=ON, blank=OFF)Account Number of Vendor or CreditorDestination/Origin: City,County,Region,Country + Tax OIC_DEST_ORIGDestination city codeDestination county codeDestination regionDestination countryOrigin city codeOrigin county codeOrigin regionOrigin countryTax origin

Page 53: SAP Tables

Tax destinationPipeline trip number (external)Pipeline operator´s external batch numberIS-OIL MAP external details mode of transportAlternate originAlternate destinationTruck numberBase locationExcise duty tax key for 'from' locationExcise Duty Handling Type - Denotes Use of MaterialED pricing: external (indicator)Excise duty tax key for 'to' locationExcise duty tax from pricing conditionsExcise duty tax group for material(s)Oil content in a material as a percentageCode for internal or external excise duty rate determinationExchanges structure to be included in Core tablesExchange agreement numberExchange typeFee totalFee pricing condition dateNetting cycle (FI blocking indicator)Fee repricing indicatorFee edit controlVAT on internally-posted materialIndicator for split invoice verificationAmount in Local CurrencyAmount in document currencySub product/ base product relevence indicatorBase product numberTRACKING FIELDS FOR 2 STEP TRANSFERSTracking numberTracking number yearExternal tracking numberTracking number item lineFinal transfer indicatorPrice options for gain calculationTransfer sign for plant-to-plant transfersGain handlingValuation type of issuing location for two-step transferExcise duty tax from pricing conditions: rate 1Excise duty tax from pricing conditions: rate 2Excise duty tax from pricing conditions: rate 3Excise duty tax from pricing conditions: rate 4Excise duty tax from pricing conditions: rate 5Excise duty tax from pricing conditions: rate 6External Bill of Lading and Misc. Deliv. NoExternal bill of ladingMiscellaneous delivery numberInvoicing cycle for purchase material costs

Page 54: SAP Tables

RLM AppendRLM Rental fields for EKPOReference document for mobilizationReference document item for mobilizationInclude Structure to Add PO Item FieldsRepairServiceMovableMaterial GroupReference Site For PurchasingEKPO Enhancement Seasonal Procurement: ProcurementEnhancement of Purchasing Document Item EKPO_PSCDReference Item for Remaining Qty CancellationEKPO Enhancement: PO Handling EKPO_POHFSource Sysetm and Source Key of RecordOrigin ProfileKey in Source SystemIndicator for Putting Back from Grouped PO DocumentOrder List Item NumberSeasonal Procurement: Include for Consignment Processing EKPO_CONSPurchase Order for Consignment

Page 55: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - LFA1

Field Data element Data TypeLength DecimalLIFNR LIFNR CHAR 10 13 0LAND1 LAND1_GP CHAR 3 16 0NAME1 NAME1_GP CHAR 35 51 0NAME2 NAME2_GP CHAR 35 86 0NAME3 NAME3_GP CHAR 35 121 0NAME4 NAME4_GP CHAR 35 156 0ORT01 ORT01_GP CHAR 35 191 0ORT02 ORT02_GP CHAR 35 226 0PFACH PFACH CHAR 10 236 0PSTL2 PSTL2 CHAR 10 246 0PSTLZ PSTLZ CHAR 10 256 0REGIO REGIO CHAR 3 259 0SORTL SORTL CHAR 10 269 0STRAS STRAS_GP CHAR 35 304 0ADRNR ADRNR CHAR 10 314 0MCOD1 MCDK1 CHAR 25 339 0MCOD2 MCDK2 CHAR 25 364 0MCOD3 MCDK3 CHAR 25 389 0.INCLUDE SI_LFA1 STRU 0 389 0ANRED ANRED CHAR 15 404 0BAHNS BAHNS CHAR 25 429 0BBBNR BBBNR NUMC 7 436 0BBSNR BBSNR NUMC 5 441 0BEGRU BRGRU CHAR 4 445 0BRSCH BRSCH CHAR 4 449 0BUBKZ BUBKZ NUMC 1 450 0DATLT DATLT CHAR 14 464 0DTAMS DTAMS CHAR 1 465 0DTAWS DTAWS CHAR 2 467 0ERDAT ERDAT_RF DATS 8 475 0ERNAM ERNAM_RF CHAR 12 487 0ESRNR ESRNR CHAR 11 498 0KONZS KONZS CHAR 10 508 0KTOKK KTOKK CHAR 4 512 0KUNNR KUNNR CHAR 10 522 0LNRZA LNRZA CHAR 10 532 0LOEVM LOEVM_X CHAR 1 533 0STCD1 STCD1 CHAR 16 552 0STCD2 STCD2 CHAR 11 563 0

TELBX TELBX CHAR 15 580 0TELF1 TELF1 CHAR 16 596 0TELF2 TELF2 CHAR 16 612 0TELFX TELFX CHAR 31 643 0TELTX TELTX CHAR 30 673 0TELX1 TELX1 CHAR 30 703 0PFORT PFORT_GP CHAR 35 840 0

Page 56: SAP Tables

Short DescriptionAccount Number of Vendor or CreditorCountry KeyName 1Name 2Name 3Name 4CityDistrictPO BoxP.O. Box Postal CodePostal CodeRegion (State, Province, County)Sort fieldHouse number and streetAddressSearch term for matchcode searchSearch term for matchcode searchSearch term for matchcode searchVendor Master (General Section)TitleTrain stationInternational location number (part 1)International location number (Part 2)Authorization GroupIndustry keyCheck digit for the international location numberData communication line no.Indicator for Data Medium ExchangeInstruction key for data medium exchangeDate on which the Record Was CreatedName of Person who Created the ObjectISR Subscriber NumberGroup keyVendor account groupCustomer Number 1Account Number of the Alternative PayeeCentral Deletion Flag for Master RecordTax Number 1Tax Number 2

Telebox numberFirst telephone numberSecond telephone numberFax NumberTeletex numberTelex numberPO Box city

Page 57: SAP Tables

Column Field Data element Data TypeLength Decimal Short Description3 MANDT MANDT CLNT 3 3 0 Client7 ZBUKR DZBUKR CHAR 4 7 0 Paying company code

12 HBKID HBKID CHAR 5 12 0 Short Key for a House Bank17 HKTID HKTID CHAR 5 17 0 ID for account details18 RZAWE DZLSCH CHAR 1 18 0 Payment Method31 CHECT CHECT CHAR 13 31 0 Check number44 CHECF CHECF CHAR 13 44 0 Check Number From52 LAUFD LAUFD DATS 8 52 0 Date on Which the Program Is to Be Run58 LAUFI LAUFI CHAR 6 58 0 Additional Identification68 LIFNR LIFNR CHAR 10 68 0 Account Number of Vendor or Creditor78 KUNNR KUNNR CHAR 10 78 0 Customer Number 194 EMPFG EMPFG CHAR 16 94 0 Payee code

104 UBHKT UBHKT CHAR 10 104 0 G/L Account Number for Our Bank Account / Bank Sub-Account114 VBLNR VBLNR CHAR 10 114 0 Document Number of the Payment Document118 GJAHR GJAHR NUMC 4 118 0 Fiscal Year126 ZALDT DZALDT DATS 8 126 0 Probable Payment Date (Cash Discount 1 Due)131 WAERS WAERS CUKY 5 131 0 Currency Key144 RWBTR RWBTR CURR 13 144 2 Amount Paid in the Payment Currency148 STRGB GSBER CHAR 4 148 0 Business Area156 PRIDT PRIDT DATS 8 156 0 Print Date162 PRITI PRITI TIMS 6 162 0 Print Time174 PRIUS PRIUS CHAR 12 174 0 Print User175 XMANU XMANU CHAR 1 175 0 X - Manual check176 XBANC XBANC CHAR 1 176 0 X - Paid Check184 BANCD BANCD DATS 8 184 0 Check encashment date192 EXTRD EXTRD DATS 8 192 0 Date of Extract Creation198 EXTRT EXTRT TIMS 6 198 0 Time of Extract Creation199 XBUKR XBUKR CHAR 1 199 0 X - Intercompany Payment214 ZANRE DZANRE CHAR 15 214 0 Title of the payee249 ZNME1 DZNME1 CHAR 35 249 0 Name of the payee284 ZNME2 DZNME1 CHAR 35 284 0 Name of the payee319 ZNME3 DZNME1 CHAR 35 319 0 Name of the payee354 ZNME4 DZNME1 CHAR 35 354 0 Name of the payee364 ZPSTL DZPSTL CHAR 10 364 0 Postal code of the payee399 ZORT1 DZORT1 CHAR 35 399 0 City of the payee434 ZSTRA DZSTRA CHAR 35 434 0 Street and house number of the payee444 ZPFAC DZPFAC CHAR 10 444 0 P.O. box of the payee447 ZLAND DZLAND CHAR 3 447 0 Country Key450 ZREGI DZREGI CHAR 3 450 0 Regional code of the payee453 ZBNKS DZBNKS CHAR 3 453 0 Country Key471 ZBNKN DZBNKN CHAR 18 471 0 Bank account number of the payee486 ZBNKL DZBNKL CHAR 15 486 0 Bank number of the payee's bank488 ZBKON DZBKON CHAR 2 488 0 Bank Control Key of the Payee's Bank490 VOIDR VOIDR NUMC 2 490 0 Check void reason code498 VOIDD VOIDD DATS 8 498 0 Voided Check Date510 VOIDU VOIDU CHAR 12 510 0 Voided check user523 CHECV CHECV CHAR 13 523 0 Replacement check number528 HBKIV HBKIV CHAR 5 528 0 Replacement check bank533 HKTIV HKTIV CHAR 5 533 0 Replacement check account543 ZPST2 DZPST2 CHAR 10 543 0 P.O. box postal code of the payee544 XRAGL XRAGL CHAR 1 544 0 Indicator: Clearing was Reversed552 PERNR PERNR_D NUMC 8 552 0 Personnel Number557 SEQNR SEQC5 CHAR 5 557 0 Sequence Number558 BTZNR BTZNR RAW 1 558 0 Assignment of Transfers568 REC_BELNR BELNR_D CHAR 10 568 0 Accounting Document Number572 REC_GJAHR GJAHR NUMC 4 572 0 Fiscal Year607 ZPFOR PFORT_Z CHAR 35 607 0 City of payee's PO box609 UZAWE UZAWE CHAR 2 609 0 Payment Method Supplement610 ICHEC ICHEC CHAR 1 610 0 Type of Payment Medium (Stored in Payment Register)611 IREFE ICREF CHAR 1 611 0 Information as to Whether a Reference to this Payment Exists611 .INCLUDE SI_PAYR STRU 0 611 0 Payment Medium File624 RWSKT RWSKT CURR 13 624 2 Total Cash Discount for the Pmnt Transactn in Pmnt Currency

Page 58: SAP Tables

TABLE DEFINITIONS FOR AUDIT ANALYSIS - REGUH

Field Data element Data TypeLength DecimalMANDT MANDT CLNT 3 0LAUFD LAUFD DATS 8 0LAUFI LAUFI CHAR 6 0XVORL XVORL CHAR 1 0ZBUKR DZBUKR CHAR 4 0LIFNR LIFNR CHAR 10 0KUNNR KUNNR CHAR 10 0EMPFG EMPFG CHAR 16 0VBLNR VBLNR CHAR 10 0AVISG AVISG CHAR 1 0WAERS WAERS CUKY 5 0SRTGB GSBER CHAR 4 0ANRED ANRED CHAR 15 0NAME1 NAME1_GP CHAR 35 0NAME2 NAME2_GP CHAR 35 0NAME3 NAME3_GP CHAR 35 0NAME4 NAME4_GP CHAR 35 0PSTLZ PSTLZ CHAR 10 0ORT01 ORT01_GP CHAR 35 0STRAS STRAS_GP CHAR 35 0PFACH PFACH CHAR 10 0LAND1 LAND1 CHAR 3 0STCD1 STCD1 CHAR 16 0WEVWV WEVWV CHAR 1 0ZANRE DZANRE CHAR 15 0ZNME1 DZNME1 CHAR 35 0ZNME2 DZNME1 CHAR 35 0ZNME3 DZNME1 CHAR 35 0ZNME4 DZNME1 CHAR 35 0ZPSTL DZPSTL CHAR 10 0ZORT1 DZORT1 CHAR 35 0ZSTRA DZSTRA CHAR 35 0ZPFAC DZPFAC CHAR 10 0ZLAND DZLAND CHAR 3 0ZREGI DZREGI CHAR 3 0ZBNKS DZBNKS CHAR 3 0ZBNKN DZBNKN CHAR 18 0ZBNKL DZBNKL CHAR 15 0ZBKON DZBKON CHAR 2 0ZBVTY DZBVTY CHAR 4 0ZSWIF SWIFT CHAR 11 0XEZER XEZER CHAR 1 0ZSPRA DZSPRA LANG 1 0ZALDT DZALDT_ZHL DATS 8 0RZAWE RZAWE CHAR 1 0RUMSK RUMSK CHAR 1 0RZUMS RZUMS CHAR 1 0HKTID HKTID CHAR 5 0HBKID HBKID CHAR 5 0HKTIW HKTIW CHAR 5 0HBKIW HBKIW CHAR 5 0

Page 59: SAP Tables

BVTYP BVTYP CHAR 4 0UBKON UBKON CHAR 2 0UBKNT UBKNT CHAR 18 0UBNKS BANKS CHAR 3 0UBNKL UBNKL CHAR 15 0UBHKT UBHKT CHAR 10 0VALUT VALUT DATS 8 0CRVAL PRQ_CRVAL DATS 8 0ANFAE ANFAE DATS 8 0WEFAE WEFAE DATS 8 0RBETR RBETR CURR 13 2RSKON RSKON CURR 13 2RWBTR RWBTR CURR 13 2RWSKT RWSKT CURR 13 2RSPE1 SPES1 CURR 11 2RSPE2 SPES2 CURR 11 2RPOST RPOST DEC 5 0RTEXT RTEXT_D DEC 5 0RSPM1 SPEM1 CURR 11 2RSPM2 SPEM2 CURR 11 2WEHMX WEHMX CURR 13 2WEFMX WEFMX CURR 13 2WEHRS WEHRS CURR 13 2WEFRS WEFRS CURR 13 2WEAMX WEAMX DEC 3 0BUSAB BUSAB CHAR 2 0EIKTO EIKTO CHAR 12 0XINVE XINVE CHAR 1 0WDATE WDATE DATS 8 0XAEND XAEND_REGU CHAR 1 0ZLSPR DZLSPR CHAR 1 0DTAWS DTAWS CHAR 2 0DTAMS DTAMS CHAR 1 0KURSF KURSF DEC 9 5ABWAE ABWAE CUKY 5 0SKVHW SKVHW CURR 13 2SKVFW SKVFW CURR 13 2DSKVH DSKVH CURR 13 2ZPST2 DZPST2 CHAR 10 0PAYGR PAYGR CHAR 20 0ZBNKY DZBNKY CHAR 15 0UBNKY UBNKY CHAR 15 0PSTL2 PSTL2 CHAR 10 0ABSBU ABSBU CHAR 4 0RBET2 RBET2 CURR 13 2RBET3 RBET3 CURR 13 2RSKO2 RSKO2 CURR 13 2RSKO3 RSKO3 CURR 13 2KURS2 KURS2 DEC 9 5KURS3 KURS3 DEC 9 5BKREF BKREF CHAR 20 0UZAWE UZAWE CHAR 2 0ZORT2 ORT02_Z CHAR 35 0ZTLFX TELFX_Z CHAR 31 0

Page 60: SAP Tables

XSIWE XSIWE CHAR 1 0ZPFOR PFORT_Z CHAR 35 0PERNR PERNR_D NUMC 8 0SEQNR SEQC5 CHAR 5 0BTZNR BTZNR RAW 1 0AUSFD AUSFD DATS 8 0EDIAV EDIAV CHAR 1 0IDOC_NUM_AVIEDI_DOCNUM NUMC 16 0EDIBN EDIBN CHAR 1 0IDOC_NUM EDI_DOCNUM NUMC 16 0ZTELF TELFN_Z CHAR 20 0ZTELX TELEX_Z CHAR 30 0KOINH KOINH_FI CHAR 60 0DTWS1 DTAT16 NUMC 2 0DTWS2 DTAT17 NUMC 2 0DTWS3 DTAT18 NUMC 2 0DTWS4 DTAT19 NUMC 2 0ZSTC1 STCD1_Z CHAR 16 0KIDNO KIDNO CHAR 30 0PYORD PYORD CHAR 10 0REGIO REGIO CHAR 3 0TEXT TEXT CHAR 29 0BTYP1 BNTYP CHAR 1 0BNKS1 BANKS CHAR 3 0BNKL1 BANKK CHAR 15 0BNKN1 BANKN CHAR 18 0BKON1 BKONT CHAR 2 0BKRF1 BKREF CHAR 20 0BTYP2 BNTYP CHAR 1 0BNKS2 BANKS CHAR 3 0BNKL2 BANKK CHAR 15 0BNKN2 BANKN CHAR 18 0BKON2 BKONT CHAR 2 0BKRF2 BKREF CHAR 20 0BTYP3 BNTYP CHAR 1 0BNKS3 BANKS CHAR 3 0BNKL3 BANKK CHAR 15 0BNKN3 BANKN CHAR 18 0BKON3 BKONT CHAR 2 0BKRF3 BKREF CHAR 20 0SAKNR SAKNR CHAR 10 0HKONT HKONT CHAR 10 0ALEBN ALEBN CHAR 1 0XKDFB XKDFB_042E CHAR 1 0SRTBP BUPLA CHAR 4 0.INCLUDE IREGUH_FPM STRU 0 0FPM_KEY FPM_KEY CHAR 15 0GRPNO GRPNO_FPM INT4 10 0SRTF1 SRTF1N_FPM CHAR 38 0SRTF2 SRTF2N_FPM CHAR 56 0XCORR XCORR_FPM CHAR 1 0XAVIS XAVIS_FPM CHAR 1 0XCOPM XCOPM_FPM CHAR 1 0DORIGIN FIBL_DORIGIN CHAR 8 0

Page 61: SAP Tables

RFTTRN RFTTRN_BF CHAR 20 0ZADNR ADRNR_Z CHAR 10 0ADRNR AD_ADDRNUM CHAR 10 0ZIBAN DZIBAN CHAR 34 0.APPEND REGUH_FM STRU 0 0FM_STATUS FM_PAY_STA CHAR 1 0.APPEND REGUH_FMFG STRU 0 0FILE_NBR FMFG_FILE_NO NUMC 6 0

Page 62: SAP Tables

Short DescriptionClientDate on Which the Program Is to Be RunAdditional IdentificationIndicator: Only Proposal Run?Paying company codeAccount Number of Vendor or CreditorCustomer Number 1Payee codeDocument Number of the Payment DocumentReason for Printing Payment AdviceCurrency KeyBusiness AreaTitleName 1Name 2Name 3Name 4Postal CodeCityHouse number and streetPO BoxCountry KeyTax Number 1Planned usage of the bill of exchangeTitle of the payeeName of the payeeName of the payeeName of the payeeName of the payeePostal code of the payeeCity of the payeeStreet and house number of the payeeP.O. box of the payeeCountry KeyRegional code of the payeeCountry KeyBank account number of the payeeBank number of the payee's bankBank Control Key of the Payee's BankBank Data Indicator for the PayeeSWIFT Code for International PaymentsIndicator: Is there collection authorization ?Language key of the payeePosting date of the payment documentPayment Method for This PaymentSpecial G/L Indicator of the Payment TransactionTarget Special G/L Indicator of the Payment TransactionID for account detailsShort Key for a House BankShort Key of the Account Data for the Bill of ExchangeShort Key of the House Bank for Bill/Exch.for Check/Bill/Ex.

Page 63: SAP Tables

Partner Bank TypeBank control key at our bankOur account number at the bankBank country keyBank number of our bankG/L Account Number for Our Bank Account / Bank Sub-AccountValue dateValue Date at Payee's BankBill of Exchange Payment Request Due DateBill of Exchange Due DateAmount in Local CurrencyTotal Cash Discount for the Payment Trans. (Local Currency)Amount Paid in the Payment CurrencyTotal Cash Discount for the Pmnt Transactn in Pmnt CurrencyForm ChargesForm ChargesNumber of Items PaidNumber of Text Lines for the Items PaidForm Charges for Bill of Exchange with Maximum AmountForm Charges for Bill of Exchange with Maximum AmountMaximum Amount per Bill of Exchange in Local CurrencyMaximum Amount per Bill of Exchange in Payment CurrencyRemaining Amount in Local Crcy for Last Bill of ExchangeRemaining Amount in Payment Crcy for Last Bill of ExchangeNumber of Bills of Exchange with Maximum AmountAccounting clerkShipper's (Our) Account Number at the Customer or VendorIndicator: Capital Goods Affected?Bill of Exchange Issue DateIndicator: Payment Proposal was Changed AfterwardsPayment Block KeyInstruction key for data medium exchangeIndicator for Data Medium ExchangeExchange rateSettlement currency for bank transfersLost Cash Discount in Local CurrencyLost Cash Discount in Payment CurrencyImpending Lost Cash Discount in Local CurrencyP.O. box postal code of the payeeGrouping Field for Automatic PaymentsBank key of the payee's bankBank key of our bankP.O. Box Postal CodeSending company codeAmount Paid in Second Local CurrencyAmount Paid in Third Local CurrencyPayment Transaction Total Discount in Second Local CurrencyPayment Transaction Total Discount in Third Local CurrencyExchange Rate for the Second Local CurrencyExchange Rate for the Third Local CurrencyReference specifications for bank detailsPayment Method SupplementLocation from payee's addressPayee's telefax number

Page 64: SAP Tables

Indicator: Bill on demandCity of payee's PO boxPersonnel NumberSequence NumberAssignment of TransfersDue date of the paid itemsEDI Payment Advice StatusIDoc numberEDI Payment Order StatusIDoc numberPayee telephone numberPayee telex numberAccount Holder NameInstruction key 1Instruction key 2Instruction key 3Instruction key 4Payee's tax number 1Payment ReferencePayment OrderRegion (State, Province, County)Text fieldType of bank in a bank chain (correspondent, intermediary)Bank country keyBank KeysBank account numberBank Control KeyReference specifications for bank detailsType of bank in a bank chain (correspondent, intermediary)Bank country keyBank KeysBank account numberBank Control KeyReference specifications for bank detailsType of bank in a bank chain (correspondent, intermediary)Bank country keyBank KeysBank account numberBank Control KeyReference specifications for bank detailsG/L Account NumberGeneral Ledger AccountALE IDoc Distribution Status of Payment DataDo not Post any Exchange Rate DifferencesBusiness PlaceRedundant Key Fields from REGUHRundate, ID, and Default Indicator ConcatenatedGrouping Criterium for PaymentsFormat-specific sorting of payments incl. sequence nuberUser-defined sorting of payments incl. sequence numberIndicator: Payment CorrespondenceIndicator: Separate Payment AdvicePayment Medium for Business Partner (Correspondence)Grouping Origin

Page 65: SAP Tables

Payment codePayee's Address NumberAddress numberIBAN of the PayeeBudget data section of payment dataAvailability Status for a PaymentU.S. Federal Government ISPSKey for multiple files from single Payment Program Print

Page 66: SAP Tables

Column Field Data element Data TypeLength Decimal Short Description3 MANDT MANDT CLNT 3 3 0 Client

11 LAUFD LAUFD DATS 8 11 0 Date on Which the Program Is to Be Run17 LAUFI LAUFI CHAR 6 17 0 Additional Identification18 XVORL XVORL CHAR 1 18 0 Indicator: Only Proposal Run?22 ZBUKR DZBUKR CHAR 4 22 0 Paying company code32 LIFNR LIFNR CHAR 10 32 0 Account Number of Vendor or Creditor42 KUNNR KUNNR CHAR 10 42 0 Customer Number 158 EMPFG EMPFG CHAR 16 58 0 Payee code68 VBLNR VBLNR CHAR 10 68 0 Document Number of the Payment Document72 BUKRS BUKRS CHAR 4 72 0 Company Code82 BELNR BELNR_D CHAR 10 82 0 Accounting Document Number86 GJAHR GJAHR NUMC 4 86 0 Fiscal Year89 BUZEI BUZEI NUMC 3 89 0 Number of Line Item Within Accounting Document99 FILKD FILKD CHAR 10 99 0 Account Number of the Branch

100 ZLSCH DZLSCH CHAR 1 100 0 Payment Method105 WAERS WAERS CUKY 5 105 0 Currency Key110 HBKID HBKID CHAR 5 110 0 Short Key for a House Bank114 BVTYP BVTYP CHAR 4 114 0 Partner Bank Type117 POKEN POKEN CHAR 3 117 0 Item Indicator133 XBLNR XBLNR1 CHAR 16 133 0 Reference Document Number135 BLART BLART CHAR 2 135 0 Document Type143 BUDAT BUDAT DATS 8 143 0 Posting Date in the Document151 BLDAT BLDAT DATS 8 151 0 Document Date in Document152 KOART KOART CHAR 1 152 0 Account Type154 BSCHL BSCHL CHAR 2 154 0 Posting Key164 HKONT HKONT CHAR 10 164 0 General Ledger Account174 SAKNR SAKNR CHAR 10 174 0 G/L Account Number175 UMSKZ UMSKZ CHAR 1 175 0 Special G/L Indicator176 UMSKS UMSKS CHAR 1 176 0 Special G/L Transaction Type177 ZUMSK DZUMSK CHAR 1 177 0 Target Special G/L Indicator178 SHKZG SHKZG CHAR 1 178 0 Debit/Credit Indicator191 DMBTR DMBTR CURR 13 191 2 Amount in Local Currency204 WRBTR WRBTR CURR 13 204 2 Amount in document currency217 BDIFF BDIFF CURR 13 217 2 Valuation Difference221 GSBER GSBER CHAR 4 221 0 Business Area223 MWSKZ MWSKZ CHAR 2 223 0 Sales Tax Code236 MWSTS MWSTS CURR 13 236 2 Tax Amount in Local Currency249 WMWST WMWST CURR 13 249 2 Tax amount in document currency251 MWSK1 MWSKX CHAR 2 251 0 Tax Code for Distribution264 DMBT1 DMBTX CURR 13 264 2 Amount in Local Currency for Tax Distribution277 WRBT1 WRBTX CURR 13 277 2 Amount in foreign currency for tax breakdown279 MWSK2 MWSKX CHAR 2 279 0 Tax Code for Distribution292 DMBT2 DMBTX CURR 13 292 2 Amount in Local Currency for Tax Distribution305 WRBT2 WRBTX CURR 13 305 2 Amount in foreign currency for tax breakdown307 MWSK3 MWSKX CHAR 2 307 0 Tax Code for Distribution320 DMBT3 DMBTX CURR 13 320 2 Amount in Local Currency for Tax Distribution333 WRBT3 WRBTX CURR 13 333 2 Amount in foreign currency for tax breakdown383 SGTXT SGTXT CHAR 50 383 0 Item Text391 ZFBDT DZFBDT DATS 8 391 0 Baseline Date for Due Date Calculation395 ZTERM DZTERM CHAR 4 395 0 Terms of Payment Key398 ZBD1T DZBD1T DEC 3 398 0 Cash discount days 1401 ZBD2T DZBD2T DEC 3 401 0 Cash discount days 2404 ZBD3T DZBD3T DEC 3 404 0 Net Payment Terms Period409 ZBD1P DZBD1P DEC 5 409 3 Cash Discount Percentage 1414 ZBD2P DZBD2P DEC 5 414 3 Cash Discount Percentage 2427 SKFBT SKFBT CURR 13 427 2 Amount Eligible for Cash Discount in Document Currency440 SKNTO SKNTO CURR 13 440 2 Cash discount amount in local currency453 WSKTO WSKTO CURR 13 453 2 Cash discount amount in document currency454 ZBFIX DZBFIX CHAR 1 454 0 Fixed Payment Terms455 ZLSPR DZLSPR CHAR 1 455 0 Payment Block Key456 SPLEV SPLEV CHAR 1 456 0 Level on Which a Payment Block has Taken Place457 XREBZ XREBZ CHAR 1 457 0 Indicator: Item is an Invoice-Related Credit Memo465 ZOLLT DZOLLT CHAR 8 465 0 Customs Tariff Number473 ZOLLD DZOLLD DATS 8 473 0 Customs Date476 LZBKZ LZBKZ CHAR 3 476 0 State Central Bank Indicator479 LANDL LANDL CHAR 3 479 0 Supplying Country480 DIEKZ DIEKZ CHAR 1 480 0 Service Indicator (Foreign Payment)482 QSSKZ QSSKZ CHAR 2 482 0 Withholding Tax Code495 QSSHB QSSHB CURR 13 495 2 Withholding Tax Base Amount508 QBSHB QBSHB CURR 13 508 2 Withholding Tax Amount (in Document Currency)521 QBSHH QBSHH CURR 13 521 2 Withholding Tax Amount (in Local Currency)532 ESRNR ESRNR CHAR 11 532 0 ISR Subscriber Number559 ESRRE ESRRE CHAR 27 559 0 ISR Reference Number561 ESRPZ ESRPZ CHAR 2 561 0 ISR Check Digit564 ZBDXT DZBDXT DEC 3 564 0 Selected cash discount days569 ZBDXP DZBDXP DEC 5 569 3 Selected cash discount percentage rate582 MSHBT MSHBT CURR 13 582 2 Maximum Cash Discount Amount in Local Currency595 MSFBT MSFBT CURR 13 595 2 Maximum Cash Discount Amount in Foreign Currency611 PROJN PROJN CHAR 16 611 0 Old: Project number : No longer used --> PS_POSNR623 AUFNR AUFNR CHAR 12 623 0 Order Number635 ANLN1 ANLN1 CHAR 12 635 0 Main Asset Number639 ANLN2 ANLN2 CHAR 4 639 0 Asset Subnumber649 EBELN EBELN CHAR 10 649 0 Purchasing Document Number654 EBELP EBELP NUMC 5 654 0 Item Number of Purchasing Document655 XANET XANET CHAR 1 655 0 Indicator: Down payment in net procedure ?656 XNETB XNETB CHAR 1 656 0 Indicator: Document posted net ?657 XNACH XNACH CHAR 1 657 0 Indicator: Document Data Must be Reread667 ZWELS DZWELS CHAR 10 667 0 List of the Payment Methods to be Considered673 VBUND RASSC CHAR 6 673 0 Company ID of trading partner693 STCEG STCEG CHAR 20 693 0 VAT Registration Number696 EGBLD EGBLD CHAR 3 696 0 Country of Destination for Delivery of Goods

Page 67: SAP Tables

699 EGLLD EGLLD CHAR 3 699 0 Supplying Country for Delivery of Goods709 QSZNR QSZNR CHAR 10 709 0 Certificate Number of the Withholding Tax Exemption722 BDIF2 BDIF2 CURR 13 722 2 Valuation Difference for the Second Local Currency735 DSKVH DSKVH CURR 13 735 2 Impending Lost Cash Discount in Local Currency736 POKLA POKLA CHAR 1 736 0 Item Classification for Online Check Printing750 FIPOS FIPOS CHAR 14 750 0 Commitment Item758 PROJK PS_PSP_PNR NUMC 8 758 0 Work Breakdown Structure Element (WBS Element)770 NPLNR NPLNR CHAR 12 770 0 Network Number for Account Assignment780 AUFPL CO_AUFPL NUMC 10 780 0 Routing number of operations in the order788 APLZL CIM_COUNT NUMC 8 788 0 Internal counter789 XEGDR XEGDR CHAR 1 789 0 Indicator: Triangular deal within the EU ?802 BDIF3 BDIF3 CURR 13 802 2 Valuation Difference for the Third Local Currency815 DMBE2 DMBE2 CURR 13 815 2 Amount in Second Local Currency828 DMBE3 DMBE3 CURR 13 828 2 Amount in Third Local Currency841 MWST2 MWST2 CURR 13 841 2 Tax Amount in Second Local Currency854 SKNT2 SKNT2 CURR 13 854 2 Cash Discount Amount in Second Local Currency867 SKNT3 SKNT3 CURR 13 867 2 Cash Discount Amount in Third Local Currency880 QBSH2 QBSH2 CURR 13 880 2 Withholding Tax Amount in Second Local Currency893 QBSH3 QBSH3 CURR 13 893 2 Withholding Tax Amount in Third Local Currency906 DMB21 DMB2X CURR 13 906 2 Amount in Second Local Currency for Tax Breakdown919 DMB22 DMB2X CURR 13 919 2 Amount in Second Local Currency for Tax Breakdown932 DMB23 DMB2X CURR 13 932 2 Amount in Second Local Currency for Tax Breakdown945 DMB31 DMB3X CURR 13 945 2 Amount in Third Local Currency for Tax Breakdown958 DMB32 DMB3X CURR 13 958 2 Amount in Third Local Currency for Tax Breakdown971 DMB33 DMB3X CURR 13 971 2 Amount in Third Local Currency for Tax Breakdown973 UZAWE UZAWE CHAR 2 973 0 Payment Method Supplement986 MWST3 MWST3 CURR 13 986 2 Tax Amount in Third Local Currency

1004 ZUONR DZUONR CHAR 18 1004 0 Assignment Number1017 OSKTO SKNTO CURR 13 1017 2 Cash discount amount in local currency1030 VERTN RANL CHAR 13 1030 0 Contract Number1038 IMKEY IMKEY CHAR 8 1038 0 Internal Key for Real Estate Object1039 REBZT REBZT CHAR 1 1039 0 Follow-On Document Type1049 REBZG REBZG CHAR 10 1049 0 Number of the Invoice the Transaction Belongs to1053 REBZJ REBZJ NUMC 4 1053 0 Fiscal Year of the Relevant Invoice (for Credit Memo)1056 REBZZ REBZZ NUMC 3 1056 0 Line Item in the Relevant Invoice1066 KOSTL KOSTL CHAR 10 1066 0 Cost Center1067 XINVE XINVE CHAR 1 1067 0 Indicator: Capital Goods Affected?1077 VBEL2 VBELN_VA CHAR 10 1077 0 Sales Document1083 VPOS2 NUM06 NUMC 6 1083 0 Numeric field: Length 61085 ZEKKN DZEKKN NUMC 2 1085 0 Sequential Number of Account Assignment1091 POSN2 POSNR_VA NUMC 6 1091 0 Sales Document Item1095 ETEN2 ETENR NUMC 4 1095 0 Delivery Schedule Line Number1111 FISTL FISTL CHAR 16 1111 0 Funds Center1121 GEBER BP_GEBER CHAR 10 1121 0 Fund1129 DABRZ DABRBEZ DATS 8 1129 0 Reference Date for Settlement1133 KKBER KKBER CHAR 4 1133 0 Credit control area1143 EMPFB EMPFB CHAR 10 1143 0 Payee/Payer1153 PRCTR PRCTR CHAR 10 1153 0 Profit Center1165 XREF1 XREF1 CHAR 12 1165 0 Business partner reference key1177 XREF2 XREF2 CHAR 12 1177 0 Business partner reference key1197 XREF3 XREF3 CHAR 20 1197 0 Reference key for line item1199 ZINKZ DZINKZ CHAR 2 1199 0 Exempted from interest calculation1201 DTWS1 DTAT16 NUMC 2 1201 0 Instruction key 11203 DTWS2 DTAT17 NUMC 2 1203 0 Instruction key 21205 DTWS3 DTAT18 NUMC 2 1205 0 Instruction key 31207 DTWS4 DTAT19 NUMC 2 1207 0 Instruction key 41207 .INCLUDE REGUP_PRQ STRU 0 1207 0 Additional data for payment requests in REGUP1217 KEYNO PRQ_KEYNO CHAR 10 1217 0 Key Number for Payment Request1230 PAMTF PRQ_AMTFC CURR 13 1230 2 Payment Request Amount in Payment Currency1231 MANSP MANSP CHAR 1 1231 0 Dunning block1261 KIDNO KIDNO CHAR 30 1261 0 Payment Reference1262 XCPDD XCPDD CHAR 1 1262 0 Indicator: Address and bank data set individually1263 VERTT RANTYP CHAR 1 1263 0 Contract Type1267 VBEWA SBEWART CHAR 4 1267 0 Flow Type1272 AGZEI AGZEI DEC 5 1272 0 Clearing Item1277 PSWSL PSWSL CUKY 5 1277 0 Update Currency for General Ledger Transaction Figures1290 PSWBT PSWBT CURR 13 1290 2 Amount for Updating in General Ledger1303 PSSKT PSSKT CURR 13 1303 2 Cash Discount Deduction for the Item1304 XPYAM XPYAM CHAR 1 1304 0 Indicator: Payment Amount Predefined1317 GDIFF GDIFF CURR 13 1317 2 Total Exchange Rate Difference1330 GDIF2 GDIFF CURR 13 1330 2 Total Exchange Rate Difference1343 GDIF3 GDIFF CURR 13 1343 2 Total Exchange Rate Difference1347 BUPLA BUPLA CHAR 4 1347 0 Business Place1351 SECCO SECCO CHAR 4 1351 0 Section Code1352 XSAEN XSAEN CHAR 1 1352 0 Indicator: Unconfirmed master data change1362 KBLNR KBLNR_FI CHAR 10 1362 0 Document Number for Earmarked Funds1365 KBLPOS KBLPOS NUMC 3 1365 0 Earmarked Funds: Document Item1373 ORIGIN FIBL_ORIGIN CHAR 8 1373 0 Origin Indicator1386 PENLC1 PENALTY1 CURR 13 1386 2 Penalty charge amount in first local currency1399 PENLC2 PENALTY2 CURR 13 1399 2 Penalty charge amount in second local currency1412 PENLC3 PENALTY3 CURR 13 1412 2 Penalty Charge Amount in Third Local Currency1425 PENFC PENALTY CURR 13 1425 2 Penalty charge amount in document currency1435 PENDAYS PDAYS INT4 10 1435 0 Number of days for penalty charge calculation1445 PPRCT PPRCTR CHAR 10 1445 0 Partner Profit Center1465 GRANT_NBR GM_GRANT_NBRCHAR 20 1465 0 Grant1481 FKBER FKBER CHAR 16 1481 0 Functional Area1516 SNAME1 NAME1_GP CHAR 35 1516 0 Name 11551 SORT01 ORT01_GP CHAR 35 1551 0 City1554 SLAND1 LAND1_GP CHAR 3 1554 0 Country Key