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
10BSEG345Accounting Document Segment

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
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
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
1ERP EHP76.0BSEG3451Accounting Document Segment
SQL:  selectupdate insert create

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

SELECT MANDT, BUKRS, BELNR, GJAHR, BUZEI, BUZID, AUGDT, AUGCP, AUGBL, BSCHL, KOART, UMSKZ, UMSKS, ZUMSK, SHKZG, GSBER, PARGB, MWSKZ, QSSKZ, ZZSPREG, ZZBUSPARTN, ZZCHAN, ZZPRODUCT, ZZLOCA, ZZLOB, ZZUSERFLD1, ZZUSERFLD2, ZZUSERFLD3, ZZSTATE, ZZREGION, DMBTR, WRBTR, KZBTR, PSWBT, PSWSL, TXBHW, TXBFW, MWSTS, WMWST, HWBAS, FWBAS, HWZUZ, FWZUZ, SHZUZ, STEKZ, MWART, TXGRP, KTOSL, QSSHB, KURSR, GBETR, BDIFF, BDIF2, VALUT, ZUONR, SGTXT, ZINKZ, VBUND, BEWAR, ALTKT, VORGN, FDLEV, FDGRP, FDWBT, FDTAG, FKONT, KOKRS, KOSTL, PROJN, AUFNR, VBELN, VBEL2, POSN2, ETEN2, ANLN1, ANLN2, ANBWA, BZDAT, PERNR, XUMSW, XHRES, XKRES, XOPVW, XCPDD, XSKST, XSAUF, XSPRO, XSERG, XFAKT, XUMAN, XANET, XSKRL, XINVE, XPANZ, XAUTO, XNCOP, XZAHL, SAKNR, HKONT, KUNNR, LIFNR, FILKD, XBILK, GVTYP, HZUON, ZFBDT, ZTERM, ZBD1T, ZBD2T, ZBD3T, ZBD1P, ZBD2P, SKFBT, SKNTO, WSKTO, ZLSCH, ZLSPR, ZBFIX, HBKID, BVTYP, NEBTR, MWSK1, DMBT1, WRBT1, MWSK2, DMBT2, WRBT2, MWSK3, DMBT3, WRBT3, REBZG, REBZJ, REBZZ, REBZT, ZOLLT, ZOLLD, LZBKZ, LANDL, DIEKZ, SAMNR, ABPER, VRSKZ, VRSDT, DISBN, DISBJ, DISBZ, WVERW, ANFBN, ANFBJ, ANFBU, ANFAE, BLNBT, BLNKZ, BLNPZ, MSCHL, MANSP, MADAT, MANST, MABER, ESRNR, ESRRE, ESRPZ, KLIBT, QSZNR, QBSHB, QSFBT, NAVHW, NAVFW, MATNR, WERKS, MENGE, MEINS, ERFMG, ERFME, BPMNG, BPRME, EBELN, EBELP, ZEKKN, ELIKZ, VPRSV, PEINH, BWKEY, BWTAR, BUSTW, REWRT, REWWR, BONFB, BUALT, PSALT, NPREI, TBTKZ, SPGRP, SPGRM, SPGRT, SPGRG, SPGRV, SPGRQ, STCEG, EGBLD, EGLLD, RSTGR, RYACQ, RPACQ, RDIFF, RDIF2, PRCTR, XHKOM, VNAME, RECID, EGRUP, VPTNR, VERTT, VERTN, VBEWA, DEPOT, TXJCD, IMKEY, DABRZ, POPTS, FIPOS, KSTRG, NPLNR, AUFPL, APLZL, PROJK, PAOBJNR, PASUBNR, SPGRS, SPGRC, BTYPE, ETYPE, XEGDR, LNRAN, HRKFT, DMBE2, DMBE3, DMB21, DMB22, DMB23, DMB31, DMB32, DMB33, MWST2, MWST3, NAVH2, NAVH3, SKNT2, SKNT3, BDIF3, RDIF3, HWMET, GLUPM, XRAGL, UZAWE, LOKKT, FISTL, GEBER, STBUK, TXBH2, TXBH3, PPRCT, XREF1, XREF2, KBLNR, KBLPOS, STTAX, FKBER, OBZEI, XNEGP, RFZEI, CCBTC, KKBER, EMPFB, XREF3, DTWS1, DTWS2, DTWS3, DTWS4, GRICD, GRIRG, GITYP, XPYPR, KIDNO, ABSBT, IDXSP, LINFV, KONTT, KONTL, TXDAT, AGZEI, PYCUR, PYAMT, BUPLA, SECCO, LSTAR, CESSION_KZ, PRZNR, PPDIFF, PPDIF2, PPDIF3, PENLC1, PENLC2, PENLC3, PENFC, PENDAYS, PENRC, GRANT_NBR, SCTAX, FKBER_LONG, GMVKZ, SRTYPE, INTRENO, MEASURE, AUGGJ, PPA_EX_IND, DOCLN, SEGMENT, PSEGMENT, PFKBER, HKTID, KSTAR, XLGCLR, TAXPS, PAYS_PROV, PAYS_TRAN, MNDID, XFRGE_BSEG, RE_BUKRS, RE_ACCOUNT, PGEBER, PGRANT_NBR, BUDGET_PD, PBUDGET_PD, J_1TPBUPL, PEROP_BEG, PEROP_END, FASTPAY, IGNR_IVREF, FMFGUS_KEY, FMXDOCNR, FMXYEAR, FMXDOCLN, FMXZEKKN, PRODPER FROM BSEG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BUKRSCompany Codenvarchar40CHAR(N' ')NoT001BUKRS Allow NULL? 
3BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
4GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
5BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
6BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
7AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
8AUGCPClearing Entry Datenvarchar80DATS(N'00000000')YesAUGCP Allow NULL? 
9AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
10BSCHLPosting Keynvarchar20CHAR(N' ')YesTBSLBSCHL Allow NULL? 
11KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
12UMSKZSpecial G/L Indicatorchar10CHAR(N' ')YesT074UUMSKZ Allow NULL? 
13UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')YesUMSKS Allow NULL? 
14ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')YesT074UDZUMSK Allow NULL? 
15SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
16GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
17PARGBTrading partner's business areanvarchar40CHAR(N' ')YesTGSBPARGB Allow NULL? 
18MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
19QSSKZWithholding Tax Codenvarchar20CHAR(N' ')YesT059QQSSKZ Allow NULL? 
20ZZSPREGSpecial Regionnvarchar50CHAR(N' ')Yes*ZREGION Allow NULL? 
21ZZBUSPARTNBusiness partnernvarchar100CHAR(N' ')YesZZBUSPARTN Allow NULL? 
22ZZCHANDistribution channelnvarchar40CHAR(N' ')YesZZCHAN Allow NULL? 
23ZZPRODUCTProduct groupnvarchar100CHAR(N' ')YesZZPRODUCT Allow NULL? 
24ZZLOCACitynvarchar40CHAR(N' ')YesZZLOCA Allow NULL? 
25ZZLOBBUSINESS LINEnvarchar70CHAR(N' ')Yes*ZZLOB Allow NULL? 
26ZZUSERFLD1Territorynvarchar90CHAR(N' ')YesZZUSERFLD1 Allow NULL? 
27ZZUSERFLD2Owner/Cont.nvarchar120CHAR(N' ')YesZZUSERFLD2 Allow NULL? 
28ZZUSERFLD3Veinnvarchar220CHAR(N' ')YesZZUSERFLD3 Allow NULL? 
29ZZSTATEState/Province Codenvarchar30CHAR(N' ')Yes*ZZSTATE Allow NULL? 
30ZZREGIONLocationnvarchar30CHAR(N' ')YesZZREGION Allow NULL? 
31DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
32WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
33KZBTROriginal Reduction Amount in Local Currencydecimal132CURR((0))YesKZBTR_FI
34PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
35PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')YesTCURCPSWSL Allow NULL? 
36TXBHWOriginal Tax Base Amount in Local Currencydecimal132CURR((0))YesTXBHW
37TXBFWOriginal Tax Base Amount in Document Currencydecimal132CURR((0))YesTXBFW
38MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
39WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
40HWBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
41FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
42HWZUZProvision Amount in Local Currencydecimal132CURR((0))YesHWZUZ
43FWZUZAdditional Tax in Document Currencydecimal132CURR((0))YesFWZUZ
44SHZUZDebit/Credit Addition for Cash Discountchar10CHAR(N' ')YesSHZUZ Allow NULL? 
45STEKZVersion Number Componentnvarchar20CHAR(N' ')YesCHAR2 Allow NULL? 
46MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
47TXGRPGroup Indicator for Tax Line Itemsnvarchar30NUMC(N'000')YesTXGRP Allow NULL? 
48KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
49QSSHBWithholding Tax Base Amountdecimal132CURR((0))YesQSSHB
50KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
51GBETRHedged Amount in Foreign Currencydecimal132CURR((0))YesGBETR
52BDIFFValuation Differencedecimal132CURR((0))YesBDIFF
53BDIF2Valuation Difference for the Second Local Currencydecimal132CURR((0))YesBDIF2
54VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
55ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
56SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
57ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
58VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
59BEWARTransaction Typenvarchar30CHAR(N' ')YesT856RMVCT Allow NULL? 
60ALTKTGroup account numbernvarchar100CHAR(N' ')Yes*BILKT_SKA1 Allow NULL? 
61VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')YesVORGN Allow NULL? 
62FDLEVPlanning levelnvarchar20CHAR(N' ')YesT036FDLEV Allow NULL? 
63FDGRPPlanning Groupnvarchar100CHAR(N' ')YesT035FDGRP Allow NULL? 
64FDWBTPlanning amount in document currencydecimal132CURR((0))YesFDWBT
65FDTAGPlanning datenvarchar80DATS(N'00000000')YesFDTAG Allow NULL? 
66FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
67KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
68KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
69PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
70AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
71VBELNBilling Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VF Allow NULL? 
72VBEL2Sales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
73POSN2Sales Document Itemnvarchar60NUMC(N'000000')YesVBUPPOSNR_VA Allow NULL? 
74ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')YesVBEPETENR Allow NULL? 
75ANLN1Main Asset Numbernvarchar120CHAR(N' ')YesANLHANLN1 Allow NULL? 
76ANLN2Asset Subnumbernvarchar40CHAR(N' ')YesANLAANLN2 Allow NULL? 
77ANBWAAsset Transaction Typenvarchar30CHAR(N' ')YesTABWANBWA Allow NULL? 
78BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
79PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
80XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
81XHRESIndicator: Resident G/L account?char10CHAR(N' ')YesXHRES Allow NULL? 
82XKRESIndicator: Can Line Items Be Displayed by Account?char10CHAR(N' ')YesXKRES Allow NULL? 
83XOPVWIndicator: Open Item Management?char10CHAR(N' ')YesXOPVW Allow NULL? 
84XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
85XSKSTIndicator: Statistical posting to cost centerchar10CHAR(N' ')YesXSKST Allow NULL? 
86XSAUFIndicator: Posting to order is statisticalchar10CHAR(N' ')YesXSAUF Allow NULL? 
87XSPROIndicator: Posting to project is statisticalchar10CHAR(N' ')YesXSPRO Allow NULL? 
88XSERGIndicator: Posting to prof.analysis is statisticalchar10CHAR(N' ')YesXSERG Allow NULL? 
89XFAKTIndicator: Billing document update successful ?char10CHAR(N' ')YesXFAKT Allow NULL? 
90XUMANIndicator: Transfer posting from down payment ?char10CHAR(N' ')YesXUMAN Allow NULL? 
91XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
92XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
93XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
94XPANZDisplay itemchar10CHAR(N' ')YesXPANZ Allow NULL? 
95XAUTOIndicator: Line item automatically createdchar10CHAR(N' ')YesXAUTO Allow NULL? 
96XNCOPIndicator: Items cannot be copied?char10CHAR(N' ')YesXNCOP Allow NULL? 
97XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
98SAKNRG/L Account Numbernvarchar100CHAR(N' ')YesSKB1SAKNR Allow NULL? 
99HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKB1HKONT Allow NULL? 
100KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
101LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
102FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
103XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
104GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
105HZUONAssignment Number for Special G/L Accountsnvarchar180CHAR(N' ')YesHZUON Allow NULL? 
106ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
107ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
108ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
109ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
110ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
111ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
112ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
113SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
114SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
115WSKTOCash discount amount in document currencydecimal132CURR((0))YesWSKTO
116ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZSCHZW_BSEG Allow NULL? 
117ZLSPRPayment Block Keychar10CHAR(N' ')YesT008DZLSPR Allow NULL? 
118ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
119HBKIDShort Key for a House Banknvarchar50CHAR(N' ')YesT012HBKID Allow NULL? 
120BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
121NEBTRNet Payment Amountdecimal132CURR((0))YesNEBTR
122MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')YesT007AMWSKX Allow NULL? 
123DMBT1Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
124WRBT1Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
125MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')YesT007AMWSKX Allow NULL? 
126DMBT2Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
127WRBT2Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
128MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')YesT007AMWSKX Allow NULL? 
129DMBT3Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
130WRBT3Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
131REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
132REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
133REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
134REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
135ZOLLTCustoms Tariff Numbernvarchar80CHAR(N' ')YesDZOLLT Allow NULL? 
136ZOLLDCustoms Datenvarchar80DATS(N'00000000')YesDZOLLD Allow NULL? 
137LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')YesT015LLZBKZ Allow NULL? 
138LANDLSupplying Countrynvarchar30CHAR(N' ')YesT005LANDL Allow NULL? 
139DIEKZService Indicator (Foreign Payment)char10CHAR(N' ')YesDIEKZ Allow NULL? 
140SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
141ABPERSettlement periodnvarchar60ACCP(N' ')YesABPER_RF Allow NULL? 
142VRSKZInsurance indicatorchar10CHAR(N' ')YesVRSKZ Allow NULL? 
143VRSDTInsurance datenvarchar80DATS(N'00000000')YesVRSDT Allow NULL? 
144DISBNNumber of Bill of Exchange Usage Document (Discount Doc.)nvarchar100CHAR(N' ')YesDISBN Allow NULL? 
145DISBJFiscal Year of Bill of Exchange Usage Documentnvarchar40NUMC(N'0000')YesDISBJ Allow NULL? 
146DISBZLine Item within the Bill of Exchange Usage Documentnvarchar30NUMC(N'000')YesDISBZ Allow NULL? 
147WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
148ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100CHAR(N' ')YesANFBN Allow NULL? 
149ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40NUMC(N'0000')YesANFBJ Allow NULL? 
150ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40CHAR(N' ')YesT001ANFBU Allow NULL? 
151ANFAEBill of Exchange Payment Request Due Datenvarchar80DATS(N'00000000')YesANFAE Allow NULL? 
152BLNBTBase Amount for Determining the Preference Amountdecimal132CURR((0))YesBLNBT
153BLNKZSubsidy indicator for determining the reduction ratesnvarchar20CHAR(N' ')Yes*BLNKZ Allow NULL? 
154BLNPZPreference Percentage Ratedecimal72DEC((0))YesBLNPZ
155MSCHLDunning keychar10CHAR(N' ')YesT040MSCHL Allow NULL? 
156MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
157MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
158MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
159MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
160ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
161ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
162ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
163KLIBTCredit Control Amountdecimal132CURR((0))YesKLIBT
164QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
165QBSHBWithholding Tax Amount (in Document Currency)decimal132CURR((0))YesQBSHB
166QSFBTWithholding Tax-Exempt Amount (in Document Currency)decimal132CURR((0))YesQSFBT
167NAVHWNon-Deductible Input Tax (in Local Currency)decimal132CURR((0))YesNAVHW
168NAVFWNon-Deductible Input Tax (in Document Currency)decimal132CURR((0))YesNAVFW
169MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
170WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
171MENGEQuantitydecimal133QUAN((0))YesMENGE_D
172MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
173ERFMGQuantity in Unit of Entrydecimal133QUAN((0))YesERFMG
174ERFMEUnit of Entrynvarchar30UNIT(N' ')YesT006ERFME Allow NULL? 
175BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))YesBPMNG
176BPRMEOrder Price Unit (Purchasing)nvarchar30UNIT(N' ')YesT006BPRME Allow NULL? 
177EBELNPurchasing Document Numbernvarchar100CHAR(N' ')YesEKKOEBELN Allow NULL? 
178EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')YesEKPOEBELP Allow NULL? 
179ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
180ELIKZ"Delivery Completed" Indicatorchar10CHAR(N' ')YesELIKZ Allow NULL? 
181VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
182PEINHPrice Unitdecimal50DEC((0))YesPEINH
183BWKEYValuation Areanvarchar40CHAR(N' ')YesT001KBWKEY Allow NULL? 
184BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
185BUSTWPosting string for valuesnvarchar40CHAR(N' ')YesBUSTW Allow NULL? 
186REWRTInvoice Value Entered (in Local Currency)decimal132CURR((0))YesREEWR
187REWWRInvoice value in foreign currencydecimal132CURR((0))YesREFWR
188BONFBAmount Qualifying for Bonus in Local Currencydecimal132CURR((0))YesBONFB
189BUALTAmount posted in alternative price controldecimal132CURR((0))YesBUALT
190PSALTAlternative Price Controlchar10CHAR(N' ')YesPSALT Allow NULL? 
191NPREINew pricedecimal112CURR((0))YesNPREI
192TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
193SPGRPBlocking reason: pricechar10CHAR(N' ')YesSPGRP Allow NULL? 
194SPGRMBlocking reason: quantitychar10CHAR(N' ')YesSPGRM Allow NULL? 
195SPGRTBlocking Reason: Datechar10CHAR(N' ')YesSPGRT Allow NULL? 
196SPGRGBlocking reason: order price quantitychar10CHAR(N' ')YesSPGRG Allow NULL? 
197SPGRVBlocking reason: project budgetchar10CHAR(N' ')YesSPGRV Allow NULL? 
198SPGRQManual Blocking Reasonchar10CHAR(N' ')YesSPGRQ Allow NULL? 
199STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
200EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')YesT005EGBLD Allow NULL? 
201EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')YesT005EGLLD Allow NULL? 
202RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')YesT053RRSTGR Allow NULL? 
203RYACQYear of acquisitionnvarchar40CHAR(N' ')YesRYACQ Allow NULL? 
204RPACQPeriod of Acquisitionnvarchar30NUMC(N'000')YesRPACQ Allow NULL? 
205RDIFFExchange Rate Gain/Loss Realizeddecimal132CURR((0))YesRDIFF
206RDIF2Exchange Rate Difference Realized for Second Local Currencydecimal132CURR((0))YesRDIF2
207PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
208XHKOMIndicator: G/L account assigned manually ?char10CHAR(N' ')YesXHKOM Allow NULL? 
209VNAMEJoint Venturenvarchar60CHAR(N' ')YesT8JVJV_NAME Allow NULL? 
210RECIDRecovery Indicatornvarchar20CHAR(N' ')YesT8JJJV_RECIND Allow NULL? 
211EGRUPEquity groupnvarchar30CHAR(N' ')YesT8JFJV_EGROUP Allow NULL? 
212VPTNRPartner account numbernvarchar100CHAR(N' ')YesKNA1JV_PART Allow NULL? 
213VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
214VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
215VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
216DEPOTSecurities Accountnvarchar100CHAR(N' ')Yes*RLDEPO Allow NULL? 
217TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
218IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
219DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
220POPTSReal estate option ratedecimal96DEC((0))YesPOPTSATZ
221FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
222KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
223NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
224AUFPLTask list number for operations in ordernvarchar100NUMC(N'0000000000')YesAUFPL_CH Allow NULL? 
225APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')Yes*APLZL_CH Allow NULL? 
226PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
227PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
228PASUBNRProfitability segment changes (CO-PA)nvarchar40NUMC(N'0000')YesRKESUBNR Allow NULL? 
229SPGRSBlocking Reason: Item Amountchar10CHAR(N' ')YesSPGRS Allow NULL? 
230SPGRCBlock.reason: qualitychar10CHAR(N' ')YesSPGRC Allow NULL? 
231BTYPEPayroll Typenvarchar20CHAR(N' ')YesT8JAJV_BILIND Allow NULL? 
232ETYPEEquity typenvarchar30CHAR(N' ')YesT8JEJV_ETYPE Allow NULL? 
233XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
234LNRANSequence number of asset line items in fiscal yearnvarchar50NUMC(N'00000')Yes*LNRAN Allow NULL? 
235HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
236DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
237DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
238DMB21Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
239DMB22Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
240DMB23Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
241DMB31Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
242DMB32Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
243DMB33Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
244MWST2Tax Amount in Second Local Currencydecimal132CURR((0))YesMWST2
245MWST3Tax Amount in Third Local Currencydecimal132CURR((0))YesMWST3
246NAVH2Non-Deductible Input Tax in Second Local Currencydecimal132CURR((0))YesNAVH2
247NAVH3Non-Deductible Input Tax in Third Local Currencydecimal132CURR((0))YesNAVH3
248SKNT2Cash Discount Amount in Second Local Currencydecimal132CURR((0))YesSKNT2
249SKNT3Cash Discount Amount in Third Local Currencydecimal132CURR((0))YesSKNT3
250BDIF3Valuation Difference for the Third Local Currencydecimal132CURR((0))YesBDIF3
251RDIF3Exchange Rate Difference Realized for Third Local Currencydecimal132CURR((0))YesRDIF3
252HWMETMethod with Which the Local Currency Amount Was Determinedchar10CHAR(N' ')YesHWMET Allow NULL? 
253GLUPMUpdate Method for FM - FI-CA Integrationchar10CHAR(N' ')YesGLUPM Allow NULL? 
254XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
255UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
256LOKKTAlternative account number in company codenvarchar100CHAR(N' ')Yes*ALTKT_SKB1 Allow NULL? 
257FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
258GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
259STBUKTax Company Codenvarchar40CHAR(N' ')Yes*STBUK Allow NULL? 
260TXBH2Tax Base/Original Tax Base in Second Local Currencydecimal132CURR((0))YesTXBH2
261TXBH3Tax Base/Original Tax Base in Third Local Currencydecimal132CURR((0))YesTXBH3
262PPRCTPartner Profit Centernvarchar100CHAR(N' ')YesCEPCPPRCTR Allow NULL? 
263XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
264XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
265KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')YesKBLKKBLNR_FI Allow NULL? 
266KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')YesKBLPKBLPOS Allow NULL? 
267STTAXTax amount as statistical information in document currencydecimal132CURR((0))YesSTTAX
268FKBERFunctional Areanvarchar40CHAR(N' ')YesFKBER_SHORT Allow NULL? 
269OBZEINumber of Line Item in Original Documentnvarchar30NUMC(N'000')YesOBZEI Allow NULL? 
270XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
271RFZEIPayment Card Itemnvarchar30NUMC(N'000')YesRFZEI_CC Allow NULL? 
272CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
273KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
274EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
275XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
276DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
277DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
278DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
279DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
280GRICDActivity Code for Gross Income Taxnvarchar20CHAR(N' ')YesJ_1AGICDJ_1AGICD_D Allow NULL? 
281GRIRGRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
282GITYPDistribution Type for Employment Taxnvarchar20CHAR(N' ')YesJ_1ADTYPJ_1ADTYP_D Allow NULL? 
283XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
284KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
285ABSBTCredit management: Hedged amountdecimal132CURR((0))YesABSBT
286IDXSPInflation Indexnvarchar50CHAR(N' ')YesJ_1AINFT20J_1AINDXSP Allow NULL? 
287LINFVLast Adjustment Datenvarchar80DATS(N'00000000')YesJ_1ALINFVL Allow NULL? 
288KONTTAccount Assignment Category for Industry Solutionnvarchar20CHAR(N' ')YesKONTT_FI Allow NULL? 
289KONTLAcct assignment string for industry-specific acct assignmntsnvarchar500CHAR(N' ')YesKONTL_FI Allow NULL? 
290TXDATDate for defining tax ratesnvarchar80DATS(N'00000000')YesTXDAT Allow NULL? 
291AGZEIClearing Itemdecimal50DEC((0))YesAGZEI
292PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')YesTCURCPYCUR Allow NULL? 
293PYAMTAmount in Payment Currencydecimal132CURR((0))YesPYAMT
294BUPLABusiness Placenvarchar40CHAR(N' ')YesJ_1BBRANCHBUPLA Allow NULL? 
295SECCOSection Codenvarchar40CHAR(N' ')YesSECCODESECCO Allow NULL? 
296LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
297CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')YesTCESSIONCESSION_KZ Allow NULL? 
298PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
299PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIFF
300PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)decimal132CURR((0))YesPPDIF2
301PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIF3
302PENLC1Penalty charge amount in first local currencydecimal132CURR((0))YesPENALTY1
303PENLC2Penalty charge amount in second local currencydecimal132CURR((0))YesPENALTY2
304PENLC3Penalty Charge Amount in Third Local Currencydecimal132CURR((0))YesPENALTY3
305PENFCPenalty charge amount in document currencydecimal132CURR((0))YesPENALTY
306PENDAYSNumber of days for penalty charge calculationint100INT4((0))YesPDAYS Allow NULL? 
307PENRCReason for late paymentnvarchar20CHAR(N' ')YesPENRC Allow NULL? 
308GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
309SCTAXTax portion FI-CA local currencydecimal132CURR((0))YesSCTAX
310FKBER_LONGFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
311GMVKZItem is in Executionchar10CHAR(N' ')YesFM_GMVKZ Allow NULL? 
312SRTYPEType of Additional Receivablenvarchar20CHAR(N' ')YesFM_SRTYPE Allow NULL? 
313INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
314MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
315AUGGJFiscal Year of Clearing Documentnvarchar40NUMC(N'0000')YesAUGGJ Allow NULL? 
316PPA_EX_INDPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
317DOCLNSix-Character Posting Item for Ledgernvarchar60CHAR(N' ')YesDOCLN6 Allow NULL? 
318SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
319PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_PSEGMENT Allow NULL? 
320PFKBERPartner Functional Areanvarchar160CHAR(N' ')Yes*SFKBER Allow NULL? 
321HKTIDID for account detailsnvarchar50CHAR(N' ')YesT012KHKTID Allow NULL? 
322KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
323XLGCLRClearing Specific to Ledger Groupschar10CHAR(N' ')YesXLGCLR Allow NULL? 
324TAXPSTax document item numbernvarchar60NUMC(N'000000')YesTAX_POSNR Allow NULL? 
325PAYS_PROVPayment Service Providernvarchar40CHAR(N' ')Yes*COM_WEC_PAYMENT_SRV_PROVIDER Allow NULL? 
326PAYS_TRANPayment Reference of Payment Service Providernvarchar350CHAR(N' ')YesFPS_TRANSACTION Allow NULL? 
327MNDIDUnique Referene to Mandate per Payment Recipientnvarchar350CHAR(N' ')YesSEPA_MNDID Allow NULL? 
328XFRGE_BSEGPayment Is Releasedchar10CHAR(N' ')YesXFRGE_BSEG Allow NULL? 
329RE_BUKRSCash Ledger: Company Code for Expense/Revenuenvarchar40CHAR(N' ')Yes*FAGL_RE_BUKRS Allow NULL? 
330RE_ACCOUNTCash Ledger: Expense or Revenue Accountnvarchar100CHAR(N' ')Yes*FAGL_RE_ACCOUNT Allow NULL? 
331PGEBERPartner Fundnvarchar100CHAR(N' ')Yes*FM_PFUND Allow NULL? 
332PGRANT_NBRPartner Grantnvarchar200CHAR(N' ')YesGM_GRANT_PARTNER Allow NULL? 
333BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
334PBUDGET_PDFM: Partner Budget Periodnvarchar100CHAR(N' ')Yes*FM_PBUDGET_PERIOD Allow NULL? 
335J_1TPBUPLBranch Codenvarchar50CHAR(N' ')YesBCODE Allow NULL? 
336PEROP_BEGBilling Period of Performance Start Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_LOW Allow NULL? 
337PEROP_ENDBilling Period of Performance End Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_HIGH Allow NULL? 
338FASTPAYPPA Fast Pay Indicatorchar10CHAR(N' ')YesFMFG_FASTPAY_FLG Allow NULL? 
339IGNR_IVREFFMFG: Ignore the invoice reference during FI doc splittingchar10CHAR(N' ')YesFMFG_IGNORE_INV_REF Allow NULL? 
340FMFGUS_KEYUnited States Federal Government Fieldsnvarchar220CHAR(N' ')YesFMFG_US_KEY Allow NULL? 
341FMXDOCNRFM Reference Document Numbernvarchar100CHAR(N' ')YesFM_XDOCNR Allow NULL? 
342FMXYEARFM Reference Yearnvarchar40NUMC(N'0000')YesFM_XYEAR Allow NULL? 
343FMXDOCLNFM Reference Line Itemnvarchar60NUMC(N'000000')YesFM_XDOCLN Allow NULL? 
344FMXZEKKNFM Reference Sequence Account Assignmentnvarchar50NUMC(N'00000')YesFM_XZEKKN Allow NULL? 
345PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
NamePrimaryUniqueTypeColumns
BSEG~0YesYesCLUSTEREDBUZEI, GJAHR, BELNR, BUKRS, MANDT