C_CntrlQtanFllwOnDocStagingHdr

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_CntrlQtanFllwOnDocStagingHdr.
-- 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: CCNTRLQTNFLLWHTP

CREATE VIEW C_CntrlQtanFllwOnDocStagingHdr AS
SELECT
  CntrlQtanFllwOnDocDraftHdrUUID,
  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
FROM I_CntrlQtanFllwOnDocStagingHdr
LEFT OUTER JOIN C_CntrlQtanFllwOnDocStagingItm AS _CntrlQtanFllwOnDocStagingItm ON I_CntrlQtanFllwOnDocStagingHdr.CntrlQtanFllwOnDocDraftHdrUUID = _CntrlQtanFllwOnDocStagingItm.CntrlQtanFllwOnDocDraftHdrUUID  -- association [1..*]
LEFT OUTER JOIN C_ProcmtHubPurgGroupVH AS _ProcmtHubPurgGroupVH ON I_CntrlQtanFllwOnDocStagingHdr.ProcmtHubPurchasingGroup = _ProcmtHubPurgGroupVH.ProcmtHubPurchasingGroup AND I_CntrlQtanFllwOnDocStagingHdr.ProcurementHubSourceSystem = _ProcmtHubPurgGroupVH.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubSupplierVH AS _ProcmtHubSupplierVH ON I_CntrlQtanFllwOnDocStagingHdr.ProcurementHubSourceSystem = _ProcmtHubSupplierVH.ProcurementHubSourceSystem AND I_CntrlQtanFllwOnDocStagingHdr.ProcmtHubFixedSupplier = _ProcmtHubSupplierVH.ProcmtHubFixedSupplier AND I_CntrlQtanFllwOnDocStagingHdr.ProcmtHubPurchasingOrg = _ProcmtHubSupplierVH.ProcmtHubPurchasingOrg AND I_CntrlQtanFllwOnDocStagingHdr.ProcmtHubCompanyCode = _ProcmtHubSupplierVH.ProcmtHubCompanyCode  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _ProcmtHubPurgOrgVH ON I_CntrlQtanFllwOnDocStagingHdr.ProcurementHubSourceSystem = _ProcmtHubPurgOrgVH.ProcurementHubSourceSystem AND I_CntrlQtanFllwOnDocStagingHdr.ProcmtHubPurchasingOrg = _ProcmtHubPurgOrgVH.ProcmtHubPurchasingOrg  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubCompanyCodeVH AS _ProcmtHubCompanyCodeVH ON I_CntrlQtanFllwOnDocStagingHdr.ProcurementHubSourceSystem = _ProcmtHubCompanyCodeVH.ProcurementHubSourceSystem AND I_CntrlQtanFllwOnDocStagingHdr.ProcmtHubCompanyCode = _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCode  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubBackendSrceSystemVH AS _BackendSourceSystem ON I_CntrlQtanFllwOnDocStagingHdr.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]
;