C_MDQualityExportedRuleTP_2

DDL: C_MDQUALITYEXPORTEDRULETP_2 Type: view_entity CONSUMPTION Package: MDQ_PF_VAL_DATA_EXCHANGE
25 Fields 1 Data Sources 1 Associations 1 OData Services

Exported Rule

C_MDQualityExportedRuleTP_2 is a Consumption CDS View that provides data about "Exported Rule" in SAP S/4HANA. It reads from 1 data source (R_MDQualityExportedRuleTP_2) and exposes 25 fields with key field MDQltyExportedRuleUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_MDQLTYRULEEXPORT_MANAGE_2). Part of development package MDQ_PF_VAL_DATA_EXCHANGE.

Data Sources (1)

SourceAliasJoin Type
R_MDQualityExportedRuleTP_2 R_MDQualityExportedRuleTP_2 projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_MDQualityBusinessRuleTP _MDQualityBusinessRuleTP $projection.MDQualityBusinessRuleUUID = _MDQualityBusinessRuleTP.MDQualityBusinessRuleUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Exported Rule view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey MDQltyExportedRuleUUID view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_MDQLTYRULEEXPORT_MANAGE_2 UI_MDQLTYRULEEXPORT_MANAGE V4 C1 NOT_RELEASED

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MDQltyExportedRuleUUID MDQltyExportedRuleUUID Exported Rule
MDQltyRuleExportUUID MDQltyRuleExportUUID Rule Export UUID
MDQualityBusinessRuleUUID MDQualityBusinessRuleUUID Rule UUID
MDQltyExportedRuleStatus MDQltyExportedRuleStatus Exported Rule Status
MDQltyExportedRuleStatusNamelocalized
MDQltyExportedRuleStsCritlty _MDQualityExportedRuleStatus MDQltyExportedRuleStsCritlty
MDQltyRuleImplmtnStsCritlty MDQltyRuleImplmtnStsCritlty
MDQltyExportedRule MDQltyExportedRule
MDQualityBusinessRule _MDQualityBusinessRule MDQualityBusinessRule Rule Definition ID
MDQualityBusinessRuleName _MDQualityBusinessRule MDQualityBusinessRuleName Rule Name
MDQltyBusinessObjectTypeCode _MDQualityBusinessRule MDQltyBusinessObjectTypeCode Bus. Obj. Type
MDQltyBusRuleIsImplemented _MDQualityBusinessRule MDQltyBusRuleIsImplemented
MDQltyBusRuleHasDraftEntity _MDQualityBusinessRule MDQltyBusRuleHasDraftEntity
MDQltyTechnicalRuleCndnUUID _MDQualityBusinessRule MDQltyTechnicalRuleCndnUUID
MDQltyTechnicalRuleScopeUUID _MDQualityBusinessRule MDQltyTechnicalRuleScopeUUID
MDQltyTechRuleCndnDcsnTblUUID _MDQualityBusinessRule MDQltyTechRuleCndnDcsnTblUUID
MDQltyTechRuleScpDcsnTblUUID _MDQualityBusinessRule MDQltyTechRuleScpDcsnTblUUID
MDQltyRuleImplmtnStatusNamelocalized
MDQltyRuleImplmtnStatus MDQltyRuleImplmtnStatus Status
MDQltyExportedRuleLogHandle Handle
_MDQualityBusinessRule _MDQualityBusinessRule
_MDQualityExportedRuleStatus _MDQualityExportedRuleStatus
_MDQualityExportedRuleStatusT _MDQualityExportedRuleStatusT
_MDQualityRuleImplmtnStatusT _MDQualityRuleImplmtnStatusT
_MDQualityBusinessRuleTP _MDQualityBusinessRuleTP

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_MDQualityExportedRuleTP_2.
-- 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_MDQualityExportedRuleTP_2 AS
SELECT
  MDQltyExportedRuleUUID,
  MDQltyRuleExportUUID,
  MDQualityBusinessRuleUUID,
  MDQltyExportedRuleStatus,
  _MDQualityExportedRuleStatusT.MDQltyExportedRuleStatusName : localized AS MDQltyExportedRuleStatusNamelocalized,
  _MDQualityExportedRuleStatus.MDQltyExportedRuleStsCritlty AS MDQltyExportedRuleStsCritlty,
  MDQltyRuleImplmtnStsCritlty,
  MDQltyExportedRule,
  _MDQualityBusinessRule.MDQualityBusinessRule AS MDQualityBusinessRule,
  _MDQualityBusinessRule.MDQualityBusinessRuleName AS MDQualityBusinessRuleName,
  _MDQualityBusinessRule.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  _MDQualityBusinessRule.MDQltyBusRuleIsImplemented AS MDQltyBusRuleIsImplemented,
  _MDQualityBusinessRule.MDQltyBusRuleHasDraftEntity AS MDQltyBusRuleHasDraftEntity,
  _MDQualityBusinessRule.MDQltyTechnicalRuleCndnUUID AS MDQltyTechnicalRuleCndnUUID,
  _MDQualityBusinessRule.MDQltyTechnicalRuleScopeUUID AS MDQltyTechnicalRuleScopeUUID,
  _MDQualityBusinessRule.MDQltyTechRuleCndnDcsnTblUUID AS MDQltyTechRuleCndnDcsnTblUUID,
  _MDQualityBusinessRule.MDQltyTechRuleScpDcsnTblUUID AS MDQltyTechRuleScpDcsnTblUUID,
  _MDQualityRuleImplmtnStatusT.MDQltyRuleImplmtnStatusName : localized AS MDQltyRuleImplmtnStatusNamelocalized,
  MDQltyRuleImplmtnStatus,
  cast( MDQltyExportedRuleLogHandle as char22 preserving type ) AS MDQltyExportedRuleLogHandle
FROM R_MDQualityExportedRuleTP_2
LEFT OUTER JOIN C_MDQualityBusinessRuleTP AS _MDQualityBusinessRuleTP ON MDQualityBusinessRuleUUID = _MDQualityBusinessRuleTP.MDQualityBusinessRuleUUID  -- association [0..1]
;

Learn More