C_CshFlwFcstComprnQ

DDL: C_CSHFLWFCSTCOMPRNQ SQL: CSNAPCOMPARE Type: view CONSUMPTION

C view for Cash Flow Comparison

C_CshFlwFcstComprnQ is a Consumption CDS View that provides data about "C view for Cash Flow Comparison" in SAP S/4HANA. It reads from 1 data source (I_CshFlwFcstComprnC) and exposes 35 fields with key field CashFlow.

Data Sources (1)

SourceAliasJoin Type
I_CshFlwFcstComprnC I_CshFlwFcstComprnC from

Parameters (10)

NameTypeDefault
P_StartDate sydate
P_EndDate sydate
P_CashFlowForecastStartDate sydate
P_CashFlowForecastEndDate sydate
P_Language sylangu
P_KeyDate vdm_v_key_date
P_DisplayCurrency vdm_v_display_currency
P_ExchangeRateType kurst_curr
P_CalendarDay rshienm
P_CashFlowSnapshotTime syuzeit

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CSNAPCOMPARE view
EndUserText.label C view for Cash Flow Comparison view
Analytics.query true view
Analytics.variableCheck.implementedBy ABAP:CL_FIN_CASH_CHECK_VARIABLES view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY CashFlow CashFlow Cash Flow
Bank Bank Bank
BankAccountCurrency BankAccountCurrency Bank Account Currency
CompanyCode CompanyCode Company Code
BankAccount BankAccount Bank Account
BankAccountDescription BankAccountDescription Bank Account Description
BankAccountType BankAccountType Bank Account Type
BankCountry BankCountry Bank Country/Region
BusinessPartner BankGroup Bank Group
BankGroupName BankGroupName Bank Group Name
BusinessArea BusinessArea Business Area
BusinessAreaName BusinessAreaName Business Area Name
CertaintyLevel CertaintyLevel Certainty Level
CompanyCodeName CompanyCodeName Company Code Name
TransactionCurrency TransactionCurrency Transaction Currency
GLAccount GLAccount GL Account
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
LiquidityItem LiquidityItem Liquidity Item
CashFlowDirection CashFlowDirection Cash Flow Direction
LiquidityItemName LiquidityItemName Liquidity Item Name
CashPlanningGroup CashPlanningGroup Planning Group
CashPlanningGroupName CashPlanningGroupName Planning Group Name
PlanningLevel PlanningLevel Planning Level
PlanningLevelName PlanningLevelName Planning Level Name
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment
TradingPartner TradingPartner Trading Partner
CashFlowSnapshotDate CashFlowSnapshotDate Snapshot Date
CalendarDay CalendarDay Day of Month
WeekDay WeekDay Day of Week
ValueDate TransactionDate Value Date
DisplayCurrency DisplayCurrency Display Currency
AmountInBankAccountCurrency AmountInBankAccountCurrency Amount in Bank Account Currency
AmountInDisplayCurrency AmountInDisplayCurrency Amount in Display Currency

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_CshFlwFcstComprnQ.
-- 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.
-- SQL view name: CSNAPCOMPARE
-- Parameters: P_StartDate : sydate, P_EndDate : sydate, P_CashFlowForecastStartDate : sydate, P_CashFlowForecastEndDate : sydate, P_Language : sylangu, P_KeyDate : vdm_v_key_date, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst_curr, P_CalendarDay : rshienm, P_CashFlowSnapshotTime : syuzeit

CREATE VIEW C_CshFlwFcstComprnQ AS
SELECT
  CashFlow,
  Bank,
  BankAccountCurrency,
  CompanyCode,
  BankAccount,
  BankAccountDescription,
  BankAccountType,
  BankCountry,
  BankGroup AS BusinessPartner,
  BankGroupName,
  BusinessArea,
  BusinessAreaName,
  CertaintyLevel,
  CompanyCodeName,
  TransactionCurrency,
  GLAccount,
  HouseBank,
  HouseBankAccount,
  LiquidityItem,
  CashFlowDirection,
  LiquidityItemName,
  CashPlanningGroup,
  CashPlanningGroupName,
  PlanningLevel,
  PlanningLevelName,
  ProfitCenter,
  Segment,
  TradingPartner,
  CashFlowSnapshotDate,
  CalendarDay,
  WeekDay,
  TransactionDate AS ValueDate,
  DisplayCurrency,
  AmountInBankAccountCurrency,
  AmountInDisplayCurrency
FROM I_CshFlwFcstComprnC
;