C_CashFlowDetailedAnalysisQ

DDL: C_CASHFLOWDETAILEDANALYSISQ SQL: CCFDAQUERY Type: view CONSUMPTION
31 Fields 1 Data Sources

Cash Flow Detailed Analysis Query

C_CashFlowDetailedAnalysisQ is a Consumption CDS View that provides data about "Cash Flow Detailed Analysis Query" in SAP S/4HANA. It reads from 1 data source (I_CashFlowDetailedAnalysisCube) and exposes 31 fields.

Data Sources (1)

SourceAliasJoin Type
I_CashFlowDetailedAnalysisCube I_CashFlowDetailedAnalysisCube from

Parameters (7)

NameTypeDefault
P_StartDate sydate
P_EndDate sydate
P_DisplayCurrency vdm_v_display_currency
P_LiquidityItemHierarchy fclm_hier_name
P_CalendarDay rshienm
P_Language sylangu
P_KeyDate vdm_v_key_date

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CCFDAQUERY view
EndUserText.label Cash Flow Detailed Analysis Query view
Analytics.query true 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 (31)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
Currency TransactionCurrency Bank Account Currency
LiquidityItemName
LiquidityItem LiquidityItem Liquidity Item
CalendarDay CalendarDay Calendar Day
CashNet CashNet Cash Net
CashIn CashIn Cash In
CashOut CashOut Cash Out
CashNetConverted CashNetConverted Cash Net (Converted)
CashInConverted CashInConverted Cash In (Converted)
CashOutConverted CashOutConverted Cash Out (Converted)
SourceCompanyCode SourceCompanyCode Assigned Company Code
BankAccountInternalID BankAccountInternalID Bank Account
BusinessArea BusinessArea Business Area
BusinessPartner BusinessPartner Issuing Authority
CertaintyLevel CertaintyLevel
ControllingArea ControllingArea Controlling Area
CostCenter CostCenter Cost Center
Country Country Country/Region
Customer Customer Sold-to Party
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
CashPlanningGroup CashPlanningGroup Planning Group
PlanningLevel PlanningLevel Planning Level
ProfitCenter ProfitCenter Profit Center
Segment Segment Segment number
Supplier Supplier Supplier
WBSElement
CashFlowDirection CashFlowDirection
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
ProjectInternalID ProjectInternalID Project Definition

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_CashFlowDetailedAnalysisQ.
-- 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: CCFDAQUERY
-- Parameters: P_StartDate : sydate, P_EndDate : sydate, P_DisplayCurrency : vdm_v_display_currency, P_LiquidityItemHierarchy : fclm_hier_name, P_CalendarDay : rshienm, P_Language : sylangu, P_KeyDate : vdm_v_key_date

CREATE VIEW C_CashFlowDetailedAnalysisQ AS
SELECT
  CompanyCode,
  TransactionCurrency AS Currency,
  _LiquidityItem._Text[1: Language = :P_Language].LiquidityItemName AS LiquidityItemName,
  LiquidityItem,
  CalendarDay,
  CashNet,
  CashIn,
  CashOut,
  CashNetConverted,
  CashInConverted,
  CashOutConverted,
  SourceCompanyCode,
  BankAccountInternalID,
  BusinessArea,
  BusinessPartner,
  CertaintyLevel,
  ControllingArea,
  CostCenter,
  Country,
  Customer,
  HouseBank,
  HouseBankAccount,
  CashPlanningGroup,
  PlanningLevel,
  ProfitCenter,
  Segment,
  Supplier,
  CashFlowDirection,
  ResponsibleCostCenter,
  ProjectInternalID
FROM I_CashFlowDetailedAnalysisCube
;

Learn More