SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

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
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: SAP Utilities :: Invoicing
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DBERDZ2091DB Table: Individ. Lines - Print DocumentInvoicing
SQL:  selectupdate insert create

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

SELECT MANDT, OPBEL, BELZEILE, BUKRS, KTOSL, HKONT, STPRZ, SBASW, SBETW, TXJCD, HVORG, SHKZG, BLDAT, BUDAT, FAEDN, BETRW, AUGBW, FAEDS, SKTOW, ASKTW, SKTPZ, VERTRAG, ABPOPBEL, SPARTE, XTOTAL_AMNT, AWTYP, AWKEY, CA_OPBEL, TAXRATE_INTERNAL, CSNO, BELZART, ABSLKZ, DIFFKZ, BUCHREL, MENGESTREL, BETRSTREL, STGRQNT, STGRAMT, PRINTREL, BRUTTOZEILE, AKLASSE, BRANCHE, TVORG, GEGEN_TVORG, LINESORT, AB, BIS, ZEITANT, TIMTYPZA, SCHEMANR, SNO, PROGRAMM, EQUNR, GERAET, MATNR, ZWNUMMER, INDEXNR, MASSBILL, MWSKZ, ERMWSKZ, NETTOBTR, TWAERS, SAISON, PREISTUF, PREISTYP, PREIS, PREISZUS, VONZONE, BISZONE, ZONENNR, PREISBTR, MNGBASIS, TIMBASIS, TIMTYP, PREIGKL, URPREIS, PREIADD, PREIFAKT, OPMULT, FRAN_TYPE, KONZIGR, ABLESGR, ABLESGRV, ATIM, ATIMVA, ADATMAX, ATIMMAX, TARIFTYP, TARIFNR, KONDIGR, STTARIF, GEWKEY, GEWANTZ, GEWANTN, LEUCHTNR, BETRART, WDHFAKT, TEMP_AREA, DRCKSTUF, THGDATUM, ZUORDDAT, SPGRUND, ABGGRND1, ABGGRND2, ABGGRND3, ABGGRND4, ABGGRND5, ABGGRND6, ABGGRND7, ABGGRND8, ABGGRND9, ABGGRND10, EIN01, EIN02, EIN03, EIN04, EIN05, EIN06, EIN07, EIN08, EIN09, EIN10, AUS01, AUS02, AUS03, AUS04, AUS05, MASS1, MASS2, MASS3, MASS4, MASS5, MASS6, DATUM1, DATUM2, TEXTNR, TEXTSP, RABZUS, BACKCANC01, BACKCANC02, BACKCANC03, BACKCANC04, BACKCANC05, BACKCANC, BACKEXEC, BACKDOCNO, BACKDOCLINE, LRATESTEP, TXDAT_KK, REGRELSORT, SC_BELNR, PEB, OPLFDNR, STAFO, ARTMENGE, STATTART, PRCTR, KOSTL, PS_PSP_PNR, AUFNR, PAOBJNR, PAOBJNR_S, GSBER, APERIODIC, ABLBELNR, LOGIKZW, ISTABLART, ISTABLARTVA, EXTPKZ, BEGPROG, ENDEPROG, REFBELZEILE, SPERRUNG, TIMECONTRL, TCNUMTOR, TCDENOMTOR, TIMTYPQUOT, NETTOFRMD, WAERSF, UMRECHDAT, UMRECHKURS, AKTIV, REFBELZONE, ABLHINW, KONZVER, REFBILLDOCNO, PERTYP, V_ZWSTAND, N_ZWSTAND, V_ZWSTNDAB, N_ZWSTNDAB, V_ZWSTVOR, N_ZWSTVOR, V_ABRMENGE, N_ABRMENGE, V_ZAHL1, N_ZAHL1, V_ZAHL2, N_ZAHL2, V_ZAHL3, N_ZAHL3, V_ZAHL4, N_ZAHL4, V_ZAHL5, N_ZAHL5, V_ZAHL6, N_ZAHL6, V_ZWSTDIFF, N_ZWSTDIFF FROM DBERDZ
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2OPBELNumber of print documentnvarchar120 Allow NULL? 
3BELZEILEBilling line item for billing documentsnvarchar60 Allow NULL? 
4BUKRSCompany Codenvarchar40 Allow NULL? 
5KTOSLTransaction Keynvarchar30 Allow NULL? 
6HKONTGeneral Ledger Accountnvarchar100 Allow NULL? 
7STPRZTax rate in output formatnvarchar80 Allow NULL? 
8SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
9SBETWTax Amount in Transaction Currency with +/- Signdecimal132
10TXJCDTax Jurisdictionnvarchar150 Allow NULL? 
11HVORGMain Transaction for Line Itemnvarchar40 Allow NULL? 
12SHKZGDebit/Credit Indicatorchar10 Allow NULL? 
13BLDATDocument Date in Documentnvarchar80 Allow NULL? 
14BUDATPosting Date in the Documentnvarchar80 Allow NULL? 
15FAEDNDue date for net paymentnvarchar80 Allow NULL? 
16BETRWAmount in Transaction Currency with +/- Signdecimal132
17AUGBWClearing Amount in Transaction Currency (With +/- Sign)decimal132
18FAEDSDue Date for Cash Discountnvarchar80 Allow NULL? 
19SKTOWCash discount amount in transaction currency with +/- signdecimal132
20ASKTWProportional cash discount in transaction currencydecimal132
21SKTPZCash discount ratedecimal53
22VERTRAGContractnvarchar100 Allow NULL? 
23ABPOPBELBudget billing plannvarchar120 Allow NULL? 
24SPARTEDivisionnvarchar20 Allow NULL? 
25XTOTAL_AMNTConsider Items in Bill Sum Totalchar10 Allow NULL? 
26AWTYPReference Transactionnvarchar50 Allow NULL? 
27AWKEYReference Keynvarchar200 Allow NULL? 
28CA_OPBELNumber of Contract Accts Rec. & Payable Doc.nvarchar120 Allow NULL? 
29TAXRATE_INTERNALTax ratenvarchar60 Allow NULL? 
30CSNOSequence number of schema step during billingnvarchar60 Allow NULL? 
31BELZARTLine Item Typenvarchar60 Allow NULL? 
32ABSLKZBilling Line Item for Budget Billing Amount Determinationchar10 Allow NULL? 
33DIFFKZIndicator: difference line item for discount statisticschar10 Allow NULL? 
34BUCHRELBilling Line Item Relevant to Postingchar10 Allow NULL? 
35MENGESTRELQuantity (billed value) is statistically relevantchar10 Allow NULL? 
36BETRSTRELAmount of billing line item is statistically relevantchar10 Allow NULL? 
37STGRQNTQuantity statistics groupnvarchar60 Allow NULL? 
38STGRAMTAmount statistics groupnvarchar60 Allow NULL? 
39PRINTRELBilling Line Is Print-Relevantchar10 Allow NULL? 
40BRUTTOZEILEBlling line item is a gross line itemchar10 Allow NULL? 
41AKLASSEBilling classnvarchar40 Allow NULL? 
42BRANCHEIndustry sectornvarchar100 Allow NULL? 
43TVORGSubtransaction for Document Itemnvarchar40 Allow NULL? 
44GEGEN_TVORGOffsetting trans. for sub-transaction of billing line itemnvarchar40 Allow NULL? 
45LINESORTPresorting of billing line items in billing schemanvarchar40 Allow NULL? 
46ABDate from which time slice is validnvarchar80 Allow NULL? 
47BISDate at Which a Time Slice Expiresnvarchar80 Allow NULL? 
48ZEITANTTime portion, billing period in days or monthsdecimal84
49TIMTYPZATime category (days or months) for billing line itemchar10 Allow NULL? 
50SCHEMANRNumber of the billing schemanvarchar100 Allow NULL? 
51SNOSequence number of schema step in billing schemanvarchar40 Allow NULL? 
52PROGRAMMVariant programnvarchar80 Allow NULL? 
53EQUNREquipment Numbernvarchar180 Allow NULL? 
54GERAETDevicenvarchar180 Allow NULL? 
55MATNRMaterial Numbernvarchar180 Allow NULL? 
56ZWNUMMERRegisternvarchar30 Allow NULL? 
57INDEXNRConsecutive number of register relationshipnvarchar120 Allow NULL? 
58MASSBILLUnit of measurement for billingnvarchar30 Allow NULL? 
59MWSKZTax on sales/purchases codenvarchar20 Allow NULL? 
60ERMWSKZIndicator: Tax Determination Codenvarchar20 Allow NULL? 
61NETTOBTRNet amount of billing line itemdecimal132
62TWAERSTransaction Currencynvarchar50 Allow NULL? 
63SAISONSeasonnvarchar100 Allow NULL? 
64PREISTUFPrice levelnvarchar100 Allow NULL? 
65PREISTYPPrice categorychar10 Allow NULL? 
66PREISPricenvarchar100 Allow NULL? 
67PREISZUSIndicator: Price Summarynvarchar40 Allow NULL? 
68VONZONEFrom-blocknvarchar100 Allow NULL? 
69BISZONETo-blocknvarchar100 Allow NULL? 
70ZONENNRNumber of price block or price scalenvarchar30 Allow NULL? 
71PREISBTRPrice amountdecimal178
72MNGBASISQuantity base for amountdecimal52
73TIMBASISTime Basisnvarchar30 Allow NULL? 
74TIMTYPTime category (days or months)char10 Allow NULL? 
75PREIGKLPrice adjustment clausenvarchar100 Allow NULL? 
76URPREISBase price to which the price adjustment clause relatesdecimal178
77PREIADDPrice to be added for price adjustmentdecimal178
78PREIFAKTPrice adjustment factordecimal127
79OPMULTAddition firstchar10 Allow NULL? 
80FRAN_TYPEFranchise Fee Categorychar10 Allow NULL? 
81KONZIGRFranchise fee groupnvarchar100 Allow NULL? 
82ABLESGRMeter reading reasonnvarchar20 Allow NULL? 
83ABLESGRVPrevious meter reading reasonnvarchar20 Allow NULL? 
84ATIMMeter reading time (relevant to billing)nvarchar40 Allow NULL? 
85ATIMVATime of day of previous meter readingnvarchar40 Allow NULL? 
86ADATMAXDate of maximum meter readingnvarchar80 Allow NULL? 
87ATIMMAXTime of maximum meter readingnvarchar40 Allow NULL? 
88TARIFTYPRate categorynvarchar100 Allow NULL? 
89TARIFNRRate keynvarchar100 Allow NULL? 
90KONDIGRRate fact groupnvarchar100 Allow NULL? 
91STTARIFStatistical ratenvarchar100 Allow NULL? 
92GEWKEYWeighting keynvarchar80 Allow NULL? 
93GEWANTZNumerator of weighting portiondecimal170
94GEWANTNDenominator of weighting portiondecimal170
95LEUCHTNRExternal lighting numbernvarchar100 Allow NULL? 
96BETRARTOperation Type for Lighting Unitnvarchar40 Allow NULL? 
97WDHFAKTRepetition factor for reference valuesint100 Allow NULL? 
98TEMP_AREATemperature areanvarchar80 Allow NULL? 
99DRCKSTUFGas pressure levelnvarchar20 Allow NULL? 
100THGDATUMGas allocation datenvarchar80 Allow NULL? 
101ZUORDDATMeter reading allocation datenvarchar80 Allow NULL? 
102SPGRUNDDisconnection reasonnvarchar20 Allow NULL? 
103ABGGRND1Reason for prorationnvarchar40 Allow NULL? 
104ABGGRND2Reason for prorationnvarchar40 Allow NULL? 
105ABGGRND3Reason for prorationnvarchar40 Allow NULL? 
106ABGGRND4Reason for prorationnvarchar40 Allow NULL? 
107ABGGRND5Reason for prorationnvarchar40 Allow NULL? 
108ABGGRND6Reason for prorationnvarchar40 Allow NULL? 
109ABGGRND7Reason for prorationnvarchar40 Allow NULL? 
110ABGGRND8Reason for prorationnvarchar40 Allow NULL? 
111ABGGRND9Reason for prorationnvarchar40 Allow NULL? 
112ABGGRND10Reason for prorationnvarchar40 Allow NULL? 
113EIN01Input operandnvarchar100 Allow NULL? 
114EIN02Input operandnvarchar100 Allow NULL? 
115EIN03Input operandnvarchar100 Allow NULL? 
116EIN04Input operandnvarchar100 Allow NULL? 
117EIN05Input operandnvarchar100 Allow NULL? 
118EIN06Input operandnvarchar100 Allow NULL? 
119EIN07Input operandnvarchar100 Allow NULL? 
120EIN08Input operandnvarchar100 Allow NULL? 
121EIN09Input operandnvarchar100 Allow NULL? 
122EIN10Input operandnvarchar100 Allow NULL? 
123AUS01Output operandnvarchar100 Allow NULL? 
124AUS02Output operandnvarchar100 Allow NULL? 
125AUS03Output operandnvarchar100 Allow NULL? 
126AUS04Output operandnvarchar100 Allow NULL? 
127AUS05Output operandnvarchar100 Allow NULL? 
128MASS1Unit of Measurementnvarchar30 Allow NULL? 
129MASS2Unit of Measurementnvarchar30 Allow NULL? 
130MASS3Unit of Measurementnvarchar30 Allow NULL? 
131MASS4Unit of Measurementnvarchar30 Allow NULL? 
132MASS5Unit of Measurementnvarchar30 Allow NULL? 
133MASS6Unit of Measurementnvarchar30 Allow NULL? 
134DATUM1Datenvarchar80 Allow NULL? 
135DATUM2Datenvarchar80 Allow NULL? 
136TEXTNRText Numbernvarchar80 Allow NULL? 
137TEXTSPLanguage key in text processingchar10 Allow NULL? 
138RABZUSDiscount keynvarchar100 Allow NULL? 
139BACKCANC01Indicator: reverse backbillingnvarchar40 Allow NULL? 
140BACKCANC02Indicator: reverse backbillingnvarchar40 Allow NULL? 
141BACKCANC03Indicator: reverse backbillingnvarchar40 Allow NULL? 
142BACKCANC04Indicator: reverse backbillingnvarchar40 Allow NULL? 
143BACKCANC05Indicator: reverse backbillingnvarchar40 Allow NULL? 
144BACKCANCIndicator: Reverse Backbillingnvarchar40 Allow NULL? 
145BACKEXECIndicator: allocate backbillingnvarchar40 Allow NULL? 
146BACKDOCNONumber of a billing documentnvarchar120 Allow NULL? 
147BACKDOCLINEBilling line item for billing documentsnvarchar60 Allow NULL? 
148LRATESTEPLogical Number of Rate Stepnvarchar100 Allow NULL? 
149TXDAT_KKDecisive Date for Calculating Taxesnvarchar80 Allow NULL? 
150REGRELSORTSort help for register relationships during bill printoutnvarchar20 Allow NULL? 
151SC_BELNRNumber of billing document in adjustment reversalnvarchar120 Allow NULL? 
152PEBIndicator: billing line item relates to period-end billingchar10 Allow NULL? 
153OPLFDNRConsecutive number of an operandnvarchar40 Allow NULL? 
154STAFOUpdate group for statistics updatenvarchar60 Allow NULL? 
155ARTMENGEClassification of billed quantity for statisticschar10 Allow NULL? 
156STATTARTRate type for statistical analysisnvarchar80 Allow NULL? 
157PRCTRProfit Centernvarchar100 Allow NULL? 
158KOSTLCost Centernvarchar100 Allow NULL? 
159PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80 Allow NULL? 
160AUFNROrder Numbernvarchar120 Allow NULL? 
161PAOBJNRProfitability Segment Number (CO-PA)nvarchar100 Allow NULL? 
162PAOBJNR_SProfitability Segment No. for CO-PA Post. Acc. to Cons. Mthnvarchar100 Allow NULL? 
163GSBERBusiness Areanvarchar40 Allow NULL? 
164APERIODICNon-Periodic Postingchar10 Allow NULL? 
165ABLBELNRInternal ID for meter reading documentnvarchar200 Allow NULL? 
166LOGIKZWLogical register numbernvarchar180 Allow NULL? 
167ISTABLARTMeter reading typenvarchar20 Allow NULL? 
168ISTABLARTVAMeter reading type of previous meter readingnvarchar20 Allow NULL? 
169EXTPKZSimulation indicator for meter reading resultschar10 Allow NULL? 
170BEGPROGStart of forecast periodnvarchar80 Allow NULL? 
171ENDEPROGEnd of forecast periodnvarchar80 Allow NULL? 
172REFBELZEILEReference billing line item for billing documentsnvarchar60 Allow NULL? 
173SPERRUNGTime slice is in a disconnection periodchar10 Allow NULL? 
174TIMECONTRLPeriod controlnvarchar20 Allow NULL? 
175TCNUMTORNumerator of the time portion in a time slicedecimal84
176TCDENOMTORDenominator of the time portion in a time slicedecimal84
177TIMTYPQUOTTime category of meter for time portion of a time slicechar10 Allow NULL? 
178NETTOFRMDAmount in foreign currency with +/- signdecimal132
179WAERSFCurrency key for amountnvarchar50 Allow NULL? 
180UMRECHDATConversion Date for Foreign Currency Amountnvarchar80 Allow NULL? 
181UMRECHKURSExchange rate btwn net amount and foreign currency amountdecimal95
182AKTIVMeter reading activechar10 Allow NULL? 
183REFBELZONERef. billing line item for documents resulting from blockingnvarchar60 Allow NULL? 
184ABLHINWNote from meter readernvarchar40 Allow NULL? 
185KONZVERFranchise contractnvarchar100 Allow NULL? 
186REFBILLDOCNOReference Document Numbernvarchar120 Allow NULL? 
187PERTYPCategory of the internal billing periodnvarchar20 Allow NULL? 
188V_ZWSTANDPlaces Before Decimal Point in Meter Readingdecimal170
189N_ZWSTANDPlaces After Decimal Point in the Meter Readingdecimal1414
190V_ZWSTNDABPredecimal Places in Billed Meter Readingdecimal170
191N_ZWSTNDABDecimal Places in the Billed Meter Readingdecimal1414
192V_ZWSTVORPredecimal places in previous meter reading resultdecimal170
193N_ZWSTVORDecimal places in previous meter readingdecimal1414
194V_ABRMENGEPlaces before decimal point in billing quantitydecimal170
195N_ABRMENGEPlaces after decimal point in billing quantitydecimal1414
196V_ZAHL1Pre-decimal places in a numberdecimal170
197N_ZAHL1Decimal places in a numberdecimal1414
198V_ZAHL2Pre-decimal places in a numberdecimal170
199N_ZAHL2Decimal places in a numberdecimal1414
200V_ZAHL3Pre-decimal places in a numberdecimal170
201N_ZAHL3Decimal places in a numberdecimal1414
202V_ZAHL4Pre-decimal places in a numberdecimal170
203N_ZAHL4Decimal places in a numberdecimal1414
204V_ZAHL5Pre-decimal places in a numberdecimal170
205N_ZAHL5Decimal places in a numberdecimal1414
206V_ZAHL6Pre-decimal places in a numberdecimal170
207N_ZAHL6Decimal places in a numberdecimal1414
208V_ZWSTDIFFPre-decimal places for the meter reading differencedecimal170
209N_ZWSTDIFFDecimal places for the meter reading differencedecimal1414
NamePrimaryUniqueTypeColumns
DBERDZ~0YesYesCLUSTEREDBELZEILE, OPBEL, MANDT