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

75 columns | Print definition?ERP 6.0  | UMNETWR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1S523LIS:CopyMan-Autom.Anreicherung20UMNETWRUmsatz Nettowertdecimal192
2S628BIW1S628BIW1 * APO Demand21UMNETWRNet value of invoiced salesdecimal192
3S628BIW2S628BIW2 * APO Demand21UMNETWRNet value of invoiced salesdecimal192
4S990Smoby: hiérarchie client20UMNETWRChiffre d'affaires - Valeur nettedecimal192
5S992Client/famille/article20UMNETWRChiffre d'affaires - Valeur nettedecimal192
6S997Danone19UMNETWRNet value of invoiced salesdecimal192
7S999Copy of S628 for APO Pump Demo21UMNETWRNet value of invoiced salesdecimal192
TOPAdvertising Management
8S481IS-M/AM: View of BP Sales Areas21UMNETWRIS-M/AM: LIS order net sales volumedecimal192
TOPData Collection
9S001SIS: Customer Statistics18UMNETWRNet value of invoiced salesdecimal192
10S001BIW1S001BIW1 * SIS: Customer Statistics18UMNETWRNet value of invoiced salesdecimal192
11S001BIW2S001BIW2 * SIS: Customer statistics18UMNETWRNet value of invoiced salesdecimal192
12S002SIS: Sales Office Statistics19UMNETWRNet value of invoiced salesdecimal192
13S002BIW1S002BIW1 * SIS: Sales office statistics19UMNETWRNet value of invoiced salesdecimal192
14S002BIW2S002BIW2 * SIS: Sales office statistics19UMNETWRNet value of invoiced salesdecimal192
15S003SIS: SalesOrg/DistCh/Division/District/Customer/Product20UMNETWRNet value of invoiced salesdecimal192
16S003BIW1S003BIW1 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro20UMNETWRNet value of invoiced salesdecimal192
17S003BIW2S003BIW2 * SIS: SaleOrg/Dist.Channel/Divisn/Distrct/Cust/Pro20UMNETWRNet value of invoiced salesdecimal192
18S004SIS: Product/Sales Organization/Distribution Channel18UMNETWRNet value of invoiced salesdecimal192
19S004BIW1SIS: Product/Sales Organization/Distribution Channel18UMNETWRNet value of invoiced salesdecimal192
20S004BIW2SIS: Product/Sales Organization/Distribution Channel18UMNETWRNet value of invoiced salesdecimal192
21S006SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/Product20UMNETWRNet value of invoiced salesdecimal192
22S006BIW1S006BIW1 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/20UMNETWRNet value of invoiced salesdecimal192
23S006BIW2S006BIW2 * SIS: Sales Rep/SalesOrg/DistCh/Division/Customer/20UMNETWRNet value of invoiced salesdecimal192
24S126Open Variants - Basis 150UMNETWRNet value of invoiced salesdecimal192
25S127Open Variants - Basis 243UMNETWRNet value of invoiced salesdecimal192
26S128Open Variants - SIS40UMNETWRNet value of invoiced salesdecimal192
27S129Open Variants - Planning31UMNETWRNet value of invoiced salesdecimal192
28S137Variants: Basis 237UMNETWRNet value of invoiced salesdecimal192
29S138Variants: SIS & planning34UMNETWRNet value of invoiced salesdecimal192
30S409Contract & Billing28UMNETWRNet value of invoiced salesdecimal192
31S521Test19UMNETWRNet value of invoiced salesdecimal192
32S530LO630 Unit 02 Solution21UMNETWRNet value of invoiced salesdecimal192
33S531LO630 Solution Unit0626UMNETWRNet value of invoiced salesdecimal192
34S532LO630 Solution Unit 0819UMNETWRNet value of invoiced salesdecimal192
35S620IDES Data Generation20UMNETWRNet value of invoiced salesdecimal192
36S621Sales and Production21UMNETWRNet value of invoiced salesdecimal192
37S622SOP Level-by-Level21UMNETWRNet value of invoiced salesdecimal192
38S623SOP Variable Time Frames21UMNETWRNet value of invoiced salesdecimal192
39S624SOP Instructor21UMNETWRNet value of invoiced salesdecimal192
40S625SOP Instructor21UMNETWRNet value of invoiced salesdecimal192
41S626LO935: SOP without plant20UMNETWRNet value of invoiced salesdecimal192
42S628APO Demand21UMNETWRNet value of invoiced salesdecimal192
43S630LO935 Group 0021UMNETWRNet value of invoiced salesdecimal192
44S631LO935 Group 0121UMNETWRNet value of invoiced salesdecimal192
45S632LO935 Group 0221UMNETWRNet value of invoiced salesdecimal192
46S633LO935 Group 0321UMNETWRNet value of invoiced salesdecimal192
47S634LO935 Group 0421UMNETWRNet value of invoiced salesdecimal192
48S635LO935 Group 0521UMNETWRNet value of invoiced salesdecimal192
49S636LO935 Group 0621UMNETWRNet value of invoiced salesdecimal192
50S637LO935 Group 0721UMNETWRNet value of invoiced salesdecimal192
51S638LO935 Group 0821UMNETWRNet value of invoiced salesdecimal192
52S639LO935 Group 0921UMNETWRNet value of invoiced salesdecimal192
53S640LO935 Group 1021UMNETWRNet value of invoiced salesdecimal192
54S641LO935 Group 1121UMNETWRNet value of invoiced salesdecimal192
55S642LO935 Group 1221UMNETWRNet value of invoiced salesdecimal192
56S643LO935 Group 1321UMNETWRNet value of invoiced salesdecimal192
57S644LO935 Group 1421UMNETWRNet value of invoiced salesdecimal192
58S645LO935 Group 1521UMNETWRNet value of invoiced salesdecimal192
59S646LO935 Group 1621UMNETWRNet value of invoiced salesdecimal192
60S647LO935 Group 1721UMNETWRNet value of invoiced salesdecimal192
61S648LO935 Group 1821UMNETWRNet value of invoiced salesdecimal192
62S649LO935 Group 1921UMNETWRNet value of invoiced salesdecimal192
63S991Hiérarchie client / Produit21UMNETWRChiffre d'affaires - Valeur nettedecimal192
64S998SMOBY20UMNETWRChiffre d'affaires - Valeur nettedecimal192
TOPDownstream
65S410BIW1S410BIW1 * SIS: Business Location Statistics via 'Ship-to' (19UMNETWRNet value of invoiced salesdecimal192
66S410BIW2S410BIW2 * SIS: Business Location Statistics via 'Ship-to' (19UMNETWRNet value of invoiced salesdecimal192
TOPInformation System
67S020SIS: Customer Potential Analysis23UMNETWRNet value of invoiced salesdecimal192
TOPMarketing Retail Network
68S410SIS: Business Location Statistics via 'Ship-to' (IS-Oil MR19UMNETWRNet value of invoiced salesdecimal192
TOPPeriodical Sales and Distribution
69S450IS-M/SD: Customer Statistics27UMNETWRNet value of invoiced salesdecimal192
70S451IS-M/SD: Sales Office Statistics28UMNETWRNet value of invoiced salesdecimal192
71S452IS-M/SD: Product Statistics28UMNETWRNet value of invoiced salesdecimal192
72S454IS-M/SD: Sales Agents27UMNETWRNet value of invoiced salesdecimal192
73S455IS-M/SD: Promotion Statistics27UMNETWRNet value of invoiced salesdecimal192
74S456IS-M/SD: AR Category Statistics26UMNETWRNet value of invoiced salesdecimal192
75S457IS-M/SD: Carrier Route Statistics28UMNETWRNet value of invoiced salesdecimal192