PPS_V_EKKO_EXT

DDL: PPS_V_EKKO_EXT SQL: PPS_V_EKKO Type: view
43 Fields 2 Data Sources

PPS: View on EKKO+PPS_EKKO_EXT

PPS_V_EKKO_EXT is a CDS View that provides data about "PPS: View on EKKO+PPS_EKKO_EXT" in SAP S/4HANA. It reads from 2 data sources (ekko, pps_ekko_ext) and exposes 43 fields with key field Ebeln.

Data Sources (2)

SourceAliasJoin Type
ekko ekko from
pps_ekko_ext pps_ekko_ext left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPS_V_EKKO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PPS: View on EKKO+PPS_EKKO_EXT view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY Ebeln ekko ebeln Source PurchDoc
Bukrs ekko bukrs Value
Bstyp ekko bstyp Source doc.cat.
Bsart ekko bsart Stnd purch.ord.
Bsakz ekko bsakz Control
Loekz ekko loekz Status
Statu ekko statu Vehicle Status
Aedat ekko aedat Obsolete
Ernam ekko ernam User Name
Lastchangedatetime ekko lastchangedatetime Timestamp
Pincr ekko pincr Item Interval
Lponr ekko lponr Last Item
Lifnr ekko lifnr Vendor no.
Spras ekko spras Off. Language
Ekorg ekko ekorg Purchasing Org.
Ekgrp ekko ekgrp Sub. purchasing grp
Waers ekko waers Transaction Currency
Wkurs ekko wkurs Exchange Rate
Kufix ekko kufix Fixed Exch.Rate
Bedat ekko bedat Start date
Kdatb ekko kdatb Validity Start
Kdate ekko kdate Validity End
Bwbdt ekko bwbdt Application By
Angdt ekko angdt Valid From
Bnddt ekko bnddt Valid To
Verkf ekko verkf Salesperson
Kunnr ekko kunnr Stock customer
Abgru ekko abgru RejectionReason
Lblif ekko lblif Rec. Supplier
Inco1 ekko inco1 Incoterms
Inco2 ekko inco2 Incoterms 2
Ktwrt ekko ktwrt Target Value
Knumv ekko knumv Doc. Condition
Kalsm ekko kalsm Search Proced.
Stafo ekko stafo Update Group
Lifre ekko lifre Location Alias
Exnum ekko exnum Official No.
Unsez ekko unsez Our Reference
Logsy ekko logsy Logical System
Upinc ekko upinc Subitem Interv.
Stako ekko stako Tm.-dep. conds.
Adrnr ekko adrnr Sold-To Address
Addnr ekko addnr Document number

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_EKKO_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_EKKO

CREATE VIEW PPS_V_EKKO_EXT AS
SELECT
  ekko.ebeln AS Ebeln,
  ekko.bukrs AS Bukrs,
  ekko.bstyp AS Bstyp,
  ekko.bsart AS Bsart,
  ekko.bsakz AS Bsakz,
  ekko.loekz AS Loekz,
  ekko.statu AS Statu,
  ekko.aedat AS Aedat,
  ekko.ernam AS Ernam,
  ekko.lastchangedatetime AS Lastchangedatetime,
  ekko.pincr AS Pincr,
  ekko.lponr AS Lponr,
  ekko.lifnr AS Lifnr,
  ekko.spras AS Spras,
  ekko.ekorg AS Ekorg,
  ekko.ekgrp AS Ekgrp,
  ekko.waers AS Waers,
  ekko.wkurs AS Wkurs,
  ekko.kufix AS Kufix,
  ekko.bedat AS Bedat,
  ekko.kdatb AS Kdatb,
  ekko.kdate AS Kdate,
  ekko.bwbdt AS Bwbdt,
  ekko.angdt AS Angdt,
  ekko.bnddt AS Bnddt,
  ekko.verkf AS Verkf,
  ekko.kunnr AS Kunnr,
  ekko.abgru AS Abgru,
  ekko.lblif AS Lblif,
  ekko.inco1 AS Inco1,
  ekko.inco2 AS Inco2,
  ekko.ktwrt AS Ktwrt,
  ekko.knumv AS Knumv,
  ekko.kalsm AS Kalsm,
  ekko.stafo AS Stafo,
  ekko.lifre AS Lifre,
  ekko.exnum AS Exnum,
  ekko.unsez AS Unsez,
  ekko.logsy AS Logsy,
  ekko.upinc AS Upinc,
  ekko.stako AS Stako,
  ekko.adrnr AS Adrnr,
  ekko.addnr AS Addnr
FROM ekko
LEFT OUTER JOIN pps_ekko_ext ON /* join condition not captured in parsed metadata */
;

Learn More