FNDEI_QASE_FILTER

DDL: FNDEI_QASE_FILTER SQL: FNDEIFQASE Type: view
52 Fields 2 Data Sources

Filter View for table QASE

FNDEI_QASE_FILTER is a CDS View that provides data about "Filter View for table QASE" in SAP S/4HANA. It reads from 2 data sources (FNDEI_QASE_BLOCKINGINFO, qase) and exposes 52 fields with key fields mandant, prueflos, vorglfnr, merknr, detailerg.

Data Sources (2)

SourceAliasJoin Type
FNDEI_QASE_BLOCKINGINFO FNDEI_QASE_BLOCKINGINFO inner
qase qase from

Annotations (8)

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

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY mandant qase mandant Client
KEY prueflos qase prueflos Inspection Lot
KEY vorglfnr qase vorglfnr Node Number
KEY merknr qase merknr Characteristic
KEY detailerg qase detailerg Indiv. result
attribut qase attribut Name of attribute
ersteller qase ersteller Created By
erstelldat qase erstelldat Created On
aenderer qase aenderer Changed By
aenderdat qase aenderdat Changed On
probenr qase probenr Sample Number
stuecknr qase stuecknr Insp. Unit No.
pruefer qase pruefer Inspector
pruefdatuv qase pruefdatuv Insp.Start Date
pruefdatub qase pruefdatub Insp. End Date
pruefzeitv qase pruefzeitv Insp.Start Time
pruefzeitb qase pruefzeitb Insp. End Time
pruefbemkt qase pruefbemkt Short Text
prltextkz qase prltextkz Long text
ltextspr qase ltextspr Language
messwertni qase messwertni MeasVal.notInit
messwert qase messwert Measured Value
katalgart1 qase katalgart1 Catalog Type
gruppe1 qase gruppe1 Code Group
code1 qase code1 Code
version1 qase version1 Version
katalgart2 qase katalgart2 Catalog Type
gruppe2 qase gruppe2 Code Group
code2 qase code2 Code
version2 qase version2 Version
katalgart3 qase katalgart3 Catalog Type
gruppe3 qase gruppe3 Code Group
code3 qase code3 Code
version3 qase version3 Version
katalgart4 qase katalgart4 Catalog Type
gruppe4 qase gruppe4 Code Group
code4 qase code4 Code
version4 qase version4 Version
katalgart5 qase katalgart5 Catalog Type
grupvers5 qase grupvers5 Version
gruppe5 qase gruppe5 Code Group
code5 qase code5 Code
version5 qase version5 Version
anzfehler qase anzfehler No. of Defects
fehlklas qase fehlklas Defect Class
mbewertg qase mbewertg Valuation
estuecknr qase estuecknr Single Unit
serialnr qase serialnr Serial Number
maschine qase maschine Information
position qase position Test Position
zeiterstl qase zeiterstl Time
zeitaend qase zeitaend Time

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_QASE_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: FNDEIFQASE

CREATE VIEW FNDEI_QASE_FILTER AS
SELECT
  qase.mandant AS mandant,
  qase.prueflos AS prueflos,
  qase.vorglfnr AS vorglfnr,
  qase.merknr AS merknr,
  qase.detailerg AS detailerg,
  qase.attribut AS attribut,
  qase.ersteller AS ersteller,
  qase.erstelldat AS erstelldat,
  qase.aenderer AS aenderer,
  qase.aenderdat AS aenderdat,
  qase.probenr AS probenr,
  qase.stuecknr AS stuecknr,
  qase.pruefer AS pruefer,
  qase.pruefdatuv AS pruefdatuv,
  qase.pruefdatub AS pruefdatub,
  qase.pruefzeitv AS pruefzeitv,
  qase.pruefzeitb AS pruefzeitb,
  qase.pruefbemkt AS pruefbemkt,
  qase.prltextkz AS prltextkz,
  qase.ltextspr AS ltextspr,
  qase.messwertni AS messwertni,
  qase.messwert AS messwert,
  qase.katalgart1 AS katalgart1,
  qase.gruppe1 AS gruppe1,
  qase.code1 AS code1,
  qase.version1 AS version1,
  qase.katalgart2 AS katalgart2,
  qase.gruppe2 AS gruppe2,
  qase.code2 AS code2,
  qase.version2 AS version2,
  qase.katalgart3 AS katalgart3,
  qase.gruppe3 AS gruppe3,
  qase.code3 AS code3,
  qase.version3 AS version3,
  qase.katalgart4 AS katalgart4,
  qase.gruppe4 AS gruppe4,
  qase.code4 AS code4,
  qase.version4 AS version4,
  qase.katalgart5 AS katalgart5,
  qase.grupvers5 AS grupvers5,
  qase.gruppe5 AS gruppe5,
  qase.code5 AS code5,
  qase.version5 AS version5,
  qase.anzfehler AS anzfehler,
  qase.fehlklas AS fehlklas,
  qase.mbewertg AS mbewertg,
  qase.estuecknr AS estuecknr,
  qase.serialnr AS serialnr,
  qase.maschine AS maschine,
  qase.position AS position,
  qase.zeiterstl AS zeiterstl,
  qase.zeitaend AS zeitaend
FROM qase
INNER JOIN FNDEI_QASE_BLOCKINGINFO ON /* join condition not captured in parsed metadata */
;

Learn More