SAP DPR_BW_DATE Dev. Projects: Extract Structure Date Attributes Table data and field list

DPR_BW_DATE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Dev. Projects: Extract Structure Date Attributes" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_DPR_BW_DATE TYPE DPR_BW_DATE.

The DPR_BW_DATE table consists of various fields, each holding specific information or linking keys about Dev. Projects: Extract Structure Date Attributes data available in SAP. These include DATE_SET (Date Type), PRO_CATEGORY (Project Category), PRO_TYPE (Project Type), PRO_EXTERNAL_ID (Project Planning: External Indentifier of an Element)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

DPR_BW_DATE structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP DPR_BW_DATE structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the DPR_BW_DATE table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
GUIDProject Planning: 16-Character GUID for Projects and Activts CGPL_GUID16RAW16CGPLPCGPL_PROJECT_GUID
DATE_SETDate Type DPR_TV_DATE_SETCHAR15Assigned to domainDPR_TYPE
PRO_CATEGORYProject Category DPR_TV_PRO_CATEGORYCHAR1Assigned to domainDPR_PROJECT_CATEGORY
PRO_TYPEProject Type DPR_TV_PRO_TYPECHAR15Assigned to domainDPR_TYPEDPR_PROJECT_TYPE
PRO_EXTERNAL_IDProject Planning: External Indentifier of an Element CGPL_EXTIDCHAR24CGPL_EXTID
TEXT1Language-Dependent Description CGPL_TEXT1CHAR40TEXT40
PRIORITYPriority CGPL_PRIORITYNUMC3NUMC3
ACTUALSTARTDATEActual Start DPR_TV_ACTUAL_STARTDATS8
ACTUALFINISHDATEActual Finish DPR_TV_ACTUALFINISHDATEDATS8
PLANSTARTDATEPlanned Start DPR_TV_PLANSTARTDATEDATS8
PLANFINISHDATEPlanned Finish DPR_TV_PLANFINISHDATEDATS8
COMPLETIONPercentage of Completion CGPL_COMPLETIONNUMC3CGPL_COMPLETION
MILESTONEMilestone indicator CGPL_MILESTONECHAR1CHAR1
CONSTRAINT_TYPEType of Scheduling Constraint CGPL_CONSTRAINTCHAR1CGPL_CONSTRAINT
CONSTRAINTDATEConstraint Date DPR_TV_CONSTRAINTDATEDATS8
PLANGROUPPlanning Profile Group CGPL_SEM_PLGRPCHAR4
LATEST_STARTDATELatest Start Date DPR_TV_LATEST_STARTDATEDATS8
LATESTFINISHDATELatest Finish Date DPR_TV_LATEST_FINISHDATEDATS8
TOTAL_FLOATTotal Float CGPL_TOTAL_FLOATDEC8(2) CGPL_FLOAT
DURATIONDuration of Execution CGPL_DURATIONDEC8(2) CGPL_DURATION
DURATION_UNITTime Unit for Execution Duration CGPL_DURATION_UNITUNIT3Assigned to domainCUNITMEINS
CALENDAR_IDFactory Calendar WFCIDCHAR2Assigned to domainWFCIDFCI
CONSTR_TYPE_FINType of Scheduling Constraint CGPL_CONSTRAINTCHAR1CGPL_CONSTRAINT
CONSTR_FINDATEConstraint Date DPR_TV_CONSTRAINTDATEDATS8
WORK_EFFORTWork DPR_TV_WORKQUAN9(2) DPR_WORK
WORK_UNITUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
WORK_EFFORT_BWWork in Project Time Unit DPR_BW_TV_WORK_EFFORTQUAN9(2)
WORK_UNIT_BWProject Time Unit for Work DPR_BW_TV_WORK_EFFORT_UNITUNIT3Assigned to domainCUNITMEINS
BEG_DATEStart Date DPR_TV_START_DATEDATS8DATS
END_DATEFinish Date DPR_TV_FINISH_DATEDATS8DATS
DZONEDPR: Time Zone DPR_TV_DZONECHAR6Assigned to domainTZNZONE
UPDMODBW Delta Process: Record Mode RODMUPDMODCHAR1RODMUPDMOD
ACT_WORK_EFFORTConfirmation (Insternal Display) DPR_TV_ACT_WORKQUAN16(3) DPR_WORK_LONG
ACT_WORK_UNITUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
ACTWORKEFFORT_BWConfirmed Time in the Project Time Unit DPR_BW_TV_ACT_WORK_EFFORTQUAN16(3) DPR_WORK_LONG
ACT_WORK_UNIT_BWProject Time Unit for Confirmed Time DPR_BW_TV_ACT_WORK_EFFORT_UNITUNIT3Assigned to domainCUNITMEINS
REM_WORK_EFFORTRemaining Work DPR_TV_REM_WORKQUAN16(3) DPR_WORK_LONG
REM_WORK_UNITUnit DPR_TV_UNITUNIT3Assigned to domainCUNITMEINS
REMWORKEFFORT_BWRemaining Work Time in Project Time Unit DPR_BW_TV_REM_WORK_EFFORTQUAN16(3) DPR_WORK_LONG
REM_WORK_UNIT_BWProject Time Unit for Remaining Work Time DPR_BW_TV_REM_WORK_EFFORT_UNITUNIT3Assigned to domainCUNITMEINS
DQ_PROJECT_GUIDSelect. Field of DataSource for Delta Queue - Project GUID DPR_BW_DQ_DS_PROJECT_GUIDRAW16CGPLPCGPL_PROJECT_GUID
DQ_PHASE_GUIDSelect. Field of DataSource for Delta Queue -Parent Obj.GUID DPR_BW_DQ_DS_PHASE_GUIDRAW16CGPLPCGPL_PROJECT_GUID
DQ_OBJECT_GUIDSelect. Field of DataSource for Delta Queue - Appl. Obj.GUID DPR_BW_DQ_DS_OBJECT_GUIDRAW16CGPLPCGPL_PROJECT_GUID
DQ_ENTITY_GUIDSelection Field of DataSource for Delta Queue - Entity GUID DPR_BW_DQ_DS_ENTITY_GUIDRAW16CGPLPCGPL_PROJECT_GUID
FORECASTED_STRTForecasted Start Date DPR_TV_FORECASTED_STARTDATS8
FORECASTED_FINForecasted Finish Date DPR_TV_FORECASTED_FINISHDATS8

Key field Non-key field



How do I retrieve data from SAP structure DPR_BW_DATE using ABAP code?

As DPR_BW_DATE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DPR_BW_DATE as there is no data to select.

How to access SAP table DPR_BW_DATE

Within an ECC or HANA version of SAP you can also view further information about DPR_BW_DATE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).