I_CreditLimitRequestCube

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 I_CreditLimitRequestCube.
-- 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: ICRDTLMTREQCUBE
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr

CREATE VIEW I_CreditLimitRequestCube AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  cast( _BusinessPartner._CurrentDefaultAddress._StandardAddress.Country as farp_country preserving type) AS Country,
  _BusinessPartner._CurrentDefaultAddress._StandardAddress.Region AS Region,
  CaseProcessor,
  CaseCreatedBy,
  CaseLastChangedBy,
  CaseClosedBy,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseSystemStatus,
  CaseStatus,
  CasePriority,
  CaseEscalationReason,
  CaseCategory,
  CreditLimitUtilizationPct,
  BusinessPartnerRating,
  CreditRiskClass,
  CrdtMgmtBusinessPartnerGroup,
  cast( NumberOfCreditLimitRequests as numberofcreditlimitrequests ) AS NumberOfCreditLimitRequests,
  cast( CaseCreationDate as scmg_create_date preserving type ) AS CaseCreationDate,
  cast( CaseLastChangeDate as scmg_change_date preserving type ) AS CaseLastChangeDate,
  cast( CaseClosingDate as scmg_closing_date preserving type ) AS CaseClosingDate,
  cast( CasePlannedCloseDate as scmg_plan_end_date preserving type ) AS CasePlannedCloseDate,
  cast ( CaseIsClosed as case_is_closed preserving type ) AS CaseIsClosed,
  cast( NmbrOfDaysPlndClsDateExceeded as numberofdaysafterplannedclose preserving type ) AS NmbrOfDaysPlndClsDateExceeded,
  cast( CreditLimitIsApproved as farp_crdtlmt_is_approved preserving type ) AS CreditLimitIsApproved,
  cast( CrdtLmtReqdIsEqualCrdtLmtAprvd as farp_crdtlmtreq_eq_crdtlmtappr preserving type ) AS CrdtLmtReqdIsEqualCrdtLmtAprvd,
  DisplayCurrency,
  cast( CreditLimitAmount as farp_creditlimit_amt ) AS CreditLimitAmount,
  cast( CreditLimitRequestedAmount as farp_credlimit_requested_amt ) AS CreditLimitRequestedAmount,
  cast( CreditLimitApprovedAmount as farp_credlimit_approved_amt ) AS CreditLimitApprovedAmount,
  cast( ExpectedSalesAmount as crmt_report_exp_revenue ) AS ExpectedSalesAmount,
  cast( CustomerCreditExposureAmount as farp_credit_exposure ) AS CustomerCreditExposureAmount
FROM P_CreditLimitRequest2
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_CreditRiskClass AS _CreditRiskClass ON CreditRiskClass = _CreditRiskClass.CreditRiskClass  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON Country = _Country.Country  -- association [0..1]
LEFT OUTER JOIN I_Region AS _Region ON Country = _Region.Country AND Region = _Region.Region  -- association [0..1]
LEFT OUTER JOIN I_CreditManagementSegment AS _CreditSegment ON CreditSegment = _CreditSegment.CreditSegment  -- association [1..1]
LEFT OUTER JOIN I_CreditCaseContact AS _Processor ON CaseProcessor = _Processor.UserID  -- association [0..1]
LEFT OUTER JOIN I_CreditCaseContact AS _CreatedBy ON CaseCreatedBy = _CreatedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CreditCaseContact AS _ChangedBy ON CaseLastChangedBy = _ChangedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CreditCaseContact AS _ClosedBy ON CaseClosedBy = _ClosedBy.UserID  -- association [0..1]
LEFT OUTER JOIN I_CaseReasons AS _Reasons ON CaseReason = _Reasons.CaseReason AND CaseType = _Reasons.CaseType  -- association [0..1]
LEFT OUTER JOIN I_Casetypes AS _CaseTypes ON CaseType = _CaseTypes.CaseType  -- association [0..1]
LEFT OUTER JOIN I_CaseStatusProfile AS _StatusProfile ON CaseStatusProfile = _StatusProfile.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_CaseStatus AS _CaseSystemStatus ON CaseSystemStatus = _CaseSystemStatus.Status  -- association [0..1]
LEFT OUTER JOIN I_CasePriority AS _Priority ON CasePriority = _Priority.CasePriority  -- association [0..1]
LEFT OUTER JOIN I_CaseCategory AS _Category ON CaseType = _Category.CaseType AND CaseCategory = _Category.CaseCategory  -- association [0..1]
LEFT OUTER JOIN I_Caseindividualstatus AS _Individual ON CaseStatus = _Individual.CaseStatus AND CaseStatusProfile = _Individual.CaseStatusProfile  -- association [0..1]
LEFT OUTER JOIN I_CrdtMBusPartnerGroup AS _CrdtMBusPartnerGroup ON CrdtMgmtBusinessPartnerGroup = _CrdtMBusPartnerGroup.CrdtMgmtBusinessPartnerGroup  -- association [0..1]
;