C_ExtPurReqnAssignedSOS

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_ExtPurReqnAssignedSOS.
-- 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: CEXTPRASOS

CREATE VIEW C_ExtPurReqnAssignedSOS AS
SELECT
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  ProcurementHubSourceSystem,
  ProcmtHubFixedSupplier,
  ProcmtHubPurRequisitionType,
  cast( '' as abap.char(60)) AS PurchasingSourceType,
  ProcmtHubPurchaseContract,
  ProcmtHubPurchaseContractItem,
  ProcmtHubPurchasingInfoRecord,
  ProcmtHubProduct,
  ConsumptionPosting,
  ProcmtHubPurgDocItmCategory,
  IsPurReqnBlocked,
  ProcmtHubSupplierName,
  ProcmtHubPlant,
  ProcmtHubSupplyingPlant,
  ProcmtHubPurchasingOrg,
  BaseUnit,
  ProcmtHubCompanyCode,
  I_PrmtHbRpldPurchaseReqnItem.PurReqnExternalSystemId AS PurReqnExternalSystemId,
  PurReqnCmpltnsCat,
  I_PrmtHbRpldPurchaseReqnItem.PurReqnIsValdInCntrlReqnProcg AS PurReqnIsValdInCntrlReqnProcg
FROM I_PrmtHbRpldPurchaseReqnItem
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 C_ProcmtHubPlantVH AS _ProcmtHubPlantVH ON _ProcmtHubPlantVH.ProcmtHubPlant = ProcmtHubSupplyingPlant AND _ProcmtHubPlantVH.ProcmtHubCompanyCode = ProcmtHubCompanyCode AND _ProcmtHubPlantVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _ProcmtHubPurgOrgVH ON _ProcmtHubPurgOrgVH.ProcmtHubPurchasingOrg = ProcmtHubPurchasingOrg AND _ProcmtHubPurgOrgVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
;