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

114 columns | Print definition?ERP 6.0  | VBIN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPRemaining Beverage - Obsolete Objects
1/BEV3/CHABRKZL_TCH Settlement Key Figure Statistics8VBINAgreement Entity - Contract Callednvarchar40
2/BEV3/CHABRSTZ_PCH Settlement Items - With Translations14VBINAgreement Entity - Contract Callednvarchar40
3/BEV3/CHAGTREEContract Tree9VBINAgreement Entitynvarchar40
4/BEV3/CHBABNHMAgreement Purchase5VBINAgreement Entitynvarchar40
5/BEV3/CHBABSATZAgreement Sales5VBINAgreement Entitynvarchar40
6/BEV3/CHBABSSAgreement Sales Scale Refund5VBINAgreement Entitynvarchar40
7/BEV3/CHBABSTVGAgreement Sales Scale Refunding5VBINAgreement Entitynvarchar40
8/BEV3/CHBABSVGAgreement Sales Refunding5VBINAgreement Entitynvarchar40
9/BEV3/CHBALLGAgreements Administration table (Generalized Data)5VBINAgreement Entitynvarchar40
10/BEV3/CHBALLVAgreements Administration Table: Visibility Index5VBINAgreement Entitynvarchar40
11/BEV3/CHBANNUAgreement Annuity5VBINAgreement Entitynvarchar40
12/BEV3/CHBBDGSTFAgreement Condition Strategy - Formula5VBINAgreement Entitynvarchar40
13/BEV3/CHBBDGSTTAgreement Condition Strategy - Text5VBINAgreement Entitynvarchar40
14/BEV3/CHBBKBDGAgreement Purchase Control - Part Condition5VBINAgreement Entitynvarchar40
15/BEV3/CHBBKBFIAgreement Purchase Control - Part Valuation FI5VBINAgreement Entitynvarchar40
16/BEV3/CHBBKBSDAgreement Purchase Control - Part Valuation SD5VBINAgreement Entitynvarchar40
17/BEV3/CHBBKBVVAgreement Purchase Control - Part Valuation CH5VBINAgreement Entitynvarchar40
18/BEV3/CHBBKFLGAgreement Purchase Control - Part Sequence5VBINAgreement Entitynvarchar40
19/BEV3/CHBBKKNTRAgreement Purchase Control - Part Request5VBINAgreement Entitynvarchar40
20/BEV3/CHBBKSTAgreement Purchase Control - Part Status5VBINAgreement Entitynvarchar40
21/BEV3/CHBBKTMAgreement Purchase Control - Part Date5VBINAgreement Entitynvarchar40
22/BEV3/CHBBKVRKTAgreement Purchase Control - Part Concatenation5VBINAgreement Entitynvarchar40
23/BEV3/CHBCALCCAgreement Calculation - Formula Constant5VBINAgreement Entitynvarchar40
24/BEV3/CHBCALCFAgreement Calculation - Formula5VBINAgreement Entitynvarchar40
25/BEV3/CHBCALCTAgreement Calculation5VBINAgreement Entitynvarchar40
26/BEV3/CHBCALCTTAgreement Calculation - Text5VBINAgreement Entitynvarchar40
27/BEV3/CHBCALCVAgreement Calculation - Formula Variable5VBINAgreement Entitynvarchar40
28/BEV3/CHBDATUMAgreement Date5VBINAgreement Entitynvarchar40
29/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items15VBINAgreement Entity - Contract Callednvarchar40
30/BEV3/CHBEINBINIntegration Agreement5VBINAgreement Entitynvarchar40
31/BEV3/CHBEXTBAgreement External Amount5VBINAgreement Entitynvarchar40
32/BEV3/CHBEZINSExternal Interest Agreement5VBINAgreement Entitynvarchar40
33/BEV3/CHBFBTRGAgreement Fixed Amount5VBINAgreement Entitynvarchar40
34/BEV3/CHBFPROZAgreement Fixed Percentage5VBINAgreement Entitynvarchar40
35/BEV3/CHBGABSTotal Sales Agreement5VBINAgreement Entitynvarchar40
36/BEV3/CHBGROUPAgreement Group5VBINAgreement Entitynvarchar40
37/BEV3/CHBGUMSTotal Sales Agreement5VBINAgreement Entitynvarchar40
38/BEV3/CHBINSTAgreements Administration Table Entity Attributes5VBINAgreement Entitynvarchar40
39/BEV3/CHBINSTTAgreements Administration Table Entity Attributes5VBINAgreement Entitynvarchar40
40/BEV3/CHBIZINSAgreement Internal Interest5VBINAgreement Entitynvarchar40
41/BEV3/CHBKERGRSLPurchase control results7VBINAgreement Entitynvarchar40
42/BEV3/CHBKOMTRAgreement Communication6VBINAgreement Entitynvarchar40
43/BEV3/CHBKONTAgreement Account5VBINAgreement Entitynvarchar40
44/BEV3/CHBKPKPZLAgreement Complement Capital Payment (BTE)5VBINAgreement Entitynvarchar40
45/BEV3/CHBKRESHISPurchase Control Results - History7VBINAgreement Entitynvarchar40
46/BEV3/CHBKRESULTPurchase control results7VBINAgreement Entitynvarchar40
47/BEV3/CHBKTMPTemp. Purchase Control Results7VBINAgreement Entitynvarchar40
48/BEV3/CHBLEISTAgreement Performance5VBINAgreement Entitynvarchar40
49/BEV3/CHBMINUMAgreement Sales Target5VBINAgreement Entitynvarchar40
50/BEV3/CHBPARTAgreement Partner SD5VBINAgreement Entitynvarchar40
51/BEV3/CHBPOSTAgreement Text5VBINAgreement Entitynvarchar40
52/BEV3/CHBPRZABWAgreement Out-of-Line Percentage5VBINAgreement Entitynvarchar40
53/BEV3/CHBPRZGRZAgreement Percentage Limits5VBINAgreement Entitynvarchar40
54/BEV3/CHBREGINFPayer Information Agreement5VBINAgreement Entitynvarchar40
55/BEV3/CHBRUECKAgreement Breakdown Arrears5VBINAgreement Entitynvarchar40
56/BEV3/CHBSALEIPayment in Kind Agreement5VBINAgreement Entitynvarchar40
57/BEV3/CHBSECUREAgreement Collateral5VBINAgreement Entitynvarchar40
58/BEV3/CHBSICHAgreement Collateral5VBINAgreement Entitynvarchar40
59/BEV3/CHBSORTAgreement Contract Assortment List5VBINAgreement Entitynvarchar40
60/BEV3/CHBTERMINAgreement Date5VBINAgreement Entitynvarchar40
61/BEV3/CHBTMANFOAgreement Date Request5VBINAgreement Entitynvarchar40
62/BEV3/CHBTMANWEAgreement Date Statement5VBINAgreement Entitynvarchar40
63/BEV3/CHBTMBDGAgreement Date Condition5VBINAgreement Entitynvarchar40
64/BEV3/CHBTMBEWFIAgreement Date Valuation FI5VBINAgreement Entitynvarchar40
65/BEV3/CHBTMBEWSDAgreement Date Valuation SD5VBINAgreement Entitynvarchar40
66/BEV3/CHBTMBEWVVAgreement Date Valuation CH5VBINAgreement Entitynvarchar40
67/BEV3/CHBTMFOLGEAgreement Date Sequence5VBINAgreement Entitynvarchar40
68/BEV3/CHBTMSTATUAgreement Date Status5VBINAgreement Entitynvarchar40
69/BEV3/CHBTMVKTGAgreement Date Concatenation5VBINAgreement Entitynvarchar40
70/BEV3/CHBUMSATZAgreement Sales (Actual)5VBINAgreement Entitynvarchar40
71/BEV3/CHBUMSPAgreement Sales Scale, Percent5VBINAgreement Entitynvarchar40
72/BEV3/CHBVERREAgreement Clearing5VBINAgreement Entitynvarchar40
73/BEV3/CHBVORGAgreement Transaction5VBINAgreement Entitynvarchar40
74/BEV3/CHBVWDNRAgreement deviating CHD number5VBINAgreement Entitynvarchar40
75/BEV3/CHBWAERAgreement Currency5VBINAgreement Entitynvarchar40
76/BEV3/CHBXREFAgreements Where-Used-List7VBINAgreement Entitynvarchar40
77/BEV3/CHBZUSCHAgreement Allowance5VBINAgreement Entitynvarchar40
78/BEV3/CHCA_PROException Handling: log15VBINAgreement Entitynvarchar40
79/BEV3/CHCA_RELException Handling: Relevance Table for Exception Analysis11VBINAgreement Entitynvarchar40
80/BEV3/CHCBPO0350Amount to be copied from LT0350 into BPO dep. on AC/RI/ENT5VBINAgreement Entitynvarchar40
81/BEV3/CHCDPBEWSDCDP: Contract Dates (SD Valuation)5VBINAgreement Entitynvarchar40
82/BEV3/CHCDPBKCDP: Purchase Control Results6VBINAgreement Entitynvarchar40
83/BEV3/CHCDPLINKCDP: Contract References15VBINAgreement Entitynvarchar40
84/BEV3/CHCDPOBLIGCDP: Contractual Services5VBINAgreement Entitynvarchar40
85/BEV3/CHCDPSALESCDP: Contract Sales (Detailed)10VBINAgreement Entitynvarchar40
86/BEV3/CHCDPSORTMCDP: Contract Assortments5VBINAgreement Entitynvarchar40
87/BEV3/CHCDPTERMICDP: Contract Dates (Dates and PC)5VBINAgreement Entitynvarchar40
88/BEV3/CHCDPTEXTCDP: Contract Texts5VBINAgreement Entitynvarchar40
89/BEV3/CHCKAWDEFDefinition of the CEV evaluations9VBINAgreement Entitynvarchar40
90/BEV3/CHC_KAWDEFDefinition of the CEV evaluations9VBINAgreement Entitynvarchar40
91/BEV3/CHERGSTZ_PCH Settlement Items - With Translations14VBINAgreement Entity - Contract Callednvarchar40
92/BEV3/CHERGSTZ_SCH Settlement Statistics15VBINAgreement Entity - Contract Callednvarchar40
93/BEV3/CHEVTMNOTEDate Part Info. Regarding Link to Deviating CHD Number7VBINAgreement Entitynvarchar40
94/BEV3/CHEVVWDNRNInformation from the Deviating AG CHD No. to the BTE8VBINAgreement Entitynvarchar40
95/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics14VBINAgreement Entity - Contract Callednvarchar40
96/BEV3/CHKAALLOCACustomer Evaluation Table: Contract Allocations5VBINAgreement Entitynvarchar40
97/BEV3/CHKABEWSDCustomer Evaluation Table: Dates Valuation SD6VBINAgreement Entitynvarchar40
98/BEV3/CHKAOBLIGACustomer Evaluation Table: Contract Performances6VBINAgreement Entitynvarchar40
99/BEV3/CHKASRTMNTCustomer Evaluation Table: Assortments6VBINAgreement Entitynvarchar40
100/BEV3/CHKATERMINCustomer Evaluation Table: Dates General6VBINAgreement Entitynvarchar40
101/BEV3/CHKATMABUMCustomer Evaluation Table: Sales per Date5VBINAgreement Entitynvarchar40
102/BEV3/CHKAW_TEXTCustomer Evaluation Table: Text7VBINAgreement Entitynvarchar40
103/BEV3/CHNODESStructure of Contract Tree13VBINAgreement Entitynvarchar40
104/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)14VBINAgreement Entity - Contract Callednvarchar40
105/BEV3/CHSHTSTZ_PCH Settlement Item14VBINAgreement Entity - Contract Callednvarchar40
106/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions15VBINAgreement Entity - Contract Callednvarchar40
107/BEV3/CHSIMSTZ_PCH Simulation Items14VBINAgreement Entity - Contract Callednvarchar40
108/BEV3/CHSIMSTZ_SCH Simulation Statistics15VBINAgreement Entity - Contract Callednvarchar40
109/BEV3/CHTBTEXTAgreement Text5VBINAgreement Entitynvarchar40
110/BEV3/CHTMP0200Link Type 0200 Temporary Data from Settlement13VBINAgreement Entitynvarchar40
111/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item15VBINAgreement Entity - Contract Callednvarchar40
112/BEV3/CHTRMSTZ_PCH Date Item14VBINAgreement Entity - Contract Callednvarchar40
113/BEV3/CHTRMSTZ_SCH Date Statistics15VBINAgreement Entity - Contract Callednvarchar40
114/BEV3/CHVABRSTZSCH Settlement Statistics15VBINAgreement Entity - Contract Callednvarchar40