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

212 columns | Print definition?ERP 6.0  | STWAE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000176000PSA for 2LIS_11_VAHDR T90CLNT090 Sales Doc. Header33STWAEnvarchar50
2/BIC/B0000177000PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item20STWAEnvarchar50
3/BIC/B0000178000PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item30STWAEnvarchar50
4/BIC/B0000179000PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule43STWAEnvarchar50
5/BIC/B0000180000PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.33STWAEnvarchar50
6/BIC/B0000181000PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.24STWAEnvarchar50
7/BIC/B0000184000PSA for 2LIS_13_VDHDR T90CLNT090 Bill.Doc.Header Data28STWAEnvarchar50
8/BIC/B0000185000PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item20STWAEnvarchar50
9/BIC/B0000186000PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.19STWAEnvarchar50
10CMM_MTM_POMtM per Purchase Order46STWAEStatistics currencynvarchar50
11CMM_MTM_SOMtM per Sales Order43STWAEStatistics currencynvarchar50
12S521ES521 - Strukturinformationen10STWAEStatistikwährungnvarchar50
13S523LIS:CopyMan-Autom.Anreicherung17STWAEStatistikwährungnvarchar50
14S523ES523 - Strukturinformationen10STWAEStatistikwährungnvarchar50
15S530ES530 - Structural information10STWAEStatistics currencynvarchar50
16S531ES531 - Structural information10STWAEStatistics currencynvarchar50
17S532ES532 - Structural information8STWAEStatistics currencynvarchar50
18S620ES620 - Strukturinformationen9STWAEStatistikwährungnvarchar50
19S621ES621 - Strukturinformationen9STWAEStatistikwährungnvarchar50
20S622ES622 - Structure Information9STWAEStatistics currencynvarchar50
21S623ES623 - Strukturinformationen9STWAEStatistikwährungnvarchar50
22S624ES624 - Strukturinformationen9STWAEStatistikwährungnvarchar50
23S625ES625 - Strukturinformationen9STWAEStatistikwährungnvarchar50
24S626ES626 - Structural information8STWAEStatistics currencynvarchar50
25S628BIW1S628BIW1 * APO Demand17STWAEStatistics currencynvarchar50
26S628BIW2S628BIW2 * APO Demand17STWAEStatistics currencynvarchar50
27S628ES628 - Strukturinformationen10STWAEStatistikwährungnvarchar50
28S630ES630 - Strukturinformationen9STWAEStatistikwährungnvarchar50
29S631ES631 - Strukturinformationen9STWAEStatistikwährungnvarchar50
30S632ES632 - Strukturinformationen9STWAEStatistikwährungnvarchar50
31S633ES633 - Strukturinformationen9STWAEStatistikwährungnvarchar50
32S634ES634 - Strukturinformationen9STWAEStatistikwährungnvarchar50
33S635ES635 - Strukturinformationen9STWAEStatistikwährungnvarchar50
34S636ES636 - Strukturinformationen9STWAEStatistikwährungnvarchar50
35S637ES637 - Strukturinformationen9STWAEStatistikwährungnvarchar50
36S638ES638 - Strukturinformationen9STWAEStatistikwährungnvarchar50
37S639ES639 - Strukturinformationen9STWAEStatistikwährungnvarchar50
38S640ES640 - Strukturinformationen9STWAEStatistikwährungnvarchar50
39S641ES641 - Strukturinformationen9STWAEStatistikwährungnvarchar50
40S642ES642 - Strukturinformationen9STWAEStatistikwährungnvarchar50
41S643ES643 - Strukturinformationen9STWAEStatistikwährungnvarchar50
42S644ES644 - Strukturinformationen9STWAEStatistikwährungnvarchar50
43S645ES645 - Strukturinformationen9STWAEStatistikwährungnvarchar50
44S646ES646 - Strukturinformationen9STWAEStatistikwährungnvarchar50
45S647ES647 - Strukturinformationen9STWAEStatistikwährungnvarchar50
46S648ES648 - Strukturinformationen9STWAEStatistikwährungnvarchar50
47S649ES649 - Strukturinformationen9STWAEStatistikwährungnvarchar50
48S990Smoby: hiérarchie client17STWAEDevise statistiquenvarchar50
49S990ES990 - Info structurelles10STWAEDevise statistiquenvarchar50
50S991ES991 - Info structurelles9STWAEDevise statistiquenvarchar50
51S992Client/famille/article16STWAEDevise statistiquenvarchar50
52S992ES992 - Info structurelles9STWAEDevise statistiquenvarchar50
53S997Danone13STWAEStatistics currencynvarchar50
54S997ES997 - Structural information6STWAEStatistics currencynvarchar50
55S998ES998 - Info structurelles8STWAEDevise statistiquenvarchar50
56S999Copy of S628 for APO Pump Demo17STWAEStatistics currencynvarchar50
57S999ES999 - Structural information10STWAEStatistics currencynvarchar50
58T399JMaintenance parameters (client)7STWAEStatistics currencynvarchar50
59WB2B_CMM_MTM_TCMtM per Trading Contract53STWAEStatistics currencynvarchar50
60ZCMM_MTM_01MtM Persistency per Transaction53STWAEStatistics currencynvarchar50
61ZCMM_MTM_TCMtM per TC52STWAEStatistics currencynvarchar50
62ZEIM_VBAKSales Document: Header Data51STWAEStatistics currencynvarchar50
TOPAdvertising Management
63JHAKIS-M/AM: Order-Publishing-Media (Header Data)23STWAEStatistics currencynvarchar50
64JHTFKIS-M/AM: Settlement Documents (Billing, Commission) - Header80STWAEStatistics currencynvarchar50
65S481IS-M/AM: View of BP Sales Areas19STWAEStatistics currencynvarchar50
66S481ES481 - Structural Information12STWAEStatistics currencynvarchar50
67S483IS-M/AM: Agent Assignment19STWAEStatistics currencynvarchar50
68S483ES483 - Structural Information12STWAEStatistics currencynvarchar50
TOPBilling
69S071Condition Update12STWAEStatistics currencynvarchar50
70VBRKBilling Document: Header Data55STWAEStatistics currencynvarchar50
TOPCross-Application Components
71VVBAKSales Document: Header Data51STWAEStatistics currencynvarchar50
TOPData Collection
72S001SIS: Customer Statistics15STWAEStatistics currencynvarchar50
73S001BIW1S001BIW1 * SIS: Customer Statistics15STWAEStatistics currencynvarchar50
74S001BIW2S001BIW2 * SIS: Customer statistics15STWAEStatistics currencynvarchar50
75S001ES001 - Structural Information8STWAEStatistics currencynvarchar50
76S002SIS: Sales Office Statistics15STWAEStatistics currencynvarchar50
77S002BIW1S002BIW1 * SIS: Sales office statistics15STWAEStatistics currencynvarchar50
78S002BIW2S002BIW2 * SIS: Sales office statistics15STWAEStatistics currencynvarchar50
79S002ES002 - Structural Information8STWAEStatistics currencynvarchar50
80S003SIS: SalesOrg/DistCh/Division/District/Customer/Product16STWAEStatistics currencynvarchar50
81S003BIW1S003BIW1 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro16STWAEStatistics currencynvarchar50
82S003BIW2S003BIW2 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro16STWAEStatistics currencynvarchar50
83S003ES003 - Structural Information9STWAEStatistics currencynvarchar50
84S004SIS: Product/Sales Organization/Distribution Channel13STWAEStatistics currencynvarchar50
85S004BIW1SIS: Product/Sales Organization/Distribution Channel13STWAEStatistics currencynvarchar50
86S004BIW2SIS: Product/Sales Organization/Distribution Channel13STWAEStatistics currencynvarchar50
87S004ES004 - Structural Information6STWAEStatistics currencynvarchar50
88S006SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product16STWAEStatistics currencynvarchar50
89S006BIW1S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/16STWAEStatistics currencynvarchar50
90S006BIW2S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/16STWAEStatistics currencynvarchar50
91S006ES006 - Structural Information9STWAEStatistics currencynvarchar50
92S014CAS Document Information15STWAEStatistics currencynvarchar50
93S060Model Structure for Info Structures with Initial VAKEY12STWAELocal Currencynvarchar50
94S126Open Variants - Basis 114STWAEStatistics currencynvarchar50
95S126ES126 - Structural information5STWAEStatistics currencynvarchar50
96S127Open Variants - Basis 216STWAEStatistics currencynvarchar50
97S127ES127 - Structural information7STWAEStatistics currencynvarchar50
98S128Open Variants - SIS20STWAEStatistics currencynvarchar50
99S128ES128 - Structural information13STWAEStatistics currencynvarchar50
100S129Open Variants - Planning16STWAEStatistics currencynvarchar50
101S129ES129 - Structural information9STWAEStatistics currencynvarchar50
102S137Variants: Basis 216STWAEStatistics currencynvarchar50
103S137ES137 -Structural Information9STWAEStatistics currencynvarchar50
104S138Variants: SIS & planning19STWAEStatistics currencynvarchar50
105S138ES138 - Structural Information12STWAEStatistics currencynvarchar50
106S181Free Goods Values12STWAEStatistics currencynvarchar50
107S181ES181 - Structural information5STWAEStatistics currencynvarchar50
108S260SD - Sales order15STWAEStatistics currencynvarchar50
109S260BIW1SD - Sales order15STWAEStatistics currencynvarchar50
110S260BIW2SD - Sales order15STWAEStatistics currencynvarchar50
111S262SD - Billing document13STWAEStatistics currencynvarchar50
112S262BIW1SD - Billing document13STWAEStatistics currencynvarchar50
113S262BIW2SD - Billing document13STWAEStatistics currencynvarchar50
114S263SD - Sales order/delivery note28STWAEStatistics currencynvarchar50
115S263BIW1SD - Sales order/delivery note28STWAEStatistics currencynvarchar50
116S263BIW2SD - Sales order/delivery note28STWAEStatistics currencynvarchar50
117S264SD- Offer15STWAEStatistics currencynvarchar50
118S264BIW1S264BIW1 * SD - Quotation15STWAEStatistics currencynvarchar50
119S264BIW2S264BIW2 * SD - Quotation15STWAEStatistics currencynvarchar50
120S409Contract & Billing17STWAEStatistics currencynvarchar50
121S409ES409 - Structure Information10STWAEStatistics currencynvarchar50
122S521Test17STWAEStatistics currencynvarchar50
123S530LO630 Unit 02 Solution17STWAEStatistics currencynvarchar50
124S531LO630 Solution Unit0617STWAEStatistics currencynvarchar50
125S532LO630 Solution Unit 0815STWAEStatistics currencynvarchar50
126S620IDES Data Generation16STWAEStatistics currencynvarchar50
127S621Sales and Production16STWAEStatistics currencynvarchar50
128S622SOP Level-by-Level16STWAEStatistics currencynvarchar50
129S623SOP Variable Time Frames16STWAEStatistics currencynvarchar50
130S624SOP Instructor16STWAEStatistics currencynvarchar50
131S625SOP Instructor16STWAEStatistics currencynvarchar50
132S626LO935: SOP without plant15STWAEStatistics currencynvarchar50
133S628APO Demand17STWAEStatistics currencynvarchar50
134S630LO935 Group 0016STWAEStatistics currencynvarchar50
135S631LO935 Group 0116STWAEStatistics currencynvarchar50
136S632LO935 Group 0216STWAEStatistics currencynvarchar50
137S633LO935 Group 0316STWAEStatistics currencynvarchar50
138S634LO935 Group 0416STWAEStatistics currencynvarchar50
139S635LO935 Group 0516STWAEStatistics currencynvarchar50
140S636LO935 Group 0616STWAEStatistics currencynvarchar50
141S637LO935 Group 0716STWAEStatistics currencynvarchar50
142S638LO935 Group 0816STWAEStatistics currencynvarchar50
143S639LO935 Group 0916STWAEStatistics currencynvarchar50
144S640LO935 Group 1016STWAEStatistics currencynvarchar50
145S641LO935 Group 1116STWAEStatistics currencynvarchar50
146S642LO935 Group 1216STWAEStatistics currencynvarchar50
147S643LO935 Group 1316STWAEStatistics currencynvarchar50
148S644LO935 Group 1416STWAEStatistics currencynvarchar50
149S645LO935 Group 1516STWAEStatistics currencynvarchar50
150S646LO935 Group 1616STWAEStatistics currencynvarchar50
151S647LO935 Group 1716STWAEStatistics currencynvarchar50
152S648LO935 Group 1816STWAEStatistics currencynvarchar50
153S649LO935 Group 1916STWAEStatistics currencynvarchar50
154S921Market Analysis Raw Data15STWAEStatistics currencynvarchar50
155S921ES921 - Structural information8STWAEStatistics currencynvarchar50
156S922Market Analysis14STWAEStatistics currencynvarchar50
157S922ES922 - Structural information7STWAEStatistics currencynvarchar50
158S923Market Analysis Aggregated12STWAEStatistics currencynvarchar50
159S923ES923 - Structural information5STWAEStatistics currencynvarchar50
160S991Hiérarchie client / Produit16STWAEDevise statistiquenvarchar50
161S998SMOBY15STWAEDevise statistiquenvarchar50
TOPDistributor-Reseller-Management
162S496DRM: MS Side Business Metrics17STWAEStatistics currencynvarchar50
163S496ES496 - Structural information10STWAEStatistics currencynvarchar50
164S497DRM: DR Side Business Metrics17STWAEStatistics currencynvarchar50
165S497ES497 - Structural information10STWAEStatistics currencynvarchar50
166S498DRM: Sellin Business Metrics15STWAEStatistics currencynvarchar50
167S498ES498 - Structural information8STWAEStatistics currencynvarchar50
TOPDownstream
168S410BIW1S410BIW1 * SIS: Business Location Statistics via 'Ship-to' (16STWAEStatistics currencynvarchar50
169S410BIW2S410BIW2 * SIS: Business Location Statistics via 'Ship-to' (16STWAEStatistics currencynvarchar50
TOPExtended Rebate
170S469Erweiterte Bonusabrechnung13STWAEStatistiekvalutanvarchar50
171S469ES469 - Strukturinformationen5STWAEStatistiekvalutanvarchar50
TOPInformation System
172MCVSRFKStatistically Relevant Fields for Order + Delivery Header3STWAEStatistics currencynvarchar50
173S020SIS: Customer Potential Analysis17STWAEStatistics currencynvarchar50
174S020ES020 - Structure Information10STWAEStatistics currencynvarchar50
TOPMarketing Retail Network
175S410SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR16STWAEStatistics currencynvarchar50
176S410ES410 - Structural Information9STWAEStatistics currencynvarchar50
TOPPeriodical Sales and Distribution
177JFRKIS-M/SD: Billing - Header Data45STWAEStatistics currencynvarchar50
178JKAKSales Order Header Data33STWAEStatistics currencynvarchar50
179JLRKIS-M/SD: Settlement Header Data29STWAEStatistics currencynvarchar50
180JVTZAEM2Sales Order Header Data35STWAEStatistics currencynvarchar50
181S450IS-M/SD: Customer Statistics17STWAEStatistics currencynvarchar50
182S450ES450 - Structural Data10STWAEStatistics currencynvarchar50
183S451IS-M/SD: Sales Office Statistics18STWAEStatistics currencynvarchar50
184S451ES451 - Structural Data11STWAEStatistics currencynvarchar50
185S452IS-M/SD: Product Statistics16STWAEStatistics currencynvarchar50
186S452ES452 - Structural Data9STWAEStatistics currencynvarchar50
187S454IS-M/SD: Sales Agents17STWAEStatistics currencynvarchar50
188S454ES454 - Structural Data10STWAEStatistics currencynvarchar50
189S455IS-M/SD: Promotion Statistics17STWAEStatistics currencynvarchar50
190S455ES455 - Structural Data10STWAEStatistics currencynvarchar50
191S456IS-M/SD: AR Category Statistics16STWAEStatistics currencynvarchar50
192S456ES456 - Structural Data9STWAEStatistics currencynvarchar50
193S457IS-M/SD: Carrier Route Statistics15STWAEStatistics currencynvarchar50
194S457ES457 - Structural Data8STWAEStatistics currencynvarchar50
TOPProduction and Revenue Accounting
195OIUCM_CONTRACTPRA Contracts30STWAEStatistics currencynvarchar50
TOPRemaining Beverage - Obsolete Objects
196/BEV1/RBBOCustomer Master Data Rebate Processing13STWAELocal Currencynvarchar50
197/BEV1/RBPAIntermediate Table (Material-Specific Contrib. Margin Acc.)13STWAELocal Currencynvarchar50
198/BEV1/RBVBAKSales Document: Header Data51STWAEStatistics currencynvarchar50
199S467Indirect Order Update15STWAEStatistics currencynvarchar50
200S467ES467 - Structure Information8STWAEStatistics currencynvarchar50
TOPReporting
201MCIPMISPMIS: Master data characteristics for PMIS before image3STWAEStatistics currencynvarchar50
202S065Object statistics14STWAEStatistics currencynvarchar50
203S065ES065 - Structural Information7STWAEStatistics currencynvarchar50
TOPSales
204VBAKSales Document: Header Data51STWAEStatistics currencynvarchar50
TOPSales Plan
205T445APlanning Configuration for Info Structure19STWAEStatistics currencynvarchar50
TOPService Station Retailing
206S412SSR Margin Report13STWAEStatistics currencynvarchar50
207S412ES412 - Structural information6STWAEStatistics currencynvarchar50
208S413SSR - Monthly/Daily Loc.Inv.12STWAEStatistics currencynvarchar50
209S413ES413 - Structural information5STWAEStatistics currencynvarchar50
TOPShipping
210LIKPSD Document: Delivery Header Data59STWAEStatistics currencynvarchar50
TOPSimulation
211VSVBAK_CNVersion: Sales document: Header data52STWAEStatistics currencynvarchar50
TOPTraders and Schedulers Workbench
212S430SIS: (OIL-TSW) Sales document statistics by TSW object10STWAEStatistics currencynvarchar50