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

56 columns | Print definition?ERP 6.0  | EA_DUMMY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPControl Plan
1DPR_CTRLPLAN_IControl Plan: Characteristics Within Control Plan36EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
2DPR_CTRLPLAN_VControl Plan: Versions22EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
TOPEngineering Documents
3EDMS_AT01EDMS: Documents - GUID9EA_DUMMYnvarchar10
TOPPortfolio Management
4/RPM/BUCKET_DOperational bucket persisted data20EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
5/RPM/BUCKET_D_DROperational derrived bucket persisted data13EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
6/RPM/CAP_B_CATDemand planning for bucket categories9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
7/RPM/CAP_B_GROUPDemand planning bucket category groups10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
8/RPM/CAP_CATDemand Planning Category9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
9/RPM/CAP_GROUPxRPM Demand planning group object10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
10/RPM/COLLECTN_DCollection Persisted Data10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
11/RPM/DECISIONDecision Point Object Data20EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
12/RPM/FIN_B_CATFinancial planning for bucket categories9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
13/RPM/FIN_B_GROUPFinancial planning bucket category groups10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
14/RPM/FIN_CATFinancial Category9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
15/RPM/FIN_GROUPxRPM Financial Group Object10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
16/RPM/HIERARCHY_DStrategic hierarchy persisted data8EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
17/RPM/ITEM_DOperational item persisted data50EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
18/RPM/ITEM_D_DERProject data49EA_DUMMYSingle-Character Indicatornvarchar10
19/RPM/ITEM_HOperational item persisted data9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
20/RPM/PORTFOLIO_DPortfolio Operational persisted data18EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
21/RPM/PORTFOLIO_SPortfolio Details persisted data8EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
22/RPM/RELATION_DPortofolio relation object persisted data14EA_DUMMYSingle-Character Indicatornvarchar10
23/RPM/REVIEW_DPortfolio Review Persisted Data10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
24/RPM/WHATIF_DWhat If Persisted Data12EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
25RPM_BUCKET_D_CDBucket - Pseudo table for change documents20EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
26RPM_CAP_B_CAT_CDBucket demand category - Pseudo table for change documents9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
27RPM_CAP_B_GRP_CDBucket demand groups - Pseudo table for change docu10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
28RPM_CAP_CAT_CDDemand Planning Category- Pseudo table for change documents9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
29RPM_CAP_GRP_CDDemand planning groups - Pseudo table for change documents10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
30RPM_COLLECTN_CDCollection - Pseudo table for change documents10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
31RPM_DECISION_CDDecision Point - Pseudo table for change documents20EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
32RPM_FIN_B_CAT_CDBucket Financial Categories - Pseudo table for change docu9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
33RPM_FIN_B_GRP_CDBucket financial groups - Pseudo table for change docu10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
34RPM_FIN_CAT_CDFinancial Category - Pseudo table for change documents9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
35RPM_FIN_GRP_CDFinancial Group Object - Pseudo table for change documents10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
36RPM_ITEM_DER_CDProject data49EA_DUMMYSingle-Character Indicatornvarchar10
37RPM_ITEM_D_CDItem details - Pseudo table for change documents50EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
38RPM_ITEM_H_CDItem header - Pseudo table for change documents9EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
39RPM_PORTFOLIO_CDPortfolio attributes - Pseudo table for change documents16EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
40RPM_RELATION_CDPortofolio Relations - Pseudo table for change documents14EA_DUMMYSingle-Character Indicatornvarchar10
41RPM_REVIEW_CDPortfolio Review - Pseudo table for change documents10EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
42RPM_WHATIF_D_CDWhat If Scenario - Pseudo table for change documents12EA_DUMMYDummy Data Element for Enhanced xRPM Attributesnvarchar10
TOPResources
43DPR_BUPA_FAVOList of Favorites (Business Partner)11EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
44DPR_BUPA_LINKRole-Business Partner Links21EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
45DPR_ENTITY_LINKRole Assignments17EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
46DPR_PARTProject Participants34EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
47DPR_SKILLQualification Requirements13EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
48RPM_BUPA_CUSTCustomer Fields for BUPA3EA_DUMMYSingle-Character Indicatornvarchar10
TOPStructure
49DPR_APPROVALApproval21EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
50DPR_CHECKLIST_HChecklist Header24EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
51DPR_CHECKLIST_IChecklist Items25EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
52DPR_CHECKLIST_RChecklist References12EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
53DPR_IND_APPROVALIndividual Approval17EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
54DPR_PHASEPhase15EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
55DPR_PROJECTProject Definition39EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10
56DPR_TASKTasks36EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributesnvarchar10