I_CreditAccountAdditionalInfo

DDL: I_CREDITACCOUNTADDITIONALINFO SQL: ICRDTACCTADDINFO Type: view BASIC
18 Fields 1 Data Sources 5 Associations

Credit Account Additional Information

I_CreditAccountAdditionalInfo (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_CreditAccountAdditionalInfo is a Basic CDS View that provides data about "Credit Account Additional Information" in SAP S/4HANA. It reads from 1 data source (bp3100) and exposes 18 fields with key fields BusinessPartner, CreditSegment, CrdtAcctInformationCategory, CrdtAcctInformationType, CrdtAcctAddInfoUTCDateTime. It has 5 associations to related views.

SAP Help Documentation

CategoryCDS Views for Credit Evaluation and Management
Purpose
This CDS view provides a structured representation of additional information related to credit accounts. It integrates data from various associated entities such as business partners, credit management segments, and currency details. The view is designed to facilitate transactional operations and ensure data integrity through its defined associations and semantic annotations. This CDS view provides the data to answer the following business questions: What are the additional credit account details associated with a specific business partner? How can we categorize and type the additional credit account information for better credit management? What is the transaction currency and amount for additional credit documents? What are the validity start and end dates for the credit account information? Is the exception relevant for credit checks in the context of additional credit account information? What comments or notes are associated with additional credit documents? When is the resubmission date for the credit account information? 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 Bus Partner Number CreditSegment Credit Segment CrdtAcctInformationCategory Information Category CrdtAcctInformationType Information Type CrdtAcctAddInfoUTCDateTime Short Time Stamp AdditionalCreditDocSequence Counter ExceptionIsCreditCheckRelevant Relevance AddlCreditDocAmtInTransacCrcy Amount TransactionCurrency Currency ValidityStartDate Valid From ValidityEndDate Valid To CreditAccountResubmissionDate Resubmission AdditionalCreditDocComment Comment

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
PackageFinancial Operations for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides a structured representation of additional information related to credit accounts. It integrates data from various associated entities such as business partners, credit management segments, and currency details. The view is designed to facilitate transactional operations and ensure data integrity through its defined associations and semantic annotations.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the additional credit account details associated with a specific business partner?</p></li> <li><p>How can we categorize and type the additional credit account information for better credit management?</p></li> <li><p>What is the transaction currency and amount for additional credit documents?</p></li> <li><p>What are the validity start and end dates for the credit account information?</p></li> <li><p>Is the exception relevant for credit checks in the context of additional credit account information?</p></li> <li><p>What comments or notes are associated with additional credit documents?</p></li> <li><p>When is the resubmission date for the credit account information?</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
bp3100 bp3100 from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BusinessPartner _BusinessPartner $projection.BusinessPartner = _BusinessPartner.BusinessPartner
[0..1] I_CreditManagementSegment _CreditManagementSegment $projection.CreditSegment = _CreditManagementSegment.CreditSegment
[0..1] I_CrdtAcctInfoCategory _CrdtAcctInfoCategory $projection.CrdtAcctInformationCategory = _CrdtAcctInfoCategory.CrdtAcctInformationCategory
[0..1] I_CrdtAcctInformationType _CrdtAcctInformationType $projection.CrdtAcctInformationCategory = _CrdtAcctInformationType.CrdtAcctInformationCategory and $projection.CrdtAcctInformationType = _CrdtAcctInformationType.CrdtAcctInformationType
[0..1] I_Currency _Currency $projection.TransactionCurrency = _Currency.Currency

Annotations (16)

NameValueLevelField
EndUserText.label Credit Account Additional Information view
AbapCatalog.sqlViewName ICRDTACCTADDINFO view
VDM.viewType #BASIC view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey AdditionalCreditDocSequence view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Analytics.internalName #LOCAL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner partner Business Partner Number
KEY CreditSegment Credit Segment
KEY CrdtAcctInformationCategory addtype Information Category
KEY CrdtAcctInformationType data_type Information Type
KEY CrdtAcctAddInfoUTCDateTime timestamp UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
KEY AdditionalCreditDocSequence counter Version
ExceptionIsCreditCheckRelevant Relevance for Credit Check
AddlCreditDocAmtInTransacCrcy amnt WTax Amt in LC
TransactionCurrency curr Valuation Crcy
ValidityStartDate Start Date of Validity
ValidityEndDate End Date of Validity
CreditAccountResubmissionDate Resubmission Date
AdditionalCreditDocComment Additional Information
_BusinessPartner _BusinessPartner
_CreditManagementSegment _CreditManagementSegment
_CrdtAcctInfoCategory _CrdtAcctInfoCategory
_CrdtAcctInformationType _CrdtAcctInformationType
_Currency _Currency

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_CreditAccountAdditionalInfo.
-- 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: ICRDTACCTADDINFO

CREATE VIEW I_CreditAccountAdditionalInfo AS
SELECT
  partner AS BusinessPartner,
  cast(criter as ukm_credit_sgmnt preserving type) AS CreditSegment,
  addtype AS CrdtAcctInformationCategory,
  data_type AS CrdtAcctInformationType,
  timestamp AS CrdtAcctAddInfoUTCDateTime,
  counter AS AdditionalCreditDocSequence,
  cast(xfeld as ukm_check_relevant preserving type ) AS ExceptionIsCreditCheckRelevant,
  amnt AS AddlCreditDocAmtInTransacCrcy,
  curr AS TransactionCurrency,
  cast(datefr as ukm_validity_start_date preserving type ) AS ValidityStartDate,
  cast(dateto as ukm_validity_end_date preserving type) AS ValidityEndDate,
  cast(addate as ukm_resubmission_date preserving type) AS CreditAccountResubmissionDate,
  cast(text as ukm_comment preserving type) AS AdditionalCreditDocComment
FROM bp3100
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CreditManagementSegment AS _CreditManagementSegment ON CreditSegment = _CreditManagementSegment.CreditSegment  -- association [0..1]
LEFT OUTER JOIN I_CrdtAcctInfoCategory AS _CrdtAcctInfoCategory ON CrdtAcctInformationCategory = _CrdtAcctInfoCategory.CrdtAcctInformationCategory  -- association [0..1]
LEFT OUTER JOIN I_CrdtAcctInformationType AS _CrdtAcctInformationType ON CrdtAcctInformationCategory = _CrdtAcctInformationType.CrdtAcctInformationCategory AND CrdtAcctInformationType = _CrdtAcctInformationType.CrdtAcctInformationType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _Currency ON TransactionCurrency = _Currency.Currency  -- association [0..1]
;

Learn More