I_CashPoolVH

DDL: I_CASHPOOLVH SQL: ICASHPOOLVH Type: view BASIC
7 Fields 1 Data Sources 2 Associations

Cash pool value help

I_CashPoolVH is a Basic CDS View that provides data about "Cash pool value help" in SAP S/4HANA. It reads from 1 data source (I_CashPoolMgmt) and exposes 7 fields with key field CashPoolName. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CashPoolMgmt vh from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CashPoolIsDeletedText _IsDeletedText $projection.CashPoolIsDeleted = _IsDeletedText.CashPoolIsDeleted
[0..*] I_CashPoolSrvcPrvdrText _SrvcPrvdrText $projection.CashPoolSrvcPrvdr = _SrvcPrvdrText.CashPoolSrvcPrvdr

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICASHPOOLVH view
EndUserText.label Cash pool value help view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
Search.searchable true view
Consumption.ranked true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CashPoolName I_CashPoolMgmt CashPoolName
CashPoolDesc I_CashPoolMgmt CashPoolDesc
CashPoolTransfDrctnText I_CashPoolMgmt CashPoolTransfDrctnText
CashPoolIsDeleted I_CashPoolMgmt CashPoolIsDeleted Marked for Deletion
CashPoolIsDeletedText _IsDeletedText CashPoolIsDeletedText
CashPoolSrvcPrvdr I_CashPoolMgmt CashPoolSrvcPrvdr Service Provider
CashPoolSrvcPrvdrText

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_CashPoolVH.
-- 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: ICASHPOOLVH

CREATE VIEW I_CashPoolVH AS
SELECT
  vh.CashPoolName AS CashPoolName,
  vh.CashPoolDesc AS CashPoolDesc,
  vh.CashPoolTransfDrctnText AS CashPoolTransfDrctnText,
  vh.CashPoolIsDeleted AS CashPoolIsDeleted,
  _IsDeletedText.CashPoolIsDeletedText AS CashPoolIsDeletedText,
  vh.CashPoolSrvcPrvdr AS CashPoolSrvcPrvdr,
  _SrvcPrvdrText[1:Language = $session.system_language].CashPoolSrvcPrvdrText AS CashPoolSrvcPrvdrText
FROM I_CashPoolMgmt AS vh
LEFT OUTER JOIN I_CashPoolIsDeletedText AS _IsDeletedText ON CashPoolIsDeleted = _IsDeletedText.CashPoolIsDeleted  -- association [0..1]
LEFT OUTER JOIN I_CashPoolSrvcPrvdrText AS _SrvcPrvdrText ON CashPoolSrvcPrvdr = _SrvcPrvdrText.CashPoolSrvcPrvdr  -- association [0..*]
;

Learn More