SAP DPR_TS_CTRLPLAN_V_EXT Control Plan: Version Attributes (External) Table data and field list

DPR_TS_CTRLPLAN_V_EXT 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 "Control Plan: Version Attributes (External)" 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_TS_CTRLPLAN_V_EXT TYPE DPR_TS_CTRLPLAN_V_EXT.

The DPR_TS_CTRLPLAN_V_EXT table consists of various fields, each holding specific information or linking keys about Control Plan: Version Attributes (External) data available in SAP. These include GUID (Application Object GUID), EXTERNAL_ID (Project Planning: External Indentifier of an Element), LAST_CHANGE_DATE (Date of Last Change), LAST_CHANGE_TIME (Last Changed at)... 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_TS_CTRLPLAN_V_EXT structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP DPR_TS_CTRLPLAN_V_EXT 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_TS_CTRLPLAN_V_EXT 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
GUIDApplication Object GUID DPR_TV_GUIDRAW16DPR_GUID
EXTERNAL_IDProject Planning: External Indentifier of an Element CGPL_EXTIDCHAR24CGPL_EXTID
LAST_CHANGE_DATEDate of Last Change DPR_TV_LAST_CHANGE_DATEDATS8
LAST_CHANGE_TIMELast Changed at DPR_TV_LAST_CHANGE_TIMETIMS6
PROJECT_GUIDProject Planning: 16 Character GUID for Projects CGPL_PROJECT_GUIDRAW16CGPLPCGPL_PROJECT_GUID
OBJECT_TYPEObject Type in Project Planning CGPL_OBJECT_TYPECHAR3CHAR3
PRIORITYPriority CGPL_PRIORITYNUMC3CGPL_PRIONUMC3
ACTUALSTARTActual Start Date CGPL_ACTUALSTARTDEC15TSTPSBCOS_TSTMP
ACTUALFINISHActual Finish Date CGPL_ACTUALFINISHDEC15TSTPSBCOS_TSTMP
PLANSTARTPlanned start date CGPL_PLANSTARTDEC15TSTPSBCOS_TSTMP
PLANFINISHPlanned Finish Date CGPL_PLANFINISHDEC15TSTPSBCOS_TSTMP
COMPLETIONPercentage of Completion CGPL_COMPLETIONNUMC3CGPL_COMPLETION
MILESTONEMilestone indicator CGPL_MILESTONECHAR1CHAR1
CONSTRAINT_TYPEType of Scheduling Constraint CGPL_CONSTRAINTCHAR1CGPL_CONSTRAINT
CONSTRAINT_TIMEConstraint Date CGPL_CONSTRAINT_TIMEDEC15TSTPSBCOS_TSTMP
CREATED_BYName of Person Who Created Object CGPL_CREATED_BYCHAR12USNAM
CREATED_ONDate When the Object Was Created CGPL_CREATED_ONDATS8DATUM
CREATED_IN_BWTransfer Object to BW CGPL_CREATED_BWCHAR1CHAR1
CHANGED_BYName of Person Who Changed Object CGPL_CHANGED_BYCHAR12USNAM
CHANGED_ONDate on which object was last changed CGPL_CHANGED_ONDATS8DATUM
UPDATED_IN_BWCurrent Object in BW CGPL_UPDATED_BWCHAR1CHAR1
BWIDENTIFIERProject Planning - BW Identification CGPL_BWIDENTIFIERNUMC8CGPL_BWIDENTIFIER
PLANGROUPPlanning Profile Group CGPL_SEM_PLGRPCHAR4
LATEST_STARTLatest start CGPL_LATEST_STARTDEC15TSTPSBCOS_TSTMP
LATEST_FINISHLatest finish date CGPL_LATEST_FINISHDEC15TSTPSBCOS_TSTMP
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_TIME_FINConstraint Date CGPL_CONSTRAINT_TIMEDEC15TSTPSBCOS_TSTMP
APPLICATIONApplication in Project Planning CGPL_APPLICATION_TYPECHAR3Assigned to domainCGPL_APPLICATION_TYPE
FORECAST_STARTForecast Start CGPL_FORECAST_STARTDEC15TSTPSBCOS_TSTMP
FORECAST_FINISHForecast Finish CGPL_FORECAST_FINISHDEC15TSTPSBCOS_TSTMP
PROC_STATUS_OWNObject Processing Status DPR_TV_PROC_STATUS_OWNCHAR2DPR_PROC_STATUS
PROC_STATUS_SUPProcessing Status of Higher-Level Object DPR_TV_PROC_STATUS_SUPCHAR2DPR_PROC_STATUS
OBJNRGUID of a CRM Order Object CRMT_OBJECT_GUIDRAW16SYSUUID
ISTATSystem status J_ISTATCHAR5Assigned to domainJ_ISTAT
ESTATUser Status J_ESTATCHAR5Assigned to domainJ_ESTAT
STSMAStatus Profile J_STSMACHAR8Assigned to domainJ_STSMA
SPRASLanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
TXT04Individual status of an object (short form) J_TXT04CHAR4TEXT4
TXT30Object status J_TXT30CHAR30TEXT30
STATTXTConcatenated Status Text of an Object DPR_TV_STATUS_TXTSTRG0
GUID_CHARUnique Object Key DPR_TV_OBJECT_GUID_CHARCHAR32SYSUUID_C
CREATED_BY_NAMEName of Person Who Created the Project Element DPR_TV_CREATED_BY_NAMECHAR80TEXT80
CHANGED_BY_NAMEName of Person Who Last Changed the Project Element DPR_TV_CHANGED_BY_NAMECHAR80TEXT80
VERSIONControl Plan Version DPR_TV_CP_VERSIONCHAR10DPR_CP_VERSION
VERSION_NUMBERVersion Number CGPL_TV_VERSIONCHAR24CGPL_VERSION
CATEGORYControl Plan Stage/Category DPR_TV_CP_STAGECHAR15DPR_STAGE
PART_IDPart Number/Last Change Status DPR_TV_CP_PART_IDCHAR40DPR_CP_PART_ID
PART_TEXTName and Description of Product/Process to Be Monitored DPR_TV_CP_PART_TEXTCHAR40DPR_CP_PART_TEXT
SUPPLIER_TEXTVendor Location DPR_TV_CP_SUPPLIER_TEXTCHAR40DPR_CP_SUPPLIER_TEXT
SUPPLIER_IDIdentification Key of Vendor in Control Plan DPR_TV_CP_SUPPLIER_IDCHAR20DPR_CP_SUPPLIER_ID
KEY_CONTACTControl Plan: Contact Person/Telephone DPR_TV_CP_KEY_CONTACTCHAR40DPR_CP_KEY_CONTACT
CORE_TEAMCore Team in Control Plan DPR_TV_CP_CORE_TEAMCHAR40DPR_CP_CORE_TEAM
SUPPLIER_INFORelease of Date and Person Responsible DPR_TV_CP_SUPPLIER_INFOCHAR40DPR_CP_SUPPLIER_INFO
APPROVED_ON_1Date for Further Release in the Control Plan (if Required) DPR_TV_CP_APPROVED_DTDATS8DATS
RELEASED_ONDate of First Release in Control Plan DPR_TV_CP_RELEASED_DTDATS8DATS
REL_BY_CUST_1Date of Release by Customer Development/Quality DPR_TV_CP_CUSTOMER_DTDATS8DATS
REL_BY_CUST_2Date of Release by Customer Development/Quality DPR_TV_CP_CUSTOMER_DTDATS8DATS
APPROVED_ON_2Date for Further Release in the Control Plan (if Required) DPR_TV_CP_APPROVED_DTDATS8DATS
STAT_PROFILE_CPStatus Profile Template DPR_TV_STAT_PROFILE_CPCHAR8Assigned to domainJ_STSMA
OBJ_GENERATEDObjects in Control Plan Were Generated (BAdI) DPR_TV_CP_OBJECTS_GENERATEDCHAR1CHAR1
EA_DUMMYDummy Data Element for Enhanced Proj. Mgmt Attributes DPR_TV_EA_DUMMYCHAR1CHAR1
DESCRIPTIONLanguage-Dependent Description CGPL_TEXT1CHAR40TEXT40

Key field Non-key field



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

As DPR_TS_CTRLPLAN_V_EXT 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_TS_CTRLPLAN_V_EXT as there is no data to select.

How to access SAP table DPR_TS_CTRLPLAN_V_EXT

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

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