C_CashPoolSubAcctAssgmtObjPgTP

DDL: C_CASHPOOLSUBACCTASSGMTOBJPGTP Type: view_entity CONSUMPTION Package: FCLM_CASHPOOLING
33 Fields 1 Data Sources 2 OData Services 1 Fiori Apps

Sub Account Assignment

C_CashPoolSubAcctAssgmtObjPgTP is a Consumption CDS View that provides data about "Sub Account Assignment" in SAP S/4HANA. It reads from 1 data source (R_CashPoolSubAcctAssgmtTP) and exposes 33 fields with key field CashPoolAssignment. It is exposed through 2 OData services (ASQL_F3266A, UI_CASHPOOL_MANAGE). It is used in 1 Fiori application: Manage Cash Pools (Version 2). Part of development package FCLM_CASHPOOLING.

Data Sources (1)

SourceAliasJoin Type
R_CashPoolSubAcctAssgmtTP R_CashPoolSubAcctAssgmtTP projection

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sub Account Assignment view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey CashPoolAssignment view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix CPS view
AbapCatalog.extensibility.quota.maximumFields 100 view
AbapCatalog.extensibility.quota.maximumBytes 100000 view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3266A ASQL_F3266A C2 NOT_RELEASED
UI_CASHPOOL_MANAGE UI_CASHPOOL_MANAGE V2 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (1)

App IDApp NameTypeDescription
F3266A Manage Cash Pools (Version 2) Transactional Manage Cash Pools (Version 2)

Manage Cash Pools (Version 2)

Business Role: Cash Manager

With this app, you can manage cash pools that have the service provider Bank - Time Dependent. The defined cash pools can be displayed in hierarchical order in the Display Cash Pool Hierarchies app. They can also be used in the Short-Term Cash Positioning app to simulate the cash pooling activities performed by banks.

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY CashPoolAssignment CashPoolAssignment Cash Pool Assignment
CashPoolAssignmentText CashPoolAssignmentText Account Name (Cash Pool)
CashPool CashPool Cash Pool Name
BankAccountNumber _BankAccount BankAccountNumber Bank Account
BankAccountCurrency BankAccountCurrency Currency
BankCountry _BankAccount BankCountry Bank Ctry/Rgn. Key
CompanyCode _BankAccount CompanyCode Receiver Company Code
CompanyCodeName
Bank _BankAccount Bank Bank Number
CompanyCodeCountry
PaymentMethod PaymentMethod Pymt Meth.
TargetBalanceAmount TargetBalanceAmount
MinTransferAmount MinTransferAmount
MaxTransferAmount MaxTransferAmount
Note Note TradeRequest Comment
CashPoolAssgmtIsHeadBkAcct CashPoolAssgmtIsHeadBkAcct Assigned as Header
CashPoolAssgmtIsDeleted CashPoolAssgmtIsDeleted Marked for Deletion
CashPoolAssgmtValdtyStrtDte CashPoolAssgmtValdtyStrtDte Valid From
CashPoolAssgmtValdtyEndDte CashPoolAssgmtValdtyEndDte Valid To
BankAccountInternalID BankAccountInternalID Technical ID
IHBBankAreaCountry _GeneralInfo IHBBankAreaCountry Bank Ctry/Rgn. Key
IHBBankKey _GeneralInfo IHBBankKey IHB Bank Key
CashPoolSrvcPrvdr _GeneralInfo CashPoolSrvcPrvdr Service Provider
CashPoolTransfDrctn _GeneralInfo CashPoolTransfDrctn Cash Pool Usage
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
int1
BankName
CountryNameasCountryNamelocalized
BankAccountContractType _BankAccount BankAccountContractType
_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 C_CashPoolSubAcctAssgmtObjPgTP.
-- 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.

CREATE VIEW C_CashPoolSubAcctAssgmtObjPgTP AS
SELECT
  CashPoolAssignment,
  CashPoolAssignmentText,
  CashPool,
  _BankAccount.BankAccountNumber AS BankAccountNumber,
  BankAccountCurrency,
  _BankAccount.BankCountry AS BankCountry,
  _BankAccount.CompanyCode AS CompanyCode,
  _BankAccount._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BankAccount.Bank AS Bank,
  _BankAccount._CompanyCode.Country AS CompanyCodeCountry,
  PaymentMethod,
  TargetBalanceAmount,
  MinTransferAmount,
  MaxTransferAmount,
  Note,
  CashPoolAssgmtIsHeadBkAcct,
  CashPoolAssgmtIsDeleted,
  CashPoolAssgmtValdtyStrtDte,
  CashPoolAssgmtValdtyEndDte,
  BankAccountInternalID,
  _GeneralInfo.IHBBankAreaCountry AS IHBBankAreaCountry,
  _GeneralInfo.IHBBankKey AS IHBBankKey,
  _GeneralInfo.CashPoolSrvcPrvdr AS CashPoolSrvcPrvdr,
  _GeneralInfo.CashPoolTransfDrctn AS CashPoolTransfDrctn,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LocalLastChangeDateTime,
  virtual CshPoolBkAcctNumberIsReadOnly : abap.int1 AS int1,
  _BankAccount._Bank.BankName AS BankName,
  _BankAccount._BankCountry._Text.CountryName as CountryName: localized AS CountryNameasCountryNamelocalized,
  _BankAccount.BankAccountContractType AS BankAccountContractType
FROM R_CashPoolSubAcctAssgmtTP
;

Learn More