C_CFinRpldPurchaseOrderDetails

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_CFinRpldPurchaseOrderDetails.
-- 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 C_CFinRpldPurchaseOrderDetails AS
SELECT
  CFinRpldPurchaseOrder.SenderLogicalSystem AS SenderLogicalSystem,
  cast( CFinRpldPurchaseOrder.CFinReplicatedPurchaseOrder as fins_cfin_av_rpld_purord preserving type ) AS CFinReplicatedPurchaseOrder,
  cast( _CFinRpldPurchaseOrderItem.CFinRpldPurchaseOrderItem as fins_cfin_av_rpld_purord_item preserving type) AS CFinRpldPurchaseOrderItem,
  _CFinRpldPurOrdAcctAssgmt.CFinRpldPurgDocAcctAssgmt AS CFinRpldPurgDocAcctAssgmt,
  _CFinRpldPurchaseOrderItem.Material AS Material,
  CFinRpldPurchaseOrder.CompanyCode AS CompanyCode,
  CFinRpldPurchaseOrder.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  CFinRpldPurchaseOrder.PurchasingDocumentType AS PurchasingDocumentType,
  _CFinRpldPurchaseOrderItem.NetAmount AS NetAmount,
  _CFinRpldPurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  _CFinRpldPurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _CFinRpldPurchaseOrderItem.IsStatisticalItem AS IsStatisticalItem,
  CFinRpldPurchaseOrder.CreationDate AS CreationDate,
  cast(CFinRpldPurchaseOrder.CreatedByUser as fins_cfin_av_src_ernam preserving type ) AS CreatedByUser,
  _CFinRpldPurOrdAcctAssgmt.GLAccount AS GLAccount,
  cast( ' ' as fin_glaccount_name preserving type ) AS GLAccountName,
  _CFinRpldPurOrdAcctAssgmt.BusinessArea AS BusinessArea,
  _CFinRpldPurOrdAcctAssgmt.CostCenter AS CostCenter,
  cast( ' ' as fis_kostl_name preserving type ) AS CostCenterName,
  _CFinRpldPurOrdAcctAssgmt.OrderID AS OrderID,
  _CFinRpldPurOrdAcctAssgmt.ControllingArea AS ControllingArea,
  _CFinRpldPurOrdAcctAssgmt.WBSElementExternalID AS WBSElementExternalID,
  _CFinRpldPurOrdAcctAssgmt.WBSElementInternalID AS WBSElementInternalID,
  _CFinRpldPurOrdAcctAssgmt.NetworkActivityInternalID AS NetworkActivityInternalID,
  _CFinRpldPurOrdAcctAssgmt.CommitmentItemShortID AS CommitmentItemShortID,
  _CFinRpldPurOrdAcctAssgmt.FundsCenter AS FundsCenter,
  _CFinRpldPurOrdAcctAssgmt.Fund AS Fund,
  _CFinRpldPurOrdAcctAssgmt.FunctionalArea AS FunctionalArea,
  _CFinRpldPurOrdAcctAssgmt.SettlementReferenceDate AS SettlementReferenceDate,
  _CFinRpldPurOrdAcctAssgmt.CostCtrActivityType AS CostCtrActivityType,
  _CFinRpldPurOrdAcctAssgmt.GrantID AS GrantID,
  _CFinRpldPurOrdAcctAssgmt.ProfitCenter AS ProfitCenter,
  cast( ' ' as fis_prctr_shorttext preserving type ) AS ProfitCenterName,
  CFinRpldPurchaseOrder.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  CFinRpldPurchaseOrder.LogicalSystemName AS LogicalSystemName,
  CFinRpldPurchaseOrder.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  cast('' as fis_cctr_hryid_42) AS CostCenterHierarchy,
  cast('' as fis_cctr_hrynid_50) AS CostCenterHierarchyNode,
  cast('' as fis_hryid_ccode_42) AS CompanyCodeHierarchy,
  cast('' as fis_hrynid_ccode_50) AS CompanyCodeHierarchyNode,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  cast('' as fis_glaccthier) AS GLAccountHierarchy,
  cast('' as fis_glacct_hrynid_50) AS GLAccountHierarchyNode,
  _CFinRpldPurOrdAcctAssgmt.ChartOfAccounts AS ChartOfAccounts,
  _CFinRpldPurchaseOrderItem._Material AS _Material,
  CFinRpldPurchaseOrder._CompanyCode AS _CompanyCode,
  _CFinRpldPurchaseOrderItem._DocumentCurrency AS _DocumentCurrency,
  _CFinRpldPurchaseOrderItem._MaterialText AS _MaterialText,
  _CFinRpldPurchaseOrderItem._AccountAssignmentCategoryText AS _AccountAssignmentCategoryText,
  _CFinRpldPurOrdAcctAssgmt._WBSElementBasicDataStdVH AS _WBSElementBasicDataStdVH,
  _CFinRpldPurOrdAcctAssgmt.ValidityDate AS ValidityDate,
  _CFinRpldPurOrdAcctAssgmt._ProfitCenterText AS _ProfitCenterText,
  _CFinRpldPurOrdAcctAssgmt._Order AS _Order,
  _CFinRpldPurOrdAcctAssgmt.ProjectNetwork AS ProjectNetwork,
  _CFinRpldPurOrdAcctAssgmt._BusinessAreaText AS _BusinessAreaText,
  _CFinRpldPurOrdAcctAssgmt._ControllingArea AS _ControllingArea,
  _CFinRpldPurOrdAcctAssgmt._CostCenterText AS _CostCenterText,
  CFinRpldPurchaseOrder._LogicalSystem AS _LogicalSystem,
  CFinRpldPurchaseOrder._CFinPurchaseOrderTypeVH AS _CFinPurchaseOrderTypeVH
FROM C_CFinRpldPurchaseOrder AS CFinRpldPurchaseOrder
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _CostCenterHierarchyLeafNode ON CostCenter = _CostCenterHierarchyLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _CostCenterHierarchyLeafNode.HierarchyNodeClass AND _CostCenterHierarchyLeafNode.ValidityStartDate <= $session.system_date AND _CostCenterHierarchyLeafNode.ValidityEndDate >= $session.system_date AND _CostCenterHierarchyLeafNode.HierarchyType = '0101'  -- association [0..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _ProfitCenterHierLeafNode ON ProfitCenter = _ProfitCenterHierLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _ProfitCenterHierLeafNode.HierarchyNodeClass AND _ProfitCenterHierLeafNode.ValidityStartDate <= $session.system_date AND _ProfitCenterHierLeafNode.ValidityEndDate >= $session.system_date AND _ProfitCenterHierLeafNode.HierarchyType = '0106'  -- association [0..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _GLAccountHierLeafNode ON GLAccount = _GLAccountHierLeafNode.UnivHierarchyBusinessEntity AND ChartOfAccounts = _GLAccountHierLeafNode.HierarchyNodeClass AND _GLAccountHierLeafNode.ValidityStartDate <= $session.system_date AND _GLAccountHierLeafNode.ValidityEndDate >= $session.system_date AND _GLAccountHierLeafNode.HierarchyType = 'FSVN'  -- association [0..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _CompanyCodeHierLeafNode ON CompanyCode = _CompanyCodeHierLeafNode.UnivHierarchyBusinessEntity AND _CompanyCodeHierLeafNode.ValidityStartDate <= $session.system_date AND _CompanyCodeHierLeafNode.ValidityEndDate >= $session.system_date AND _CompanyCodeHierLeafNode.HierarchyType = 'COCD'  -- association [0..*]
;