Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

FNDEI_EKBEH_FILTER

DDL: FNDEI_EKBEH_FILTER SQL: FNDEIFEKBEH Type: view

Filter View for table EKBEH

FNDEI_EKBEH_FILTER is a CDS View that provides data about "Filter View for table EKBEH" in SAP S/4HANA. It reads from 2 data sources (ekbeh, FNDEI_EKBEH_BLOCKINGINFO) and exposes 89 fields with key fields mandt, ebeln, ebelp, zekkn, vgabe.

Data Sources (2)

SourceAliasJoin Type
ekbeh ekbeh from
FNDEI_EKBEH_BLOCKINGINFO FNDEI_EKBEH_BLOCKINGINFO inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIFEKBEH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Filter View for table EKBEH view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
VDM.lifecycle.status #DEPRECATED view

Fields (89)

KeyFieldSource TableSource FieldDescription
KEY mandt ekbeh mandt Editing Client
KEY ebeln ekbeh ebeln Source PurchDoc
KEY ebelp ekbeh ebelp Item pur. doc.
KEY zekkn ekbeh zekkn Account Assgmt No.
KEY vgabe ekbeh vgabe Transact. Type
KEY gjahr ekbeh gjahr Settlement Year
KEY belnr ekbeh belnr SD Document
KEY buzei ekbeh buzei Posting View Item
bewtp ekbeh bewtp PO History Cat.
bwart ekbeh bwart Valuation Type
budat ekbeh budat Posting Date
menge ekbeh menge WarrCountValue
bpmng ekbeh bpmng Qty. in OPUn
dmbtr ekbeh dmbtr Loc. amount
wrbtr ekbeh wrbtr Gross Amount
waers ekbeh waers Transaction Currency
arewr ekbeh arewr Ord.GRIR.Val
wesbs ekbeh wesbs GR Bl.St. OUn
bpwes ekbeh bpwes GR blocked stck
shkzg ekbeh shkzg Returns
bwtar ekbeh bwtar Valuation Type
elikz ekbeh elikz Delivery Completion
xblnr ekbeh xblnr Reference
lfgja ekbeh lfgja Year Cur.Period
lfbnr ekbeh lfbnr Reference Doc.
lfpos ekbeh lfpos Ref. Doc. Item
grund ekbeh grund Reason for mvt.
cpudt ekbeh cpudt Imported On
cputm ekbeh cputm Time
reewr ekbeh reewr Ord.Set.Value
evere ekbeh evere Compliance
refwr ekbeh refwr Inv.Value in FC
matnr ekbeh matnr Vehicle Model
werks ekbeh werks Receiving Plant
xwsbr ekbeh xwsbr RevGR desp. IR
etens ekbeh etens Sequential No.
knumv ekbeh knumv Doc. Condition
mwskz ekbeh mwskz Tax Code
lsmng ekbeh lsmng Del. Note Qty
lsmeh ekbeh lsmeh Del. Note Unit
ematn ekbeh ematn MPN: Material
areww ekbeh areww GR/IR clr.value
hswae ekbeh hswae Local currency
bamng ekbeh bamng Quantity
charg ekbeh charg Chargeable Proc.
bldat ekbeh bldat Journal Entry Date
xwoff ekbeh xwoff Calcn of val.Open
xunpl ekbeh xunpl UAcctAssignment
ernam ekbeh ernam User Name
srvpos ekbeh srvpos Service
packno ekbeh packno Package number
introw ekbeh introw Service line
bekkn ekbeh bekkn SeqNo.PO AccAss
lemin ekbeh lemin SRV Returns Ind.
arewb ekbeh arewb GR/IR clr.value
rewrb ekbeh rewrb FC invoice amnt
saprl ekbeh saprl SAP Release
menge_pop ekbeh menge_pop Quantity
bpmng_pop ekbeh bpmng_pop Qty. in OPUn
dmbtr_pop ekbeh dmbtr_pop Amount in LC
wrbtr_pop ekbeh wrbtr_pop Amount
wesbb ekbeh wesbb Val. GR BlStock OUn
bpweb ekbeh bpweb Val. GR BS OPUn
weora ekbeh weora Origin Accept.
arewr_pop ekbeh arewr_pop GR/IR clr.value
kudif ekbeh kudif Exch.Rate Diff.
retamt_fc ekbeh retamt_fc Retent. in Doc. Crcy
retamt_lc ekbeh retamt_lc Retention in CC Crcy
retamtp_fc ekbeh retamtp_fc Retent. in Doc. Crcy
retamtp_lc ekbeh retamtp_lc Retention in CC Crcy
xmacc ekbeh xmacc Multi Acct Assgt
wkurs ekbeh wkurs Exchange Rate
vbeln_st ekbeh vbeln_st Delivery
vbelp_st ekbeh vbelp_st Item
sgt_scat ekbeh sgt_scat Stock Segment
_dataaging ekbeh _dataaging Data Aging
sesuom ekbeh sesuom SES UoM
logsy ekbeh logsy Logical System
et_upd ekbeh et_upd SLPU
cwmbamng ekbeh /cwm/bamng
cwmwesbs ekbeh /cwm/wesbs
cwmty2tq ekbeh /cwm/ty2tq
cwmwesbb ekbeh /cwm/wesbb
fsh_season ekbeh fsh_season Season
fsh_theme ekbeh fsh_theme Theme
qty_diff ekbeh qty_diff Quantity
wrf_charstc1 ekbeh wrf_charstc1 Characteristic 1
wrf_charstc2 ekbeh wrf_charstc2 Characteristic 2
wrf_charstc3 ekbeh wrf_charstc3 Characteristic 3

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_EKBEH_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: FNDEIFEKBEH

CREATE VIEW FNDEI_EKBEH_FILTER AS
SELECT
  ekbeh.mandt AS mandt,
  ekbeh.ebeln AS ebeln,
  ekbeh.ebelp AS ebelp,
  ekbeh.zekkn AS zekkn,
  ekbeh.vgabe AS vgabe,
  ekbeh.gjahr AS gjahr,
  ekbeh.belnr AS belnr,
  ekbeh.buzei AS buzei,
  ekbeh.bewtp AS bewtp,
  ekbeh.bwart AS bwart,
  ekbeh.budat AS budat,
  ekbeh.menge AS menge,
  ekbeh.bpmng AS bpmng,
  ekbeh.dmbtr AS dmbtr,
  ekbeh.wrbtr AS wrbtr,
  ekbeh.waers AS waers,
  ekbeh.arewr AS arewr,
  ekbeh.wesbs AS wesbs,
  ekbeh.bpwes AS bpwes,
  ekbeh.shkzg AS shkzg,
  ekbeh.bwtar AS bwtar,
  ekbeh.elikz AS elikz,
  ekbeh.xblnr AS xblnr,
  ekbeh.lfgja AS lfgja,
  ekbeh.lfbnr AS lfbnr,
  ekbeh.lfpos AS lfpos,
  ekbeh.grund AS grund,
  ekbeh.cpudt AS cpudt,
  ekbeh.cputm AS cputm,
  ekbeh.reewr AS reewr,
  ekbeh.evere AS evere,
  ekbeh.refwr AS refwr,
  ekbeh.matnr AS matnr,
  ekbeh.werks AS werks,
  ekbeh.xwsbr AS xwsbr,
  ekbeh.etens AS etens,
  ekbeh.knumv AS knumv,
  ekbeh.mwskz AS mwskz,
  ekbeh.lsmng AS lsmng,
  ekbeh.lsmeh AS lsmeh,
  ekbeh.ematn AS ematn,
  ekbeh.areww AS areww,
  ekbeh.hswae AS hswae,
  ekbeh.bamng AS bamng,
  ekbeh.charg AS charg,
  ekbeh.bldat AS bldat,
  ekbeh.xwoff AS xwoff,
  ekbeh.xunpl AS xunpl,
  ekbeh.ernam AS ernam,
  ekbeh.srvpos AS srvpos,
  ekbeh.packno AS packno,
  ekbeh.introw AS introw,
  ekbeh.bekkn AS bekkn,
  ekbeh.lemin AS lemin,
  ekbeh.arewb AS arewb,
  ekbeh.rewrb AS rewrb,
  ekbeh.saprl AS saprl,
  ekbeh.menge_pop AS menge_pop,
  ekbeh.bpmng_pop AS bpmng_pop,
  ekbeh.dmbtr_pop AS dmbtr_pop,
  ekbeh.wrbtr_pop AS wrbtr_pop,
  ekbeh.wesbb AS wesbb,
  ekbeh.bpweb AS bpweb,
  ekbeh.weora AS weora,
  ekbeh.arewr_pop AS arewr_pop,
  ekbeh.kudif AS kudif,
  ekbeh.retamt_fc AS retamt_fc,
  ekbeh.retamt_lc AS retamt_lc,
  ekbeh.retamtp_fc AS retamtp_fc,
  ekbeh.retamtp_lc AS retamtp_lc,
  ekbeh.xmacc AS xmacc,
  ekbeh.wkurs AS wkurs,
  ekbeh.vbeln_st AS vbeln_st,
  ekbeh.vbelp_st AS vbelp_st,
  ekbeh.sgt_scat AS sgt_scat,
  ekbeh._dataaging AS _dataaging,
  ekbeh.sesuom AS sesuom,
  ekbeh.logsy AS logsy,
  ekbeh.et_upd AS et_upd,
  ekbeh./cwm/bamng AS cwmbamng,
  ekbeh./cwm/wesbs AS cwmwesbs,
  ekbeh./cwm/ty2tq AS cwmty2tq,
  ekbeh./cwm/wesbb AS cwmwesbb,
  ekbeh.fsh_season AS fsh_season,
  ekbeh.fsh_theme AS fsh_theme,
  ekbeh.qty_diff AS qty_diff,
  ekbeh.wrf_charstc1 AS wrf_charstc1,
  ekbeh.wrf_charstc2 AS wrf_charstc2,
  ekbeh.wrf_charstc3 AS wrf_charstc3
FROM ekbeh
INNER JOIN FNDEI_EKBEH_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;