What is I_CreditManagementAccount in SAP S/4HANA?

I_CreditManagementAccount is a basic CDS view in SAP S/4HANA. Credit Management Account It contains 21 fields.

Which tables does I_CreditManagementAccount read from?

I_CreditManagementAccount reads data from: ukmbp_cms_sgm.

What VDM layer is I_CreditManagementAccount?

I_CreditManagementAccount is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CreditManagementAccount

DDL: I_CREDITMANAGEMENTACCOUNT SQL: ICREDMGMNTACCNT Type: view BASIC

21 Fields 1 Data Sources 4 Associations

Credit Management Account

I_CreditManagementAccount (Basic)

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

Financial Operations

I_CreditManagementAccount is a Basic CDS View that provides data about "Credit Management Account" in SAP S/4HANA. It reads from 1 data source (ukmbp_cms_sgm) and exposes 21 fields with key fields BusinessPartner, CreditSegment. It has 4 associations to related views.

SAP Help Documentation

Category	CDS Views for Credit Evaluation and Management

Purpose
This CDS view is designed to provide a comprehensive overview of credit management accounts by integrating data from various related entities such as business partners, credit segments, and block reasons. It serves as a foundational data source for analyzing credit limits, account statuses, and associated business partners. This CDS view provides the data to answer the following business questions: What is the credit limit assigned to a specific business partner within a particular credit segment? Is a business partner's credit account currently blocked, and if so, what is the reason for the block? What are the calculated and requested credit limits for a business partner, and how do they compare to the assigned credit limit? When was the last change made to a business partner's credit limit, and when does the current credit limit expire? Who is the credit coordinator responsible for managing a business partner's credit account? Is a business partner considered critical in terms of credit management? Are there any automatic calculations required for a business partner's credit limit, and what is the requested validity end date for the credit limit? 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 must have the following authorization objects assigned: Authorization Object ID Authorization object Text B_BUPA_GRP Business Partner: Authorization Groups B_BUPA_RLT Business Partner: BP Roles B_BUP_DCPD Business Partner: Data Categories B_BUP_PCPT Business Partner: End of Purposes F_UKM_SGMT SAP Credit Management Authorization for Credit Segment

Structure
Important fields Important fields in this view include the following: Field Name Description BusinessPartner Business Partner CreditSegment Credit Segment CreditSegmentCurrency Currency CustomerCreditLimitAmount Credit Limit CreditLimitCalculatedAmount Calculated Limit CreditLimitRequestedAmount Limit Requested CreditAccountIsBlocked Block in Cr. Mgt CreditLimitValidityEndDate Limit Valid To CreditLimitLastChangeDate Limit Changed On CreditCoordinator Credit Analyst CreditAccountResubmissionDate Resubmission On BusinessPartnerIsCritical Special Attention CreditLimitIsZero Limit is Zero CreditAccountBlockReason Block Reason CrdtLmtIsReqdFrmAutomCalc Calculated CreditLimitReqdValidityEndDate Valid To (Requested) CreditLimitRequestDate Requested On

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Operations
Application Component	FIN-FSCM-CR
Capabilities	Data Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
Package	Financial Operations for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view is designed to provide a comprehensive overview of credit management accounts by integrating data from various related entities such as business partners, credit segments, and block reasons. It serves as a foundational data source for analyzing credit limits, account statuses, and associated business partners.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>What is the credit limit assigned to a specific business partner within a particular credit segment?</p></li> <li><p>Is a business partner's credit account currently blocked, and if so, what is the reason for the block?</p></li> <li><p>What are the calculated and requested credit limits for a business partner, and how do they compare to the assigned credit limit?</p></li> <li><p>When was the last change made to a business partner's credit limit, and when does the current credit limit expire?</p></li> <li><p>Who is the credit coordinator responsible for managing a business partner's credit account?</p></li> <li><p>Is a business partner considered critical in terms of credit management?</p></li> <li><p>Are there any automatic calculations required for a business partner's credit limit, and what is the requested validity end date for the credit limit?</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
ukmbp_cms_sgm	ukmbp_cms_sgm	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_BusinessPartner	_BusinessPartner	`$projection.BusinessPartner = _BusinessPartner.BusinessPartner`
[1..1]	I_CreditManagementBP	_CreditAccount	`$projection.BusinessPartner = _CreditAccount.BusinessPartner`
[1..1]	I_CreditManagementSegment	_CreditSegment	`$projection.CreditSegment = _CreditSegment.CreditSegment`
[0..1]	I_CreditBlockReason	_CreditBlockReason	`$projection.CreditAccountBlockReason = _CreditBlockReason.CreditAccountBlockReason`

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	ICREDMGMNTACCNT	view
EndUserText.label	Credit Management Account	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#CHECK	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view

Fields (21)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner		partner	Business Partner Number
KEY	CreditSegment			Credit Segment
	CreditSegmentCurrency	_CreditSegment	CreditSegmentCurrency	Credit Segment Currency
	CustomerCreditLimitAmount		credit_limit	Credit Limit
	CreditLimitCalculatedAmount		cred_lim_calc	Calculated Credit Limit
	CreditLimitRequestedAmount		cred_lim_req	Credit Limit Requested
	CreditAccountIsBlocked		xblocked	Blocked by Credit Management
	CreditLimitValidityEndDate		limit_valid_date	Valid To Date
	CreditLimitLastChangeDate		limit_chg_date	Change Date for Credit Limit
	CreditCoordinator		coordinator	Credit Analyst
	CreditAccountResubmissionDate		follow_up_dt	Resubmission Date
	BusinessPartnerIsCritical			Special Attention Required
	CreditLimitIsZero		x_limit_zero	Limit Is Zero
	CreditAccountBlockReason		block_reason	Reason for Block in Credit Management
	CrdtLmtIsReqdFrmAutomCalc		automatic_req	Limit Request from Automatic Calculation
	CreditLimitReqdValidityEndDate		lim_val_date_req	Valid To Date (Requested)
	CreditLimitRequestDate		req_date	Requested On
	_BusinessPartner		_BusinessPartner
	_CreditAccount		_CreditAccount
	_CreditSegment		_CreditSegment
	_CreditBlockReason		_CreditBlockReason

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_CreditManagementAccount.
-- 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: ICREDMGMNTACCNT

CREATE VIEW I_CreditManagementAccount AS
SELECT
  partner AS BusinessPartner,
  cast( credit_sgmnt as ukm_credit_sgmnt preserving type ) AS CreditSegment,
  _CreditSegment.CreditSegmentCurrency AS CreditSegmentCurrency,
  credit_limit AS CustomerCreditLimitAmount,
  cred_lim_calc AS CreditLimitCalculatedAmount,
  cred_lim_req AS CreditLimitRequestedAmount,
  xblocked AS CreditAccountIsBlocked,
  limit_valid_date AS CreditLimitValidityEndDate,
  limit_chg_date AS CreditLimitLastChangeDate,
  coordinator AS CreditCoordinator,
  follow_up_dt AS CreditAccountResubmissionDate,
  cast( xcritical as ukm_critical_account preserving type ) AS BusinessPartnerIsCritical,
  x_limit_zero AS CreditLimitIsZero,
  block_reason AS CreditAccountBlockReason,
  automatic_req AS CrdtLmtIsReqdFrmAutomCalc,
  lim_val_date_req AS CreditLimitReqdValidityEndDate,
  req_date AS CreditLimitRequestDate
FROM ukmbp_cms_sgm
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CreditManagementBP AS _CreditAccount ON BusinessPartner = _CreditAccount.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CreditManagementSegment AS _CreditSegment ON CreditSegment = _CreditSegment.CreditSegment  -- association [1..1]
LEFT OUTER JOIN I_CreditBlockReason AS _CreditBlockReason ON CreditAccountBlockReason = _CreditBlockReason.CreditAccountBlockReason  -- association [0..1]
;

Depth:

I_CreditManagementAccount view

ukmbp_cms_sgm