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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

150 columns | Print definition?ERP 6.0  | VBKL

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPRemaining Beverage - Obsolete Objects
1/BEV3/CHABRKZL_TCH Settlement Key Figure Statistics6VBKLAgreement Class - Contract Callednvarchar40
2/BEV3/CHABRSTZ_PCH Settlement Items - With Translations12VBKLAgreement Class - Contract Callednvarchar40
3/BEV3/CHAGTREEContract Tree7VBKLAgreement Classnvarchar40
4/BEV3/CHBABNHMAgreement Purchase3VBKLAgreement Classnvarchar40
5/BEV3/CHBABSATZAgreement Sales3VBKLAgreement Classnvarchar40
6/BEV3/CHBABSSAgreement Sales Scale Refund3VBKLAgreement Classnvarchar40
7/BEV3/CHBABSTVGAgreement Sales Scale Refunding3VBKLAgreement Classnvarchar40
8/BEV3/CHBABSVGAgreement Sales Refunding3VBKLAgreement Classnvarchar40
9/BEV3/CHBALLGAgreements Administration table (Generalized Data)3VBKLAgreement Classnvarchar40
10/BEV3/CHBALLVAgreements Administration Table: Visibility Index3VBKLAgreement Classnvarchar40
11/BEV3/CHBANNUAgreement Annuity3VBKLAgreement Classnvarchar40
12/BEV3/CHBBDGSTFAgreement Condition Strategy - Formula3VBKLAgreement Classnvarchar40
13/BEV3/CHBBDGSTTAgreement Condition Strategy - Text3VBKLAgreement Classnvarchar40
14/BEV3/CHBBKBDGAgreement Purchase Control - Part Condition3VBKLAgreement Classnvarchar40
15/BEV3/CHBBKBFIAgreement Purchase Control - Part Valuation FI3VBKLAgreement Classnvarchar40
16/BEV3/CHBBKBSDAgreement Purchase Control - Part Valuation SD3VBKLAgreement Classnvarchar40
17/BEV3/CHBBKBVVAgreement Purchase Control - Part Valuation CH3VBKLAgreement Classnvarchar40
18/BEV3/CHBBKFLGAgreement Purchase Control - Part Sequence3VBKLAgreement Classnvarchar40
19/BEV3/CHBBKKNTRAgreement Purchase Control - Part Request3VBKLAgreement Classnvarchar40
20/BEV3/CHBBKSTAgreement Purchase Control - Part Status3VBKLAgreement Classnvarchar40
21/BEV3/CHBBKTMAgreement Purchase Control - Part Date3VBKLAgreement Classnvarchar40
22/BEV3/CHBBKVRKTAgreement Purchase Control - Part Concatenation3VBKLAgreement Classnvarchar40
23/BEV3/CHBCALCCAgreement Calculation - Formula Constant3VBKLAgreement Classnvarchar40
24/BEV3/CHBCALCFAgreement Calculation - Formula3VBKLAgreement Classnvarchar40
25/BEV3/CHBCALCTAgreement Calculation3VBKLAgreement Classnvarchar40
26/BEV3/CHBCALCTTAgreement Calculation - Text3VBKLAgreement Classnvarchar40
27/BEV3/CHBCALCVAgreement Calculation - Formula Variable3VBKLAgreement Classnvarchar40
28/BEV3/CHBDATUMAgreement Date3VBKLAgreement Classnvarchar40
29/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items13VBKLAgreement Class - Contract Callednvarchar40
30/BEV3/CHBEINBINIntegration Agreement3VBKLAgreement Classnvarchar40
31/BEV3/CHBEXTBAgreement External Amount3VBKLAgreement Classnvarchar40
32/BEV3/CHBEZINSExternal Interest Agreement3VBKLAgreement Classnvarchar40
33/BEV3/CHBFBTRGAgreement Fixed Amount3VBKLAgreement Classnvarchar40
34/BEV3/CHBFPROZAgreement Fixed Percentage3VBKLAgreement Classnvarchar40
35/BEV3/CHBGABSTotal Sales Agreement3VBKLAgreement Classnvarchar40
36/BEV3/CHBGROUPAgreement Group3VBKLAgreement Classnvarchar40
37/BEV3/CHBGUMSTotal Sales Agreement3VBKLAgreement Classnvarchar40
38/BEV3/CHBINSTAgreements Administration Table Entity Attributes3VBKLAgreement Classnvarchar40
39/BEV3/CHBINSTTAgreements Administration Table Entity Attributes3VBKLAgreement Classnvarchar40
40/BEV3/CHBIZINSAgreement Internal Interest3VBKLAgreement Classnvarchar40
41/BEV3/CHBKERGRSLPurchase control results5VBKLAgreement Classnvarchar40
42/BEV3/CHBKOMTRAgreement Communication4VBKLAgreement Classnvarchar40
43/BEV3/CHBKONTAgreement Account3VBKLAgreement Classnvarchar40
44/BEV3/CHBKPKPZLAgreement Complement Capital Payment (BTE)3VBKLAgreement Classnvarchar40
45/BEV3/CHBKRESHISPurchase Control Results - History5VBKLAgreement Classnvarchar40
46/BEV3/CHBKRESULTPurchase control results5VBKLAgreement Class of the Purchase Controlnvarchar40
47/BEV3/CHBKTMPTemp. Purchase Control Results5VBKLAgreement Classnvarchar40
48/BEV3/CHBLEISTAgreement Performance3VBKLAgreement Classnvarchar40
49/BEV3/CHBMINUMAgreement Sales Target3VBKLAgreement Classnvarchar40
50/BEV3/CHBPARTAgreement Partner SD3VBKLAgreement Classnvarchar40
51/BEV3/CHBPOSTAgreement Text3VBKLAgreement Classnvarchar40
52/BEV3/CHBPRZABWAgreement Out-of-Line Percentage3VBKLAgreement Classnvarchar40
53/BEV3/CHBPRZGRZAgreement Percentage Limits3VBKLAgreement Classnvarchar40
54/BEV3/CHBREGINFPayer Information Agreement3VBKLAgreement Classnvarchar40
55/BEV3/CHBRUECKAgreement Breakdown Arrears3VBKLAgreement Classnvarchar40
56/BEV3/CHBSALEIPayment in Kind Agreement3VBKLAgreement Classnvarchar40
57/BEV3/CHBSECUREAgreement Collateral3VBKLAgreement Classnvarchar40
58/BEV3/CHBSICHAgreement Collateral3VBKLAgreement Classnvarchar40
59/BEV3/CHBSORTAgreement Contract Assortment List3VBKLAgreement Classnvarchar40
60/BEV3/CHBTERMINAgreement Date3VBKLAgreement Classnvarchar40
61/BEV3/CHBTMANFOAgreement Date Request3VBKLAgreement Classnvarchar40
62/BEV3/CHBTMANWEAgreement Date Statement3VBKLAgreement Classnvarchar40
63/BEV3/CHBTMBDGAgreement Date Condition3VBKLAgreement Classnvarchar40
64/BEV3/CHBTMBEWFIAgreement Date Valuation FI3VBKLAgreement Classnvarchar40
65/BEV3/CHBTMBEWSDAgreement Date Valuation SD3VBKLAgreement Classnvarchar40
66/BEV3/CHBTMBEWVVAgreement Date Valuation CH3VBKLAgreement Classnvarchar40
67/BEV3/CHBTMFOLGEAgreement Date Sequence3VBKLAgreement Classnvarchar40
68/BEV3/CHBTMSTATUAgreement Date Status3VBKLAgreement Classnvarchar40
69/BEV3/CHBTMVKTGAgreement Date Concatenation3VBKLAgreement Classnvarchar40
70/BEV3/CHBUMSATZAgreement Sales (Actual)3VBKLAgreement Classnvarchar40
71/BEV3/CHBUMSPAgreement Sales Scale, Percent3VBKLAgreement Classnvarchar40
72/BEV3/CHBVERREAgreement Clearing3VBKLAgreement Classnvarchar40
73/BEV3/CHBVORGAgreement Transaction3VBKLAgreement Classnvarchar40
74/BEV3/CHBVWDNRAgreement deviating CHD number3VBKLAgreement Classnvarchar40
75/BEV3/CHBWAERAgreement Currency3VBKLAgreement Classnvarchar40
76/BEV3/CHBXREFAgreements Where-Used-List5VBKLAgreement Classnvarchar40
77/BEV3/CHBZUSCHAgreement Allowance3VBKLAgreement Classnvarchar40
78/BEV3/CHCAABTXTException Handling: Programs for Exception Handling - Text3VBKLAgreement Classnvarchar40
79/BEV3/CHCAGCLSFAssignment: Agreement to classification3VBKLAgreement Classnvarchar40
80/BEV3/CHCA_ABException Handling: Programs for Exception Handling3VBKLAgreement Classnvarchar40
81/BEV3/CHCA_PROException Handling: log13VBKLAgreement Classnvarchar40
82/BEV3/CHCA_REException Handling: Response3VBKLAgreement Classnvarchar40
83/BEV3/CHCA_RELException Handling: Relevance Table for Exception Analysis9VBKLAgreement Classnvarchar40
84/BEV3/CHCA_VWException Handling: Comparative Data Table Currency3VBKLAgreement Classnvarchar40
85/BEV3/CHCBPO0350Amount to be copied from LT0350 into BPO dep. on AC/RI/ENT3VBKLAgreement Classnvarchar40
86/BEV3/CHCBPO0500Assignment of the basic data to BPO3VBKLAgreement Classnvarchar40
87/BEV3/CHCBPO700ABPOs for link type 0700: Build-up BPO with components5VBKLAgreement Classnvarchar40
88/BEV3/CHCBPO700PInformation for Evaluating Link Type 0700 - Data Sources4VBKLAgreement Classnvarchar40
89/BEV3/CHCDPBEWSDCDP: Contract Dates (SD Valuation)3VBKLAgreement Classnvarchar40
90/BEV3/CHCDPBKCDP: Purchase Control Results4VBKLAgreement Classnvarchar40
91/BEV3/CHCDPLINKCDP: Contract References13VBKLAgreement Classnvarchar40
92/BEV3/CHCDPOBLIGCDP: Contractual Services3VBKLAgreement Classnvarchar40
93/BEV3/CHCDPSALESCDP: Contract Sales (Detailed)8VBKLAgreement Classnvarchar40
94/BEV3/CHCDPSORTMCDP: Contract Assortments3VBKLAgreement Classnvarchar40
95/BEV3/CHCDPTERMICDP: Contract Dates (Dates and PC)3VBKLAgreement Classnvarchar40
96/BEV3/CHCDPTEXTCDP: Contract Texts3VBKLAgreement Classnvarchar40
97/BEV3/CHCERGPERCustomizing: Supplement - Periods to Be Supplemented2VBKLAgreement Classnvarchar40
98/BEV3/CHCEVLASFICH BTE: Customizing Event Listener Assessment FI6VBKLAgreement Classnvarchar40
99/BEV3/CHCFDFIELDTarget Fields of Agreements2VBKLAgreement Classnvarchar40
100/BEV3/CHCHDPReports for Evaluation Agreements2VBKLAgreement Classnvarchar40
101/BEV3/CHCKAWDEFDefinition of the CEV evaluations7VBKLAgreement Classnvarchar40
102/BEV3/CHCLTLOABRLink type/place for data transfer in settlement record2VBKLAgreement Classnvarchar40
103/BEV3/CHCPOSTXItem texts4VBKLAgreement Classnvarchar40
104/BEV3/CHCPT_FSelected Fields for Item Text Formation4VBKLAgreement Classnvarchar40
105/BEV3/CHCRSTRTItem List - Resettle/Change Despite Success.Final Settlement2VBKLAgreement Classnvarchar40
106/BEV3/CHCSIMKONTSpec. Account Views for Settlement Simulation4VBKLAgreement Classnvarchar40
107/BEV3/CHCSIMSALDSpec. Balancing Method for Simulation4VBKLAgreement Classnvarchar40
108/BEV3/CHCTBDVKRARule Attributes to be Copied to LT05002VBKLAgreement Classnvarchar40
109/BEV3/CHCTLINKCustomizing Link Reference Annulment, Coding Assignment2VBKLAgreement Classnvarchar40
110/BEV3/CHCTLTBERLink Type/Link Loc. Combination with Ref. to Consultant Tab.2VBKLAgreement Classnvarchar40
111/BEV3/CHCTTMPRIOCustomizing Date Priority (CH Cross-Organizational)3VBKLAgreement Classnvarchar40
112/BEV3/CHCTTMPRIVCustomizing Date Priority per CH Organization Unit4VBKLAgreement Classnvarchar40
113/BEV3/CHCTTMSTZPCustomizing: Time -> Module2VBKLAgreement Classnvarchar40
114/BEV3/CHCTVBKLTBTables Used by Agreement Classes (AG - Special)2VBKLAgreement Classnvarchar40
115/BEV3/CHCTVBLOABCombination of Agreement Class/Link Type Out/Settlement Mod.2VBKLAgreement Classnvarchar40
116/BEV3/CHCTVBRILOAllowed Locations_out for Agreement Class/Rule Identifier2VBKLAgreement Classnvarchar40
117/BEV3/CHCTVKRAKKCustomizing AGCL, RA, area/range ID and RA for area/range2VBKLAgreement Classnvarchar40
118/BEV3/CHCTVKTMSTCustomizing: AC Date Coding Date Control2VBKLAgreement Classnvarchar40
119/BEV3/CHCTVRABGCustomizing AG Class Rule ID Rule Attribute Condition Group2VBKLAgreement Classnvarchar40
120/BEV3/CHCTVRILOTCustomizing: Linktype(Out) Linktype/Loc.(In) for AG Class RI2VBKLAgreement Classnvarchar40
121/BEV3/CHCVBFIMA1FIMA converter 1 AC/RI control record setting2VBKLAgreement Classnvarchar40
122/BEV3/CHCVKEVASFCH BTE: AC Event Assessment FI2VBKLAgreement Classnvarchar40
123/BEV3/CHCVKTORPSettlement relevant representation of an agreement2VBKLAgreement Classnvarchar40
124/BEV3/CHC_KAWDEFDefinition of the CEV evaluations7VBKLAgreement Classnvarchar40
125/BEV3/CHERGSTZ_PCH Settlement Items - With Translations12VBKLAgreement Class - Contract Callednvarchar40
126/BEV3/CHERGSTZ_SCH Settlement Statistics13VBKLAgreement Class - Contract Callednvarchar40
127/BEV3/CHEVTMNOTEDate Part Info. Regarding Link to Deviating CHD Number5VBKLAgreement Classnvarchar40
128/BEV3/CHEVVWDNRNInformation from the Deviating AG CHD No. to the BTE6VBKLAgreement Classnvarchar40
129/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics12VBKLAgreement Class - Contract Callednvarchar40
130/BEV3/CHKAALLOCACustomer Evaluation Table: Contract Allocations3VBKLAgreement Classnvarchar40
131/BEV3/CHKABEWSDCustomer Evaluation Table: Dates Valuation SD4VBKLAgreement Classnvarchar40
132/BEV3/CHKAOBLIGACustomer Evaluation Table: Contract Performances4VBKLAgreement Classnvarchar40
133/BEV3/CHKASRTMNTCustomer Evaluation Table: Assortments4VBKLAgreement Classnvarchar40
134/BEV3/CHKATERMINCustomer Evaluation Table: Dates General4VBKLAgreement Classnvarchar40
135/BEV3/CHKATMABUMCustomer Evaluation Table: Sales per Date3VBKLAgreement Classnvarchar40
136/BEV3/CHKAW_TEXTCustomer Evaluation Table: Text5VBKLAgreement Classnvarchar40
137/BEV3/CHNODESStructure of Contract Tree11VBKLAgreement Classnvarchar40
138/BEV3/CHRDSTATCH Modules for Reading Statisitics3VBKLAgreement Classnvarchar40
139/BEV3/CHREPPARMCH: General Parameter Table for Reports (CDP)7VBKLAgreement Classnvarchar40
140/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)12VBKLAgreement Class - Contract Callednvarchar40
141/BEV3/CHSHTSTZ_PCH Settlement Item12VBKLAgreement Class - Contract Callednvarchar40
142/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions13VBKLAgreement Class - Contract Callednvarchar40
143/BEV3/CHSIMSTZ_PCH Simulation Items12VBKLAgreement Class - Contract Callednvarchar40
144/BEV3/CHSIMSTZ_SCH Simulation Statistics13VBKLAgreement Class - Contract Callednvarchar40
145/BEV3/CHTBTEXTAgreement Text3VBKLAgreement Classnvarchar40
146/BEV3/CHTMP0200Link Type 0200 Temporary Data from Settlement11VBKLAgreement Classnvarchar40
147/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item13VBKLAgreement Class - Contract Callednvarchar40
148/BEV3/CHTRMSTZ_PCH Date Item12VBKLAgreement Class - Contract Callednvarchar40
149/BEV3/CHTRMSTZ_SCH Date Statistics13VBKLAgreement Class - Contract Callednvarchar40
150/BEV3/CHVABRSTZSCH Settlement Statistics13VBKLAgreement Class - Contract Callednvarchar40