I_PrmtHbPurOrdItmSchdLnAPI01

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_PrmtHbPurOrdItmSchdLnAPI01.
-- 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: IPRCHBPOSLAPI01

CREATE VIEW I_PrmtHbPurOrdItmSchdLnAPI01 AS
SELECT
  PurchaseOrder AS PrmtHbRpldPurchaseOrder,
  PurchaseOrderItem AS PrmtHbRpldPurchaseOrderItem,
  ExtSourceSystem AS ProcurementHubSourceSystem,
  ScheduleLine AS PrmtHbRpldPOItmSchdLn,
  DelivDateCategory AS PrmtHbDelivDateCategory,
  ScheduleLineDeliveryDate AS PrmtHbSchedLineDlvDte,
  SchedLineStscDeliveryDate AS PrmtHbSchedLineStstcsDlvDte,
  PerformancePeriodStartDate AS PrmtHbPerfPerdStrtDte,
  PerformancePeriodEndDate AS PrmtHbPerfPerdEndDte,
  ScheduleLineDeliveryTime AS PrmtHbSchedLineDelivTme,
  PurchaseRequisition AS ProcmtHubPurchaseRequisition,
  PurchaseRequisitionItem AS ProcmtHubPurRequisitionItem,
  SourceOfCreation AS ProcurementHubSourceOfCreation,
  PrevDelivQtyOfScheduleLine AS PrmtHbPrevDelivOfSchdLnQty,
  NoOfRemindersOfScheduleLine AS PrmtHbNmbrOfRemOfSchdLn,
  ScheduleLineIsFixed AS PrmtHbScheduleLineIsFixed,
  ScheduleLineCommittedQuantity AS PrmtHbSchdLnCmtdQty,
  Reservation AS ProcurementHubReservation,
  ProductAvailabilityDate AS PrmtHbProductAvailabilityDate,
  MaterialStagingTime AS PrmtHbMaterialStagingTime,
  TransportationPlanningDate AS PrmtHbTranspPlngDte,
  TransportationPlanningTime AS PrmtHbTranspPlngTme,
  LoadingDate AS PrmtHbLoadingDate,
  LoadingTime AS PrmtHbLoadingTime,
  GoodsIssueDate AS PrmtHbGoodsIssueDate,
  GoodsIssueTime AS PrmtHbGoodsIssueTime,
  STOLatestPossibleGRDate AS PrmtHbSTOLtstPosblGRDte,
  STOLatestPossibleGRTime AS PrmtHbSTOLtstPosblGRTme,
  GoodsReceiptQuantity AS PrmtHbGoodsReceiptQuantity,
  StockTransferDeliveredQuantity AS PrmtHbStkTransfDlvrdQty,
  ScheduleLineIssuedQuantity AS PrmtHbSchedLineIssdQty,
  Batch AS ProcmtHubBatch,
  ScheduleLineOrderDate AS PrmtHbScheduleLineOrderDate,
  SchedulingAgreementReleaseType AS PrmtHbSchdAgrRelType,
  CommittedDeliveryDate AS PrmtHbCommittedDeliveryDate,
  SchedgLineDataAgingFilterDate AS PrmtHbSchedDtaAgingFltrDte,
  PurchaseOrderQuantityUnit AS PrmtHbPurOrdQtyUnt,
  Currency AS ProcmtHubDocumentCurrency,
  ScheduleLineOpenQuantity AS PrmtHbSchdLnOpnQty,
  ScheduleLineOrderQuantity AS PrmtHbSchdLnOrdQty,
  RoughGoodsReceiptQty AS PrmtHbRoughGoodsReceiptQty,
  OpenPurchaseOrderQuantity AS PrmtHbOpnPurOrdQty
FROM I_CntrlPurOrderScheduleLine
LEFT OUTER JOIN I_ProcmtHubPurOrdHdrAPI01 AS _ProcmtHubPOHeader ON _ProcmtHubPOHeader.PurchaseOrder = PrmtHbRpldPurchaseOrder AND _ProcmtHubPOHeader.ExtSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubPurOrdItmAPI01 AS _ProcmtHubPOItem ON _ProcmtHubPOItem.PurchaseOrder = PrmtHbRpldPurchaseOrder AND _ProcmtHubPOItem.PurchaseOrderItem = PrmtHbRpldPurchaseOrderItem AND _ProcmtHubPOItem.ExtSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
;