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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

138 columns | Print definition?ERP 6.0  | YVORGE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPRemaining Beverage - Obsolete Objects
1/BEV3/CHABRKZL_TCH Settlement Key Figure Statistics14YVORGECH Organizational Unitnvarchar40
2/BEV3/CHABRSTZ_KSettlement Record - Header3YVORGECH Organizational Unitnvarchar40
3/BEV3/CHABRSTZ_PCH Settlement Items - With Translations4YVORGECH Organizational Unitnvarchar40
4/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items7YVORGECH Organizational Unitnvarchar40
5/BEV3/CHBFLDSTATAgreements Field Status2YVORGECH Organizational Unitnvarchar40
6/BEV3/CHBKOMTRAgreement Communication9YVORGECH Organizational Unitnvarchar40
7/BEV3/CHBKSTK_CCH Settlement Stats for Exception Trigger in Purchase Ctrl9YVORGECH Organizational Unitnvarchar40
8/BEV3/CHBKSTK_TCH Settlement Statistics Final Settlement Information8YVORGECH Organizational Unitnvarchar40
9/BEV3/CHBKTMP_CTemp.CH Settlement Stats for Except.Trigger in Purchase Ctrl9YVORGECH Organizational Unitnvarchar40
10/BEV3/CHBKTMP_TTemp. CH Settlement Stats Final Settlement Information8YVORGECH Organizational Unitnvarchar40
11/BEV3/CHBPROTLog of Agreements from Rule Dispatcher7YVORGECH Organizational Unitnvarchar40
12/BEV3/CHBXREFAgreements Where-Used-List3YVORGECH Organizational Unitnvarchar40
13/BEV3/CHCBASDRNGPermissible period for to-settlement selection date2YVORGECH Organizational Unitnvarchar40
14/BEV3/CHCEV103XCH BTE Permissible Events Res. frm Combination CHD/1030 Data3YVORGECH Organizational Unitnvarchar40
15/BEV3/CHCEVVWDEXCH BTE Allowed Events from CHD3YVORGECH Organizational Unitnvarchar40
16/BEV3/CHCREGDISPRule Dispatcher, User Settings3YVORGECH Organizational Unitnvarchar40
17/BEV3/CHCRESVWVGContract Handling Transaction for Reset Process2YVORGECH Organizational Unitnvarchar40
18/BEV3/CHCSIMKONTSpec. Account Views for Settlement Simulation2YVORGECH Organizational Unitnvarchar40
19/BEV3/CHCSIMSALDSpec. Balancing Method for Simulation2YVORGECH Organizational Unitnvarchar40
20/BEV3/CHCSTVCHCKReset: Settings for Variable Check Criteria2YVORGECH Organizational Unitnvarchar40
21/BEV3/CHCTSTKLTax classification2YVORGECH Organizational Unitnvarchar40
22/BEV3/CHCTTMPRIVCustomizing Date Priority per CH Organization Unit2YVORGECH Organizational Unitnvarchar40
23/BEV3/CHERGSTZ_KSettlement Record - Header3YVORGECH Organizational Unitnvarchar40
24/BEV3/CHERGSTZ_PCH Settlement Items - With Translations4YVORGECH Organizational Unitnvarchar40
25/BEV3/CHERGSTZ_SCH Settlement Statistics5YVORGECH Organizational Unitnvarchar40
26/BEV3/CHEXCSTZ_KCH Settlement Header/Non-Posted Docs w/o Date Statistics3YVORGECH Organizational Unitnvarchar40
27/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics4YVORGECH Organizational Unitnvarchar40
28/BEV3/CHKACNTRCTCustomer Evaluation Table: Contract7YVORGECH Organizational Unitnvarchar40
29/BEV3/CHKA_SALDOCustomer Evaluation Table: Balances from FI Ledger5YVORGECH Organizational Unitnvarchar40
30/BEV3/CHOAEObject Annual Purchasing Expectation2YVORGECH Organizational Unitnvarchar40
31/BEV3/CHOBObject Valuation2YVORGECH Organizational Unitnvarchar40
32/BEV3/CHOBSObject status2YVORGECH Organizational Unitnvarchar40
33/BEV3/CHOLBobject performance participation, relation-like attribute2YVORGECH Organizational Unitnvarchar40
34/BEV3/CHOLSObject performance2YVORGECH Organizational Unitnvarchar40
35/BEV3/CHORBObject Room Valuation2YVORGECH Organizational Unitnvarchar40
36/BEV3/CHORGETText Table for Organizational Unit3YVORGECH Organizational Unitnvarchar40
37/BEV3/CHPRUEF_Z4Control Table for Time 4 - Check2YVORGECH Organizational Unitnvarchar40
38/BEV3/CHRALGGeneral Rule2YVORGECH Organizational Unitnvarchar40
39/BEV3/CHRDSTATCH Modules for Reading Statisitics2YVORGECH Organizational Unitnvarchar40
40/BEV3/CHRESSTZ_KSettlement Record - Header - Reset Documents (2/Transaction)3YVORGECH Organizational Unitnvarchar40
41/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)4YVORGECH Organizational Unitnvarchar40
42/BEV3/CHRGABRERFSettlement Success Rule2YVORGECH Organizational Unitnvarchar40
43/BEV3/CHRGABRINFSettlement Info Rule2YVORGECH Organizational Unitnvarchar40
44/BEV3/CHRGABZPKTRule From Time Control2YVORGECH Organizational Unitnvarchar40
45/BEV3/CHRGANFFRMRule Request Form2YVORGECH Organizational Unitnvarchar40
46/BEV3/CHRGANWFRMRule Statement Form2YVORGECH Organizational Unitnvarchar40
47/BEV3/CHRGAUSGRule: Clearing2YVORGECH Organizational Unitnvarchar40
48/BEV3/CHRGBDGCondition Rule2YVORGECH Organizational Unitnvarchar40
49/BEV3/CHRGBLSTRule Performance Type2YVORGECH Organizational Unitnvarchar40
50/BEV3/CHRGBTRGAmount Rule2YVORGECH Organizational Unitnvarchar40
51/BEV3/CHRGBUKRSPeriod View Rule2YVORGECH Organizational Unitnvarchar40
52/BEV3/CHRGBUKZRule: Posting ID2YVORGECH Organizational Unitnvarchar40
53/BEV3/CHRGDATUMPeriod Group Rule2YVORGECH Organizational Unitnvarchar40
54/BEV3/CHRGDNAMAssortment Type Rule2YVORGECH Organizational Unitnvarchar40
55/BEV3/CHRGEGZFRMRule Request Form2YVORGECH Organizational Unitnvarchar40
56/BEV3/CHRGEINHUnit Rule2YVORGECH Organizational Unitnvarchar40
57/BEV3/CHRGEITRRight of Entry Rule2YVORGECH Organizational Unitnvarchar40
58/BEV3/CHRGEZSCHLRule Interest Key - External2YVORGECH Organizational Unitnvarchar40
59/BEV3/CHRGFRMFormula Rule2YVORGECH Organizational Unitnvarchar40
60/BEV3/CHRGGEN3Customer No. Rule2YVORGECH Organizational Unitnvarchar40
61/BEV3/CHRGGRUMRule Movement Types, Grouping Characteristic2YVORGECH Organizational Unitnvarchar40
62/BEV3/CHRGHASBRule Tap/Dispenser Use2YVORGECH Organizational Unitnvarchar40
63/BEV3/CHRGKPBGRPRule Complement Posting Group (BTE)2YVORGECH Organizational Unitnvarchar40
64/BEV3/CHRGKREISRule Area/Range2YVORGECH Organizational Unitnvarchar40
65/BEV3/CHRGKTSIAccount View Rule2YVORGECH Organizational Unitnvarchar40
66/BEV3/CHRGKUNNRCustomer No. Rule2YVORGECH Organizational Unitnvarchar40
67/BEV3/CHRGLSTBWRule Performance Valuation2YVORGECH Organizational Unitnvarchar40
68/BEV3/CHRGMAHNDunning Key Rule2YVORGECH Organizational Unitnvarchar40
69/BEV3/CHRGMHNBERDunning Area Rule2YVORGECH Organizational Unitnvarchar40
70/BEV3/CHRGMHNSPDunning Block Rule2YVORGECH Organizational Unitnvarchar40
71/BEV3/CHRGMNGEQuantity Rule2YVORGECH Organizational Unitnvarchar40
72/BEV3/CHRGPBKTYPPartner Bank Type Rule2YVORGECH Organizational Unitnvarchar40
73/BEV3/CHRGPERGRPPeriod Group Rule2YVORGECH Organizational Unitnvarchar40
74/BEV3/CHRGPERIPeriod Rule2YVORGECH Organizational Unitnvarchar40
75/BEV3/CHRGPERVWPeriod View Rule2YVORGECH Organizational Unitnvarchar40
76/BEV3/CHRGPGDATPeriod Group Date Rule2YVORGECH Organizational Unitnvarchar40
77/BEV3/CHRGPRTSTPrint Strategy Rule2YVORGECH Organizational Unitnvarchar40
78/BEV3/CHRGPRZNTPercent Rule2YVORGECH Organizational Unitnvarchar40
79/BEV3/CHRGRUNDUNRounding Control Rule2YVORGECH Organizational Unitnvarchar40
80/BEV3/CHRGSALAPayment in Kind Type Rule2YVORGECH Organizational Unitnvarchar40
81/BEV3/CHRGSALDRule Balancing Method2YVORGECH Organizational Unitnvarchar40
82/BEV3/CHRGSALGPayment in Kind Grp Rule2YVORGECH Organizational Unitnvarchar40
83/BEV3/CHRGSECORTRule Collateral Depository2YVORGECH Organizational Unitnvarchar40
84/BEV3/CHRGSECTYPCollateral Type Rule2YVORGECH Organizational Unitnvarchar40
85/BEV3/CHRGSOLIAssortment List Rule2YVORGECH Organizational Unitnvarchar40
86/BEV3/CHRGSORTAssortment Rule2YVORGECH Organizational Unitnvarchar40
87/BEV3/CHRGSPARTDivision Rule2YVORGECH Organizational Unitnvarchar40
88/BEV3/CHRGSTAFScale Rule2YVORGECH Organizational Unitnvarchar40
89/BEV3/CHRGSTRATCondition Rule2YVORGECH Organizational Unitnvarchar40
90/BEV3/CHRGSTYPAssortment Type Rule2YVORGECH Organizational Unitnvarchar40
91/BEV3/CHRGVBLINRule Agreement Link Entity (Deviating Contract)2YVORGECH Organizational Unitnvarchar40
92/BEV3/CHRGVBLNKAgreement Link Rule2YVORGECH Organizational Unitnvarchar40
93/BEV3/CHRGVBVBAgreement / Agreement Rule2YVORGECH Organizational Unitnvarchar40
94/BEV3/CHRGVDSTFICompression Strategy FI Rule2YVORGECH Organizational Unitnvarchar40
95/BEV3/CHRGVDSTSDCompression Strategy SD Rule2YVORGECH Organizational Unitnvarchar40
96/BEV3/CHRGVDSTVVCompression Strategy CH Rule2YVORGECH Organizational Unitnvarchar40
97/BEV3/CHRGVERWUsage Rule2YVORGECH Organizational Unitnvarchar40
98/BEV3/CHRGVKORGSales Organization Rule2YVORGECH Organizational Unitnvarchar40
99/BEV3/CHRGVTWEGDistribution Channel Rule2YVORGECH Organizational Unitnvarchar40
100/BEV3/CHRGVWDVBContract Handling Document / Agreement Rule2YVORGECH Organizational Unitnvarchar40
101/BEV3/CHRGVWVORGCH Transaction (Settle) Rule2YVORGECH Organizational Unitnvarchar40
102/BEV3/CHRGWAERKCurrency Code Rule2YVORGECH Organizational Unitnvarchar40
103/BEV3/CHRGXXXXRule XXXX2YVORGECH Organizational Unitnvarchar40
104/BEV3/CHRGZEITTime Condition Rule2YVORGECH Organizational Unitnvarchar40
105/BEV3/CHRGZHLBDGTerms of Payment Rule2YVORGECH Organizational Unitnvarchar40
106/BEV3/CHRGZHLSPPayment Block Rule2YVORGECH Organizational Unitnvarchar40
107/BEV3/CHRGZHLWGPayment Method Rule2YVORGECH Organizational Unitnvarchar40
108/BEV3/CHRGZNSCHLInterest Key Rule2YVORGECH Organizational Unitnvarchar40
109/BEV3/CHSHTSTZSDSpecial Interface Data for SD - Not CH-Relevant4YVORGECH Organizational Unitnvarchar40
110/BEV3/CHSHTSTZ_KInterface Record - Header (SD)3YVORGECH Organizational Unitnvarchar40
111/BEV3/CHSHTSTZ_PCH Settlement Item4YVORGECH Organizational Unitnvarchar40
112/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions7YVORGECH Organizational Unitnvarchar40
113/BEV3/CHSIMSTKFHCH Settlement Statistics Header Data - History11YVORGECH Organizational Unitnvarchar40
114/BEV3/CHSIMSTK_CCH - Simulation Statistics of Exception Trigger9YVORGECH Organizational Unitnvarchar40
115/BEV3/CHSIMSTK_FCH - Silulation Statistics Header Data8YVORGECH Organizational Unitnvarchar40
116/BEV3/CHSIMSTK_TCH Simulation Statistics Final Settlement Information8YVORGECH Organizational Unitnvarchar40
117/BEV3/CHSIMSTK_VCH - Simulation statistics of premature DA conditions7YVORGECH Organizational Unitnvarchar40
118/BEV3/CHSIMSTZ_KSimulation Record - Header3YVORGECH Organizational Unitnvarchar40
119/BEV3/CHSIMSTZ_PCH Simulation Items4YVORGECH Organizational Unitnvarchar40
120/BEV3/CHSIMSTZ_SCH Simulation Statistics5YVORGECH Organizational Unitnvarchar40
121/BEV3/CHTBPERSHuman Resources2YVORGECH Organizational Unitnvarchar40
122/BEV3/CHTBVORGECH Organizational Unit2YVORGECH Organizational Unitnvarchar40
123/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item7YVORGECH Organizational Unitnvarchar40
124/BEV3/CHTMPSTK_CCH - Temporary Statistics of Exception Trigger9YVORGECH Organizational Unitnvarchar40
125/BEV3/CHTMPSTK_FCH - Temporary Statistics Header Data8YVORGECH Organizational Unitnvarchar40
126/BEV3/CHTMPSTK_TCH - Temporary Statistics Final Settlement Information8YVORGECH Organizational Unitnvarchar40
127/BEV3/CHTMPSTK_VCH - temporary statistics of premature DA termination7YVORGECH Organizational Unitnvarchar40
128/BEV3/CHTRMSTK_CCH Settlement Statistics of Exception Trigger9YVORGECH Organizational Unitnvarchar40
129/BEV3/CHTRMSTK_TCH Settlement Statistics Final Settlement Information8YVORGECH Organizational Unitnvarchar40
130/BEV3/CHTRMSTK_VCH-settlement statistics of premature DA conditions7YVORGECH Organizational Unitnvarchar40
131/BEV3/CHTRMSTZ_KDate Record - Header3YVORGECH Organizational Unitnvarchar40
132/BEV3/CHTRMSTZ_PCH Date Item4YVORGECH Organizational Unitnvarchar40
133/BEV3/CHTRMSTZ_SCH Date Statistics5YVORGECH Organizational Unitnvarchar40
134/BEV3/CHTVWDARTContract Handling Document Type2YVORGECH Organizational Unitnvarchar40
135/BEV3/CHVABRSTZSCH Settlement Statistics5YVORGECH Organizational Unitnvarchar40
136/BEV3/CHWDContract Handling Document3YVORGECH Organizational Unitnvarchar40
137/BEV3/CHWDARTTContract Handling Document Type Text3YVORGECH Organizational Unitnvarchar40
138/BEV3/CHWDFLDSTField Status of Contract Handling Document2YVORGECH Organizational Unitnvarchar40