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

33 columns | Print definition?ERP 6.0  | PRSNLS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPData Collection
1S077STRPS: Movements25PRSNLSSales deviation during salesdecimal192
2S079STRPS: Movements + Stock25PRSNLSSales deviation during salesdecimal192
3S080Purchasing: Movements25PRSNLSSales deviation during salesdecimal192
4S082Purchasing: Movements + Stock25PRSNLSSales deviation during salesdecimal192
5S083Material: Movements25PRSNLSSales deviation during salesdecimal192
6S085Material: Movements + Stock25PRSNLSSales deviation during salesdecimal192
7S086Promotion25PRSNLSSales deviation during salesdecimal192
8S105Season: Movements25PRSNLSSales deviation during salesdecimal192
9S107Season: Movements + Stock25PRSNLSSales deviation during salesdecimal192
10S110OTB23PRSNLSSales deviation during salesdecimal192
11S117Receipt/article39PRSNLSPrice reduction from sales as per receipts/aggregated salesdecimal192
12S119Transaction Number (Till Receipt)30PRSNLSPrice reduction from sales as per receipts/aggregated salesdecimal192
13S120Sales as per receipts27PRSNLSPrice reduction from sales as per receipts/aggregated salesdecimal192
14S120BIW1S120BIW1 * Sales as Per Receipts27PRSNLSPrice reduction from sales as per receipts/aggregated salesdecimal192
15S120BIW2S120BIW2 * Sales as Per Receipts27PRSNLSPrice reduction from sales as per receipts/aggregated salesdecimal192
16S121Material aggregation - POS21PRSNLSPrice reductiondecimal192
17S122Cashier19PRSNLSPrice reduction based on cashier statisticsdecimal192
18S122BIW1S122BIW1 * Cashier19PRSNLSPrice reduction based on cashier statisticsdecimal192
19S122BIW2S122BIW2 * Cashier19PRSNLSPrice reduction based on cashier statisticsdecimal192
20S123Customer / material group60PRSNLSThird-party sales deviationdecimal192
21S124Customer / material59PRSNLSThird-party sales deviationdecimal192
22S160Perishables63PRSNLSSales deviation during salesdecimal192
23S952Reference Structure for Generating Info Structures40PRSNLSSales deviation during salesdecimal192
24S953BW Vorl.für BON/Artikel S11739PRSNLSPreisnachlaß aus bongenauem/verdichteten Umsatzdecimal192
25S954BW Vorl.für BON S11930PRSNLSPreisnachlaß aus bongenauem/verdichteten Umsatzdecimal192
26S957Reference Structure for Generating Info Structures20PRSNLSSales deviation during salesdecimal192
TOPMerchandise and Assortment Planning
27S202MAP: Merchandise Planning Structure40PRSNLSSales deviation during salesdecimal192
28S204MAP: Merchandise Planning Movements26PRSNLSSales deviation during salesdecimal192
29S207MAP: Store Planning Structure20PRSNLSSales deviation during salesdecimal192
30S216MAP: Average Retail WOC25PRSNLSSales deviation during salesdecimal192
31S217MAP: AvgRetail MON25PRSNLSSales deviation during salesdecimal192
32S218MAP: AvgRetail BUP25PRSNLSSales deviation during salesdecimal192
TOPReporting
33S205MAP: Store Planning Movements20PRSNLSSales deviation during salesdecimal192