P_ActualPlanBalFlow2

DDL: P_ACTUALPLANBALFLOW2 Type: view_entity COMPOSITE Package: FINS_FIS_FICO
66 Fields 2 Data Sources

P_ActualPlanBalFlow2

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

Data Sources (2)

SourceAliasJoin Type
P_ActualBalFlowDateFunc2 P_ActualBalFlowDateFunc2 from
P_PlanBalFlowDateFunc2 P_PlanBalFlowDateFunc2 union_all

Annotations (5)

NameValueLevelField
AbapCatalog.entityBuffer.definitionAllowed false view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view
Metadata.ignorePropagatedAnnotations true view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY ActualPlanCode P_ActualBalFlowDateFunc2 ActualPlanCode
KEY PlanningCategory P_ActualBalFlowDateFunc2 PlanningCategory Plan Category
KEY Ledger P_ActualBalFlowDateFunc2 Ledger Ledger
KEY CompanyCode P_ActualBalFlowDateFunc2 CompanyCode Receiver Company Code
KEY DateFunction P_ActualBalFlowDateFunc2 DateFunction Relative Date Function
KEY FiscalYearPeriodendasFiscalYearPeriod
KEY GLAccountFlowType P_ActualBalFlowDateFunc2 GLAccountFlowType
FiscalYearVariant P_ActualBalFlowDateFunc2 FiscalYearVariant FY Variant
LedgerFiscalYear P_ActualBalFlowDateFunc2 LedgerFiscalYear
FiscalQuarter
FiscalYearQuarter
FiscalPeriodendasFiscalPeriod
ChartOfAccounts P_ActualBalFlowDateFunc2 ChartOfAccounts Node Class
GLAccount P_ActualBalFlowDateFunc2 GLAccount General Ledger
IsBalanceSheetAccount
ControllingArea P_ActualBalFlowDateFunc2 ControllingArea Controlling Area
CostCenter P_ActualBalFlowDateFunc2 CostCenter Cost Center
ProfitCenter P_ActualBalFlowDateFunc2 ProfitCenter Profit Center
FunctionalArea P_ActualBalFlowDateFunc2 FunctionalArea Sendr Fctl Area
BusinessArea P_ActualBalFlowDateFunc2 BusinessArea Business Area
Segment P_ActualBalFlowDateFunc2 Segment Segment number
Product P_ActualBalFlowDateFunc2 Product Product Sold
ProductGroup P_ActualBalFlowDateFunc2 ProductGroup Product Sold Group
SoldProduct P_ActualBalFlowDateFunc2 SoldProduct Product Sold
SoldProductGroup P_ActualBalFlowDateFunc2 SoldProductGroup Product Sold Group
Customer P_ActualBalFlowDateFunc2 Customer Sold-to Party
CustomerGroup P_ActualBalFlowDateFunc2 CustomerGroup Customer Group
Supplier P_ActualBalFlowDateFunc2 Supplier Supplier
GlobalCurrency P_ActualBalFlowDateFunc2 GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_ActualBalFlowDateFunc2 AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy P_ActualBalFlowDateFunc2 FixedAmountInGlobalCrcy
KslwoBCF P_ActualBalFlowDateFunc2 KslwoBCF Amount in Global Currency
KslonlyBCF P_ActualBalFlowDateFunc2 KslonlyBCF
ActualPlanCode
KEY PlanningCategory P_PlanBalFlowDateFunc2 PlanningCategory Plan Category
KEY Ledger P_PlanBalFlowDateFunc2 Ledger Ledger
KEY CompanyCode P_PlanBalFlowDateFunc2 CompanyCode Receiver Company Code
KEY DateFunction P_PlanBalFlowDateFunc2 DateFunction Relative Date Function
KEY FiscalYearPeriodendasFiscalYearPeriod
KEY GLAccountFlowType P_PlanBalFlowDateFunc2 GLAccountFlowType
FiscalYearVariant P_PlanBalFlowDateFunc2 FiscalYearVariant FY Variant
LedgerFiscalYear P_PlanBalFlowDateFunc2 LedgerFiscalYear
FiscalQuarter
FiscalYearQuarter
ChartOfAccounts P_PlanBalFlowDateFunc2 ChartOfAccounts Node Class
GLAccount P_PlanBalFlowDateFunc2 GLAccount General Ledger
IsBalanceSheetAccount
ControllingArea P_PlanBalFlowDateFunc2 ControllingArea Controlling Area
CostCenter P_PlanBalFlowDateFunc2 CostCenter Cost Center
ProfitCenter P_PlanBalFlowDateFunc2 ProfitCenter Profit Center
FunctionalArea P_PlanBalFlowDateFunc2 FunctionalArea Sendr Fctl Area
BusinessArea P_PlanBalFlowDateFunc2 BusinessArea Business Area
Segment P_PlanBalFlowDateFunc2 Segment Segment number
Product P_PlanBalFlowDateFunc2 Product Product Sold
ProductGroup P_PlanBalFlowDateFunc2 ProductGroup Product Sold Group
SoldProduct P_PlanBalFlowDateFunc2 SoldProduct Product Sold
SoldProductGroup P_PlanBalFlowDateFunc2 SoldProductGroup Product Sold Group
Customer P_PlanBalFlowDateFunc2 Customer Sold-to Party
CustomerGroup P_PlanBalFlowDateFunc2 CustomerGroup Customer Group
Supplier P_PlanBalFlowDateFunc2 Supplier Supplier
GlobalCurrency P_PlanBalFlowDateFunc2 GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_PlanBalFlowDateFunc2 AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy P_PlanBalFlowDateFunc2 FixedAmountInGlobalCrcy
KslwoBCF P_PlanBalFlowDateFunc2 KslwoBCF Amount in Global Currency
KslonlyBCF P_PlanBalFlowDateFunc2 KslonlyBCF
_GlobalCurrency P_PlanBalFlowDateFunc2 _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_ActualPlanBalFlow2.
-- 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_ActualPlanBalFlow2 AS
SELECT
  P_ActualBalFlowDateFunc2.ActualPlanCode AS ActualPlanCode,
  P_ActualBalFlowDateFunc2.PlanningCategory AS PlanningCategory,
  P_ActualBalFlowDateFunc2.Ledger AS Ledger,
  P_ActualBalFlowDateFunc2.CompanyCode AS CompanyCode,
  P_ActualBalFlowDateFunc2.DateFunction AS DateFunction,
  case when P_ActualBalFlowDateFunc2.FiscalYearPeriod > I_FiscalCalendarDate.FiscalYearPeriod then I_FiscalCalendarDate.FiscalYearPeriod else P_ActualBalFlowDateFunc2.FiscalYearPeriod end as FiscalYearPeriod AS FiscalYearPeriodendasFiscalYearPeriod,
  P_ActualBalFlowDateFunc2.GLAccountFlowType AS GLAccountFlowType,
  P_ActualBalFlowDateFunc2.FiscalYearVariant AS FiscalYearVariant,
  P_ActualBalFlowDateFunc2.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActualBalFlowDateFunc2._FiscalCalendarDate.FiscalQuarter AS FiscalQuarter,
  P_ActualBalFlowDateFunc2._FiscalCalendarDate.FiscalYearQuarter AS FiscalYearQuarter,
  case when P_ActualBalFlowDateFunc2.FiscalPeriod > I_FiscalCalendarDate.FiscalPeriod then I_FiscalCalendarDate.FiscalPeriod else P_ActualBalFlowDateFunc2.FiscalPeriod end as FiscalPeriod AS FiscalPeriodendasFiscalPeriod,
  P_ActualBalFlowDateFunc2.ChartOfAccounts AS ChartOfAccounts,
  P_ActualBalFlowDateFunc2.GLAccount AS GLAccount,
  P_ActualBalFlowDateFunc2._GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  P_ActualBalFlowDateFunc2.ControllingArea AS ControllingArea,
  P_ActualBalFlowDateFunc2.CostCenter AS CostCenter,
  P_ActualBalFlowDateFunc2.ProfitCenter AS ProfitCenter,
  P_ActualBalFlowDateFunc2.FunctionalArea AS FunctionalArea,
  P_ActualBalFlowDateFunc2.BusinessArea AS BusinessArea,
  P_ActualBalFlowDateFunc2.Segment AS Segment,
  P_ActualBalFlowDateFunc2.Product AS Product,
  P_ActualBalFlowDateFunc2.ProductGroup AS ProductGroup,
  P_ActualBalFlowDateFunc2.SoldProduct AS SoldProduct,
  P_ActualBalFlowDateFunc2.SoldProductGroup AS SoldProductGroup,
  P_ActualBalFlowDateFunc2.Customer AS Customer,
  P_ActualBalFlowDateFunc2.CustomerGroup AS CustomerGroup,
  P_ActualBalFlowDateFunc2.Supplier AS Supplier,
  P_ActualBalFlowDateFunc2.GlobalCurrency AS GlobalCurrency,
  P_ActualBalFlowDateFunc2.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_ActualBalFlowDateFunc2.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  P_ActualBalFlowDateFunc2.KslwoBCF AS KslwoBCF,
  P_ActualBalFlowDateFunc2.KslonlyBCF AS KslonlyBCF,
  P_PlanBalFlowDateFunc2._GlobalCurrency AS _GlobalCurrency
FROM P_ActualBalFlowDateFunc2
-- UNION ALL with additional select branch(es): P_PlanBalFlowDateFunc2
;

Learn More