C_ExtPurReqnAcctAssgmt

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_ExtPurReqnAcctAssgmt.
-- 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: CEXTPRACCASNMT

CREATE VIEW C_ExtPurReqnAcctAssgmt AS
SELECT
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  ProcmtHubPurReqnAcctAssgmtNo,
  ProcurementHubSourceSystem,
  cast (concat(concat(concat(concat(ProcmtHubPurchaseRequisition, '/'), ProcmtHubPurRequisitionItem ), '/' ), ProcurementHubSourceSystem )as vdm_formatteditemid) AS FormattedItemID,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  ProcmtHubGLAccount,
  ProcmtHubCostCenter,
  ProcmtHubFunctionalArea,
  ProcmtHubFund,
  ProcmtHubFundsCenter,
  ProcmtHubControllingArea,
  ProcmtHubUnloadingPointName,
  ProcmtHubGoodsRecipientName,
  ProcmtHubProcessOrder,
  ProcmtHubProjectNetwork,
  ProcmtHubProjectNetworkIntID,
  _ProcmtHubWBSElement.WBSElementDescription AS WBSElementDescription,
  _ProcmtHubWBSElement.WBSElement AS ProcmtHubWBSElementExternalID,
  ProcmtHubWBSElementInternalID,
  ProcmtHubSalesOrder,
  ProcmtHubSalesOrdScheduleLine,
  ProcmtHubSalesDocumentItem,
  ProcmtHubMasterFixedAsset,
  ChartOfAccounts,
  ValidityDate,
  BusinessArea,
  ProfitCenter,
  _ExtPurchaseRequisitionItem.ProcmtHubCompanyCode AS ProcmtHubCompanyCode,
  cast ('' as xfeld) AS PrmtHbMssUpAcctAssgmtIsCrted,
  IsDeleted
FROM I_PrmtHbRpldPurReqnAcctAssgmt
LEFT OUTER JOIN C_ExtPurchaseRequisitionItem AS _ExtPurchaseRequisitionItem ON ProcmtHubPurchaseRequisition = _ExtPurchaseRequisitionItem.ProcmtHubPurchaseRequisition AND ProcmtHubPurRequisitionItem = _ExtPurchaseRequisitionItem.ProcmtHubPurRequisitionItem AND ProcurementHubSourceSystem = _ExtPurchaseRequisitionItem.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubWBSElement AS _ProcmtHubWBSElement ON ProcmtHubWBSElementInternalID = _ProcmtHubWBSElement.WBSElementInternalID AND ProcurementHubSourceSystem = _ProcmtHubWBSElement.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubGLAcctInChtOfAccts AS _ProcmtHubGLAcctInChtOfAccts ON ChartOfAccounts = _ProcmtHubGLAcctInChtOfAccts.ChartOfAccounts AND ProcmtHubGLAccount = _ProcmtHubGLAcctInChtOfAccts.GLAccount AND ProcurementHubSourceSystem = _ProcmtHubGLAcctInChtOfAccts.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubProjectNetworkText AS _ProcmtHubProjectNetworkText ON _ProcmtHubProjectNetworkText.ProjectNetwork = ProcmtHubProjectNetwork AND _ProcmtHubProjectNetworkText.ExtSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubCostCenter AS _ProcmtHubCostCenter ON _ProcmtHubCostCenter.ProcmtHubCostCenter = ProcmtHubCostCenter AND _ProcmtHubCostCenter.ExtSourceSystem = ProcurementHubSourceSystem AND _ProcmtHubCostCenter.ProcmtHubControllingArea = ProcmtHubControllingArea AND ValidityDate <= _ProcmtHubCostCenter.ValidityEndDate  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubFixedAsset AS _ProcmtHubFixedAsset ON _ProcmtHubFixedAsset.ProcmtHubMasterFixedAsset = ProcmtHubMasterFixedAsset AND _ProcmtHubFixedAsset.ExtSourceSystem = ProcurementHubSourceSystem AND _ProcmtHubFixedAsset.CompanyCode = ProcmtHubCompanyCode  -- association [0..1]
;