I_BUSINESSPARTNERRATING

CDS View
11 Fields 7 CDS Views

Rating of Business Partner

I_BUSINESSPARTNERRATING is a CDS View in S/4HANA. Rating of Business Partner. It contains 11 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
A_BusinessPartnerRating view from BASIC Ratings
I_BusinessPartnerRatingTP view_entity from TRANSACTIONAL Ratings - TP
I_LoanContrBPCurRatgWthDflt view left_outer COMPOSITE Rating data for Business partner with defaulting
I_LoanContrDataBPCurRatWthDflt view left_outer COMPOSITE Loan Contract Business Partner Rating with defaulting
I_TrsyCtptyLmtBPRatingCube view inner COMPOSITE Treasury Counterparty Limit Business Partner Rating - Cube
P_LoanContrBPCurRatg view left_outer COMPOSITE Ratings of Business Partner
R_CrdtMBusPartnerRatingTP view_entity from TRANSACTIONAL Credit Rating of a Business Partner

Fields (11)

KeyField CDS FieldsUsed in Views
KEY BPRatingValidityEndDate BPRatingValidityEndDate 1
KEY BusinessPartner BusinessPartner 1
KEY BusinessPartnerRatingProcedure BusinessPartnerRatingProcedure 2
BPRatingCreationDate BPRatingCreationDate 1
BPRatingIsValidOnKeyDate BPRatingIsValidOnKeyDate 1
BPRatingValidityStartDate BPRatingValidityStartDate 1
BusinessPartnerRatingComment BusinessPartnerRatingComment 1
BusinessPartnerRatingGrade BusinessPartnerRatingGrade 1
BusinessPartnerRatingIsAllowed BusinessPartnerRatingIsAllowed 1
BusinessPartnerRatingIsExpired BusinessPartnerRatingIsExpired 1
BusinessPartnerRatingTrend BusinessPartnerRatingTrend 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.

-- Rating of Business Partner
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BUSINESSPARTNERRATING (
    BPRATINGVALIDITYENDDATE,
    BUSINESSPARTNER,
    BUSINESSPARTNERRATINGPROCEDURE,
    BPRATINGCREATIONDATE,
    BPRATINGISVALIDONKEYDATE,
    BPRATINGVALIDITYSTARTDATE,
    BUSINESSPARTNERRATINGCOMMENT,
    BUSINESSPARTNERRATINGGRADE,
    BUSINESSPARTNERRATINGISALLOWED,
    BUSINESSPARTNERRATINGISEXPIRED,
    BUSINESSPARTNERRATINGTREND,
    PRIMARY KEY (BPRATINGVALIDITYENDDATE, BUSINESSPARTNER, BUSINESSPARTNERRATINGPROCEDURE)
);

Learn More