C_CreditLimitRequestTP

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_CreditLimitRequestTP.
-- 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_CreditLimitRequestTP AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  CaseProcessor,
  CaseResponsible,
  CaseExternalReference,
  CaseTitle,
  CaseCreatedBy,
  CreditCaseCreationDateTime,
  CaseLastChangedBy,
  CreditCaseLastChangeDateTime,
  CaseClosedBy,
  CreditCaseCloseDateTime,
  CasePlannedCloseDate,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CasePriority,
  CaseAuthorizationLevel,
  CaseEscalationReason,
  CaseCategory,
  CaseStatusObjectNumber,
  CaseSystemStatusName,
  CaseUserStatusName,
  cast( CreditLimitUtilizationPct as ukm_clcr_credit_us32 preserving type ) AS CreditLimitUtilizationPct,
  cast( BusinessPartnerRating as ukm_clcr_own_rating preserving type ) AS BusinessPartnerRating,
  cast( CreditRiskClass as ukm_clcr_risk_class preserving type ) AS CreditRiskClass,
  CrdtMgmtBusinessPartnerGroup,
  CreditSegmentCurrency,
  CreditLimitRequestedAmount,
  CreditLimitApprovedAmount,
  ExpectedSalesAmount,
  CustomerCreditExposureAmount,
  _CreditManagementAccount.CreditLimitAmount AS CreditLimitAmount,
  _CreditManagementBP.CreditRiskClass AS CurrentCreditRiskClass,
  _CaseTypes.CaseAttributeProfile AS CaseAttributeProfile,
  CreditLimitValidityEndDate,
  _BlockedCreditDecisionDocument.NumberOfCreditDecisionDocs AS NumberOfCreditDecisionDocs,
  _BrokenPromisesToPay.NumberOfBrokenPromisesToPay AS NumberOfBrokenPromisesToPay,
  _CreditManagementAccount._CrdtMAcctPaytBehaviorTP.DaysSalesOutstanding AS DaysSalesOutstanding,
  _CreditManagementAccount._CrdtMAcctPaytBehaviorTP.Last12MnthsMaxSlsAmtInSndrCrcy AS Last12MnthsMaxSlsAmtInSndrCrcy,
  _CreditManagementAccount._CrdtMAcctPaytBehaviorTP.TotLast12MnthsSlsAmtInSndrCrcy AS TotLast12MnthsSlsAmtInSndrCrcy,
  CreditCoordinator,
  _CreditAnalystContactCard.UserDescription AS CreditAnalystName,
  _Priority._Text.CasePriorityName : localized AS CasePriorityNamelocalized,
  _CreditRiskClass._Text.CreditRiskClassName : localized AS CreditRiskClassNamelocalized,
  _CreditSegment._Text.CreditSegmentName : localized AS CreditSegmentNamelocalized,
  _Escalation._Text.CaseEscalationReasonName : localized AS CaseEscalationReasonNamelocalized,
  _Individual._Text.CaseStatusName : localized AS CaseStatusNamelocalized,
  _CaseCategory._Text.CaseCategoryName : localized AS CaseCategoryNamelocalized,
  _Reasons._Text.CaseReasonName : localized AS CaseReasonNamelocalized,
  _StatProfile._Text.CaseStatusProfileName : localized AS CaseStatusProfileNamelocalized,
  _BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CreatedByUserContactCard.UserDescription AS CaseCreatedByUserName,
  _LastChangeUserContactCard.UserDescription AS CaseLastChangedByUserName,
  _ClosedByUserContactCard.UserDescription AS CaseClosedByUserName,
  _PersonResponsibleUser.PersonFullName AS CaseResponsibleName,
  _ProcessorUser.PersonFullName AS CaseProcessorName,
  _BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _CreditAnalyst._BusinessUser.FirstName AS UICT_CoordinatorFirstName,
  _CreditAnalyst._BusinessUser.LastName AS UICT_CoordinatorLastName,
  _ProcessorUser.FirstName AS UICT_ProcessorFirstName,
  _ProcessorUser.LastName AS UICT_ProcessorLastName,
  _PersonResponsibleUser.FirstName AS UICT_ResponsibleFirstName,
  _PersonResponsibleUser.LastName AS UICT_ResponsibleLastName,
  _CreatedByUserContactCard.FirstName AS UICT_CreatedByFirstName,
  _CreatedByUserContactCard.LastName AS UICT_CreatedByLastName,
  _LastChangeUserContactCard.FirstName AS UICT_ChangedByFirstName,
  _LastChangeUserContactCard.LastName AS UICT_ChangedByLastName,
  _ClosedByUserContactCard.FirstName AS UICT_ClosedByFirstName,
  _ClosedByUserContactCard.LastName AS UICT_ClosedByLastName,
  virtual NoteTypeListText : text200 AS virtualNoteTypeListTexttext200,
  virtual PlannedCloseDateIsExceeded : boolean AS virtualPlannedCloseDateIsExceededboolean,
  virtual PlannedCloseDateCriticality : char1 AS virtualPlannedCloseDateCriticalitychar1
FROM R_CreditLimitRequestTP
LEFT OUTER JOIN C_CreditLimitRequestLog AS _CreditLimitRequestLog ON CaseUUID = _CreditLimitRequestLog.CaseUUID  -- association [0..*]
LEFT OUTER JOIN C_CreditWorthinessScoreTrend AS _CreditWorthinessScoreTrend ON BusinessPartner = _CreditWorthinessScoreTrend.ChangeDocObject  -- association [0..*]
LEFT OUTER JOIN C_CrdtMAcctAgingGrid AS _AgingGrid ON BusinessPartner = _AgingGrid.BusinessPartner AND CreditSegment = _AgingGrid.CreditSegment  -- association [0..*]
LEFT OUTER JOIN C_CreditLimitTrend AS _CreditLimitTrend ON BusinessPartner = _CreditLimitTrend.ChangeDocObject AND CreditSegment = _CreditLimitTrend.CreditSegment  -- association [0..*]
;