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

61 columns | Print definition?ERP 6.0  | BERID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1PPH_PFE_CHANGETable for PFE changes4BERIDMRP Areanvarchar100
2T449USettings for Collective Display of MRP List32BERIDMRP Areanvarchar100
3ZEIM_AFPOOrder item89BERIDMRP Areanvarchar100
4ZEIM_LIPSSD document: Delivery: Item data206BERIDMRP Areanvarchar100
5ZEIM_VBAPSales Document: Item Data204BERIDMRP Areanvarchar100
TOPAvailability Check
6LATP_ENQPersistent Lock Records for ATP in R/3 from External Systems11BERIDMRP Areanvarchar100
TOPBasic Functions
7VBBESales Requirements: Individual Records7BERIDMRP Areanvarchar100
TOPConsumption-Based Planning See Also PP-MRP
8DBPROFForecast Error with MRP Areas3BERIDMRP Areanvarchar100
9DBPRONReproc. of Forecast Errors and Excpn Messages with MRP Area3BERIDMRP Areanvarchar100
10MAHDAlternative Required Time Series for the Forecast2BERIDMRP Areanvarchar100
11MAHD_OVALOriginal Values for Alternative RPM Time Series for Forecast2BERIDMRP Areanvarchar100
TOPCross-Application Components
12VVBAPSales Document: Item Data204BERIDMRP Areanvarchar100
TOPDefense Forces and Public Security
13/ISDFPS/ZEBANCopy of EBAN112BERIDMRP Areanvarchar100
TOPDemand Management
14PBIDPlanned independent requirements index: MRP area5BERIDMRP Areanvarchar100
15T459USettings for Maintaining Planned Independent Requirements5BERIDMRP Areanvarchar100
TOPManufacturer Part Number
16ADPIC_HOLD_MPNStore MPN subitems for MIGO hold / restore functionality26BERIDMRP Areanvarchar100
TOPMaster Data
17DBPRMaterial Index MRP Area for Forecast2BERIDMRP Areanvarchar100
18DBVLPlanning File Entry, MRP Area, Long-Term Planning6BERIDMRP Areanvarchar100
19DBVMPlanning File Entry, MRP Area5BERIDMRP Areanvarchar100
20DVERMaterial Consumption for MRP Area3BERIDMRP Areanvarchar100
21EMRP_RUNBlocking argument for MRP5BERIDMRP Areanvarchar100
22KBVLIndividual Customer Plng File Entry, MRP Area Long-Term Plng6BERIDMRP Areanvarchar100
23KBVMIndividual Customer Planning File Entry, MRP Area5BERIDMRP Areanvarchar100
24MDCOVTable with Range of Coverage Information5BERIDMRP Areanvarchar100
25MDDMAPMapping Table for External User for MRP Evaluations8BERIDMRP Areanvarchar100
26MDFDDBFirming Data of MRP - MRP Area3BERIDMRP Areanvarchar100
27MDKPDBHeader Data for MRP Document4BERIDMRP Areanvarchar100
28MDLGCustomizing: MRP Area Storage Location2BERIDMRP Areanvarchar100
29MDLLCustomizing: MRP Area Subcontractor2BERIDMRP Areanvarchar100
30MDLVCustomizing MRP Area2BERIDMRP Areanvarchar100
31MDLWCustomizing: MRP Area Plants2BERIDMRP Areanvarchar100
32MDMAMRP Area for Material3BERIDMRP Areanvarchar100
33MDMULTLEVDELAYMultilevel Delay Calculated via Order Report19BERIDMRP Areanvarchar100
34MDSEQCustomizing: Sequence of MRP in Scope of Planning5BERIDMRP Areanvarchar100
35PLAFPlanned Order109BERIDMRP Areanvarchar100
36T439CScope of Planning MRP Unit: Sequence5BERIDMRP Areanvarchar100
TOPMaterial Requirements Planning
37CIFMDLGVRVersions of Table MDLG2BERIDMRP Areanvarchar100
38CIFMDLVVRVersions of Table MDLV2BERIDMRP Areanvarchar100
39CIFMDMAVRVersions of Table MDMA4BERIDMRP Areanvarchar100
TOPMaterials Management
40/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions118BERIDMRP Areanvarchar100
TOPProduction Orders
41AFPOOrder item89BERIDMRP Areanvarchar100
TOPPurchasing
42EBANPurchase Requisition112BERIDMRP Areanvarchar100
43EKPOPurchasing Document Item199BERIDMRP Areanvarchar100
44MEREQXPurchase Requisition Change Parameter112BERIDUpdated information in related user data fieldnvarchar10
TOPRemaining Beverage - Obsolete Objects
45/BEV1/RBVBAPSales Document: Item Data204BERIDMRP Areanvarchar100
TOPSales
46VBAPSales Document: Item Data204BERIDMRP Areanvarchar100
TOPSCM Basis
47CIF_IMMRPAIntegration Model Reference Table for MRP Areas2BERIDMRP Areanvarchar200
48CIF_IMMTMRPAIntegration Model Reference Table for Material3BERIDMRP Areanvarchar100
TOPShipping
49LIPSSD document: Delivery: Item data206BERIDMRP Areanvarchar100
TOPSimulation
50VSAFPO_CNVersion: Order items in PP orders90BERIDMRP Areanvarchar100
51VSEBAN_CNVersion: Purchase requisition113BERIDMRP Areanvarchar100
52VSPLAF_CNVersion: Planned order110BERIDMRP Areanvarchar100
53VSVBAP_CNVersion: Sales document: Item data205BERIDMRP Areanvarchar100
TOPStructures Workbench
54/ISDFPS/FORSUPLCControl Data: Logistics5BERIDMRP Areanvarchar100
TOPSupersession Chains
55PICRLParts Interchangeability Relation (Plant/MRP Area)7BERIDMRP Areanvarchar100
TOPTraders and Schedulers Workbench
56OIJBERBerth Table2BERIDBerth identifiernvarchar200
57OIJBERLOCIndex table for berths at TSW locations3BERIDBerth identifiernvarchar200
58OIJBERMATAssignment of material to berths2BERIDBerth identifiernvarchar200
59OIJBERSOCAssignment of berths to tanks3BERIDBerth identifiernvarchar200
60OIJNENomination Events50BERIDBerth identifiernvarchar200
61OIJNOMI_LDSLoad / Discharge scheduling for nominations13BERIDBerth identifiernvarchar200