C_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 C_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 C_CreditAccountSummaryTP AS
SELECT
  BusinessPartner,
  CreditSegment,
  CreditCommitmentDspEndDate,
  _CustomerToPartner.Customer AS Customer,
  CreditSegmentCurrency,
  _CreditSegmentCurrency._Text.CurrencyName as CurrencyName : localized AS CurrencyNameasCurrencyNamelocalized,
  _BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.AddresseeFullName AS BusinessPartnerFullName,
  _BusinessPartner._CurrentDefaultAddress._Address.BusinessPartnerName1 AS BusinessPartnerName1,
  _BusinessPartner._CurrentDefaultAddress._Address.BusinessPartnerName2 AS BusinessPartnerName2,
  _BusinessPartner.FirstName AS PartnerFirstName,
  _BusinessPartner.LastName AS PartnerLastName,
  _BusinessPartner._CurrentDefaultAddress._Address.Country AS BusinessPartnerCountry,
  _BusinessPartner._CurrentDefaultAddress._Address.CityName AS BusinessPartnerCityName,
  _BusinessPartner.SearchTerm1 AS SearchTerm1,
  _BusinessPartner.SearchTerm2 AS SearchTerm2,
  CreditWorthinessScoreValue,
  CreditCheckRule,
  _CheckRule._Text[1:Language = $session.system_language].CreditCheckRuleName AS CreditCheckRuleName,
  CreditScoreAndLimitCalcRule,
  _CalcRule._Text[1:Language = $session.system_language].CrdtScoreAndLimitCalcRuleName AS CrdtScoreAndLimitCalcRuleName,
  CrdtWrthnssScoreValdtyEndDate,
  CrdtWorthinessScoreLastChgDate,
  CalcdCrdtWorthinessScoreValue,
  CreditRiskClass,
  _RiskClass._Text[1:Language = $session.system_language].CreditRiskClassName AS CreditRiskClassName,
  CalculatedCreditRiskClass,
  _CalcRiskClass._Text[1:Language = $session.system_language].CreditRiskClassName AS CalculatedCreditRiskClassName,
  CreditRiskClassLastChangeDate,
  CrdtMgmtBusinessPartnerGroup,
  MainCreditSegment,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  BusinessPartnerIsCritical,
  CreditAccountIsBlocked,
  CreditAccountBlockReason,
  _CreditBlockReason._Text[1:Language = $session.system_language].CrdtAcctBlockReasonDescription AS CrdtAcctBlockReasonDescription,
  CreditAccountResubmissionDate,
  EffectiveTotalCreditLimitAmt,
  InsuredCreditLimitAmount,
  SecuredCreditLimitAmount,
  TemporaryIncreasedCreditLmtAmt,
  CreditLimitAmount,
  CreditLimitValidityEndDate,
  CreditLimitLastChangeDate,
  CreditLimitCalculatedAmount,
  CreditLimitIsZero,
  CreditLimitIsDefined,
  CreditLimitRequestedAmount,
  CrdtLmtIsReqdFrmAutomCalc,
  CreditLimitReqdValidityEndDate,
  CreditLimitRequestDate,
  CrdtMDunningInfoIsErroneous,
  MaximumDunnedOpenItem,
  MaximumDunningLevel,
  MaximumDunnedOpenItemAmount,
  MaximumDunnedOpenItemCurrency,
  NumberOfOpenItemsInMaxDunLevel,
  DunnedItemInfoTransmnDateTime,
  CrdtMOverdueItmInfoIsErroneous,
  OldestOpenItem,
  OldestOpenItemAmount,
  OldestOpenItemCurrency,
  OldestOpenItemNetDueDate,
  OldestOpnItemNrOfDaysInArrears,
  OldestOpnItemInfoTransmnDteTme,
  CrdtMPaymentInfoIsErroneous,
  LastPaymentItem,
  LastPaymentDate,
  LastPaymentItemAmount,
  LastPaymentCurrency,
  LastPaymentInfoTransmnDateTime,
  CrdtMKeyFigureInfoIsErroneous,
  DaysSalesOutstanding,
  TotalOutstandingAmtInSndrCrcy,
  SenderCurrency,
  CrdtMKeyFigureTransmnDateTime,
  NoCshDiscAvgNrOfDaysInArrears,
  PaytNoCshDiscTotAmtInSndrCrcy,
  CshDiscClmAvgNrOfDaysInArrears,
  PaytWthCshDiscTotAmtInSndrCrcy,
  TotLast12MnthsSlsAmtInSndrCrcy,
  Last12MnthsMaxSlsAmtInSndrCrcy,
  CreditAnalyst,
  CreditCoordinatorName,
  RelationshipCategory,
  BusinessPartnerUUID,
  _CreditAccountPrediction.CrdtLmtExceedanceReferenceDate AS CrdtLmtExceedanceReferenceDate,
  _CreditAccountPrediction.CrdtLmtExceedancePredictedDays AS CrdtLmtExceedancePredictedDays
FROM R_CreditAccountSummaryTP
;