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

88 columns | Print definition?ERP 6.0  | VBNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPRemaining Beverage - Obsolete Objects
1/BEV3/CHABRSTZ_PCH Settlement Items - With Translations15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
2/BEV3/CHBABNHMAgreement Purchase6VBNRAgreement Number in Sequential Time Ordernvarchar90
3/BEV3/CHBABSATZAgreement Sales6VBNRAgreement Number in Sequential Time Ordernvarchar90
4/BEV3/CHBABSSAgreement Sales Scale Refund6VBNRAgreement Number in Sequential Time Ordernvarchar90
5/BEV3/CHBABSTVGAgreement Sales Scale Refunding6VBNRAgreement Number in Sequential Time Ordernvarchar90
6/BEV3/CHBABSVGAgreement Sales Refunding6VBNRAgreement Number in Sequential Time Ordernvarchar90
7/BEV3/CHBALLGAgreements Administration table (Generalized Data)6VBNRAgreement Number in Sequential Time Ordernvarchar90
8/BEV3/CHBALLVAgreements Administration Table: Visibility Index6VBNRAgreement Number in Sequential Time Ordernvarchar90
9/BEV3/CHBANNUAgreement Annuity6VBNRAgreement Number in Sequential Time Ordernvarchar90
10/BEV3/CHBBDGSTFAgreement Condition Strategy - Formula6VBNRAgreement Number in Sequential Time Ordernvarchar90
11/BEV3/CHBBDGSTTAgreement Condition Strategy - Text6VBNRAgreement Number in Sequential Time Ordernvarchar90
12/BEV3/CHBBKBDGAgreement Purchase Control - Part Condition6VBNRAgreement Number in Sequential Time Ordernvarchar90
13/BEV3/CHBBKBFIAgreement Purchase Control - Part Valuation FI6VBNRAgreement Number in Sequential Time Ordernvarchar90
14/BEV3/CHBBKBSDAgreement Purchase Control - Part Valuation SD6VBNRAgreement Number in Sequential Time Ordernvarchar90
15/BEV3/CHBBKBVVAgreement Purchase Control - Part Valuation CH6VBNRAgreement Number in Sequential Time Ordernvarchar90
16/BEV3/CHBBKFLGAgreement Purchase Control - Part Sequence6VBNRAgreement Number in Sequential Time Ordernvarchar90
17/BEV3/CHBBKKNTRAgreement Purchase Control - Part Request6VBNRAgreement Number in Sequential Time Ordernvarchar90
18/BEV3/CHBBKSTAgreement Purchase Control - Part Status6VBNRAgreement Number in Sequential Time Ordernvarchar90
19/BEV3/CHBBKTMAgreement Purchase Control - Part Date6VBNRAgreement Number in Sequential Time Ordernvarchar90
20/BEV3/CHBBKVRKTAgreement Purchase Control - Part Concatenation6VBNRAgreement Number in Sequential Time Ordernvarchar90
21/BEV3/CHBCALCCAgreement Calculation - Formula Constant6VBNRAgreement Number in Sequential Time Ordernvarchar90
22/BEV3/CHBCALCFAgreement Calculation - Formula6VBNRAgreement Number in Sequential Time Ordernvarchar90
23/BEV3/CHBCALCTAgreement Calculation6VBNRAgreement Number in Sequential Time Ordernvarchar90
24/BEV3/CHBCALCTTAgreement Calculation - Text6VBNRAgreement Number in Sequential Time Ordernvarchar90
25/BEV3/CHBCALCVAgreement Calculation - Formula Variable6VBNRAgreement Number in Sequential Time Ordernvarchar90
26/BEV3/CHBDATUMAgreement Date6VBNRAgreement Number in Sequential Time Ordernvarchar90
27/BEV3/CHBDMDHSTHistory of Condit. Modifications from Temp. Settlement Items16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
28/BEV3/CHBEINBINIntegration Agreement6VBNRAgreement Number in Sequential Time Ordernvarchar90
29/BEV3/CHBEXTBAgreement External Amount6VBNRAgreement Number in Sequential Time Ordernvarchar90
30/BEV3/CHBEZINSExternal Interest Agreement6VBNRAgreement Number in Sequential Time Ordernvarchar90
31/BEV3/CHBFBTRGAgreement Fixed Amount6VBNRAgreement Number in Sequential Time Ordernvarchar90
32/BEV3/CHBFPROZAgreement Fixed Percentage6VBNRAgreement Number in Sequential Time Ordernvarchar90
33/BEV3/CHBGABSTotal Sales Agreement6VBNRAgreement Number in Sequential Time Ordernvarchar90
34/BEV3/CHBGROUPAgreement Group6VBNRAgreement Number in Sequential Time Ordernvarchar90
35/BEV3/CHBGUMSTotal Sales Agreement6VBNRAgreement Number in Sequential Time Ordernvarchar90
36/BEV3/CHBIZINSAgreement Internal Interest6VBNRAgreement Number in Sequential Time Ordernvarchar90
37/BEV3/CHBKERGRSLPurchase control results8VBNRAgreement Number in Sequential Time Ordernvarchar90
38/BEV3/CHBKONTAgreement Account6VBNRAgreement Number in Sequential Time Ordernvarchar90
39/BEV3/CHBKPKPZLAgreement Complement Capital Payment (BTE)6VBNRAgreement Number in Sequential Time Ordernvarchar90
40/BEV3/CHBKRESHISPurchase Control Results - History8VBNRAgreement Number in Sequential Time Ordernvarchar90
41/BEV3/CHBKRESULTPurchase control results8VBNRAgreement Number in Sequential Time Ordernvarchar90
42/BEV3/CHBKTMPTemp. Purchase Control Results8VBNRAgreement Number in Sequential Time Ordernvarchar90
43/BEV3/CHBLEISTAgreement Performance6VBNRAgreement Number in Sequential Time Ordernvarchar90
44/BEV3/CHBMINUMAgreement Sales Target6VBNRAgreement Number in Sequential Time Ordernvarchar90
45/BEV3/CHBPARTAgreement Partner SD6VBNRAgreement Number in Sequential Time Ordernvarchar90
46/BEV3/CHBPOSTAgreement Text6VBNRAgreement Number in Sequential Time Ordernvarchar90
47/BEV3/CHBPRZABWAgreement Out-of-Line Percentage6VBNRAgreement Number in Sequential Time Ordernvarchar90
48/BEV3/CHBPRZGRZAgreement Percentage Limits6VBNRAgreement Number in Sequential Time Ordernvarchar90
49/BEV3/CHBREGINFPayer Information Agreement6VBNRAgreement Number in Sequential Time Ordernvarchar90
50/BEV3/CHBRUECKAgreement Breakdown Arrears6VBNRAgreement Number in Sequential Time Ordernvarchar90
51/BEV3/CHBSALEIPayment in Kind Agreement6VBNRAgreement Number in Sequential Time Ordernvarchar90
52/BEV3/CHBSECUREAgreement Collateral6VBNRAgreement Number in Sequential Time Ordernvarchar90
53/BEV3/CHBSICHAgreement Collateral6VBNRAgreement Number in Sequential Time Ordernvarchar90
54/BEV3/CHBSORTAgreement Contract Assortment List6VBNRAgreement Number in Sequential Time Ordernvarchar90
55/BEV3/CHBTERMINAgreement Date6VBNRAgreement Number in Sequential Time Ordernvarchar90
56/BEV3/CHBTMANFOAgreement Date Request6VBNRAgreement Number in Sequential Time Ordernvarchar90
57/BEV3/CHBTMANWEAgreement Date Statement6VBNRAgreement Number in Sequential Time Ordernvarchar90
58/BEV3/CHBTMBDGAgreement Date Condition6VBNRAgreement Number in Sequential Time Ordernvarchar90
59/BEV3/CHBTMBEWFIAgreement Date Valuation FI6VBNRAgreement Number in Sequential Time Ordernvarchar90
60/BEV3/CHBTMBEWSDAgreement Date Valuation SD6VBNRAgreement Number in Sequential Time Ordernvarchar90
61/BEV3/CHBTMBEWVVAgreement Date Valuation CH6VBNRAgreement Number in Sequential Time Ordernvarchar90
62/BEV3/CHBTMFOLGEAgreement Date Sequence6VBNRAgreement Number in Sequential Time Ordernvarchar90
63/BEV3/CHBTMSTATUAgreement Date Status6VBNRAgreement Number in Sequential Time Ordernvarchar90
64/BEV3/CHBTMVKTGAgreement Date Concatenation6VBNRAgreement Number in Sequential Time Ordernvarchar90
65/BEV3/CHBUMSATZAgreement Sales (Actual)6VBNRAgreement Number in Sequential Time Ordernvarchar90
66/BEV3/CHBUMSPAgreement Sales Scale, Percent6VBNRAgreement Number in Sequential Time Ordernvarchar90
67/BEV3/CHBVERREAgreement Clearing6VBNRAgreement Number in Sequential Time Ordernvarchar90
68/BEV3/CHBVORGAgreement Transaction6VBNRAgreement Number in Sequential Time Ordernvarchar90
69/BEV3/CHBVWDNRAgreement deviating CHD number6VBNRAgreement Number in Sequential Time Ordernvarchar90
70/BEV3/CHBWAERAgreement Currency6VBNRAgreement Number in Sequential Time Ordernvarchar90
71/BEV3/CHBZUSCHAgreement Allowance6VBNRAgreement Number in Sequential Time Ordernvarchar90
72/BEV3/CHCA_PROException Handling: log16VBNRAgreement Number in Sequential Time Ordernvarchar90
73/BEV3/CHERGSTZ_PCH Settlement Items - With Translations15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
74/BEV3/CHERGSTZ_SCH Settlement Statistics16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
75/BEV3/CHEXCSTZ_PCH Settlement Items/Non-Posted Docs w/o Date Statistics15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
76/BEV3/CHKABEWSDCustomer Evaluation Table: Dates Valuation SD12VBNRAgreement Number in Sequential Time Ordernvarchar90
77/BEV3/CHKATERMINCustomer Evaluation Table: Dates General10VBNRAgreement Number in Sequential Time Ordernvarchar90
78/BEV3/CHRESSTZ_PCH Settlement Items - Reset Documents (2/Transaction)15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
79/BEV3/CHSHTSTZ_PCH Settlement Item15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
80/BEV3/CHSIMBDMDHCH simulation history of modifications caused by conditions16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
81/BEV3/CHSIMSTZ_PCH Simulation Items15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
82/BEV3/CHSIMSTZ_SCH Simulation Statistics16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
83/BEV3/CHTBTEXTAgreement Text6VBNRAgreement Number in Sequential Time Ordernvarchar90
84/BEV3/CHTMPMDHSTTemp. history of cond. modifications from temp. settle. item16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
85/BEV3/CHTRMSTZ_PCH Date Item15VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
86/BEV3/CHTRMSTZ_SCH Date Statistics16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
87/BEV3/CHVABRSTZSCH Settlement Statistics16VBNRAgreement Number in Seq. Time Order - Contract Callednvarchar90
TOPSAP Healthcare - Industry-Specific Components for Hospitals
88TNWAT_EDI_VERTRIS-H AT: EDIVKA Vereinbarungen Krankenhaus und Versicherung6VBNRIS-H AT: EDIVKA - Vereinbarungsnummernvarchar170