I_MstrProjActlStatisticKeyFig

DDL: I_MSTRPROJACTLSTATISTICKEYFIG SQL: IMSTRPROJACTLSKF Type: view COMPOSITE
42 Fields 3 Data Sources

Commercial Project Output SKF Actuals

I_MstrProjActlStatisticKeyFig is a Composite CDS View that provides data about "Commercial Project Output SKF Actuals" in SAP S/4HANA. It reads from 3 data sources (I_ActlStatisticKeyFig, I_WorkforcePerson, P_MstrProjHierWithStstclKeyFig) and exposes 42 fields with key fields MasterProjectUUID, MasterProject.

Data Sources (3)

SourceAliasJoin Type
I_ActlStatisticKeyFig ActlStatisticKeyFig inner
I_WorkforcePerson Employee left_outer
P_MstrProjHierWithStstclKeyFig MstrProjHierarchy from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMSTRPROJACTLSKF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Commercial Project Output SKF Actuals view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY MasterProjectUUID P_MstrProjHierWithStstclKeyFig MasterProjectUUID NodeID
KEY MasterProject P_MstrProjHierWithStstclKeyFig MasterProject Project ID
MasterProjectName P_MstrProjHierWithStstclKeyFig MasterProjectName
MasterProjectOrganization P_MstrProjHierWithStstclKeyFig MasterProjectOrganization
MasterProjectIsConfidential P_MstrProjHierWithStstclKeyFig MasterProjectIsConfidential
MasterProjectType P_MstrProjHierWithStstclKeyFig MasterProjectType
Currency P_MstrProjHierWithStstclKeyFig Currency Valuation Crcy
Project P_MstrProjHierWithStstclKeyFig Project WBS Element
ProjectDescription P_MstrProjHierWithStstclKeyFig ProjectDescription Project Name
BusinessArea P_MstrProjHierWithStstclKeyFig BusinessArea Business Area
CompanyCode P_MstrProjHierWithStstclKeyFig CompanyCode Receiver Company Code
ControllingArea P_MstrProjHierWithStstclKeyFig ControllingArea Controlling Area
ControllingObjectendasControllingObject
ObjectName P_MstrProjHierWithStstclKeyFig ObjectName Object name
MstrProjAnchorObjectInternalID P_MstrProjHierWithStstclKeyFig MstrProjAnchorObjectInternalID
MstrProjCutOffDate P_MstrProjHierWithStstclKeyFig MstrProjCutOffDate
_MstrProjType P_MstrProjHierWithStstclKeyFig _MstrProjType
MasterProjectFiscalYearVariant
FinancialPlanUUID
FinancialPlanVersUUID
FinancialPlanInternalID
FinancialPlanID
FinancialPlanScenario
FinancialPlanType
FinancialPlanCurrency
FinancialPlanStartDate
FinancialPlanEndDate
FinancialPlanVersion
MstrProjPerdStrtDte
MstrProjPerdEndDte
AccountingDocument I_ActlStatisticKeyFig AccountingDocument Journal Entry
PostingPeriod I_ActlStatisticKeyFig PostingPeriod Posting Period
DocumentDate I_ActlStatisticKeyFig DocumentDate Journal Entry Date
YearMonth
StatisticalKeyFigureQuantity I_ActlStatisticKeyFig StatisticalKeyFigureQuantity Statistical qty
StstcKeyFigQuantityUnit I_ActlStatisticKeyFig StstcKeyFigQuantityUnit Quantity Unit
StatisticalKeyFigure I_ActlStatisticKeyFig StatisticalKeyFigure Statistical Key Figure
FiscalYear I_ActlStatisticKeyFig FiscalYear G/L Fiscal Year
PersonnelNumberendasPersonnelNumber
PostingDate I_ActlStatisticKeyFig PostingDate Posting Date for GR
ControllingAreaCurrency I_ActlStatisticKeyFig ControllingAreaCurrency Global Currency
IsReversalDocument I_ActlStatisticKeyFig IsReversalDocument Reverse

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_MstrProjActlStatisticKeyFig.
-- 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: IMSTRPROJACTLSKF

CREATE VIEW I_MstrProjActlStatisticKeyFig AS
SELECT
  MstrProjHierarchy.MasterProjectUUID AS MasterProjectUUID,
  MstrProjHierarchy.MasterProject AS MasterProject,
  MstrProjHierarchy.MasterProjectName AS MasterProjectName,
  MstrProjHierarchy.MasterProjectOrganization AS MasterProjectOrganization,
  MstrProjHierarchy.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MstrProjHierarchy.MasterProjectType AS MasterProjectType,
  MstrProjHierarchy.Currency AS Currency,
  MstrProjHierarchy.Project AS Project,
  MstrProjHierarchy.ProjectDescription AS ProjectDescription,
  MstrProjHierarchy.BusinessArea AS BusinessArea,
  MstrProjHierarchy.CompanyCode AS CompanyCode,
  MstrProjHierarchy.ControllingArea AS ControllingArea,
  case when MstrProjHierarchy.ControllingObjectType = 'OR' then MstrProjHierarchy.WBSElementObject else MstrProjHierarchy.ControllingObject end as ControllingObject AS ControllingObjectendasControllingObject,
  MstrProjHierarchy.ObjectName AS ObjectName,
  MstrProjHierarchy.MstrProjAnchorObjectInternalID AS MstrProjAnchorObjectInternalID,
  MstrProjHierarchy.MstrProjCutOffDate AS MstrProjCutOffDate,
  MstrProjHierarchy._MstrProjType AS _MstrProjType,
  MstrProjHierarchy._MstrProjType.MasterProjectFiscalYearVariant AS MasterProjectFiscalYearVariant,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanUUID AS FinancialPlanUUID,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanVersUUID AS FinancialPlanVersUUID,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanInternalID AS FinancialPlanInternalID,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanID AS FinancialPlanID,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanScenario AS FinancialPlanScenario,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanType AS FinancialPlanType,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanCurrency AS FinancialPlanCurrency,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanStartDate AS FinancialPlanStartDate,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanEndDate AS FinancialPlanEndDate,
  MstrProjHierarchy._MstrProjFinPlan.FinancialPlanVersion AS FinancialPlanVersion,
  MstrProjHierarchy._MstrProjPerdKPI.MstrProjPerdStrtDte AS MstrProjPerdStrtDte,
  MstrProjHierarchy._MstrProjPerdKPI.MstrProjPerdEndDte AS MstrProjPerdEndDte,
  ActlStatisticKeyFig.AccountingDocument AS AccountingDocument,
  ActlStatisticKeyFig.PostingPeriod AS PostingPeriod,
  ActlStatisticKeyFig.DocumentDate AS DocumentDate,
  Substring(ActlStatisticKeyFig.PostingDate, 1, 6) AS YearMonth,
  ActlStatisticKeyFig.StatisticalKeyFigureQuantity AS StatisticalKeyFigureQuantity,
  ActlStatisticKeyFig.StstcKeyFigQuantityUnit AS StstcKeyFigQuantityUnit,
  ActlStatisticKeyFig.StatisticalKeyFigure AS StatisticalKeyFigure,
  ActlStatisticKeyFig.FiscalYear AS FiscalYear,
  case when Employee.IsBusinessPurposeCompleted = 'X' then '*****' else ActlStatisticKeyFig.PersonnelNumber end as PersonnelNumber AS PersonnelNumberendasPersonnelNumber,
  ActlStatisticKeyFig.PostingDate AS PostingDate,
  ActlStatisticKeyFig.ControllingAreaCurrency AS ControllingAreaCurrency,
  ActlStatisticKeyFig.IsReversalDocument AS IsReversalDocument
FROM P_MstrProjHierWithStstclKeyFig AS MstrProjHierarchy
INNER JOIN I_ActlStatisticKeyFig AS ActlStatisticKeyFig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkforcePerson AS Employee ON /* join condition not captured in parsed metadata */
;

Learn More