I_CashPositionProfileTP

DDL: I_CASHPOSITIONPROFILETP Type: view_entity

I_CashPositionProfileTP is a CDS View in SAP S/4HANA. It reads from 1 data source (I_CashPositionProfile) and exposes 35 fields with key field CashPositionProfile.

Data Sources (1)

SourceAliasJoin Type
I_CashPositionProfile Main from

Annotations (1)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CashPositionProfile CashPositionProfile Setup Mat. Prof.
CashPositionProfileDescription CashPositionProfileDescription Description
CashPositionHierSource CashPositionHierSource Hierarchy Src.
CashPositionHierLevel1 CashPositionHierLevel1 Hier. Level 1
CashPositionHierLevel2 CashPositionHierLevel2 Hier. Level 2
CashPositionHierLevel3 CashPositionHierLevel3 Hier. Level 3
BankAccountHierarchyName BankAccountHierarchyName Hierarchy ID
CashPositionBalanceCategory CashPositionBalanceCategory Balance Category
CashPositionViewCategory CashPositionViewCategory View Category
CashPositionPrdfndIncrement CashPositionPrdfndIncrement Increment
CashPositionPrdfndInterimStep CashPositionPrdfndInterimStep Period Unit
CashPositionPeriodEndIsNatural CashPositionPeriodEndIsNatural Time Stamp
CashPositionOverdueIsVisible CashPositionOverdueIsVisible Show Overdue
CashPositionOvrdIsIncldInClsg CashPositionOvrdIsIncldInClsg Incl. Overdue
CashPositionShiftOption CashPositionShiftOption Shift Option
FactoryCalendar FactoryCalendar Factory Calendar
DisplayCurrency DisplayCurrency Display Currency
ExchangeRateType ExchangeRateType Exch. Rate Type
CshPosSclngOfPreDcmlPlaces CshPosSclngOfPreDcmlPlaces Scaling Factor (Deprecated)
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_Currency _Currency
_BankFeeExchRateTypeVH _BankFeeExchRateTypeVH
_CshPosHierSourceText _CshPosHierSourceText
_CshPosHierText _CshPosHierText
_CshPosHierTwoText _CshPosHierTwoText
_CshPosHierThreeText _CshPosHierThreeText
_FactoryCalendarText _FactoryCalendarText
_CshPosShiftOptionText _CshPosShiftOptionText
_CshPosUnitText _CshPosUnitText
_CshPosBalTypeText _CshPosBalTypeText
_CshPosViewTypeText _CshPosViewTypeText
_CshPosSclngPreDcmlPlacesText _CshPosSclngPreDcmlPlacesText

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_CashPositionProfileTP.
-- 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 I_CashPositionProfileTP AS
SELECT
  CashPositionProfile,
  CashPositionProfileDescription,
  CashPositionHierSource,
  CashPositionHierLevel1,
  CashPositionHierLevel2,
  CashPositionHierLevel3,
  BankAccountHierarchyName,
  CashPositionBalanceCategory,
  CashPositionViewCategory,
  CashPositionPrdfndIncrement,
  CashPositionPrdfndInterimStep,
  CashPositionPeriodEndIsNatural,
  CashPositionOverdueIsVisible,
  CashPositionOvrdIsIncldInClsg,
  CashPositionShiftOption,
  FactoryCalendar,
  DisplayCurrency,
  ExchangeRateType,
  CshPosSclngOfPreDcmlPlaces,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_CashPositionProfile AS Main
;