PPS_V_EKPO_EXT

DDL: PPS_V_EKPO_EXT SQL: PPS_V_EKPO Type: view
65 Fields 2 Data Sources

PPS: View on EKPO+PPS_EKPO_EXT

PPS_V_EKPO_EXT is a CDS View that provides data about "PPS: View on EKPO+PPS_EKPO_EXT" in SAP S/4HANA. It reads from 2 data sources (ekpo, pps_ekpo_ext) and exposes 65 fields with key fields Ebeln, Ebelp.

Data Sources (2)

SourceAliasJoin Type
ekpo ekpo from
pps_ekpo_ext pps_ekpo_ext left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PPS_V_EKPO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PPS: View on EKPO+PPS_EKPO_EXT view
ObjectModel.usageType.serviceQuality #P view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY Ebeln ekpo ebeln Source PurchDoc
KEY Ebelp ekpo ebelp Item pur. doc.
Uniqueid ekpo uniqueid Schedule line
Loekz ekpo loekz Status
Statu ekpo statu Vehicle Status
Aedat ekpo aedat Obsolete
Txz01 ekpo txz01 Text
Matnr ekpo matnr Vehicle Model
Ematn ekpo ematn MPN: Material
Bukrs ekpo bukrs Value
Werks ekpo werks Receiving Plant
Lgort ekpo lgort Sublocation
Bednr ekpo bednr Tracking Number
Matkl ekpo matkl Product Sold Group
Infnr ekpo infnr Info Record
Idnlf ekpo idnlf Vendor Material
Ktmng ekpo ktmng Target Quantity
Menge ekpo menge WarrCountValue
Meins ekpo meins Valuation Unit
Bprme ekpo bprme PO Price Unit
Bpumz ekpo bpumz Qty Conversion
Bpumn ekpo bpumn Qty Conversion
Umrez ekpo umrez Numerator
Umren ekpo umren Denominator
Netpr ekpo netpr Price
Peinh ekpo peinh Unit of measure
Netwr ekpo netwr Value
Brtwr ekpo brtwr Gross value
Agdat ekpo agdat Submission Date
Webaz ekpo webaz GR Proc. Time
Mwskz ekpo mwskz Tax Code
TxdatFrom ekpo txdat_from Tax Rate Valid-From
Txdat ekpo txdat Tax Date
TaxCountry ekpo tax_country Tax Ctry/Rgn
Prdat ekpo prdat Valid to
Bstyp ekpo bstyp Source doc.cat.
Effwr ekpo effwr Effective value
Xoblr ekpo xoblr Commitments
Kunnr ekpo kunnr Stock customer
Adrnr ekpo adrnr Sold-To Address
Ekkol ekpo ekkol Condition Group
Sktof ekpo sktof No Cash Disc.
Stafo ekpo stafo Update Group
Plifz ekpo plifz Plnd Deliv.Time
Ntgew ekpo ntgew Net Weight
Gewei ekpo gewei Weight Unit
Txjcd ekpo txjcd Tax Jurisdict.
Etdrk ekpo etdrk Print-relevant
Sobkz ekpo sobkz Special Stock
Arsnr ekpo arsnr Settle.reser.No
Arsps ekpo arsps Settle.item no.
Insnc ekpo insnc Not changeable
Ssqss ekpo ssqss QM Control Key
Zgtyp ekpo zgtyp CertificateType
Ean11 ekpo ean11 EAN/UPC
Bstae ekpo bstae Conf. Control
Revlv ekpo revlv Revision Level
Brgew ekpo brgew Weight
Volum ekpo volum Volume
Voleh ekpo voleh Volume Unit
Inco1 ekpo inco1 Incoterms
Inco2 ekpo inco2 Incoterms 2
Vorab ekpo vorab Prelim. order
Kolif ekpo kolif Prior Supplier
Ltsnr ekpo ltsnr Suppl. Subrange

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 PPS_V_EKPO_EXT.
-- 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: PPS_V_EKPO

CREATE VIEW PPS_V_EKPO_EXT AS
SELECT
  ekpo.ebeln AS Ebeln,
  ekpo.ebelp AS Ebelp,
  ekpo.uniqueid AS Uniqueid,
  ekpo.loekz AS Loekz,
  ekpo.statu AS Statu,
  ekpo.aedat AS Aedat,
  ekpo.txz01 AS Txz01,
  ekpo.matnr AS Matnr,
  ekpo.ematn AS Ematn,
  ekpo.bukrs AS Bukrs,
  ekpo.werks AS Werks,
  ekpo.lgort AS Lgort,
  ekpo.bednr AS Bednr,
  ekpo.matkl AS Matkl,
  ekpo.infnr AS Infnr,
  ekpo.idnlf AS Idnlf,
  ekpo.ktmng AS Ktmng,
  ekpo.menge AS Menge,
  ekpo.meins AS Meins,
  ekpo.bprme AS Bprme,
  ekpo.bpumz AS Bpumz,
  ekpo.bpumn AS Bpumn,
  ekpo.umrez AS Umrez,
  ekpo.umren AS Umren,
  ekpo.netpr AS Netpr,
  ekpo.peinh AS Peinh,
  ekpo.netwr AS Netwr,
  ekpo.brtwr AS Brtwr,
  ekpo.agdat AS Agdat,
  ekpo.webaz AS Webaz,
  ekpo.mwskz AS Mwskz,
  ekpo.txdat_from AS TxdatFrom,
  ekpo.txdat AS Txdat,
  ekpo.tax_country AS TaxCountry,
  ekpo.prdat AS Prdat,
  ekpo.bstyp AS Bstyp,
  ekpo.effwr AS Effwr,
  ekpo.xoblr AS Xoblr,
  ekpo.kunnr AS Kunnr,
  ekpo.adrnr AS Adrnr,
  ekpo.ekkol AS Ekkol,
  ekpo.sktof AS Sktof,
  ekpo.stafo AS Stafo,
  ekpo.plifz AS Plifz,
  ekpo.ntgew AS Ntgew,
  ekpo.gewei AS Gewei,
  ekpo.txjcd AS Txjcd,
  ekpo.etdrk AS Etdrk,
  ekpo.sobkz AS Sobkz,
  ekpo.arsnr AS Arsnr,
  ekpo.arsps AS Arsps,
  ekpo.insnc AS Insnc,
  ekpo.ssqss AS Ssqss,
  ekpo.zgtyp AS Zgtyp,
  ekpo.ean11 AS Ean11,
  ekpo.bstae AS Bstae,
  ekpo.revlv AS Revlv,
  ekpo.brgew AS Brgew,
  ekpo.volum AS Volum,
  ekpo.voleh AS Voleh,
  ekpo.inco1 AS Inco1,
  ekpo.inco2 AS Inco2,
  ekpo.vorab AS Vorab,
  ekpo.kolif AS Kolif,
  ekpo.ltsnr AS Ltsnr
FROM ekpo
LEFT OUTER JOIN pps_ekpo_ext ON /* join condition not captured in parsed metadata */
;

Learn More