P_CreditLimitRequest2

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 P_CreditLimitRequest2.
-- 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.
-- SQL view name: PCRDTLIMITREQ2
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr

CREATE VIEW P_CreditLimitRequest2 AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  CaseProcessor,
  CaseCreatedBy,
  CaseLastChangedBy,
  CaseClosedBy,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseSystemStatus,
  CaseStatus,
  CasePriority,
  CaseEscalationReason,
  CaseCategory,
  CreditLimitUtilizationPct,
  BusinessPartnerRating,
  CreditRiskClass,
  CrdtMgmtBusinessPartnerGroup,
  CaseCreationDate,
  CaseLastChangeDate,
  CaseClosingDate,
  CasePlannedCloseDate,
  TodayDate,
  CaseIsClosed,
  CreditLimitIsApproved,
  1 AS NumberOfCreditLimitRequests,
  DisplayCurrency,
  CreditLimitAmount,
  CreditLimitRequestedAmount,
  CreditLimitApprovedAmount,
  ExpectedSalesAmount,
  CustomerCreditExposureAmount
FROM P_CreditLimitRequest1
;