C_MDQltyMndRuleLinkdRuleVH

DDL: C_MDQLTYMNDRULELINKDRULEVH Type: view_entity CONSUMPTION

MDQlty Linked Bus Rule Value Help

C_MDQltyMndRuleLinkdRuleVH is a Consumption CDS View that provides data about "MDQlty Linked Bus Rule Value Help" in SAP S/4HANA.

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label MDQlty Linked Bus Rule Value Help view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY MDQualityBusinessRule _MDQltyBusinessRuleVH MDQualityBusinessRule Rule Definition ID
KEY MDQltyBusinessObjectTypeCode _MDQltyBusinessRuleVH MDQltyBusinessObjectTypeCode Bus. Obj. Type
MDQualityBusinessRuleUUID _MDQltyBusinessRuleVH MDQualityBusinessRuleUUID Rule UUID
MDQualityBusinessRuleName _MDQltyBusinessRuleVH MDQualityBusinessRuleName Rule Name
MDQltyBusinessRuleBaseTable _MDQltyBusinessRuleVH MDQltyBusinessRuleBaseTable Base Table
MDQltyBusinessRuleOwner _MDQltyBusinessRuleVH MDQltyBusinessRuleOwner Rule Owner
MDQltyBusinessRuleStatus _MDQltyBusinessRuleVH MDQltyBusinessRuleStatus Rule Status
MDQltyBusRuleStatusCriticality _MDQltyBusinessRuleVH MDQltyBusRuleStatusCriticality
MDQltyBusRuleCheckedField _MDQltyBusinessRuleVH MDQltyBusRuleCheckedField Fieldname
MDQltyBusRuleCheckedFieldTable _MDQltyBusinessRuleVH MDQltyBusRuleCheckedFieldTable Chkd. Field Table
MDQltyBusRuleChkdFieldAndTable _MDQltyBusinessRuleVH MDQltyBusRuleChkdFieldAndTable Table and Field Name
MDQltyTechnicalRuleUUID _MDQltyBusinessRuleVH MDQltyTechnicalRuleUUID
MDQltyTechnicalRuleScopeUUID _MDQltyBusinessRuleVH MDQltyTechnicalRuleScopeUUID
MDQltyTechnicalRuleCndnUUID _MDQltyBusinessRuleVH MDQltyTechnicalRuleCndnUUID
MDQltyTechRuleScpDcsnTblUUID _MDQltyBusinessRuleVH MDQltyTechRuleScpDcsnTblUUID
MDQltyTechRuleCndnDcsnTblUUID _MDQltyBusinessRuleVH MDQltyTechRuleCndnDcsnTblUUID
MDQltyRuleImplmtnStatus _MDQltyBusinessRuleVH MDQltyRuleImplmtnStatus Status
MDQltyRuleImplmtnStatusName _MDQltyBusinessRuleVH MDQltyRuleImplmtnStatusName
MDQltyRuleImplmtnStsCritlty _MDQltyBusinessRuleVH MDQltyRuleImplmtnStsCritlty
_MDQltyBusinessRuleBaseTableT _MDQltyBusinessRuleVH _MDQltyBusinessRuleBaseTableT
_MDQltyBusinessRuleBaseTblVH _MDQltyBusinessRuleVH _MDQltyBusinessRuleBaseTblVH
_MDQltyBusinessRuleDetails _MDQltyBusinessRuleVH _MDQltyBusinessRuleDetails
_MDQltyBusRuleChkdFieldText _MDQltyBusinessRuleVH _MDQltyBusRuleChkdFieldText
_MDQualityBusinessRuleStatus _MDQltyBusinessRuleVH _MDQualityBusinessRuleStatus
_MDQualityBusinessRuleStatusT _MDQltyBusinessRuleVH _MDQualityBusinessRuleStatusT
_MDQualityBusRuleOwnerVH _MDQltyBusinessRuleVH _MDQualityBusRuleOwnerVH

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 C_MDQltyMndRuleLinkdRuleVH.
-- 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.

CREATE VIEW C_MDQltyMndRuleLinkdRuleVH AS
SELECT
  _MDQltyBusinessRuleVH.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQltyBusinessRuleVH.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  _MDQltyBusinessRuleVH.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  _MDQltyBusinessRuleVH.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _MDQltyBusinessRuleVH.MDQltyBusinessRuleBaseTable AS MDQltyBusinessRuleBaseTable,
  _MDQltyBusinessRuleVH.MDQltyBusinessRuleOwner AS MDQltyBusinessRuleOwner,
  _MDQltyBusinessRuleVH.MDQltyBusinessRuleStatus AS MDQltyBusinessRuleStatus,
  _MDQltyBusinessRuleVH.MDQltyBusRuleStatusCriticality AS MDQltyBusRuleStatusCriticality,
  _MDQltyBusinessRuleVH.MDQltyBusRuleCheckedField AS MDQltyBusRuleCheckedField,
  _MDQltyBusinessRuleVH.MDQltyBusRuleCheckedFieldTable AS MDQltyBusRuleCheckedFieldTable,
  _MDQltyBusinessRuleVH.MDQltyBusRuleChkdFieldAndTable AS MDQltyBusRuleChkdFieldAndTable,
  _MDQltyBusinessRuleVH.MDQltyTechnicalRuleUUID AS MDQltyTechnicalRuleUUID,
  _MDQltyBusinessRuleVH.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  _MDQltyBusinessRuleVH.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  _MDQltyBusinessRuleVH.MDQltyTechRuleScpDcsnTblUUID AS MDQltyTechRuleScpDcsnTblUUID,
  _MDQltyBusinessRuleVH.MDQltyTechRuleCndnDcsnTblUUID AS MDQltyTechRuleCndnDcsnTblUUID,
  _MDQltyBusinessRuleVH.MDQltyRuleImplmtnStatus AS MDQltyRuleImplmtnStatus,
  _MDQltyBusinessRuleVH.MDQltyRuleImplmtnStatusName AS MDQltyRuleImplmtnStatusName,
  _MDQltyBusinessRuleVH.MDQltyRuleImplmtnStsCritlty AS MDQltyRuleImplmtnStsCritlty,
  _MDQltyBusinessRuleVH._MDQltyBusinessRuleBaseTableT AS _MDQltyBusinessRuleBaseTableT,
  _MDQltyBusinessRuleVH._MDQltyBusinessRuleBaseTblVH AS _MDQltyBusinessRuleBaseTblVH,
  _MDQltyBusinessRuleVH._MDQltyBusinessRuleDetails AS _MDQltyBusinessRuleDetails,
  _MDQltyBusinessRuleVH._MDQltyBusRuleChkdFieldText AS _MDQltyBusRuleChkdFieldText,
  _MDQltyBusinessRuleVH._MDQualityBusinessRuleStatus AS _MDQualityBusinessRuleStatus,
  _MDQltyBusinessRuleVH._MDQualityBusinessRuleStatusT AS _MDQualityBusinessRuleStatusT,
  _MDQltyBusinessRuleVH._MDQualityBusRuleOwnerVH AS _MDQualityBusRuleOwnerVH
;