PActualForecastCashFlow

DDL: PACTUALFORECASTCASHFLOW SQL: PCASHFLOW Type: view
32 Fields 1 Data Sources 2 Associations

Cash Flow

PActualForecastCashFlow is a CDS View that provides data about "Cash Flow" in SAP S/4HANA. It reads from 1 data source (I_CashFlow) and exposes 32 fields. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CashFlow flow from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CalendarDate _Date $projection.CalendarDay = _Date.CalendarDate
[0..1] PActivePlanningUnit _PlanningUnit $projection.CompanyCode = _PlanningUnit.CompanyCode

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCASHFLOW view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Cash Flow view

Fields (32)

KeyFieldSource TableSource FieldDescription
BankAccountInternalID I_CashFlow BankAccountInternalID Technical ID
BusinessPartner I_CashFlow BusinessPartner Issuing Authority
BusinessArea I_CashFlow BusinessArea Business Area
CompanyCode I_CashFlow CompanyCode Receiver Company Code
CostCenter I_CashFlow CostCenter Cost Center
ControllingArea
Customer I_CashFlow Customer Sold-to Party
HouseBank I_CashFlow HouseBank House Bank
HouseBankAccount I_CashFlow HouseBankAccount House Bank Account
LiquidityItem I_CashFlow LiquidityItem Liquidity Item
PlanningUnit _PlanningUnit PlanningUnit
CashPlanningGroup I_CashFlow CashPlanningGroup Planning Group
PlanningLevel I_CashFlow PlanningLevel Planning Level
ProfitCenter I_CashFlow ProfitCenter Profit Center
Segment I_CashFlow Segment Segment number
TradingPartner I_CashFlow PartnerCompany Trading Partner
Vendor I_CashFlow Supplier Supplier
WBSElement
WBSElement
CertaintyLevel I_CashFlow CertaintyLevel
CompanyCountry
PayingCompanyCode
AssignedCompanyCode I_CashFlow SourceCompanyCode
CalendarDay I_CashFlow TransactionDate Value Date
CalendarYearWeek _Date YearWeek Year and Calendar Week
CalendarYearMonth _Date YearMonth Year Month
CalendarYearQuarter _Date YearQuarter Year Quarter
CalendarYear _Date CalendarYear Year
FiscalYear I_CashFlow FiscalYear G/L Fiscal Year
FiscalYearVariant
PostingPeriod
ExpirationDate I_CashFlow ExpirationDate Expiratn Date

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 PActualForecastCashFlow.
-- 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: PCASHFLOW

CREATE VIEW PActualForecastCashFlow AS
SELECT
  flow.BankAccountInternalID AS BankAccountInternalID,
  flow.BusinessPartner AS BusinessPartner,
  flow.BusinessArea AS BusinessArea,
  flow.CompanyCode AS CompanyCode,
  flow.CostCenter AS CostCenter,
  flow._CompanyCode.ControllingArea AS ControllingArea,
  flow.Customer AS Customer,
  flow.HouseBank AS HouseBank,
  flow.HouseBankAccount AS HouseBankAccount,
  flow.LiquidityItem AS LiquidityItem,
  _PlanningUnit.PlanningUnit AS PlanningUnit,
  flow.CashPlanningGroup AS CashPlanningGroup,
  flow.PlanningLevel AS PlanningLevel,
  flow.ProfitCenter AS ProfitCenter,
  flow.Segment AS Segment,
  flow.PartnerCompany AS TradingPartner,
  flow.Supplier AS Vendor,
  flow._WBSElement.WBSElement AS WBSElement,
  flow.CertaintyLevel AS CertaintyLevel,
  flow._CompanyCode.Country AS CompanyCountry,
  flow.SourceCompanyCode AS AssignedCompanyCode,
  flow.TransactionDate AS CalendarDay,
  _Date.YearWeek AS CalendarYearWeek,
  _Date.YearMonth AS CalendarYearMonth,
  _Date.YearQuarter AS CalendarYearQuarter,
  _Date.CalendarYear AS CalendarYear,
  flow.FiscalYear AS FiscalYear,
  flow._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  '' AS PostingPeriod,
  flow.ExpirationDate AS ExpirationDate
FROM I_CashFlow AS flow
LEFT OUTER JOIN I_CalendarDate AS _Date ON CalendarDay = _Date.CalendarDate  -- association [0..1]
LEFT OUTER JOIN PActivePlanningUnit AS _PlanningUnit ON CompanyCode = _PlanningUnit.CompanyCode  -- association [0..1]
;

Learn More