Deprecated PUBLIC_LOCAL_API
This CDS view is deprecated in S/4HANA. Use I_PeriodStatisticalKeyFigure instead. View all deprecated CDS views →

I_ProgressData

DDL: I_PROGRESSDATA SQL: IPROGSDATA Type: view BASIC
23 Fields 1 Data Sources

Progress Data

I_ProgressData is a Basic CDS View that provides data about "Progress Data" in SAP S/4HANA. It reads from 1 data source (P_Cosr) and exposes 23 fields.

Data Sources (1)

SourceAliasJoin Type
P_Cosr P_Cosr from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPROGSDATA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Progress Data view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.lifecycle.successor I_PeriodStatisticalKeyFigure view

Fields (23)

KeyFieldSource TableSource FieldDescription
WBSElementObject I_WBSElement WBSElementObject Object number
WBSElementInternalID I_WBSElement WBSElementInternalID WBS Internal ID
ProjectInternalID I_WBSElement ProjectInternalID Project Def.
ControllingArea I_WBSElement ControllingArea Controlling Area
ControllingValueType P_Cosr ControllingValueType Value Type
StatisticalKeyFigure P_Cosr StatisticalKeyFigure Statistical Key Figure
UnitOfMeasure P_Cosr UnitOfMeasure Unit Protected Qty
CtrlgObjStstcKeyFigP01Qty P_Cosr CtrlgObjStstcKeyFigP01Qty Statistical qty
CtrlgObjStstcKeyFigP02Qty P_Cosr CtrlgObjStstcKeyFigP02Qty Statistical qty
CtrlgObjStstcKeyFigP03Qty P_Cosr CtrlgObjStstcKeyFigP03Qty Statistical qty
CtrlgObjStstcKeyFigP04Qty P_Cosr CtrlgObjStstcKeyFigP04Qty Statistical qty
CtrlgObjStstcKeyFigP05Qty P_Cosr CtrlgObjStstcKeyFigP05Qty Statistical qty
CtrlgObjStstcKeyFigP06Qty P_Cosr CtrlgObjStstcKeyFigP06Qty Statistical qty
CtrlgObjStstcKeyFigP07Qty P_Cosr CtrlgObjStstcKeyFigP07Qty Statistical qty
CtrlgObjStstcKeyFigP08Qty P_Cosr CtrlgObjStstcKeyFigP08Qty Statistical qty
CtrlgObjStstcKeyFigP09Qty P_Cosr CtrlgObjStstcKeyFigP09Qty Statistical qty
CtrlgObjStstcKeyFigP10Qty P_Cosr CtrlgObjStstcKeyFigP10Qty Statistical qty
CtrlgObjStstcKeyFigP11Qty P_Cosr CtrlgObjStstcKeyFigP11Qty Statistical qty
CtrlgObjStstcKeyFigP12Qty P_Cosr CtrlgObjStstcKeyFigP12Qty Statistical qty
FiscalYear P_Cosr FiscalYear G/L Fiscal Year
CurrentYear
CurrentMonth
ProgressVersion P_Cosr Version XML Vers.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ProgressData.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPROGSDATA

CREATE VIEW I_ProgressData AS
SELECT
  I_WBSElement.WBSElementObject AS WBSElementObject,
  I_WBSElement.WBSElementInternalID AS WBSElementInternalID,
  I_WBSElement.ProjectInternalID AS ProjectInternalID,
  I_WBSElement.ControllingArea AS ControllingArea,
  P_Cosr.ControllingValueType AS ControllingValueType,
  P_Cosr.StatisticalKeyFigure AS StatisticalKeyFigure,
  P_Cosr.UnitOfMeasure AS UnitOfMeasure,
  P_Cosr.CtrlgObjStstcKeyFigP01Qty AS CtrlgObjStstcKeyFigP01Qty,
  P_Cosr.CtrlgObjStstcKeyFigP02Qty AS CtrlgObjStstcKeyFigP02Qty,
  P_Cosr.CtrlgObjStstcKeyFigP03Qty AS CtrlgObjStstcKeyFigP03Qty,
  P_Cosr.CtrlgObjStstcKeyFigP04Qty AS CtrlgObjStstcKeyFigP04Qty,
  P_Cosr.CtrlgObjStstcKeyFigP05Qty AS CtrlgObjStstcKeyFigP05Qty,
  P_Cosr.CtrlgObjStstcKeyFigP06Qty AS CtrlgObjStstcKeyFigP06Qty,
  P_Cosr.CtrlgObjStstcKeyFigP07Qty AS CtrlgObjStstcKeyFigP07Qty,
  P_Cosr.CtrlgObjStstcKeyFigP08Qty AS CtrlgObjStstcKeyFigP08Qty,
  P_Cosr.CtrlgObjStstcKeyFigP09Qty AS CtrlgObjStstcKeyFigP09Qty,
  P_Cosr.CtrlgObjStstcKeyFigP10Qty AS CtrlgObjStstcKeyFigP10Qty,
  P_Cosr.CtrlgObjStstcKeyFigP11Qty AS CtrlgObjStstcKeyFigP11Qty,
  P_Cosr.CtrlgObjStstcKeyFigP12Qty AS CtrlgObjStstcKeyFigP12Qty,
  P_Cosr.FiscalYear AS FiscalYear,
  substring( cast( TSTMP_CURRENT_UTCTIMESTAMP () as abap.char(17) ), 1, 4 ) AS CurrentYear,
  substring( cast( TSTMP_CURRENT_UTCTIMESTAMP () as abap.char(17) ), 5, 2 ) AS CurrentMonth,
  P_Cosr.Version AS ProgressVersion
FROM P_Cosr
;

Learn More