I_MDQltyModelSelField

DDL: I_MDQLTYMODELSELFIELD SQL: IMDQLTYMODSELFLD Type: view BASIC
11 Fields 1 Data Sources

MDQ Model Fields for Data Selection

I_MDQltyModelSelField is a Basic CDS View that provides data about "MDQ Model Fields for Data Selection" in SAP S/4HANA. It reads from 1 data source (mdc_modelcfields) and exposes 11 fields with key fields MDQltyBusinessObjectTypeCode, MDQltyModelTable, MDQltyModelField.

Data Sources (1)

SourceAliasJoin Type
mdc_modelcfields mdc_fld_cust left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDQLTYMODSELFLD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label MDQ Model Fields for Data Selection view
Search.searchable true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MDQltyBusinessObjectTypeCode MDQltyBusinessObjectTypeCode Bus. Obj. Type
KEY MDQltyModelTable MDQltyModelTable Table
KEY MDQltyModelField MDQltyModelField Field
MDQltyModelFieldIsTableKey MDQltyModelFieldIsTableKey Key Field
MDQltyModelTableIsRootTable MDQltyModelTableIsRootTable
MDQltyModelFieldIsSelective MDQltyModelFieldIsSelective
ABAPDataElement ABAPDataElement Data Element
MDQltyModelDataElementName _MDQltyModelFieldText MDQltyModelDataElementName
_MDQltyModelFieldText _MDQltyModelFieldText
MDQltyModFldNameCstm mdc_modelcfields field_name VAT Declaration Fld
MDQltyModFldIsSelectiveCstm mdc_modelcfields selective Selective

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 I_MDQltyModelSelField.
-- 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: IMDQLTYMODSELFLD

CREATE VIEW I_MDQltyModelSelField AS
SELECT
  MDQltyBusinessObjectTypeCode,
  MDQltyModelTable,
  MDQltyModelField,
  MDQltyModelFieldIsTableKey,
  MDQltyModelTableIsRootTable,
  MDQltyModelFieldIsSelective,
  ABAPDataElement,
  _MDQltyModelFieldText.MDQltyModelDataElementName AS MDQltyModelDataElementName,
  mdc_fld_cust.field_name AS MDQltyModFldNameCstm,
  mdc_fld_cust.selective AS MDQltyModFldIsSelectiveCstm
LEFT OUTER JOIN mdc_modelcfields AS mdc_fld_cust ON /* join condition not captured in parsed metadata */
;

Learn More