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

47 columns | Print definition?ERP 6.0  | PROJECT_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SLOAP/ANALYSISSLOAP analysis data14PROJECT_GUIDSLOAS Project Guidvarbinary160
2/SLOAP/KNA1_PROJSLOAS mapping of kunnr to project3PROJECT_GUIDSLOAS Project Guidvarbinary160
3/SLOAP/PROJ_RESSLOAS project to result mapping table2PROJECT_GUIDSLOAS Project Guidvarbinary160
4/SLOAP/UI_STATEStatus of UI Head Table3PROJECT_GUIDSLOAS: Guidvarbinary160
5/XPPM/EVA_USER_LDatatable for User-Log6PROJECT_GUIDApplication Object GUIDvarbinary160
6CNVCMIS_A_1_DEVCDevelopment Class Table(CMIS)32PROJECT_GUIDGUID for cPro Projectvarbinary160
7ZDPR_OBJLINKObject link data storage for DPR3PROJECT_GUIDApplication Object GUIDvarbinary160
8ZPPMC_CPL_T_CACHCache for Delta Posting13PROJECT_GUIDGUID for Projectvarbinary160
9ZPPMC_CPL_T_COSTplanning positions of project for bapis11PROJECT_GUIDGUID for Projectvarbinary160
10ZPPMC_CPL_T_POSPlanning positions for cProjects Cost Planning4PROJECT_GUIDApplication Object GUID (Entity with Conversion Exit)varbinary160
11ZPPMC_DPR_COSTPLBewegungsdaten für die Sachkostenplanung in cProjects3PROJECT_GUIDApplication Object GUID (Entity with Conversion Exit)varbinary160
12ZRPM_OBJ_LINKObject link data storage3PROJECT_GUIDGuid for application objectsvarbinary160
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
13CRMCHKOBJAObject Attributes18PROJECT_GUIDGUID for cPro Projectvarbinary160
14CRMCHKRESLFindings (Display LoaD)46PROJECT_GUIDGUID for cPro Projectvarbinary160
TOPAudit Management
15PLMM_AUDIT_OBJAudit Object Attribute3PROJECT_GUIDComponent in Investigation (Audit, FMEA, ...)varbinary160
16PLMM_QUEST_IQuestion List Item3PROJECT_GUIDIdentification of Question List Headervarbinary160
17PLMM_QUEST_RESAudit Question/Reply List/Item3PROJECT_GUIDIdentification of the Auditvarbinary160
TOPConnection to External Systems
18DPR_OBJLINK_SCObject Link to SRM Shopping Carts4PROJECT_GUIDApplication Object GUID (Entity with Conversion Exit)varbinary160
19DPR_OBJLINK_SCPOPurchase Order and Purchase Order Item for SRM Shopping Cart7PROJECT_GUIDProject Planning: 16 Character GUID for Projectsvarbinary160
TOPGeneric Project Planning
20CGPL_HIERARCHYProject Planning: Activities and Projects Hierarchy Table3PROJECT_GUIDProject Planning: 16-Character GUID for Projects and Activtsvarbinary160
21CGPL_PROJECTProject Planning: Attribute Table for Project Headers4PROJECT_GUIDProject Planning: 16 Character GUID for Projectsvarbinary160
22CGPL_TASKProject Planning: Attribute Table for Activities4PROJECT_GUIDProject Planning: 16 Character GUID for Projectsvarbinary160
TOPIntegrated Product and Process Engineering
23PPECPROOBJLNKiPPE Assignment Table: Object Links with cProjects6PROJECT_GUIDInternal Identification for PVS Objectsvarbinary160
TOPMaintenance Processing
24/MRSS/D_DPR_REJRejected resoruces2PROJECT_GUIDGUIDvarbinary160
TOPObject Links
25DPR_OBJLINKObject Link3PROJECT_GUIDApplication Object GUIDvarbinary160
TOPPackage Tools
26PAK_PROJECTSF4 Values for cPro Projects2PROJECT_GUIDGUID for cPro Projectvarbinary160
TOPPortfolio Management
27RPM_CTEMPLATECustom Development Template2PROJECT_GUIDGuid for application objectsvarbinary160
28RPM_DOCUMENTDocument data storage3PROJECT_GUIDProject Planning: 16-Character GUID for Projects and Activtsvarbinary160
29RPM_FES_PRJ_ASGNAssignments for Project Manager6PROJECT_GUIDGuid for application objectsvarbinary160
30RPM_FES_PRJ_ROLEAssignments for Project Manager6PROJECT_GUIDGuid for application objectsvarbinary160
31RPM_FES_RES_ASGNTo be deleted6PROJECT_GUIDGuid for application objectsvarbinary160
32RPM_FES_RES_ROLETo be deleted6PROJECT_GUIDGuid for application objectsvarbinary160
33RPM_OBJ_LINKObject link data storage3PROJECT_GUIDGuid for application objectsvarbinary160
34RPM_OBJ_LINK_CDObject links - Pseudo table for change documents3PROJECT_GUIDGuid for application objectsvarbinary160
35RPM_PP_PRIO_PROJRPM : Projects for Portfolio Prioritization3PROJECT_GUIDGuid for application objectsvarbinary160
36RPM_PROJECT_COControlling Information about a project24PROJECT_GUIDGuid for application objectsvarbinary160
37RPM_RELATERPM: Relationship table8PROJECT_GUIDGuid for application objectsvarbinary160
38RPM_RELATE_BKUPRPM: Relationship table8PROJECT_GUIDGuid for application objectsvarbinary160
39RPM_REL_ALLOC_BKBack up table for RPM: Relationship table8PROJECT_GUIDGuid for application objectsvarbinary160
40RPM_ROLE_AVL_BAKBack up table of Project Role Demand8PROJECT_GUIDGuid for application objectsvarbinary160
41RPM_UNIT_CONVERTProject ID for converted projects2PROJECT_GUIDGlobally Unique Identifiervarbinary160
TOPProject Management
42CGPL_ENTITYCGPL Entities7PROJECT_GUIDProject Planning: 16 Character GUID for Projectsvarbinary160
43DPR_CONF_DETProject Management Confirmation: Detail Fields of Tasks3PROJECT_GUIDProject Planning: 16 Character GUID for Projectsvarbinary160
44DPR_CONF_LIProject Management Confirmation: Line Item7PROJECT_GUIDProject Planning: 16 Character GUID for Projectsvarbinary160
TOPTransport Organizer
45TDEVCPackages28PROJECT_GUIDGUID for cPro Projectvarbinary160
TOPTravel Expenses
46PTRV_SCOSTrip Statistics - Cost Assignment26PROJECT_GUIDProject GUID (cProjects)varbinary160
TOPTravel Planning
47FTPT_REQ_ACCOUNTTravel Request Cost Assignment47PROJECT_GUIDProject GUID (cProjects)varbinary160