C_CashPositionProfileTP

DDL: C_CASHPOSITIONPROFILETP Type: view_entity
47 Fields 1 Data Sources

Cash Position Profile

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

Data Sources (1)

SourceAliasJoin Type
I_CashPositionProfileTP I_CashPositionProfileTP projection

Annotations (2)

NameValueLevelField
EndUserText.label Cash Position Profile view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY CashPositionProfile CashPositionProfile
CashPositionProfileDescription CashPositionProfileDescription
CashPositionHierSource CashPositionHierSource
CashPositionHierSourceText
CashPositionHierLevel1 CashPositionHierLevel1
CashPositionHierLevel1Text
CashPositionHierLevel2 CashPositionHierLevel2
CashPositionHierLevel2Text
CashPositionHierLevel3 CashPositionHierLevel3
CashPositionHierLevel3Text
BankAccountHierarchyName BankAccountHierarchyName
CashPositionPrdfndIncrement CashPositionPrdfndIncrement
CashPositionPrdfndInterimStep CashPositionPrdfndInterimStep
CashPositionPrdfndIntrmStpText
CashPositionPeriodEndIsNatural CashPositionPeriodEndIsNatural
FactoryCalendar FactoryCalendar Factory Calendar
FactoryCalendarName
CashPositionShiftOption CashPositionShiftOption
CashPositionShiftOptionText
DisplayCurrency DisplayCurrency Display Currency
CurrencyName
ExchangeRateType ExchangeRateType Exch. Rate Type
ExchangeRateTypeName _BankFeeExchRateTypeVH ExchangeRateTypeName *
CashPositionViewCategory CashPositionViewCategory
CashPositionViewCategoryText
CashPositionBalanceCategory CashPositionBalanceCategory
CashPositionBalCategoryText
CashPositionOverdueIsVisible CashPositionOverdueIsVisible
CashPositionOvrdIsIncldInClsg CashPositionOvrdIsIncldInClsg
CshPosSclngOfPreDcmlPlaces CshPosSclngOfPreDcmlPlaces
CshPosSclngOfPreDcmlPlacesText
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 C_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 C_CashPositionProfileTP AS
SELECT
  CashPositionProfile,
  CashPositionProfileDescription,
  CashPositionHierSource,
  _CshPosHierSourceText[1:Language = $session.system_language].DomainValueName AS CashPositionHierSourceText,
  CashPositionHierLevel1,
  _CshPosHierText[1:Language = $session.system_language].DomainValueName AS CashPositionHierLevel1Text,
  CashPositionHierLevel2,
  _CshPosHierTwoText[1:Language = $session.system_language].DomainValueName AS CashPositionHierLevel2Text,
  CashPositionHierLevel3,
  _CshPosHierThreeText[1:Language = $session.system_language].DomainValueName AS CashPositionHierLevel3Text,
  BankAccountHierarchyName,
  CashPositionPrdfndIncrement,
  CashPositionPrdfndInterimStep,
  _CshPosUnitText[1:Language = $session.system_language].DomainValueName AS CashPositionPrdfndIntrmStpText,
  CashPositionPeriodEndIsNatural,
  FactoryCalendar,
  _FactoryCalendarText[1:Language = $session.system_language].FactoryCalendarName AS FactoryCalendarName,
  CashPositionShiftOption,
  _CshPosShiftOptionText[1:Language = $session.system_language].DomainValueName AS CashPositionShiftOptionText,
  DisplayCurrency,
  _Currency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  ExchangeRateType,
  _BankFeeExchRateTypeVH.ExchangeRateTypeName AS ExchangeRateTypeName,
  CashPositionViewCategory,
  _CshPosViewTypeText[1:Language = $session.system_language].DomainValueName AS CashPositionViewCategoryText,
  CashPositionBalanceCategory,
  _CshPosBalTypeText[1:Language = $session.system_language].DomainValueName AS CashPositionBalCategoryText,
  CashPositionOverdueIsVisible,
  CashPositionOvrdIsIncldInClsg,
  CshPosSclngOfPreDcmlPlaces,
  _CshPosSclngPreDcmlPlacesText[1:Language = $session.system_language].DomainValueName AS CshPosSclngOfPreDcmlPlacesText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_CashPositionProfileTP
;

Learn More