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
7BSEG345Accounting Document Segment
8/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
9AUDLORIPR7KPro: Logical Information Object Attribute Values
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8OSRN20Serial Numbers Master Data
9JDT1110Journal Entry - Rows
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
1ERP EHP76.0FUDT_VDOCBSEGH3271Verification Document Segment with Additional Info(History)
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, 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, VDOCSTATUS, RE_BUKRS, RE_ACCOUNT, BUDGET_PD, PBUDGET_PD, PGEBER, PGRANT_NBR, PEROP_BEG, PEROP_END, FASTPAY, IGNR_IVREF, PRODPER FROM FUDT_VDOCBSEGH
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? 
20DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
21WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
22KZBTROriginal Reduction Amount in Local Currencydecimal132CURR((0))YesKZBTR_FI
23PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
24PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')YesTCURCPSWSL Allow NULL? 
25TXBHWOriginal Tax Base Amount in Local Currencydecimal132CURR((0))YesTXBHW
26TXBFWOriginal Tax Base Amount in Document Currencydecimal132CURR((0))YesTXBFW
27MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
28WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
29HWBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
30FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
31HWZUZProvision Amount in Local Currencydecimal132CURR((0))YesHWZUZ
32FWZUZAdditional Tax in Document Currencydecimal132CURR((0))YesFWZUZ
33SHZUZDebit/Credit Addition for Cash Discountchar10CHAR(N' ')YesSHZUZ Allow NULL? 
34STEKZVersion Number Componentnvarchar20CHAR(N' ')YesCHAR2 Allow NULL? 
35MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
36TXGRPGroup Indicator for Tax Line Itemsnvarchar30NUMC(N'000')YesTXGRP Allow NULL? 
37KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
38QSSHBWithholding Tax Base Amountdecimal132CURR((0))YesQSSHB
39KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
40GBETRHedged Amount in Foreign Currencydecimal132CURR((0))YesGBETR
41BDIFFValuation Differencedecimal132CURR((0))YesBDIFF
42BDIF2Valuation Difference for the Second Local Currencydecimal132CURR((0))YesBDIF2
43VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
44ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
45SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
46ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
47VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')YesT880RASSC Allow NULL? 
48BEWARTransaction Typenvarchar30CHAR(N' ')YesT856RMVCT Allow NULL? 
49ALTKTGroup account numbernvarchar100CHAR(N' ')Yes*BILKT_SKA1 Allow NULL? 
50VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')YesVORGN Allow NULL? 
51FDLEVPlanning levelnvarchar20CHAR(N' ')YesT036FDLEV Allow NULL? 
52FDGRPPlanning Groupnvarchar100CHAR(N' ')YesT035FDGRP Allow NULL? 
53FDWBTPlanning amount in document currencydecimal132CURR((0))YesFDWBT
54FDTAGPlanning datenvarchar80DATS(N'00000000')YesFDTAG Allow NULL? 
55FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
56KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
57KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
58PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
59AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
60VBELNBilling Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VF Allow NULL? 
61VBEL2Sales Documentnvarchar100CHAR(N' ')YesVBUKVBELN_VA Allow NULL? 
62POSN2Sales Document Itemnvarchar60NUMC(N'000000')YesVBUPPOSNR_VA Allow NULL? 
63ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')YesVBEPETENR Allow NULL? 
64ANLN1Main Asset Numbernvarchar120CHAR(N' ')YesANLHANLN1 Allow NULL? 
65ANLN2Asset Subnumbernvarchar40CHAR(N' ')YesANLAANLN2 Allow NULL? 
66ANBWAAsset Transaction Typenvarchar30CHAR(N' ')YesTABWANBWA Allow NULL? 
67BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
68PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
69XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
70XHRESIndicator: Resident G/L account?char10CHAR(N' ')YesXHRES Allow NULL? 
71XKRESIndicator: Can Line Items Be Displayed by Account?char10CHAR(N' ')YesXKRES Allow NULL? 
72XOPVWIndicator: Open Item Management?char10CHAR(N' ')YesXOPVW Allow NULL? 
73XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
74XSKSTIndicator: Statistical posting to cost centerchar10CHAR(N' ')YesXSKST Allow NULL? 
75XSAUFIndicator: Posting to order is statisticalchar10CHAR(N' ')YesXSAUF Allow NULL? 
76XSPROIndicator: Posting to project is statisticalchar10CHAR(N' ')YesXSPRO Allow NULL? 
77XSERGIndicator: Posting to prof.analysis is statisticalchar10CHAR(N' ')YesXSERG Allow NULL? 
78XFAKTIndicator: Billing document update successful ?char10CHAR(N' ')YesXFAKT Allow NULL? 
79XUMANIndicator: Transfer posting from down payment ?char10CHAR(N' ')YesXUMAN Allow NULL? 
80XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
81XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
82XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
83XPANZDisplay itemchar10CHAR(N' ')YesXPANZ Allow NULL? 
84XAUTOIndicator: Line item automatically createdchar10CHAR(N' ')YesXAUTO Allow NULL? 
85XNCOPIndicator: Items cannot be copied?char10CHAR(N' ')YesXNCOP Allow NULL? 
86XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
87SAKNRG/L Account Numbernvarchar100CHAR(N' ')YesSKB1SAKNR Allow NULL? 
88HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')YesSKB1HKONT Allow NULL? 
89KUNNRCustomer Numbernvarchar100CHAR(N' ')YesKNA1KUNNR Allow NULL? 
90LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')YesLFA1LIFNR Allow NULL? 
91FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
92XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
93GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
94HZUONAssignment Number for Special G/L Accountsnvarchar180CHAR(N' ')YesHZUON Allow NULL? 
95ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
96ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
97ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
98ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
99ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
100ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
101ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
102SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
103SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
104WSKTOCash discount amount in document currencydecimal132CURR((0))YesWSKTO
105ZLSCHPayment Methodchar10CHAR(N' ')YesT042ZSCHZW_BSEG Allow NULL? 
106ZLSPRPayment Block Keychar10CHAR(N' ')YesT008DZLSPR Allow NULL? 
107ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
108HBKIDShort Key for a House Banknvarchar50CHAR(N' ')YesT012HBKID Allow NULL? 
109BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
110NEBTRNet Payment Amountdecimal132CURR((0))YesNEBTR
111MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')YesT007AMWSKX Allow NULL? 
112DMBT1Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
113WRBT1Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
114MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')YesT007AMWSKX Allow NULL? 
115DMBT2Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
116WRBT2Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
117MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')YesT007AMWSKX Allow NULL? 
118DMBT3Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
119WRBT3Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
120REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
121REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
122REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
123REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
124ZOLLTCustoms Tariff Numbernvarchar80CHAR(N' ')YesDZOLLT Allow NULL? 
125ZOLLDCustoms Datenvarchar80DATS(N'00000000')YesDZOLLD Allow NULL? 
126LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')YesT015LLZBKZ Allow NULL? 
127LANDLSupplying Countrynvarchar30CHAR(N' ')YesT005LANDL Allow NULL? 
128DIEKZService Indicator (Foreign Payment)char10CHAR(N' ')YesDIEKZ Allow NULL? 
129SAMNRInvoice List Numbernvarchar80NUMC(N'00000000')YesSAMNR Allow NULL? 
130ABPERSettlement periodnvarchar60ACCP(N' ')YesABPER_RF Allow NULL? 
131VRSKZInsurance indicatorchar10CHAR(N' ')YesVRSKZ Allow NULL? 
132VRSDTInsurance datenvarchar80DATS(N'00000000')YesVRSDT Allow NULL? 
133DISBNNumber of Bill of Exchange Usage Document (Discount Doc.)nvarchar100CHAR(N' ')YesDISBN Allow NULL? 
134DISBJFiscal Year of Bill of Exchange Usage Documentnvarchar40NUMC(N'0000')YesDISBJ Allow NULL? 
135DISBZLine Item within the Bill of Exchange Usage Documentnvarchar30NUMC(N'000')YesDISBZ Allow NULL? 
136WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
137ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100CHAR(N' ')YesANFBN Allow NULL? 
138ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40NUMC(N'0000')YesANFBJ Allow NULL? 
139ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40CHAR(N' ')YesT001ANFBU Allow NULL? 
140ANFAEBill of Exchange Payment Request Due Datenvarchar80DATS(N'00000000')YesANFAE Allow NULL? 
141BLNBTBase Amount for Determining the Preference Amountdecimal132CURR((0))YesBLNBT
142BLNKZSubsidy indicator for determining the reduction ratesnvarchar20CHAR(N' ')Yes*BLNKZ Allow NULL? 
143BLNPZPreference Percentage Ratedecimal72DEC((0))YesBLNPZ
144MSCHLDunning keychar10CHAR(N' ')YesT040MSCHL Allow NULL? 
145MANSPDunning blockchar10CHAR(N' ')YesT040SMANSP Allow NULL? 
146MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
147MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
148MABERDunning Areanvarchar20CHAR(N' ')YesT047MMABER Allow NULL? 
149ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
150ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
151ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
152KLIBTCredit Control Amountdecimal132CURR((0))YesKLIBT
153QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
154QBSHBWithholding Tax Amount (in Document Currency)decimal132CURR((0))YesQBSHB
155QSFBTWithholding Tax-Exempt Amount (in Document Currency)decimal132CURR((0))YesQSFBT
156NAVHWNon-Deductible Input Tax (in Local Currency)decimal132CURR((0))YesNAVHW
157NAVFWNon-Deductible Input Tax (in Document Currency)decimal132CURR((0))YesNAVFW
158MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
159WERKSPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
160MENGEQuantitydecimal133QUAN((0))YesMENGE_D
161MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
162ERFMGQuantity in Unit of Entrydecimal133QUAN((0))YesERFMG
163ERFMEUnit of Entrynvarchar30UNIT(N' ')YesT006ERFME Allow NULL? 
164BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))YesBPMNG
165BPRMEOrder Price Unit (Purchasing)nvarchar30UNIT(N' ')YesT006BPRME Allow NULL? 
166EBELNPurchasing Document Numbernvarchar100CHAR(N' ')YesEKKOEBELN Allow NULL? 
167EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')YesEKPOEBELP Allow NULL? 
168ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
169ELIKZ"Delivery Completed" Indicatorchar10CHAR(N' ')YesELIKZ Allow NULL? 
170VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
171PEINHPrice Unitdecimal50DEC((0))YesPEINH
172BWKEYValuation Areanvarchar40CHAR(N' ')YesT001KBWKEY Allow NULL? 
173BWTARValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
174BUSTWPosting string for valuesnvarchar40CHAR(N' ')YesBUSTW Allow NULL? 
175REWRTInvoice Value Entered (in Local Currency)decimal132CURR((0))YesREEWR
176REWWRInvoice value in foreign currencydecimal132CURR((0))YesREFWR
177BONFBAmount Qualifying for Bonus in Local Currencydecimal132CURR((0))YesBONFB
178BUALTAmount posted in alternative price controldecimal132CURR((0))YesBUALT
179PSALTAlternative Price Controlchar10CHAR(N' ')YesPSALT Allow NULL? 
180NPREINew pricedecimal112CURR((0))YesNPREI
181TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
182SPGRPBlocking reason: pricechar10CHAR(N' ')YesSPGRP Allow NULL? 
183SPGRMBlocking reason: quantitychar10CHAR(N' ')YesSPGRM Allow NULL? 
184SPGRTBlocking Reason: Datechar10CHAR(N' ')YesSPGRT Allow NULL? 
185SPGRGBlocking reason: order price quantitychar10CHAR(N' ')YesSPGRG Allow NULL? 
186SPGRVBlocking reason: project budgetchar10CHAR(N' ')YesSPGRV Allow NULL? 
187SPGRQManual Blocking Reasonchar10CHAR(N' ')YesSPGRQ Allow NULL? 
188STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
189EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')YesT005EGBLD Allow NULL? 
190EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')YesT005EGLLD Allow NULL? 
191RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')YesT053RRSTGR Allow NULL? 
192RYACQYear of acquisitionnvarchar40CHAR(N' ')YesRYACQ Allow NULL? 
193RPACQPeriod of Acquisitionnvarchar30NUMC(N'000')YesRPACQ Allow NULL? 
194RDIFFExchange Rate Gain/Loss Realizeddecimal132CURR((0))YesRDIFF
195RDIF2Exchange Rate Difference Realized for Second Local Currencydecimal132CURR((0))YesRDIF2
196PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
197XHKOMIndicator: G/L account assigned manually ?char10CHAR(N' ')YesXHKOM Allow NULL? 
198VNAMEJoint Venturenvarchar60CHAR(N' ')YesT8JVJV_NAME Allow NULL? 
199RECIDRecovery Indicatornvarchar20CHAR(N' ')YesT8JJJV_RECIND Allow NULL? 
200EGRUPEquity groupnvarchar30CHAR(N' ')YesT8JFJV_EGROUP Allow NULL? 
201VPTNRPartner account numbernvarchar100CHAR(N' ')YesKNA1JV_PART Allow NULL? 
202VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
203VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
204VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
205DEPOTSecurities Accountnvarchar100CHAR(N' ')Yes*RLDEPO Allow NULL? 
206TXJCDTax Jurisdictionnvarchar150CHAR(N' ')YesTTXJTXJCD Allow NULL? 
207IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
208DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
209POPTSReal estate option ratedecimal96DEC((0))YesPOPTSATZ
210FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
211KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
212NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
213AUFPLTask list number for operations in ordernvarchar100NUMC(N'0000000000')YesAUFPL_CH Allow NULL? 
214APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')Yes*APLZL_CH Allow NULL? 
215PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
216PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
217PASUBNRProfitability segment changes (CO-PA)nvarchar40NUMC(N'0000')YesRKESUBNR Allow NULL? 
218SPGRSBlocking Reason: Item Amountchar10CHAR(N' ')YesSPGRS Allow NULL? 
219SPGRCBlock.reason: qualitychar10CHAR(N' ')YesSPGRC Allow NULL? 
220BTYPEPayroll Typenvarchar20CHAR(N' ')YesT8JAJV_BILIND Allow NULL? 
221ETYPEEquity typenvarchar30CHAR(N' ')YesT8JEJV_ETYPE Allow NULL? 
222XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
223LNRANSequence number of asset line items in fiscal yearnvarchar50NUMC(N'00000')Yes*LNRAN Allow NULL? 
224HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
225DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
226DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
227DMB21Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
228DMB22Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
229DMB23Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
230DMB31Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
231DMB32Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
232DMB33Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
233MWST2Tax Amount in Second Local Currencydecimal132CURR((0))YesMWST2
234MWST3Tax Amount in Third Local Currencydecimal132CURR((0))YesMWST3
235NAVH2Non-Deductible Input Tax in Second Local Currencydecimal132CURR((0))YesNAVH2
236NAVH3Non-Deductible Input Tax in Third Local Currencydecimal132CURR((0))YesNAVH3
237SKNT2Cash Discount Amount in Second Local Currencydecimal132CURR((0))YesSKNT2
238SKNT3Cash Discount Amount in Third Local Currencydecimal132CURR((0))YesSKNT3
239BDIF3Valuation Difference for the Third Local Currencydecimal132CURR((0))YesBDIF3
240RDIF3Exchange Rate Difference Realized for Third Local Currencydecimal132CURR((0))YesRDIF3
241HWMETMethod with Which the Local Currency Amount Was Determinedchar10CHAR(N' ')YesHWMET Allow NULL? 
242GLUPMUpdate Method for FM - FI-CA Integrationchar10CHAR(N' ')YesGLUPM Allow NULL? 
243XRAGLIndicator: Clearing was Reversedchar10CHAR(N' ')YesXRAGL Allow NULL? 
244UZAWEPayment Method Supplementnvarchar20CHAR(N' ')YesT042FUZAWE Allow NULL? 
245LOKKTAlternative account number in company codenvarchar100CHAR(N' ')Yes*ALTKT_SKB1 Allow NULL? 
246FISTLFunds Centernvarchar160CHAR(N' ')Yes*FISTL Allow NULL? 
247GEBERFundnvarchar100CHAR(N' ')Yes*BP_GEBER Allow NULL? 
248STBUKTax Company Codenvarchar40CHAR(N' ')Yes*STBUK Allow NULL? 
249TXBH2Tax Base/Original Tax Base in Second Local Currencydecimal132CURR((0))YesTXBH2
250TXBH3Tax Base/Original Tax Base in Third Local Currencydecimal132CURR((0))YesTXBH3
251PPRCTPartner Profit Centernvarchar100CHAR(N' ')YesCEPCPPRCTR Allow NULL? 
252XREF1Business partner reference keynvarchar120CHAR(N' ')YesXREF1 Allow NULL? 
253XREF2Business partner reference keynvarchar120CHAR(N' ')YesXREF2 Allow NULL? 
254KBLNRDocument Number for Earmarked Fundsnvarchar100CHAR(N' ')YesKBLKKBLNR_FI Allow NULL? 
255KBLPOSEarmarked Funds: Document Itemnvarchar30NUMC(N'000')YesKBLPKBLPOS Allow NULL? 
256STTAXTax amount as statistical information in document currencydecimal132CURR((0))YesSTTAX
257FKBERFunctional Areanvarchar40CHAR(N' ')YesFKBER_SHORT Allow NULL? 
258OBZEINumber of Line Item in Original Documentnvarchar30NUMC(N'000')YesOBZEI Allow NULL? 
259XNEGPIndicator: Negative postingchar10CHAR(N' ')YesXNEGP Allow NULL? 
260RFZEIPayment Card Itemnvarchar30NUMC(N'000')YesRFZEI_CC Allow NULL? 
261CCBTCPayment cards: Settlement runnvarchar100CHAR(N' ')YesCCBTC Allow NULL? 
262KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
263EMPFBPayee/Payernvarchar100CHAR(N' ')YesEMPFB Allow NULL? 
264XREF3Reference key for line itemnvarchar200CHAR(N' ')YesXREF3 Allow NULL? 
265DTWS1Instruction key 1nvarchar20NUMC(N'00')Yes*DTAT16 Allow NULL? 
266DTWS2Instruction key 2nvarchar20NUMC(N'00')Yes*DTAT17 Allow NULL? 
267DTWS3Instruction key 3nvarchar20NUMC(N'00')Yes*DTAT18 Allow NULL? 
268DTWS4Instruction key 4nvarchar20NUMC(N'00')Yes*DTAT19 Allow NULL? 
269GRICDActivity Code for Gross Income Taxnvarchar20CHAR(N' ')YesJ_1AGICDJ_1AGICD_D Allow NULL? 
270GRIRGRegion (State, Province, County)nvarchar30CHAR(N' ')YesT005SREGIO Allow NULL? 
271GITYPDistribution Type for Employment Taxnvarchar20CHAR(N' ')YesJ_1ADTYPJ_1ADTYP_D Allow NULL? 
272XPYPRIndicator: Items from Payment Program Blockedchar10CHAR(N' ')YesXPYPR Allow NULL? 
273KIDNOPayment Referencenvarchar300CHAR(N' ')YesKIDNO Allow NULL? 
274ABSBTCredit management: Hedged amountdecimal132CURR((0))YesABSBT
275IDXSPInflation Indexnvarchar50CHAR(N' ')YesJ_1AINFT20J_1AINDXSP Allow NULL? 
276LINFVLast Adjustment Datenvarchar80DATS(N'00000000')YesJ_1ALINFVL Allow NULL? 
277KONTTAccount Assignment Category for Industry Solutionnvarchar20CHAR(N' ')YesKONTT_FI Allow NULL? 
278KONTLAcct assignment string for industry-specific acct assignmntsnvarchar500CHAR(N' ')YesKONTL_FI Allow NULL? 
279TXDATDate for defining tax ratesnvarchar80DATS(N'00000000')YesTXDAT Allow NULL? 
280AGZEIClearing Itemdecimal50DEC((0))YesAGZEI
281PYCURCurrency for Automatic Paymentnvarchar50CUKY(N' ')YesTCURCPYCUR Allow NULL? 
282PYAMTAmount in Payment Currencydecimal132CURR((0))YesPYAMT
283BUPLABusiness Placenvarchar40CHAR(N' ')YesJ_1BBRANCHBUPLA Allow NULL? 
284SECCOSection Codenvarchar40CHAR(N' ')YesSECCODESECCO Allow NULL? 
285LSTARActivity Typenvarchar60CHAR(N' ')Yes*LSTAR Allow NULL? 
286CESSION_KZAccounts Receivable Pledging Indicatornvarchar20CHAR(N' ')YesTCESSIONCESSION_KZ Allow NULL? 
287PRZNRBusiness Processnvarchar120CHAR(N' ')Yes*CO_PRZNR Allow NULL? 
288PPDIFFRealized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIFF
289PPDIF2Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)decimal132CURR((0))YesPPDIF2
290PPDIF3Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)decimal132CURR((0))YesPPDIF3
291PENLC1Penalty charge amount in first local currencydecimal132CURR((0))YesPENALTY1
292PENLC2Penalty charge amount in second local currencydecimal132CURR((0))YesPENALTY2
293PENLC3Penalty Charge Amount in Third Local Currencydecimal132CURR((0))YesPENALTY3
294PENFCPenalty charge amount in document currencydecimal132CURR((0))YesPENALTY
295PENDAYSNumber of days for penalty charge calculationint100INT4((0))YesPDAYS Allow NULL? 
296PENRCReason for late paymentnvarchar20CHAR(N' ')YesPENRC Allow NULL? 
297GRANT_NBRGrantnvarchar200CHAR(N' ')YesGM_GRANT_NBR Allow NULL? 
298SCTAXTax portion FI-CA local currencydecimal132CURR((0))YesSCTAX
299FKBER_LONGFunctional Areanvarchar160CHAR(N' ')Yes*FKBER Allow NULL? 
300GMVKZItem is in Executionchar10CHAR(N' ')YesFM_GMVKZ Allow NULL? 
301SRTYPEType of Additional Receivablenvarchar20CHAR(N' ')YesFM_SRTYPE Allow NULL? 
302INTRENOInternal Real Estate Master Data Codenvarchar130CHAR(N' ')YesVVINTRENO Allow NULL? 
303MEASUREFunded Programnvarchar240CHAR(N' ')Yes*FM_MEASURE Allow NULL? 
304AUGGJFiscal Year of Clearing Documentnvarchar40NUMC(N'0000')YesAUGGJ Allow NULL? 
305PPA_EX_INDPPA Exclude Indicatorchar10CHAR(N' ')YesEXCLUDE_FLG Allow NULL? 
306DOCLNSix-Character Posting Item for Ledgernvarchar60CHAR(N' ')YesDOCLN6 Allow NULL? 
307SEGMENTSegment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_SEGMENT Allow NULL? 
308PSEGMENTPartner Segment for Segmental Reportingnvarchar100CHAR(N' ')Yes*FB_PSEGMENT Allow NULL? 
309PFKBERPartner Functional Areanvarchar160CHAR(N' ')Yes*SFKBER Allow NULL? 
310HKTIDID for account detailsnvarchar50CHAR(N' ')YesT012KHKTID Allow NULL? 
311KSTARCost Elementnvarchar100CHAR(N' ')Yes*KSTAR Allow NULL? 
312XLGCLRClearing Specific to Ledger Groupschar10CHAR(N' ')YesXLGCLR Allow NULL? 
313TAXPSTax document item numbernvarchar60NUMC(N'000000')YesTAX_POSNR Allow NULL? 
314PAYS_PROVPayment Service Providernvarchar40CHAR(N' ')Yes*COM_WEC_PAYMENT_SRV_PROVIDER Allow NULL? 
315PAYS_TRANPayment Reference of Payment Service Providernvarchar350CHAR(N' ')YesFPS_TRANSACTION Allow NULL? 
316VDOCSTATUSFI Document Verification Statuschar10CHAR(N' ')YesFUD_FIDOC_STATUS Allow NULL? 
317RE_BUKRSCash Ledger: Company Code for Expense/Revenuenvarchar40CHAR(N' ')Yes*FAGL_RE_BUKRS Allow NULL? 
318RE_ACCOUNTCash Ledger: Expense or Revenue Accountnvarchar100CHAR(N' ')Yes*FAGL_RE_ACCOUNT Allow NULL? 
319BUDGET_PDFM: Budget Periodnvarchar100CHAR(N' ')Yes*FM_BUDGET_PERIOD Allow NULL? 
320PBUDGET_PDFM: Partner Budget Periodnvarchar100CHAR(N' ')Yes*FM_PBUDGET_PERIOD Allow NULL? 
321PGEBERPartner Fundnvarchar100CHAR(N' ')Yes*FM_PFUND Allow NULL? 
322PGRANT_NBRPartner Grantnvarchar200CHAR(N' ')YesGM_GRANT_PARTNER Allow NULL? 
323PEROP_BEGBilling Period of Performance Start Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_LOW Allow NULL? 
324PEROP_ENDBilling Period of Performance End Datenvarchar80DATS(N'00000000')YesFM_PEROP_FI_HIGH Allow NULL? 
325FASTPAYPPA Fast Pay Indicatorchar10CHAR(N' ')YesFMFG_FASTPAY_FLG Allow NULL? 
326IGNR_IVREFFMFG: Ignore the invoice reference during FI doc splittingchar10CHAR(N' ')YesFMFG_IGNORE_INV_REF Allow NULL? 
327PRODPERProduction Month (Date to find period and year)nvarchar80DATS(N'00000000')YesJV_PRODPER Allow NULL? 
NamePrimaryUniqueTypeColumns
FUDT_VDOCBSEGH~0YesYesCLUSTEREDBUZEI, GJAHR, BELNR, BUKRS, MANDT