I_MDQltyCustDocAssgmtRsltFocus

DDL: I_MDQLTYCUSTDOCASSGMTRSLTFOCUS Type: view_entity COMPOSITE Package: MDQ_EVAL_RESULTS_BUPA
19 Fields 1 Data Sources 2 OData Services

Cust Doc Assignment focused Result

I_MDQltyCustDocAssgmtRsltFocus is a Composite CDS View that provides data about "Cust Doc Assignment focused Result" in SAP S/4HANA. It reads from 1 data source (I_MDQltyBPCustDocAssgmtResult) and exposes 19 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, DocumentInfoRecordDocType. It is exposed through 2 OData services (ASQL_F7205A, X_C_MDQLTYBPCUSTOMERPROC_SRV). Part of development package MDQ_EVAL_RESULTS_BUPA.

Data Sources (1)

SourceAliasJoin Type
I_MDQltyBPCustDocAssgmtResult CustDocumentAssignmentResult from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cust 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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
X_C_MDQLTYBPCUSTOMERPROC_SRV

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_MDQltyBPCustDocAssgmtResult MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDQltyBPCustDocAssgmtResult MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_MDQltyBPCustDocAssgmtResult MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_MDQltyBPCustDocAssgmtResult MDChgProcessSrceObject Source ID
KEY DocumentInfoRecordDocType I_MDQltyBPCustDocAssgmtResult DocumentInfoRecordDocType Document Type
KEY DocumentInfoRecordDocNumber I_MDQltyBPCustDocAssgmtResult DocumentInfoRecordDocNumber Document
KEY DocumentInfoRecordDocVersion I_MDQltyBPCustDocAssgmtResult DocumentInfoRecordDocVersion Doc. Version
KEY DocumentInfoRecordDocPart I_MDQltyBPCustDocAssgmtResult DocumentInfoRecordDocPart Document Part
KEY LinkedSAPObject I_MDQltyBPCustDocAssgmtResult LinkedSAPObject Object
KEY DocObjectLinkCounter I_MDQltyBPCustDocAssgmtResult DocObjectLinkCounter Obj.Ctr
KEY LinkedSAPObjectKey I_MDQltyBPCustDocAssgmtResult LinkedSAPObjectKey SAP Object Key
KEY BPAssignmentID I_MDQltyBPCustDocAssgmtResult BPAssignmentID Assignment ID
KEY MDQualityBusinessRuleUUID I_MDQltyBPCustDocAssgmtResult 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_MDQltyCustDocAssgmtRsltFocus.
-- 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_MDQltyCustDocAssgmtRsltFocus AS
SELECT
  CustDocumentAssignmentResult.MasterDataChangeProcess AS MasterDataChangeProcess,
  CustDocumentAssignmentResult.MDChgProcessStep AS MDChgProcessStep,
  CustDocumentAssignmentResult.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  CustDocumentAssignmentResult.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  CustDocumentAssignmentResult.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  CustDocumentAssignmentResult.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  CustDocumentAssignmentResult.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  CustDocumentAssignmentResult.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  CustDocumentAssignmentResult.LinkedSAPObject AS LinkedSAPObject,
  CustDocumentAssignmentResult.DocObjectLinkCounter AS DocObjectLinkCounter,
  CustDocumentAssignmentResult.LinkedSAPObjectKey AS LinkedSAPObjectKey,
  CustDocumentAssignmentResult.BPAssignmentID AS BPAssignmentID,
  CustDocumentAssignmentResult.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_MDQltyBPCustDocAssgmtResult AS CustDocumentAssignmentResult
;

Learn More