P_PurOrdMaintainItemDraft

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_PurOrdMaintainItemDraft.
-- 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: PPOMAINTITMDRAFT

CREATE VIEW P_PurOrdMaintainItemDraft AS
SELECT
  ekpo_po_d.guid AS PurchaseOrderItemDraftUUID,
  ekpo_po_d.parent_guid AS PurchaseOrderHeaderDraftUUID,
  ekpo_po_d.ebeln AS PurchaseOrder,
  ekpo_po_d.ebelp AS PurchaseOrderItem,
  ekpo_po_d.txz01 AS PurchasingDocumentItemText,
  ekpo_po_d.matnr AS Material,
  ekpo_po_d.mtart AS MaterialType,
  ekpo_po_d.matkl AS MaterialGroup,
  ekpo_po_d.werks AS Plant,
  ekpo_po_d.lgort AS StorageLocation,
  ekpo_po_d.meins AS PurchaseOrderQuantityUnit,
  ekpo_po_d.menge AS PurchaseOrderQty,
  ekpo_po_d.netpr AS PurchaseOrderNetPriceAmount,
  ekpo_po_d.netwr AS PurchaseOrderNetAmount,
  ekpo_po_d.mmpo_netprice_is_derived AS NetPriceIsDerived,
  ekpo_po_d.effwr AS PurOrderEffectiveItemAmount,
  ekpo_po_d.peinh AS PurchaseOrderNetPriceQuantity,
  ekpo_po_d.bprme AS PurchaseOrderPriceUnit,
  ekpo_po_d.kunnr AS Customer,
  ekpo_po_d.mwskz AS TaxCode,
  ekpo_po_d.txjcd AS TaxJurisdiction,
  ekpo_po_d.wepos AS GoodsReceiptIsExpected,
  ekpo_po_d.weunb AS GoodsReceiptIsNonValuated,
  ekpo_po_d.repos AS InvoiceIsExpected,
  ekpo_po_d.webre AS InvoiceIsGoodsReceiptBased,
  ekpo_po_d.uebto AS OverdelivTolrtdLmtRatioInPct,
  ekpo_po_d.uebtk AS UnlimitedOverdeliveryIsAllowed,
  ekpo_po_d.untto AS UnderdelivTolrtdLmtRatioInPct,
  ekpo_po_d.umrez AS OrderItemQtyToBaseQtyNmrtr,
  ekpo_po_d.umren AS OrderItemQtyToBaseQtyDnmntr,
  ekpo_po_d.infnr AS RefPurOrderInfoRecord,
  ekpo_po_d.konnr AS RefPurchaseOutlineAgreement,
  ekpo_po_d.ktpnr AS RefPurchOutlineAgrmtItem,
  ekpo_po_d.pstyp AS PurchaseOrderItemCategory,
  ekpo_po_d.epstp AS PurgDocExternalItemCategory,
  ekpo_po_d.knttp AS AcctAssignmentCategory,
  ekpo_po_d.loekz AS IsDeleted,
  ekpo_po_d.kostl AS CostCenter,
  ekpo_po_d.kokrs AS ControllingArea,
  ekpo_po_d.prctr AS ProfitCenter,
  ekpo_po_d.ps_psp_pnr AS WBSElementInternalID,
  ekpo_po_d.fkber AS FunctionalArea,
  ekpo_po_d.vbeln AS SalesOrder,
  ekpo_po_d.vbelp AS SalesOrderItem,
  ekpo_po_d.sakto AS GLAccount,
  ekpo_po_d.freetextinput AS FreeTextInput,
  cast( ekpo_po_d.eindt as abap.char(8)) AS DeliveryDate,
  ekpo_po_d.mmpur_servproc_period_start AS PerformancePeriodStartDate,
  ekpo_po_d.mmpur_servproc_period_end AS PerformancePeriodEndDate,
  ekpo_po_d.adrnr AS ManualDeliveryAddressID,
  ekpo_po_d.ad_name1 AS DeliveryAddressName,
  ekpo_po_d.ad_street AS DeliveryAddressStreetName,
  ekpo_po_d.ad_hsnm1 AS DeliveryAddressHouseNumber,
  ekpo_po_d.ad_pstcd1 AS DeliveryAddressPostalCode,
  ekpo_po_d.ad_city1 AS DeliveryAddressCityName,
  ekpo_po_d.regio AS DeliveryAddressRegion,
  ekpo_po_d.land1 AS DeliveryAddressCountry,
  ekpo_po_d.idnlf AS SupplierMaterialNumber,
  ekpo_po_d.inco1 AS IncotermsClassification,
  ekpo_po_d.inco2 AS IncotermsTransferLocation,
  ekpo_po_d.inco2_l AS IncotermsLocation1,
  ekpo_po_d.inco3_l AS IncotermsLocation2,
  ekpo_po_d.bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  ekpo_po_d.bpumn AS OrdPriceUnitToOrderUnitDnmntr,
  ekpo_po_d.elikz AS IsCompletelyDelivered,
  ekpo_po_d.erekz AS IsFinallyInvoiced,
  ekpo_po_d.kalsm_taxcode AS TaxCalculationProcedure,
  ekpo_po_d.kalsm_taxjur AS TaxJurisdictionCalcProcedure,
  ekpo_po_d.serviceperformer AS ServicePerformer,
  ekpo_po_d.producttype AS ProductType,
  ekpo_po_d.packno AS ServicePackage,
  ekpo_po_d.sumlimit AS OverallLimitAmount,
  ekpo_po_d.sumnolim AS OverallLimitAmountIsUnlimited,
  ekpo_po_d.commitment AS ExpectedOverallLimitAmount,
  _PurOrdMaintainHeaderDraft.Currency AS Currency,
  _PurOrdMaintainHeaderDraft.PricingProcedure AS PricingProcedure,
  _PurOrdMaintainHeaderDraft.PurchasingDocumentType AS PurchasingDocumentType,
  _PurOrdMaintainHeaderDraft.PurchasingOrganization AS PurchasingOrganization,
  _PurOrdMaintainHeaderDraft.PurchasingGroup AS PurchasingGroup,
  _PurOrdMaintainHeaderDraft.Supplier AS Supplier,
  _PurOrdMaintainHeaderDraft.IncotermsVersion AS IncotermsVersion,
  cast('X' as abap.char(1)) AS IsDraft,
  case when ekpo_po_d.ebeln is null or ekpo_po_d.ebeln = '' then cast('' as abap.char(1)) else cast('X' as abap.char(1)) end as HasTwin AS char1endasHasTwin,
  ekpo_po_d.crea_uname AS CreatedByUser,
  ekpo_po_d.lchg_uname AS LastChangeUser,
  ekpo_po_d.lchg_date_time AS LastChangeDateTime
FROM ekpo_po_d
LEFT OUTER JOIN P_PurOrdMaintainHeaderDraft AS _PurOrdMaintainHeaderDraft ON ekpo_po_d.parent_guid = _PurOrdMaintainHeaderDraft.PurchaseOrderHeaderDraftUUID  -- association [1..1]
;