What is P_ActualPlanBalFlow in SAP S/4HANA?

P_ActualPlanBalFlow is a composite CDS view in SAP S/4HANA. P_ActualPlanBalFlow It contains 71 fields.

Which tables does P_ActualPlanBalFlow read from?

P_ActualPlanBalFlow reads data from: P_ActualBalFlowDateFunc, P_PlanBalFlowDateFunc.

What VDM layer is P_ActualPlanBalFlow?

P_ActualPlanBalFlow is classified as a Composite view that combines data from multiple basic views.

P_ActualPlanBalFlow

DDL: P_ACTUALPLANBALFLOW Type: view_entity COMPOSITE Package: FINS_FIS_FICO

71 Fields 2 Data Sources

P_ActualPlanBalFlow

P_ActualPlanBalFlow is a Composite CDS View that provides data about "P_ActualPlanBalFlow" in SAP S/4HANA. It reads from 2 data sources (P_ActualBalFlowDateFunc, P_PlanBalFlowDateFunc) and exposes 71 fields with key fields ActualPlanCode, PlanningCategory, Ledger, CompanyCode, DateFunction. Part of development package FINS_FIS_FICO.

Data Sources (2)

Source	Alias	Join Type
P_ActualBalFlowDateFunc	P_ActualBalFlowDateFunc	from
P_PlanBalFlowDateFunc	P_PlanBalFlowDateFunc	union_all

Annotations (5)

Name	Value	Level
AbapCatalog.entityBuffer.definitionAllowed	false	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
VDM.viewType	#COMPOSITE	view
VDM.private	true	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (71)

Key	Field	Source Table	Source Field	Description
KEY	ActualPlanCode	P_ActualBalFlowDateFunc	ActualPlanCode
KEY	PlanningCategory	P_ActualBalFlowDateFunc	PlanningCategory	Plan Category
KEY	Ledger	P_ActualBalFlowDateFunc	Ledger	Ledger
KEY	CompanyCode	P_ActualBalFlowDateFunc	CompanyCode	Receiver Company Code
KEY	DateFunction	P_ActualBalFlowDateFunc	DateFunction	Relative Date Function
KEY	FiscalYearPeriodendasFiscalYearPeriod
KEY	GLAccountFlowType	P_ActualBalFlowDateFunc	GLAccountFlowType
	FiscalYearVariant	P_ActualBalFlowDateFunc	FiscalYearVariant	FY Variant
	LedgerFiscalYear	P_ActualBalFlowDateFunc	LedgerFiscalYear
	FiscalQuarter
	FiscalYearQuarter
	FiscalPeriodendasFiscalPeriod
	ChartOfAccounts	P_ActualBalFlowDateFunc	ChartOfAccounts	Node Class
	GLAccount	P_ActualBalFlowDateFunc	GLAccount	General Ledger
	IsBalanceSheetAccount
	ControllingArea	P_ActualBalFlowDateFunc	ControllingArea	Controlling Area
	CostCenter	P_ActualBalFlowDateFunc	CostCenter	Cost Center
	ProfitCenter	P_ActualBalFlowDateFunc	ProfitCenter	Profit Center
	FunctionalArea	P_ActualBalFlowDateFunc	FunctionalArea	Sendr Fctl Area
	BusinessArea	P_ActualBalFlowDateFunc	BusinessArea	Business Area
	Segment	P_ActualBalFlowDateFunc	Segment	Segment number
	Product	P_ActualBalFlowDateFunc	Product	Product Sold
	ProductGroup	P_ActualBalFlowDateFunc	ProductGroup	Product Sold Group
	SoldProduct	P_ActualBalFlowDateFunc	SoldProduct	Product Sold
	SoldProductGroup	P_ActualBalFlowDateFunc	SoldProductGroup	Product Sold Group
	Customer	P_ActualBalFlowDateFunc	Customer	Sold-to Party
	CustomerGroup	P_ActualBalFlowDateFunc	CustomerGroup	Customer Group
	Supplier	P_ActualBalFlowDateFunc	Supplier	Supplier
	OrderID	P_ActualBalFlowDateFunc	OrderID	Order ID
	SalesDocument	P_ActualBalFlowDateFunc	SalesDocument	SD Document
	GlobalCurrency	P_ActualBalFlowDateFunc	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	P_ActualBalFlowDateFunc	AmountInGlobalCurrency	Amount in Global Currency
	FixedAmountInGlobalCrcy	P_ActualBalFlowDateFunc	FixedAmountInGlobalCrcy
	KslwoBCF	P_ActualBalFlowDateFunc	KslwoBCF
	KslonlyBCF	P_ActualBalFlowDateFunc	KslonlyBCF
	ActualPlanCode
KEY	PlanningCategory	P_PlanBalFlowDateFunc	PlanningCategory	Plan Category
KEY	Ledger	P_PlanBalFlowDateFunc	Ledger	Ledger
KEY	CompanyCode	P_PlanBalFlowDateFunc	CompanyCode	Receiver Company Code
KEY	DateFunction	P_PlanBalFlowDateFunc	DateFunction	Relative Date Function
KEY	FiscalYearPeriodendasFiscalYearPeriod
KEY	GLAccountFlowType	P_PlanBalFlowDateFunc	GLAccountFlowType
	FiscalYearVariant	P_PlanBalFlowDateFunc	FiscalYearVariant	FY Variant
	LedgerFiscalYear	P_PlanBalFlowDateFunc	LedgerFiscalYear
	FiscalQuarter
	FiscalYearQuarter
	FiscalPeriodendasFiscalPeriod
	ChartOfAccounts	P_PlanBalFlowDateFunc	ChartOfAccounts	Node Class
	GLAccount	P_PlanBalFlowDateFunc	GLAccount	General Ledger
	IsBalanceSheetAccount
	ControllingArea	P_PlanBalFlowDateFunc	ControllingArea	Controlling Area
	CostCenter	P_PlanBalFlowDateFunc	CostCenter	Cost Center
	ProfitCenter	P_PlanBalFlowDateFunc	ProfitCenter	Profit Center
	FunctionalArea	P_PlanBalFlowDateFunc	FunctionalArea	Sendr Fctl Area
	BusinessArea	P_PlanBalFlowDateFunc	BusinessArea	Business Area
	Segment	P_PlanBalFlowDateFunc	Segment	Segment number
	Product	P_PlanBalFlowDateFunc	Product	Product Sold
	ProductGroup	P_PlanBalFlowDateFunc	ProductGroup	Product Sold Group
	SoldProduct	P_PlanBalFlowDateFunc	SoldProduct	Product Sold
	SoldProductGroup	P_PlanBalFlowDateFunc	SoldProductGroup	Product Sold Group
	Customer	P_PlanBalFlowDateFunc	Customer	Sold-to Party
	CustomerGroup	P_PlanBalFlowDateFunc	CustomerGroup	Customer Group
	Supplier	P_PlanBalFlowDateFunc	Supplier	Supplier
	OrderID	P_PlanBalFlowDateFunc	OrderID	Order ID
	SalesDocument	P_PlanBalFlowDateFunc	SalesDocument	SD Document
	GlobalCurrency	P_PlanBalFlowDateFunc	GlobalCurrency	GM Billing Element: Global Currency
	AmountInGlobalCurrency	P_PlanBalFlowDateFunc	AmountInGlobalCurrency	Amount in Global Currency
	FixedAmountInGlobalCrcy	P_PlanBalFlowDateFunc	FixedAmountInGlobalCrcy
	KslwoBCF	P_PlanBalFlowDateFunc	KslwoBCF
	KslonlyBCF	P_PlanBalFlowDateFunc	KslonlyBCF
	_GlobalCurrency	P_PlanBalFlowDateFunc	_GlobalCurrency

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 P_ActualPlanBalFlow.
-- 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 P_ActualPlanBalFlow AS
SELECT
  P_ActualBalFlowDateFunc.ActualPlanCode AS ActualPlanCode,
  P_ActualBalFlowDateFunc.PlanningCategory AS PlanningCategory,
  P_ActualBalFlowDateFunc.Ledger AS Ledger,
  P_ActualBalFlowDateFunc.CompanyCode AS CompanyCode,
  P_ActualBalFlowDateFunc.DateFunction AS DateFunction,
  case when P_ActualBalFlowDateFunc.FiscalYearPeriod > I_FiscalCalendarDate.FiscalYearPeriod then I_FiscalCalendarDate.FiscalYearPeriod else P_ActualBalFlowDateFunc.FiscalYearPeriod end as FiscalYearPeriod AS FiscalYearPeriodendasFiscalYearPeriod,
  P_ActualBalFlowDateFunc.GLAccountFlowType AS GLAccountFlowType,
  P_ActualBalFlowDateFunc.FiscalYearVariant AS FiscalYearVariant,
  P_ActualBalFlowDateFunc.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActualBalFlowDateFunc._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  P_ActualBalFlowDateFunc._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  case when P_ActualBalFlowDateFunc.FiscalPeriod > I_FiscalCalendarDate.FiscalPeriod then I_FiscalCalendarDate.FiscalPeriod else P_ActualBalFlowDateFunc.FiscalPeriod end as FiscalPeriod AS FiscalPeriodendasFiscalPeriod,
  P_ActualBalFlowDateFunc.ChartOfAccounts AS ChartOfAccounts,
  P_ActualBalFlowDateFunc.GLAccount AS GLAccount,
  P_ActualBalFlowDateFunc._GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  P_ActualBalFlowDateFunc.ControllingArea AS ControllingArea,
  P_ActualBalFlowDateFunc.CostCenter AS CostCenter,
  P_ActualBalFlowDateFunc.ProfitCenter AS ProfitCenter,
  P_ActualBalFlowDateFunc.FunctionalArea AS FunctionalArea,
  P_ActualBalFlowDateFunc.BusinessArea AS BusinessArea,
  P_ActualBalFlowDateFunc.Segment AS Segment,
  P_ActualBalFlowDateFunc.Product AS Product,
  P_ActualBalFlowDateFunc.ProductGroup AS ProductGroup,
  P_ActualBalFlowDateFunc.SoldProduct AS SoldProduct,
  P_ActualBalFlowDateFunc.SoldProductGroup AS SoldProductGroup,
  P_ActualBalFlowDateFunc.Customer AS Customer,
  P_ActualBalFlowDateFunc.CustomerGroup AS CustomerGroup,
  P_ActualBalFlowDateFunc.Supplier AS Supplier,
  P_ActualBalFlowDateFunc.OrderID AS OrderID,
  P_ActualBalFlowDateFunc.SalesDocument AS SalesDocument,
  P_ActualBalFlowDateFunc.GlobalCurrency AS GlobalCurrency,
  P_ActualBalFlowDateFunc.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_ActualBalFlowDateFunc.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  P_ActualBalFlowDateFunc.KslwoBCF AS KslwoBCF,
  P_ActualBalFlowDateFunc.KslonlyBCF AS KslonlyBCF,
  P_PlanBalFlowDateFunc._GlobalCurrency AS _GlobalCurrency
FROM P_ActualBalFlowDateFunc
-- UNION ALL with additional select branch(es): P_PlanBalFlowDateFunc
;

Depth:

P_ActualPlanBalFlow view_entity

P_ActualBalFlowDateFunc view_entity
P_PlanBalFlowDateFunc view_entity

P_ActualPlanBalFlowSemtag view
P_GLAcctFlowSemTagDateFunc view_entity

Depth:

P_ActualPlanBalFlow

Data Sources (2)

Annotations (5)

Fields (71)

Learn More