C_CashPoolTransReport

DDL: C_CASHPOOLTRANSREPORT SQL: CPLTRANSREPORT Type: view CONSUMPTION Package: FCLM_CASHPOOLING
23 Fields 1 Data Sources

Cash Pool Transfer Report

C_CashPoolTransReport is a Consumption CDS View that provides data about "Cash Pool Transfer Report" in SAP S/4HANA. It reads from 1 data source (I_CashPoolTransReport) and exposes 23 fields with key field CashConcentrationID. Part of development package FCLM_CASHPOOLING.

Data Sources (1)

SourceAliasJoin Type
I_CashPoolTransReport I_CashPoolTransReport from

Parameters (2)

NameTypeDefault
P_StartDate vdm_v_validity_start_date
P_EndDate vdm_v_validity_end_date

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPLTRANSREPORT view
EndUserText.label Cash Pool Transfer Report view
Analytics.query true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY CashConcentrationID CashConcentrationID
CashPoolName CashPoolName Cash Pool Name
Currency Currency Currency
PayeeBankAccount PayeeBankAccount Header Account Number
PayingBankAccount PayingBankAccount Subaccount Number
CompanyCode CompanyCode Company Code of Subaccount
TransfAmtInBkAcctCrcy TransfAmtInBkAcctCrcy Transfer Amount
ValueDate ValueDate Transfer Date
PayeeBankCountry PayeeBankCountry Bank Country/Region of Header Account
BankCountry BankCountry Bank Country/Region of Subaccount
PayeeBank PayeeBank Bank Key of Header Account
Bank Bank Bank Key of Subaccount
PayeeCompanyCode PayeeCompanyCode Company Code of Header Account
PayeeHouseBank PayeeHouseBank House Bank of Header Account
HouseBank HouseBank House Bank of Subaccount
PayeeHouseBankAccount PayeeHouseBankAccount House Bank Account of Header Account
HouseBankAccount HouseBankAccount House Bank Account of Subaccount
PayeeBankAccountDescription PayeeBankAccountDescription Bank Account Desc. of Header Account
PayingBankAccountDescription PayingBankAccountDescription Bank Account Description of Subaccount
PayeeBankAccountInternalID PayeeBankAccountInternalID Bank Account Tech. ID of Header Account
PayingBankAccountInternalID PayingBankAccountInternalID Bank Account Technical ID of Subaccount
CertaintyLevel CertaintyLevel Certainty Level
BankAccountNumber BankAccountNumber Bank Account Number

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_CashPoolTransReport.
-- 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: CPLTRANSREPORT
-- Parameters: P_StartDate : vdm_v_validity_start_date, P_EndDate : vdm_v_validity_end_date

CREATE VIEW C_CashPoolTransReport AS
SELECT
  CashConcentrationID,
  CashPoolName,
  Currency,
  PayeeBankAccount,
  PayingBankAccount,
  CompanyCode,
  TransfAmtInBkAcctCrcy,
  ValueDate,
  PayeeBankCountry,
  BankCountry,
  PayeeBank,
  Bank,
  PayeeCompanyCode,
  PayeeHouseBank,
  HouseBank,
  PayeeHouseBankAccount,
  HouseBankAccount,
  PayeeBankAccountDescription,
  PayingBankAccountDescription,
  PayeeBankAccountInternalID,
  PayingBankAccountInternalID,
  CertaintyLevel,
  BankAccountNumber
FROM I_CashPoolTransReport
;

Learn More