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

149 columns | Print definition?ERP 6.0  | RI

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGovernance, Risk and Compliance
1GRFNDMRIDataMart: Risk Influenced4RIInfluenced Risk IDnvarchar160
TOPRemaining Beverage - Obsolete Objects
2/BEV3/CHABRKZL_TCH Settlement Key Figure Statistics7RIRule Identifier - Contract Callednvarchar60
3/BEV3/CHABRSTZ_PCH Settlement Items - With Translations13RIRule Identifier - Contract Callednvarchar60
4/BEV3/CHAGTREEContract Tree8RIRule Identifiernvarchar60
5/BEV3/CHBABNHMAgreement Purchase4RIRule Identifiernvarchar60
6/BEV3/CHBABSATZAgreement Sales4RIRule Identifiernvarchar60
7/BEV3/CHBABSSAgreement Sales Scale Refund4RIRule Identifiernvarchar60
8/BEV3/CHBABSTVGAgreement Sales Scale Refunding4RIRule Identifiernvarchar60
9/BEV3/CHBABSVGAgreement Sales Refunding4RIRule Identifiernvarchar60
10/BEV3/CHBALLGAgreements Administration table (Generalized Data)4RIRule Identifiernvarchar60
11/BEV3/CHBALLVAgreements Administration Table: Visibility Index4RIRule Identifiernvarchar60
12/BEV3/CHBANNUAgreement Annuity4RIRule Identifiernvarchar60
13/BEV3/CHBBDGSTFAgreement Condition Strategy - Formula4RIRule Identifiernvarchar60
14/BEV3/CHBBDGSTTAgreement Condition Strategy - Text4RIRule Identifiernvarchar60
15/BEV3/CHBBKBDGAgreement Purchase Control - Part Condition4RIRule Identifiernvarchar60
16/BEV3/CHBBKBFIAgreement Purchase Control - Part Valuation FI4RIRule Identifiernvarchar60
17/BEV3/CHBBKBSDAgreement Purchase Control - Part Valuation SD4RIRule Identifiernvarchar60
18/BEV3/CHBBKBVVAgreement Purchase Control - Part Valuation CH4RIRule Identifiernvarchar60
19/BEV3/CHBBKFLGAgreement Purchase Control - Part Sequence4RIRule Identifiernvarchar60
20/BEV3/CHBBKKNTRAgreement Purchase Control - Part Request4RIRule Identifiernvarchar60
21/BEV3/CHBBKSTAgreement Purchase Control - Part Status4RIRule Identifiernvarchar60
22/BEV3/CHBBKTMAgreement Purchase Control - Part Date4RIRule Identifiernvarchar60
23/BEV3/CHBBKVRKTAgreement Purchase Control - Part Concatenation4RIRule Identifiernvarchar60
24/BEV3/CHBCALCCAgreement Calculation - Formula Constant4RIRule Identifiernvarchar60
25/BEV3/CHBCALCFAgreement Calculation - Formula4RIRule Identifiernvarchar60
26/BEV3/CHBCALCTAgreement Calculation4RIRule Identifiernvarchar60
27/BEV3/CHBCALCTTAgreement Calculation - Text4RIRule Identifiernvarchar60
28/BEV3/CHBCALCVAgreement Calculation - Formula Variable4RIRule Identifiernvarchar60
29/BEV3/CHBDATUMAgreement Date4RIRule Identifiernvarchar60
30/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items14RIRule Identifier - Contract Callednvarchar60
31/BEV3/CHBEINBINIntegration Agreement4RIRule Identifiernvarchar60
32/BEV3/CHBEXTBAgreement External Amount4RIRule Identifiernvarchar60
33/BEV3/CHBEZINSExternal Interest Agreement4RIRule Identifiernvarchar60
34/BEV3/CHBFBTRGAgreement Fixed Amount4RIRule Identifiernvarchar60
35/BEV3/CHBFPROZAgreement Fixed Percentage4RIRule Identifiernvarchar60
36/BEV3/CHBGABSTotal Sales Agreement4RIRule Identifiernvarchar60
37/BEV3/CHBGROUPAgreement Group4RIRule Identifiernvarchar60
38/BEV3/CHBGUMSTotal Sales Agreement4RIRule Identifiernvarchar60
39/BEV3/CHBINSTAgreements Administration Table Entity Attributes4RIRule Identifiernvarchar60
40/BEV3/CHBINSTTAgreements Administration Table Entity Attributes4RIRule Identifiernvarchar60
41/BEV3/CHBIZINSAgreement Internal Interest4RIRule Identifiernvarchar60
42/BEV3/CHBKERGRSLPurchase control results6RIRule Identifiernvarchar60
43/BEV3/CHBKOMTRAgreement Communication5RIRule Identifiernvarchar60
44/BEV3/CHBKONTAgreement Account4RIRule Identifiernvarchar60
45/BEV3/CHBKPKPZLAgreement Complement Capital Payment (BTE)4RIRule Identifiernvarchar60
46/BEV3/CHBKRESHISPurchase Control Results - History6RIRule Identifiernvarchar60
47/BEV3/CHBKRESULTPurchase control results6RIRule Identifier for Purchase Controlnvarchar60
48/BEV3/CHBKTMPTemp. Purchase Control Results6RIRule Identifiernvarchar60
49/BEV3/CHBLEISTAgreement Performance4RIRule Identifiernvarchar60
50/BEV3/CHBMINUMAgreement Sales Target4RIRule Identifiernvarchar60
51/BEV3/CHBPARTAgreement Partner SD4RIRule Identifiernvarchar60
52/BEV3/CHBPOSTAgreement Text4RIRule Identifiernvarchar60
53/BEV3/CHBPRZABWAgreement Out-of-Line Percentage4RIRule Identifiernvarchar60
54/BEV3/CHBPRZGRZAgreement Percentage Limits4RIRule Identifiernvarchar60
55/BEV3/CHBREGINFPayer Information Agreement4RIRule Identifiernvarchar60
56/BEV3/CHBRUECKAgreement Breakdown Arrears4RIRule Identifiernvarchar60
57/BEV3/CHBSALEIPayment in Kind Agreement4RIRule Identifiernvarchar60
58/BEV3/CHBSECUREAgreement Collateral4RIRule Identifiernvarchar60
59/BEV3/CHBSICHAgreement Collateral4RIRule Identifiernvarchar60
60/BEV3/CHBSORTAgreement Contract Assortment List4RIRule Identifiernvarchar60
61/BEV3/CHBTERMINAgreement Date4RIRule Identifiernvarchar60
62/BEV3/CHBTMANFOAgreement Date Request4RIRule Identifiernvarchar60
63/BEV3/CHBTMANWEAgreement Date Statement4RIRule Identifiernvarchar60
64/BEV3/CHBTMBDGAgreement Date Condition4RIRule Identifiernvarchar60
65/BEV3/CHBTMBEWFIAgreement Date Valuation FI4RIRule Identifiernvarchar60
66/BEV3/CHBTMBEWSDAgreement Date Valuation SD4RIRule Identifiernvarchar60
67/BEV3/CHBTMBEWVVAgreement Date Valuation CH4RIRule Identifiernvarchar60
68/BEV3/CHBTMFOLGEAgreement Date Sequence4RIRule Identifiernvarchar60
69/BEV3/CHBTMSTATUAgreement Date Status4RIRule Identifiernvarchar60
70/BEV3/CHBTMVKTGAgreement Date Concatenation4RIRule Identifiernvarchar60
71/BEV3/CHBUMSATZAgreement Sales (Actual)4RIRule Identifiernvarchar60
72/BEV3/CHBUMSPAgreement Sales Scale, Percent4RIRule Identifiernvarchar60
73/BEV3/CHBVERREAgreement Clearing4RIRule Identifiernvarchar60
74/BEV3/CHBVORGAgreement Transaction4RIRule Identifiernvarchar60
75/BEV3/CHBVWDNRAgreement deviating CHD number4RIRule Identifiernvarchar60
76/BEV3/CHBWAERAgreement Currency4RIRule Identifiernvarchar60
77/BEV3/CHBXREFAgreements Where-Used-List6RIRule Identifiernvarchar60
78/BEV3/CHBZUSCHAgreement Allowance4RIRule Identifiernvarchar60
79/BEV3/CHCAABTXTException Handling: Programs for Exception Handling - Text4RIRule Identifiernvarchar60
80/BEV3/CHCAGCLSFAssignment: Agreement to classification4RIRule Identifiernvarchar60
81/BEV3/CHCA_ABException Handling: Programs for Exception Handling4RIRule Identifiernvarchar60
82/BEV3/CHCA_PROException Handling: log14RIRule Identifiernvarchar60
83/BEV3/CHCA_REException Handling: Response4RIRule Identifiernvarchar60
84/BEV3/CHCA_RELException Handling: Relevance Table for Exception Analysis10RIRule Identifiernvarchar60
85/BEV3/CHCA_VWException Handling: Comparative Data Table Currency4RIRule Identifiernvarchar60
86/BEV3/CHCBKRIVBWContract MVT dependent on CoCd, RI, Date part, Contract view3RIRule Identifiernvarchar60
87/BEV3/CHCBPO0350Amount to be copied from LT0350 into BPO dep. on AC/RI/ENT4RIRule Identifiernvarchar60
88/BEV3/CHCBPO0500Assignment of the basic data to BPO4RIRule Identifiernvarchar60
89/BEV3/CHCBPO700ABPOs for link type 0700: Build-up BPO with components6RIRule Identifiernvarchar60
90/BEV3/CHCBPO700PInformation for Evaluating Link Type 0700 - Data Sources5RIRule Identifiernvarchar60
91/BEV3/CHCDPBEWSDCDP: Contract Dates (SD Valuation)4RIRule Identifiernvarchar60
92/BEV3/CHCDPBKCDP: Purchase Control Results5RIRule Identifiernvarchar60
93/BEV3/CHCDPLINKCDP: Contract References14RIRule Identifiernvarchar60
94/BEV3/CHCDPOBLIGCDP: Contractual Services4RIRule Identifiernvarchar60
95/BEV3/CHCDPPARMCDP: Parameter Control of CDP8RIRule Identifiernvarchar60
96/BEV3/CHCDPSALESCDP: Contract Sales (Detailed)9RIRule Identifiernvarchar60
97/BEV3/CHCDPSORTMCDP: Contract Assortments4RIRule Identifiernvarchar60
98/BEV3/CHCDPTERMICDP: Contract Dates (Dates and PC)4RIRule Identifiernvarchar60
99/BEV3/CHCDPTEXTCDP: Contract Texts4RIRule Identifiernvarchar60
100/BEV3/CHCERGPERCustomizing: Supplement - Periods to Be Supplemented3RIRule Identifiernvarchar60
101/BEV3/CHCEVLASFICH BTE: Customizing Event Listener Assessment FI7RIRule Identifiernvarchar60
102/BEV3/CHCFDFIELDTarget Fields of Agreements3RIRule Identifiernvarchar60
103/BEV3/CHCHDPReports for Evaluation Agreements3RIRule Identifiernvarchar60
104/BEV3/CHCKAWDEFDefinition of the CEV evaluations8RIRule Identifiernvarchar60
105/BEV3/CHCKMPLMNTCustom. of Complementation f. Negative Amounts in Sett. Rec.2RIRule Identifiernvarchar60
106/BEV3/CHCLTLOABRLink type/place for data transfer in settlement record3RIRule Identifiernvarchar60
107/BEV3/CHCPOSTXItem texts5RIRule Identifiernvarchar60
108/BEV3/CHCPT_FSelected Fields for Item Text Formation5RIRule Identifiernvarchar60
109/BEV3/CHCRSTRTItem List - Resettle/Change Despite Success.Final Settlement3RIRule Identifiernvarchar60
110/BEV3/CHCSIMKONTSpec. Account Views for Settlement Simulation5RIRule Identifiernvarchar60
111/BEV3/CHCSIMSALDSpec. Balancing Method for Simulation5RIRule Identifiernvarchar60
112/BEV3/CHCTKMPBCHComplement Postings (BTE)9RIRule Identifiernvarchar60
113/BEV3/CHCTLTBERLink Type/Link Loc. Combination with Ref. to Consultant Tab.3RIRule Identifiernvarchar60
114/BEV3/CHCTSTBSHLPosting key dependent on CoCd,acc. type/Datepart,sett.method5RIRule Identifiernvarchar60
115/BEV3/CHCTSTRKZCH Settlement Tax Indicator3RIRule Identifiernvarchar60
116/BEV3/CHCTTMPRIOCustomizing Date Priority (CH Cross-Organizational)4RIRule Identifiernvarchar60
117/BEV3/CHCTTMPRIVCustomizing Date Priority per CH Organization Unit5RIRule Identifiernvarchar60
118/BEV3/CHCTTMSTZPCustomizing: Time -> Module3RIRule Identifiernvarchar60
119/BEV3/CHCTVBRILOAllowed Locations_out for Agreement Class/Rule Identifier3RIRule Identifiernvarchar60
120/BEV3/CHCTVRABGCustomizing AG Class Rule ID Rule Attribute Condition Group3RIRule Identifiernvarchar60
121/BEV3/CHCTVRILOTCustomizing: Linktype(Out) Linktype/Loc.(In) for AG Class RI3RIRule Identifiernvarchar60
122/BEV3/CHCVBFIMA1FIMA converter 1 AC/RI control record setting3RIRule Identifiernvarchar60
123/BEV3/CHCVBWBKRIRI, DAPART,contract view dependent on contract movement type5RIRule Identifiernvarchar60
124/BEV3/CHC_KAWDEFDefinition of the CEV evaluations8RIRule Identifiernvarchar60
125/BEV3/CHERGSTZ_PCH Settlement Items - With Translations13RIRule Identifier - Contract Callednvarchar60
126/BEV3/CHERGSTZ_SCH Settlement Statistics14RIRule Identifier - Contract Callednvarchar60
127/BEV3/CHEVTMNOTEDate Part Info. Regarding Link to Deviating CHD Number6RIRule Identifiernvarchar60
128/BEV3/CHEVVWDNRNInformation from the Deviating AG CHD No. to the BTE7RIRule Identifiernvarchar60
129/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics13RIRule Identifier - Contract Callednvarchar60
130/BEV3/CHKAALLOCACustomer Evaluation Table: Contract Allocations4RIRule Identifiernvarchar60
131/BEV3/CHKABEWSDCustomer Evaluation Table: Dates Valuation SD5RIRule Identifiernvarchar60
132/BEV3/CHKAOBLIGACustomer Evaluation Table: Contract Performances5RIRule Identifiernvarchar60
133/BEV3/CHKASRTMNTCustomer Evaluation Table: Assortments5RIRule Identifiernvarchar60
134/BEV3/CHKATERMINCustomer Evaluation Table: Dates General5RIRule Identifiernvarchar60
135/BEV3/CHKATMABUMCustomer Evaluation Table: Sales per Date4RIRule Identifiernvarchar60
136/BEV3/CHKAW_TEXTCustomer Evaluation Table: Text6RIRule Identifiernvarchar60
137/BEV3/CHNODESStructure of Contract Tree12RIRule Identifiernvarchar60
138/BEV3/CHREPPARMCH: General Parameter Table for Reports (CDP)8RIRule Identifiernvarchar60
139/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)13RIRule Identifier - Contract Callednvarchar60
140/BEV3/CHSHTSTZ_PCH Settlement Item13RIRule Identifier - Contract Callednvarchar60
141/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions14RIRule Identifier - Contract Callednvarchar60
142/BEV3/CHSIMSTZ_PCH Simulation Items13RIRule Identifier - Contract Callednvarchar60
143/BEV3/CHSIMSTZ_SCH Simulation Statistics14RIRule Identifier - Contract Callednvarchar60
144/BEV3/CHTBTEXTAgreement Text4RIRule Identifiernvarchar60
145/BEV3/CHTMP0200Link Type 0200 Temporary Data from Settlement12RIRule Identifiernvarchar60
146/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item14RIRule Identifier - Contract Callednvarchar60
147/BEV3/CHTRMSTZ_PCH Date Item13RIRule Identifier - Contract Callednvarchar60
148/BEV3/CHTRMSTZ_SCH Date Statistics14RIRule Identifier - Contract Callednvarchar60
149/BEV3/CHVABRSTZSCH Settlement Statistics14RIRule Identifier - Contract Callednvarchar60