I_CshConcnFltr

DDL: I_CSHCONCNFLTR SQL: ICSHCCNFLTR Type: view COMPOSITE
11 Fields 2 Data Sources

Cash Concentration with Filters

I_CshConcnFltr is a Composite CDS View (Dimension) that provides data about "Cash Concentration with Filters" in SAP S/4HANA. It reads from 2 data sources (I_CshConcnBase, I_CashPoolMgmt) and exposes 11 fields with key field CashConcentrationID.

Data Sources (2)

SourceAliasJoin Type
I_CshConcnBase base from
I_CashPoolMgmt poolData inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICSHCCNFLTR view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
EndUserText.label Cash Concentration with Filters view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.representativeKey CashConcentrationID view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CashConcentrationID I_CshConcnBase CashConcentrationID Flow ID
CashPoolName I_CshConcnBase CashPoolName Cash Pool Name
CashPoolTransfDrctn I_CashPoolMgmt CashPoolTransfDrctn Cash Pool Usage
CashPoolDesc I_CashPoolMgmt CashPoolDesc
CreationDate I_CshConcnBase CreationDate Time Stamp
CreationTime I_CshConcnBase CreationTime Time of Change
LogHandle I_CshConcnBase LogHandle LogsHandle
EffectiveExchangeRate I_CshConcnBase EffectiveExchangeRate Effective Exch. Rate
CshConcnPlnDte I_CshConcnBase CshConcnPlnDte Plan Date
SubAccountPaymentMethodIsUsed I_CshConcnBase SubAccountPaymentMethodIsUsed Use Subaccount PM
CashPoolSrvcPrvdr I_CashPoolMgmt CashPoolSrvcPrvdr Service Provider

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_CshConcnFltr.
-- 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: ICSHCCNFLTR

CREATE VIEW I_CshConcnFltr AS
SELECT
  base.CashConcentrationID AS CashConcentrationID,
  base.CashPoolName AS CashPoolName,
  poolData.CashPoolTransfDrctn AS CashPoolTransfDrctn,
  poolData.CashPoolDesc AS CashPoolDesc,
  base.CreationDate AS CreationDate,
  base.CreationTime AS CreationTime,
  base.LogHandle AS LogHandle,
  base.EffectiveExchangeRate AS EffectiveExchangeRate,
  base.CshConcnPlnDte AS CshConcnPlnDte,
  base.SubAccountPaymentMethodIsUsed AS SubAccountPaymentMethodIsUsed,
  poolData.CashPoolSrvcPrvdr AS CashPoolSrvcPrvdr
FROM I_CshConcnBase AS base
INNER JOIN I_CashPoolMgmt AS poolData ON /* join condition not captured in parsed metadata */
;

Learn More