I_ProjectPlanSettlement

DDL: I_PROJECTPLANSETTLEMENT Type: view_entity BASIC
63 Fields 1 Data Sources 4 Associations

Project Plan Settlement Basic

I_ProjectPlanSettlement is a Basic CDS View that provides data about "Project Plan Settlement Basic" in SAP S/4HANA. It reads from 1 data source (coej) and exposes 63 fields with key fields ControllingObject, ControllingValueType, FiscalYear, ValueCategory, ControllingBusTransacType. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
coej _PlanSettlement from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[1..*] I_WBSElementData_2 _WBSElement $projection.ControllingObject = _WBSElement.WBSElementObject
[1..*] I_NetworkActivityForCostReport _NetworkActivity $projection.ControllingObject = _NetworkActivity.NetworkActivityObject
[1..*] I_ProjectNetwork _ProjectNetwork $projection.ControllingObject = _ProjectNetwork.ProjectNetworkObject

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Project Plan Settlement Basic view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY ControllingObject coej objnr Val. Obj. No.
KEY ControllingValueType coej wrttp Value Type
KEY FiscalYear
KEY ValueCategory
KEY ControllingBusTransacType coej vrgng Bus.Transaction
KEY ControllingVersion coej versn Version
KEY TransactionCurrency coej twaer Trans. Currency
ControllingCostRevenueCode coej beltp Debit Type
ControllingArea kokrs Org. Value
ControllingAreaCurrency _ControllingArea ControllingAreaCurrency
Perd01ProjPlnAmtInTransCrcy coej wtg001 Value TranCurr
Perd02ProjPlnAmtInTransCrcy coej wtg002 Value TranCurr
Perd03ProjPlnAmtInTransCrcy coej wtg003 Value TranCurr
Perd04ProjPlnAmtInTransCrcy coej wtg004 Value TranCurr
Perd05ProjPlnAmtInTransCrcy coej wtg005 Value TranCurr
Perd06ProjPlnAmtInTransCrcy coej wtg006 Value TranCurr
Perd07ProjPlnAmtInTransCrcy coej wtg007 Value TranCurr
Perd08ProjPlnAmtInTransCrcy coej wtg008 Value TranCurr
Perd09ProjPlnAmtInTransCrcy coej wtg009 Value TranCurr
Perd10ProjPlnAmtInTransCrcy coej wtg010 Value TranCurr
Perd11ProjPlnAmtInTransCrcy coej wtg011 Value TranCurr
Perd12ProjPlnAmtInTransCrcy coej wtg012 Value TranCurr
Perd13ProjPlnAmtInTransCrcy coej wtg013 Value TranCurr
Perd14ProjPlnAmtInTransCrcy coej wtg014 Value TranCurr
Perd15ProjPlnAmtInTransCrcy coej wtg015 Value TranCurr
Perd16ProjPlnAmtInTransCrcy coej wtg016 Value TranCurr
PlanAmtInCtrlgAreaCrcy coej wkg001 Val/COArea Crcy
P02TgtAmtInCtrlgAreaCrcy coej wkg002 Val/COArea Crcy
P03TgtAmtInCtrlgAreaCrcy coej wkg003 Val/COArea Crcy
P04TgtAmtInCtrlgAreaCrcy coej wkg004 Val/COArea Crcy
P05TgtAmtInCtrlgAreaCrcy coej wkg005 Val/COArea Crcy
P06TgtAmtInCtrlgAreaCrcy coej wkg006 Val/COArea Crcy
P07TgtAmtInCtrlgAreaCrcy coej wkg007 Val/COArea Crcy
P08TgtAmtInCtrlgAreaCrcy coej wkg008 Val/COArea Crcy
P09TgtAmtInCtrlgAreaCrcy coej wkg009 Val/COArea Crcy
P10TgtAmtInCtrlgAreaCrcy coej wkg010 Val/COArea Crcy
P11TgtAmtInCtrlgAreaCrcy coej wkg011 Val/COArea Crcy
P12TgtAmtInCtrlgAreaCrcy coej wkg012 Val/COArea Crcy
P13TgtAmtInCtrlgAreaCrcy coej wkg013 Val/COArea Crcy
P14TgtAmtInCtrlgAreaCrcy coej wkg014 Val/COArea Crcy
P15TgtAmtInCtrlgAreaCrcy coej wkg015 Val/COArea Crcy
P16TgtAmtInCtrlgAreaCrcy coej wkg016 Val/COArea Crcy
Perd01ProjPlnAmtInObjCrcy coej wog001 Value/Obj. Crcy
Perd02ProjPlnAmtInObjCrcy coej wog002 Value/Obj. Crcy
Perd03ProjPlnAmtInObjCrcy coej wog003 Value/Obj. Crcy
Perd04ProjPlnAmtInObjCrcy coej wog004 Value/Obj. Crcy
Perd05ProjPlnAmtInObjCrcy coej wog005 Value/Obj. Crcy
Perd06ProjPlnAmtInObjCrcy coej wog006 Value/Obj. Crcy
Perd07ProjPlnAmtInObjCrcy coej wog007 Value/Obj. Crcy
Perd08ProjPlnAmtInObjCrcy coej wog008 Value/Obj. Crcy
Perd09ProjPlnAmtInObjCrcy coej wog009 Value/Obj. Crcy
Perd10ProjPlnAmtInObjCrcy coej wog010 Value/Obj. Crcy
Perd11ProjPlnAmtInObjCrcy coej wog011 Value/Obj. Crcy
Perd12ProjPlnAmtInObjCrcy coej wog012 Value/Obj. Crcy
Perd13ProjPlnAmtInObjCrcy coej wog013 Value/Obj. Crcy
Perd14ProjPlnAmtInObjCrcy coej wog014 Value/Obj. Crcy
Perd15ProjPlnAmtInObjCrcy coej wog015 Value/Obj. Crcy
Perd16ProjPlnAmtInObjCrcy coej wog016 Value/Obj. Crcy
PartnerControllingObject parob Partner Object
ControllingDebitCreditCode Dr/Cr indicator
_WBSElement _WBSElement
_NetworkActivity _NetworkActivity
_ProjectNetwork _ProjectNetwork

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_ProjectPlanSettlement.
-- 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.

CREATE VIEW I_ProjectPlanSettlement AS
SELECT
  _PlanSettlement.objnr AS ControllingObject,
  _PlanSettlement.wrttp AS ControllingValueType,
  cast(_PlanSettlement.gjahr as fis_gjahr_no_conv ) AS FiscalYear,
  cast( '' as acpos ) AS ValueCategory,
  _PlanSettlement.vrgng AS ControllingBusTransacType,
  _PlanSettlement.versn AS ControllingVersion,
  _PlanSettlement.twaer AS TransactionCurrency,
  _PlanSettlement.beltp AS ControllingCostRevenueCode,
  kokrs AS ControllingArea,
  _ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  _PlanSettlement.wtg001 AS Perd01ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg002 AS Perd02ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg003 AS Perd03ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg004 AS Perd04ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg005 AS Perd05ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg006 AS Perd06ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg007 AS Perd07ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg008 AS Perd08ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg009 AS Perd09ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg010 AS Perd10ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg011 AS Perd11ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg012 AS Perd12ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg013 AS Perd13ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg014 AS Perd14ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg015 AS Perd15ProjPlnAmtInTransCrcy,
  _PlanSettlement.wtg016 AS Perd16ProjPlnAmtInTransCrcy,
  _PlanSettlement.wkg001 AS PlanAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg002 AS P02TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg003 AS P03TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg004 AS P04TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg005 AS P05TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg006 AS P06TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg007 AS P07TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg008 AS P08TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg009 AS P09TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg010 AS P10TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg011 AS P11TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg012 AS P12TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg013 AS P13TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg014 AS P14TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg015 AS P15TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wkg016 AS P16TgtAmtInCtrlgAreaCrcy,
  _PlanSettlement.wog001 AS Perd01ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog002 AS Perd02ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog003 AS Perd03ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog004 AS Perd04ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog005 AS Perd05ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog006 AS Perd06ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog007 AS Perd07ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog008 AS Perd08ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog009 AS Perd09ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog010 AS Perd10ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog011 AS Perd11ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog012 AS Perd12ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog013 AS Perd13ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog014 AS Perd14ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog015 AS Perd15ProjPlnAmtInObjCrcy,
  _PlanSettlement.wog016 AS Perd16ProjPlnAmtInObjCrcy,
  parob AS PartnerControllingObject,
  cast(beknz as co_belkz) AS ControllingDebitCreditCode
FROM coej AS _PlanSettlement
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElementData_2 AS _WBSElement ON ControllingObject = _WBSElement.WBSElementObject  -- association [1..*]
LEFT OUTER JOIN I_NetworkActivityForCostReport AS _NetworkActivity ON ControllingObject = _NetworkActivity.NetworkActivityObject  -- association [1..*]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON ControllingObject = _ProjectNetwork.ProjectNetworkObject  -- association [1..*]
;

Learn More