I_MDQSuplrDocAssgmtResultFocus

DDL: I_MDQSUPLRDOCASSGMTRESULTFOCUS Type: view_entity COMPOSITE
19 Fields 1 Data Sources

Suplr Doc Assignment focused Result

I_MDQSuplrDocAssgmtResultFocus is a Composite CDS View that provides data about "Suplr Doc Assignment focused Result" in SAP S/4HANA. It reads from 1 data source (I_MDQltyBPSuplrDocAssgmtResult) and exposes 19 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DocumentInfoRecordDocType.

Data Sources (1)

SourceAliasJoin Type
I_MDQltyBPSuplrDocAssgmtResult SuplrDocumentAssignmentResult from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Suplr Doc Assignment focused Result view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_MDQltyBPSuplrDocAssgmtResult MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDQltyBPSuplrDocAssgmtResult MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_MDQltyBPSuplrDocAssgmtResult MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_MDQltyBPSuplrDocAssgmtResult MDChgProcessSrceObject Source ID
KEY DocumentInfoRecordDocType I_MDQltyBPSuplrDocAssgmtResult DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber I_MDQltyBPSuplrDocAssgmtResult DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion I_MDQltyBPSuplrDocAssgmtResult DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart I_MDQltyBPSuplrDocAssgmtResult DocumentInfoRecordDocPart Document Part
KEY LinkedSAPObject I_MDQltyBPSuplrDocAssgmtResult LinkedSAPObject Object
KEY DocObjectLinkCounter I_MDQltyBPSuplrDocAssgmtResult DocObjectLinkCounter Obj.Ctr
KEY LinkedSAPObjectKey I_MDQltyBPSuplrDocAssgmtResult LinkedSAPObjectKey SAP Object Key
KEY BPAssignmentID I_MDQltyBPSuplrDocAssgmtResult BPAssignmentID Assignment ID
KEY MDQualityBusinessRuleUUID I_MDQltyBPSuplrDocAssgmtResult MDQualityBusinessRuleUUID Rule UUID
MDQltyBusRuleResultOutOfScope OutOfScopeResult MDQltyBusRuleEvalResultCode Result Type
MDQltyNmbrOfRecdOutOfScope OutOfScopeResult MDQltyNmbrOfBusRuleEvalResults Total Results
MDQltyBusRuleResultSuccess SuccessResult MDQltyBusRuleEvalResultCode Result Type
MDQltyNmbrOfRecdSuccess SuccessResult MDQltyNmbrOfBusRuleEvalResults Total Results
MDQltyBusRuleResultFailed FailedResult MDQltyBusRuleEvalResultCode Result Type
MDQltyNmbrOfRecdFailed FailedResult MDQltyNmbrOfBusRuleEvalResults Total Results

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_MDQSuplrDocAssgmtResultFocus.
-- 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_MDQSuplrDocAssgmtResultFocus AS
SELECT
  SuplrDocumentAssignmentResult.MasterDataChangeProcess AS MasterDataChangeProcess,
  SuplrDocumentAssignmentResult.MDChgProcessStep AS MDChgProcessStep,
  SuplrDocumentAssignmentResult.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  SuplrDocumentAssignmentResult.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  SuplrDocumentAssignmentResult.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  SuplrDocumentAssignmentResult.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  SuplrDocumentAssignmentResult.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  SuplrDocumentAssignmentResult.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  SuplrDocumentAssignmentResult.LinkedSAPObject AS LinkedSAPObject,
  SuplrDocumentAssignmentResult.DocObjectLinkCounter AS DocObjectLinkCounter,
  SuplrDocumentAssignmentResult.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  SuplrDocumentAssignmentResult.BPAssignmentID AS BPAssignmentID,
  SuplrDocumentAssignmentResult.MDQualityBusinessRuleUUID AS MDQualityBusinessRuleUUID,
  OutOfScopeResult.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleResultOutOfScope,
  OutOfScopeResult.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfRecdOutOfScope,
  SuccessResult.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleResultSuccess,
  SuccessResult.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfRecdSuccess,
  FailedResult.MDQltyBusRuleEvalResultCode AS MDQltyBusRuleResultFailed,
  FailedResult.MDQltyNmbrOfBusRuleEvalResults AS MDQltyNmbrOfRecdFailed
FROM I_MDQltyBPSuplrDocAssgmtResult AS SuplrDocumentAssignmentResult
;

Learn More