R_CashPoolSubAcctAssgmtTP

DDL: R_CASHPOOLSUBACCTASSGMTTP Type: view_entity TRANSACTIONAL
21 Fields 1 Data Sources

Cash Pool Subaccount Assignment - TP

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

Data Sources (1)

SourceAliasJoin Type
I_CashPoolSubAcctAssgmt I_CashPoolSubAcctAssgmt from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Cash Pool Subaccount Assignment - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (21)

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
BankAccountCurrency BankAccountCurrency Currency
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDateTime CreationDateTime Timestamp
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
_GeneralInfo _GeneralInfo
_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 R_CashPoolSubAcctAssgmtTP.
-- 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 R_CashPoolSubAcctAssgmtTP AS
SELECT
  CashPoolAssignment,
  CashPoolAssignmentText,
  CashPool,
  CashPoolAssgmtIsHeadBkAcct,
  CashPoolAssgmtIsDeleted,
  CashPoolAssgmtValdtyStrtDte,
  CashPoolAssgmtValdtyEndDte,
  BankAccountInternalID,
  PaymentMethod,
  TargetBalanceAmount,
  MinTransferAmount,
  MaxTransferAmount,
  Note,
  BankAccountCurrency,
  CreatedByUser,
  LastChangedByUser,
  CreationDateTime,
  LocalLastChangeDateTime
FROM I_CashPoolSubAcctAssgmt
;

Learn More