P_ENGMNTPROJSALESPLANDATA

DDL: P_ENGMNTPROJSALESPLANDATA SQL: PEPROJSLSPLDATA Type: view COMPOSITE
35 Fields 1 Data Sources 2 Associations

P_ENGMNTPROJSALESPLANDATA is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_EngagementProject) and exposes 35 fields. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EngagementProject EngagementProject from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ControllingArea _ControllingArea $projection.ControllingArea = _ControllingArea.ControllingArea
[0..1] I_SalesOrderItem _SalesOrderItem $projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PEPROJSLSPLDATA view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (35)

KeyFieldSource TableSource FieldDescription
EngagementProject
ProjectStartDate I_EngagementProject ProjectStartDate Latest Planned Start
ProjectEndDate I_EngagementProject ProjectEndDate Ltst Planned Finish
Customer I_EngagementProject Customer Sold-to Party
EngagementProjectType I_EngagementProject EngagementProjectType
EngagementProjectStage I_EngagementProject EngagementProjectStage Stage
EngagementProjectServiceOrg I_EngagementProject EngagementProjectServiceOrg Service Org.
EngagementProjectCategory ProjectSalesMargin EngagementProjectCategory
CompanyCode I_EngagementProject CompanyCode Receiver Company Code
Country
SalesOrder ProjectSalesMargin SalesOrder SD Document
SalesOrderItem ProjectSalesMargin SalesOrderItem Sales Order Item
SalesOrderItemCategory _SalesOrderItem SalesOrderItemCategory Item Category
ControllingArea I_EngagementProject ControllingArea Controlling Area
ControllingAreaCurrency _ControllingArea ControllingAreaCurrency
ProfitCenter I_EngagementProject ProfitCenter Profit Center
EngmtProjEmployeeIsStaffed ProjectSalesMargin EngmtProjEmployeeIsStaffed Confirmation of staffed Employee
EngmtProjFinPlanVersion ProjectSalesMargin EngmtProjFinPlanVersion Plan Version ID
AccountingDocumentStatus ProjectSalesMargin AccountingDocumentStatus
UnitOfMeasure ProjectSalesMargin UnitOfMeasure Unit Protected Qty
BaseUnit ProjectSalesMargin BaseUnit Unit of Measure
ActlEffortQty ProjectSalesMargin ActlEffortQty
BilledEffort ProjectSalesMargin BilledEffort
PlndEffortQty ProjectSalesMargin PlndEffortQty Total Quantity
FiscalPeriod ProjectSalesMargin FiscalPeriod Tax period
FiscalYear ProjectSalesMargin FiscalYear G/L Fiscal Year
FiscalYearPeriod ProjectSalesMargin FiscalYearPeriod Period/Year
PersonnelNumber ProjectSalesMargin PersonnelNumber Personnel No.
Currency ProjectSalesMargin Currency Valuation Crcy
CompanyCodeCurrency ProjectSalesMargin CompanyCodeCurrency Local Currency
ActlRevnInCoCodeCrcy ProjectSalesMargin ActlRevnInCoCodeCrcy
ActlCostInCoCodeCrcy ProjectSalesMargin ActlCostInCoCodeCrcy
EngmntProjPlanLineType ProjectSalesMargin EngmntProjPlanLineType Line type
EngagementProjectResourceType ProjectSalesMargin EngagementProjectResourceType ResourceTypeID
IsMyProject ProjectSalesMargin IsMyProject

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 P_ENGMNTPROJSALESPLANDATA.
-- 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: PEPROJSLSPLDATA

CREATE VIEW P_ENGMNTPROJSALESPLANDATA AS
SELECT
  cast(EngagementProject.EngagementProject as /cpd/project preserving type ) AS EngagementProject,
  EngagementProject.ProjectStartDate AS ProjectStartDate,
  EngagementProject.ProjectEndDate AS ProjectEndDate,
  EngagementProject.Customer AS Customer,
  EngagementProject.EngagementProjectType AS EngagementProjectType,
  EngagementProject.EngagementProjectStage AS EngagementProjectStage,
  EngagementProject.EngagementProjectServiceOrg AS EngagementProjectServiceOrg,
  ProjectSalesMargin.EngagementProjectCategory AS EngagementProjectCategory,
  EngagementProject.CompanyCode AS CompanyCode,
  EngagementProject._CompanyCode.Country AS Country,
  ProjectSalesMargin.SalesOrder AS SalesOrder,
  ProjectSalesMargin.SalesOrderItem AS SalesOrderItem,
  _SalesOrderItem.SalesOrderItemCategory AS SalesOrderItemCategory,
  EngagementProject.ControllingArea AS ControllingArea,
  _ControllingArea.ControllingAreaCurrency AS ControllingAreaCurrency,
  EngagementProject.ProfitCenter AS ProfitCenter,
  ProjectSalesMargin.EngmtProjEmployeeIsStaffed AS EngmtProjEmployeeIsStaffed,
  ProjectSalesMargin.EngmtProjFinPlanVersion AS EngmtProjFinPlanVersion,
  ProjectSalesMargin.AccountingDocumentStatus AS AccountingDocumentStatus,
  ProjectSalesMargin.UnitOfMeasure AS UnitOfMeasure,
  ProjectSalesMargin.BaseUnit AS BaseUnit,
  ProjectSalesMargin.ActlEffortQty AS ActlEffortQty,
  ProjectSalesMargin.BilledEffort AS BilledEffort,
  ProjectSalesMargin.PlndEffortQty AS PlndEffortQty,
  ProjectSalesMargin.FiscalPeriod AS FiscalPeriod,
  ProjectSalesMargin.FiscalYear AS FiscalYear,
  ProjectSalesMargin.FiscalYearPeriod AS FiscalYearPeriod,
  ProjectSalesMargin.PersonnelNumber AS PersonnelNumber,
  ProjectSalesMargin.Currency AS Currency,
  ProjectSalesMargin.CompanyCodeCurrency AS CompanyCodeCurrency,
  ProjectSalesMargin.ActlRevnInCoCodeCrcy AS ActlRevnInCoCodeCrcy,
  ProjectSalesMargin.ActlCostInCoCodeCrcy AS ActlCostInCoCodeCrcy,
  ProjectSalesMargin.EngmntProjPlanLineType AS EngmntProjPlanLineType,
  ProjectSalesMargin.EngagementProjectResourceType AS EngagementProjectResourceType,
  ProjectSalesMargin.IsMyProject AS IsMyProject
FROM I_EngagementProject AS EngagementProject
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [0..1]
;

Learn More