C_ProjectCostLineItem

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 C_ProjectCostLineItem.
-- 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.
-- Parameters: P_PlanningCategory1 : fcom_category, P_PlanningCategory2 : fcom_category, P_ProjectHierarchyIsIncluded : boolean, P_Project : ps_p_pspid, P_ProjectObjectExternalID : ps_pspid_edit, P_ProjectObjectType : char2, P_ProjectObjectNode : j_objnr, P_ProjectCostIsSettled : boolean, P_ProjectObjectRootNode : j_objnr, P_Ledger : fins_ledger, P_OrderTypeAppendedCode : ps_s4_appendedcode

CREATE VIEW C_ProjectCostLineItem AS
SELECT
  resultElement: 'ProjectObjectNode' AS resultElementProjectObjectNode,
  resultElement: 'ProjectObject' AS resultElementProjectObject,
  resultElement: 'Ledger' AS resultElementLedgerP_Ledgerfins_ledger,
  quickInfo: 'Appended Plan Only' AS P_PlanningCategory1,
  P_PlanningCategory2: $parameters.P_PlanningCategory2 AS P_PlanningCategory2,
  P_ProjectObjectRootNode: $parameters.P_ProjectObjectRootNode ) as _ProjCostLineItems inner join I_ProjStrucHierarchyNode(P_ProjectObjectNode: $parameters.P_ProjectObjectNode AS P_ProjectObjectNode,
  _ProjectHierarchy.ProjectObjectInternalID AS ProjectInternalID,
  _ProjCostLineItems.SourceLedger AS SourceLedger,
  _ProjCostLineItems.Ledger AS Ledger,
  _ProjCostLineItems.CompanyCode AS CompanyCode,
  _ProjCostLineItems.FiscalYear AS FiscalYear,
  _ProjCostLineItems.AccountingDocument AS AccountingDocument,
  _ProjCostLineItems.LedgerGLLineItem AS LedgerGLLineItem,
  _ProjCostLineItems.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  _ProjCostLineItems.FinancialPlanningEntryItem AS FinancialPlanningEntryItem,
  cast(_ProjectHierarchy.Project as ps_p_pspid preserving type ) AS Project,
  cast( _ProjectHierarchy.ProjectObjectExternalID as ps_posid_edit preserving type ) AS ProjectObjectExternalID,
  _ProjectHierarchy.ProjectObjectDescription AS ProjectObjectDescription,
  _ProjCostLineItems.ProjectObjectRootNode AS ProjectObjectRootNode,
  _ProjCostLineItems.ProjectObjectType AS ProjectObjectType,
  _ProjCostLineItems._ProjectObjectTypeText.ProjectSelectedObjectText AS ProjectSelectedObjectText,
  _ProjCostLineItems.ProjectSelectedObject AS ProjectSelectedObject,
  _ProjectHierarchy.WBSElement AS WBSElement,
  case when $parameters.P_ProjectHierarchyIsIncluded = 'X' then cast ($parameters.P_ProjectObjectExternalID as ps_posid_edit preserving type) else _ProjectHierarchy.WBSElement end as WBSElementExternalID AS WBSElementendasWBSElementExternalID,
  _ProjCostLineItems.ProjectNetwork AS ProjectNetwork,
  _ProjCostLineItems.NetworkActivity AS NetworkActivity,
  _ProjCostLineItems.NetworkActivityElement AS NetworkActivityElement,
  _ProjCostLineItems.OrderID AS OrderID,
  _ProjCostLineItems.OrderOperation AS OrderOperation,
  _ProjCostLineItems.OrderSuboperation AS OrderSuboperation,
  _ProjCostLineItems.PlanningCategory1 AS PlanningCategory1,
  _ProjCostLineItems.PlanningCategory2 AS PlanningCategory2,
  _ProjCostLineItems.InternalOrder AS InternalOrder,
  _ProjCostLineItems.ProductionOrder AS ProductionOrder,
  _ProjCostLineItems.Product AS Product,
  _ProjCostLineItems.OriginCostCtrActivityType AS OriginCostCtrActivityType,
  _ProjCostLineItems.OriginCostCenter AS OriginCostCenter,
  _ProjCostLineItems.ServiceOrder AS ServiceOrder,
  _ProjCostLineItems.ServiceOrderItem AS ServiceOrderItem,
  _ProjCostLineItems.ServiceContract AS ServiceContract,
  _ProjCostLineItems.ServiceContractItem AS ServiceContractItem,
  _ProjCostLineItems.SourcePlanningCategory AS SourcePlanningCategory,
  _CostCategoryText.PlanningCategoryName AS PlanningCategoryName,
  _ProjCostLineItems.GLAccount AS GLAccount,
  _GLAccountText.GLAccountName AS GLAccountName,
  _ProjCostLineItems.ChartOfAccounts AS ChartOfAccounts,
  _ProjCostLineItems.PostingDate AS PostingDate,
  _ProjCostLineItems.ProfitCenter AS ProfitCenter,
  _ProjCostLineItems.ProjectObjectProfitCenter AS ProjectObjectProfitCenter,
  _ProjCostLineItems.ResponsibleCostCenter AS ResponsibleCostCenter,
  _ProjCostLineItems.ControllingArea AS ControllingArea,
  _ProjCostLineItems.OrderTypeAppendedCode AS OrderTypeAppendedCode,
  _ProjCostLineItems.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _UserContactCard.FullName AS CreatedByUserFullName,
  _BusinessUser.BPIdentificationNumber AS PersonExternalID,
  _ProjCostLineItems.FiscalPeriod AS FiscalPeriod,
  _ProjCostLineItems._FiscalYearPeriodText[1:Language = $session.system_language].FiscalPeriodName AS FiscalPeriodName,
  _ProjCostLineItems.FiscalYearVariant AS FiscalYearVariant,
  cast( _ProjGLAccountHierarchy.ProjectCostComponentName as ps_s4_projcostcompt preserving type ) AS ProjectCostComponentName,
  cast( _ProjGLAccountHierarchy.ProjectCostComponent as ps_s4_projcostcomp preserving type ) AS ProjectCostComponent,
  _ProjGLAccountHierarchy.GLAccountHierarchy AS GLAccountHierarchy,
  _ProjCostLineItems.ProjectCostIsSettled AS ProjectCostIsSettled,
  _ProjCostLineItems.CompanyCodeCurrency AS CompanyCodeCurrency,
  _ProjCostLineItems.TransactionCurrency AS TransactionCurrency,
  _ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  _ProjCostLineItems.FunctionalCurrency AS FunctionalCurrency,
  _ProjCostLineItems.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
  _ProjCostLineItems.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
  _ProjCostLineItems.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
  _ProjCostLineItems.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
  _ProjCostLineItems.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
  _ProjCostLineItems.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
  _ProjCostLineItems.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
  _ProjCostLineItems.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
  _ProjCostLineItems.PartnerOrder AS PartnerOrder,
  _ProjCostLineItems.PartnerOrderCategory AS PartnerOrderCategory,
  _ProjCostLineItems.ProjectPartnerObject AS ProjectPartnerObject,
  _ProjCostLineItems.PartnerProject AS PartnerProject,
  _ProjCostLineItems.PartnerProfitCenter AS PartnerProfitCenter,
  _ProjCostLineItems.PartnerCompanyCode AS PartnerCompanyCode,
  _ProjCostLineItems.BusinessTransactionType AS BusinessTransactionType,
  _ProjCostLineItems.DebitCreditCode AS DebitCreditCode,
  _ProjCostLineItems.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  _ProjCostLineItems.ActualAmountInCompanyCodeCrcy AS ActualAmountInCompanyCodeCrcy,
  _ProjCostLineItems.ActualAmountInTransactionCrcy AS ActualAmountInTransactionCrcy,
  _ProjCostLineItems.ActualAmountInGlobalCurrency AS ActualAmountInGlobalCurrency,
  _ProjCostLineItems.ActualAmountInFunctionalCrcy AS ActualAmountInFunctionalCrcy,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy1 AS ActualAmountInFreeDfndCrcy1,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy2 AS ActualAmountInFreeDfndCrcy2,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy3 AS ActualAmountInFreeDfndCrcy3,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy4 AS ActualAmountInFreeDfndCrcy4,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy5 AS ActualAmountInFreeDfndCrcy5,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy6 AS ActualAmountInFreeDfndCrcy6,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy7 AS ActualAmountInFreeDfndCrcy7,
  _ProjCostLineItems.ActualAmountInFreeDfndCrcy8 AS ActualAmountInFreeDfndCrcy8,
  _ProjCostLineItems.PlanAmountInCompanyCodeCrcy AS PlanAmountInCompanyCodeCrcy,
  _ProjCostLineItems.PlanAmountInTransactionCrcy AS PlanAmountInTransactionCrcy,
  _ProjCostLineItems.PlanAmountInGlobalCurrency AS PlanAmountInGlobalCurrency,
  _ProjCostLineItems.PlanAmountInFunctionalCurrency AS PlanAmountInFunctionalCurrency,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy1 AS PlanAmountInFreeDefinedCrcy1,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy2 AS PlanAmountInFreeDefinedCrcy2,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy3 AS PlanAmountInFreeDefinedCrcy3,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy4 AS PlanAmountInFreeDefinedCrcy4,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy5 AS PlanAmountInFreeDefinedCrcy5,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy6 AS PlanAmountInFreeDefinedCrcy6,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy7 AS PlanAmountInFreeDefinedCrcy7,
  _ProjCostLineItems.PlanAmountInFreeDefinedCrcy8 AS PlanAmountInFreeDefinedCrcy8,
  _ProjCostLineItems.BaselineAmtInCompanyCodeCrcy AS BaselineAmtInCompanyCodeCrcy,
  _ProjCostLineItems.BaselineAmtInFreeDefinedCrcy4 AS BaselineAmtInFreeDefinedCrcy4,
  _ProjCostLineItems.BaselineAmtInGlobalCrcy AS BaselineAmtInGlobalCrcy,
  _ProjCostLineItems.BaselineAmtInFunctionalCrcy AS BaselineAmtInFunctionalCrcy,
  _ProjCostLineItems.BaselineAmtInFreeDefinedCrcy1 AS BaselineAmtInFreeDefinedCrcy1,
  _ProjCostLineItems.BaselineAmtInFreeDefinedCrcy2 AS BaselineAmtInFreeDefinedCrcy2,
  _ProjCostLineItems.BaselineAmtInFreeDefinedCrcy3 AS BaselineAmtInFreeDefinedCrcy3,
  _ProjCostLineItems.BaselinePlndRevnAmt AS BaselinePlndRevnAmt,
  _ProjCostLineItems.BaselineAmtInFreeDefinedCrcy5 AS BaselineAmtInFreeDefinedCrcy5,
  _ProjCostLineItems.BaselineAmtInFreeDefinedCrcy6 AS BaselineAmtInFreeDefinedCrcy6,
  _ProjCostLineItems.BaselineAmtInFreeDefinedCrcy7 AS BaselineAmtInFreeDefinedCrcy7,
  _ProjCostLineItems.BaseAmtWithoutTxInCCCrcy AS BaseAmtWithoutTxInCCCrcy,
  _ProjCostLineItems.SourceReferenceDocument AS SourceReferenceDocument,
  _ProjCostLineItems.SourceReferenceDocumentItem AS SourceReferenceDocumentItem,
  _ProjCostLineItems.SourceReferenceDocumentType AS SourceReferenceDocumentType,
  _ProjCostLineItems.ControllingObjectCurrency AS ControllingObjectCurrency,
  _ProjCostLineItems.AmountInObjectCurrency AS AmountInObjectCurrency,
  _ProjCostLineItems.ActlCostInProjCrcy AS ActlCostInProjCrcy,
  _ProjCostLineItems.PlndCostAmtInProjCrcy AS PlndCostAmtInProjCrcy,
  _ProjCostLineItems.BslnAmtInProjCrcy AS BslnAmtInProjCrcy,
  _ProjCostLineItems.OrderType AS OrderType,
  _ProjCostLineItems.SalesDocument AS SalesDocument,
  _ProjCostLineItems.SalesDocumentItem AS SalesDocumentItem,
  _ProjCostLineItems._Project AS _Project,
  _ProjCostLineItems._WBSElement AS _WBSElement,
  _ProjCostLineItems._ProjectNetwork AS _ProjectNetwork,
  _ProjCostLineItems._NetworkActivity AS _NetworkActivity,
  _ProjCostLineItems._PMOrder AS _PMOrder
FROM I_ProjectCostLineItemByPeriod
INNER JOIN I_ProjStrucHierarchyNode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PlanningCategoryText AS _CostCategoryText ON SourcePlanningCategory = _CostCategoryText.PlanningCategory AND _CostCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_Pclincludesettlmtvh AS _IncludeSettlements ON ProjectCostIsSettled = _IncludeSettlements.IsSettled  -- association [0..1]
LEFT OUTER JOIN C_ProjectCostReportContactCard AS _UserContactCard ON AccountingDocCreatedByUser = _UserContactCard.UserID  -- association [1..1]
LEFT OUTER JOIN I_GLAccountText AS _GLAccountText ON GLAccount = _GLAccountText.GLAccount AND ChartOfAccounts = _GLAccountText.ChartOfAccounts AND _GLAccountText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BusinessUserVH AS _BusinessUser ON AccountingDocCreatedByUser = _BusinessUser.UserID  -- association [0..1]
LEFT OUTER JOIN P_ProjectGLAccountHierarchy AS _ProjGLAccountHierarchy ON GLAccount = _ProjGLAccountHierarchy.GLAccount  -- association [0..*]
;