I_CashPoolMgmt

DDL: I_CASHPOOLMGMT SQL: ICPLMGMT Type: view BASIC
11 Fields 1 Data Sources 2 Associations

Manage Cash Pools

I_CashPoolMgmt is a Basic CDS View (Dimension) that provides data about "Manage Cash Pools" in SAP S/4HANA. It reads from 1 data source (I_CashPoolMD) and exposes 11 fields with key field CashPoolName. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CashPoolMD md from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CashPoolMDDesc desc $projection.CashPoolName = desc.CashPoolName
[0..1] I_CashPoolTransfDrctnText _DrctnText $projection.CashPoolTransfDrctn = _DrctnText.CashPoolTransfDrctn

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICPLMGMT view
AbapCatalog.compiler.compareFilter true view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Manage Cash Pools view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.representativeKey CashPoolName view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY CashPoolName I_CashPoolMD CashPoolName Cash Pool Name
CashPoolIsDeleted I_CashPoolMD CashPoolIsDeleted Marked for Deletion
CashPoolType I_CashPoolMD CashPoolType Cash Pool Type
CashPoolTransfDrctn I_CashPoolMD CashPoolTransfDrctn Cash Pool Usage
CashPoolSrvcPrvdr I_CashPoolMD CashPoolSrvcPrvdr Service Provider
CashPoolBalCalcPrfl I_CashPoolMD CashPoolBalCalcPrfl Profile Name
CashPoolDesc desc CashPoolDesc
CashPoolRefTxt desc CashPoolRefTxt
CashPoolTransfDrctnText _DrctnText CashPoolTransfDrctnText
PlanningLevel I_CashPoolMD PlanningLevel Planning Level
BankManagedCashPoolAuthGrp I_CashPoolMD BankManagedCashPoolAuthGrp Authorization Group

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_CashPoolMgmt.
-- 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: ICPLMGMT

CREATE VIEW I_CashPoolMgmt AS
SELECT
  md.CashPoolName AS CashPoolName,
  md.CashPoolIsDeleted AS CashPoolIsDeleted,
  md.CashPoolType AS CashPoolType,
  md.CashPoolTransfDrctn AS CashPoolTransfDrctn,
  md.CashPoolSrvcPrvdr AS CashPoolSrvcPrvdr,
  md.CashPoolBalCalcPrfl AS CashPoolBalCalcPrfl,
  desc.CashPoolDesc AS CashPoolDesc,
  desc.CashPoolRefTxt AS CashPoolRefTxt,
  _DrctnText.CashPoolTransfDrctnText AS CashPoolTransfDrctnText,
  md.PlanningLevel AS PlanningLevel,
  md.BankManagedCashPoolAuthGrp AS BankManagedCashPoolAuthGrp
FROM I_CashPoolMD AS md
LEFT OUTER JOIN I_CashPoolMDDesc AS desc ON CashPoolName = desc.CashPoolName  -- association [0..1]
LEFT OUTER JOIN I_CashPoolTransfDrctnText AS _DrctnText ON CashPoolTransfDrctn = _DrctnText.CashPoolTransfDrctn  -- association [0..1]
;

Learn More