I_CshConcnFltr

DDL: I_CSHCONCNFLTR SQL: ICSHCCNFLTR Type: view COMPOSITE Package: FCLM_CASHPOOLING
12 Fields 1 Data Sources 2 Associations

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 1 data source (I_CshConcnBase) and exposes 12 fields with key field CashConcentrationID. It has 2 associations to related views. Part of development package FCLM_CASHPOOLING.

Data Sources (1)

SourceAliasJoin Type
I_CshConcnBase base from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CshConcnWithCshConcnStatus ConCnStatus $projection.CashConcentrationID = ConCnStatus.CashConcentrationID
[0..*] I_CashPoolMDDesc _CashPoolNameText $projection.CashPoolName = _CashPoolNameText.CashPoolName

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 (12)

KeyFieldSource TableSource FieldDescription
KEY CashConcentrationID I_CshConcnBase CashConcentrationID Flow ID
CashPoolName I_CshConcnBase CashPoolName Cash Pool Name
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
CashConcentrationGroup I_CshConcnBase CashConcentrationGroup
CashPoolTransfDrctn I_CshConcnBase CashPoolTransfDrctn Cash Pool Usage
CashPoolSrvcPrvdr I_CshConcnBase CashPoolSrvcPrvdr Service Provider
_CashPoolNameText _CashPoolNameText

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,
  base.CreationDate AS CreationDate,
  base.CreationTime AS CreationTime,
  base.LogHandle AS LogHandle,
  base.EffectiveExchangeRate AS EffectiveExchangeRate,
  base.CshConcnPlnDte AS CshConcnPlnDte,
  base.SubAccountPaymentMethodIsUsed AS SubAccountPaymentMethodIsUsed,
  base.CashConcentrationGroup AS CashConcentrationGroup,
  base.CashPoolTransfDrctn AS CashPoolTransfDrctn,
  base.CashPoolSrvcPrvdr AS CashPoolSrvcPrvdr
FROM I_CshConcnBase AS base
LEFT OUTER JOIN I_CshConcnWithCshConcnStatus AS ConCnStatus ON CashConcentrationID = ConCnStatus.CashConcentrationID  -- association [0..1]
LEFT OUTER JOIN I_CashPoolMDDesc AS _CashPoolNameText ON CashPoolName = _CashPoolNameText.CashPoolName  -- association [0..*]
;

Learn More