I_CustomerProjectPlanData

DDL: I_CUSTOMERPROJECTPLANDATA SQL: ICUSTPROJPLAN Type: view COMPOSITE
22 Fields 2 Data Sources 4 Associations

Customer Project Planning Data

I_CustomerProjectPlanData is a Composite CDS View that provides data about "Customer Project Planning Data" in SAP S/4HANA. It reads from 2 data sources (I_CustomerProject, I_EngmntProjectPlnDataVersion) and exposes 22 fields with key fields PlanLineItemUUID, CustProjFinancialPlanUUID, CustProjWorkPackageUUID, CustProjFinancialPlanVersion, CustomerProjectResourceType. It has 4 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_CustomerProject CustomerProject left_outer
I_EngmntProjectPlnDataVersion PlanData from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
[0..*] I_CustProjResourceText _CustProjResourceText $projection.CustomerProjectResource = _CustProjResourceText.CustomerProjectResource
[0..1] I_CustProjWrkPckgText _CustProjWrkPckgText $projection.CustProjWorkPackageUUID = _CustProjWrkPckgText.CustProjWorkPackageUUID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPROJPLAN view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Customer Project Planning Data view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PlanLineItemUUID PlanLineItemUUID Planning Line GUID
KEY CustProjFinancialPlanUUID
KEY CustProjWorkPackageUUID
KEY CustProjFinancialPlanVersion
KEY CustomerProjectResourceType
KEY FiscalPeriod I_EngmntProjectPlnDataVersion FiscalPeriod Tax period
KEY FiscalYear I_EngmntProjectPlnDataVersion FiscalYear G/L Fiscal Year
KEY CustomerProjectResource
KEY PersonnelNumber I_EngmntProjectPlnDataVersion EmploymentInternalID WorkForce Assgmt ID
KEY CustProjWorkPckgEmplIsStaffed I_EngmntProjectPlnDataVersion EngmtProjEmployeeIsStaffed Confirmation of staffed Employee
CustomerProject I_CustomerProject CustomerProject Engmnt Project ID
CustomerProjectType I_CustomerProject CustomerProjectType
CustomerProjectServiceOrg I_CustomerProject CustomerProjectServiceOrg Service Org.
Currency I_EngmntProjectPlnDataVersion Currency Valuation Crcy
CustProjWrkPckgPlanCost I_EngmntProjectPlnDataVersion PlndCostAmt Amount
UnitOfMeasure I_EngmntProjectPlnDataVersion UnitOfMeasure Unit Protected Qty
CustProjWrkPckgPlanEffortQty I_EngmntProjectPlnDataVersion PlndEffortQty Total Quantity
CustProjWrkPckgPlanRevenue I_EngmntProjectPlnDataVersion PlndRevnAmt Amount
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
_CustProjResourceText _CustProjResourceText
_CustProjWrkPckgText _CustProjWrkPckgText

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_CustomerProjectPlanData.
-- 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: ICUSTPROJPLAN

CREATE VIEW I_CustomerProjectPlanData AS
SELECT
  PlanLineItemUUID,
  cast(PlanData.EngagementProjFinPlanUUID as /cpd/ss_cp_fp_uuid ) AS CustProjFinancialPlanUUID,
  cast(PlanData.WorkPackageUUID as /cpd/ss_cp_wp_uuid ) AS CustProjWorkPackageUUID,
  cast(PlanData.EngmtProjFinPlanVersion as /cpd/ss_cp_fp_version ) AS CustProjFinancialPlanVersion,
  cast(PlanData.EngagementProjectResourceType as /cpd/ss_cp_res_typ ) AS CustomerProjectResourceType,
  PlanData.FiscalPeriod AS FiscalPeriod,
  PlanData.FiscalYear AS FiscalYear,
  cast(PlanData.EngagementProjectResource as /cpd/ss_cp_resource ) AS CustomerProjectResource,
  PlanData.EmploymentInternalID AS PersonnelNumber,
  PlanData.EngmtProjEmployeeIsStaffed AS CustProjWorkPckgEmplIsStaffed,
  CustomerProject.CustomerProject AS CustomerProject,
  CustomerProject.CustomerProjectType AS CustomerProjectType,
  CustomerProject.CustomerProjectServiceOrg AS CustomerProjectServiceOrg,
  PlanData.Currency AS Currency,
  PlanData.PlndCostAmt AS CustProjWrkPckgPlanCost,
  PlanData.UnitOfMeasure AS UnitOfMeasure,
  PlanData.PlndEffortQty AS CustProjWrkPckgPlanEffortQty,
  PlanData.PlndRevnAmt AS CustProjWrkPckgPlanRevenue
FROM I_EngmntProjectPlnDataVersion AS PlanData
LEFT OUTER JOIN I_CustomerProject AS CustomerProject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CustProjResourceText AS _CustProjResourceText ON CustomerProjectResource = _CustProjResourceText.CustomerProjectResource  -- association [0..*]
LEFT OUTER JOIN I_CustProjWrkPckgText AS _CustProjWrkPckgText ON CustProjWorkPackageUUID = _CustProjWrkPckgText.CustProjWorkPackageUUID  -- association [0..1]
;

Learn More