P_Inforecordmanagesosdraft

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_Inforecordmanagesosdraft.
-- 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: PIRMNGSOSDRAFT

CREATE VIEW P_Inforecordmanagesosdraft AS
SELECT
  draft.guid AS Guid,
  draft.infnr AS PurchasingInfoRecord,
  draft.ekorg AS PurchasingOrganization,
  draft.werks AS Plant,
  draft.esokz AS PurchasingInfoRecordCategory,
  draft.lifnr AS Supplier,
  draft.matnr AS Material,
  draft.entitystate AS Entitystate,
  coalesce(draft.matkl, _Material._MaterialGroup.MaterialGroup ) as MaterialGroup AS MaterialGroupasMaterialGroup,
  draft.loekz_a AS GeneralDataDeleted,
  draft.txz01 AS PurchasingInfoRecordDesc,
  draft.meins AS OrderUnit,
  draft.umrez AS OrderItemQtyToBaseQtyNmrtr,
  draft.umren AS OrderItemQtyToBaseQtyDnmntr,
  draft.idnlf AS SupplierMaterialNumber,
  draft.verkf AS SalesPerson,
  draft.telf1 AS SupplierPhoneNumber,
  draft.lmein AS BaseUnit,
  draft.wglif AS SupplierMaterialGroup,
  draft.kolif AS PriorSupplier,
  draft.lifab AS AvailableFromDate,
  draft.lifbi AS AvailableToDate,
  draft.vabme AS vabme,
  draft.relif AS relif,
  draft.loekz_e AS isMarkedForDeletion,
  draft.ekgrp AS PurchasingGroup,
  draft.waers AS Currency,
  draft.minbm AS MinimumPurchaseOrderQuantity,
  draft.norbm AS StandardPurchaseOrderQuantity,
  draft.aplfz AS MaterialPlannedDeliveryDurn,
  draft.uebto AS OverdelivTolrtdLmtRatioInPct,
  draft.untto AS UnderdelivTolrtdLmtRatioInPct,
  draft.uebtk AS uebtk,
  draft.ebeln AS ebeln,
  draft.ebelp AS ebelp,
  draft.netpr AS NetPriceAmount,
  draft.peinh AS MaterialPriceUnitQty,
  draft.bprme AS PurchaseOrderPriceUnit,
  draft.prdat AS PriceValidityEndDate,
  draft.bpumz AS bpumz,
  draft.bpumn AS bpumn,
  draft.webre AS InvoiceIsGoodsReceiptBased,
  draft.mwskz AS TaxCode,
  draft.inco1 AS IncotermsClassification,
  draft.inco2 AS IncotermsTransferLocation,
  draft.bstma AS MaximumOrderQuantity,
  draft.aut_source AS IsRelevantForAutomSrcg,
  draft.crea_uname AS Creator,
  _User.techdesc AS CreatorName,
  draft.crea_date_time AS DraftCreationDate,
  draft.lchg_date_time AS DraftChangeDate
FROM eina_eine_d AS draft
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN usr21 AS _User ON draft.crea_uname = _User.bname  -- association [0..1]
;