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

Home | ERP 6.0  | DPR_DASHBOARD
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
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OINM101Whse Journal
Portfolio and Project Management :: Project Management :: Evaluations
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DPR_DASHBOARD542Dashboard Data for ProjectEvaluations
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT CLIENT, OBJECT_GUID, ROOT_OBJECT_GUID, PARENT_GUID, LAST_CHANGED_ON, OBJECT_TYPE, SEC_OBJECT_TYPE, PHASE_GUID, ACTUAL_FINISH, ACTUAL_START, DOC_TOTAL, OBL_TOTAL, COLL_TOTAL, CTRL_PLAN_TOTAL, SYSTEM_STATUS, USER_STATUS, STATUS_SCHEME, RESPONSIBLES, MAX_SEVERITY, MANUAL_SEVERITY, AGGR_SEVERITY, PRIORITY, WORK_COMPLETE, PERFORM_START, PERFORM_FINISH, PERFORM_SCOPE, PERFORM_SCHED, PROJECT_DELAY, STAFFING, PLANNED_COSTS, ACTUAL_COSTS, BUDGET, CURRENCY, RESULT_CLI, MILESTONE, GROUPING, PRO_TYPE, PHA_TYPE, TSK_TYPE, CLH_TYPE, SEARCH_FIELD, PROCESS, APP_RELEVANT, OBLIGATORY, PC_GROUP, PC_SAV_TARGET, PC_SAV_CURR, PC_SAV_CRCY, PC_ROI_TARGET, PC_ROI_CURR, PC_ROI_CRCY, PC_SIG_BASE, PC_SIG_TARG, PC_SIG_CURR FROM DPR_DASHBOARD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2OBJECT_GUIDApplication Object GUIDvarbinary160RAWNoEVE_TV_OBJECT_GUID
3ROOT_OBJECT_GUIDRoot Object GUID of an Application Hierarchyvarbinary160RAWYesEVE_TV_ROOT_OBJECT_GUID
4PARENT_GUIDGUID of Superior Objectvarbinary160RAWYesEVE_TV_PARENT_OBJECT_GUID
5LAST_CHANGED_ONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)decimal150DEC((0))YesDPR_TV_TIMESTAMP
6OBJECT_TYPEObject Category for Evaluation Enginenvarchar160CHAR(N' ')Yes*EVE_TV_OBJECT_TYPE Allow NULL? 
7SEC_OBJECT_TYPESecondary Object Type for Evaluation Enginenvarchar160CHAR(N' ')Yes*EVE_TV_SEC_OBJECT_TYPE Allow NULL? 
8PHASE_GUIDGUID of a Phasevarbinary160RAWYesEVE_TV_PHASE_GUID
9ACTUAL_FINISHActual Finishnvarchar80DATS(N'00000000')YesDPR_TV_ACTUAL_FINISH Allow NULL? 
10ACTUAL_STARTActual Startnvarchar80DATS(N'00000000')YesDPR_TV_ACTUAL_START Allow NULL? 
11DOC_TOTALNumber of Documentssmallint50INT2((0))YesDPR_TV_DOCUMENTS_TOTAL
12OBL_TOTALNumber of Object Linkssmallint50INT2((0))YesDPR_TV_OBJ_LINKS_TOTAL
13COLL_TOTALNumber of Collaborationssmallint50INT2((0))YesDPR_TV_COLLABORATIONS_TOTAL
14CTRL_PLAN_TOTALNumber of Control Planssmallint50INT2((0))YesDPR_TV_CTRL_PLANS_TOTAL
15SYSTEM_STATUSSystem Status for an Object as a Stringntext10737418230YesDPR_TV_SYSTEM_STATUS
16USER_STATUSUser Status for an Objectntext10737418230YesDPR_TV_USER_STATUS
17STATUS_SCHEMEStatus Profilenvarchar80CHAR(N' ')Yes*J_STSMA Allow NULL? 
18RESPONSIBLESPersons Responsible or Responsible Organizational Unitsntext10737418230YesDPR_TV_PERSONS_RESPONSIBLE
19MAX_SEVERITYMaximum Severity of a Threshold Value in the Evaluationsnvarchar50NUMC(N'00000')Yes*EVE_TV_MAX_THLD_SEVERITY Allow NULL? 
20MANUAL_SEVERITYManual Severity of a Threshold Value in the Evaluationsnvarchar50NUMC(N'00000')Yes*EVE_TV_MANUAL_THLD_SEVERITY Allow NULL? 
21AGGR_SEVERITYAggregated Severity of a Threshold Value in the Evaluationnvarchar50NUMC(N'00000')Yes*EVE_TV_AGGR_THLD_SEVERITY Allow NULL? 
22PRIORITYPrioritytinyint30INT1((0))YesDPR_TV_PRIORITY
23WORK_COMPLETEPercentage of Completion of Project Worknvarchar30NUMC(N'000')YesDPR_TV_PRO_WORK_COMPLETE Allow NULL? 
24PERFORM_STARTStart Date of Project Metchar10CHAR(N' ')YesDPR_TV_PERFORMANCE_START Allow NULL? 
25PERFORM_FINISHFinish Date of Project Metchar10CHAR(N' ')YesDPR_TV_PERFORMANCE_FINISH Allow NULL? 
26PERFORM_SCOPEScope of Project Metnvarchar30NUMC(N'000')YesDPR_TV_PERFORMANCE_SCOPE Allow NULL? 
27PERFORM_SCHEDTasks That Met Deadlinenvarchar30NUMC(N'000')YesDPR_TV_PERFORMANCE_SCHEDULE Allow NULL? 
28PROJECT_DELAYKey Figure: Project Delaysmallint50INT2((0))YesDPR_TV_PROJECT_DELAY
29STAFFINGKey Figure: Staffing Statusnvarchar30NUMC(N'000')YesDPR_TV_STAFFING_INDICATOR Allow NULL? 
30PLANNED_COSTSValue of Planned Costs for a Projectdecimal152CURR((0))YesDPR_TV_PLANNED_COSTS
31ACTUAL_COSTSValue of Actual Costs of a Projectdecimal152CURR((0))YesDPR_TV_ACTUAL_COSTS
32BUDGETBudget Value of a Projectdecimal152CURR((0))YesDPR_TV_BUDGET
33CURRENCYCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
34RESULT_CLIResult for Checklist Itemchar10CHAR(N' ')YesDPR_TV_CKLITEM_RESULT Allow NULL? 
35MILESTONEMilestone Indicatorchar10CHAR(N' ')YesDPR_TV_MILESTONE Allow NULL? 
36GROUPINGGroupingnvarchar400CHAR(N' ')YesDPR_TV_GROUPING Allow NULL? 
37PRO_TYPEProject Typenvarchar150CHAR(N' ')Yes*DPR_TV_PRO_TYPE Allow NULL? 
38PHA_TYPEPhase Typenvarchar150CHAR(N' ')Yes*DPR_TV_PHA_TYPE Allow NULL? 
39TSK_TYPETask Typenvarchar150CHAR(N' ')Yes*DPR_TV_TSK_TYPE Allow NULL? 
40CLH_TYPEChecklist Typenvarchar150CHAR(N' ')Yes*DPR_TV_CLH_TYPE Allow NULL? 
41SEARCH_FIELDSearch Fieldnvarchar400CHAR(N' ')YesDPR_TV_SEARCH_FIELD Allow NULL? 
42PROCESSProcessnvarchar150CHAR(N' ')Yes*DPR_TV_PROCESS Allow NULL? 
43APP_RELEVANTRelevant for Approvalchar10CHAR(N' ')YesDPR_TV_APPROVAL_RELEVANT Allow NULL? 
44OBLIGATORYMandatorychar10CHAR(N' ')YesDPR_TV_OBLIGATORY Allow NULL? 
45PC_GROUPGroup for Project Charternvarchar150CHAR(N' ')Yes*DPR_TV_PC_GROUP Allow NULL? 
46PC_SAV_TARGETSavings Targetint100INT4((0))YesDPR_TV_PC_SAV_TARGET Allow NULL? 
47PC_SAV_CURRSavings Actualint100INT4((0))YesDPR_TV_PC_SAV_CURRENT Allow NULL? 
48PC_SAV_CRCYSavings Currencynvarchar50CUKY(N' ')Yes*DPR_TV_PC_SAV_CURRENCY Allow NULL? 
49PC_ROI_TARGETROI Targetint100INT4((0))YesDPR_TV_PC_ROI_TARGET Allow NULL? 
50PC_ROI_CURRROI Actualint100INT4((0))YesDPR_TV_PC_ROI_CURRENT Allow NULL? 
51PC_ROI_CRCYROI Currencynvarchar50CUKY(N' ')Yes*DPR_TV_PC_ROI_CURRENCY Allow NULL? 
52PC_SIG_BASEBase Value Six Sigmaint100INT4((0))YesDPR_TV_PC_SIGMA_BASE Allow NULL? 
53PC_SIG_TARGTarget Value Six Sigmaint100INT4((0))YesDPR_TV_PC_SIGMA_TARGET Allow NULL? 
54PC_SIG_CURRCurrent/Final Value Six Sigmaint100INT4((0))YesDPR_TV_PC_SIGMA_CURRENT Allow NULL? 
NamePrimaryUniqueTypeColumns
DPR_DASHBOARD~0YesYesCLUSTEREDOBJECT_GUID, CLIENT
DPR_DASHBOARD~ROGNoNoNONCLUSTEREDROOT_OBJECT_GUID, CLIENT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy