I_CASHPOSITIONPROFILE
Define Cash Position Profile
I_CASHPOSITIONPROFILE is a CDS View in S/4HANA. Define Cash Position Profile. It contains 33 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_CashPositionProfile | view_entity | from | CONSUMPTION | Cash Position Profile |
| C_CashPositionProfileWithCycle | view_entity | from | CONSUMPTION | Cash Position Profile With Cycle Info |
| C_ShrtTrmCshPosActualFlow | view_entity | cross | CONSUMPTION | Overdue Actual Flows |
| I_CashPositionProfileVH | view_entity | from | COMPOSITE | Cash Position Profile |
| P_ShrtTrmCshPosAccHier | view_entity | from | COMPOSITE | Short Term Cash Position Bank Acc Hier |
| P_ShrtTrmCshPosAccHier | view_entity | inner | COMPOSITE | Short Term Cash Position Bank Acc Hier |
| P_ShrtTrmCshPosAccHier | view_entity | union_all | COMPOSITE | Short Term Cash Position Bank Acc Hier |
| P_ShrtTrmCshPosAccWithProfile | view_entity | cross | COMPOSITE | Short Term Cash Position Acc Filter |
| P_ShrtTrmCshPosGrouping | view_entity | inner | COMPOSITE | Short Term Cash Position Grouping |
| P_ShrtTrmCshPosGrouping | view_entity | union_all | COMPOSITE | Short Term Cash Position Grouping |
Fields (33)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CashPositionProfile | CashPositionProfile | 4 |
| _BankFeeExchRateTypeVH | _BankFeeExchRateTypeVH | 1 | |
| _CshPosBalCategoryText | _CshPosBalCategoryText | 1 | |
| _CshPosBalTypeText | _CshPosBalTypeText | 1 | |
| _CshPosShiftOptionText | _CshPosShiftOptionText | 1 | |
| _CshPosUnitText | _CshPosUnitText | 1 | |
| _CshPosViewTypeText | _CshPosViewTypeText | 1 | |
| _Currency | _Currency | 1 | |
| _FactoryCalendarText | _FactoryCalendarText | 1 | |
| CashBalanceType | CashBalanceType | 1 | |
| CashPositionBalanceCategory | CashPositionBalanceCategory | 1 | |
| CashPositionFutureIsVisible | CashPositionFutureIsVisible | 1 | |
| CashPositionHierLevel1 | CashPositionHierLevel1 | 1 | |
| CashPositionHierLevel2 | CashPositionHierLevel2 | 1 | |
| CashPositionHierLevel3 | CashPositionHierLevel3 | 1 | |
| CashPositionHierSource | CashPositionHierSource | 2 | |
| CashPositionOverdueIsVisible | CashPositionOverdueIsVisible | 1 | |
| CashPositionOvrdIsIncldInClsg | CashPositionOvrdIsIncldInClsg | 1 | |
| CashPositionPeriodEndIsNatural | CashPositionPeriodEndIsNatural | 1 | |
| CashPositionPrdfndIncrement | CashPositionPrdfndIncrement | 1 | |
| CashPositionPrdfndInterimStep | CashPositionPrdfndInterimStep | 1 | |
| CashPositionProfileDescription | CashPositionProfileDescription | 1 | |
| CashPositionRootNode | CashPositionRootNode | 1 | |
| CashPositionRootNodeIsNeeded | CashPositionRootNodeIsNeeded | 1 | |
| CashPositionShiftOption | CashPositionShiftOption | 1 | |
| CashPositionSmartCrcyIsEnabled | CashPositionSmartCrcyIsEnabled | 1 | |
| CashPositionViewCategory | CashPositionViewCategory | 1 | |
| DisplayCurrency | DisplayCurrency | 1 | |
| EmbeddedCshPosDetViewIsVisible | EmbeddedCshPosDetViewIsVisible | 1 | |
| EndOfDayRecnclnRsltIsConsdrd | EndOfDayRecnclnRsltIsConsdrd | 1 | |
| ExchangeRateType | ExchangeRateType | 1 | |
| FactoryCalendar | FactoryCalendar | 1 | |
| IntradayRecnclnRsltIsConsdrd | IntradayRecnclnRsltIsConsdrd | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Define Cash Position Profile
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CASHPOSITIONPROFILE (
CASHPOSITIONPROFILE,
_BANKFEEEXCHRATETYPEVH,
_CSHPOSBALCATEGORYTEXT,
_CSHPOSBALTYPETEXT,
_CSHPOSSHIFTOPTIONTEXT,
_CSHPOSUNITTEXT,
_CSHPOSVIEWTYPETEXT,
_CURRENCY,
_FACTORYCALENDARTEXT,
CASHBALANCETYPE,
CASHPOSITIONBALANCECATEGORY,
CASHPOSITIONFUTUREISVISIBLE,
CASHPOSITIONHIERLEVEL1,
CASHPOSITIONHIERLEVEL2,
CASHPOSITIONHIERLEVEL3,
CASHPOSITIONHIERSOURCE,
CASHPOSITIONOVERDUEISVISIBLE,
CASHPOSITIONOVRDISINCLDINCLSG,
CASHPOSITIONPERIODENDISNATURAL,
CASHPOSITIONPRDFNDINCREMENT,
CASHPOSITIONPRDFNDINTERIMSTEP,
CASHPOSITIONPROFILEDESCRIPTION,
CASHPOSITIONROOTNODE,
CASHPOSITIONROOTNODEISNEEDED,
CASHPOSITIONSHIFTOPTION,
CASHPOSITIONSMARTCRCYISENABLED,
CASHPOSITIONVIEWCATEGORY,
DISPLAYCURRENCY,
EMBEDDEDCSHPOSDETVIEWISVISIBLE,
ENDOFDAYRECNCLNRSLTISCONSDRD,
EXCHANGERATETYPE,
FACTORYCALENDAR,
INTRADAYRECNCLNRSLTISCONSDRD,
PRIMARY KEY (CASHPOSITIONPROFILE)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA