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

85 columns | Print definition?ERP 6.0  | WGRU2

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1ISRWP/800H0105Waren & Sortimentscontrolling: Planungshierarchietabelle6WGRU2Warengruppenhierarchie 2nvarchar180
2/1ISRWP/800H0106Waren & Sortimentscontrolling: Planungshierarchietabelle6WGRU2Warengruppenhierarchie 2nvarchar180
3/1ISRWP/800H0107Waren & Sortimentscontrolling: Planungshierarchietabelle6WGRU2Warengruppenhierarchie 2nvarchar180
4/1ISRWP/800H0110Waren & Sortimentscontrolling: Planungshierarchietabelle6WGRU2Warengruppenhierarchie 2nvarchar180
5/1ISRWP/800H0111Waren & Sortimentscontrolling: Planungshierarchietabelle6WGRU2Warengruppenhierarchie 2nvarchar180
6/1ISRWP/800H0112Waren & Sortimentscontrolling: Planungshierarchietabelle6WGRU2Warengruppenhierarchie 2nvarchar180
7/1ISRWP/800H0113Waren & Sortimentscontrolling: Planungshierarchietabelle6WGRU2Warengruppenhierarchie 2nvarchar180
8/1ISRWP/800H0204MAC: Planning Hierarchy Tables5WGRU2Material group hierarchy 2nvarchar180
9/1ISRWP/800H0205MAC: Planning Hierarchy Tables5WGRU2Material group hierarchy 2nvarchar180
10/1ISRWP/800H0206MAC: Planning Hierarchy Tables5WGRU2Material group hierarchy 2nvarchar180
11/1ISRWP/800H0208MAC: Planning Hierarchy Tables5WGRU2Material group hierarchy 2nvarchar180
12/1ISRWP/800H0209MAC: Planning Hierarchy Tables5WGRU2Material group hierarchy 2nvarchar180
13/1RA/0SD010MIItems for Class SD01 - Raw Data136WGRU2Material group hierarchy 2nvarchar180
14S540ES540 - Structural information5WGRU2Material group hierarchy 2nvarchar180
15S952ES952 - Structural information7WGRU2Material group hierarchy 2nvarchar180
16S955ES955 - Strukturinformationen10WGRU2Warengruppenhierarchie 2nvarchar180
17ZEIM_VBAPSales Document: Item Data197WGRU2Material group hierarchy 2nvarchar180
TOPBilling
18VBRPBilling Document: Item Data158WGRU2Material group hierarchy 2nvarchar180
TOPCross-Application Components
19VVBAPSales Document: Item Data197WGRU2Material group hierarchy 2nvarchar180
TOPData Collection
20S077STRPS: Movements14WGRU2Material group hierarchy 2nvarchar180
21S077ES077 - Structural Information9WGRU2Material group hierarchy 2nvarchar180
22S078STRPS: Stock8WGRU2Material group hierarchy 2nvarchar180
23S078ES078 - Structural Informaton9WGRU2Material group hierarchy 2nvarchar180
24S079STRPS: Movements + Stock14WGRU2Material group hierarchy 2nvarchar180
25S079ES079 - Structural Information9WGRU2Material group hierarchy 2nvarchar180
26S080Purchasing: Movements14WGRU2Material group hierarchy 2nvarchar180
27S080ES080 - Structural Information9WGRU2Material group hierarchy 2nvarchar180
28S081Purchasing: Stock8WGRU2Material group hierarchy 2nvarchar180
29S081ES081 - Structural Information9WGRU2Material group hierarchy 2nvarchar180
30S082Purchasing: Movements + Stock14WGRU2Material group hierarchy 2nvarchar180
31S082ES082 - Structural Information9WGRU2Material group hierarchy 2nvarchar180
32S083Material: Movements11WGRU2Material group hierarchy 2nvarchar180
33S083ES083 - Structural Information6WGRU2Material group hierarchy 2nvarchar180
34S084Material: Stock5WGRU2Material group hierarchy 2nvarchar180
35S084ES084 - Structural Information6WGRU2Material group hierarchy 2nvarchar180
36S085Material: Movements + Stock11WGRU2Material group hierarchy 2nvarchar180
37S085ES085 - Structural Information6WGRU2Material group hierarchy 2nvarchar180
38S086Promotion11WGRU2Material group hierarchy 2nvarchar180
39S086ES086 - Structural Information6WGRU2Material group hierarchy 2nvarchar180
40S105Season: Movements72WGRU2Material group hierarchy 2nvarchar180
41S106Season: Stock34WGRU2Material group hierarchy 2nvarchar180
42S107Season: Movements + Stock107WGRU2Material group hierarchy 2nvarchar180
43S110OTB12WGRU2Material group hierarchy 2nvarchar180
44S110ES110 - Structural Information7WGRU2Material group hierarchy 2nvarchar180
45S123Customer / material group14WGRU2Material group hierarchy 2nvarchar180
46S123ES123 - Structural Information9WGRU2Material group hierarchy 2nvarchar180
47S124Customer / material10WGRU2Material group hierarchy 2nvarchar180
48S124ES124 - Structural Information5WGRU2Material group hierarchy 2nvarchar180
49S200Inventory Controlling Stores38WGRU2Material group hierarchy 2nvarchar180
50S540Reference Structure for Generating Info Structures10WGRU2Material group hierarchy 2nvarchar180
51S952Reference Structure for Generating Info Structures12WGRU2Material group hierarchy 2nvarchar180
52S955Istdatenspeicher MAP - BW15WGRU2Warengruppenhierarchie 2nvarchar180
53S958Reference Structure for Generating Info Structures27WGRU2Material group hierarchy 2nvarchar180
TOPMerchandise and Assortment Planning
54S202MAP: Merchandise Planning Structure7WGRU2Material group hierarchy 2nvarchar180
55S202ES202 - Structural Information7WGRU2Material group hierarchy 2nvarchar180
56S203MAP: Merchandise Planning Stock6WGRU2Material group hierarchy 2nvarchar180
57S203ES203 - Structural Information7WGRU2Material group hierarchy 2nvarchar180
58S204MAP: Merchandise Planning Movements7WGRU2Material group hierarchy 2nvarchar180
59S204ES204 - Structural Information7WGRU2Material group hierarchy 2nvarchar180
60S208MAP: Assortment Planning24WGRU2Material group hierarchy 2nvarchar180
61S209MAP: OTB Movements7WGRU2Material group hierarchy 2nvarchar180
62S209ES209 - Structural Information7WGRU2Material group hierarchy 2nvarchar180
63S210MAP: OTB Stock6WGRU2Material group hierarchy 2nvarchar180
64S210ES210 - Structural Information7WGRU2Material group hierarchy 2nvarchar180
65S211MAP: OTB Evaluation Structure7WGRU2Material group hierarchy 2nvarchar180
66S211ES211 - Structural Information7WGRU2Material group hierarchy 2nvarchar180
67S216MAP: Average Retail WOC3WGRU2Material group hierarchy 2nvarchar180
68S216ES216 - Structural Information3WGRU2Material group hierarchy 2nvarchar180
69S217MAP: AvgRetail MON3WGRU2Material group hierarchy 2nvarchar180
70S217ES217 - Structural Information3WGRU2Material group hierarchy 2nvarchar180
71S218MAP: AvgRetail BUP3WGRU2Material group hierarchy 2nvarchar180
72S218ES218 - Structural Information3WGRU2Material group hierarchy 2nvarchar180
73TWISPA_AVERAGERTMerchandise and Assortment Planning: Average Retail2WGRU2Material group hierarchy 2nvarchar180
74TWISPA_AVGRETMerchandise and Assortment Planning: Average Retail2WGRU2Material group hierarchy 2nvarchar180
75TWISPC_ASORTZAssignment of Store Groups to Assortments4WGRU2Material group hierarchy 2nvarchar180
76TWISPC_FILGRPZAssignment of Stores to Store Groups3WGRU2Material group hierarchy 2nvarchar180
TOPProfitability Analysis
77CE1R300Operating Concern IDES61WGRU2Material group hierarchy 2nvarchar180
78CE2R300Operating Concern IDES45WGRU2Material group hierarchy 2nvarchar180
79CE4R300Operating Concern IDES30WGRU2Material group hierarchy 2nvarchar180
80CE4R300_ACCTErgebnisbereich IDES31WGRU2Warengruppenhierarchie 2nvarchar180
81CE4R300_FLAGErgebnisbereich IDES27WGRU2Flag: Merkmal manuell oder über TKEZU kontiertnvarchar10
82CE4R300_KENCOperating Concern IDES29WGRU2Material group hierarchy 2nvarchar180
TOPRemaining Beverage - Obsolete Objects
83/BEV1/RBVBAPSales Document: Item Data197WGRU2Material group hierarchy 2nvarchar180
TOPSales
84VBAPSales Document: Item Data197WGRU2Material group hierarchy 2nvarchar180
TOPSimulation
85VSVBAP_CNVersion: Sales document: Item data198WGRU2Material group hierarchy 2nvarchar180