P_AnaHubPurOrdSchdlnMigrData

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 P_AnaHubPurOrdSchdlnMigrData.
-- 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: PANAHUBPOMIGR

CREATE VIEW P_AnaHubPurOrdSchdlnMigrData AS
SELECT
  _PurchaseOrderScheduleLine.PurchaseOrder AS ebeln,
  _PurchaseOrderScheduleLine.PurchaseOrderItem AS ebelp,
  _PurchaseOrderScheduleLine.ScheduleLine AS etenr,
  _PurchaseOrder.ExtSourceSystem AS BE_SOURCE_SYS,
  concat(_PurchaseOrderScheduleLine.PurchaseOrder, concat(_PurchaseOrderScheduleLine.PurchaseOrderItem, _PurchaseOrderScheduleLine.ScheduleLine ) ) AS uniqueid,
  cast ( 0 as bwert_repcrcy1 ) AS NETWR_SL_REPCURR1,
  cast ( 0 as bwert_repcrcy2 ) AS NETWR_SL_REPCURR2,
  cast ( '' as waers_repcurr1 ) AS WAERS_REPCURR1,
  cast ( '' as waers_repcurr2 ) AS WAERS_REPCURR2,
  _PurchaseOrderItem.NetAmount AS netwr,
  _PurchaseOrder.DocumentCurrency AS waers,
  cast ( 0 as bwert_basecurr ) AS NETWR_BASE,
  _PurchaseOrder.DocumentCurrency AS WAERS_BASE,
  cast(0 as obmng ) AS OBMNG,
  cast ( 0 as obmng_curr ) AS OBMNG_NETWR,
  cast ( 0 as obmng_repcurr1 ) AS OBMNG_NETWR_REPCURR1,
  cast ( 0 as obmng_repcurr2 ) AS OBMNG_NETWR_REPCURR2,
  cast ( 0 as obmng_basecurr ) AS OBMNG_NETWR_BASE,
  _PurchaseOrderItem.NetPriceAmount AS netpr,
  cast ( 0 as netpr_repcrcy1 ) AS NETPR_REPCURR1,
  cast ( 0 as netpr_repcrcy2) AS NETPR_REPCURR2,
  cast ( 0 as netpr_basecurr ) AS NETPR_BASE,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS meins,
  cast ( '0' as abap.char (2) ) AS ZERO_VAL_REPCURR_IND,
  _PurchaseOrder.PurchasingOrganization AS ekorg,
  _PurchaseOrder.PurchasingGroup AS ekgrp,
  _PurchaseOrderItem.CompanyCode AS bukrs,
  _PurchaseOrderItem.Plant AS werks,
  _PurchaseOrder.Supplier AS lifnr,
  _PurchaseOrderItem.Material AS matnr,
  _PurchaseOrderItem.MaterialGroup AS matkl,
  _PurchaseOrderItem.ServicePerformer AS SERVICEPERFORMER,
  _PurchaseOrderItem.IsCompletelyDelivered AS elikz,
  _PurchaseOrderItem.GoodsReceiptIsExpected AS wepos,
  _PurchaseOrderItem.PurchasingDocumentDeletionCode AS loekz,
  _PurchaseOrder.PurchasingCompletenessStatus AS memory,
  _PurchaseOrder.PurchasingDocumentCategory AS bstyp,
  _PurchaseOrder.PurchaseOrderType AS bsart,
  _PurchaseOrderItem.PurchaseOrderItemCategory AS pstyp,
  _PurchaseOrderItem.AccountAssignmentCategory AS knttp,
  _PurchaseOrderItem.MultipleAcctAssgmtDistribution AS vrtkz,
  _PurchaseOrderItem.PurchaseContract AS konnr,
  _PurchaseOrderItem.PurchaseContractItem AS KTPNR,
  _PurchaseOrder.CreationDate AS aedat,
  _PurchaseOrder.PurchasingDocumentOrigin AS STATU,
  _PurchaseOrder.CreatedByUser AS ernam,
  _PurchaseOrder.PurchasingProcessingStatus AS procstat,
  _PurchaseOrder.PurchasingDocumentOrderDate AS BEDAT_POHDR,
  _PurchaseOrder.PurchasingDocumentIsAged AS isaged,
  _PurchaseOrderItem.OrderQuantity AS MENGE_EKPO,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS MEINS_EKPO,
  _PurchaseOrderItem.OrderPriceUnitToOrderUnitNmrtr AS BPUMZ,
  _PurchaseOrderItem.OrdPriceUnitToOrderUnitDnmntr AS bpumn,
  _PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr AS umrez,
  _PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr AS umren,
  _PurchaseOrderItem.ProductType AS PRODUCTTYPE,
  _PurchaseOrderItem.IsReturnsItem AS retpo,
  _PurchaseOrder.ReleaseIsNotCompleted AS frgrl,
  cast ( '' as abap.char (1) ) AS FinalScheduleLine,
  cast ( 0 as abap.int4 ) AS TOTALEXPECTEDQUANTITY,
  cast ( 0 as abap.int4 ) AS LASTEXPECTEDQUANTITY,
  cast ( '' as abap.char (1) ) AS NDD,
  _PurchaseOrderScheduleLine.ScheduleLineDeliveryDate AS eindt,
  _PurchaseOrderScheduleLine.SchedLineStscDeliveryDate AS slfdt,
  _PurchaseOrderScheduleLine.DelivDateCategory AS lpein,
  _PurchaseOrderScheduleLine.ScheduleLineOrderQuantity AS menge,
  _PurchaseOrderScheduleLine.PrevDelivQtyOfScheduleLine AS ameng,
  _PurchaseOrderScheduleLine.RoughGoodsReceiptQty AS wemng,
  _PurchaseOrderScheduleLine.ScheduleLineIssuedQuantity AS wamng,
  _PurchaseOrderScheduleLine.ScheduleLineDeliveryTime AS uzeit,
  _PurchaseOrderScheduleLine.PurchaseRequisition AS banfn,
  _PurchaseOrderScheduleLine.PurchaseRequisitionItem AS bnfpo,
  _PurchaseOrderScheduleLine.SourceOfCreation AS estkz,
  _PurchaseOrderScheduleLine.NoOfRemindersOfScheduleLine AS mahnz,
  _PurchaseOrderScheduleLine.ScheduleLineOrderDate AS bedat,
  _PurchaseOrderScheduleLine.ScheduleLineIsFixed AS fixkz,
  _PurchaseOrderScheduleLine.SchedulingAgreementReleaseType AS abart,
  _PurchaseOrderScheduleLine.ScheduleLineCommittedQuantity AS mng02,
  _PurchaseOrderScheduleLine.CommittedDeliveryDate AS dat01,
  _PurchaseOrderScheduleLine.SchedLinePrevDelivDate AS altdt,
  _PurchaseOrderScheduleLine.ProductAvailabilityDate AS mbdat,
  _PurchaseOrderScheduleLine.MaterialStagingTime AS mbuhr,
  _PurchaseOrderScheduleLine.LoadingDate AS lddat,
  _PurchaseOrderScheduleLine.LoadingTime AS lduhr,
  _PurchaseOrderScheduleLine.TransportationPlanningDate AS tddat,
  _PurchaseOrderScheduleLine.TransportationPlanningTime AS tduhr,
  _PurchaseOrderScheduleLine.GoodsIssueDate AS wadat,
  _PurchaseOrderScheduleLine.GoodsIssueTime AS wauhr,
  _PurchaseOrderScheduleLine.STOLatestPossibleGRDate AS eldat,
  _PurchaseOrderScheduleLine.STOLatestPossibleGRTime AS eluhr,
  _PurchaseOrderScheduleLine.PerformancePeriodStartDate AS startdate,
  _PurchaseOrderScheduleLine.PerformancePeriodEndDate AS enddate,
  _PurchaseOrderScheduleLine.SchedgLineDataAgingFilterDate AS _dataaging,
  _PurchaseOrderItem.NetPriceQuantity AS peinh,
  _PurchaseOrder.PurchasingDocumentDeletionCode AS LOEKZ_POHDR,
  CreatedByUserName AS USERDESCRIPTION,
  _PurchaseOrderItem.OrderPriceUnit AS bprme,
  _PurchaseOrderItem.BaseUnit AS lmein,
  _PurchaseOrder.SupplyingPlant AS reswk,
  ProcmtHubLastExtractionTime
FROM I_CentralPurchaseOrder AS _PurchaseOrder
INNER JOIN I_CentralPurchaseOrderItem AS _PurchaseOrderItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_CntrlPurOrderScheduleLine AS _PurchaseOrderScheduleLine ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_PrmtHbRpldPurchaseOrder AS _PrmtHbRpldPurchaseOrder ON _PrmtHbRpldPurchaseOrder.PurchaseOrder = ebeln AND _PrmtHbRpldPurchaseOrder.ExtSourceSystem = BE_SOURCE_SYS  -- association [1..1]
LEFT OUTER JOIN E_PrmtHbRpldPurchaseOrderItem AS _PrmtHbRpldPurchaseOrderItem ON _PrmtHbRpldPurchaseOrderItem.PurchaseOrder = ebeln AND _PrmtHbRpldPurchaseOrderItem.PurchaseOrderItem = ebelp AND _PrmtHbRpldPurchaseOrderItem.ExtSourceSystem = BE_SOURCE_SYS  -- association [1..1]
;