SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9/OPT/Z1344Reporting table: Text table for exception definitions
10FCO_DOC_HEAD61Failure Cost Document Header

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7JDT1124Journal Entry - Rows
8OPCH386A/P Invoice
9OPOR386Purchase Order
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Accounting - General :: Accounting Interface
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0GLE_FI_ITEM_MODF4861ECS: Modified FI Line Items (Header/Item/Currency Data)Accounting Interface
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, ITEM_ID, AWTYP, AWREF, AWORG, AWSYS, GLVOR, PROCESS, SUBSET, USNAM, TCODE, CPUDT, CPUTM, BKTXT, DOCID, BARCD, KNUMV, STATUS_NEW, STATUS_OLD, GRPID, ACC_PRINCIPLE, RLDNR, LDGRP, NOSPLIT, GLPROCESS, GLPROCVAR, EXCLUDE_FLAG, DBBLG, KURSX, KUR2X, KUR3X, POSNR, LOGVO, ISTAT, KSTAT, AWREF_REV, AWORG_REV, AWREF_REB, AWORG_REB, BUKRS_ORIG, BUKRS, BELNR, GJAHR, BUZEI, OBZEI, DOCLN, BLDAT, BUDAT, WWERT, VALUT, MONAT, BLART, XBLNR, XREF1, XREF2, XREF3, XREF1_HD, XREF2_HD, VORGN, PRVRG, PRVRG_SV, STBUK, XMWST, MWSKZ, KTOSL, KNUMH, TXJCD, TXDAT, KBETR, TXJDP, TXJLV, TAXPS, OLD_DOC_NUMBER, BUPLA, SECCO, XSKRL, ZUMSK, UMSKZ, BSTAT, BSCHL, SHKZG, PSWSL, PSWBT, PYCUR, PYAMT, KOART, KUNNR, LIFNR, SAKNR, HKONT, ALTKT, FILKD, XFILKD, LOKKT, GVTYP, GKOAR, GKONT, CACCT, LINETYPE, XSPLITMOD, ZTERM, ZFBDT, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, ZBFIX, UZAWE, ZLSCH, EMPFB, RSTGR, REBZG, REBZJ, REBZZ, REBZT, REBZG_CHECK, MABER, MSCHL, MADAT, MANST, MANSP, ZLSPR, ADRNR, STCEG, XEGDR, LZBKZ, LANDL, LAND1_ACNT, DIEKZ, SAMNR, ABPER, ZUONR, DTWS1, DTWS2, DTWS3, DTWS4, SGTXT, GSBER, KOSTL, LSTAR, KOKRS, PERNR, BPMNG, BPRME, AUFNR, ANLN1, ANLN2, BZDAT, ANBWA, WEBUD, RMVCT, ABUKR, AIBN1, AIBN2, MATNR, MENGE, MEINS, WERKS, BWART, PARGB, GSBER_GP, BUZID, HOART, HRKFT, HKMAT, IMKEY, KSTRG, PAOBJNR, PRZNR, PRCTR, PPRCTR, PROJK, PS_PSP_PNR, MAT_PSPNR, NPLNR, AUFPL, APLZL, AUFPS, FIKRS, FIPOS, FISTL, GEBER, KBLNR, KBLPOS, KBLTYP_EXT, KBLREF_EXT, KBLORG_EXT, KBLPOS_EXT, ERLKZ, LOTKZ, STTAX, STHTX, VBELN, KDAUF, KDPOS, MAT_KDAUF, MAT_KDPOS, KZVBR, KZBWS, SOBKZ, ZINKZ, VBUND, BWKEY, BWTAR, VNAME, EGRUP, BTYPE, EBELN, EBELP, ZEKKN, VPRSV, RECID, RECID_MAN, ETYPE, VPTNR, XBILK, XUMSW, TAXIT, XAUTO, FCVAL, BEKNZ, KZBEW, PSTYP, BUSTW, TBTKZ, XUMBW, SCOPE, AUTYP, XMFRW, ESRNR, ESRPZ, ESRRE, QSSKZ, BKLAS, BWMOD, MTART, EPRCTR, POSNR_SD, KSCHL, STUNR, ZAEHK, FKART, VTWEG, KUNAG, SPART, VKORG, VKBUR, VKGRP, FKDAT, FKTYP, FBUDA, AUBEL, AUPOS, FKIMG, VRKME, FKLMG, KAPPL, KNTYP, KURSK, KZZUAB, KINAK, NTGEW, BRGEW, GEWEI, VOLUM, VOLEH, VBTYP, VBEL2, POSN2, FDLEV, FDTAG, FDGRP, FDWBT, KZUML, XPKON, KOAID, XAKON, FKBER, AFABE, VERSA, WIP_CAT, XLIFO, ERFMG, ERFME, DABRZ, AUGDT, AUGCP, AUGBL, AGZEI, XNEGP, STGRD, CCINS, CCNUM, CCFOL, DATAB, DATBI, CCNAME, CSOUR, AUTWR, CCWAE, SETTL, AUNUM, AUTRA, AUDAT, AUTIM, MERCH, LOCID, TRMID, CCBTC, CCTYP, CCARD_GUID, KKBER, SHKZG_VA, SDSTR, POSAR, ANLO1, ANLO2, CONDI, BEMOT, ABSBT, KIDNO, BRNCH, NUMPG, ADISC, GRICD, GRIRG, GITYP, WT_KEY, XBGBB, VERTT, VERTN, VBEWA, BVTYP, HBKID, HKTID, NEBTR, MWSK1, DMBT1, MWSK2, DMBT2, MWSK3, DMBT3, ABWZE, BVTYPABW, BAPI_PARAM, BAPI_TABIX, CCACT, CO_KAKST, CO_KAAUF, CO_KAPRO, CO_KAKTR, CO_KANPL, CO_KAIMO, CO_KAKDA, CO_KAERG, CO_KAABS, CO_KAPRZ, CO_KASAT, ZZSPREG, ZZBUSPARTN, ZZPRODUCT, ZZLOCA, ZZCHAN, ZZLOB, ZZNFAL, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZREGION, ZZSTATE, BVALTNR, KALN1, AUFNR_ORG, CESSION_KZ, MLMAA, MLAST, ZEILE, URZEILE, MLBWG, MLNPRD, LSQTY, PRQTY, EKORG, VKWRT, UMMAT, UMWRK, KNTTP, UMSOK, UMWER, RRREL, MAT_LIFNR, XOBEW, TPKNZ, XINVE, KRUEK, AWTYP_REV, AWTYP_REB, VORNR, PGEBER, PENRC, GRANT_NBR, PGRANT_NBR, GMVKZ, SRTYPE, REINDAT, IDXSP, INTRENO, GLUPM, MEASURE, STBLG, HZUON, SEGMENT, PSEGMENT, PFKBER, PKOSTL, KSTAR, FLG_NOBUD, PPA_EX_IND, CASE_GUID_CORE, LONGNUM, STODT, BDGT_SUBTYPE, COHORT, PUBLAW, LEGIS, FMCMMTSTR, PRODPER, TCOBJNR, DATEOFSERVICE, NOTAXCORR, DIFFOPTRATE, HASDIFFOPTRATE, CURTP, WAERS, WRBTR, FWBAS, SKFBT, WSKTO, QSSHB, QSFBT, BUALT, KWERT, NAVBT, WMWST, CURRTYP, VALUTYP, GBETR, KURSR, WRBTR_FIX, WRBTR_AVG, CURT1, HWAER, DMBTR, KURSF, HWSTE, HWBAS, TXKRS, SKNTO, KZBTR, MWSTS, DMBTR_AVG, CURT2, HWAE2, DMBE2, KURS2, H2STE, SKNT2, MWST2, TXBH2, BASW2, UMRD2, KUTY2, DMBE2_AVG, CURT3, HWAE3, DMBE3, KURS3, H3STE, SKNT3, MWST3, TXBH3, BASW3, UMRD3, KUTY3, DMBE3_AVG FROM GLE_FI_ITEM_MODF
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2ITEM_IDID of Error Correction Itemvarbinary160RAWNoGLE_DTE_ECS_ITEM_ID
3AWTYPReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
4AWREFReference Document Numbernvarchar100CHAR(N' ')YesAWREF Allow NULL? 
5AWORGReference Organizational Unitsnvarchar100CHAR(N' ')YesAWORG Allow NULL? 
6AWSYSLogical Systemnvarchar100CHAR(N' ')Yes*LOGSYSTEM Allow NULL? 
7GLVORBusiness Transactionnvarchar40CHAR(N' ')YesGLVOR Allow NULL? 
8PROCESSTransaction for which CO interface is accessednvarchar80CHAR(N' ')YesPROCE Allow NULL? 
9SUBSETDefines subset of components for the FI/CO interfacenvarchar40CHAR(N' ')YesACC_SUBSET Allow NULL? 
10USNAMUser namenvarchar120CHAR(N' ')Yes*USNAM Allow NULL? 
11TCODETransaction Codenvarchar200CHAR(N' ')Yes*TCODE Allow NULL? 
12CPUDTDay On Which Accounting Document Was Enterednvarchar80DATS(N'00000000')YesCPUDT Allow NULL? 
13CPUTMTime of Entrynvarchar60TIMS(N'000000')YesCPUTM Allow NULL? 
14BKTXTDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
15DOCIDDocument typenvarchar100CHAR(N' ')Yes*SAEOBJART Allow NULL? 
16BARCDSAP ArchiveLink: Document IDnvarchar400CHAR(N' ')YesSAEARDOID Allow NULL? 
17KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
18STATUS_NEWNew Status of Transferred Documentchar10CHAR(N' ')YesACC_STATUS_NEW Allow NULL? 
19STATUS_OLDPrevious Status of Transferred Documentchar10CHAR(N' ')YesACC_STATUS_OLD Allow NULL? 
20GRPIDBatch Input Session Namenvarchar120CHAR(N' ')YesGRPID_BKPF Allow NULL? 
21ACC_PRINCIPLEAccounting Principlenvarchar40CHAR(N' ')Yes*ACCOUNTING_PRINCIPLE Allow NULL? 
22RLDNRLedgernvarchar20CHAR(N' ')Yes*RLDNR Allow NULL? 
23LDGRPLedger Groupnvarchar40CHAR(N' ')Yes*FAGL_LDGRP Allow NULL? 
24NOSPLITNew Input Valueschar10CHAR(N' ')YesXFLAG Allow NULL? 
25GLPROCESSBusiness Transactionnvarchar40CHAR(N' ')Yes*GLPROCESS Allow NULL? 
26GLPROCVARBusiness Transaction Variantnvarchar40CHAR(N' ')Yes*GLPROCVARI Allow NULL? 
27EXCLUDE_FLAGPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
28DBBLGRecurring Entry Document Numbernvarchar100CHAR(N' ')YesDBBLG Allow NULL? 
29KURSXMarket Data Exchange Ratedecimal2814DEC((0))YesGLE_FXR_DTE_RATEX28
30KUR2XMarket Data Exchange Rate 2decimal2814DEC((0))YesGLE_FXR_DTE_RATE2X28
31KUR3XMarket Data Exchange Rate 3decimal2814DEC((0))YesGLE_FXR_DTE_RATE3X28
32POSNRAccounting Document Line Item Numbernvarchar100NUMC(N'0000000000')YesPOSNR_ACC Allow NULL? 
33LOGVOLogical Transactionnvarchar60CHAR(N' ')YesLOGVO Allow NULL? 
34ISTATItem Historychar10CHAR(N' ')YesISTAT_ACC Allow NULL? 
35KSTATIndicator for Statistical Line Itemschar10CHAR(N' ')YesKSTAZ Allow NULL? 
36AWREF_REVReversal: Reverse Document Reference Document Numbernvarchar100CHAR(N' ')YesAWREF_REV Allow NULL? 
37AWORG_REVReversal: Reverse Document Reference Organizationnvarchar100CHAR(N' ')YesAWORG_REV Allow NULL? 
38AWREF_REBInvoice Reference: Document Number for Invoice Referencenvarchar100CHAR(N' ')YesAWREF_REB Allow NULL? 
39AWORG_REBInvoice reference: Reference organization for inv. referencenvarchar100CHAR(N' ')YesAWORG_REB Allow NULL? 
40BUKRS_ORIGSource Company Code from Cross-Company-Code Postingnvarchar40CHAR(N' ')Yes*GLE_DTE_ECS_ORIG_BUKRS Allow NULL? 
41BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
42BELNRAccounting Document Numbernvarchar100CHAR(N' ')YesBELNR_D Allow NULL? 
43GJAHRFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
44BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')YesBUZEI Allow NULL? 
45OBZEINumber of Line Item in Original Documentnvarchar30NUMC(N'000')YesOBZEI Allow NULL? 
46DOCLNSix-Character Posting Item for Ledgernvarchar60CHAR(N' ')YesDOCLN6 Allow NULL? 
47BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
48BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
49WWERTTranslation Datenvarchar80DATS(N'00000000')YesWWERT_D Allow NULL? 
50VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
51MONATFiscal Periodnvarchar20NUMC(N'00')YesMONAT Allow NULL? 
52BLARTDocument Typenvarchar20CHAR(N' ')Yes*BLART Allow NULL? 
53XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
54XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
55XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
56XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
57XREF1_HDReference Key 1 Internal for Document Headernvarchar200CHAR(N' ')YesXREF1_HD Allow NULL? 
58XREF2_HDReference Key 2 Internal for Document Headernvarchar200CHAR(N' ')YesXREF2_HD Allow NULL? 
59VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')YesVORGN Allow NULL? 
60PRVRGBusiness transaction for validationsnvarchar40CHAR(N' ')Yes*PRVRG Allow NULL? 
61PRVRG_SVBusiness transaction for status managementnvarchar40CHAR(N' ')Yes*PRVRG_SV Allow NULL? 
62STBUKTax Company Codenvarchar40CHAR(N' ')Yes*STBUK Allow NULL? 
63XMWSTCalculate tax automaticallychar10CHAR(N' ')YesXMWST Allow NULL? 
64MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
65KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
66KNUMHCondition record numbernvarchar100CHAR(N' ')YesKNUMH Allow NULL? 
67TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
68TXDATDate for defining tax ratesnvarchar80DATS(N'00000000')YesTXDAT Allow NULL? 
69KBETRRate (condition amount or percentage)decimal112CURR((0))YesKBETR
70TXJDPTax Jurisdiction Code - Jurisdiction for Lowest Level Taxnvarchar150CHAR(N' ')Yes*TXJCD_DEEP Allow NULL? 
71TXJLVTax jurisdiction code levelchar10CHAR(N' ')YesTXJCD_LEVEL Allow NULL? 
72TAXPSTax document item numbernvarchar60NUMC(N'000000')YesTAX_POSNR Allow NULL? 
73OLD_DOC_NUMBERTemporary document number when calculating taxesnvarchar100CHAR(N' ')Yes*OLD_DOC_NUMBER Allow NULL? 
74BUPLABusiness Placenvarchar40CHAR(N' ')Yes*BUPLA Allow NULL? 
75SECCOSection Codenvarchar40CHAR(N' ')Yes*SECCO Allow NULL? 
76XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
77ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')Yes*DZUMSK Allow NULL? 
78UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
79BSTATDocument Statuschar10CHAR(N' ')YesBSTAT_D Allow NULL? 
80BSCHLPosting Keynvarchar20CHAR(N' ')YesTBSLBSCHL Allow NULL? 
81SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
82PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')Yes*PSWSL Allow NULL? 
83PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
84PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')Yes*PYCUR Allow NULL? 
85PYAMTAmount in Payment Currencydecimal132CURR((0))YesPYAMT
86KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
87KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
88LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
89SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
90HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKB1HKONT Allow NULL? 
91ALTKTAccount Number in Groupnvarchar100CHAR(N' ')YesALTKT Allow NULL? 
92FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
93XFILKDIndicator: Break off branch/head office relationshipchar10CHAR(N' ')YesXFILKD Allow NULL? 
94LOKKTAccount Number in the Local Chart of Accountsnvarchar100CHAR(N' ')Yes*LOKKT Allow NULL? 
95GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
96GKOAROffsetting Account Typechar10CHAR(N' ')YesGKOAR Allow NULL? 
97GKONTOffsetting Account Numbernvarchar100CHAR(N' ')YesGKONT Allow NULL? 
98CACCTG/L offsetting acct numbernvarchar100CHAR(N' ')Yes*CACCT Allow NULL? 
99LINETYPEItem categorynvarchar50CHAR(N' ')Yes*LINETYPE Allow NULL? 
100XSPLITMODItem changed by document splittingchar10CHAR(N' ')YesXSPLITMOD Allow NULL? 
101ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
102ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
103ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
104ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
105ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
106ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
107ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
108ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
109UZAWEPayment Method Supplementnvarchar20CHAR(N' ')Yes*UZAWE Allow NULL? 
110ZLSCHPayment Methodchar10CHAR(N' ')Yes*DZLSCH Allow NULL? 
111EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
112RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')Yes*RSTGR Allow NULL? 
113REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
114REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
115REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
116REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
117REBZG_CHECKCheck Indicator for REBZG Checks in ACC Interfacechar10CHAR(N' ')YesREBZG_CHECK Allow NULL? 
118MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
119MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
120MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
121MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
122MANSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
123ZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
124ADRNRAddressnvarchar100CHAR(N' ')Yes*ADRNR Allow NULL? 
125STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
126XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
127LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
128LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL Allow NULL? 
129LAND1_ACNTCustomer/Vendor Countrynvarchar30CHAR(N' ')Yes*LAND1_ACNT Allow NULL? 
130DIEKZService Indicator (Foreign Payment)char10CHAR(N' ')YesDIEKZ Allow NULL? 
131SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
132ABPERSettlement periodnvarchar60ACCP(N' ')YesABPER_RF Allow NULL? 
133ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
134DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
135DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
136DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
137DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
138SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
139GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
140KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
141LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
142KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
143PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
144BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))YesBPMNG
145BPRMEOrder Price Unit (Purchasing)nvarchar30UNIT(N' ')Yes*BPRME Allow NULL? 
146AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
147ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
148ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
149BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
150ANBWAAsset Transaction Typenvarchar30CHAR(N' ')Yes*ANBWA Allow NULL? 
151WEBUDGoods receipt posting datenvarchar80DATS(N'00000000')YesWEBUD Allow NULL? 
152RMVCTTransaction Typenvarchar30CHAR(N' ')Yes*RMVCT Allow NULL? 
153ABUKRCompany Code which will be Cleared Againstnvarchar40CHAR(N' ')Yes*ABUKR Allow NULL? 
154AIBN1Original asset that was transferrednvarchar120CHAR(N' ')Yes*AIBN1 Allow NULL? 
155AIBN2Original asset that was transferrednvarchar40CHAR(N' ')Yes*AIBN2 Allow NULL? 
156MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
157MENGEQuantitydecimal133QUAN((0))YesMENGE_D
158MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
159WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
160BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')Yes*BWART Allow NULL? 
161PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
162GSBER_GPBusiness area reported to the partnernvarchar40CHAR(N' ')Yes*GSBER_GP Allow NULL? 
163BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
164HOARTType of origin object (EC-PCA)nvarchar20NUMC(N'00')YesHOART Allow NULL? 
165HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
166HKMATMaterial-related originchar10CHAR(N' ')YesHKMAT Allow NULL? 
167IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
168KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
169PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
170PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
171PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
172PPRCTRPartner Profit Centernvarchar100CHAR(N' ')Yes*PPRCTR Allow NULL? 
173PROJKProject Account Assignment (PS_PSP_PNR Batch Input Field)nvarchar240CHAR(N' ')YesPROJK_BI Allow NULL? 
174PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
175MAT_PSPNRValuated Sales Order Stock WBS Elementnvarchar80NUMC(N'00000000')Yes*MAT_PSPNR Allow NULL? 
176NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
177AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
178APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
179AUFPSOrder Item Numbernvarchar40NUMC(N'0000')YesCO_POSNR Allow NULL? 
180FIKRSFinancial Management Areanvarchar40CHAR(N' ')Yes*FIKRS Allow NULL? 
181FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
182FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
183GEBERFundnvarchar100CHAR(N' ')Yes*FM_FUND Allow NULL? 
184KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')Yes*KBLNR Allow NULL? 
185KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')Yes*KBLPOS Allow NULL? 
186KBLTYP_EXTEarmarked Funds: Reference Object Typenvarchar50CHAR(N' ')Yes*KBL_AWTYP Allow NULL? 
187KBLREF_EXTEarmarked Funds: Reference Document Numbernvarchar100CHAR(N' ')YesKBL_AWREF Allow NULL? 
188KBLORG_EXTEarmarked Funds: Reference Organization Unitsnvarchar100CHAR(N' ')YesKBL_AWORG Allow NULL? 
189KBLPOS_EXTEarmarked Funds: Reference Line Itemnvarchar100CHAR(N' ')YesKBL_AWPOS Allow NULL? 
190ERLKZCompletion indicator for line itemchar10CHAR(N' ')YesKBLERLKZ Allow NULL? 
191LOTKZLot Number for Documentsnvarchar100CHAR(N' ')YesLOTKZ Allow NULL? 
192STTAXTax amount as statistical information in document currencydecimal132CURR((0))YesSTTAX
193STHTXTax Amount as Statistical Information in Co. Code Currencydecimal132CURR((0))YesSTHTX
194VBELNSales and Distribution Document Numbernvarchar100CHAR(N' ')Yes*VBELN Allow NULL? 
195KDAUFSales Order Numbernvarchar100CHAR(N' ')Yes*KDAUF Allow NULL? 
196KDPOSItem Number in Sales Ordernvarchar60NUMC(N'000000')YesKDPOS Allow NULL? 
197MAT_KDAUFSales Order Number of Valuated Sales Order Stocknvarchar100CHAR(N' ')Yes*MAT_KDAUF Allow NULL? 
198MAT_KDPOSSales Order Item of Valuated Sales Order Stocknvarchar60NUMC(N'000000')YesMAT_KDPOS Allow NULL? 
199KZVBRConsumption Postingchar10CHAR(N' ')YesKZVBR Allow NULL? 
200KZBWSValuation of Special Stockchar10CHAR(N' ')YesKZBWS Allow NULL? 
201SOBKZSpecial Stock Indicatorchar10CHAR(N' ')Yes*SOBKZ Allow NULL? 
202ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
203VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
204BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
205BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
206VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
207EGRUPEquity groupnvarchar30CHAR(N' ')Yes*JV_EGROUP Allow NULL? 
208BTYPEPayroll Typenvarchar20CHAR(N' ')Yes*JV_BILIND Allow NULL? 
209EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
210EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
211ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
212VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
213RECIDRecovery Indicatornvarchar20CHAR(N' ')Yes*JV_RECIND Allow NULL? 
214RECID_MANIndicator: Recovery Indicator Set Manually.char10CHAR(N' ')YesJV_RECID_M Allow NULL? 
215ETYPEEquity typenvarchar30CHAR(N' ')Yes*JV_ETYPE Allow NULL? 
216VPTNRPartner account numbernvarchar100CHAR(N' ')Yes*JV_PART Allow NULL? 
217XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
218XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
219TAXITIndicator: Tax Itemchar10CHAR(N' ')YesTAXIT Allow NULL? 
220XAUTOIndicator: Line item automatically createdchar10CHAR(N' ')YesXAUTO Allow NULL? 
221FCVALIndicator: Line Item Contains Foreign Currency Valuationchar10CHAR(N' ')YesFCVAL Allow NULL? 
222BEKNZDebit/credit indicatorchar10CHAR(N' ')YesBEKNZ Allow NULL? 
223KZBEWMovement Indicatorchar10CHAR(N' ')YesKZBEW Allow NULL? 
224PSTYPItem Category in Purchasing Documentchar10CHAR(N' ')Yes*PSTYP Allow NULL? 
225BUSTWPosting string for valuesnvarchar40CHAR(N' ')YesBUSTW Allow NULL? 
226TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
227XUMBWRevaluationchar10CHAR(N' ')YesXUMBW Allow NULL? 
228SCOPEObject Classnvarchar20CHAR(N' ')YesSCOPE_CV Allow NULL? 
229AUTYPOrder categorynvarchar20NUMC(N'00')YesAUFTYP Allow NULL? 
230XMFRWIndicator: Update quantity in RWchar10CHAR(N' ')YesXMFRW Allow NULL? 
231ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
232ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
233ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
234QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
235BKLASValuation Classnvarchar40CHAR(N' ')Yes*BKLAS Allow NULL? 
236BWMODValuation Grouping Codenvarchar40CHAR(N' ')YesBWMOD Allow NULL? 
237MTARTMaterial Typenvarchar40CHAR(N' ')Yes*MTART Allow NULL? 
238EPRCTRPartner profit center for elimination of internal businessnvarchar100CHAR(N' ')Yes*EPRCTR Allow NULL? 
239POSNR_SDItem number of the SD documentnvarchar60NUMC(N'000000')Yes*POSNR Allow NULL? 
240KSCHLCondition typenvarchar40CHAR(N' ')Yes*KSCHA Allow NULL? 
241STUNRStep numbernvarchar30NUMC(N'000')Yes*STUNR Allow NULL? 
242ZAEHKCondition counternvarchar20NUMC(N'00')YesDZAEHK Allow NULL? 
243FKARTBilling Typenvarchar40CHAR(N' ')Yes*FKART Allow NULL? 
244VTWEGDistribution Channelnvarchar20CHAR(N' ')Yes*VTWEG Allow NULL? 
245KUNAGSold-to partynvarchar100CHAR(N' ')Yes*KUNAG Allow NULL? 
246SPARTDivisionnvarchar20CHAR(N' ')Yes*SPART Allow NULL? 
247VKORGSales Organizationnvarchar40CHAR(N' ')Yes*VKORG Allow NULL? 
248VKBURSales Officenvarchar40CHAR(N' ')Yes*VKBUR Allow NULL? 
249VKGRPSales Groupnvarchar30CHAR(N' ')Yes*VKGRP Allow NULL? 
250FKDATBilling date for billing index and printoutnvarchar80DATS(N'00000000')YesFKDAT Allow NULL? 
251FKTYPBilling categorychar10CHAR(N' ')YesFKTYP Allow NULL? 
252FBUDADate on which services renderednvarchar80DATS(N'00000000')YesFBUDA Allow NULL? 
253AUBELSales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
254AUPOSSales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
255FKIMGActual Invoiced Quantitydecimal133QUAN((0))YesFKIMG
256VRKMESales unitnvarchar30UNIT(N' ')Yes*VRKME Allow NULL? 
257FKLMGBilling quantity in stockkeeping unitdecimal133QUAN((0))YesFKLMG
258KAPPLApplicationnvarchar20CHAR(N' ')Yes*KAPPL Allow NULL? 
259KNTYPCondition category (examples: tax, freight, price, cost)char10CHAR(N' ')YesKNTYP Allow NULL? 
260KURSKExchange Rate for Price Determinationdecimal95DEC((0))YesKURSK
261KZZUABDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
262KINAKCondition is inactivechar10CHAR(N' ')YesKINAK Allow NULL? 
263NTGEWNet weightdecimal153QUAN((0))YesNTGEW_15
264BRGEWGross weightdecimal153QUAN((0))YesBRGEW_15
265GEWEIWeight Unitnvarchar30UNIT(N' ')Yes*GEWEI Allow NULL? 
266VOLUMVolumedecimal153QUAN((0))YesVOLUM_15
267VOLEHVolume unitnvarchar30UNIT(N' ')Yes*VOLEH Allow NULL? 
268VBTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
269VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
270POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
271FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
272FDTAGPlanning datenvarchar80DATS(N'00000000')YesFDTAG Allow NULL? 
273FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP Allow NULL? 
274FDWBTPlanning amount in document currencydecimal132CURR((0))YesFDWBT
275KZUMLStock transfer/transfer postingchar10CHAR(N' ')YesKZUML Allow NULL? 
276XPKONCheck account assignmentchar10CHAR(N' ')YesXPKON Allow NULL? 
277KOAIDCondition classchar10CHAR(N' ')YesKOAID Allow NULL? 
278XAKONIndicator: CO account assignment field filled automaticallychar10CHAR(N' ')YesXAKON Allow NULL? 
279FKBERFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
280AFABEReal depreciation areanvarchar20NUMC(N'00')Yes*AFABE_D Allow NULL? 
281VERSAResults Analysis Versionnvarchar30CHAR(N' ')Yes*VERSN_ABGR Allow NULL? 
282WIP_CATWork in Process Categories for Profit Center Accountingnvarchar20NUMC(N'00')YesPCA_WIP_CAT Allow NULL? 
283XLIFOLIFO/FIFO-Relevantchar10CHAR(N' ')YesXLIFO Allow NULL? 
284ERFMGQuantity in Unit of Entrydecimal133QUAN((0))YesERFMG
285ERFMEUnit of Entrynvarchar30UNIT(N' ')Yes*ERFME Allow NULL? 
286DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
287AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
288AUGCPClearing Entry Datenvarchar80DATS(N'00000000')YesAUGCP Allow NULL? 
289AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
290AGZEIClearing Itemdecimal50DEC((0))YesAGZEI
291XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
292STGRDReason for Reversalnvarchar20CHAR(N' ')Yes*STGRD Allow NULL? 
293CCINSPayment cards: Card typenvarchar40CHAR(N' ')YesTVCINCCINS Allow NULL? 
294CCNUMPayment cards: Card numbernvarchar250CHAR(N' ')Yes*CCNUM Allow NULL? 
295CCFOLPayment cards: Payment card suffixnvarchar100CHAR(N' ')YesCCFOL Allow NULL? 
296DATABPayment cards: Valid fromnvarchar80DATS(N'00000000')YesDATAB_CC Allow NULL? 
297DATBIPayment Cards: Valid Tonvarchar80DATS(N'00000000')YesDATBI_CC Allow NULL? 
298CCNAMEPayment cards: Name of cardholdernvarchar400CHAR(N' ')YesCCNAME Allow NULL? 
299CSOURPayment cards: Entry modechar10CHAR(N' ')YesCSOUR Allow NULL? 
300AUTWRPayment cards: Authorized amountdecimal152CURR((0))YesAUTWR
301CCWAECurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
302SETTLPayment cards: Settlement carried outchar10CHAR(N' ')YesSETTL Allow NULL? 
303AUNUMPayment cards: Authorization numbernvarchar100CHAR(N' ')YesAUNUM Allow NULL? 
304AUTRAPayment cards: Authoriz. reference code of clearing housenvarchar150CHAR(N' ')YesAUTRA Allow NULL? 
305AUDATPayment cards: Authorization datenvarchar80DATS(N'00000000')YesAUDAT_CC Allow NULL? 
306AUTIMPayment cards: Authorization timenvarchar60TIMS(N'000000')YesAUTIM Allow NULL? 
307MERCHPayment cards: Merchant ID at the clearing housenvarchar150CHAR(N' ')YesTCCMMERCH Allow NULL? 
308LOCIDPayment cards: Point of receipt for the transactionnvarchar100CHAR(N' ')YesTCCLLOCID_CC Allow NULL? 
309TRMIDPayment cards: Terminalnvarchar100CHAR(N' ')YesTRMID Allow NULL? 
310CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
311CCTYPPayment cards: Card categorynvarchar20CHAR(N' ')YesTVCTYCCTYP Allow NULL? 
312CCARD_GUIDReference to Encrypted Payment Card Datanvarchar320CHAR(N' ')YesCCARDEC_GUID Allow NULL? 
313KKBERCredit control areanvarchar40CHAR(N' ')Yes*KKBER Allow NULL? 
314SHKZG_VAReturns Itemchar10CHAR(N' ')YesSHKZG_VA Allow NULL? 
315SDSTRThird-Party Order Processingchar10CHAR(N' ')YesSDSTR Allow NULL? 
316POSARItem typechar10CHAR(N' ')YesPOSAR Allow NULL? 
317ANLO1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
318ANLO2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
319CONDIJoint Venture Indicator (Condition Key)nvarchar20CHAR(N' ')Yes*JV_CONDCOD Allow NULL? 
320BEMOTAccounting Indicatornvarchar20CHAR(N' ')Yes*BEMOT Allow NULL? 
321ABSBTCredit management: Hedged amountdecimal132CURR((0))YesABSBT
322KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
323BRNCHBranch Numbernvarchar40CHAR(N' ')Yes*J_1ABRNCH Allow NULL? 
324NUMPGNumber of pages of invoicenvarchar30NUMC(N'000')YesJ_1ANOPG Allow NULL? 
325ADISCIndicator: entry represents a discount documentchar10CHAR(N' ')YesJ_1ADISC Allow NULL? 
326GRICDActivity Code for Gross Income Taxnvarchar20CHAR(N' ')Yes*J_1AGICD_D Allow NULL? 
327GRIRGRegion (State, Province, County)nvarchar30CHAR(N' ')Yes*REGIO Allow NULL? 
328GITYPDistribution Type for Employment Taxnvarchar20CHAR(N' ')Yes*J_1ADTYP_D Allow NULL? 
329WT_KEYGrouping key for withholding tax informationnvarchar60NUMC(N'000000')YesWT_KEY Allow NULL? 
330XBGBBPosting for offsetting entrychar10CHAR(N' ')YesXBGBB Allow NULL? 
331VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
332VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
333VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
334BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
335HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
336HKTIDID for account detailsnvarchar50CHAR(N' ')Yes*HKTID Allow NULL? 
337NEBTRNet Payment Amountdecimal132CURR((0))YesNEBTR
338MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
339DMBT1Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
340MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
341DMBT2Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
342MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
343DMBT3Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
344ABWZEAlternative payeenvarchar100CHAR(N' ')Yes*VVABWZE Allow NULL? 
345BVTYPABWBank type of alternative payernvarchar40CHAR(N' ')YesVVBVTYPABW Allow NULL? 
346BAPI_PARAMField Namenvarchar300CHAR(N' ')Yes*FIELDNAME Allow NULL? 
347BAPI_TABIXRow Index of Internal Tablesint100INT4((0))YesSYTABIX Allow NULL? 
348CCACTG/L Account Number for Payment Card Receivablesnvarchar100CHAR(N' ')Yes*CCACT Allow NULL? 
349CO_KAKSTAccount Assignment Type: Cost Centerchar10NUMC(N'0')YesCO_KAKST Allow NULL? 
350CO_KAAUFAccount assignment type: Orderchar10NUMC(N'0')YesCO_KAAUF Allow NULL? 
351CO_KAPROProject account assignment typechar10NUMC(N'0')YesCO_KAPRO Allow NULL? 
352CO_KAKTRAccount Assignment Type: Cost Objectchar10NUMC(N'0')YesCO_KAKTR Allow NULL? 
353CO_KANPLAccount Assignment Type: Networkchar10NUMC(N'0')YesCO_KANPL Allow NULL? 
354CO_KAIMOAccount Assignment Type: Real Estate Objectchar10NUMC(N'0')YesCO_KAIMO Allow NULL? 
355CO_KAKDAAccount Assignment Type: Sales Orderchar10NUMC(N'0')YesCO_KAKDA Allow NULL? 
356CO_KAERGBusiness segment account assignment typechar10NUMC(N'0')YesCO_KAERG Allow NULL? 
357CO_KAABSAccount assignment type: reconciliation objectchar10NUMC(N'0')YesCO_KAABS Allow NULL? 
358CO_KAPRZAccount Assignment Type: Business Processchar10NUMC(N'0')YesCO_KAPRZ Allow NULL? 
359CO_KASATAccount Assignment Type Not Usedchar10NUMC(N'0')YesCO_KASAT Allow NULL? 
360ZZSPREGSpecial Regionnvarchar50CHAR(N' ')YesZZSPREGZREGION Allow NULL? 
361ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
362ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
363ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
364ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
365ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
366ZZNFALnvarchar100(N' ')Yes Allow NULL? 
367ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZFU1ZZUSERFLD1 Allow NULL? 
368ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
369ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
370ZZREGIONLocationnvarchar30CHAR(N' ')YesZREGZZREGION Allow NULL? 
371ZZSTATEState/Province Codenvarchar30CHAR(N' ')YesT005SZZSTATE Allow NULL? 
372BVALTNRProcurement alternative/processnvarchar120NUMC(N'000000000000')Yes*CKML_ALPROCNR Allow NULL? 
373KALN1Cost Estimate Number - Product Costingnvarchar120NUMC(N'000000000000')Yes*CK_KALNR1 Allow NULL? 
374AUFNR_ORGOriginal Order Numbernvarchar120CHAR(N' ')Yes*CK_AUFNR_ORG Allow NULL? 
375CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')Yes*CESSION_KZ Allow NULL? 
376MLMAAMaterial ledger activated at material levelchar10CHAR(N' ')YesCK_ML_MAAC Allow NULL? 
377MLASTMaterial Price Determination: Controlchar10CHAR(N' ')YesCK_ML_ABST Allow NULL? 
378ZEILEItem in material or invoice verification documentnvarchar60NUMC(N'000000')YesCK_ZEILE Allow NULL? 
379URZEILEOriginal item in material or invoice documentnvarchar60NUMC(N'000000')YesCK_URZEILE Allow NULL? 
380MLBWGMovement Type Group for ML Updatenvarchar20CHAR(N' ')Yes*CKML_MLBWG Allow NULL? 
381MLNPRDDo not break down price differences in profit center acctgchar10CHAR(N' ')YesCK_MLNPRD Allow NULL? 
382LSQTYLast Settlement Amount in Current Period (Production Order)decimal153QUAN((0))YesCK_LSQTY
383PRQTYBase Quantity for Invoice Verification Price Differencesdecimal153QUAN((0))YesCK_PRQTY
384EKORGPurchasing Organizationnvarchar40CHAR(N' ')Yes*EKORG Allow NULL? 
385VKWRTValue at Sales Prices Including Value-Added Taxdecimal132CURR((0))YesVKWRT
386UMMATReceiving/Issuing Materialnvarchar180CHAR(N' ')Yes*UMMAT Allow NULL? 
387UMWRKReceiving/Issuing Plantnvarchar40CHAR(N' ')Yes*UMWRK Allow NULL? 
388KNTTPAccount Assignment Categorychar10CHAR(N' ')Yes*KNTTP Allow NULL? 
389UMSOKSpecial Stock Indicator for Physical Stock Transferchar10CHAR(N' ')Yes*UMSOK Allow NULL? 
390UMWERValue Update in Material Master Recordchar10CHAR(N' ')YesWERTU Allow NULL? 
391RRRELRevenue recognition categorychar10CHAR(N' ')YesRR_RELTYP Allow NULL? 
392MAT_LIFNRValuated Vendor Stocksnvarchar100CHAR(N' ')Yes*MAT_LIFNR Allow NULL? 
393XOBEWVendor Stock Valuation Indicatorchar10CHAR(N' ')YesXOBEW Allow NULL? 
394TPKNZTransfer Price Indicatorchar10NUMC(N'0')YesTPKNZ Allow NULL? 
395XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
396KRUEKCondition is Relevant for Accrual (e.g. Freight)char10CHAR(N' ')YesKRUEK Allow NULL? 
397AWTYP_REVReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
398AWTYP_REBReference Transactionnvarchar50CHAR(N' ')Yes*AWTYP Allow NULL? 
399VORNROperation/Activity Numbernvarchar40CHAR(N' ')YesVORNR Allow NULL? 
400PGEBERPartner Fundnvarchar100CHAR(N' ')Yes*FM_PFUND Allow NULL? 
401PENRCReason for late paymentnvarchar20CHAR(N' ')YesPENRC Allow NULL? 
402GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
403PGRANT_NBRPartner Grantnvarchar200CHAR(N' ')YesGM_GRANT_PARTNER Allow NULL? 
404GMVKZItem is in Executionchar10CHAR(N' ')YesFM_GMVKZ Allow NULL? 
405SRTYPEType of Additional Receivablenvarchar20CHAR(N' ')YesFM_SRTYPE Allow NULL? 
406REINDATInvoice Receipt Datenvarchar80DATS(N'00000000')YesREINDAT Allow NULL? 
407IDXSPInflation Indexnvarchar50CHAR(N' ')Yes*J_1AINDXSP Allow NULL? 
408INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
409GLUPMUpdate Method for FM - FI-CA Integrationchar10CHAR(N' ')YesGLUPM Allow NULL? 
410MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
411STBLGReverse Document Numbernvarchar100CHAR(N' ')YesSTBLG Allow NULL? 
412HZUONAssignment Number for Special G/L Accountsnvarchar180CHAR(N' ')YesHZUON Allow NULL? 
413SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
414PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_PSEGMENT Allow NULL? 
415PFKBERPartner Functional Areanvarchar160CHAR(N' ')Yes*SFKBER Allow NULL? 
416PKOSTLSender cost centernvarchar100CHAR(N' ')Yes*SKOST Allow NULL? 
417KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
418FLG_NOBUDNot budget-relevantchar10CHAR(N' ')YesFM_NBUD Allow NULL? 
419PPA_EX_INDPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
420CASE_GUID_CORETechnical Case Key (Case GUID)nvarchar320CHAR(N' ')YesSCMG_CASE_GUID Allow NULL? 
421LONGNUMSmart Numbernvarchar400CHAR(N' ')Yes/SAPPSPRO/LONGNUM Allow NULL? 
422STODTPlanned Date for the Reverse Postingnvarchar80DATS(N'00000000')YesSTODT Allow NULL? 
423BDGT_SUBTYPEBudget Subtypenvarchar40CHAR(N' ')Yes*BP_SUBVO Allow NULL? 
424COHORTReporting Year for Cohortnvarchar40CHAR(N' ')YesFM_COHORT Allow NULL? 
425PUBLAWPublic Law Citednvarchar200CHAR(N' ')YesFM_PUBLAW Allow NULL? 
426LEGISType of Legislationchar10CHAR(N' ')YesFM_LEGIS Allow NULL? 
427FMCMMTSTRFM Commitment String For Budgetary Ledgernvarchar620CHAR(N' ')YesFMCMMTSTR Allow NULL? 
428PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
429TCOBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
430DATEOFSERVICEDate of Servicenvarchar80DATS(N'00000000')YesVVBEACTDATE Allow NULL? 
431NOTAXCORRDo Not Consider Item in Input Tax Correctionchar10CHAR(N' ')YesVVREITNOTAXCORR Allow NULL? 
432DIFFOPTRATEReal estate option ratedecimal96DEC((0))YesPOPTSATZ
433HASDIFFOPTRATEUse Different Option Ratechar10CHAR(N' ')YesVVREITUSEDIFFOPTRATE Allow NULL? 
434CURTPCurrency Type and Valuation Viewnvarchar20CHAR(N' ')YesCURTP Allow NULL? 
435WAERSCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
436WRBTRAmount or tax amount in the currency of the currency typesdecimal132CURR((0))YesACBTR
437FWBASTax base amount in the currency of the currency typesdecimal132CURR((0))YesACSBS
438SKFBTAmnt Eligible for Cash Disc.in the Curr.of the Curr.Typesdecimal132CURR((0))YesACFBT
439WSKTOCash Discount Amount in the Currency of the Currency Typesdecimal132CURR((0))YesACSKT
440QSSHBWithholding Tax Base Amnt in the Currency of the Curr.Typesdecimal132CURR((0))YesACQBS
441QSFBTAmnt Exempt from Withhold.Tax in the Curr.of the Curr.Typesdecimal132CURR((0))YesACQBT
442BUALTAmount posted in alternative price controldecimal132CURR((0))YesBUALT
443KWERTCondition valuedecimal132CURR((0))YesKWERT
444NAVBTNon-Deductible Input Tax (in Document Currency)decimal132CURR((0))YesNAVFW
445WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
446CURRTYPCurrency Typenvarchar20CHAR(N' ')YesCURRTYP Allow NULL? 
447VALUTYPValuation Viewchar10NUMC(N'0')YesVALUTYP Allow NULL? 
448GBETRHedged Amount in Foreign Currencydecimal132CURR((0))YesGBETR
449KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
450WRBTR_FIXFixed Part of Amount in Currency of Currency Typedecimal132CURR((0))YesACBTR_FIX
451WRBTR_AVGADB: Average Amountdecimal232CURR((0))YesGLE_DTE_ADB_AVERAGE_AMOUNT
452CURT1Currency type of the first local currencynvarchar20CHAR(N' ')YesCURT1 Allow NULL? 
453HWAERLocal Currencynvarchar50CUKY(N' ')Yes*HWAER Allow NULL? 
454DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
455KURSFExchange ratedecimal95DEC((0))YesKURSF
456HWSTETax Amount in Local Currencydecimal132CURR((0))YesHWSTE
457HWBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
458TXKRSExchange Rate for Taxesdecimal95DEC((0))YesTXKRS_BKPF
459SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
460KZBTROriginal Reduction Amount in Local Currencydecimal132CURR((0))YesKZBTR_FI
461MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
462DMBTR_AVGADB: Average Amountdecimal232CURR((0))YesGLE_DTE_ADB_AVERAGE_AMOUNT
463CURT2Currency Type of Second Local Currencynvarchar20CHAR(N' ')YesCURT2 Allow NULL? 
464HWAE2Currency Key of Second Local Currencynvarchar50CUKY(N' ')Yes*HWAE2 Allow NULL? 
465DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
466KURS2Exchange Rate for the Second Local Currencydecimal95DEC((0))YesKURS2
467H2STETax Amount in Local Currency 2decimal132CURR((0))YesH2STE
468SKNT2Cash Discount Amount in Second Local Currencydecimal132CURR((0))YesSKNT2
469MWST2Tax Amount in Second Local Currencydecimal132CURR((0))YesMWST2
470TXBH2Tax Base/Original Tax Base in Second Local Currencydecimal132CURR((0))YesTXBH2
471BASW2Source Currency for Currency Translationchar10CHAR(N' ')YesCURSR Allow NULL? 
472UMRD2Translation Date Type for Second Local Currencychar10CHAR(N' ')YesUMRD2 Allow NULL? 
473KUTY2Exchange Rate Typenvarchar40CHAR(N' ')Yes*KURST Allow NULL? 
474DMBE2_AVGADB: Average Amountdecimal232CURR((0))YesGLE_DTE_ADB_AVERAGE_AMOUNT
475CURT3Currency Type of Third Local Currencynvarchar20CHAR(N' ')YesCURT3 Allow NULL? 
476HWAE3Currency Key of Third Local Currencynvarchar50CUKY(N' ')Yes*HWAE3 Allow NULL? 
477DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
478KURS3Exchange Rate for the Third Local Currencydecimal95DEC((0))YesKURS3
479H3STETax Amount in Local Currency 3decimal132CURR((0))YesH3STE
480SKNT3Cash Discount Amount in Third Local Currencydecimal132CURR((0))YesSKNT3
481MWST3Tax Amount in Third Local Currencydecimal132CURR((0))YesMWST3
482TXBH3Tax Base/Original Tax Base in Third Local Currencydecimal132CURR((0))YesTXBH3
483BASW3Source Currency for Currency Translationchar10CHAR(N' ')YesCURSR Allow NULL? 
484UMRD3Translation Date Type for Third Local Currencychar10CHAR(N' ')YesUMRD3 Allow NULL? 
485KUTY3Exchange Rate Typenvarchar40CHAR(N' ')Yes*KURST Allow NULL? 
486DMBE3_AVGADB: Average Amountdecimal232CURR((0))YesGLE_DTE_ADB_AVERAGE_AMOUNT
NamePrimaryUniqueTypeColumns
GLE_FI_ITEM_MODF~0YesYesCLUSTEREDITEM_ID, MANDT