I_BusinessPartnerCreditProfile

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_BusinessPartnerCreditProfile.
-- 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_BusinessPartnerCreditProfile AS
SELECT
  _CreditProfile.partner AS BusinessPartner,
  _CreditProfile.own_rating AS CreditWorthinessScoreValue,
  _CreditProfile.check_rule AS CreditCheckRule,
  cast( _CreditProfile.limit_rule as ukm_limit_and_score_calc_rule preserving type ) AS CreditScoreAndLimitCalcRule,
  _CreditProfile.rating_val_date AS CrdtWrthnssScoreValdtyEndDate,
  _CreditProfile.rating_chg_date AS CrdtWorthinessScoreLastChgDate,
  _CreditProfile.own_rating_calc AS CalcdCrdtWorthinessScoreValue,
  _CreditProfile.risk_class AS CreditRiskClass,
  cast( _CreditProfile.risk_class_calc as ukm_calculated_risk_class_2 preserving type ) AS CalculatedCreditRiskClass,
  _CreditProfile.risk_class_chgdt AS CreditRiskClassLastChangeDate,
  _CreditProfile.credit_group AS CrdtMgmtBusinessPartnerGroup,
  _CreditProfile.customer_since_year AS CustBusinessRelshpStartYear,
  _CreditProfile.last_changed_at AS BPLastChangeDateTime
FROM ukmbp_cms AS _CreditProfile
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CreditMgmtBPAddress AS _CreditMgmtBPAddress ON BusinessPartner = _CreditMgmtBPAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CrdtMBusPartnerGroup AS _CrdtMBusPartnerGroup ON CrdtMgmtBusinessPartnerGroup = _CrdtMBusPartnerGroup.CrdtMgmtBusinessPartnerGroup  -- association [0..1]
LEFT OUTER JOIN I_CreditRiskClass AS _RiskClass ON CreditRiskClass = _RiskClass.CreditRiskClass  -- association [0..1]
LEFT OUTER JOIN I_CreditRiskClass AS _CalcRiskClass ON CalculatedCreditRiskClass = _CalcRiskClass.CreditRiskClass  -- association [0..1]
LEFT OUTER JOIN I_CreditCheckRule AS _CheckRule ON CreditCheckRule = _CheckRule.CreditCheckRule  -- association [0..1]
LEFT OUTER JOIN I_CrdtScoreAndLmtCalcRule AS _CalcRule ON CreditScoreAndLimitCalcRule = _CalcRule.CreditScoreAndLimitCalcRule  -- association [0..1]
;