I_MDQANLYTSSCRBPCUSTSLS

CDS View
12 Fields 1 CDS Views

Basic Score for Customer Sales

I_MDQANLYTSSCRBPCUSTSLS is a CDS View in S/4HANA. Basic Score for Customer Sales. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MDQAnlytsScrCustSlsC view_entity from COMPOSITE MDQ Score for Customer Sales - Cube

Fields (12)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY DistributionChannel DistributionChannel 1
KEY Division Division 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDQltyBusRuleEvalResultCode MDQltyBusRuleEvalResultCode 1
KEY MDQualityBusinessRuleUUID MDQualityBusinessRuleUUID 1
KEY SalesOrganization SalesOrganization 1
MDQltyBusinessRuleBaseTable MDQltyBusinessRuleBaseTable 1
MDQltyBusinessRuleOwner MDQltyBusinessRuleOwner 1
MDQltyNmbrOfBusRuleEvalResults MDQltyNmbrOfBusRuleEvalResults 1
MDQltyNmbrOfFailedEvalRslts MDQltyNmbrOfFailedEvalRslts 1
MDQltyNmbrOfSuccssflEvalRslts MDQltyNmbrOfSuccssflEvalRslts 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Basic Score for Customer Sales
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MDQANLYTSSCRBPCUSTSLS (
    BUSINESSPARTNER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    MASTERDATACHANGEPROCESS,
    MDQLTYBUSRULEEVALRESULTCODE,
    MDQUALITYBUSINESSRULEUUID,
    SALESORGANIZATION,
    MDQLTYBUSINESSRULEBASETABLE,
    MDQLTYBUSINESSRULEOWNER,
    MDQLTYNMBROFBUSRULEEVALRESULTS,
    MDQLTYNMBROFFAILEDEVALRSLTS,
    MDQLTYNMBROFSUCCSSFLEVALRSLTS,
    PRIMARY KEY (BUSINESSPARTNER, DISTRIBUTIONCHANNEL, DIVISION, MASTERDATACHANGEPROCESS, MDQLTYBUSRULEEVALRESULTCODE, MDQUALITYBUSINESSRULEUUID, SALESORGANIZATION)
);

Learn More