C_CrdtMBusPartnerRatingTP

DDL: C_CRDTMBUSPARTNERRATINGTP Type: view_entity CONSUMPTION

Credit Rating of a Business Partner

C_CrdtMBusPartnerRatingTP is a Consumption CDS View that provides data about "Credit Rating of a Business Partner" in SAP S/4HANA. It reads from 1 data source (R_CrdtMBusPartnerRatingTP) and exposes 17 fields with key fields BusinessPartner, BPRatingValidityEndDate, BusinessPartnerRatingProcedure. It is exposed through 1 OData service (UI_CRDTMGMTACCOUNT_MANAGE). It is used in 1 Fiori application: Manage Credit Accounts.

Data Sources (1)

SourceAliasJoin Type
R_CrdtMBusPartnerRatingTP R_CrdtMBusPartnerRatingTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Credit Rating of a Business Partner view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CRDTMGMTACCOUNT_MANAGE UI_CRDTMGMTACCOUNT_MANAGE V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F4596 Manage Credit Accounts Transactional

Manage Credit Accounts

Business Role: Credit Controller

Use this app to display and update the credit data for business parters. Edit the credit data of business partners and update the scoring. On the global credit data page, you can see the credit profile for your business partners, as well as detailed information about blocked sales documents or credit limit requests. Find the credit exposure and credit limit utilization highlighted for each credit segment. Navigate to credit segment level to find further information about credit-relevant data, or details about the related sales documents.

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY BPRatingValidityEndDate BPRatingValidityEndDate Rating Valid To
KEY BusinessPartnerRatingProcedure BusinessPartnerRatingProcedure Rating Procedure
BPRatingProcedureDescriptionlocalized
BPRatingValidityStartDate BPRatingValidityStartDate Rating Valid From
BusinessPartnerRatingGrade BusinessPartnerRatingGrade Rating
BusinessPartnerRatingTrend BusinessPartnerRatingTrend Trend
BusinessPartnerRatingTrendDesclocalized
BPRatingCreationDate BPRatingCreationDate Rated On
BusinessPartnerRatingComment BusinessPartnerRatingComment Text
BPRatingValidityEndDateForEdit BPRatingValidityEndDateForEdit Rating Valid To
BusinessPartnerRatingIsExpired BusinessPartnerRatingIsExpired Rating is Expired
_BPRatingProcedure _BPRatingProcedure
_BPRatingProcedureGrade _BPRatingProcedureGrade
_BPRatingTrend _BPRatingTrend
_BusinessPartner _BusinessPartner
_BPFinancialServicesExtn _BPFinancialServicesExtn

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 C_CrdtMBusPartnerRatingTP.
-- 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 C_CrdtMBusPartnerRatingTP AS
SELECT
  BusinessPartner,
  BPRatingValidityEndDate,
  BusinessPartnerRatingProcedure,
  _BPRatingProcedure._Text.BPRatingProcedureDescription : localized AS BPRatingProcedureDescriptionlocalized,
  BPRatingValidityStartDate,
  BusinessPartnerRatingGrade,
  BusinessPartnerRatingTrend,
  _BPRatingTrend._Text.BusinessPartnerRatingTrendDesc : localized AS BusinessPartnerRatingTrendDesclocalized,
  BPRatingCreationDate,
  BusinessPartnerRatingComment,
  BPRatingValidityEndDateForEdit,
  BusinessPartnerRatingIsExpired
FROM R_CrdtMBusPartnerRatingTP
;