FNDEI_EKPA_FILTER

DDL: FNDEI_EKPA_FILTER SQL: FNDEIFEKPA Type: view
19 Fields 2 Data Sources

Filter View for table EKPA

FNDEI_EKPA_FILTER is a CDS View that provides data about "Filter View for table EKPA" in SAP S/4HANA. It reads from 2 data sources (ekpa, FNDEI_EKPA_BLOCKINGINFO) and exposes 19 fields with key fields mandt, ebeln, ebelp, ekorg, ltsnr.

Data Sources (2)

SourceAliasJoin Type
ekpa ekpa from
FNDEI_EKPA_BLOCKINGINFO FNDEI_EKPA_BLOCKINGINFO inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIFEKPA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Filter View for table EKPA view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY mandt ekpa mandt Editing Client
KEY ebeln ekpa ebeln Source PurchDoc
KEY ebelp ekpa ebelp Item pur. doc.
KEY ekorg ekpa ekorg Purchasing Org.
KEY ltsnr ekpa ltsnr Suppl. Subrange
KEY werks ekpa werks Receiving Plant
KEY parvw ekpa parvw Task Processor
KEY parza ekpa parza Partner counter
ernam ekpa ernam User Name
erdat ekpa erdat Entered On
lifn2 ekpa lifn2 Ref. to suplr
defpa ekpa defpa Default Partner
hityp ekpa hityp Hierarchy type
parnr ekpa parnr Responsible
pernr ekpa pernr Personnel no.
prfre ekpa prfre Price determin.
bolre ekpa bolre Subseq. Settlmt
histunr ekpa histunr Hierarchy level
_dataaging ekpa _dataaging Data Aging

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 FNDEI_EKPA_FILTER.
-- 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: FNDEIFEKPA

CREATE VIEW FNDEI_EKPA_FILTER AS
SELECT
  ekpa.mandt AS mandt,
  ekpa.ebeln AS ebeln,
  ekpa.ebelp AS ebelp,
  ekpa.ekorg AS ekorg,
  ekpa.ltsnr AS ltsnr,
  ekpa.werks AS werks,
  ekpa.parvw AS parvw,
  ekpa.parza AS parza,
  ekpa.ernam AS ernam,
  ekpa.erdat AS erdat,
  ekpa.lifn2 AS lifn2,
  ekpa.defpa AS defpa,
  ekpa.hityp AS hityp,
  ekpa.parnr AS parnr,
  ekpa.pernr AS pernr,
  ekpa.prfre AS prfre,
  ekpa.bolre AS bolre,
  ekpa.histunr AS histunr,
  ekpa._dataaging AS _dataaging
FROM ekpa
INNER JOIN FNDEI_EKPA_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;

Learn More