C_CashPositionProfile

DDL: C_CASHPOSITIONPROFILE Type: view_entity CONSUMPTION
32 Fields 1 Data Sources

Cash Position Profile

C_CashPositionProfile is a Consumption CDS View that provides data about "Cash Position Profile" in SAP S/4HANA. It reads from 1 data source (I_CashPositionProfile) and exposes 32 fields with key field CashPositionProfile.

Data Sources (1)

SourceAliasJoin Type
I_CashPositionProfile profile from

Annotations (14)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Cash Position Profile view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Search.searchable true view
UI.headerInfo.typeName Cash Position Profile view
UI.headerInfo.typeNamePlural Cash Position Profiles view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value CashPositionProfileDescription view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value CashPositionProfile view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CashPositionProfile CashPositionProfile Setup Mat. Prof.
CashPositionProfileDescription CashPositionProfileDescription Description
CashPositionHierSource CashPositionHierSource Hierarchy Src.
CashPositionRootNodeIsNeeded CashPositionRootNodeIsNeeded Enable Root Node
CashPositionRootNode CashPositionRootNode Root Node Name
CshPosKeyDteInThePastIsAllowed CshPosKeyDteInThePastIsAllowed
CashPositionHierLevel1 CashPositionHierLevel1 Hier. Level 1
CashPositionHierLevel2 CashPositionHierLevel2 Hier. Level 2
CashPositionHierLevel3 CashPositionHierLevel3 Hier. Level 3
BankAccountHierarchyName BankAccountHierarchyName Hierarchy ID
CashBalanceType CashBalanceType Balance Type
CashPositionBalanceCategory CashPositionBalanceCategory Balance Category
CashPositionViewCategory CashPositionViewCategory View Category
CashPositionOvrdIsIncldInClsg CashPositionOvrdIsIncldInClsg Incl. Overdue
CashPositionSmartCrcyIsEnabled CashPositionSmartCrcyIsEnabled Enable Smart Curr
DisplayCurrency DisplayCurrency Display Currency
EmbeddedCshPosDetViewIsVisible EmbeddedCshPosDetViewIsVisible Display Pos. Details
ExchangeRateType ExchangeRateType Exch. Rate Type
IntradayRecnclnRsltIsConsdrd IntradayRecnclnRsltIsConsdrd Consider Intraday Recon. Result
CashPositionPrdfndInterimStep CashPositionPrdfndInterimStep Period Unit
CashPositionPrdfndIncrement CashPositionPrdfndIncrement Increment
CashPositionPeriodEndIsNatural CashPositionPeriodEndIsNatural Time Stamp
CashPositionOverdueIsVisible CashPositionOverdueIsVisible Show Overdue
CashPositionFutureIsVisible CashPositionFutureIsVisible Show Future
CashPositionShiftOption CashPositionShiftOption Shift Option
FactoryCalendar FactoryCalendar Factory Calendar
UICT_HierLevelIsHidden
UICT_HierNameIsHidden
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp

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_CashPositionProfile.
-- 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.

CREATE VIEW C_CashPositionProfile AS
SELECT
  CashPositionProfile,
  CashPositionProfileDescription,
  CashPositionHierSource,
  CashPositionRootNodeIsNeeded,
  CashPositionRootNode,
  CshPosKeyDteInThePastIsAllowed,
  CashPositionHierLevel1,
  CashPositionHierLevel2,
  CashPositionHierLevel3,
  BankAccountHierarchyName,
  CashBalanceType,
  CashPositionBalanceCategory,
  CashPositionViewCategory,
  CashPositionOvrdIsIncldInClsg,
  CashPositionSmartCrcyIsEnabled,
  DisplayCurrency,
  EmbeddedCshPosDetViewIsVisible,
  ExchangeRateType,
  IntradayRecnclnRsltIsConsdrd,
  CashPositionPrdfndInterimStep,
  CashPositionPrdfndIncrement,
  CashPositionPeriodEndIsNatural,
  CashPositionOverdueIsVisible,
  CashPositionFutureIsVisible,
  CashPositionShiftOption,
  FactoryCalendar,
  case when CashPositionHierSource = '02' then 'X' else '' end AS UICT_HierLevelIsHidden,
  case when CashPositionHierSource <> '02' then 'X' else '' end AS UICT_HierNameIsHidden,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_CashPositionProfile AS profile
;

Learn More