R_CreditAccountSummaryTP

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 R_CreditAccountSummaryTP.
-- 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 R_CreditAccountSummaryTP AS
SELECT
  _CrdtMBusinessPartner.BusinessPartner AS BusinessPartner,
  _CreditMgmtAccount.CreditSegment AS CreditSegment,
  cast( '99991231' as ukm_eff_date ) AS CreditCommitmentDspEndDate,
  _CrdtMBusinessPartner.CreditWorthinessScoreValue AS CreditWorthinessScoreValue,
  _CrdtMBusinessPartner.CreditCheckRule AS CreditCheckRule,
  _CrdtMBusinessPartner.CreditScoreAndLimitCalcRule AS CreditScoreAndLimitCalcRule,
  _CrdtMBusinessPartner.CrdtWrthnssScoreValdtyEndDate AS CrdtWrthnssScoreValdtyEndDate,
  _CrdtMBusinessPartner.CrdtWorthinessScoreLastChgDate AS CrdtWorthinessScoreLastChgDate,
  _CrdtMBusinessPartner.CalcdCrdtWorthinessScoreValue AS CalcdCrdtWorthinessScoreValue,
  _CrdtMBusinessPartner.CreditRiskClass AS CreditRiskClass,
  _CrdtMBusinessPartner.CalculatedCreditRiskClass AS CalculatedCreditRiskClass,
  _CrdtMBusinessPartner.CreditRiskClassLastChangeDate AS CreditRiskClassLastChangeDate,
  _CrdtMBusinessPartner.CrdtMgmtBusinessPartnerGroup AS CrdtMgmtBusinessPartnerGroup,
  _CrdtMBusinessPartner.AuthorizationGroup AS AuthorizationGroup,
  _CrdtMBusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  cast( _CrdtMBusinessPartner.MainCreditSegment as ukm_main_crsgmnt preserving type ) AS MainCreditSegment,
  cast( _CrdtMBusinessPartner._BusinessPartner.OrganizationBPName1 as bupa_nameor1 preserving type ) AS OrganizationBPName1,
  cast( _CrdtMBusinessPartner._BusinessPartner.OrganizationBPName2 as bupa_nameor2 preserving type ) AS OrganizationBPName2,
  cast( _CrdtMBusinessPartner._BusinessPartner.OrganizationBPName3 as bupa_nameor3 preserving type ) AS OrganizationBPName3,
  cast( _CrdtMBusinessPartner._BusinessPartner.OrganizationBPName4 as bupa_nameor4 preserving type ) AS OrganizationBPName4,
  _CrdtMBusinessPartner._BusinessPartner AS _BusinessPartner,
  _CrdtMBusinessPartner._CalcRiskClass AS _CalcRiskClass,
  _CrdtMBusinessPartner._CalcRule AS _CalcRule,
  _CrdtMBusinessPartner._CheckRule AS _CheckRule,
  _CrdtMBusinessPartner._CrdtMBusPartnerGroup AS _CrdtMBusPartnerGroup,
  _CrdtMBusinessPartner._MainCreditSegment AS _MainCreditSegment,
  _CrdtMBusinessPartner._MainCreditSegmentAccount AS _MainCreditSegmentAccount,
  _CrdtMBusinessPartner._RiskClass AS _RiskClass,
  _CreditMgmtAccount.CreditAccountBlockReason AS CreditAccountBlockReason,
  _CreditMgmtAccount.CreditAccountResubmissionDate AS CreditAccountResubmissionDate,
  _CreditMgmtAccount.CreditLimitAmount AS CreditLimitAmount,
  _CrdtMAccountCreditLimit.EffectiveTotalCreditLimitAmt AS EffectiveTotalCreditLimitAmt,
  _CrdtMAccountCreditLimit.InsuredCreditLimitAmount AS InsuredCreditLimitAmount,
  _CrdtMAccountCreditLimit.SecuredCreditLimitAmount AS SecuredCreditLimitAmount,
  _CrdtMAccountCreditLimit.TemporaryIncreasedCreditLmtAmt AS TemporaryIncreasedCreditLmtAmt,
  _CreditMgmtAccount.CreditLimitValidityEndDate AS CreditLimitValidityEndDate,
  _CreditMgmtAccount.CreditLimitLastChangeDate AS CreditLimitLastChangeDate,
  _CreditMgmtAccount.CreditLimitCalculatedAmount AS CreditLimitCalculatedAmount,
  case when _CreditMgmtAccount.CreditLimitIsZero is null then '' else _CreditMgmtAccount.CreditLimitIsZero end as CreditLimitIsZero AS CreditLimitIsZeroendasCreditLimitIsZero,
  _CreditMgmtAccount.CreditLimitRequestedAmount AS CreditLimitRequestedAmount,
  _CreditMgmtAccount.CreditLimitReqdValidityEndDate AS CreditLimitReqdValidityEndDate,
  _CreditMgmtAccount.CreditLimitRequestDate AS CreditLimitRequestDate,
  _CreditMgmtAccount.CreditSegmentCurrency AS CreditSegmentCurrency,
  _CreditMgmtAccount._CreditBlockReason AS _CreditBlockReason,
  _CreditMgmtAccount._CreditSegment AS _CreditSegment,
  _CreditMgmtAccount._CreditSegmentCurrency AS _CreditSegmentCurrency,
  cast( _CreditLimitUtilizationUnion.ExposureAmount as ukm_static_exposure_amt_long ) AS StaticCrdtExpsrAmtInSgmtCrcy,
  cast( _CreditLimitUtilizationUnion.DynamicExposure as ukm_dynamic_exposure_amount ) AS DynamicCreditExposureAmount,
  cast( _CreditHorizonConfig.CreditHorizonDays as ukm_credit_horizon preserving type) AS CreditHorizonDays,
  _CrdtMAcctPaytBehavior.MaximumDunnedOpenItem AS MaximumDunnedOpenItem,
  _CrdtMAcctPaytBehavior.MaximumDunningLevel AS MaximumDunningLevel,
  _CrdtMAcctPaytBehavior.MaximumDunnedOpenItemAmount AS MaximumDunnedOpenItemAmount,
  _CrdtMAcctPaytBehavior.MaximumDunnedOpenItemCurrency AS MaximumDunnedOpenItemCurrency,
  _CrdtMAcctPaytBehavior.NumberOfOpenItemsInMaxDunLevel AS NumberOfOpenItemsInMaxDunLevel,
  _CrdtMAcctPaytBehavior.DunnedItemInfoTransmnDateTime AS DunnedItemInfoTransmnDateTime,
  _CrdtMAcctPaytBehavior.OldestOpenItem AS OldestOpenItem,
  _CrdtMAcctPaytBehavior.OldestOpenItemAmount AS OldestOpenItemAmount,
  _CrdtMAcctPaytBehavior.OldestOpenItemCurrency AS OldestOpenItemCurrency,
  _CrdtMAcctPaytBehavior.OldestOpenItemNetDueDate AS OldestOpenItemNetDueDate,
  cast( _CrdtMAcctPaytBehavior.OldestOpnItemNrOfDaysInArrears as ukm_oi_days_in_arrears preserving type ) AS OldestOpnItemNrOfDaysInArrears,
  _CrdtMAcctPaytBehavior.OldestOpnItemInfoTransmnDteTme AS OldestOpnItemInfoTransmnDteTme,
  _CrdtMAcctPaytBehavior.LastPaymentItem AS LastPaymentItem,
  _CrdtMAcctPaytBehavior.LastPaymentDate AS LastPaymentDate,
  _CrdtMAcctPaytBehavior.LastPaymentItemAmount AS LastPaymentItemAmount,
  _CrdtMAcctPaytBehavior.LastPaymentCurrency AS LastPaymentCurrency,
  _CrdtMAcctPaytBehavior.LastPaymentInfoTransmnDateTime AS LastPaymentInfoTransmnDateTime,
  _CrdtMAcctPaytBehavior.DaysSalesOutstanding AS DaysSalesOutstanding,
  _CrdtMAcctPaytBehavior.TotalOutstandingAmtInSndrCrcy AS TotalOutstandingAmtInSndrCrcy,
  _CrdtMAcctPaytBehavior.SenderCurrency AS SenderCurrency,
  _CrdtMAcctPaytBehavior.CrdtMKeyFigureTransmnDateTime AS CrdtMKeyFigureTransmnDateTime,
  cast( _CrdtMAcctPaytBehavior.NoCshDiscAvgNrOfDaysInArrears as ukm_avg_arr_wocd preserving type ) AS NoCshDiscAvgNrOfDaysInArrears,
  _CrdtMAcctPaytBehavior.PaytNoCshDiscTotAmtInSndrCrcy AS PaytNoCshDiscTotAmtInSndrCrcy,
  cast( _CrdtMAcctPaytBehavior.CshDiscClmAvgNrOfDaysInArrears as ukm_avg_arr_wcd preserving type ) AS CshDiscClmAvgNrOfDaysInArrears,
  _CrdtMAcctPaytBehavior.PaytWthCshDiscTotAmtInSndrCrcy AS PaytWthCshDiscTotAmtInSndrCrcy,
  _CrdtMAcctPaytBehavior.TotLast12MnthsSlsAmtInSndrCrcy AS TotLast12MnthsSlsAmtInSndrCrcy,
  _CrdtMAcctPaytBehavior.Last12MnthsMaxSlsAmtInSndrCrcy AS Last12MnthsMaxSlsAmtInSndrCrcy,
  _CrdtMAcctPaytBehavior._LastPaymentCurrency AS _LastPaymentCurrency,
  _CrdtMAcctPaytBehavior._MaximumDunnedOpenItemCurrency AS _MaximumDunnedOpenItemCurrency,
  _CrdtMAcctPaytBehavior._OldestOpenItemCurrency AS _OldestOpenItemCurrency,
  _CrdtMAcctPaytBehavior._SenderCurrency AS _SenderCurrency,
  cast( _CreditAcctWithToDo.CreditAnalyst as fis_creditanalyst preserving type ) AS CreditAnalyst,
  _CreditAnalyst.BusinessPartnerFullName AS CreditCoordinatorName,
  _CreditAcctWithToDo.RelationshipCategory AS RelationshipCategory,
  _CrdtMBusinessPartner._BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID
FROM I_CrdtMBusinessPartner AS _CrdtMBusinessPartner
LEFT OUTER JOIN I_CustomerToBusinessPartner AS _CustomerToPartner ON businesspartneruuid = _CustomerToPartner.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CreditAnalyst ON CreditAnalyst = _CreditAnalyst.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _CurrentDefaultAddress ON BusinessPartner = _CurrentDefaultAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CreditAccountPrediction AS _CreditAccountPrediction ON BusinessPartner = _CreditAccountPrediction.BusinessPartner AND CreditSegment = _CreditAccountPrediction.CreditSegment  -- association [0..1]
;