R_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 R_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 R_CreditLimitRequestTP AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  CaseProcessor,
  CaseResponsible,
  CaseExternalReference,
  CaseTitle,
  CaseCreatedBy,
  CaseCreatedOn AS CreditCaseCreationDateTime,
  CaseLastChangedBy,
  CaseLastChangedOn AS CreditCaseLastChangeDateTime,
  CaseClosedBy,
  CaseClosedTime AS CreditCaseCloseDateTime,
  CasePlannedCloseDate,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseStatus,
  CaseSystemStatus,
  CasePriority,
  CaseAuthorizationLevel,
  CaseEscalationReason,
  CaseCategory,
  CaseStatusObjectNumber,
  CaseSystemStatusName,
  CaseUserStatusName,
  CreditLimitUtilizationPct,
  BusinessPartnerRating,
  CreditRiskClass,
  CrdtMgmtBusinessPartnerGroup,
  CreditSegmentCurrency,
  CreditLimitAmount,
  CreditLimitRequestedAmount,
  CreditLimitApprovedAmount,
  ExpectedSalesAmount,
  cast( CustomerCreditExposureAmount as ukm_clcr_comm_total preserving type ) AS CustomerCreditExposureAmount,
  CreditLimitValidityEndDate,
  _CreditAnalyst.UserID AS CreditCoordinator,
  _CreditAnalyst._CreditAnalystContactCard AS _CreditAnalystContactCard
FROM I_CreditLimitRequest
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CreatedByUserContactCard ON CaseCreatedBy = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _LastChangeUserContactCard ON CaseLastChangedBy = _LastChangeUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _ClosedByUserContactCard ON CaseClosedBy = _ClosedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CaseProcessorContactCard ON CaseProcessor = _CaseProcessorContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_RblsMgmtUserContactCard AS _CaseResponsibleContactCard ON CaseResponsible = _CaseResponsibleContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN R_CreditMgmtAccountTP AS _CreditManagementAccount ON BusinessPartner = _CreditManagementAccount.BusinessPartner AND CreditSegment = _CreditManagementAccount.CreditSegment  -- association [0..1]
LEFT OUTER JOIN I_BusinessUser AS _ProcessorUser ON CaseProcessor = _ProcessorUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_BusinessUser AS _PersonResponsibleUser ON CaseResponsible = _PersonResponsibleUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_CrdtAcctNrOfBlkdCrdtDcsnDocs AS _BlockedCreditDecisionDocument ON BusinessPartner = _BlockedCreditDecisionDocument.BusinessPartner AND CreditSegment = _BlockedCreditDecisionDocument.CreditSegment  -- association [0..1]
LEFT OUTER JOIN I_CrdtMNrOfBrokenPromisesToPay AS _BrokenPromisesToPay ON BusinessPartner = _BrokenPromisesToPay.BusinessPartner AND CreditSegment = _BrokenPromisesToPay.CreditSegment  -- association [0..1]
LEFT OUTER JOIN R_CrdtMAccountMainAnalyst AS _CreditAnalyst ON BusinessPartner = _CreditAnalyst.BusinessPartner AND CreditSegment = _CreditAnalyst.CreditSegment AND _CreditAnalyst.UserID is not initial  -- association [0..1]
LEFT OUTER JOIN R_CrdtMgmtBPQuickViewTP AS _QuickView ON BusinessPartner = _QuickView.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_CreditLimitRequest AS _Extension ON CaseUUID = _Extension.CaseUUID  -- association [1]
LEFT OUTER JOIN R_CrdtLmtChgReqApprvlHierTP AS _ApprovalHierarchy ON /* condition not available in parsed metadata */  -- association [0..*]
;