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
8BSEG345Accounting Document Segment
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
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OPOR386Purchase Order
9JDT1124Journal Entry - Rows
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OPCH268A/P Invoice
6OIVL77Whse Journal
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/BEV3/CH1030BSG12422Document Segment CH Event Ledger Part1Remaining Beverage - Obsolete Objects
SQL:  selectupdate insert create

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

SELECT MANDT, EVENT, EVENT_NR, BUZEI, BUKRS, BELNR, GJAHR, 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 FROM /BEV3/CH1030BSG1
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2EVENTEvent for export of business datanvarchar80CHAR(N' ')No*BUS_EVENT Allow NULL? 
3EVENT_NRCH BTE Sequence Number of Event Receiptnvarchar160NUMC(N'0000000000000000')No/BEV3/CHEVENR Allow NULL? 
4BUZEINumber of Line Item Within Accounting Documentnvarchar30NUMC(N'000')NoBUZEI Allow NULL? 
5BUKRSCompany Codenvarchar40CHAR(N' ')No*BUKRS Allow NULL? 
6BELNRAccounting Document Numbernvarchar100CHAR(N' ')NoBELNR_D Allow NULL? 
7GJAHRFiscal Yearnvarchar40NUMC(N'0000')NoGJAHR Allow NULL? 
8BUZIDIdentification of the Line Itemchar10CHAR(N' ')YesBUZID Allow NULL? 
9AUGDTClearing Datenvarchar80DATS(N'00000000')YesAUGDT Allow NULL? 
10AUGCPClearing Entry Datenvarchar80DATS(N'00000000')YesAUGCP Allow NULL? 
11AUGBLDocument Number of the Clearing Documentnvarchar100CHAR(N' ')YesAUGBL Allow NULL? 
12BSCHLPosting Keynvarchar20CHAR(N' ')Yes*BSCHL Allow NULL? 
13KOARTAccount Typechar10CHAR(N' ')YesKOART Allow NULL? 
14UMSKZSpecial G/L Indicatorchar10CHAR(N' ')Yes*UMSKZ Allow NULL? 
15UMSKSSpecial G/L Transaction Typechar10CHAR(N' ')YesUMSKS Allow NULL? 
16ZUMSKTarget Special G/L Indicatorchar10CHAR(N' ')Yes*DZUMSK Allow NULL? 
17SHKZGDebit/Credit Indicatorchar10CHAR(N' ')YesSHKZG Allow NULL? 
18GSBERBusiness Areanvarchar40CHAR(N' ')Yes*GSBER Allow NULL? 
19PARGBTrading partner's business areanvarchar40CHAR(N' ')Yes*PARGB Allow NULL? 
20MWSKZTax on sales/purchases codenvarchar20CHAR(N' ')Yes*MWSKZ Allow NULL? 
21QSSKZWithholding Tax Codenvarchar20CHAR(N' ')Yes*QSSKZ Allow NULL? 
22DMBTRAmount in Local Currencydecimal132CURR((0))YesDMBTR
23WRBTRAmount in document currencydecimal132CURR((0))YesWRBTR
24KZBTROriginal Reduction Amount in Local Currencydecimal132CURR((0))YesKZBTR_FI
25PSWBTAmount for Updating in General Ledgerdecimal132CURR((0))YesPSWBT
26PSWSLUpdate Currency for General Ledger Transaction Figuresnvarchar50CUKY(N' ')Yes*PSWSL Allow NULL? 
27TXBHWOriginal Tax Base Amount in Local Currencydecimal132CURR((0))YesTXBHW
28TXBFWOriginal Tax Base Amount in Document Currencydecimal132CURR((0))YesTXBFW
29MWSTSTax Amount in Local Currencydecimal132CURR((0))YesMWSTS
30WMWSTTax amount in document currencydecimal132CURR((0))YesWMWST
31HWBASTax Base Amount in Local Currencydecimal132CURR((0))YesHWBAS
32FWBASTax Base Amount in Document Currencydecimal132CURR((0))YesFWBAS
33HWZUZProvision Amount in Local Currencydecimal132CURR((0))YesHWZUZ
34FWZUZAdditional Tax in Document Currencydecimal132CURR((0))YesFWZUZ
35SHZUZDebit/Credit Addition for Cash Discountchar10CHAR(N' ')YesSHZUZ Allow NULL? 
36STEKZVersion Number Componentnvarchar20CHAR(N' ')YesCHAR2 Allow NULL? 
37MWARTTax Typechar10CHAR(N' ')YesMWART Allow NULL? 
38TXGRPGroup Indicator for Tax Line Itemsnvarchar30NUMC(N'000')YesTXGRP Allow NULL? 
39KTOSLTransaction Keynvarchar30CHAR(N' ')YesKTOSL Allow NULL? 
40QSSHBWithholding Tax Base Amountdecimal132CURR((0))YesQSSHB
41KURSRHedged Exchange Ratedecimal95DEC((0))YesKURSR
42GBETRHedged Amount in Foreign Currencydecimal132CURR((0))YesGBETR
43BDIFFValuation Differencedecimal132CURR((0))YesBDIFF
44BDIF2Valuation Difference for the Second Local Currencydecimal132CURR((0))YesBDIF2
45VALUTValue datenvarchar80DATS(N'00000000')YesVALUT Allow NULL? 
46ZUONRAssignment Numbernvarchar180CHAR(N' ')YesDZUONR Allow NULL? 
47SGTXTItem Textnvarchar500CHAR(N' ')YesSGTXT Allow NULL? 
48ZINKZExempted from interest calculationnvarchar20CHAR(N' ')YesDZINKZ Allow NULL? 
49VBUNDCompany ID of trading partnernvarchar60CHAR(N' ')Yes*RASSC Allow NULL? 
50BEWARTransaction Typenvarchar30CHAR(N' ')Yes*RMVCT Allow NULL? 
51ALTKTGroup account numbernvarchar100CHAR(N' ')Yes*BILKT_SKA1 Allow NULL? 
52VORGNTransaction Type for General Ledgernvarchar40CHAR(N' ')YesVORGN Allow NULL? 
53FDLEVPlanning levelnvarchar20CHAR(N' ')Yes*FDLEV Allow NULL? 
54FDGRPPlanning Groupnvarchar100CHAR(N' ')Yes*FDGRP Allow NULL? 
55FDWBTPlanning amount in document currencydecimal132CURR((0))YesFDWBT
56FDTAGPlanning datenvarchar80DATS(N'00000000')YesFDTAG Allow NULL? 
57FKONTFinancial Budget Itemnvarchar30NUMC(N'000')YesFIPLS Allow NULL? 
58KOKRSControlling Areanvarchar40CHAR(N' ')Yes*KOKRS Allow NULL? 
59KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
60PROJNOld: Project number : No longer used --> PS_POSNRnvarchar160CHAR(N' ')YesPROJN Allow NULL? 
61AUFNROrder Numbernvarchar120CHAR(N' ')Yes*AUFNR Allow NULL? 
62VBELNBilling Documentnvarchar100CHAR(N' ')Yes*VBELN_VF Allow NULL? 
63VBEL2Sales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
64POSN2Sales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
65ETEN2Delivery Schedule Line Numbernvarchar40NUMC(N'0000')Yes*ETENR Allow NULL? 
66ANLN1Main Asset Numbernvarchar120CHAR(N' ')Yes*ANLN1 Allow NULL? 
67ANLN2Asset Subnumbernvarchar40CHAR(N' ')Yes*ANLN2 Allow NULL? 
68ANBWAAsset Transaction Typenvarchar30CHAR(N' ')Yes*ANBWA Allow NULL? 
69BZDATAsset value datenvarchar80DATS(N'00000000')YesBZDAT Allow NULL? 
70PERNRPersonnel Numbernvarchar80NUMC(N'00000000')YesPERNR_D Allow NULL? 
71XUMSWIndicator: Sales-related item ?char10CHAR(N' ')YesXUMSW Allow NULL? 
72XHRESIndicator: Resident G/L account?char10CHAR(N' ')YesXHRES Allow NULL? 
73XKRESIndicator: Can Line Items Be Displayed by Account?char10CHAR(N' ')YesXKRES Allow NULL? 
74XOPVWIndicator: Open Item Management?char10CHAR(N' ')YesXOPVW Allow NULL? 
75XCPDDIndicator: Address and bank data set individuallychar10CHAR(N' ')YesXCPDD Allow NULL? 
76XSKSTIndicator: Statistical posting to cost centerchar10CHAR(N' ')YesXSKST Allow NULL? 
77XSAUFIndicator: Posting to order is statisticalchar10CHAR(N' ')YesXSAUF Allow NULL? 
78XSPROIndicator: Posting to project is statisticalchar10CHAR(N' ')YesXSPRO Allow NULL? 
79XSERGIndicator: Posting to prof.analysis is statisticalchar10CHAR(N' ')YesXSERG Allow NULL? 
80XFAKTIndicator: Billing document update successful ?char10CHAR(N' ')YesXFAKT Allow NULL? 
81XUMANIndicator: Transfer posting from down payment ?char10CHAR(N' ')YesXUMAN Allow NULL? 
82XANETIndicator: Down payment in net procedure ?char10CHAR(N' ')YesXANET Allow NULL? 
83XSKRLIndicator: Line item not liable to cash discount?char10CHAR(N' ')YesXSKRL Allow NULL? 
84XINVEIndicator: Capital Goods Affected?char10CHAR(N' ')YesXINVE Allow NULL? 
85XPANZDisplay itemchar10CHAR(N' ')YesXPANZ Allow NULL? 
86XAUTOIndicator: Line item automatically createdchar10CHAR(N' ')YesXAUTO Allow NULL? 
87XNCOPIndicator: Items cannot be copied?char10CHAR(N' ')YesXNCOP Allow NULL? 
88XZAHLIndicator: Is the posting key used in a payment transaction?char10CHAR(N' ')YesXZAHL Allow NULL? 
89SAKNRG/L Account Numbernvarchar100CHAR(N' ')Yes*SAKNR Allow NULL? 
90HKONTGeneral Ledger Accountnvarchar100CHAR(N' ')Yes*HKONT Allow NULL? 
91KUNNRCustomer Numbernvarchar100CHAR(N' ')Yes*KUNNR Allow NULL? 
92LIFNRAccount Number of Vendor or Creditornvarchar100CHAR(N' ')Yes*LIFNR Allow NULL? 
93FILKDAccount Number of the Branchnvarchar100CHAR(N' ')YesFILKD Allow NULL? 
94XBILKIndicator: Account is a balance sheet account?char10CHAR(N' ')YesXBILK Allow NULL? 
95GVTYPP&L statement account typenvarchar20CHAR(N' ')YesGVTYP Allow NULL? 
96HZUONAssignment Number for Special G/L Accountsnvarchar180CHAR(N' ')YesHZUON Allow NULL? 
97ZFBDTBaseline Date for Due Date Calculationnvarchar80DATS(N'00000000')YesDZFBDT Allow NULL? 
98ZTERMTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
99ZBD1TCash discount days 1decimal30DEC((0))YesDZBD1T
100ZBD2TCash discount days 2decimal30DEC((0))YesDZBD2T
101ZBD3TNet Payment Terms Perioddecimal30DEC((0))YesDZBD3T
102ZBD1PCash Discount Percentage 1decimal53DEC((0))YesDZBD1P
103ZBD2PCash Discount Percentage 2decimal53DEC((0))YesDZBD2P
104SKFBTAmount Eligible for Cash Discount in Document Currencydecimal132CURR((0))YesSKFBT
105SKNTOCash discount amount in local currencydecimal132CURR((0))YesSKNTO
106WSKTOCash discount amount in document currencydecimal132CURR((0))YesWSKTO
107ZLSCHPayment Methodchar10CHAR(N' ')Yes*SCHZW_BSEG Allow NULL? 
108ZLSPRPayment Block Keychar10CHAR(N' ')Yes*DZLSPR Allow NULL? 
109ZBFIXFixed Payment Termschar10CHAR(N' ')YesDZBFIX Allow NULL? 
110HBKIDShort Key for a House Banknvarchar50CHAR(N' ')Yes*HBKID Allow NULL? 
111BVTYPPartner Bank Typenvarchar40CHAR(N' ')YesBVTYP Allow NULL? 
112NEBTRNet Payment Amountdecimal132CURR((0))YesNEBTR
113MWSK1Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
114DMBT1Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
115WRBT1Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
116MWSK2Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
117DMBT2Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
118WRBT2Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
119MWSK3Tax Code for Distributionnvarchar20CHAR(N' ')Yes*MWSKX Allow NULL? 
120DMBT3Amount in Local Currency for Tax Distributiondecimal132CURR((0))YesDMBTX
121WRBT3Amount in foreign currency for tax breakdowndecimal132CURR((0))YesWRBTX
122REBZGNumber of the Invoice the Transaction Belongs tonvarchar100CHAR(N' ')YesREBZG Allow NULL? 
123REBZJFiscal Year of the Relevant Invoice (for Credit Memo)nvarchar40NUMC(N'0000')YesREBZJ Allow NULL? 
124REBZZLine Item in the Relevant Invoicenvarchar30NUMC(N'000')YesREBZZ Allow NULL? 
125REBZTFollow-On Document Typechar10CHAR(N' ')YesREBZT Allow NULL? 
126ZOLLTCustoms Tariff Numbernvarchar80CHAR(N' ')YesDZOLLT Allow NULL? 
127ZOLLDCustoms Datenvarchar80DATS(N'00000000')YesDZOLLD Allow NULL? 
128LZBKZState Central Bank Indicatornvarchar30CHAR(N' ')Yes*LZBKZ Allow NULL? 
129LANDLSupplying Countrynvarchar30CHAR(N' ')Yes*LANDL 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? 
133VRSKZInsurance indicatorchar10CHAR(N' ')YesVRSKZ Allow NULL? 
134VRSDTInsurance datenvarchar80DATS(N'00000000')YesVRSDT Allow NULL? 
135DISBNNumber of Bill of Exchange Usage Document (Discount Doc.)nvarchar100CHAR(N' ')YesDISBN Allow NULL? 
136DISBJFiscal Year of Bill of Exchange Usage Documentnvarchar40NUMC(N'0000')YesDISBJ Allow NULL? 
137DISBZLine Item within the Bill of Exchange Usage Documentnvarchar30NUMC(N'000')YesDISBZ Allow NULL? 
138WVERWBill of exchange usage typechar10CHAR(N' ')YesWVERW Allow NULL? 
139ANFBNDocument Number of the Bill of Exchange Payment Requestnvarchar100CHAR(N' ')YesANFBN Allow NULL? 
140ANFBJFiscal Year of the Bill of Exchange Payment Request Documentnvarchar40NUMC(N'0000')YesANFBJ Allow NULL? 
141ANFBUCompany Code in Which Bill of Exch.Payment Request Is Postednvarchar40CHAR(N' ')Yes*ANFBU Allow NULL? 
142ANFAEBill of Exchange Payment Request Due Datenvarchar80DATS(N'00000000')YesANFAE Allow NULL? 
143BLNBTBase Amount for Determining the Preference Amountdecimal132CURR((0))YesBLNBT
144BLNKZSubsidy indicator for determining the reduction ratesnvarchar20CHAR(N' ')Yes*BLNKZ Allow NULL? 
145BLNPZPreference Percentage Ratedecimal72DEC((0))YesBLNPZ
146MSCHLDunning keychar10CHAR(N' ')Yes*MSCHL Allow NULL? 
147MANSPDunning blockchar10CHAR(N' ')Yes*MANSP Allow NULL? 
148MADATLast dunned onnvarchar80DATS(N'00000000')YesMADAT Allow NULL? 
149MANSTDunning levelchar10NUMC(N'0')YesMAHNS_D Allow NULL? 
150MABERDunning Areanvarchar20CHAR(N' ')Yes*MABER Allow NULL? 
151ESRNRISR Subscriber Numbernvarchar110CHAR(N' ')YesESRNR Allow NULL? 
152ESRREISR Reference Numbernvarchar270CHAR(N' ')YesESRRE Allow NULL? 
153ESRPZISR Check Digitnvarchar20CHAR(N' ')YesESRPZ Allow NULL? 
154KLIBTCredit Control Amountdecimal132CURR((0))YesKLIBT
155QSZNRCertificate Number of the Withholding Tax Exemptionnvarchar100CHAR(N' ')YesQSZNR Allow NULL? 
156QBSHBWithholding Tax Amount (in Document Currency)decimal132CURR((0))YesQBSHB
157QSFBTWithholding Tax-Exempt Amount (in Document Currency)decimal132CURR((0))YesQSFBT
158NAVHWNon-Deductible Input Tax (in Local Currency)decimal132CURR((0))YesNAVHW
159NAVFWNon-Deductible Input Tax (in Document Currency)decimal132CURR((0))YesNAVFW
160MATNRMaterial Numbernvarchar180CHAR(N' ')Yes*MATNR Allow NULL? 
161WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
162MENGEQuantitydecimal133QUAN((0))YesMENGE_D
163MEINSBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
164ERFMGQuantity in Unit of Entrydecimal133QUAN((0))YesERFMG
165ERFMEUnit of Entrynvarchar30UNIT(N' ')Yes*ERFME Allow NULL? 
166BPMNGQuantity in Purchase Order Price Unitdecimal133QUAN((0))YesBPMNG
167BPRMEOrder Price Unit (Purchasing)nvarchar30UNIT(N' ')Yes*BPRME Allow NULL? 
168EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
169EBELPItem Number of Purchasing Documentnvarchar50NUMC(N'00000')Yes*EBELP Allow NULL? 
170ZEKKNSequential Number of Account Assignmentnvarchar20NUMC(N'00')YesDZEKKN Allow NULL? 
171ELIKZ"Delivery Completed" Indicatorchar10CHAR(N' ')YesELIKZ Allow NULL? 
172VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
173PEINHPrice Unitdecimal50DEC((0))YesPEINH
174BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
175BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
176BUSTWPosting string for valuesnvarchar40CHAR(N' ')YesBUSTW Allow NULL? 
177REWRTInvoice Value Entered (in Local Currency)decimal132CURR((0))YesREEWR
178REWWRInvoice value in foreign currencydecimal132CURR((0))YesREFWR
179BONFBAmount Qualifying for Bonus in Local Currencydecimal132CURR((0))YesBONFB
180BUALTAmount posted in alternative price controldecimal132CURR((0))YesBUALT
181PSALTAlternative Price Controlchar10CHAR(N' ')YesPSALT Allow NULL? 
182NPREINew pricedecimal112CURR((0))YesNPREI
183TBTKZIndicator: subsequent debit/creditchar10CHAR(N' ')YesTBTKZ Allow NULL? 
184SPGRPBlocking reason: pricechar10CHAR(N' ')YesSPGRP Allow NULL? 
185SPGRMBlocking reason: quantitychar10CHAR(N' ')YesSPGRM Allow NULL? 
186SPGRTBlocking Reason: Datechar10CHAR(N' ')YesSPGRT Allow NULL? 
187SPGRGBlocking reason: order price quantitychar10CHAR(N' ')YesSPGRG Allow NULL? 
188SPGRVBlocking reason: project budgetchar10CHAR(N' ')YesSPGRV Allow NULL? 
189SPGRQManual Blocking Reasonchar10CHAR(N' ')YesSPGRQ Allow NULL? 
190STCEGVAT Registration Numbernvarchar200CHAR(N' ')YesSTCEG Allow NULL? 
191EGBLDCountry of Destination for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGBLD Allow NULL? 
192EGLLDSupplying Country for Delivery of Goodsnvarchar30CHAR(N' ')Yes*EGLLD Allow NULL? 
193RSTGRReason Code for Paymentsnvarchar30CHAR(N' ')Yes*RSTGR Allow NULL? 
194RYACQYear of acquisitionnvarchar40CHAR(N' ')YesRYACQ Allow NULL? 
195RPACQPeriod of Acquisitionnvarchar30NUMC(N'000')YesRPACQ Allow NULL? 
196RDIFFExchange Rate Gain/Loss Realizeddecimal132CURR((0))YesRDIFF
197RDIF2Exchange Rate Difference Realized for Second Local Currencydecimal132CURR((0))YesRDIF2
198PRCTRProfit Centernvarchar100CHAR(N' ')Yes*PRCTR Allow NULL? 
199XHKOMIndicator: G/L account assigned manually ?char10CHAR(N' ')YesXHKOM Allow NULL? 
200VNAMEJoint Venturenvarchar60CHAR(N' ')Yes*JV_NAME Allow NULL? 
201RECIDRecovery Indicatornvarchar20CHAR(N' ')Yes*JV_RECIND Allow NULL? 
202EGRUPEquity groupnvarchar30CHAR(N' ')Yes*JV_EGROUP Allow NULL? 
203VPTNRPartner account numbernvarchar100CHAR(N' ')Yes*JV_PART Allow NULL? 
204VERTTContract Typechar10CHAR(N' ')YesRANTYP Allow NULL? 
205VERTNContract Numbernvarchar130CHAR(N' ')YesRANL Allow NULL? 
206VBEWAFlow Typenvarchar40CHAR(N' ')Yes*SBEWART Allow NULL? 
207DEPOTSecurities Accountnvarchar100CHAR(N' ')Yes*RLDEPO Allow NULL? 
208TXJCDTax Jurisdictionnvarchar150CHAR(N' ')Yes*TXJCD Allow NULL? 
209IMKEYInternal Key for Real Estate Objectnvarchar80CHAR(N' ')YesIMKEY Allow NULL? 
210DABRZReference Date for Settlementnvarchar80DATS(N'00000000')YesDABRBEZ Allow NULL? 
211POPTSReal estate option ratedecimal96DEC((0))YesPOPTSATZ
212FIPOSCommitment Itemnvarchar140CHAR(N' ')Yes*FIPOS Allow NULL? 
213KSTRGCost Objectnvarchar120CHAR(N' ')Yes*KSTRG Allow NULL? 
214NPLNRNetwork Number for Account Assignmentnvarchar120CHAR(N' ')Yes*NPLNR Allow NULL? 
215AUFPLTask list number for operations in ordernvarchar100NUMC(N'0000000000')YesAUFPL_CH Allow NULL? 
216APLZLGeneral counter for ordernvarchar80NUMC(N'00000000')Yes*APLZL_CH Allow NULL? 
217PROJKWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')Yes*PS_PSP_PNR Allow NULL? 
218PAOBJNRProfitability Segment Number (CO-PA)nvarchar100NUMC(N'0000000000')YesRKEOBJNR Allow NULL? 
219PASUBNRProfitability segment changes (CO-PA)nvarchar40NUMC(N'0000')YesRKESUBNR Allow NULL? 
220SPGRSBlocking Reason: Item Amountchar10CHAR(N' ')YesSPGRS Allow NULL? 
221SPGRCBlock.reason: qualitychar10CHAR(N' ')YesSPGRC Allow NULL? 
222BTYPEPayroll Typenvarchar20CHAR(N' ')Yes*JV_BILIND Allow NULL? 
223ETYPEEquity typenvarchar30CHAR(N' ')Yes*JV_ETYPE Allow NULL? 
224XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
225LNRANSequence number of asset line items in fiscal yearnvarchar50NUMC(N'00000')Yes*LNRAN Allow NULL? 
226HRKFTOrigin Group as Subdivision of Cost Elementnvarchar40CHAR(N' ')Yes*HRKFT Allow NULL? 
227DMBE2Amount in Second Local Currencydecimal132CURR((0))YesDMBE2
228DMBE3Amount in Third Local Currencydecimal132CURR((0))YesDMBE3
229DMB21Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
230DMB22Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
231DMB23Amount in Second Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB2X
232DMB31Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
233DMB32Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
234DMB33Amount in Third Local Currency for Tax Breakdowndecimal132CURR((0))YesDMB3X
235MWST2Tax Amount in Second Local Currencydecimal132CURR((0))YesMWST2
236MWST3Tax Amount in Third Local Currencydecimal132CURR((0))YesMWST3
237NAVH2Non-Deductible Input Tax in Second Local Currencydecimal132CURR((0))YesNAVH2
238NAVH3Non-Deductible Input Tax in Third Local Currencydecimal132CURR((0))YesNAVH3
239SKNT2Cash Discount Amount in Second Local Currencydecimal132CURR((0))YesSKNT2
240SKNT3Cash Discount Amount in Third Local Currencydecimal132CURR((0))YesSKNT3
241BDIF3Valuation Difference for the Third Local Currencydecimal132CURR((0))YesBDIF3
242RDIF3Exchange Rate Difference Realized for Third Local Currencydecimal132CURR((0))YesRDIF3
NamePrimaryUniqueTypeColumns
/BEV3/CH1030BSG1ENNoNoNONCLUSTEREDEVENT_NR
/BEV3/CH1030BSG1~0YesYesCLUSTEREDBUZEI, EVENT_NR, EVENT, MANDT