C_PurReqnFllwOnDocDraftItem

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_PurReqnFllwOnDocDraftItem.
-- 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: CPURREQNFLLWI

CREATE VIEW C_PurReqnFllwOnDocDraftItem AS
SELECT
  I_PurReqnFllwOnDocDraftItem.PurReqnFllwOnDocDrftHdrUUID AS PurReqnFllwOnDocDrftHdrUUID,
  I_PurReqnFllwOnDocDraftItem.PurReqnFllwOnDocDrftItmUUID AS PurReqnFllwOnDocDrftItmUUID,
  I_PurReqnFllwOnDocDraftItem.ProcmtHubPurchaseRequisition AS ProcmtHubPurchaseRequisition,
  I_PurReqnFllwOnDocDraftItem.ProcmtHubPurRequisitionItem AS ProcmtHubPurRequisitionItem,
  _ProcmtHubPurReqnItem.ProcmtHubPurgDocItmCategory AS ProcmtHubPurgDocItmCategory,
  _ProcmtHubPurgDocItmCatVH.ItemCategoryName AS ItemCategoryName,
  I_PurReqnFllwOnDocDraftItem.ProcmtHubProduct AS ProcmtHubProduct,
  _ProcmtHubPurReqnItem.ProcmtHubProductGroup AS ProcmtHubProductGroup,
  _ProcmtHubPurReqnItem.RequestedQuantity AS RequestedQuantity,
  _ProcmtHubPurReqnItem.BaseUnit AS BaseUnit,
  _ProcmtHubPurReqnItem.ProcmtHubPlant AS ProcmtHubPlant,
  _ProcmtHubPlantVH.ProcmtHubPlantName AS ProcmtHubPlantName,
  _ProcmtHubPurReqnItem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  _ProcmtHubPurReqnItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  _ProcmtHubPurReqnItem.LastChangeDateTime AS LastChangeDateTime,
  _PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem AS ProcurementHubSourceSystem,
  ProcmtHubMaterialName,
  ProcmtHubDeliveryDate,
  ProcmtHubOrderQuantity,
  ProcmtHubOrderQuantityUnit,
  ProcmtHubNetPriceAmount,
  I_PurReqnFllwOnDocDraftItem.ProcmtHubDocumentCurrency AS ProcmtHubDocumentCurrency,
  ProcmtHubNetPriceQuantity,
  ProcmtHubOrderPriceUnit,
  ProcmtHubTaxCode,
  InvoiceIsGoodsReceiptBased,
  cast ( ('') as abap.char(1)) AS IsEditable,
  _ProcmtHubPurReqnItem.PurReqnIsValdInCntrlReqnProcg AS PurReqnIsValdInCntrlReqnProcg
FROM I_PurReqnFllwOnDocDraftItem
INNER JOIN C_PurReqnFllwOnDocDraftHeader AS _PurReqnFllwOnDocDraftHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrmtHbRpldPurchaseReqnItem AS _ProcmtHubPurReqnItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ProcmtHubProductVH AS _ProcmtHubProductVH ON _PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _ProcmtHubProductVH.ProcurementHubSourceSystem AND I_PurReqnFllwOnDocDraftItem.ProcmtHubProduct = _ProcmtHubProductVH.ProcmtHubProduct  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPlantVH AS _ProcmtHubPlantVH ON _PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _ProcmtHubPlantVH.ProcurementHubSourceSystem AND _ProcmtHubPurReqnItem.ProcmtHubPlant = _ProcmtHubPlantVH.ProcmtHubPlant AND _PurReqnFllwOnDocDraftHeader.ProcmtHubCompanyCode = _ProcmtHubPlantVH.ProcmtHubCompanyCode  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPurgDocItmCatVH AS _ProcmtHubPurgDocItmCatVH ON _ProcmtHubPurReqnItem.ProcmtHubPurgDocItmCategory = _ProcmtHubPurgDocItmCatVH.ItemCategory AND _PurReqnFllwOnDocDraftHeader.ProcurementHubSourceSystem = _ProcmtHubPurgDocItmCatVH.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubTaxCodeValueHelp AS _ProcmtHubTaxCodeValueHelp ON ProcmtHubTaxCode = _ProcmtHubTaxCodeValueHelp.TaxCode AND ProcurementHubSourceSystem = _ProcmtHubTaxCodeValueHelp.ProcurementHubSourceSystem  -- association [0..*]
;