I_MDQltyMinedRuleScpFieldTP

DDL: I_MDQLTYMINEDRULESCPFIELDTP SQL: IMDQMNDRLSCFLDTP Type: view TRANSACTIONAL
9 Fields 1 Data Sources 1 Associations

MDQ Mined Rule Scope Field

I_MDQltyMinedRuleScpFieldTP is a Transactional CDS View that provides data about "MDQ Mined Rule Scope Field" in SAP S/4HANA. It reads from 1 data source (I_MDQltyMinedRuleScpField) and exposes 9 fields with key field MDQltyMinedRuleScpFieldUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MDQltyMinedRuleScpField I_MDQltyMinedRuleScpField from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MDQltyMinedRuleTP _MDQltyMinedRuleTP $projection.MDQltyMinedRuleUUID = _MDQltyMinedRuleTP.MDQltyMinedRuleUUID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMDQMNDRLSCFLDTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label MDQ Mined Rule Scope Field view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.compositionRoot false view
ObjectModel.writeActivePersistence MDQ_MND_SCPFLDS view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MDQltyMinedRuleScpFieldUUID MDQltyMinedRuleScpFieldUUID Scope Field UUID
MDQltyMinedRuleUUID MDQltyMinedRuleUUID Mined Rule UUID
MDQltyMinedRuleScpFieldTable MDQltyMinedRuleScpFieldTable Scope Field Table
MDQltyMinedRuleScpField MDQltyMinedRuleScpField Scope Field
MDQltyMinedRuleScpFldSign MDQltyMinedRuleScpFldSign Sign
MDQltyMinedRuleScpFldOperand MDQltyMinedRuleScpFldOperand Operand
MDQltyMinedRuleScpFldLow MDQltyMinedRuleScpFldLow Low Value
MDQltyMinedRuleScpFldHigh MDQltyMinedRuleScpFldHigh High Value
_MDQltyMinedRuleTP _MDQltyMinedRuleTP

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_MDQltyMinedRuleScpFieldTP.
-- 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: IMDQMNDRLSCFLDTP

CREATE VIEW I_MDQltyMinedRuleScpFieldTP AS
SELECT
  MDQltyMinedRuleScpFieldUUID,
  MDQltyMinedRuleUUID,
  MDQltyMinedRuleScpFieldTable,
  MDQltyMinedRuleScpField,
  MDQltyMinedRuleScpFldSign,
  MDQltyMinedRuleScpFldOperand,
  MDQltyMinedRuleScpFldLow,
  MDQltyMinedRuleScpFldHigh
FROM I_MDQltyMinedRuleScpField
LEFT OUTER JOIN I_MDQltyMinedRuleTP AS _MDQltyMinedRuleTP ON MDQltyMinedRuleUUID = _MDQltyMinedRuleTP.MDQltyMinedRuleUUID  -- association [1..1]
;

Learn More