I_CentralPurchaseOrderItem

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_CentralPurchaseOrderItem.
-- 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: IMMCPURORDRITEM

CREATE VIEW I_CentralPurchaseOrderItem AS
SELECT
  ekpo.ebeln AS PurchaseOrder,
  ekpo.ebelp AS PurchaseOrderItem,
  ekpo.extsourcesystem AS ExtSourceSystem,
  ekpo.uniqueid AS ProcmtHubPOItemUniqueID,
  ekpo.bstyp AS PurchasingDocumentCategory,
  ekpo.loekz AS PurchasingDocumentDeletionCode,
  ekpo.matnr AS Material,
  ekpo.idnlf AS SupplierMaterialNumber,
  ekpo.ematn AS ManufacturerMaterial,
  ekpo.mfrpn AS ManufacturerPartNmbr,
  ekpo.mfrnr AS Manufacturer,
  ekpo.txz01 AS PurchaseOrderItemText,
  ekpo.bukrs AS CompanyCode,
  ekpo.werks AS Plant,
  ekpo.adrnr AS ManualDeliveryAddressID,
  ekpo.adrn2 AS ReferenceDeliveryAddressID,
  ekpo.kunnr AS Customer,
  ekpo.emlif AS Subcontractor,
  ekpo.lblkz AS SupplierIsSubcontractor,
  ekpo.satnr AS CrossPlantConfigurableProduct,
  ekpo.attyp AS ArticleCategory,
  ekpo.kanba AS PlndOrderReplnmtElmntType,
  ekpo.punei AS ProductPurchasePointsQtyUnit,
  ekpo.anzpu AS ProductPurchasePointsQty,
  cast (ekpo.lgort as vdm_storage_location preserving type) AS StorageLocation,
  ekpo.matkl AS MaterialGroup,
  ekpo.meins AS PurchaseOrderQuantityUnit,
  ekpo.umrez AS OrderItemQtyToBaseQtyNmrtr,
  ekpo.umren AS OrderItemQtyToBaseQtyDnmntr,
  cast (ekpo.peinh as vdm_price_unit preserving type) AS NetPriceQuantity,
  ekpo.elikz AS IsCompletelyDelivered,
  ekpo.erekz AS IsFinallyInvoiced,
  ekpo.wepos AS GoodsReceiptIsExpected,
  ekpo.repos AS InvoiceIsExpected,
  ekpo.webre AS InvoiceIsGoodsReceiptBased,
  ekpo.weunb AS GoodsReceiptIsNonValuated,
  ekpo.banfn AS PurchaseRequisition,
  ekpo.bnfpo AS PurchaseRequisitionItem,
  ekpo.packno AS ServicePackage,
  ekpo.serviceperformer AS ServicePerformer,
  ekpo.producttype AS ProductType,
  ekpo.mtart AS MaterialType,
  ekpo.ktpnr AS PurchaseContractItem,
  ekpo.konnr AS PurchaseContract,
  ekpo.requestforquotation AS RequestForQuotation,
  ekpo.requestforquotationitem AS RequestForQuotationItem,
  ekpo.xersy AS EvaldRcptSettlmtIsAllowed,
  ekpo.uebtk AS UnlimitedOverdeliveryIsAllowed,
  ekpo.uebto AS OverdelivTolrtdLmtRatioInPct,
  ekpo.untto AS UnderdelivTolrtdLmtRatioInPct,
  ekpo.afnam AS RequisitionerName,
  ekpo.inco1 AS IncotermsClassification,
  ekpo.inco2 AS IncotermsTransferLocation,
  ekpo.inco2_l AS IncotermsLocation1,
  ekpo.inco3_l AS IncotermsLocation2,
  ekpo.kolif AS PriorSupplier,
  ekpo.ean11 AS InternationalArticleNumber,
  ekpo.bstae AS SupplierConfirmationControlKey,
  ekpo.prsdr AS PriceIsToBePrinted,
  ekpo.lmein AS BaseUnit,
  ekpo.pstyp AS PurchaseOrderItemCategory,
  ekpo.ko_prctr AS ProfitCenter,
  ekpo.bprme AS OrderPriceUnit,
  ekpo.voleh AS ItemVolumeUnit,
  ekpo.gewei AS ItemWeightUnit,
  ekpo.vrtkz AS MultipleAcctAssgmtDistribution,
  ekpo.twrkz AS PartialInvoiceDistribution,
  ekpo.meprf AS PricingDateControl,
  ekpo.stapo AS IsStatisticalItem,
  ekpo.uebpo AS PurchasingParentItem,
  ekpo.lewed AS GoodsReceiptLatestCreationDate,
  ekpo.retpo AS IsReturnsItem,
  ekpo.bsgru AS PurchasingOrderReason,
  ekpo.knttp AS AccountAssignmentCategory,
  ekpo.infnr AS PurchasingInfoRecord,
  ekpo.netwr AS NetAmount,
  ekpo.brtwr AS GrossAmount,
  ekpo.effwr AS EffectiveAmount,
  ekpo.kzwi1 AS Subtotal1Amount,
  ekpo.kzwi2 AS Subtotal2Amount,
  ekpo.kzwi3 AS Subtotal3Amount,
  ekpo.kzwi4 AS Subtotal4Amount,
  ekpo.kzwi5 AS Subtotal5Amount,
  ekpo.kzwi6 AS Subtotal6Amount,
  ekpo.ktmng AS TargetQuantity,
  ekpo.menge AS OrderQuantity,
  ekpo.netpr AS NetPriceAmount,
  ekpo.zwert AS TargetAmount,
  ekpo.volum AS ItemVolume,
  ekpo.brgew AS ItemGrossWeight,
  ekpo.ntgew AS ItemNetWeight,
  ekpo.bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  ekpo.bpumn AS OrdPriceUnitToOrderUnitDnmntr,
  ekpo.abdat AS SchedAgrmtCumQtyReconcileDate,
  ekpo.abftz AS SchedAgrmtAgreedCumQty,
  ekpo.drdat AS ItemLastTransmissionDate,
  ekpo.etfz1 AS ScheduleLineFirmOrderInDays,
  ekpo.etfz2 AS SchedLineSemiFirmOrderInDays,
  ekpo.mahn1 AS NoDaysReminder1,
  ekpo.mahn2 AS NoDaysReminder2,
  ekpo.mahn3 AS NoDaysReminder3,
  ekpo.bednr AS RequirementTracking,
  ekpo.kzabs AS IsOrderAcknRqd,
  ekpo.insmk AS StockType,
  ekpo.mwskz AS TaxCode,
  ekpo.txjcd AS TaxJurisdiction,
  ekpo.taxprocedure AS TaxCalculationProcedure,
  ekpo.evers AS ShippingInstruction,
  ekpo.navnw AS NonDeductibleInputTaxAmount,
  ekpo.bwtar AS ValuationType,
  ekpo.bwtty AS ValuationCategory,
  ekpo.abskz AS ItemIsRejectedBySupplier,
  ekpo.prdat AS PurgDocPriceDate,
  ekpo.spinf AS IsInfoRecordUpdated,
  ekpo.abmng AS PurgDocReleaseOrderQuantity,
  ekpo.labnr AS PurgDocOrderAcknNumber,
  ekpo.schpr AS PurgDocEstimatedPrice,
  ekpo.ltsnr AS SupplierSubrange,
  ekpo.kblnr AS EarmarkedFunds,
  ekpo.kblpos AS EarmarkedFundsItem,
  ekpo.plifz AS PlannedDeliveryDurationInDays,
  ekpo.webaz AS GoodsReceiptDurationInDays,
  ekpo.kztlf AS PartialDeliveryIsAllowed,
  ekpo.kzvbr AS ConsumptionPosting,
  ekpo.abueb AS SchedgAgrmtRelCreationProfile,
  ekpo.spe_cq_ctrltype AS SchedAgrmtCumulativeQtyControl,
  ekpo.spe_cq_nocq AS CumulativeQuantityIsNotSent,
  ekpo.mhdrz AS MinRemainingShelfLife,
  cast( ekpo.iprkz as char1 preserving type ) AS ShelfLifeExpirationDatePeriod,
  ekpo.ssqss AS QualityMgmtCtrlKey,
  ekpo.sobkz AS InventorySpecialStockType,
  ekpo.fabkz AS IsRelevantForJITDelivSchedule,
  ekpo.nfabd AS NextJITDelivSchedSendingDate,
  ekpo.nlabd AS NextFcstDelivSchedSendingDate,
  ekpo.kzstu AS FirmTradeOffZoneBindMRP,
  ekpo.zgtyp AS QualityCertificateType,
  ekpo.anfnr AS SupplierQuotation,
  ekpo.anfps AS SupplierQuotationItem,
  ekpo.isvco AS IntrastatServiceCode,
  ekpo.stawn AS CommodityCode,
  ekpo.lfret AS DeliveryDocumentType,
  ekpo.mfrgr AS MaterialFreightGroup,
  ekpo.nrfhg AS DiscountInKindEligibility,
  ekpo.novet AS PurgItemIsBlockedForDelivery,
  ekpo.reslo AS IssuingStorageLocation,
  ekpo.abeln AS AllocationTable,
  ekpo.abelp AS AllocationTableItem,
  ekpo.aktnr AS RetailPromotion,
  ekpo.dptyp AS DownPaymentType,
  ekpo.dppct AS DownPaymentPercentageOfTotAmt,
  ekpo.dpamt AS DownPaymentAmount,
  ekpo.dpdat AS DownPaymentDueDate,
  ekpo.expected_value AS ExpectedOverallLimitAmount,
  ekpo.limit_amount AS OverallLimitAmount,
  ekpo.sgt_rcat AS RequirementSegment,
  ekpo.extmaterialforpurg AS PurchasingCentralMaterial,
  ekpo.target_value AS PurgDocItmTargetAmount,
  ekpo.status AS PurchaseOrderItemStatus,
  ekpo.isnoteavailable AS HasNote,
  ekpo.isattachmentavailable AS HasAttachment,
  ekpo.poitemdeliveryaddressid AS ItemDeliveryAddressID,
  ekpo.contract_for_limit AS PurContractForOverallLimit,
  _PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrder._DocumentCurrency AS _DocumentCurrency
FROM mmpur_ext_ekpo AS ekpo
LEFT OUTER JOIN I_CentralPurchaseOrder AS _PurchaseOrder ON PurchaseOrder = _PurchaseOrder.PurchaseOrder AND ExtSourceSystem = _PurchaseOrder.ExtSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurOrderAcctAssgmt AS _PurOrdAcctAssignment ON _PurOrdAcctAssignment.PurchaseOrder = PurchaseOrder AND _PurOrdAcctAssignment.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdAcctAssignment.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN I_CntrlPurOrderScheduleLine AS _PurOrdScheduleLine ON _PurOrdScheduleLine.PurchaseOrder = PurchaseOrder AND _PurOrdScheduleLine.PurchaseOrderItem = PurchaseOrderItem AND _PurOrdScheduleLine.ExtSourceSystem = ExtSourceSystem  -- association [1..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON PurchaseOrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON ItemVolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON ItemWeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderPriceUnit ON OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurgDocumentCategory ON PurchasingDocumentCategory = _PurgDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchaseOrderItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductType ON ProductType = _ProductType.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_ProductCategory AS _ProductCategory ON ArticleCategory = _ProductCategory.ProductCategory  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_ProcmtHubProduct AS _ProcmtHubProduct ON Material = _ProcmtHubProduct.ProcmtHubProduct AND ExtSourceSystem = _ProcmtHubProduct.ProcurementHubSourceSystem  -- association [0..1]
;