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_PRO_TYPE
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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
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
10OBOT10Bill Of Exchang Transaction
Portfolio and Project Management :: Project Management :: Structure
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0DPR_PRO_TYPE451Project TypeStructure
SQL:  selectupdate insert create

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

SELECT CLIENT, PRO_TYPE, PRO_CATEGORY, REPL_ALLOWED, REPL_KIND, DEFAULT_UNIT, USE_DOCUMENTS, USE_COLLS, USE_OBJECT_LINKS, USE_CTRL_PLANS, USE_CHECKLISTS, USE_TASKS, USE_SUBTASKS, USE_RES_SEARCH, USE_RES_ASSIGNMT, USE_SUBPROJECTS, USE_MIRRORED, CONF_CATS, CONF_PROJ_ELEM, CONF_PROJ_DEF, USE_STAT_REPORTS, R3DMS_STAT_REP, THLD_CHECK, THLD_AGGREGATE, USE_VERSIONS, USE_APPR_CERT, USE_R3DMS_DOC, USE_SKILLS, SCHEDULE_TYPE, FIELD_CONTROL, USE_PHASES, CL_BELOW_TSK, TSK_CL_PROJ_DEF, USE_DASHBOARD, USE_CROOM, USE_SRM, ACTIVE, USE_PROJECT_CHAR, USE_XRPM, PROJ_INTEG_TYPE, IMP_ACTUAL, ACC2FORECASTED, VRSN_HEADER_INT, USE_MTA, SET_USER_AUTH FROM DPR_PRO_TYPE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PRO_TYPEProject Typenvarchar150CHAR(N' ')NoDPR_TV_PRO_TYPE Allow NULL? 
3PRO_CATEGORYProject Categorychar10CHAR(N' ')YesDPR_PRO_CATEGDPR_TV_PRO_CATEGORY Allow NULL? 
4REPL_ALLOWEDScenario for Accounting Integrationchar10CHAR(N' ')YesDPR_FIN_INT_SCENDPR_TV_FIN_INT_SCENARIO Allow NULL? 
5REPL_KINDTime of Transferchar10CHAR(N' ')YesDPR_TV_REPLICATION_KIND Allow NULL? 
6DEFAULT_UNITUnitnvarchar30UNIT(N' ')YesDPR_TIME_UNITSDPR_TV_UNIT Allow NULL? 
7USE_DOCUMENTSWork with Documentschar10CHAR(N' ')YesDPR_TV_USE_DOCUMENTS Allow NULL? 
8USE_COLLSWork with cFolderschar10CHAR(N' ')YesDPR_TV_USE_COLLABORATIONS Allow NULL? 
9USE_OBJECT_LINKSWork with Object Linkschar10CHAR(N' ')YesDPR_TV_USE_OBJECT_LINKS Allow NULL? 
10USE_CTRL_PLANSWork with Control Planschar10CHAR(N' ')YesDPR_TV_USE_CONTROL_PLANS Allow NULL? 
11USE_CHECKLISTSWork with Checklistschar10CHAR(N' ')YesDPR_TV_USE_CHECKLISTS Allow NULL? 
12USE_TASKSWork with Taskschar10CHAR(N' ')YesDPR_TV_USE_TASKS Allow NULL? 
13USE_SUBTASKSWork with Task Hierarchieschar10CHAR(N' ')YesDPR_TV_USE_SUBTASKS Allow NULL? 
14USE_RES_SEARCHWork with Resource Searchchar10CHAR(N' ')YesDPR_TV_USE_RESOURCE_SEARCH Allow NULL? 
15USE_RES_ASSIGNMTIndicator Is Obsolete: No Longer Displayed in Customizingchar10CHAR(N' ')YesDPR_TV_USE_RESOURCE_ASSIGNMENT Allow NULL? 
16USE_SUBPROJECTSWork with Subprojectschar10CHAR(N' ')YesDPR_TV_USE_SUBPROJECTS Allow NULL? 
17USE_MIRROREDWork with Mirrored Taskschar10CHAR(N' ')YesDPR_TV_USE_MIRRORED Allow NULL? 
18CONF_CATSTime Recording and Travel Expenses via CATS/SRM/FINchar10CHAR(N' ')YesDPR_TV_CONF_CATS Allow NULL? 
19CONF_PROJ_ELEMProject Element for Time Recordingchar10CHAR(N' ')YesDPR_TV_CONF_PROJ_ELEM Allow NULL? 
20CONF_PROJ_DEFTime Recording for Project Definition Is Allowedchar10CHAR(N' ')YesDPR_TV_CONF_PROJ_DEF Allow NULL? 
21USE_STAT_REPORTSWork with Status Reportschar10CHAR(N' ')YesDPR_TV_USE_STATUS_REPORTS Allow NULL? 
22R3DMS_STAT_REPCheck In Status Reports in SAP DMSchar10CHAR(N' ')YesDPR_TV_USE_R3DMS_STATUS_REPS Allow NULL? 
23THLD_CHECKCheck for Threshold Value Violationschar10CHAR(N' ')YesDPR_TV_THLD_CHECK Allow NULL? 
24THLD_AGGREGATEAggregate Severitieschar10CHAR(N' ')YesDPR_TV_THLD_AGGREGATE Allow NULL? 
25USE_VERSIONSWork with Versionschar10CHAR(N' ')YesDPR_TV_USE_VERSIONS Allow NULL? 
26USE_APPR_CERTSignature of Approval with User Certificatechar10CHAR(N' ')YesDPR_TV_SIGN_PHASE_CERTIFICATE Allow NULL? 
27USE_R3DMS_DOCWork with Documents in SAP DMSchar10CHAR(N' ')YesDPR_TV_USE_R3DMS_DOCUMENTS Allow NULL? 
28USE_SKILLSWork with Qualificationschar10CHAR(N' ')YesDPR_TV_USE_SKILLS Allow NULL? 
29SCHEDULE_TYPEScheduling Typechar10CHAR(N' ')YesDPR_TV_SCHEDULE_TYPE Allow NULL? 
30FIELD_CONTROLField Controlnvarchar60CHAR(N' ')YesDPR_FCDPR_TV_FC Allow NULL? 
31USE_PHASESWork with Phaseschar10CHAR(N' ')YesDPR_TV_USE_PHASES Allow NULL? 
32CL_BELOW_TSKChecklists Below Taskschar10CHAR(N' ')YesDPR_TV_CL_BELOW_TSK Allow NULL? 
33TSK_CL_PROJ_DEFTasks/Checklists Directly Below the Project Definitionchar10CHAR(N' ')YesDPR_TV_TSK_CL_PROJECT_DEF Allow NULL? 
34USE_DASHBOARDUse Dashboardchar10CHAR(N' ')YesDPR_TV_USE_DASHBOARD Allow NULL? 
35USE_CROOMWork with Virtual Roomschar10CHAR(N' ')YesDPR_TV_USE_CROOM Allow NULL? 
36USE_SRMActivate Shopping in SRMchar10CHAR(N' ')YesDPR_TV_SRM_INTEGRATION Allow NULL? 
37ACTIVEActivate Project Typechar10CHAR(N' ')YesDPR_TV_PRO_TYPE_ACTIVE Allow NULL? 
38USE_PROJECT_CHARWork with Project Charterchar10CHAR(N' ')YesDPR_TV_USE_PROJECT_CHARTER Allow NULL? 
39USE_XRPMActivate Portfolio Mgmt Integrationchar10CHAR(N' ')NoDPR_TV_USE_XRPM Allow NULL? 
40PROJ_INTEG_TYPEProject Integration Typechar10CHAR(N' ')YesDPR_TRA_PROJ_INTEG_TYPE Allow NULL? 
41IMP_ACTUALImport Actual on Project Typechar10CHAR(N' ')YesDPR_TRA_IMPORT_ACTUAL Allow NULL? 
42ACC2FORECASTEDOnly Authorized Access to Forecasted Dateschar10CHAR(N' ')YesDPR_TV_FORECASTED_DATES_ACCESS Allow NULL? 
43VRSN_HEADER_INTType of Version Header Selectionchar10CHAR(N' ')YesDPR_TV_INT_VRSN_HEADER_NR Allow NULL? 
44USE_MTAWork with Milestone Trend Analysischar10CHAR(N' ')YesDPR_TV_USE_MTA Allow NULL? 
45SET_USER_AUTHSet distinct authorization for userchar10CHAR(N' ')YesDPR_TV_SET_USER_AUTH Allow NULL? 
NamePrimaryUniqueTypeColumns
DPR_PRO_TYPE~0YesYesCLUSTEREDPRO_TYPE, 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