I_CashPoolSubAcctAssgmt

DDL: I_CASHPOOLSUBACCTASSGMT SQL: ICPLSUBASMT Type: view BASIC
20 Fields 1 Data Sources

Cash Pool Subaccount Assignment

I_CashPoolSubAcctAssgmt is a Basic CDS View that provides data about "Cash Pool Subaccount Assignment" in SAP S/4HANA. It reads from 1 data source (I_CashPoolAssgmtBasic) and exposes 20 fields with key field CashPoolAssignment.

SAP Help Documentation

CategoryCDS Views for Cash and Liquidity Management
Purpose
This CDS view provides the data of the subaccount assignments of time-dependent cash pools. Therefore, this CDS view provides the data to answer the following business questions, for example: What is the payment method of the subaccount assignment? What is the validity period of the subaccount assignment? Is the subaccount assignment marked for deletion? 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 . For more information, see also Manage Cash Pools (Version 2) .

Structure
Important Fields Important fields in this view include the following: Field Name Description Is Key Data Element CashPoolAssignment Cash Pool Assignment X FCLM_CPL_ASSGN_ID CashPoolAssignmentText Account Name (Cash Pool) FCLM_CPL_ASSGN_TEXT CashPool Cash Pool Name FCLM_CPL_NAME CashPoolAssgmtIsHeadBkAcct Assigned as Header FCLM_CPL_ASSGN_IS_HEAD_ACC CashPoolAssgmtIsDeleted Marked for Deletion FCLM_CPL_ASSGN_DELFLG CashPoolAssgmtValdtyStrtDte Valid From FCLM_CPL_ASSGN_VALID_FROM CashPoolAssgmtValdtyEndDte Valid To FCLM_CPL_ASSGN_VALID_TO BankAccountInternalID Technical ID FCLM_BAM_ACC_ID PaymentMethod Payment Method FCLM_CPL_PAYMENT_METHOD TargetBalanceAmount Target Balance FCLM_CPL_TARGET_BALANCE_AMOUNT MinTransferAmount Minimum Transfer Amount FCLM_CPL_MIN_TRANS_AMOUNT MaxTransferAmount Maximum Transfer Amount FCLM_CPL_MAX_TRANS_AMOUNT Note Reference Text FCLM_CPL_REFERENCE_TEXT CreatedByUser Created By FCLM_CPL_CREATEDBYUSERID LastChangedByUser Changed By FCLM_CPL_LASTCHANGEDBYUSERID CreationDateTime Created At FCLM_CPL_CREATIONDATETIME LocalLastChangeDateTime Changed At FCLM_CPL_LASTCHANGEDATETIME BankAccountCurrency Currency WAERS_CURC

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_CashPoolAssgmtBasic I_CashPoolAssgmtBasic from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICPLSUBASMT view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Cash Pool Subaccount Assignment view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey CashPoolAssignment view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY CashPoolAssignment CashPoolAssignment Cash Pool Assignment
CashPoolAssignmentText CashPoolAssignmentText Account Name (Cash Pool)
CashPool CashPool Cash Pool Name
CashPoolAssgmtIsHeadBkAcct CashPoolAssgmtIsHeadBkAcct Assigned as Header
CashPoolAssgmtIsDeleted CashPoolAssgmtIsDeleted Marked for Deletion
CashPoolAssgmtValdtyStrtDte CashPoolAssgmtValdtyStrtDte Valid From
CashPoolAssgmtValdtyEndDte CashPoolAssgmtValdtyEndDte Valid To
BankAccountInternalID BankAccountInternalID Technical ID
PaymentMethod PaymentMethod Pymt Meth.
TargetBalanceAmount TargetBalanceAmount
MinTransferAmount MinTransferAmount
MaxTransferAmount MaxTransferAmount
Note Note TradeRequest Comment
CreatedByUser CashPoolCreatedByUser User Name
LastChangedByUser CashPoolLastChangedByUser User Name
CreationDateTime CashPoolCreationDateTime Timestamp
LocalLastChangeDateTime CashPoolLastChangeDateTime Last Changed At
BankAccountCurrency _BankAccount BankAccountCurrency Currency
_BankAccount _BankAccount
_IsDeletedText _IsDeletedText

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_CashPoolSubAcctAssgmt.
-- 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: ICPLSUBASMT

CREATE VIEW I_CashPoolSubAcctAssgmt AS
SELECT
  CashPoolAssignment,
  CashPoolAssignmentText,
  CashPool,
  CashPoolAssgmtIsHeadBkAcct,
  CashPoolAssgmtIsDeleted,
  CashPoolAssgmtValdtyStrtDte,
  CashPoolAssgmtValdtyEndDte,
  BankAccountInternalID,
  PaymentMethod,
  TargetBalanceAmount,
  MinTransferAmount,
  MaxTransferAmount,
  Note,
  CashPoolCreatedByUser AS CreatedByUser,
  CashPoolLastChangedByUser AS LastChangedByUser,
  CashPoolCreationDateTime AS CreationDateTime,
  CashPoolLastChangeDateTime AS LocalLastChangeDateTime,
  _BankAccount.BankAccountCurrency AS BankAccountCurrency
FROM I_CashPoolAssgmtBasic
;

Learn More