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

43 columns | Print definition?ERP 6.0  | SIMID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPliveCache Applications
1/SAPAPO/ORDKEYKey and descriptive data for order3SIMIDName of Planning Versionnvarchar220
2/SAPAPO/STOCKANCKey and Descriptive Data for Stock2SIMIDName of Planning Versionnvarchar220
3/SAPAPO/UPGRADEData for Release Upgrade3SIMIDName of Planning Versionnvarchar220
4MMRP_DATEVECSKey: Date Vector (Only in the liveCache)3SIMIDName of Planning Versionnvarchar220
5RPM_PERF_DATARPM: Performance Results (only in the liveCache)2SIMIDName of Planning Versionnvarchar220
6RPM_PLAN_FILEMatrix: RPM Markings (Only in liveCache)2SIMIDName of Planning Versionnvarchar220
TOPWorkforce Management Core
7/SAPAPO/LRPASGLCTable of Dispatching Details for Assignment2SIMIDWFM Planning Version (UID)nvarchar220
8/SAPAPO/LRPASLCTLong Descriptions for Assignments2SIMIDWFM Planning Version (UID)nvarchar220
9/SAPAPO/LRPASSARTable of Dispatching Details for Assignment3SIMIDWFM Planning Version (UID)nvarchar220
10/SAPAPO/LRPASSGNObsolete: Table of Dispatching Details for Assignment2SIMIDWFM Planning Version (UID)nvarchar220
11/SAPAPO/LRPASSIGTable of Dispatching Details for Assignment2SIMIDWFM Planning Version (UID)nvarchar220
12/SAPAPO/LRPASSITLong Descriptions for Assignments2SIMIDWFM Planning Version (UID)nvarchar220
13/SAPAPO/LRPCAPAVInterval list for capacitive time specification3SIMIDWFM Planning Version (UID)nvarchar220
14/SAPAPO/LRPCAPILCapacitve Time Intervals List3SIMIDWFM Planning Version (UID)nvarchar220
15/SAPAPO/LRPDEMHLRP Requirements3SIMIDWFM Planning Version (UID)nvarchar220
16/SAPAPO/LRPDUKEYObsolete: Attributes for Time Durations3SIMIDWFM Planning Version (UID)nvarchar220
17/SAPAPO/LRPITKEYAttributes for Time Intervals3SIMIDWFM Planning Version (UID)nvarchar220
18/SAPAPO/LRPLOCDDemand Locations3SIMIDWFM Planning Version (UID)nvarchar220
19/SAPAPO/LRPLOCRWFM Supplied Location Table for Resources3SIMIDWFM Planning Version (UID)nvarchar220
20/SAPAPO/LRPREQRTResource Type Profile Requirement2SIMIDWFM Planning Version (UID)nvarchar220
21/SAPAPO/LRPREQWDSearch/Requirements Profile for Work Descriptions3SIMIDWFM Planning Version (UID)nvarchar220
22/SAPAPO/LRPRESOKey and Descriptive Data for a Resource3SIMIDWFM Planning Version (UID)nvarchar220
23/SAPAPO/LRPRKEYObsolete since 110: Key and Descriptive Data for a Resource3SIMIDWFM Planning Version (UID)nvarchar220
24/SAPAPO/LRPRQPROQualifications Profile2SIMIDWFM Planning Version (UID)nvarchar220
25/SAPAPO/LRPRTSATAttributes for a Requirement's Time Data3SIMIDWFM Planning Version (UID)nvarchar220
26/SAPAPO/LRPRWRESLRP Work Description: WD Resource Object4SIMIDWFM Planning Version (UID)nvarchar220
27/SAPAPO/LRPRWTIMWork Description: WD Time Object for Requirements3SIMIDWFM Planning Version (UID)nvarchar220
28/SAPAPO/LRPSCHEDObsolete: Planning Step Table2SIMIDWFM Planning Version (UID)nvarchar220
29/SAPAPO/LRPSCPROSupplied WD Time Capacity Limits Profile Set2SIMIDWFM Planning Version (UID)nvarchar220
30/SAPAPO/LRPSOPROSupplied WD Time Overtime Profile Set2SIMIDWFM Planning Version (UID)nvarchar220
31/SAPAPO/LRPSQPROQualifications Profile2SIMIDWFM Planning Version (UID)nvarchar220
32/SAPAPO/LRPSTSATAttributes for Resource's Time Data3SIMIDWFM Planning Version (UID)nvarchar220
33/SAPAPO/LRPSUPWDWFM Capacity Profile for Work Descriptions (Internal)3SIMIDWFM Planning Version (UID)nvarchar220
34/SAPAPO/LRPSWTIMWork Description: WD Time Object for Resources3SIMIDWFM Planning Version (UID)nvarchar220
35/SAPAPO/LRPTMRULWFM Time Specification - Rules3SIMIDWFM Planning Version (UID)nvarchar220
36/SAPAPO/LRPTSATTObsolete: Attributes for Time Data3SIMIDWFM Planning Version (UID)nvarchar220
37/SAPAPO/LRPTSTRMTable for WFM Time Streams of the BuiltIn Dispatcher2SIMIDWFM Planning Version (UID)nvarchar220
38/SAPAPO/LRPWDRESLRP Work Description: WD Resource Object4SIMIDWFM Planning Version (UID)nvarchar220
39/SAPAPO/LRPWDTIMObsolete: LRP Work Description: WD Time Object3SIMIDWFM Planning Version (UID)nvarchar220
40/SAPAPO/TSTASGLCTable of Dispatching Details for Assignment2SIMIDWFM Planning Version (UID)nvarchar220
41/SAPAPO/TSTASSIGTable of Dispatching Details for Assignment2SIMIDWFM Planning Version (UID)nvarchar220
42/SAPAPO/TSTRESOKey and Descriptive Data for a Resource3SIMIDWFM Planning Version (UID)nvarchar220
43/SAPAPO/TSTRWRESLRP Work Description: WD Resource Object4SIMIDWFM Planning Version (UID)nvarchar220