P_GLAcctFlowSemTagDateFunc2

DDL: P_GLACCTFLOWSEMTAGDATEFUNC2 Type: view_entity COMPOSITE Package: FINS_FIS_FICO
41 Fields 2 Data Sources 2 Associations

P_GLAcctFlowSemTagDateFunc2

P_GLAcctFlowSemTagDateFunc2 is a Composite CDS View that provides data about "P_GLAcctFlowSemTagDateFunc2" in SAP S/4HANA. It reads from 2 data sources (I_SemTagGLAccount, P_ActualPlanBalFlow2) and exposes 41 fields with key fields GLAccountHierarchy, ActualPlanCode, PlanningCategory, Ledger, CompanyCode. It has 2 associations to related views. Part of development package FINS_FIS_FICO.

Data Sources (2)

SourceAliasJoin Type
I_SemTagGLAccount I_SemTagGLAccount inner
P_ActualPlanBalFlow2 P_ActualPlanBalFlow2 from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer
[0..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier

Annotations (5)

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

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY ActualPlanCode P_ActualPlanBalFlow2 ActualPlanCode
KEY PlanningCategory P_ActualPlanBalFlow2 PlanningCategory Plan Category
KEY Ledger P_ActualPlanBalFlow2 Ledger Ledger
KEY CompanyCode P_ActualPlanBalFlow2 CompanyCode Receiver Company Code
KEY DateFunction P_ActualPlanBalFlow2 DateFunction Relative Date Function
KEY FiscalYearPeriod P_ActualPlanBalFlow2 FiscalYearPeriod Period/Year
KEY GLAccountFlowType P_ActualPlanBalFlow2 GLAccountFlowType
FiscalYearVariant P_ActualPlanBalFlow2 FiscalYearVariant FY Variant
LedgerFiscalYear P_ActualPlanBalFlow2 LedgerFiscalYear
FiscalQuarter P_ActualPlanBalFlow2 FiscalQuarter
FiscalYearQuarter P_ActualPlanBalFlow2 FiscalYearQuarter
FiscalPeriod P_ActualPlanBalFlow2 FiscalPeriod Tax period
ChartOfAccounts P_ActualPlanBalFlow2 ChartOfAccounts Node Class
GLAccount P_ActualPlanBalFlow2 GLAccount General Ledger
IsBalanceSheetAccount P_ActualPlanBalFlow2 IsBalanceSheetAccount Is Balance Sheet Account
HierarchyNode I_SemTagGLAccount HierarchyNode Node
SemanticTag I_SemTagGLAccount SemanticTag Semantic Tag
GLAccountTypeFlowType
ControllingArea P_ActualPlanBalFlow2 ControllingArea Controlling Area
CostCenter P_ActualPlanBalFlow2 CostCenter Cost Center
ProfitCenter P_ActualPlanBalFlow2 ProfitCenter Profit Center
FunctionalArea P_ActualPlanBalFlow2 FunctionalArea Sendr Fctl Area
BusinessArea P_ActualPlanBalFlow2 BusinessArea Business Area
Segment P_ActualPlanBalFlow2 Segment Segment number
Product P_ActualPlanBalFlow2 Product Product Sold
ProductGroup P_ActualPlanBalFlow2 ProductGroup Product Sold Group
SoldProduct P_ActualPlanBalFlow2 SoldProduct Product Sold
SoldProductGroup P_ActualPlanBalFlow2 SoldProductGroup Product Sold Group
Customer P_ActualPlanBalFlow2 Customer Sold-to Party
CustomerGroup P_ActualPlanBalFlow2 CustomerGroup Customer Group
Supplier P_ActualPlanBalFlow2 Supplier Supplier
GlobalCurrency P_ActualPlanBalFlow2 GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_ActualPlanBalFlow2 AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy P_ActualPlanBalFlow2 FixedAmountInGlobalCrcy
InvertedAmountInGlobalCurrency
KslwoBCF P_ActualPlanBalFlow2 KslwoBCF
KslonlyBCF P_ActualPlanBalFlow2 KslonlyBCF
_GlobalCurrency P_ActualPlanBalFlow2 _GlobalCurrency
_Customer _Customer
_Supplier _Supplier

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_GLAcctFlowSemTagDateFunc2.
-- 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_GLAcctFlowSemTagDateFunc2 AS
SELECT
  I_SemTagGLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  P_ActualPlanBalFlow2.ActualPlanCode AS ActualPlanCode,
  P_ActualPlanBalFlow2.PlanningCategory AS PlanningCategory,
  P_ActualPlanBalFlow2.Ledger AS Ledger,
  P_ActualPlanBalFlow2.CompanyCode AS CompanyCode,
  P_ActualPlanBalFlow2.DateFunction AS DateFunction,
  P_ActualPlanBalFlow2.FiscalYearPeriod AS FiscalYearPeriod,
  P_ActualPlanBalFlow2.GLAccountFlowType AS GLAccountFlowType,
  P_ActualPlanBalFlow2.FiscalYearVariant AS FiscalYearVariant,
  P_ActualPlanBalFlow2.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActualPlanBalFlow2.FiscalQuarter AS FiscalQuarter,
  P_ActualPlanBalFlow2.FiscalYearQuarter AS FiscalYearQuarter,
  P_ActualPlanBalFlow2.FiscalPeriod AS FiscalPeriod,
  P_ActualPlanBalFlow2.ChartOfAccounts AS ChartOfAccounts,
  P_ActualPlanBalFlow2.GLAccount AS GLAccount,
  P_ActualPlanBalFlow2.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  I_SemTagGLAccount.HierarchyNode AS HierarchyNode,
  I_SemTagGLAccount.SemanticTag AS SemanticTag,
  cast( ' ' as fis_glacct_type_flow_type preserving type ) AS GLAccountTypeFlowType,
  P_ActualPlanBalFlow2.ControllingArea AS ControllingArea,
  P_ActualPlanBalFlow2.CostCenter AS CostCenter,
  P_ActualPlanBalFlow2.ProfitCenter AS ProfitCenter,
  P_ActualPlanBalFlow2.FunctionalArea AS FunctionalArea,
  P_ActualPlanBalFlow2.BusinessArea AS BusinessArea,
  P_ActualPlanBalFlow2.Segment AS Segment,
  P_ActualPlanBalFlow2.Product AS Product,
  P_ActualPlanBalFlow2.ProductGroup AS ProductGroup,
  P_ActualPlanBalFlow2.SoldProduct AS SoldProduct,
  P_ActualPlanBalFlow2.SoldProductGroup AS SoldProductGroup,
  P_ActualPlanBalFlow2.Customer AS Customer,
  P_ActualPlanBalFlow2.CustomerGroup AS CustomerGroup,
  P_ActualPlanBalFlow2.Supplier AS Supplier,
  P_ActualPlanBalFlow2.GlobalCurrency AS GlobalCurrency,
  P_ActualPlanBalFlow2.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_ActualPlanBalFlow2.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  cast(( P_ActualPlanBalFlow2.AmountInGlobalCurrency * -1 ) as fis_ksl_inverted ) AS InvertedAmountInGlobalCurrency,
  P_ActualPlanBalFlow2.KslwoBCF AS KslwoBCF,
  P_ActualPlanBalFlow2.KslonlyBCF AS KslonlyBCF,
  P_ActualPlanBalFlow2._GlobalCurrency AS _GlobalCurrency
FROM P_ActualPlanBalFlow2
INNER JOIN I_SemTagGLAccount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;

Learn More