C_PurReqnFllwOnDocDraftHeader

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_PurReqnFllwOnDocDraftHeader.
-- 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: CPURREQNFLLWH

CREATE VIEW C_PurReqnFllwOnDocDraftHeader AS
SELECT
  PurReqnFllwOnDocDrftHdrUUID,
  ProcurementHubSourceSystem,
  _BackendSourceSystem.ProcurementHubSourceSystemName AS ProcurementHubSourceSystemName,
  ProcmtHubFixedSupplier,
  _ProcmtHubSupplierVH.ProcmtHubSupplierName AS ProcmtHubSupplierName,
  ProcmtHubCompanyCode,
  _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCodeName AS ProcmtHubCompanyCodeName,
  ProcmtHubPurchasingGroup,
  _ProcmtHubPurgGroupVH.PurchasingGroupName AS PurchasingGroupName,
  ProcmtHubPurchasingOrg,
  _ProcmtHubPurgOrgVH.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
  CreatedByUser,
  ProcmtHubPurDocumentType,
  ProcmtHubDocumentCurrency,
  ProcmtHubPaymentTerms,
  ProcmtHubIncotermsClassfctn,
  ProcmtHubIncotermsLocation1,
  cast ('' as boole_d ) AS SuplrIsDsbldForPurReqnGrouping
FROM I_PurReqnFllwOnDocDraftHeader
LEFT OUTER JOIN C_PurReqnFllwOnDocDraftItem AS _PurReqnFllwOnDocDraftItem ON I_PurReqnFllwOnDocDraftHeader.PurReqnFllwOnDocDrftHdrUUID = _PurReqnFllwOnDocDraftItem.PurReqnFllwOnDocDrftHdrUUID  -- association [1..*]
LEFT OUTER JOIN C_ProcmtHubPurgGroupVH AS _ProcmtHubPurgGroupVH ON I_PurReqnFllwOnDocDraftHeader.ProcmtHubPurchasingGroup = _ProcmtHubPurgGroupVH.ProcmtHubPurchasingGroup AND I_PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _ProcmtHubPurgGroupVH.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubSupplierVH AS _ProcmtHubSupplierVH ON I_PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _ProcmtHubSupplierVH.ProcurementHubSourceSystem AND I_PurReqnFllwOnDocDraftHeader.ProcmtHubFixedSupplier = _ProcmtHubSupplierVH.ProcmtHubFixedSupplier AND I_PurReqnFllwOnDocDraftHeader.ProcmtHubPurchasingOrg = _ProcmtHubSupplierVH.ProcmtHubPurchasingOrg AND I_PurReqnFllwOnDocDraftHeader.ProcmtHubCompanyCode = _ProcmtHubSupplierVH.ProcmtHubCompanyCode  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _ProcmtHubPurgOrgVH ON I_PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _ProcmtHubPurgOrgVH.ProcurementHubSourceSystem AND I_PurReqnFllwOnDocDraftHeader.ProcmtHubPurchasingOrg = _ProcmtHubPurgOrgVH.ProcmtHubPurchasingOrg  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubCompanyCodeVH AS _ProcmtHubCompanyCodeVH ON I_PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _ProcmtHubCompanyCodeVH.ProcurementHubSourceSystem AND I_PurReqnFllwOnDocDraftHeader.ProcmtHubPurchasingOrg = _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCode  -- association [1..1]
LEFT OUTER JOIN I_BackendSourceSystem AS _BackendSourceSystem ON I_PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubIncotermsClsfctnVH AS _ProcmtHubIncotermsClsfctnVH ON _ProcmtHubIncotermsClsfctnVH.IncotermsClassification = ProcmtHubIncotermsClassfctn AND _ProcmtHubIncotermsClsfctnVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurOrdDocTypeVH AS _ProcmtHubDocumentTypeVH ON _ProcmtHubDocumentTypeVH.ExtSourceSystem = ProcurementHubSourceSystem AND _ProcmtHubDocumentTypeVH.PurchasingDocumentType = ProcmtHubPurDocumentType  -- association [0..1]
LEFT OUTER JOIN C_ProcurementHubPaymentTermsVH AS _ProcurementHubPaymentTermsVH ON _ProcurementHubPaymentTermsVH.PaymentTerms = ProcmtHubPaymentTerms AND _ProcurementHubPaymentTermsVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
;