I_MDQualityRuleExport_2

DDL: I_MDQUALITYRULEEXPORT_2 Type: view_entity COMPOSITE
23 Fields 1 Data Sources

Validation Rule Export

I_MDQualityRuleExport_2 is a Composite CDS View that provides data about "Validation Rule Export" in SAP S/4HANA. It reads from 1 data source (I_MDQualityRuleExport) and exposes 23 fields with key field MDQltyRuleExportUUID.

Data Sources (1)

SourceAliasJoin Type
I_MDQualityRuleExport I_MDQualityRuleExport from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Validation Rule Export view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY MDQltyRuleExportUUID I_MDQualityRuleExport MDQltyRuleExportUUID Rule Export UUID
MDQltyRuleExport I_MDQualityRuleExport MDQltyRuleExport Rule Export
MDQltyRuleExportName I_MDQualityRuleExport MDQltyRuleExportName Export Name
MDQltyBusinessObjectTypeCode I_MDQualityRuleExport MDQltyBusinessObjectTypeCode Bus. Obj. Type
MDQltyRuleExportText I_MDQualityRuleExport MDQltyRuleExportText Export Text
MDQltyRuleExprtCrtnDateTime I_MDQualityRuleExport MDQltyRuleExprtCrtnDateTime Created On
MDQltyRuleExportCreatedByUser I_MDQualityRuleExport MDQltyRuleExportCreatedByUser Created By
MDQltyRuleExportChangeDateTime I_MDQualityRuleExport MDQltyRuleExportChangeDateTime Changed At
MDQltyRuleExportChangedByUser I_MDQualityRuleExport MDQltyRuleExportChangedByUser Changed By
MDQltyRuleExprtCompltnDateTime I_MDQualityRuleExport MDQltyRuleExprtCompltnDateTime Completed On
MDQltyRuleExprtCompletedByUser I_MDQualityRuleExport MDQltyRuleExprtCompletedByUser Completed By
MDQltyRuleExportStatus I_MDQualityRuleExport MDQltyRuleExportStatus Rule Export Status
MDQltyRuleExportValidationUUID I_MDQualityRuleExport MDQltyRuleExportValidationUUID Validation UUID
MDQltyRuleExportLogHandle I_MDQualityRuleExport MDQltyRuleExportLogHandle Handle
MDQltyRuleExportJobID I_MDQualityRuleExport MDQltyRuleExportJobID
MDQltyRuleExportJobName I_MDQualityRuleExport MDQltyRuleExportJobName
MDQRuleExprtExcelFileCntntBin _ExcelFile MDQltyRuleExportFileContent File Content
MDQRuleExprtExcelFileMimeType
MDQRuleExprtExcelFileName _ExcelFile MDQltyRuleExportFileName File Name
MDQRuleExprtZIPFileContentBin _ZIPFile MDQltyRuleExportFileContent File Content
MDQRuleExprtZIPFileMimeType
MDQRuleExprtZIPFileName _ZIPFile MDQltyRuleExportFileName File Name
_MDQualityExportedRule I_MDQualityRuleExport _MDQualityExportedRule

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_MDQualityRuleExport_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 I_MDQualityRuleExport_2 AS
SELECT
  I_MDQualityRuleExport.MDQltyRuleExportUUID AS MDQltyRuleExportUUID,
  I_MDQualityRuleExport.MDQltyRuleExport AS MDQltyRuleExport,
  I_MDQualityRuleExport.MDQltyRuleExportName AS MDQltyRuleExportName,
  I_MDQualityRuleExport.MDQltyBusinessObjectTypeCode AS MDQltyBusinessObjectTypeCode,
  I_MDQualityRuleExport.MDQltyRuleExportText AS MDQltyRuleExportText,
  I_MDQualityRuleExport.MDQltyRuleExprtCrtnDateTime AS MDQltyRuleExprtCrtnDateTime,
  I_MDQualityRuleExport.MDQltyRuleExportCreatedByUser AS MDQltyRuleExportCreatedByUser,
  I_MDQualityRuleExport.MDQltyRuleExportChangeDateTime AS MDQltyRuleExportChangeDateTime,
  I_MDQualityRuleExport.MDQltyRuleExportChangedByUser AS MDQltyRuleExportChangedByUser,
  I_MDQualityRuleExport.MDQltyRuleExprtCompltnDateTime AS MDQltyRuleExprtCompltnDateTime,
  I_MDQualityRuleExport.MDQltyRuleExprtCompletedByUser AS MDQltyRuleExprtCompletedByUser,
  I_MDQualityRuleExport.MDQltyRuleExportStatus AS MDQltyRuleExportStatus,
  I_MDQualityRuleExport.MDQltyRuleExportValidationUUID AS MDQltyRuleExportValidationUUID,
  I_MDQualityRuleExport.MDQltyRuleExportLogHandle AS MDQltyRuleExportLogHandle,
  I_MDQualityRuleExport.MDQltyRuleExportJobID AS MDQltyRuleExportJobID,
  I_MDQualityRuleExport.MDQltyRuleExportJobName AS MDQltyRuleExportJobName,
  _ExcelFile.MDQltyRuleExportFileContent AS MDQRuleExprtExcelFileCntntBin,
  case when _ExcelFile.MDQltyRuleExportFileName is not initial then cast( 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet' as w3conttype ) else '' end AS MDQRuleExprtExcelFileMimeType,
  _ExcelFile.MDQltyRuleExportFileName AS MDQRuleExprtExcelFileName,
  _ZIPFile.MDQltyRuleExportFileContent AS MDQRuleExprtZIPFileContentBin,
  case when _ZIPFile.MDQltyRuleExportFileName is not initial then cast( 'application/zip' as w3conttype ) else '' end AS MDQRuleExprtZIPFileMimeType,
  _ZIPFile.MDQltyRuleExportFileName AS MDQRuleExprtZIPFileName,
  I_MDQualityRuleExport._MDQualityExportedRule AS _MDQualityExportedRule
FROM I_MDQualityRuleExport
;

Learn More