I_MDQltyBPCustDunResultFocus

DDL: I_MDQLTYBPCUSTDUNRESULTFOCUS Type: view_entity COMPOSITE
14 Fields 1 Data Sources

BP Customer Dunning focused Result

I_MDQltyBPCustDunResultFocus is a Composite CDS View that provides data about "BP Customer Dunning focused Result" in SAP S/4HANA. It reads from 1 data source (I_MDQltyBPCustDunningResult) and exposes 14 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_MDQltyBPCustDunningResult CustomerDunningResult from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label BP Customer Dunning 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 (14)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess I_MDQltyBPCustDunningResult MasterDataChangeProcess Process ID
KEY MDChgProcessStep I_MDQltyBPCustDunningResult MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem I_MDQltyBPCustDunningResult MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_MDQltyBPCustDunningResult MDChgProcessSrceObject Source ID
KEY CompanyCode I_MDQltyBPCustDunningResult CompanyCode Receiver Company Code
KEY DunningArea I_MDQltyBPCustDunningResult DunningArea Dunning Area
KEY BPAssignmentID I_MDQltyBPCustDunningResult BPAssignmentID Assignment ID
KEY MDQualityBusinessRuleUUID I_MDQltyBPCustDunningResult 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_MDQltyBPCustDunResultFocus.
-- 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_MDQltyBPCustDunResultFocus AS
SELECT
  CustomerDunningResult.MasterDataChangeProcess AS MasterDataChangeProcess,
  CustomerDunningResult.MDChgProcessStep AS MDChgProcessStep,
  CustomerDunningResult.MDChgProcessSrceSystem AS MDChgProcessSrceSystem,
  CustomerDunningResult.MDChgProcessSrceObject AS MDChgProcessSrceObject,
  CustomerDunningResult.CompanyCode AS CompanyCode,
  CustomerDunningResult.DunningArea AS DunningArea,
  CustomerDunningResult.BPAssignmentID AS BPAssignmentID,
  CustomerDunningResult.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_MDQltyBPCustDunningResult AS CustomerDunningResult
;

Learn More