I_BPCREDITWORTHINESS

CDS View

Credit Worthiness of Business Partner

I_BPCREDITWORTHINESS is a CDS View in S/4HANA. Credit Worthiness of Business Partner. It contains 5 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_BPCreditWorthiness view from BASIC Credit Worthiness
I_BPCreditWorthinessTP view_entity from TRANSACTIONAL Creditworthiness - TP
I_LoanContrBPCrdtWorthWthDflt view left_outer COMPOSITE Loan Contract Business Partner Credit Worth with defaulting
P_LoanContrBPAddlDet view left_outer COMPOSITE Business Partner additional details

Fields (5)

KeyField CDS FieldsUsed in Views
BPCreditStandingRating CreditRating 1
BPForeclosureIsInitiated BPForeclosureIsInitiated 1
BPLegalProceedingStatus BusPartLegalProceedingCode 1
BusinessPartnerIsBankrupt BusinessPartnerIsBankrupt 1
BusPartCreditStanding BusPartCreditStanding 1
@AbapCatalog: { sqlViewName: 'IBPCRDTWRTHNSS',
                compiler.compareFilter: true,
                buffering.status: #NOT_ALLOWED
              }
@AccessControl: {authorizationCheck: #MANDATORY,
                 personalData.blocking: #REQUIRED
                }
@ObjectModel: { usageType: { dataClass: #MASTER,
                             serviceQuality: #A,
                             sizeCategory: #XL
                           },
                representativeKey: 'BusinessPartner',
                sapObjectNodeType.name: 'BPCreditWorthiness',
                supportedCapabilities: [  #ANALYTICAL_DIMENSION,
                                          #CDS_MODELING_DATA_SOURCE,
                                          #CDS_MODELING_ASSOCIATION_TARGET,
                                          #SQL_DATA_SOURCE,
                                          #EXTRACTION_DATA_SOURCE ],
                modelingPattern: #ANALYTICAL_DIMENSION
              }
@Analytics: { dataExtraction.enabled: true,
              dataCategory: #DIMENSION,
              internalName: #LOCAL
            }
@Metadata: { ignorePropagatedAnnotations: true,  // For C1-Release

             allowExtensions: true
           }
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]           
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Credit Worthiness of Business Partner'

define view I_BPCreditWorthiness
  as select from bp1010

  association [1]    to I_BusinessPartner          as _BusinessPartner          on $projection.BusinessPartner = _BusinessPartner.BusinessPartner // <--- to inherit authorizations in DCL

  association [0..1] to I_BPFinancialServicesExtn  as _BPFinancialServicesExtn  on $projection.BusinessPartner = _BPFinancialServicesExtn.BusinessPartner // <--- to inherit authorizations in DCL

  association [0..1] to I_BPCreditStanding         as _BPCreditStanding         on $projection.BusPartCreditStanding = _BPCreditStanding.BusPartCreditStanding
  association [0..1] to I_BPCreditStandingStatus   as _BPCreditStandingStatus   on $projection.BPCreditStandingStatus = _BPCreditStandingStatus.BPCreditStandingStatus
  association [0..1] to I_BPCreditRatingAgency     as _CreditRatingAgency       on $projection.CreditRatingAgency = _CreditRatingAgency.CreditRatingAgency
  association [0..1] to I_BPCreditWorthinessRating as _BPCreditWorthinessRating on $projection.BPCreditStandingRating = _BPCreditWorthinessRating.BPCreditStandingRating
  association [0..1] to I_BPLegalProceedingStatus  as _BPLegalProceedingStatus  on $projection.BPLegalProceedingStatus = _BPLegalProceedingStatus.BPLegalProceedingStatus
{
  key bp1010.partnr     as BusinessPartner,

      bp1010.solvncy    as BusPartCreditStanding,

      bp1010.sol_inf    as BPCreditStandingStatus,
      @API.element.releaseState: #DEPRECATED
      @API.element.decommissioningPlannedForYearMonth: '2027-08'
      //No successor available as the field is obsolete, use BP1012 instead

      bp1010.sol_ins    as CreditRatingAgency,
      @API.element.releaseState: #DEPRECATED
      @API.element.decommissioningPlannedForYearMonth: '2027-08'
      //No successor available as the field is obsolete, use BP1012 instead

      bp1010.sol_txt    as BPCreditStandingComment,
      @API.element.releaseState: #DEPRECATED
      @API.element.decommissioningPlannedForYearMonth: '2027-08'
      //No successor available as the field is obsolete, use BP1012 instead

      bp1010.sol_i_d    as BPCreditStandingDate,
      @API.element.releaseState: #DEPRECATED
      @API.element.decommissioningPlannedForYearMonth: '2027-08'
      //No successor available as the field is obsolete, use BP1012 instead

      bp1010.rating     as BPCreditStandingRating,

      bp1010.lgl_proc   as BPLegalProceedingStatus,

      bp1010.lgl_proc_d as BPLglProceedingInitiationDate,
      bp1010.de_oath    as BusinessPartnerIsUnderOath,
      bp1010.de_oa_d    as BusinessPartnerOathDate,
      bp1010.bankrup    as BusinessPartnerIsBankrupt,
      bp1010.bnkry_d    as BusinessPartnerBankruptcyDate,
      bp1010.foreclo    as BPForeclosureIsInitiated,
      bp1010.forcl_d    as BPForeclosureDate,

      // obsolete

      ''                as BPCrdtWrthnssAccessChkIsActive,

      _BPCreditStanding,
      _BPCreditStandingStatus,
      _CreditRatingAgency,
      _BPCreditWorthinessRating,
      _BPLegalProceedingStatus,

      _BusinessPartner,
      _BPFinancialServicesExtn

}