P_EngmtProjActuals

DDL: P_ENGMTPROJACTUALS SQL: PEPACTS Type: view COMPOSITE
48 Fields 3 Data Sources

P_EngmtProjActuals is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_EngmntProjAssgmtToSessionUsr, I_Ledger, P_EngmntProjGLAcctRawData) and exposes 48 fields.

Data Sources (3)

SourceAliasJoin Type
I_EngmntProjAssgmtToSessionUsr A from
I_Ledger Ledger inner
P_EngmntProjGLAcctRawData ProjectActuals inner

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PEPACTS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (48)

KeyFieldSource TableSource FieldDescription
Project P_EngmntProjGLAcctRawData Project WBS Element
WBSElement P_EngmntProjGLAcctRawData WBSElement WBS Internal ID
ControllingObject P_EngmntProjGLAcctRawData ControllingObject Object number
WorkPackage P_EngmntProjGLAcctRawData WorkPackage Plan Item
WorkItem P_EngmntProjGLAcctRawData WorkItem Work Item ID
PartnerCompanyCode EmpOrg CompanyCode Receiver Company Code
PartnerCostCenter EmpOrg CostCenter Cost Center
StartDate EmpOrg StartDate Valid From
EndDate EmpOrg EndDate Term to
EngagementProjFinPlanUUID I_EngmntProjAssgmtToSessionUsr EngagementProjFinPlanUUID Engagement Project
IsMyProject I_EngmntProjAssgmtToSessionUsr IsMyProject
Currency I_EngmntProjAssgmtToSessionUsr Currency Valuation Crcy
SalesOrder P_EngmntProjGLAcctRawData SalesDocument SD Document
SalesOrderItem P_EngmntProjGLAcctRawData SalesDocumentItem Sales Document Item
Material P_EngmntProjGLAcctRawData Product Product Sold
ClearingAccountingDocument Receivables ClearingAccountingDocument Clearing Journal Entry
GLAccount P_EngmntProjGLAcctRawData GLAccount General Ledger
ChartOfAccounts P_EngmntProjGLAcctRawData ChartOfAccounts Node Class
ControllingObjectDebitType P_EngmntProjGLAcctRawData ControllingObjectDebitType
BusinessTransactionType P_EngmntProjGLAcctRawData BusinessTransactionType Bus.transaction
PersonnelNumber P_EngmntProjGLAcctRawData PersonnelNumber Personnel No.
ValuationQuantityendasValuationQuantity
CostSourceUnitendasBaseUnit
FiscalYearPeriod P_EngmntProjGLAcctRawData FiscalYearPeriod Period/Year
PostingDate P_EngmntProjGLAcctRawData PostingDate Posting Date for GR
FiscalYear
FiscalPeriod
CompanyCodeCurrency P_EngmntProjGLAcctRawData CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency P_EngmntProjGLAcctRawData AmountInCompanyCodeCurrency Local Crcy Amt
CostSourceUnit P_EngmntProjGLAcctRawData CostSourceUnit
Quantity P_EngmntProjGLAcctRawData Quantity Value
PartnerCompanyCodeendasCompanyCode
PartnerCostCenterendasCostCenter
ControllingArea P_EngmntProjGLAcctRawData ControllingArea Controlling Area
Ledger P_EngmntProjGLAcctRawData SourceLedger Source Ledger
IsLeadingLedger I_Ledger IsLeadingLedger Leading Ledger
EngagementProjectCategory I_EngmntProjAssgmtToSessionUsr EngagementProjectCategory
CustomerProjectServiceOrg I_EngmntProjAssgmtToSessionUsr EngagementProjectServiceOrg Service Org.
Customer I_EngmntProjAssgmtToSessionUsr Customer Sold-to Party
ProjectVisibility I_EngmntProjAssgmtToSessionUsr ProjectVisibility
EngagementProjectStage I_EngmntProjAssgmtToSessionUsr EngagementProjectStage
ProjectProfileCode I_EngmntProjAssgmtToSessionUsr ProjectProfileCode Project Profile
EngagementProjectType I_EngmntProjAssgmtToSessionUsr EngagementProjectType
EngmntProjectHeaderCompanyCode I_EngmntProjAssgmtToSessionUsr EngmntProjectHeaderCompanyCode Receiver Company Code
EngagementProjectCostCenter I_EngmntProjAssgmtToSessionUsr EngagementProjectCostCenter Cost Center
ProfitCenter I_EngmntProjAssgmtToSessionUsr ProfitCenter Profit Center
EngmntProjectControllingArea I_EngmntProjAssgmtToSessionUsr ControllingArea Controlling Area
LastChangeDateTime I_EngmntProjAssgmtToSessionUsr LastChangeDateTime Timestamp

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_EngmtProjActuals.
-- 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: PEPACTS

CREATE VIEW P_EngmtProjActuals AS
SELECT
  ProjectActuals.Project AS Project,
  ProjectActuals.WBSElement AS WBSElement,
  ProjectActuals.ControllingObject AS ControllingObject,
  ProjectActuals.WorkPackage AS WorkPackage,
  ProjectActuals.WorkItem AS WorkItem,
  EmpOrg.CompanyCode AS PartnerCompanyCode,
  EmpOrg.CostCenter AS PartnerCostCenter,
  EmpOrg.StartDate AS StartDate,
  EmpOrg.EndDate AS EndDate,
  A.EngagementProjFinPlanUUID AS EngagementProjFinPlanUUID,
  A.IsMyProject AS IsMyProject,
  A.Currency AS Currency,
  ProjectActuals.SalesDocument AS SalesOrder,
  ProjectActuals.SalesDocumentItem AS SalesOrderItem,
  ProjectActuals.Product AS Material,
  Receivables.ClearingAccountingDocument AS ClearingAccountingDocument,
  ProjectActuals.GLAccount AS GLAccount,
  ProjectActuals.ChartOfAccounts AS ChartOfAccounts,
  ProjectActuals.ControllingObjectDebitType AS ControllingObjectDebitType,
  ProjectActuals.BusinessTransactionType AS BusinessTransactionType,
  ProjectActuals.PersonnelNumber AS PersonnelNumber,
  case when ProjectActuals.ControllingObjectDebitType = '1' and ProjectActuals.Product <> '' and ProjectActuals.MaterialGroup = 'P001' then ProjectActuals.Quantity else ProjectActuals.ValuationQuantity end as ValuationQuantity AS ValuationQuantityendasValuationQuantity,
  case when ProjectActuals.ControllingObjectDebitType = '1' and ProjectActuals.Product <> '' and ProjectActuals.MaterialGroup = 'P001' then ProjectActuals.BaseUnit when ProjectActuals.ControllingObjectDebitType = '2' and ProjectActuals.Product <> '' then cast('H' as meins) else ProjectActuals.CostSourceUnit end as BaseUnit AS CostSourceUnitendasBaseUnit,
  ProjectActuals.FiscalYearPeriod AS FiscalYearPeriod,
  ProjectActuals.PostingDate AS PostingDate,
  substring(ProjectActuals.PostingDate,1,4) AS FiscalYear,
  substring (ProjectActuals.PostingDate,5,2) AS FiscalPeriod,
  ProjectActuals.CompanyCodeCurrency AS CompanyCodeCurrency,
  ProjectActuals.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  ProjectActuals.CostSourceUnit AS CostSourceUnit,
  ProjectActuals.Quantity AS Quantity,
  case when EmpOrg.CompanyCode <> '' then EmpOrg.CompanyCode else ProjectActuals.PartnerCompanyCode end as CompanyCode AS PartnerCompanyCodeendasCompanyCode,
  case when EmpOrg.CostCenter <> '' then EmpOrg.CostCenter else ProjectActuals.PartnerCostCenter end as CostCenter AS PartnerCostCenterendasCostCenter,
  ProjectActuals.ControllingArea AS ControllingArea,
  ProjectActuals.SourceLedger AS Ledger,
  Ledger.IsLeadingLedger AS IsLeadingLedger,
  A.EngagementProjectCategory AS EngagementProjectCategory,
  A.EngagementProjectServiceOrg AS CustomerProjectServiceOrg,
  A.Customer AS Customer,
  A.ProjectVisibility AS ProjectVisibility,
  A.EngagementProjectStage AS EngagementProjectStage,
  A.ProjectProfileCode AS ProjectProfileCode,
  A.EngagementProjectType AS EngagementProjectType,
  A.EngmntProjectHeaderCompanyCode AS EngmntProjectHeaderCompanyCode,
  A.EngagementProjectCostCenter AS EngagementProjectCostCenter,
  A.ProfitCenter AS ProfitCenter,
  A.ControllingArea AS EngmntProjectControllingArea,
  A.LastChangeDateTime AS LastChangeDateTime
FROM I_EngmntProjAssgmtToSessionUsr AS A
INNER JOIN P_EngmntProjGLAcctRawData AS ProjectActuals ON /* join condition not captured in parsed metadata */
INNER JOIN I_Ledger AS Ledger ON /* join condition not captured in parsed metadata */
;

Learn More