P_GLAcctFlowSemTagDateFunc

DDL: P_GLACCTFLOWSEMTAGDATEFUNC Type: view_entity COMPOSITE Package: FINS_FIS_FICO
43 Fields 2 Data Sources 2 Associations

P_GLAcctFlowSemTagDateFunc

P_GLAcctFlowSemTagDateFunc is a Composite CDS View that provides data about "P_GLAcctFlowSemTagDateFunc" in SAP S/4HANA. It reads from 2 data sources (I_SemTagGLAccount, P_ActualPlanBalFlow) and exposes 43 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_ActualPlanBalFlow P_ActualPlanBalFlow 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 (43)

KeyFieldSource TableSource FieldDescription
KEY GLAccountHierarchy I_SemTagGLAccount GLAccountHierarchy
KEY ActualPlanCode P_ActualPlanBalFlow ActualPlanCode
KEY PlanningCategory P_ActualPlanBalFlow PlanningCategory Plan Category
KEY Ledger P_ActualPlanBalFlow Ledger Ledger
KEY CompanyCode P_ActualPlanBalFlow CompanyCode Receiver Company Code
KEY DateFunction P_ActualPlanBalFlow DateFunction Relative Date Function
KEY FiscalYearPeriod P_ActualPlanBalFlow FiscalYearPeriod Period/Year
KEY GLAccountFlowType P_ActualPlanBalFlow GLAccountFlowType
FiscalYearVariant P_ActualPlanBalFlow FiscalYearVariant FY Variant
LedgerFiscalYear P_ActualPlanBalFlow LedgerFiscalYear
FiscalQuarter P_ActualPlanBalFlow FiscalQuarter
FiscalYearQuarter P_ActualPlanBalFlow FiscalYearQuarter
FiscalPeriod P_ActualPlanBalFlow FiscalPeriod Tax period
ChartOfAccounts P_ActualPlanBalFlow ChartOfAccounts Node Class
GLAccount P_ActualPlanBalFlow GLAccount General Ledger
IsBalanceSheetAccount P_ActualPlanBalFlow IsBalanceSheetAccount Is Balance Sheet Account
HierarchyNode I_SemTagGLAccount HierarchyNode Node
SemanticTag I_SemTagGLAccount SemanticTag Semantic Tag
GLAccountTypeFlowType
ControllingArea P_ActualPlanBalFlow ControllingArea Controlling Area
CostCenter P_ActualPlanBalFlow CostCenter Cost Center
ProfitCenter P_ActualPlanBalFlow ProfitCenter Profit Center
FunctionalArea P_ActualPlanBalFlow FunctionalArea Sendr Fctl Area
BusinessArea P_ActualPlanBalFlow BusinessArea Business Area
Segment P_ActualPlanBalFlow Segment Segment number
Product P_ActualPlanBalFlow Product Product Sold
ProductGroup P_ActualPlanBalFlow ProductGroup Product Sold Group
SoldProduct P_ActualPlanBalFlow SoldProduct Product Sold
SoldProductGroup P_ActualPlanBalFlow SoldProductGroup Product Sold Group
Customer P_ActualPlanBalFlow Customer Sold-to Party
CustomerGroup P_ActualPlanBalFlow CustomerGroup Customer Group
Supplier P_ActualPlanBalFlow Supplier Supplier
OrderID P_ActualPlanBalFlow OrderID Order ID
SalesDocument P_ActualPlanBalFlow SalesDocument SD Document
GlobalCurrency P_ActualPlanBalFlow GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency P_ActualPlanBalFlow AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy P_ActualPlanBalFlow FixedAmountInGlobalCrcy
InvertedAmountInGlobalCurrency
KslwoBCF P_ActualPlanBalFlow KslwoBCF
KslonlyBCF P_ActualPlanBalFlow KslonlyBCF
_GlobalCurrency P_ActualPlanBalFlow _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_GLAcctFlowSemTagDateFunc.
-- 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_GLAcctFlowSemTagDateFunc AS
SELECT
  I_SemTagGLAccount.GLAccountHierarchy AS GLAccountHierarchy,
  P_ActualPlanBalFlow.ActualPlanCode AS ActualPlanCode,
  P_ActualPlanBalFlow.PlanningCategory AS PlanningCategory,
  P_ActualPlanBalFlow.Ledger AS Ledger,
  P_ActualPlanBalFlow.CompanyCode AS CompanyCode,
  P_ActualPlanBalFlow.DateFunction AS DateFunction,
  P_ActualPlanBalFlow.FiscalYearPeriod AS FiscalYearPeriod,
  P_ActualPlanBalFlow.GLAccountFlowType AS GLAccountFlowType,
  P_ActualPlanBalFlow.FiscalYearVariant AS FiscalYearVariant,
  P_ActualPlanBalFlow.LedgerFiscalYear AS LedgerFiscalYear,
  P_ActualPlanBalFlow.FiscalQuarter AS FiscalQuarter,
  P_ActualPlanBalFlow.FiscalYearQuarter AS FiscalYearQuarter,
  P_ActualPlanBalFlow.FiscalPeriod AS FiscalPeriod,
  P_ActualPlanBalFlow.ChartOfAccounts AS ChartOfAccounts,
  P_ActualPlanBalFlow.GLAccount AS GLAccount,
  P_ActualPlanBalFlow.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_ActualPlanBalFlow.ControllingArea AS ControllingArea,
  P_ActualPlanBalFlow.CostCenter AS CostCenter,
  P_ActualPlanBalFlow.ProfitCenter AS ProfitCenter,
  P_ActualPlanBalFlow.FunctionalArea AS FunctionalArea,
  P_ActualPlanBalFlow.BusinessArea AS BusinessArea,
  P_ActualPlanBalFlow.Segment AS Segment,
  P_ActualPlanBalFlow.Product AS Product,
  P_ActualPlanBalFlow.ProductGroup AS ProductGroup,
  P_ActualPlanBalFlow.SoldProduct AS SoldProduct,
  P_ActualPlanBalFlow.SoldProductGroup AS SoldProductGroup,
  P_ActualPlanBalFlow.Customer AS Customer,
  P_ActualPlanBalFlow.CustomerGroup AS CustomerGroup,
  P_ActualPlanBalFlow.Supplier AS Supplier,
  P_ActualPlanBalFlow.OrderID AS OrderID,
  P_ActualPlanBalFlow.SalesDocument AS SalesDocument,
  P_ActualPlanBalFlow.GlobalCurrency AS GlobalCurrency,
  P_ActualPlanBalFlow.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  P_ActualPlanBalFlow.FixedAmountInGlobalCrcy AS FixedAmountInGlobalCrcy,
  cast(( P_ActualPlanBalFlow.AmountInGlobalCurrency * -1 ) as fis_ksl_inverted ) AS InvertedAmountInGlobalCurrency,
  P_ActualPlanBalFlow.KslwoBCF AS KslwoBCF,
  P_ActualPlanBalFlow.KslonlyBCF AS KslonlyBCF,
  P_ActualPlanBalFlow._GlobalCurrency AS _GlobalCurrency
FROM P_ActualPlanBalFlow
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