I_SchedgAgrmtSchedLineEnhcd

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_SchedgAgrmtSchedLineEnhcd.
-- 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: ISCHEDGAGRMTENHD

CREATE VIEW I_SchedgAgrmtSchedLineEnhcd AS
SELECT
  ScheduleLineEnhanced.ebeln AS SchedulingAgreement,
  ScheduleLineEnhanced.ebelp AS SchedulingAgreementItem,
  ScheduleLineEnhanced.etenr AS ScheduleLine,
  be_source_sys AS ProcurementHubSourceSystem,
  ScheduleLineEnhanced.uniqueid AS ScheduleLineUniqueID,
  ScheduleLineEnhanced.ekorg AS PurchasingOrganization,
  ScheduleLineEnhanced.ekgrp AS PurchasingGroup,
  ScheduleLineEnhanced.bukrs AS CompanyCode,
  ScheduleLineEnhanced.lifnr AS Supplier,
  ScheduleLineEnhanced.werks AS Plant,
  ScheduleLineEnhanced.matnr AS Material,
  ScheduleLineEnhanced.matkl AS MaterialGroup,
  ScheduleLineEnhanced.serviceperformer AS ServicePerformer,
  zero_val_repcurr_ind AS AnlytlCrcyExchangeRateStatus,
  waers_repcurr1 AS AnalyticalReportingCurrency,
  waers_repcurr2 AS AnalyticalReportingCurrency2,
  waers AS DocumentCurrency,
  waers_base AS CompanyCodeCurrency,
  netpr_repcurr1 AS NetPriceInReportingCurrency,
  netpr_repcurr2 AS NetPriceInReportingCurrency2,
  netpr AS NetPriceAmount,
  netpr_base AS NetPriceInCompanyCodeCrcy,
  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 AS PurchasingDocumentDeletionCode,
  memory AS PurchasingCompletenessStatus,
  bstyp AS PurchasingDocumentCategory,
  bsart AS PurchasingDocumentType,
  pstyp AS PurchasingDocumentItemCategory,
  knttp AS AccountAssignmentCategory,
  aedat AS CreationDate,
  statu AS PurchasingDocumentOrigin,
  ernam AS CreatedByUser,
  LastChangeDateTime,
  procstat AS PurchasingProcessingStatus,
  bedat_pohdr AS PurchasingDocumentOrderDate,
  isaged AS PurchasingDocumentIsAged,
  menge_ekpo AS OrderQuantity,
  meins_ekpo AS PurgDocOrderQuantityUnit,
  producttype AS ProductTypeCode,
  frgrl AS ReleaseIsNotCompleted,
  retpo AS IsReturnsItem,
  ndd AS PurgDocSchdLnHasNextDelivery,
  eindt AS ScheduleLineDeliveryDate,
  slfdt AS SchedLineStscDeliveryDate,
  or_eindt AS OriglPurgDocSchedLineDelivDte,
  or_slfdt AS OriglPurgDocItemStstclDelivDte,
  lpein AS DelivDateCategory,
  menge AS ScheduleLineOrderQuantity,
  ameng AS PrevDelivQtyOfScheduleLine,
  wemng AS GoodsReceiptQuantity,
  wamng AS ScheduleLineIssuedQuantity,
  uzeit AS ScheduleLineDeliveryTime,
  banfn AS PurchaseRequisition,
  bnfpo AS PurchaseRequisitionItem,
  lgort AS StorageLocation,
  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,
  wemng AS RoughGoodsReceiptQty,
  ktpnr AS PurchaseContractItem,
  konnr AS PurchaseContract,
  vrtkz AS MultipleAcctAssgmtDistribution,
  bedat AS PurchaseOrderDate,
  bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  bpumn AS OrdPriceUnitToOrderUnitDnmntr,
  peinh AS NetPriceQuantity,
  bprme AS OrderPriceUnit,
  startdate AS PerformancePeriodStartDate,
  enddate AS PerformancePeriodEndDate,
  reswk AS SupplyingPlant,
  dimension_ind AS PurgDocItmAnlytsIndIsActv,
  firstgrpostingdate AS PurDocItmFirstGRPostingDate,
  finalgrpostingdate AS PurDocItmFinalGRPostingDate,
  or_firstgrpostingdate AS OriglPurgDocItm1stGRPostgDte,
  or_finalgrpostingdate AS OriglPurgDocItmFnlGRPostgDte,
  TimeVarianceInDays,
  TimeVarianceInPct,
  TimeVarianceInPctByDelivDate,
  TimeVarianceScore,
  TimeVarianceScoreByDelivDate
FROM mmpur_ana_eket AS ScheduleLineEnhanced
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_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 _PurgDocQuantityUnit ON PurgDocOrderQuantityUnit = _PurgDocQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _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]
;