FNDEI_EKBEH_FILTER
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)
| Source | Alias | Join Type |
|---|---|---|
| ekbeh | ekbeh | from |
| FNDEI_EKBEH_BLOCKINGINFO | FNDEI_EKBEH_BLOCKINGINFO | inner |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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 */
;
Learn More
- S/4HANA CDS View Deprecation: What You Need to Know
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA