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

92 columns | Print definition?ERP 6.0  | SAISO

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1ISRWP/800H0101Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
2/1ISRWP/800H0102Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
3/1ISRWP/800H0103Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
4/1ISRWP/800H0104Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
5/1ISRWP/800H0105Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
6/1ISRWP/800H0106Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
7/1ISRWP/800H0107Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
8/1ISRWP/800H0108Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
9/1ISRWP/800H0109Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
10/1ISRWP/800H0110Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
11/1ISRWP/800H0111Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
12/1ISRWP/800H0112Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
13/1ISRWP/800H0113Waren & Sortimentscontrolling: Planungshierarchietabelle2SAISOSaisontypnvarchar40
14/SMERP/STG_MM001Data staging - Material master plant view complex table46SAISOSeason Categorynvarchar40
15/SMERP/STG_MM002Data staging - Material storage location view complex table46SAISOSeason Categorynvarchar40
16/SMERP/STG_MM003Data staging - Material UoM view complex table47SAISOSeason Categorynvarchar40
17/SMERP/STG_MM004Data staging - Material warehouse view complex table46SAISOSeason Categorynvarchar40
18/SMERP/STG_MM005Data staging - Material batch view complex table46SAISOSeason Categorynvarchar40
19S952ES952 - Structural information3SAISOSeason Categorynvarchar40
20S957ES957 - Structural information3SAISOSeason Categorynvarchar40
21S958ES958 - Structural information3SAISOSeason Categorynvarchar40
22ZEIMMARAUSING FOR STORING EIM MARA DATAS47SAISOSeason Categorynvarchar40
TOPAssortment
23WRFT_APC_GENOperational APC: General Customizing20SAISODefault Season Category for Transfer from LWB to OAPCnvarchar40
24WRF_APC_IBIDPurchasing List Inbound Interface Detailed Totals4SAISOSeason Categorynvarchar40
25WRF_APC_IBITPurchasing List Inbound Interface Totals4SAISOSeason Categorynvarchar40
26WRF_APC_MPAMarkdown Profile Assignment10SAISOSeason Categorynvarchar40
27WRF_APC_PLHPurchasing List Header Data5SAISOSeason Categorynvarchar40
TOPAssortment Maintenance
28T6WSPCheck Table for Season Indicator2SAISOSeason Categorynvarchar40
29T6WSTTexts to describe season indicators2SAISOSeason Categorynvarchar40
30TWSAI(Annual) Seasons2SAISOSeason Categorynvarchar40
31TWSAJAnnual seasons (distribution chain-specific)2SAISOSeason Categorynvarchar40
32WSOJOBMAPMAP: Temporary Listing Table from Planning6SAISOSeason Categorynvarchar40
TOPCross-Application Components
33MMARAGeneral material data47SAISOSeason Categorynvarchar40
TOPData Collection
34S083Material: Movements14SAISOSeason Categorynvarchar40
35S083ES083 - Structural Information9SAISOSeason Categorynvarchar40
36S084Material: Stock8SAISOSeason Categorynvarchar40
37S084ES084 - Structural Information9SAISOSeason Categorynvarchar40
38S085Material: Movements + Stock14SAISOSeason Categorynvarchar40
39S085ES085 - Structural Information9SAISOSeason Categorynvarchar40
40S105Season: Movements15SAISOSeason Categorynvarchar40
41S105ES105 - Structural Information10SAISOSeason Categorynvarchar40
42S106Season: Stock9SAISOSeason Categorynvarchar40
43S106ES106 - Structural Information10SAISOSeason Categorynvarchar40
44S107Season: Movements + Stock15SAISOSeason Categorynvarchar40
45S107ES107 - Structural Information10SAISOSeason Categorynvarchar40
46S110OTB8SAISOSeason Categorynvarchar40
47S110ES110 - Structural Information3SAISOSeason Categorynvarchar40
48S117Receipt/article25SAISOSeason Categorynvarchar40
49S124Customer / material13SAISOSeason Categorynvarchar40
50S124ES124 - Structural Information8SAISOSeason Categorynvarchar40
51S952Reference Structure for Generating Info Structures8SAISOSeason Categorynvarchar40
52S953BW Vorl.für BON/Artikel S11725SAISOSaisontypnvarchar40
53S957Reference Structure for Generating Info Structures8SAISOSeason Categorynvarchar40
54S958Reference Structure for Generating Info Structures8SAISOSeason Categorynvarchar40
TOPInventory Management
55MWXVM07MFields: Update Control of Module Pool SAPMM07M130SAISOSeason Categorynvarchar40
56MWZVM07MFields: Update Control of Module Pool SAPMM07M130SAISOSeason Categorynvarchar40
TOPMaterial Master
57MARAGeneral Material Data47SAISOSeason Categorynvarchar40
58MARA_TMPFile for Incorrect Data in Direct Input54SAISOSeason Categorynvarchar40
59MVRACross-version fields for MARA47SAISOSeason Categorynvarchar40
60WRF_DISCONT_POSWorklist Items: Discontinuation for Seasonal Procurement17SAISOSeason Categorynvarchar40
61WSTN_AL_LINKRelation between alloc table created and generic article4SAISOSeason Categorynvarchar40
62WSTN_CTL_POSTPrepack creation and allocation - posting control4SAISOSeason Categorynvarchar40
TOPMerchandise and Assortment Planning
63S202MAP: Merchandise Planning Structure3SAISOSeason Categorynvarchar40
64S202ES202 - Structural Information3SAISOSeason Categorynvarchar40
65S203MAP: Merchandise Planning Stock2SAISOSeason Categorynvarchar40
66S203ES203 - Structural Information3SAISOSeason Categorynvarchar40
67S204MAP: Merchandise Planning Movements3SAISOSeason Categorynvarchar40
68S204ES204 - Structural Information3SAISOSeason Categorynvarchar40
69S206MAP: Store Planning Stocks2SAISOSeason Categorynvarchar40
70S206ES206 - Structural Information3SAISOSeason Categorynvarchar40
71S207MAP: Store Planning Structure3SAISOSeason Categorynvarchar40
72S207ES207 - Structural Information3SAISOSeason Categorynvarchar40
73S208MAP: Assortment Planning3SAISOSeason Categorynvarchar40
74S208ES208 - Structural Information3SAISOSeason Categorynvarchar40
75S209MAP: OTB Movements3SAISOSeason Categorynvarchar40
76S209ES209 - Structural Information3SAISOSeason Categorynvarchar40
77S210MAP: OTB Stock2SAISOSeason Categorynvarchar40
78S210ES210 - Structural Information3SAISOSeason Categorynvarchar40
79S211MAP: OTB Evaluation Structure3SAISOSeason Categorynvarchar40
80S211ES211 - Structural Information3SAISOSeason Categorynvarchar40
81TWISPC_MARARetail Planning: Materials for Provisional Planning10SAISOSeason Categorynvarchar40
82TWISPC_SAISORetail Planning: Assign. Posting Periods to Season Cat./Year2SAISOSeason Categorynvarchar40
TOPPrice Planning Workbench
83WRF_PPW_PPDARTPPD Material Item17SAISOSeasonnvarchar60
TOPPromotion
84WAKRPromotion Discounts18SAISOSeason Categorynvarchar40
85WMFPMarkdown Planning - item data (materials)14SAISOSeason Categorynvarchar40
86WSAHWorklist Season wind-up - header2SAISOSeason Categorynvarchar40
TOPPurchasing
87EKPOPurchasing Document Item138SAISOSeason Categorynvarchar40
88WRF_POHF_POLOrder list30SAISOSeason Categorynvarchar40
TOPReporting
89S205MAP: Store Planning Movements3SAISOSeason Categorynvarchar40
90S205ES205 - Structure Information3SAISOSeason Categorynvarchar40
TOPSales Plan
91T445QPrices for Price Band Categories5SAISOSeason Categorynvarchar40
92T445QKPrices for Price Band Categories (Key)5SAISOSeason Categorynvarchar40