What is C_CashPositionProfileWithCycle in SAP S/4HANA?

C_CashPositionProfileWithCycle is a consumption CDS view in SAP S/4HANA. Cash Position Profile With Cycle Info It contains 98 fields.

Which tables does C_CashPositionProfileWithCycle read from?

C_CashPositionProfileWithCycle reads data from: I_CalendarDate, I_CashPositionProfile.

What VDM layer is C_CashPositionProfileWithCycle?

C_CashPositionProfileWithCycle is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CashPositionProfileWithCycle

DDL: C_CASHPOSITIONPROFILEWITHCYCLE Type: view_entity CONSUMPTION

98 Fields 2 Data Sources 1 Associations

Cash Position Profile With Cycle Info

C_CashPositionProfileWithCycle is a Consumption CDS View that provides data about "Cash Position Profile With Cycle Info" in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, I_CashPositionProfile) and exposes 98 fields with key fields CashPositionProfile, KeyDate. It has 1 association to related views.

Data Sources (2)

Source	Alias	Join Type
I_CalendarDate	_Date	cross
I_CashPositionProfile	profile	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_CalendarDate	_CalendarDate	`$projection.KeyDate = _CalendarDate.CalendarDate`

Annotations (14)

Name	Value	Level
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Cash Position Profile With Cycle Info	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
UI.headerInfo.typeName	Cash Position Profile	view
UI.headerInfo.typeNamePlural	Cash Position Profiles	view
UI.headerInfo.title.type	#STANDARD	view
UI.headerInfo.title.value	CashPositionProfile	view
UI.headerInfo.description.type	#STANDARD	view
UI.headerInfo.description.value	CashPositionProfileDescription	view
ObjectModel.representativeKey	CashPositionProfile	view
VDM.viewType	#CONSUMPTION	view

Fields (98)

Key	Field	Source Table	Source Field	Description
KEY	CashPositionProfile	I_CashPositionProfile	CashPositionProfile	Setup Mat. Prof.
KEY	KeyDate	I_CalendarDate	CalendarDate	Calendar Date
	CashPositionProfileDescription	I_CashPositionProfile	CashPositionProfileDescription	Description
	CashPositionHierSource	I_CashPositionProfile	CashPositionHierSource	Hierarchy Src.
	CashPositionViewCategory	I_CashPositionProfile	CashPositionViewCategory	View Category
	CashBalanceType	I_CashPositionProfile	CashBalanceType	Balance Type
	CashPositionBalanceCategory	I_CashPositionProfile	CashPositionBalanceCategory	Balance Category
	CashPositionSmartCrcyIsEnabled	I_CashPositionProfile	CashPositionSmartCrcyIsEnabled	Enable Smart Curr
	DisplayCurrency	I_CashPositionProfile	DisplayCurrency	Display Currency
	ExchangeRateType	I_CashPositionProfile	ExchangeRateType	Exch. Rate Type
	IntradayRecnclnRsltIsConsdrd	I_CashPositionProfile	IntradayRecnclnRsltIsConsdrd	Consider Intraday Recon. Result
	CashPositionPrdfndIncrement	I_CashPositionProfile	CashPositionPrdfndIncrement	Increment
	CashPositionPrdfndInterimStep	I_CashPositionProfile	CashPositionPrdfndInterimStep	Period Unit
	CashPositionPeriodEndIsNatural	I_CashPositionProfile	CashPositionPeriodEndIsNatural	Time Stamp
	CashPositionOverdueIsVisible	I_CashPositionProfile	CashPositionOverdueIsVisible	Show Overdue
	CashPositionOvrdIsIncldInClsg	I_CashPositionProfile	CashPositionOvrdIsIncldInClsg	Incl. Overdue
	CashPositionFutureIsVisible	I_CashPositionProfile	CashPositionFutureIsVisible	Show Future
	CashPositionShiftOption	I_CashPositionProfile	CashPositionShiftOption	Shift Option
	FactoryCalendar	I_CashPositionProfile	FactoryCalendar	Factory Calendar
	EmbeddedCshPosDetViewIsVisible	I_CashPositionProfile	EmbeddedCshPosDetViewIsVisible	Display Pos. Details
	ConsdrIntradayRecnclnIsHidden	I_CashPositionProfile	ConsdrIntradayRecnclnIsHidden
	CashPositionFromDate
	CashPositionToDate
	CashPositionDisplayFutrFrmDate
	CashPositionDisplayOvrdFrmDate
	CashPositionDisplay1FromDate
	CashPositionDisplay2FromDate
	CashPositionDisplay3FromDate
	CashPositionDisplay4FromDate
	CashPositionDisplay5FromDate
	CashPositionDisplay6FromDate
	CashPositionDisplay7FromDate
	CashPositionDisplay8FromDate
	CashPositionDisplay9FromDate
	CashPositionDisplay10FromDate
	CashPositionDisplay11FromDate
	CashPositionDisplay12FromDate
	CashPositionDisplay13FromDate
	CashPositionDisplay14FromDate
	CashPositionDisplay15FromDate
	CashPositionDisplay16FromDate
	CashPositionDisplay17FromDate
	CashPositionDisplay18FromDate
	CashPositionDisplay19FromDate
	CashPositionDisplay20FromDate
	CashPositionDisplay21FromDate
	CashPositionDisplay22FromDate
	CashPositionDisplay23FromDate
	CashPositionDisplay24FromDate
	CashPositionDisplay25FromDate
	CashPositionDisplay26FromDate
	CashPositionDisplay27FromDate
	CashPositionDisplay28FromDate
	CashPositionDisplay29FromDate
	CashPositionDisplay30FromDate
	CashPositionDisplay31FromDate
	CashPositionDisplayOvrdToDate
	CashPositionDisplayFutrToDate
	CashPositionDisplay1ToDate
	CashPositionDisplay2ToDate
	CashPositionDisplay3ToDate
	CashPositionDisplay4ToDate
	CashPositionDisplay5ToDate
	CashPositionDisplay6ToDate
	CashPositionDisplay7ToDate
	CashPositionDisplay8ToDate
	CashPositionDisplay9ToDate
	CashPositionDisplay10ToDate
	CashPositionDisplay11ToDate
	CashPositionDisplay12ToDate
	CashPositionDisplay13ToDate
	CashPositionDisplay14ToDate
	CashPositionDisplay15ToDate
	CashPositionDisplay16ToDate
	CashPositionDisplay17ToDate
	CashPositionDisplay18ToDate
	CashPositionDisplay19ToDate
	CashPositionDisplay20ToDate
	CashPositionDisplay21ToDate
	CashPositionDisplay22ToDate
	CashPositionDisplay23ToDate
	CashPositionDisplay24ToDate
	CashPositionDisplay25ToDate
	CashPositionDisplay26ToDate
	CashPositionDisplay27ToDate
	CashPositionDisplay28ToDate
	CashPositionDisplay29ToDate
	CashPositionDisplay30ToDate
	CashPositionDisplay31ToDate
	_Currency	I_CashPositionProfile	_Currency
	_BankFeeExchRateTypeVH	I_CashPositionProfile	_BankFeeExchRateTypeVH
	_FactoryCalendarText	I_CashPositionProfile	_FactoryCalendarText
	_CshPosShiftOptionText	I_CashPositionProfile	_CshPosShiftOptionText
	_CshPosUnitText	I_CashPositionProfile	_CshPosUnitText
	_CshPosBalTypeText	I_CashPositionProfile	_CshPosBalTypeText
	_CshPosViewTypeText	I_CashPositionProfile	_CshPosViewTypeText
	_CashBalanceTypeText	I_CashPositionProfile	_CashBalanceTypeText
	_CalendarDate		_CalendarDate

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_CashPositionProfileWithCycle.
-- 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_CashPositionProfileWithCycle AS
SELECT
  profile.CashPositionProfile AS CashPositionProfile,
  _Date.CalendarDate AS KeyDate,
  profile.CashPositionProfileDescription AS CashPositionProfileDescription,
  profile.CashPositionHierSource AS CashPositionHierSource,
  profile.CashPositionViewCategory AS CashPositionViewCategory,
  profile.CashBalanceType AS CashBalanceType,
  profile.CashPositionBalanceCategory AS CashPositionBalanceCategory,
  profile.CashPositionSmartCrcyIsEnabled AS CashPositionSmartCrcyIsEnabled,
  profile.DisplayCurrency AS DisplayCurrency,
  profile.ExchangeRateType AS ExchangeRateType,
  profile.IntradayRecnclnRsltIsConsdrd AS IntradayRecnclnRsltIsConsdrd,
  profile.CashPositionPrdfndIncrement AS CashPositionPrdfndIncrement,
  profile.CashPositionPrdfndInterimStep AS CashPositionPrdfndInterimStep,
  profile.CashPositionPeriodEndIsNatural AS CashPositionPeriodEndIsNatural,
  profile.CashPositionOverdueIsVisible AS CashPositionOverdueIsVisible,
  profile.CashPositionOvrdIsIncldInClsg AS CashPositionOvrdIsIncldInClsg,
  profile.CashPositionFutureIsVisible AS CashPositionFutureIsVisible,
  profile.CashPositionShiftOption AS CashPositionShiftOption,
  profile.FactoryCalendar AS FactoryCalendar,
  profile.EmbeddedCshPosDetViewIsVisible AS EmbeddedCshPosDetViewIsVisible,
  profile.ConsdrIntradayRecnclnIsHidden AS ConsdrIntradayRecnclnIsHidden,
  cast('00000000' as datum) AS CashPositionFromDate,
  cast('00000000' as datum) AS CashPositionToDate,
  cast('00000000' as datum) AS CashPositionDisplayFutrFrmDate,
  cast('00000000' as datum) AS CashPositionDisplayOvrdFrmDate,
  cast('00000000' as datum) AS CashPositionDisplay1FromDate,
  cast('00000000' as datum) AS CashPositionDisplay2FromDate,
  cast('00000000' as datum) AS CashPositionDisplay3FromDate,
  cast('00000000' as datum) AS CashPositionDisplay4FromDate,
  cast('00000000' as datum) AS CashPositionDisplay5FromDate,
  cast('00000000' as datum) AS CashPositionDisplay6FromDate,
  cast('00000000' as datum) AS CashPositionDisplay7FromDate,
  cast('00000000' as datum) AS CashPositionDisplay8FromDate,
  cast('00000000' as datum) AS CashPositionDisplay9FromDate,
  cast('00000000' as datum) AS CashPositionDisplay10FromDate,
  cast('00000000' as datum) AS CashPositionDisplay11FromDate,
  cast('00000000' as datum) AS CashPositionDisplay12FromDate,
  cast('00000000' as datum) AS CashPositionDisplay13FromDate,
  cast('00000000' as datum) AS CashPositionDisplay14FromDate,
  cast('00000000' as datum) AS CashPositionDisplay15FromDate,
  cast('00000000' as datum) AS CashPositionDisplay16FromDate,
  cast('00000000' as datum) AS CashPositionDisplay17FromDate,
  cast('00000000' as datum) AS CashPositionDisplay18FromDate,
  cast('00000000' as datum) AS CashPositionDisplay19FromDate,
  cast('00000000' as datum) AS CashPositionDisplay20FromDate,
  cast('00000000' as datum) AS CashPositionDisplay21FromDate,
  cast('00000000' as datum) AS CashPositionDisplay22FromDate,
  cast('00000000' as datum) AS CashPositionDisplay23FromDate,
  cast('00000000' as datum) AS CashPositionDisplay24FromDate,
  cast('00000000' as datum) AS CashPositionDisplay25FromDate,
  cast('00000000' as datum) AS CashPositionDisplay26FromDate,
  cast('00000000' as datum) AS CashPositionDisplay27FromDate,
  cast('00000000' as datum) AS CashPositionDisplay28FromDate,
  cast('00000000' as datum) AS CashPositionDisplay29FromDate,
  cast('00000000' as datum) AS CashPositionDisplay30FromDate,
  cast('00000000' as datum) AS CashPositionDisplay31FromDate,
  cast('00000000' as datum) AS CashPositionDisplayOvrdToDate,
  cast('00000000' as datum) AS CashPositionDisplayFutrToDate,
  cast('00000000' as datum) AS CashPositionDisplay1ToDate,
  cast('00000000' as datum) AS CashPositionDisplay2ToDate,
  cast('00000000' as datum) AS CashPositionDisplay3ToDate,
  cast('00000000' as datum) AS CashPositionDisplay4ToDate,
  cast('00000000' as datum) AS CashPositionDisplay5ToDate,
  cast('00000000' as datum) AS CashPositionDisplay6ToDate,
  cast('00000000' as datum) AS CashPositionDisplay7ToDate,
  cast('00000000' as datum) AS CashPositionDisplay8ToDate,
  cast('00000000' as datum) AS CashPositionDisplay9ToDate,
  cast('00000000' as datum) AS CashPositionDisplay10ToDate,
  cast('00000000' as datum) AS CashPositionDisplay11ToDate,
  cast('00000000' as datum) AS CashPositionDisplay12ToDate,
  cast('00000000' as datum) AS CashPositionDisplay13ToDate,
  cast('00000000' as datum) AS CashPositionDisplay14ToDate,
  cast('00000000' as datum) AS CashPositionDisplay15ToDate,
  cast('00000000' as datum) AS CashPositionDisplay16ToDate,
  cast('00000000' as datum) AS CashPositionDisplay17ToDate,
  cast('00000000' as datum) AS CashPositionDisplay18ToDate,
  cast('00000000' as datum) AS CashPositionDisplay19ToDate,
  cast('00000000' as datum) AS CashPositionDisplay20ToDate,
  cast('00000000' as datum) AS CashPositionDisplay21ToDate,
  cast('00000000' as datum) AS CashPositionDisplay22ToDate,
  cast('00000000' as datum) AS CashPositionDisplay23ToDate,
  cast('00000000' as datum) AS CashPositionDisplay24ToDate,
  cast('00000000' as datum) AS CashPositionDisplay25ToDate,
  cast('00000000' as datum) AS CashPositionDisplay26ToDate,
  cast('00000000' as datum) AS CashPositionDisplay27ToDate,
  cast('00000000' as datum) AS CashPositionDisplay28ToDate,
  cast('00000000' as datum) AS CashPositionDisplay29ToDate,
  cast('00000000' as datum) AS CashPositionDisplay30ToDate,
  cast('00000000' as datum) AS CashPositionDisplay31ToDate,
  profile._Currency AS _Currency,
  profile._BankFeeExchRateTypeVH AS _BankFeeExchRateTypeVH,
  profile._FactoryCalendarText AS _FactoryCalendarText,
  profile._CshPosShiftOptionText AS _CshPosShiftOptionText,
  profile._CshPosUnitText AS _CshPosUnitText,
  profile._CshPosBalTypeText AS _CshPosBalTypeText,
  profile._CshPosViewTypeText AS _CshPosViewTypeText,
  profile._CashBalanceTypeText AS _CashBalanceTypeText
FROM I_CashPositionProfile AS profile
CROSS JOIN I_CalendarDate AS _Date
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON KeyDate = _CalendarDate.CalendarDate  -- association [1..1]
;

Depth:

C_CashPositionProfileWithCycle view_entity

I_CalendarDate view
I_CashPositionProfile view_entity