I_ProcmtHubPurReqnAcctAssgmt

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 I_ProcmtHubPurReqnAcctAssgmt.
-- 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: IHUBPRACCASNMT

CREATE VIEW I_ProcmtHubPurReqnAcctAssgmt AS
SELECT
  purchaserequisition AS ProcmtHubPurchaseRequisition,
  purchaserequisitionitem AS ProcmtHubPurRequisitionItem,
  purreqnacctassgmtnmbr AS ProcmtHubPurReqnAcctAssgmtNo,
  extsourcesystem AS ProcurementHubSourceSystem,
  Quantity,
  MultipleAcctAssgmtDistrPercent,
  glaccount AS ProcmtHubGLAccount,
  costcenter AS ProcmtHubCostCenter,
  functionalarea AS ProcmtHubFunctionalArea,
  fund AS ProcmtHubFund,
  fundscenter AS ProcmtHubFundsCenter,
  controllingarea AS ProcmtHubControllingArea,
  unloadingpointname AS ProcmtHubUnloadingPointName,
  processorder AS ProcmtHubProcessOrder,
  projectnetwork AS ProcmtHubProjectNetwork,
  projectnetworkinternalid AS ProcmtHubProjectNetworkIntID,
  cast( wbselementinternalid as abap.char(40)) AS ProcmtHubWBSElementInternalID,
  salesorder AS ProcmtHubSalesOrder,
  salesorderscheduleline AS ProcmtHubSalesOrdScheduleLine,
  salesdocumentitem AS ProcmtHubSalesDocumentItem,
  masterfixedasset AS ProcmtHubMasterFixedAsset,
  ChartOfAccounts,
  cast(substring( cast(tstmp_current_utctimestamp() as abap.char( 17 ) ), 1, 8 ) as abap.dats ) AS ValidityDate
FROM mmpur_ext_ebkn
;