I_CntrlPurgDocSchedLineEnhcd

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_CntrlPurgDocSchedLineEnhcd.
-- 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: ICPURGDOCSLENCD

CREATE VIEW I_CntrlPurgDocSchedLineEnhcd AS
SELECT
  ScheduleLineEnhanced.ebeln AS PurchasingDocument,
  ScheduleLineEnhanced.ebelp AS PurchasingDocumentItem,
  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 PurchasingDocumentStatus,
  ernam AS CreatedByUser,
  userdescription AS CreatedByUserName,
  LastChangeDateTime,
  procstat AS PurchasingProcessingStatus,
  bedat_pohdr AS PurchasingDocumentOrderDate,
  isaged AS PurchasingDocumentIsAged,
  menge_ekpo AS OrderQuantity,
  meins_ekpo AS PurchaseOrderQuantityUnit,
  producttype AS ProductTypeCode,
  frgrl AS ReleaseIsNotCompleted,
  retpo AS IsReturnsItem,
  eindt AS ScheduleLineDeliveryDate,
  slfdt AS SchedLineStscDeliveryDate,
  menge AS ScheduleLineOrderQuantity,
  ameng AS PrevDelivQtyOfScheduleLine,
  wemng AS GoodsReceiptQuantity,
  wamng AS ScheduleLineIssuedQuantity,
  uzeit AS ScheduleLineDeliveryTime,
  banfn AS PurchaseRequisition,
  bnfpo AS PurchaseRequisitionItem,
  estkz AS SourceOfCreation,
  bedat AS ScheduleLineOrderDate,
  abart AS SchedulingAgreementReleaseType,
  mng02 AS ScheduleLineCommittedQuantity,
  dat01 AS CommittedDeliveryDate,
  altdt AS SchedLinePrevDelivDate,
  mbdat AS ProductAvailabilityDate,
  mbuhr AS MaterialStagingTime,
  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,
  bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  bpumn AS OrdPriceUnitToOrderUnitDnmntr,
  peinh AS NetPriceQuantity,
  startdate AS PerformancePeriodStartDate,
  enddate AS PerformancePeriodEndDate,
  bprme AS OrderPriceUnit,
  lmein AS BaseUnit,
  reswk AS SupplyingPlant,
  umrez AS OrderItemQtyToBaseQtyNmrtr,
  umren AS OrderItemQtyToBaseQtyDnmntr
FROM mmpur_anaexteket AS ScheduleLineEnhanced
LEFT OUTER JOIN I_ProcmtHubPurgOrg AS _HubPurchasingOrg ON ProcurementHubSourceSystem = _HubPurchasingOrg.ProcurementHubSourceSystem AND PurchasingOrganization = _HubPurchasingOrg.ProcmtHubPurchasingOrg  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubPurgGroup AS _HubPurchasingGroup ON ProcurementHubSourceSystem = _HubPurchasingGroup.ProcurementHubSourceSystem AND PurchasingGroup = _HubPurchasingGroup.ProcmtHubPurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubSupplier AS _Supplier ON Supplier = _Supplier.ProcmtHubFixedSupplier AND ProcurementHubSourceSystem = _Supplier.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_BackendPlantForPurg AS _HubPlant ON Plant = _HubPlant.Plant AND CompanyCode = _HubPlant.CompanyCode AND ProcurementHubSourceSystem = _HubPlant.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_BackendCoCodeForPurg AS _HubCompanyCode ON CompanyCode = _HubCompanyCode.CompanyCode AND ProcurementHubSourceSystem = _HubCompanyCode.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubProduct AS _Material ON Material = _Material.ProcmtHubProduct AND ProcurementHubSourceSystem = _Material.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubProductGroup AS _ProcmtHubProductGroupVH ON MaterialGroup = _ProcmtHubProductGroupVH.ProcmtHubProductGroup AND ProcurementHubSourceSystem = _ProcmtHubProductGroupVH.ProcurementHubSourceSystem  -- 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 _POQuantityUnit ON PurchaseOrderQuantityUnit = _POQuantityUnit.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON PurchasingDocumentCategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubPurgDocItmCat AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.ItemCategory AND ProcurementHubSourceSystem = _PurgDocumentItemCategory.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_ProcmtHubPurgDocType AS _PurchasingDocumentType ON PurchasingDocumentCategory = _PurchasingDocumentType.PurchasingDocumentCategory AND PurchasingDocumentType = _PurchasingDocumentType.PurchasingDocumentType AND ProcurementHubSourceSystem = _PurchasingDocumentType.ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_BackendSourceSystem AS _BackendSourceSystem ON ProcurementHubSourceSystem = _BackendSourceSystem.ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
;