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

46 columns | Print definition?ERP 6.0  | SATNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table80SATNRCross-Plant Configurable Materialnvarchar180
2/SMERP/STG_MM002Data staging - Material storage location view complex table80SATNRCross-Plant Configurable Materialnvarchar180
3/SMERP/STG_MM003Data staging - Material UoM view complex table81SATNRCross-Plant Configurable Materialnvarchar180
4/SMERP/STG_MM004Data staging - Material warehouse view complex table80SATNRCross-Plant Configurable Materialnvarchar180
5/SMERP/STG_MM005Data staging - Material batch view complex table80SATNRCross-Plant Configurable Materialnvarchar180
6FSH_SEASONS_MATTable for Seasons In Material13SATNRCross-Plant Configurable Materialnvarchar180
7SGT_MARMSegmentation | Weights and Volumes5SATNRCross-Plant Configurable Materialnvarchar180
8SGT_MVKESegmentation | Sales Status8SATNRCross-Plant Configurable Materialnvarchar180
9ZEIMMARAUSING FOR STORING EIM MARA DATAS82SATNRCross-Plant Configurable Materialnvarchar180
TOPAssortment Maintenance
10WSOPModules SAP Retail / Item Data12SATNRCross-Plant Configurable Materialnvarchar180
TOPCross-Application Components
11FRE_MD_PRODUCTObjects sent to F&R as Product6SATNRCross-Plant Configurable Materialnvarchar180
12MMARAGeneral material data82SATNRCross-Plant Configurable Materialnvarchar180
TOPData Collection
13S105Season: Movements12SATNRCross-Plant Configurable Materialnvarchar180
14S105ES105 - Structural Information7SATNRCross-Plant Configurable Materialnvarchar180
15S106Season: Stock6SATNRCross-Plant Configurable Materialnvarchar180
16S106ES106 - Structural Information7SATNRCross-Plant Configurable Materialnvarchar180
17S107Season: Movements + Stock12SATNRCross-Plant Configurable Materialnvarchar180
18S107ES107 - Structural Information7SATNRCross-Plant Configurable Materialnvarchar180
19S108Additionals9SATNRCross-Plant Configurable Materialnvarchar180
20S108ES108 - Structural Information8SATNRCross-Plant Configurable Materialnvarchar180
21S117Receipt/article27SATNRCross-Plant Configurable Materialnvarchar180
22S160Perishables13SATNRCross-Plant Configurable Materialnvarchar180
23S160ES160 - Structural Information8SATNRCross-Plant Configurable Materialnvarchar180
24S200Inventory Controlling Stores39SATNRCross-Plant Configurable Materialnvarchar180
25S953BW Vorl.für BON/Artikel S11727SATNRWerksübergreifendes konfigurierbares Materialnvarchar180
TOPDefense Forces and Public Security
26/ISDFPS/ZEBANCopy of EBAN89SATNRCross-Plant Configurable Materialnvarchar180
TOPElectronic Data Interchange
27PRICAT_K003PRICAT: Catalog item basic data69SATNRCross-Plant Configurable Materialnvarchar180
TOPInventory Management
28MWXVM07MFields: Update Control of Module Pool SAPMM07M126SATNRCross-Plant Configurable Materialnvarchar180
29MWZVM07MFields: Update Control of Module Pool SAPMM07M126SATNRCross-Plant Configurable Materialnvarchar180
TOPInvoice Verification
30RBDRSEGBatch IV: Invoice Document Items79SATNRCross-Plant Configurable Materialnvarchar180
31RBVDMATInvoice Verification - Aggregation Data, Material11SATNRCross-Plant Configurable Materialnvarchar180
TOPMaterial Master
32MARAGeneral Material Data82SATNRCross-Plant Configurable Materialnvarchar180
33MARA_TMPFile for Incorrect Data in Direct Input89SATNRCross-Plant Configurable Materialnvarchar180
34MVRACross-version fields for MARA82SATNRCross-Plant Configurable Materialnvarchar180
35WRF_DISCONT_POSWorklist Items: Discontinuation for Seasonal Procurement16SATNRCross-Plant Configurable Materialnvarchar180
TOPMaterials Management
36/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions94SATNRCross-Plant Configurable Materialnvarchar180
TOPMerchandise and Assortment Planning
37TWISPC_MARARetail Planning: Materials for Provisional Planning19SATNRCross-Plant Configurable Materialnvarchar180
TOPPrice Planning Workbench
38WRF_PPW_PPDARTPPD Material Item14SATNRMaterial Number of the Generic Materialnvarchar180
TOPPromotion
39WAKPPromotion Item Data6SATNRCross-Plant Configurable Materialnvarchar180
40WMFPMarkdown Planning - item data (materials)11SATNRCross-Plant Configurable Materialnvarchar180
TOPPurchasing
41EBANPurchase Requisition89SATNRCross-Plant Configurable Materialnvarchar180
42EKPOPurchasing Document Item121SATNRCross-Plant Configurable Materialnvarchar180
43MEREQXPurchase Requisition Change Parameter89SATNRUpdated information in related user data fieldnvarchar10
44WDFR1Requirements Planning for Perishables21SATNRCross-Plant Configurable Materialnvarchar180
45WRF_POHF_POLOrder list27SATNRCross-Plant Configurable Materialnvarchar180
TOPSimulation
46VSEBAN_CNVersion: Purchase requisition89SATNRCross-Plant Configurable Materialnvarchar180