C_BankAccCashPoolTP

DDL: C_BANKACCCASHPOOLTP Type: view CONSUMPTION
12 Fields 1 Associations

Bank Account Cash Pool

C_BankAccCashPoolTP is a Consumption CDS View that provides data about "Bank Account Cash Pool" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_BankAccountTP _Account $projection.BankAccountInternalID = _Account.BankAccountInternalID and $projection.BankAccountRevision = _Account.BankAccountRevision

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CBANKACCCPTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Bank Account Cash Pool view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
AccessControl.personalData.blocking #NOT_REQUIRED view
UI.headerInfo.typeName Cash Pool view
UI.headerInfo.typeNamePlural Cash Pool view
UI.headerInfo.title.value HouseBankAccount view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY BankAccountInternalID BankAccountInternalID Technical ID
KEY BankAccountRevision BankAccountRevision
KEY CashPool CashPool Cash Pool Name
CashPoolName CashPoolName
AccountGroupName AccountGroupName
_Account _Account
CompanyCode _Account CompanyCode Receiver Company Code
BankAccountType _Account BankAccountType Account Type
BusinessArea _Account BusinessArea Business Area
Segment _Account Segment Segment number
ControllingArea _Account ControllingArea Controlling Area
ProfitCenter _Account ProfitCenter Profit Center

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_BankAccCashPoolTP.
-- 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_BankAccCashPoolTP AS
SELECT
  BankAccountInternalID,
  BankAccountRevision,
  CashPool,
  CashPoolName,
  AccountGroupName,
  _Account.CompanyCode AS CompanyCode,
  _Account.BankAccountType AS BankAccountType,
  _Account.BusinessArea AS BusinessArea,
  _Account.Segment AS Segment,
  _Account.ControllingArea AS ControllingArea,
  _Account.ProfitCenter AS ProfitCenter
LEFT OUTER JOIN C_BankAccountTP AS _Account ON BankAccountInternalID = _Account.BankAccountInternalID AND BankAccountRevision = _Account.BankAccountRevision  -- association [1..1]
;

Learn More