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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

179 columns | Print definition?ERP 6.0  | YVWDNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPRemaining Beverage - Obsolete Objects
1/BEV3/CHABRKZL_TCH Settlement Key Figure Statistics2YVWDNRCHD Contract Numbernvarchar130
2/BEV3/CHABRSTZ_KSettlement Record - Header5YVWDNRCHD Contract Numbernvarchar130
3/BEV3/CHABRSTZ_PCH Settlement Items - With Translations6YVWDNRCHD Contract Numbernvarchar130
4/BEV3/CHACCOUNT1Date Data for Settlement Using Event Administration Process3YVWDNRCHD Contract Numbernvarchar130
5/BEV3/CHAGTREEContract Tree2YVWDNRCHD Contract Numbernvarchar130
6/BEV3/CHAGTREETContract Tree - Free Text2YVWDNRCHD Contract Numbernvarchar130
7/BEV3/CHBABNHMAgreement Purchase2YVWDNRCHD Contract Numbernvarchar130
8/BEV3/CHBABSATZAgreement Sales2YVWDNRCHD Contract Numbernvarchar130
9/BEV3/CHBABSSAgreement Sales Scale Refund2YVWDNRCHD Contract Numbernvarchar130
10/BEV3/CHBABSTVGAgreement Sales Scale Refunding2YVWDNRCHD Contract Numbernvarchar130
11/BEV3/CHBABSVGAgreement Sales Refunding2YVWDNRCHD Contract Numbernvarchar130
12/BEV3/CHBALLGAgreements Administration table (Generalized Data)2YVWDNRCHD Contract Numbernvarchar130
13/BEV3/CHBALLVAgreements Administration Table: Visibility Index2YVWDNRCHD Contract Numbernvarchar130
14/BEV3/CHBANNUAgreement Annuity2YVWDNRCHD Contract Numbernvarchar130
15/BEV3/CHBBDGSTFAgreement Condition Strategy - Formula2YVWDNRCHD Contract Numbernvarchar130
16/BEV3/CHBBDGSTTAgreement Condition Strategy - Text2YVWDNRCHD Contract Numbernvarchar130
17/BEV3/CHBBKBDGAgreement Purchase Control - Part Condition2YVWDNRCHD Contract Numbernvarchar130
18/BEV3/CHBBKBFIAgreement Purchase Control - Part Valuation FI2YVWDNRCHD Contract Numbernvarchar130
19/BEV3/CHBBKBSDAgreement Purchase Control - Part Valuation SD2YVWDNRCHD Contract Numbernvarchar130
20/BEV3/CHBBKBVVAgreement Purchase Control - Part Valuation CH2YVWDNRCHD Contract Numbernvarchar130
21/BEV3/CHBBKFLGAgreement Purchase Control - Part Sequence2YVWDNRCHD Contract Numbernvarchar130
22/BEV3/CHBBKKNTRAgreement Purchase Control - Part Request2YVWDNRCHD Contract Numbernvarchar130
23/BEV3/CHBBKSTAgreement Purchase Control - Part Status2YVWDNRCHD Contract Numbernvarchar130
24/BEV3/CHBBKTMAgreement Purchase Control - Part Date2YVWDNRCHD Contract Numbernvarchar130
25/BEV3/CHBBKVRKTAgreement Purchase Control - Part Concatenation2YVWDNRCHD Contract Numbernvarchar130
26/BEV3/CHBCALCCAgreement Calculation - Formula Constant2YVWDNRCHD Contract Numbernvarchar130
27/BEV3/CHBCALCFAgreement Calculation - Formula2YVWDNRCHD Contract Numbernvarchar130
28/BEV3/CHBCALCTAgreement Calculation2YVWDNRCHD Contract Numbernvarchar130
29/BEV3/CHBCALCTTAgreement Calculation - Text2YVWDNRCHD Contract Numbernvarchar130
30/BEV3/CHBCALCVAgreement Calculation - Formula Variable2YVWDNRCHD Contract Numbernvarchar130
31/BEV3/CHBDATUMAgreement Date2YVWDNRCHD Contract Numbernvarchar130
32/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items5YVWDNRCHD Contract Numbernvarchar130
33/BEV3/CHBEINBINIntegration Agreement2YVWDNRCHD Contract Numbernvarchar130
34/BEV3/CHBEXTBAgreement External Amount2YVWDNRCHD Contract Numbernvarchar130
35/BEV3/CHBEZINSExternal Interest Agreement2YVWDNRCHD Contract Numbernvarchar130
36/BEV3/CHBFBTRGAgreement Fixed Amount2YVWDNRCHD Contract Numbernvarchar130
37/BEV3/CHBFPROZAgreement Fixed Percentage2YVWDNRCHD Contract Numbernvarchar130
38/BEV3/CHBGABSTotal Sales Agreement2YVWDNRCHD Contract Numbernvarchar130
39/BEV3/CHBGROUPAgreement Group2YVWDNRCHD Contract Numbernvarchar130
40/BEV3/CHBGUMSTotal Sales Agreement2YVWDNRCHD Contract Numbernvarchar130
41/BEV3/CHBINSTAgreements Administration Table Entity Attributes2YVWDNRCHD Contract Numbernvarchar130
42/BEV3/CHBINSTTAgreements Administration Table Entity Attributes2YVWDNRCHD Contract Numbernvarchar130
43/BEV3/CHBIZINSAgreement Internal Interest2YVWDNRCHD Contract Numbernvarchar130
44/BEV3/CHBKABRNRCH Purchase Control / Settlements2YVWDNRCHD Contract Numbernvarchar130
45/BEV3/CHBKBELEGPurchase Control Transaction / CH Documents2YVWDNRCHD Contract Numbernvarchar130
46/BEV3/CHBKERGBLGPurchase Control Transaction / CH Documents2YVWDNRCHD Contract Numbernvarchar130
47/BEV3/CHBKERGRSLPurchase control results4YVWDNRCHD Contract Numbernvarchar130
48/BEV3/CHBKHISTORCH Settlement Stats Header Data - Purchase Control History2YVWDNRCHD Contract Numbernvarchar130
49/BEV3/CHBKOMTRAgreement Communication2YVWDNRCHD Contract Numbernvarchar130
50/BEV3/CHBKONTAgreement Account2YVWDNRCHD Contract Numbernvarchar130
51/BEV3/CHBKPKPZLAgreement Complement Capital Payment (BTE)2YVWDNRCHD Contract Numbernvarchar130
52/BEV3/CHBKRESHISPurchase Control Results - History4YVWDNRCHD Contract Numbernvarchar130
53/BEV3/CHBKRESULTPurchase control results4YVWDNRCHD Contract Numbernvarchar130
54/BEV3/CHBKSTATUSCH Settlement Statistics Header Data for Purchase Control2YVWDNRCHD Contract Numbernvarchar130
55/BEV3/CHBKSTK_CCH Settlement Stats for Exception Trigger in Purchase Ctrl2YVWDNRCHD Contract Numbernvarchar130
56/BEV3/CHBKSTK_TCH Settlement Statistics Final Settlement Information2YVWDNRCHD Contract Numbernvarchar130
57/BEV3/CHBKTMPTemp. Purchase Control Results4YVWDNRCHD Contract Numbernvarchar130
58/BEV3/CHBKTMP_CTemp.CH Settlement Stats for Except.Trigger in Purchase Ctrl2YVWDNRCHD Contract Numbernvarchar130
59/BEV3/CHBKTMP_TTemp. CH Settlement Stats Final Settlement Information2YVWDNRCHD Contract Numbernvarchar130
60/BEV3/CHBLEISTAgreement Performance2YVWDNRCHD Contract Numbernvarchar130
61/BEV3/CHBMINUMAgreement Sales Target2YVWDNRCHD Contract Numbernvarchar130
62/BEV3/CHBPARTAgreement Partner SD2YVWDNRCHD Contract Numbernvarchar130
63/BEV3/CHBPOSTAgreement Text2YVWDNRCHD Contract Numbernvarchar130
64/BEV3/CHBPRZABWAgreement Out-of-Line Percentage2YVWDNRCHD Contract Numbernvarchar130
65/BEV3/CHBPRZGRZAgreement Percentage Limits2YVWDNRCHD Contract Numbernvarchar130
66/BEV3/CHBREGINFPayer Information Agreement2YVWDNRCHD Contract Numbernvarchar130
67/BEV3/CHBRUECKAgreement Breakdown Arrears2YVWDNRCHD Contract Numbernvarchar130
68/BEV3/CHBSALEIPayment in Kind Agreement2YVWDNRCHD Contract Numbernvarchar130
69/BEV3/CHBSECUREAgreement Collateral2YVWDNRCHD Contract Numbernvarchar130
70/BEV3/CHBSICHAgreement Collateral2YVWDNRCHD Contract Numbernvarchar130
71/BEV3/CHBSORTAgreement Contract Assortment List2YVWDNRCHD Contract Numbernvarchar130
72/BEV3/CHBTERMINAgreement Date2YVWDNRCHD Contract Numbernvarchar130
73/BEV3/CHBTMANFOAgreement Date Request2YVWDNRCHD Contract Numbernvarchar130
74/BEV3/CHBTMANWEAgreement Date Statement2YVWDNRCHD Contract Numbernvarchar130
75/BEV3/CHBTMBDGAgreement Date Condition2YVWDNRCHD Contract Numbernvarchar130
76/BEV3/CHBTMBEWFIAgreement Date Valuation FI2YVWDNRCHD Contract Numbernvarchar130
77/BEV3/CHBTMBEWSDAgreement Date Valuation SD2YVWDNRCHD Contract Numbernvarchar130
78/BEV3/CHBTMBEWVVAgreement Date Valuation CH2YVWDNRCHD Contract Numbernvarchar130
79/BEV3/CHBTMFOLGEAgreement Date Sequence2YVWDNRCHD Contract Numbernvarchar130
80/BEV3/CHBTMSTATUAgreement Date Status2YVWDNRCHD Contract Numbernvarchar130
81/BEV3/CHBTMVKTGAgreement Date Concatenation2YVWDNRCHD Contract Numbernvarchar130
82/BEV3/CHBUMSATZAgreement Sales (Actual)2YVWDNRCHD Contract Numbernvarchar130
83/BEV3/CHBUMSPAgreement Sales Scale, Percent2YVWDNRCHD Contract Numbernvarchar130
84/BEV3/CHBVERREAgreement Clearing2YVWDNRCHD Contract Numbernvarchar130
85/BEV3/CHBVORGAgreement Transaction2YVWDNRCHD Contract Numbernvarchar130
86/BEV3/CHBVWDNRAgreement deviating CHD number2YVWDNRCHD Contract Numbernvarchar130
87/BEV3/CHBWAERAgreement Currency2YVWDNRCHD Contract Numbernvarchar130
88/BEV3/CHBXREFAgreements Where-Used-List2YVWDNRCHD Contract Numbernvarchar130
89/BEV3/CHBZUSCHAgreement Allowance2YVWDNRCHD Contract Numbernvarchar130
90/BEV3/CHCDPALLOCCDP: R/3 Environment Data2YVWDNRCHD Contract Numbernvarchar130
91/BEV3/CHCDPBEWSDCDP: Contract Dates (SD Valuation)2YVWDNRCHD Contract Numbernvarchar130
92/BEV3/CHCDPBKCDP: Purchase Control Results2YVWDNRCHD Contract Numbernvarchar130
93/BEV3/CHCDPCTR1CDP: Contract Data 1 - General Contract Data2YVWDNRCHD Contract Numbernvarchar130
94/BEV3/CHCDPCTR2CDP: Contract Data 2 - Specific Contract Data2YVWDNRCHD Contract Numbernvarchar130
95/BEV3/CHCDPCUSTCDP: Contract Data Customer2YVWDNRCHD Contract Numbernvarchar130
96/BEV3/CHCDPLINKCDP: Contract References2YVWDNRCHD Contract Numbernvarchar130
97/BEV3/CHCDPOBLIGCDP: Contractual Services2YVWDNRCHD Contract Numbernvarchar130
98/BEV3/CHCDPSALDOCDP: Contract Balances / Totals2YVWDNRCHD Contract Numbernvarchar130
99/BEV3/CHCDPSALESCDP: Contract Sales (Detailed)2YVWDNRCHD Contract Numbernvarchar130
100/BEV3/CHCDPSELVCDP: Upload Selection - Contracts3YVWDNRCHD Contract Numbernvarchar130
101/BEV3/CHCDPSORTMCDP: Contract Assortments2YVWDNRCHD Contract Numbernvarchar130
102/BEV3/CHCDPSTATECDP: Status of Contract Handling2YVWDNRCHD Contract Numbernvarchar130
103/BEV3/CHCDPTERMICDP: Contract Dates (Dates and PC)2YVWDNRCHD Contract Numbernvarchar130
104/BEV3/CHCDPTEXTCDP: Contract Texts2YVWDNRCHD Contract Numbernvarchar130
105/BEV3/CHCIVBSKSales Document Collective Run Header CH Billing Documents27YVWDNRCHD Contract Numbernvarchar130
106/BEV3/CHCWSValue Date: CH Document Value Date2YVWDNRCHD Contract Numbernvarchar130
107/BEV3/CHDVWD0001Basic Data for CHD2YVWDNRCHD Contract Numbernvarchar130
108/BEV3/CHERGSTZ_KSettlement Record - Header5YVWDNRCHD Contract Numbernvarchar130
109/BEV3/CHERGSTZ_PCH Settlement Items - With Translations6YVWDNRCHD Contract Numbernvarchar130
110/BEV3/CHERGSTZ_SCH Settlement Statistics7YVWDNRCHD Contract Numbernvarchar130
111/BEV3/CHEVLIACBPCH BTE Event Listener ACCOUNT Before Processed2YVWDNRCHD Contract Numbernvarchar130
112/BEV3/CHEVLIACELCH BTE Event Listener ACCOUNT2YVWDNRCHD Contract Numbernvarchar130
113/BEV3/CHEVLIACFLCH BTE Event Listener ACCOUNT Fault5YVWDNRCHD Contract Numbernvarchar130
114/BEV3/CHEVLIACNTCH BTE Event Listener ACCOUNT Date2YVWDNRCHD Contract Numbernvarchar130
115/BEV3/CHEVTMNOTEDate Part Info. Regarding Link to Deviating CHD Number2YVWDNRCHD Contract Numbernvarchar130
116/BEV3/CHEVVWDNRNInformation from the Deviating AG CHD No. to the BTE5YVWDNRCHD Contract Numbernvarchar130
117/BEV3/CHEXCSTZ_KCH Settlement Header/Non-Posted Docs w/o Date Statistics5YVWDNRCHD Contract Numbernvarchar130
118/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics6YVWDNRCHD Contract Numbernvarchar130
119/BEV3/CHKAALLOCACustomer Evaluation Table: Contract Allocations2YVWDNRCHD Contract Numbernvarchar130
120/BEV3/CHKABEWSDCustomer Evaluation Table: Dates Valuation SD2YVWDNRCHD Contract Numbernvarchar130
121/BEV3/CHKACNTRCTCustomer Evaluation Table: Contract2YVWDNRCHD Contract Numbernvarchar130
122/BEV3/CHKACUSTOCustomer Evaluation Table: Customer Table2YVWDNRCHD Contract Numbernvarchar130
123/BEV3/CHKAOBLIGACustomer Evaluation Table: Contract Performances2YVWDNRCHD Contract Numbernvarchar130
124/BEV3/CHKASRTMNTCustomer Evaluation Table: Assortments2YVWDNRCHD Contract Numbernvarchar130
125/BEV3/CHKATERMINCustomer Evaluation Table: Dates General2YVWDNRCHD Contract Numbernvarchar130
126/BEV3/CHKATMABUMCustomer Evaluation Table: Sales per Date2YVWDNRCHD Contract Numbernvarchar130
127/BEV3/CHKAW_TEXTCustomer Evaluation Table: Text2YVWDNRCHD Contract Numbernvarchar130
128/BEV3/CHKA_SALDOCustomer Evaluation Table: Balances from FI Ledger2YVWDNRCHD Contract Numbernvarchar130
129/BEV3/CHLERFExternal Amount: Performances Entered2YVWDNRCHD Contract Numbernvarchar130
130/BEV3/CHNODESStructure of Contract Tree2YVWDNRCHD Contract Numbernvarchar130
131/BEV3/CHNODESTTexts for Node Structure2YVWDNRCHD Contract Numbernvarchar130
132/BEV3/CHRESADMINReset Date - Transfer Paranmeters for Admin. Process2YVWDNRCHD Contract Numbernvarchar130
133/BEV3/CHRESSTZ_KSettlement Record - Header - Reset Documents (2/Transaction)5YVWDNRCHD Contract Numbernvarchar130
134/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)6YVWDNRCHD Contract Numbernvarchar130
135/BEV3/CHRSBKADMNReset PC - Transfer Parameters for Admin. Process2YVWDNRCHD Contract Numbernvarchar130
136/BEV3/CHSHTSTZSDSpecial Interface Data for SD - Not CH-Relevant6YVWDNRCHD Contract Numbernvarchar130
137/BEV3/CHSHTSTZ_KInterface Record - Header (SD)5YVWDNRCHD Contract Numbernvarchar130
138/BEV3/CHSHTSTZ_PCH Settlement Item6YVWDNRCHD Contract Numbernvarchar130
139/BEV3/CHSIMADMINReset Simulation: Data for Admin. Process4YVWDNRCHD Contract Numbernvarchar130
140/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions5YVWDNRCHD Contract Numbernvarchar130
141/BEV3/CHSIMSTKFHCH Settlement Statistics Header Data - History2YVWDNRCHD Contract Numbernvarchar130
142/BEV3/CHSIMSTK_CCH - Simulation Statistics of Exception Trigger2YVWDNRCHD Contract Numbernvarchar130
143/BEV3/CHSIMSTK_FCH - Silulation Statistics Header Data2YVWDNRCHD Contract Numbernvarchar130
144/BEV3/CHSIMSTK_TCH Simulation Statistics Final Settlement Information2YVWDNRCHD Contract Numbernvarchar130
145/BEV3/CHSIMSTK_VCH - Simulation statistics of premature DA conditions2YVWDNRCHD Contract Numbernvarchar130
146/BEV3/CHSIMSTZ_KSimulation Record - Header5YVWDNRCHD Contract Numbernvarchar130
147/BEV3/CHSIMSTZ_PCH Simulation Items6YVWDNRCHD Contract Numbernvarchar130
148/BEV3/CHSIMSTZ_SCH Simulation Statistics7YVWDNRCHD Contract Numbernvarchar130
149/BEV3/CHTBTEXTAgreement Text2YVWDNRCHD Contract Numbernvarchar130
150/BEV3/CHTM1030Date Transaction / BTE 10302YVWDNRCHD Contract Numbernvarchar130
151/BEV3/CHTMABRNRCH Dates / Settlements2YVWDNRCHD Contract Numbernvarchar130
152/BEV3/CHTMBELEGDate Transaction / CH Documents2YVWDNRCHD Contract Numbernvarchar130
153/BEV3/CHTMBKRESDate Transaction / CH Documents2YVWDNRCHD Contract Numbernvarchar130
154/BEV3/CHTMERGBLGDate Transaction / CH Documents2YVWDNRCHD Contract Numbernvarchar130
155/BEV3/CHTMHISTORCH Settlement Statistics Header Data - History2YVWDNRCHD Contract Numbernvarchar130
156/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item5YVWDNRCHD Contract Numbernvarchar130
157/BEV3/CHTMPSTK_CCH - Temporary Statistics of Exception Trigger2YVWDNRCHD Contract Numbernvarchar130
158/BEV3/CHTMPSTK_FCH - Temporary Statistics Header Data2YVWDNRCHD Contract Numbernvarchar130
159/BEV3/CHTMPSTK_TCH - Temporary Statistics Final Settlement Information2YVWDNRCHD Contract Numbernvarchar130
160/BEV3/CHTMPSTK_VCH - temporary statistics of premature DA termination2YVWDNRCHD Contract Numbernvarchar130
161/BEV3/CHTMSTATUSCH Settlement Statistics Header Data2YVWDNRCHD Contract Numbernvarchar130
162/BEV3/CHTRMSTK_CCH Settlement Statistics of Exception Trigger2YVWDNRCHD Contract Numbernvarchar130
163/BEV3/CHTRMSTK_TCH Settlement Statistics Final Settlement Information2YVWDNRCHD Contract Numbernvarchar130
164/BEV3/CHTRMSTK_VCH-settlement statistics of premature DA conditions2YVWDNRCHD Contract Numbernvarchar130
165/BEV3/CHTRMSTZ_KDate Record - Header5YVWDNRCHD Contract Numbernvarchar130
166/BEV3/CHTRMSTZ_PCH Date Item6YVWDNRCHD Contract Numbernvarchar130
167/BEV3/CHTRMSTZ_SCH Date Statistics7YVWDNRCHD Contract Numbernvarchar130
168/BEV3/CHVABRSTZSCH Settlement Statistics7YVWDNRCHD Contract Numbernvarchar130
169/BEV3/CHVWDKLCHD No. Class Assignment2YVWDNRCHD Contract Numbernvarchar130
170/BEV3/CHWDContract Handling Document2YVWDNRCHD Contract Numbernvarchar130
171/BEV3/CHWDAUFSTCHD-Increase in Loan2YVWDNRCHD Contract Numbernvarchar130
172/BEV3/CHWDKLSSClassifications of CHD2YVWDNRCHD Contract Numbernvarchar130
173/BEV3/CHWDKORRCorrepondence Data for CHD2YVWDNRCHD Contract Numbernvarchar130
174/BEV3/CHWDLFZEITCHD Validity Periods2YVWDNRCHD Contract Numbernvarchar130
175/BEV3/CHWDOBJObjects with Reference to CHD2YVWDNRCHD Contract Numbernvarchar130
176/BEV3/CHWDPRTNRCHD Partner2YVWDNRCHD Contract Numbernvarchar130
177/BEV3/CHWDSIGNVGContract for signing party2YVWDNRCHD Contract Numbernvarchar130
178/BEV3/CHWDSIGNVNContract for signing party2YVWDNRCHD Contract Numbernvarchar130
179/BEV3/CHWDVTRRBZContract Number References2YVWDNRCHD Contract Numbernvarchar130