I_CreditBlockReason

DDL: I_CREDITBLOCKREASON SQL: ICRDBLOCKREASN Type: view BASIC
2 Fields 1 Data Sources 1 Associations

CreditManagement Block Reason

I_CreditBlockReason (Basic)

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

CreditAccountBlockReason · Financial Operations

I_CreditBlockReason is a Basic CDS View (Dimension) that provides data about "CreditManagement Block Reason" in SAP S/4HANA. It reads from 1 data source (ukm_bl_reason) and exposes 2 fields with key field CreditAccountBlockReason. It has 1 association to related views.

SAP Help Documentation

CategoryCDS Views for Credit Evaluation and Management
Data CategoryDimension
Purpose
This CDS view is designed to provide a structured representation of credit management block reasons within a system. It serves as a dimension in analytical scenarios, allowing users to understand and categorize the reasons for blocking credit accounts. The view is primarily used for data extraction and reporting purposes, enabling businesses to analyze and manage credit block reasons effectively. This CDS view provides the data to answer the following business questions: What are the different reasons for blocking credit accounts in the system? How can we categorize and analyze the block reasons for credit management? What textual descriptions are associated with each credit account block reason? How can we extract and report on credit block reasons for analytical purposes? 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 don't need any special authorization.

Structure
Important Fields Important fields in this view include the following: Field Name Description CreditAccountBlockReason Block Reason

Data Extraction
Data Extraction Type This CDS view is enabled for data extraction in full mode.

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Operations
Application ComponentFIN-FSCM-CR
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities, Analytical Dimension, Data Source for Data Extraction
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is designed to provide a structured representation of credit management block reasons within a system. It serves as a dimension in analytical scenarios, allowing users to understand and categorize the reasons for blocking credit accounts. The view is primarily used for data extraction and reporting purposes, enabling businesses to analyze and manage credit block reasons effectively.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the different reasons for blocking credit accounts in the system?</p></li> <li><p>How can we categorize and analyze the block reasons for credit management?</p></li> <li><p>What textual descriptions are associated with each credit account block reason?</p></li> <li><p>How can we extract and report on credit block reasons for analytical purposes?</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

Data Sources (1)

SourceAliasJoin Type
ukm_bl_reason ukm_bl_reason from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CreditBlockReasonText _Text $projection.CreditAccountBlockReason = _Text.CreditAccountBlockReason

Annotations (15)

NameValueLevelField
EndUserText.label CreditManagement Block Reason view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName ICRDBLOCKREASN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CreditAccountBlockReason view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY CreditAccountBlockReason block_reason Reason for Block in Credit Management
_Text _Text

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_CreditBlockReason.
-- 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: ICRDBLOCKREASN

CREATE VIEW I_CreditBlockReason AS
SELECT
  block_reason AS CreditAccountBlockReason
FROM ukm_bl_reason
LEFT OUTER JOIN I_CreditBlockReasonText AS _Text ON CreditAccountBlockReason = _Text.CreditAccountBlockReason  -- association [0..*]
;

Learn More