What is C_CreditDecisionDocumentQ in SAP S/4HANA?

C_CreditDecisionDocumentQ is a consumption CDS view in SAP S/4HANA. Credit Decision Document Query It contains 53 fields.

Which tables does C_CreditDecisionDocumentQ read from?

C_CreditDecisionDocumentQ reads data from: I_CreditDecisionDocumentC.

What VDM layer is C_CreditDecisionDocumentQ?

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

C_CreditDecisionDocumentQ

DDL: C_CREDITDECISIONDOCUMENTQ SQL: CCRDTDCSNDOCQ Type: view CONSUMPTION

53 Fields 1 Data Sources

Credit Decision Document Query

C_CreditDecisionDocumentQ (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_CreditDecisionDocumentQ is a Consumption CDS View that provides data about "Credit Decision Document Query" in SAP S/4HANA. It reads from 1 data source (I_CreditDecisionDocumentC) and exposes 53 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 about a credit decision document in SAP Credit Management . This CDS view provides the data to answer the following business questions: When and by whom was credit decision document created? Who is the processor and the responsible person? What is the planned close date? What is the related sales order? 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_ReadLineItem : This parameter is a flag used to include the exposure from finance. Default value: Y. 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 DCD and is a key field for this view. CreditLimitUtilizationPct Credit Limit Used % Measure Shows the credit limit utilization in percent. It is calculated as follows: CreditLimitUtilizationPct = (CustomerCreditExposureAmount / CustomerCreditLimitAmount) x 100

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 about a credit decision document 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 decision document 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 related sales order?</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_CreditDecisionDocumentC	I_CreditDecisionDocumentC	from

Parameters (4)

Name	Type	Default
P_KeyDate	sydate
P_DisplayCurrency	vdm_v_display_currency
P_ExchangeRateType	kurst_curr
P_ReadLineItem	read_fiar_lineitems

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	CCRDTDCSNDOCQ	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 Decision Document 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 (53)

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	Credit Analyst
	CaseResponsible	CaseResponsible	Person Responsible
	CaseCreatedBy	CaseCreatedBy	Created By
	CaseLastChangedBy	CaseLastChangedBy	Last Changed By
	CaseClosedBy	CaseClosedBy	Closed by User
	CreditRiskClass	CreditRiskClass	Risk Class at Time of Credit Decision
	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
	CrdtMgmtBusinessPartnerGroup	CrdtMgmtBusinessPartnerGroup	Customer Credit Group
	NumberOfCreditDecisionDocs	NumberOfCreditDecisionDocs	Number of Documented Credit Decisions
	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
	CasePlannedCloseDateIsExceeded	CasePlannedCloseDateIsExceeded	Planned Close Date is Exceeded
	DisplayCurrency	DisplayCurrency	Display Currency
	OpenCreditAmount	OpenCreditAmount	Open Credit Amount
	CheckedCreditRiskAmount	CheckedCreditRiskAmount	Checked Credit Value
	CustomerCreditLimitAmount	CustomerCreditLimitAmount	Customer's Credit Limit
	CustomerCreditExposureAmount	CustomerCreditExposureAmount	Credit Exposure Amount
	CreditDecisionObjectType	CreditDecisionObjectType	Type of Document with Credit Block
	CreditDecisionSalesDocument	CreditDecisionSalesDocument	Sales and Distribution Document Number
	SalesDocumentCreditStatus	SalesDocumentCreditStatus	Status of Document with Credit Block
	CreditDecisionReqUTCDateTime	CreditDecisionReqUTCDateTime	Timestamp
	CreditDecisionFirstApprover	CreditDecisionFirstApprover	Approver
	CreditDecisionSecondApprover	CreditDecisionSecondApprover	Second Approver
	CreditDecisionFirstApprvlSts	CreditDecisionFirstApprvlSts	Status of First Approval
	CreditDecisionSecondApprvlSts	CreditDecisionSecondApprvlSts	Status of Second Approval
	CreditDecisionCompletedByUser	CreditDecisionCompletedByUser	User Who Released/Rejected the Sales Document
	CrdtDcsnApprvlProcIsOverruled	CrdtDcsnApprvlProcIsOverruled	Approval Process Not Adhered To
	StaticLmtUtilznCrdtChkIsFailed	StaticLmtUtilznCrdtChkIsFailed	Static Check of Credit Limit Utilization Failed
	MaxDocAmountCreditChkIsFailed	MaxDocAmountCreditChkIsFailed	Check for Maximum Document Value Failed
	DynLimitUtilznCrdtChkIsFailed	DynLimitUtilznCrdtChkIsFailed	Dynamic Check of Credit Limit Utilization Failed
	MaxDunningLevelCrdtChkIsFailed	MaxDunningLevelCrdtChkIsFailed	Check of Maximum Dunning Level Failed
	OldestOpenItemCrdtChkIsFailed	OldestOpenItemCrdtChkIsFailed	Check for Oldest Open Item Failed
	DaysSlsOutStdgCrdtChkIsFailed	DaysSlsOutStdgCrdtChkIsFailed	Check of Days Sales Outstanding (DSO) Failed
	OtherCreditCheckIsFailed	OtherCreditCheckIsFailed	Other Checks Failed
	OverdueOpenItemCrdtChkIsFailed	OverdueOpenItemCrdtChkIsFailed	Check for Overdue Open Items Failed
	CreditLimitUtilizationPct	1	Credit Limit Used %

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_CreditDecisionDocumentQ.
-- 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: CCRDTDCSNDOCQ
-- Parameters: P_KeyDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_ReadLineItem : read_fiar_lineitems

CREATE VIEW C_CreditDecisionDocumentQ AS
SELECT
  CaseUUID,
  CaseID,
  BusinessPartner,
  CreditSegment,
  Country,
  Region,
  CaseProcessor,
  CaseResponsible,
  CaseCreatedBy,
  CaseLastChangedBy,
  CaseClosedBy,
  CreditRiskClass,
  CaseReason,
  CaseType,
  CaseStatusProfile,
  CaseSystemStatus,
  CaseStatus,
  CasePriority,
  CaseEscalationReason,
  CaseCategory,
  CrdtMgmtBusinessPartnerGroup,
  NumberOfCreditDecisionDocs,
  CaseCreationDate,
  CaseLastChangeDate,
  CaseClosingDate,
  CasePlannedCloseDate,
  NmbrOfDaysPlndClsDateExceeded,
  CaseIsClosed,
  CasePlannedCloseDateIsExceeded,
  DisplayCurrency,
  OpenCreditAmount,
  CheckedCreditRiskAmount,
  CustomerCreditLimitAmount,
  CustomerCreditExposureAmount,
  CreditDecisionObjectType,
  CreditDecisionSalesDocument,
  SalesDocumentCreditStatus,
  CreditDecisionReqUTCDateTime,
  CreditDecisionFirstApprover,
  CreditDecisionSecondApprover,
  CreditDecisionFirstApprvlSts,
  CreditDecisionSecondApprvlSts,
  CreditDecisionCompletedByUser,
  CrdtDcsnApprvlProcIsOverruled,
  StaticLmtUtilznCrdtChkIsFailed,
  MaxDocAmountCreditChkIsFailed,
  DynLimitUtilznCrdtChkIsFailed,
  MaxDunningLevelCrdtChkIsFailed,
  OldestOpenItemCrdtChkIsFailed,
  DaysSlsOutStdgCrdtChkIsFailed,
  OtherCreditCheckIsFailed,
  OverdueOpenItemCrdtChkIsFailed,
  1 AS CreditLimitUtilizationPct
FROM I_CreditDecisionDocumentC
;

Depth:

C_CreditDecisionDocumentQ view

I_CreditDecisionDocumentC view