What is C_CreditLimitRequestQuery in SAP S/4HANA?

C_CreditLimitRequestQuery is a consumption CDS view in SAP S/4HANA. Credit Limit Request Query It contains 38 fields.

Which tables does C_CreditLimitRequestQuery read from?

C_CreditLimitRequestQuery reads data from: I_CreditLimitRequestCube.

What VDM layer is C_CreditLimitRequestQuery?

C_CreditLimitRequestQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CreditLimitRequestQuery

DDL: C_CREDITLIMITREQUESTQUERY SQL: CCRDTLIMITREQSTQ Type: view CONSUMPTION

38 Fields 1 Data Sources

Credit Limit Request Query

C_CreditLimitRequestQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Operations

C_CreditLimitRequestQuery is a Consumption CDS View that provides data about "Credit Limit Request Query" in SAP S/4HANA. It reads from 1 data source (I_CreditLimitRequestCube) and exposes 38 fields with key field CaseUUID.

SAP Help Documentation

Category	CDS Views for Credit Evaluation and Management
Data Category	Query

Purpose
This CDS view retrieves details for a credit limit request in SAP Credit Management . This CDS view provides the data to answer the following business questions: When and by whom was credit limit request created? Who is the processor and the responsible person? What is the planned close date? What is the requested limit amount? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view need to access it via another CDS view (privileged mode).

Structure
Parameters The parameters of the CDS view are as follows: P_ExchangeRateType : This parameter is used to set the exchange rate type. Default value: M. P_DisplayCurrency : This parameter is used to set the display currency. Default value: USD. P_KeyDate : This parameter is used to specify the key date. Important Fields Important fields in this view include the following: Field Name Description Measure or Attribute Comment CaseUUID UUID Attribute The case UUID identifies the credit limit request and is a key field for this view.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Operations
Application Component	FI-FIO-AR
Capabilities	Analytical Query
Package	Financial Operations for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view retrieves details for a credit limit request in SAP Credit Management.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>When and by whom was credit limit request created? </p></li> <li><p>Who is the processor and the responsible person? </p></li> <li><p>What is the planned close date? </p></li> <li><p>What is the requested limit amount?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_CreditLimitRequestCube	I_CreditLimitRequestCube	from

Parameters (3)

Name	Type	Default
P_KeyDate	sydate
P_DisplayCurrency	vdm_v_display_currency
P_ExchangeRateType	kurst_curr

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CCRDTLIMITREQSTQ	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#CONSUMPTION	view
Analytics.query	true	view
OData.publish	true	view
EndUserText.label	Credit Limit Request Query	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (38)

Key	Field	Source Field	Description
KEY	CaseUUID	CaseUUID	UUID in character form
	CaseID	CaseID	Case ID
	BusinessPartner	BusinessPartner	Business Partner Number
	CreditSegment	CreditSegment	Credit Segment
	Country	Country	Venue: Ctry/Reg
	Region	Region	Region (State, Province, County)
	CaseProcessor	CaseProcessor	Processor
	CaseCreatedBy	CaseCreatedBy	Created By
	CaseLastChangedBy	CaseLastChangedBy	Last Changed By
	CaseClosedBy	CaseClosedBy	Closed by User
	CaseReason	CaseReason	Reason for Case
	CaseType	CaseType	Upper/Lowercase
	CaseStatusProfile	CaseStatusProfile	Case: Status Profile
	CaseSystemStatus	CaseSystemStatus	Case: System Status
	CaseStatus	CaseStatus	Case: Status
	CasePriority	CasePriority	Priority
	CaseEscalationReason	CaseEscalationReason	Reason for Escalation
	CaseCategory	CaseCategory	Category
	CreditLimitUtilizationPct	CreditLimitUtilizationPct	Credit Limit Utilization in Percent
	BusinessPartnerRating	BusinessPartnerRating	Score
	CreditRiskClass	CreditRiskClass	Credit Risk Class
	CrdtMgmtBusinessPartnerGroup	CrdtMgmtBusinessPartnerGroup	Customer Credit Group
	NumberOfCreditLimitRequests	NumberOfCreditLimitRequests	Number of Credit Limit Requests
	CaseCreationDate	CaseCreationDate	Created On
	CaseLastChangeDate	CaseLastChangeDate	Last Changed On
	CaseClosingDate	CaseClosingDate	Closed On
	CasePlannedCloseDate	CasePlannedCloseDate	Planned Close Date
	NmbrOfDaysPlndClsDateExceeded	NmbrOfDaysPlndClsDateExceeded	Number of Days After Planned Closing Date
	CaseIsClosed	CaseIsClosed	Case is Closed
	CreditLimitIsApproved	CreditLimitIsApproved	Credit Limit Is Approved
	CrdtLmtReqdIsEqualCrdtLmtAprvd	CrdtLmtReqdIsEqualCrdtLmtAprvd	Requested Limit Vs. Approved Limit
	CasePlannedCloseDateIsExceeded	CasePlannedCloseDateIsExceeded	Planned Close Date is Exceeded
	DisplayCurrency
	CreditLimitAmount	CreditLimitAmount	Customer's Credit Limit
	CreditLimitRequestedAmount	CreditLimitRequestedAmount	Requested Credit Limit
	CreditLimitApprovedAmount	CreditLimitApprovedAmount	Approved Credit Limit
	ExpectedSalesAmount	ExpectedSalesAmount	Expected Sales Revenue
	CustomerCreditExposureAmount	CustomerCreditExposureAmount	Credit Exposure Amount

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

CREATE VIEW C_CreditLimitRequestQuery AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  Country,
  Region,
  CaseProcessor,
  CaseCreatedBy,
  CaseLastChangedBy,
  CaseClosedBy,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseSystemStatus,
  CaseStatus,
  CasePriority,
  CaseEscalationReason,
  CaseCategory,
  CreditLimitUtilizationPct,
  BusinessPartnerRating,
  CreditRiskClass,
  CrdtMgmtBusinessPartnerGroup,
  NumberOfCreditLimitRequests,
  CaseCreationDate,
  CaseLastChangeDate,
  CaseClosingDate,
  CasePlannedCloseDate,
  NmbrOfDaysPlndClsDateExceeded,
  CaseIsClosed,
  CreditLimitIsApproved,
  CrdtLmtReqdIsEqualCrdtLmtAprvd,
  CasePlannedCloseDateIsExceeded,
  :P_DisplayCurrency AS DisplayCurrency,
  CreditLimitAmount,
  CreditLimitRequestedAmount,
  CreditLimitApprovedAmount,
  ExpectedSalesAmount,
  CustomerCreditExposureAmount
FROM I_CreditLimitRequestCube
;

Depth:

C_CreditLimitRequestQuery view

I_CreditLimitRequestCube view