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

27 columns | Print definition?ERP 6.0  | WEBAZ

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_MM001Data staging - Material master plant view complex table215WEBAZGoods Receipt Processing Time in Daysdecimal30
2ZEIM_AFPOOrder item40WEBAZGoods receipt processing time in daysdecimal30
TOPAllocation
3AUFIAllocation Table, Document Sub-item, Stores37WEBAZGoods Receipt Processing Time in Daysdecimal30
4AUVZDistribution Center16WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPBills of Material
5STPOBOM item66WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPCross-Application Components
6MMARCPlant Data for Material19WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPDefense Forces and Public Security
7/ISDFPS/ZEBANCopy of EBAN32WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPInventory Management
8MWZDM07M1ZDM07M1183WEBAZGoods Receipt Processing Time in Daysdecimal30
9RESBReservation/dependent requirements154WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPMaster Data
10MDKPHeader Data for MRP Document33WEBAZGoods Receipt Processing Time in Daysdecimal30
11MDKPDBHeader Data for MRP Document34WEBAZGoods Receipt Processing Time in Daysdecimal30
12MDTBMRP Table21WEBAZGoods Receipt Processing Time in Daysdecimal30
13PLAFPlanned Order16WEBAZGoods receipt processing time in daysdecimal30
TOPMaterial Master
14MARCPlant Data for Material19WEBAZGoods Receipt Processing Time in Daysdecimal30
15MARC_TMPFile for Incorrect Data in Direct Input22WEBAZGoods Receipt Processing Time in Daysdecimal30
16MDIPMaterial: MRP Profiles (Field Contents)25WEBAZGoods Receipt Processing Time in Daysdecimal30
17MVRCCross-version fields for MARC19WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPMaterials Management
18/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions37WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPProduction Orders
19AFPOOrder item40WEBAZGoods receipt processing time in daysdecimal30
TOPPurchasing
20EBANPurchase Requisition32WEBAZGoods Receipt Processing Time in Daysdecimal30
21EKPOPurchasing Document Item30WEBAZGoods Receipt Processing Time in Daysdecimal30
22MEREQXPurchase Requisition Change Parameter32WEBAZUpdated information in related user data fieldnvarchar10
23WDFR_POSPerishables Planninng Item64WEBAZGoods Receipt Processing Time in Daysdecimal30
TOPSimulation
24VSAFPO_CNVersion: Order items in PP orders41WEBAZGoods receipt processing time in daysdecimal30
25VSEBAN_CNVersion: Purchase requisition33WEBAZGoods Receipt Processing Time in Daysdecimal30
26VSPLAF_CNVersion: Planned order17WEBAZGoods receipt processing time in daysdecimal30
27VSRESB_CNVersion: Reservation/Dependent requirements155WEBAZGoods Receipt Processing Time in Daysdecimal30