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

82 columns | Print definition?ERP 6.0  | PRODH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1CADMC/00000468T1795PRODHnvarchar180
2/1CADMC/00000469T179T6PRODHnvarchar180
3/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item45PRODHnvarchar180
4/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item82PRODHnvarchar180
5/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule76PRODHnvarchar180
6/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.55PRODHnvarchar180
7/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.51PRODHnvarchar180
8/BIC/B0000183000PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item72PRODHnvarchar180
9/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item75PRODHnvarchar180
10/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.55PRODHnvarchar180
11/SMD/MD_____00BZSID-Tabelle fuer Product hierarchy3PRODHProduct hierarchynvarchar180
12/SMD/MD_____00Y5SID-Tabelle fuer Product hierarchy3PRODHProduct hierarchynvarchar180
13S628BIW1S628BIW1 * APO Demand12PRODHProduct hierarchynvarchar180
14S628BIW2S628BIW2 * APO Demand12PRODHProduct hierarchynvarchar180
15S628ES628 - Strukturinformationen7PRODHProdukthierarchienvarchar180
16S999Copy of S628 for APO Pump Demo12PRODHProduct hierarchynvarchar180
17S999ES999 - Structural information7PRODHProduct hierarchynvarchar180
18ZEIM_LIPSSD document: Delivery: Item data16PRODHProduct hierarchynvarchar180
19ZEIM_VBAPSales Document: Item Data17PRODHProduct hierarchynvarchar180
TOPAdvertising Management
20JHAMOTIS-M/AM: Ad Spec69PRODHIS-M/AM: Product Hierarchynvarchar180
21JHAMOTOIS-M/AM: Online Ad Spec15PRODHIS-M/AM: Product Hierarchynvarchar180
22JHAMOTWIS-M/AM: OPM Ad Spec (Commercial)14PRODHIS-M/AM: Product Hierarchynvarchar180
23JHAPAIS-M/AM: Order-Publishing-Media Ad Item61PRODHIS-M/AM: Product Hierarchynvarchar180
24JHAPDIS-M/AM: OPM Service Item36PRODHIS-M/AM: Product Hierarchynvarchar180
25JHAPPOrder-Publishing-Media Package Item6PRODHIS-M/AM: Product Hierarchynvarchar180
26JHAPSIS-M/AM: OPM Ad Insert Item65PRODHIS-M/AM: Product Hierarchynvarchar180
27JHAPVIS-M/AM: OPM Distribution Item54PRODHIS-M/AM: Product Hierarchynvarchar180
28JHAREV1IS-M/AM: Order Revenue Recognition Key Date Values54PRODHIS-M/AM: Product Hierarchynvarchar180
29JHAREV3IS-M/AM: Order Revenue Recognition Key Date Quantities51PRODHIS-M/AM: Product Hierarchynvarchar180
30JHFREV2IS-M/AM: Key Dates for Billing Document Revenue Recognition59PRODHIS-M/AM: Product Hierarchynvarchar180
31JHFREV4IS-M/AM: Billing Document Revenue Recognition Key Date Qties56PRODHIS-M/AM: Product Hierarchynvarchar180
32JHTFPIS-M/AM: Billing/Settlement Documents - Item68PRODHIS-M/AM: Product Hierarchynvarchar180
33JHTVABRUFIS-M/AM: Contract Access10PRODHIS-M/AM: Product Hierarchynvarchar180
34JHTVBPOIS-M/AM: Contract Requirement Element27PRODHIS-M/AM: Product Hierarchynvarchar180
35JJCPRESPONSIBIS-M: Responsibility in Contact Person Relationship9PRODHIS-M/AM: Product Hierarchynvarchar180
36JJT179IS-M/AM: Product Hierarchy2PRODHIS-M/AM: Product Hierarchynvarchar180
37JJT179TMaterials: Product Hierarchies: Texts3PRODHIS-M/AM: Product Hierarchynvarchar180
38JJTAZIS-M/AM: Media Contact Person Responsibility9PRODHIS-M/AM: Product Hierarchynvarchar180
39JJTKONZUIS-M/AM: Sales Activity Assignments6PRODHIS-M/AM: Product Hierarchynvarchar180
40JJTPHIS-M/AM: BP Product Hierarchy Assignment3PRODHIS-M/AM: Product Hierarchynvarchar180
41TJJKAMPIS-M/AM: Campaign (Customer)8PRODHIS-M/AM: Product Hierarchynvarchar180
TOPBasic Functions
42T179TMaterials: Product hierarchies: Texts3PRODHProduct hierarchynvarchar180
TOPBilling
43VBRPBilling Document: Item Data38PRODHProduct hierarchynvarchar180
TOPConditions
44KOTE999Sales org./Distr. Chl/Customer/Prod.hier.7PRODHProduct hierarchynvarchar180
TOPCross-Application Components
45VVBAPSales Document: Item Data17PRODHProduct hierarchynvarchar180
TOPData Collection
46S125Forecast history for ex. system14PRODHProduct hierarchynvarchar180
47S125ES125 - Structural information9PRODHProduct hierarchynvarchar180
48S260SD - Sales order36PRODHProduct hierarchynvarchar180
49S260BIW1SD - Sales order36PRODHProduct hierarchynvarchar180
50S260BIW2SD - Sales order36PRODHProduct hierarchynvarchar180
51S261SD - Delivery note53PRODHProduct hierarchynvarchar180
52S261BIW1SD - Delivery note53PRODHProduct hierarchynvarchar180
53S261BIW2SD - Delivery note53PRODHProduct hierarchynvarchar180
54S262SD - Billing document41PRODHProduct hierarchynvarchar180
55S262BIW1SD - Billing document41PRODHProduct hierarchynvarchar180
56S262BIW2SD - Billing document41PRODHProduct hierarchynvarchar180
57S263SD - Sales order/delivery note32PRODHProduct hierarchynvarchar180
58S263BIW1SD - Sales order/delivery note32PRODHProduct hierarchynvarchar180
59S263BIW2SD - Sales order/delivery note32PRODHProduct hierarchynvarchar180
60S264SD- Offer38PRODHProduct hierarchynvarchar180
61S264BIW1S264BIW1 * SD - Quotation38PRODHProduct hierarchynvarchar180
62S264BIW2S264BIW2 * SD - Quotation38PRODHProduct hierarchynvarchar180
63S628APO Demand12PRODHProduct hierarchynvarchar180
TOPData Retention Tool
64TXW_S_VBAPRetrieve VBAP from archive10PRODHProduct hierarchynvarchar180
65TXW_S_VBRPRetrieve VBRP from archive43PRODHProduct hierarchynvarchar180
TOPIntegration
66FKK_VBRP_SHORTItem Data for SD Billing Document - Extracts39PRODHProduct hierarchynvarchar180
TOPLogistics - General
67WBHITrading Contract: Item Data38PRODHProduct hierarchynvarchar180
TOPMarketing, Accounting and Pricing
68A420SalesOrg/DistCh/CustGrp/ProdHier/PricDRC8PRODHProduct hierarchynvarchar180
69A421SalesOrg/DistCh/CustGrp/Plant/ProdHier/PricDRC9PRODHProduct hierarchynvarchar180
70A428SalesOrg/DistChann/CustGrp/DRCMetrInd/ProdHier8PRODHProduct hierarchynvarchar180
TOPMaterial Maintenance
71T179Materials: Product Hierarchies2PRODHProduct hierarchynvarchar180
TOPMaterial Master
72MVKESales Data for Material20PRODHProduct hierarchynvarchar180
73MVKE_TMPFile for Incorrect Data in Direct Input23PRODHProduct hierarchynvarchar180
74MVVESales Data for Material20PRODHProduct hierarchynvarchar180
TOPRecycling Administration Core Functions
75J_7LC06REA Data Filter: Product Hierarchies3PRODHProduct hierarchynvarchar180
76J_7LVBRPOSNON-SD Interface: Billing: Item Data12PRODHProduct hierarchynvarchar180
TOPRemaining Beverage - Obsolete Objects
77/BEV1/RBVBAPSales Document: Item Data17PRODHProduct hierarchynvarchar180
TOPResourcen Management
78RMXTT_PRODHTrial: Assignment of Product <-> Product Hierarchy2PRODHProduct hierarchynvarchar180
TOPSales
79VBAPSales Document: Item Data17PRODHProduct hierarchynvarchar180
80VBSPSD Document Item for Models of Material Structures10PRODHProduct hierarchynvarchar180
TOPShipping
81LIPSSD document: Delivery: Item data16PRODHProduct hierarchynvarchar180
TOPSimulation
82VSVBAP_CNVersion: Sales document: Item data18PRODHProduct hierarchynvarchar180