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,
  CreditLimitAmount AS CurrentCreditLimitAmount,
  CreditLimitRequestedAmount,
  CreditLimitApprovedAmount,
  ExpectedSalesAmount,
  CustomerCreditExposureAmount,
  _CreditManagementAccount.CreditLimitAmount AS CreditLimitAmount,
  _CreditManagementBP.CreditRiskClass AS CurrentCreditRiskClass,
  _CaseTypes.CaseAttributeProfile AS CaseAttributeProfile,
  CreditLimitValidityEndDate,
  _BlockedCreditDecisionDocument.NumberOfCreditDecisionDocs AS NumberOfCreditDecisionDocs,
  _OpenCreditDecisionDocument.NumberOfCreditDecisionDocs_2 AS NumberOfCreditDecisionDocs_2,
  _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,
  virtual UICT_ProcessorFirstName : bu_namep_f AS virtualUICT_ProcessorFirstNamebu_namep_f,
  virtual UICT_ProcessorLastName : bu_namep_l AS virtualUICT_ProcessorLastNamebu_namep_l,
  virtual UICT_CreatedByFirstName : ad_namefir AS virtualUICT_CreatedByFirstNamead_namefir,
  virtual UICT_CreatedByLastName : ad_namelas AS virtualUICT_CreatedByLastNamead_namelas,
  virtual UICT_ChangedByFirstName : ad_namefir AS virtualUICT_ChangedByFirstNamead_namefir,
  virtual UICT_ChangedByLastName : ad_namelas AS virtualUICT_ChangedByLastNamead_namelas,
  virtual UICT_ClosedByFirstName : ad_namefir AS virtualUICT_ClosedByFirstNamead_namefir,
  virtual UICT_ClosedByLastName : ad_namelas AS virtualUICT_ClosedByLastNamead_namelas,
  virtual NoteTypeListText : text200 AS virtualNoteTypeListTexttext200,
  virtual PlannedCloseDateIsExceeded : boolean AS virtualPlannedCloseDateIsExceededboolean,
  virtual PlannedCloseDateCriticality : char1 AS virtualPlannedCloseDateCriticalitychar1,
  virtual UICT_Hide_DCD_V1 : ukm_hide_dcd_v1 AS virtualUICT_Hide_DCD_V1ukm_hide_dcd_v1,
  virtual UICT_Hide_DCD_V2 : ukm_hide_dcd_v2 AS virtualUICT_Hide_DCD_V2ukm_hide_dcd_v2
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..*]
;