I_PurOrdScheduleLineEnhanced

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_PurOrdScheduleLineEnhanced.
-- 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: IMMPOSCHEDENH

CREATE VIEW I_PurOrdScheduleLineEnhanced AS
SELECT
  ebeln AS PurchaseOrder,
  ebelp AS PurchaseOrderItem,
  etenr AS ScheduleLine,
  be_source_sys AS ProcurementHubSourceSystem,
  uniqueid AS ScheduleLineUniqueID,
  ekorg AS PurchasingOrganization,
  ekgrp AS PurchasingGroup,
  bukrs AS CompanyCode,
  bukrs_pohdr AS PurgDocHdrCompanyCode,
  lifnr AS Supplier,
  werks AS Plant,
  matnr AS Material,
  matkl AS MaterialGroup,
  _PurchaseOrderItem.PurchaseOrderItemText AS PurchaseOrderItemText,
  ServicePerformer,
  waers AS DocumentCurrency,
  zero_val_repcurr_ind AS AnlytlCrcyExchangeRateStatus,
  netpr_repcurr1 AS NetPriceInReportingCurrency,
  netpr_repcurr2 AS NetPriceInReportingCurrency2,
  netpr AS NetPriceAmount,
  netpr_base AS NetPriceInCompanyCodeCrcy,
  waers_repcurr1 AS AnalyticalReportingCurrency,
  waers_repcurr2 AS AnalyticalReportingCurrency2,
  waers_base AS CompanyCodeCurrency,
  netwr_sl_repcurr1 AS NetAmountInReportingCurrency,
  netwr_sl_repcurr2 AS NetAmountInReportingCurrency2,
  netwr AS NetAmount,
  netwr_base AS NetAmountInCoCodeCurrency,
  obmng_netwr_repcurr1 AS OpenAmountInReportingCurrency,
  obmng_netwr_repcurr2 AS OpenAmountInReportingCurrency2,
  obmng_netwr AS OpenAmountInDocumentCurrency,
  obmng_netwr_base AS OpenAmountInCompanyCodeCrcy,
  obmng AS ScheduleLineOpenQuantity,
  meins AS OrderQuantityUnit,
  elikz AS IsCompletelyDelivered,
  wepos AS GoodsReceiptIsExpected,
  loekz_pohdr AS PurchasingDocumentDeletionCode,
  loekz AS PurgDocumentItemDeletionCode,
  memory AS PurchasingCompletenessStatus,
  ndd AS PurgDocSchdLnHasNextDelivery,
  bstyp AS PurchaseOrderCategory,
  bsart AS PurchaseOrderType,
  pstyp AS PurchaseOrderItemCategory,
  knttp AS AccountAssignmentCategory,
  aedat AS CreationDate,
  statu AS PurchasingDocumentOrigin,
  ernam AS CreatedByUser,
  LastChangeDateTime,
  procstat AS PurchasingProcessingStatus,
  bedat_pohdr AS PurchaseOrderDate,
  isaged AS PurchasingDocumentIsAged,
  menge_ekpo AS OrderQuantity,
  meins_ekpo AS PurchaseOrderQuantityUnit,
  producttype AS ProductTypeCode,
  frgrl AS ReleaseIsNotCompleted,
  firstgrpostingdate AS PurOrdItmFirstGRPostingDate,
  finalgrpostingdate AS PurOrdItmFinalGRPostingDate,
  or_firstgrpostingdate AS OriglPurOrdItm1stGRPostgDte,
  or_finalgrpostingdate AS OriglPurOrdItmFnlGRPostgDte,
  finalscheduleline AS POItmFinalScheduleLineIsActive,
  lastexpectedquantity AS POPrevSchdLnTotalExpectedQty,
  totalexpectedquantity AS POScheduleLineTotalExpectedQty,
  TimeVarianceInDays,
  TimeVarianceInPct,
  TimeVarianceInPctByDelivDate,
  TimeVarianceScore,
  TimeVarianceScoreByDelivDate,
  eindt AS ScheduleLineDeliveryDate,
  slfdt AS SchedLineStscDeliveryDate,
  or_eindt AS OriglPOSchdLnDelivDte,
  or_slfdt AS OriglPOSchedLineStstclDelivDte,
  lpein AS DelivDateCategory,
  menge AS ScheduleLineOrderQuantity,
  ameng AS PrevDelivQtyOfScheduleLine,
  wemng AS GoodsReceiptQuantity,
  wamng AS ScheduleLineIssuedQuantity,
  uzeit AS ScheduleLineDeliveryTime,
  banfn AS PurchaseRequisition,
  bnfpo AS PurchaseRequisitionItem,
  estkz AS SourceOfCreation,
  mahnz AS PurchasingSchdLnNrOfReminders,
  abart AS SchedulingAgreementReleaseType,
  mng02 AS ScheduleLineCommittedQuantity,
  mbdat AS ProductAvailabilityDate,
  mbuhr AS ProductAvailabilityTime,
  lddat AS LoadingDate,
  lduhr AS LoadingTime,
  tddat AS TransportationPlanningDate,
  tduhr AS TransportationPlanningTime,
  wadat AS GoodsIssueDate,
  wauhr AS GoodsIssueTime,
  eldat AS STOLatestPossibleGRDate,
  eluhr AS STOLatestPossibleGRTime,
  ktpnr AS PurchaseContractItem,
  konnr AS PurchaseContract,
  vrtkz AS MultipleAcctAssgmtDistribution,
  retpo AS IsReturnsItem,
  bstae AS SupplierConfirmationControlKey,
  peinh AS NetPriceQuantity,
  umrez AS OrderItemQtyToBaseQtyNmrtr,
  umren AS OrderItemQtyToBaseQtyDnmntr,
  lmein AS BaseUnit,
  bprme AS OrderPriceUnit,
  reswk AS SupplyingPlant,
  gjahr AS MaterialDocumentYear,
  belnr AS MaterialDocument,
  buzei AS MaterialDocumentItem,
  budat AS PostingDate,
  dimension_ind AS PurOrdItmAnlytsIndIsActv
FROM mmpur_ana_eket
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItem.PurchaseOrderItem  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCodeHdr ON PurgDocHdrCompanyCode = _CompanyCodeHdr.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AnalyticalReportingCurrency ON AnalyticalReportingCurrency = _AnalyticalReportingCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AnalyticalReportingCurrency2 ON AnalyticalReportingCurrency2 = _AnalyticalReportingCurrency2.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _POQuantityUnit ON PurchaseOrderQuantityUnit = _POQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchaseOrderItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchaseOrderCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchaseOrderCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchaseOrderType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_Deliverydatecategory AS _DeliveryDateCategory ON DelivDateCategory = _DeliveryDateCategory.DelivDateCategory  -- association [1..1]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisition AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [1..1]
LEFT OUTER JOIN I_BackendSourceSystem AS _BackendSourceSystem ON ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem  -- association [1..1]
;