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

37 columns | Print definition?ERP 6.0  | EMATN

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000187000PSA for 2LIS_02_ITM T90CLNT090 Purch. Data (Item)36EMATNnvarchar180
2/BIC/B0000189000PSA for 2LIS_02_SCL T90CLNT090 Purch.Data Sch.Line34EMATNnvarchar180
3/SMERP/STG_PM001Data staging - Equipment complex table73EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
4/SMERP/STG_PM002Data staging - Functional Location complex table58EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
5/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab73EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
6/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab58EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
7ZEIM_LIPSSD document: Delivery: Item data198EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPCross-Application Components
8EEORDPurchasing Source List16EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPDefense Forces and Public Security
9/ISDFPS/ZEBANCopy of EBAN19EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPEquipment
10EQUIEquipment master data68EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPFunctional Locations
11IFLOTFunctional Location (Table)52EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
12IFLOT_VSFunctional Location (Version Table)53EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPInventory Management
13MSEGDocument Segment: Material170EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
14MWXMSEGZMSEG: Interface for Posting of Value170EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
15MWZMSEGZMSEG:Interface for Posting of Value170EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPMaster Data
16PLAFPlanned Order111EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPMaterial Requirements Planning
17MPNSETMPN-MRP Set: Group of Interchangeable MPNs in MRP5EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPMaterials Management
18/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions24EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPPOS Interface
19WVFBDRS Interface, Intermediate Buffer, Order Item FM21EMATNMaterial Numbernvarchar180
TOPPurchasing
20AMPLTable of Approved Manufacturer Parts4EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
21AMPL_REJECTIONRejection of AMPL Row4EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
22EBANPurchase Requisition19EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
23EKBEHistory per Purchasing Document41EMATNMaterial Numbernvarchar180
24EKBEHRemoved PO History Records41EMATNMaterial Numbernvarchar180
25EKESVendor Confirmations20EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
26EKPOPurchasing Document Item9EMATNMaterial Numbernvarchar180
27EORDPurchasing Source List16EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
28EQUPQuota File: Item21EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
29MEREQXPurchase Requisition Change Parameter19EMATNUpdated information in related user data fieldnvarchar10
30PEKESVariant Vendor Confirmations20EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
31WDFR_POSPerishables Planninng Item32EMATNMaterial Numbernvarchar180
TOPRepetitive Manufacturing
32COMPMOVEGoods Movement of Components110EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPSelf-Service Procurement
33/SRMERP/D_SC_ITMShopping Cart Item23EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPSerial Numbers
34T377XDocuments Allowed for Serial Number Management53EMATNOptionality of Parameter Transfernvarchar10
TOPShipping
35LIPSSD document: Delivery: Item data198EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180
TOPSimulation
36VSEBAN_CNVersion: Purchase requisition20EMATNMaterial Numbernvarchar180
37VSPLAF_CNVersion: Planned order112EMATNMaterial Number Corresponding to Manufacturer Part Numbernvarchar180