P_GLAcctFlowSemTagDateFunc

P_GLAcctFlowSemTagDateFunc | view: PFIACTPLNBFDF | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, ACDOCA, ACDOCP, T004, T001, TKA02, T009, SKA1, HRRP_FSV_DIR, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
GLAccountHierarchy FK Financial Statement Version
ActualPlanCode Actual Plan Code Show values
PlanningCategory Plan Category
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
DateFunction Relative Date Function ID
FiscalYearPeriod Fiscal Year Period
GLAccountFlowType G/L Account Flow Type Show values
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
InvertedAmountInGlobalCurrency Inverted Amount in Global Currency
KslwoBCF Amount in Global Currency
KslonlyBCF Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
ActualPlanCode Actual Plan Code Show values
GLAccountFlowType G/L Account Flow Type Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
GLAccountTypeFlowType G/L Account Flow Type For G/L Account Type Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalPeriod Fiscal Period POPER
HierarchyNode Hierarchy node
Master Data Relations Join Conditions
Business Area
  • Business Area
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.BUSINESSAREA == TGSB.GSBER
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.CHARTOFACCOUNTS == T004.KTOPL
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == T004.MANDT
Company Code
  • Client
  • Company Code
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == T001.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.COMPANYCODE == T001.BUKRS
Controlling Area
  • Controlling Area
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.CONTROLLINGAREA == TKA01.KOKRS
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • Client
  • Cost Center
  • ?
  • P_GLACCTFLOWSEMTAGDATEFUNC.CONTROLLINGAREA == CSKS.KOKRS
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == CSKS.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.COSTCENTER == CSKS.KOSTL
  • P_GLACCTFLOWSEMTAGDATEFUNC.[column in domain "DATBI"] == CSKS.DATBI
Customer Number
  • Customer Number
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.CUSTOMER == KNA1.KUNNR
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == KNA1.MANDT
Customer Group
  • Client
  • Customer Group
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == T151.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.CUSTOMERGROUP == T151.KDGRP
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.FISCALYEARVARIANT == T009.PERIV
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == T009.MANDT
Functional Area
  • Client
  • Functional Area
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == TFKB.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • G/L Account
  • Client
  • Company Code
  • P_GLACCTFLOWSEMTAGDATEFUNC.GLACCOUNT == SKB1.SAKNR
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == SKB1.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == TCURC.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Product Number
  • Product Number
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.PRODUCT == MARA.MATNR
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == MARA.MANDT
Product Group
  • Client
  • Product Group
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == T023.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.PRODUCTGROUP == T023.MATKL
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • P_GLACCTFLOWSEMTAGDATEFUNC.CONTROLLINGAREA == CEPC.KOKRS
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == CEPC.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.[column in domain "DATBI"] == CEPC.DATBI
  • P_GLACCTFLOWSEMTAGDATEFUNC.PROFITCENTER == CEPC.PRCTR
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.SEGMENT == FAGL_SEGM.SEGMENT
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == FAGL_SEGM.MANDT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Product Sold
  • Client
  • Product Sold
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == MARA.MANDT
  • P_GLACCTFLOWSEMTAGDATEFUNC.SOLDPRODUCT == MARA.MATNR
Product Sold Group
  • Product Sold Group
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.SOLDPRODUCTGROUP == T023.MATKL
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == T023.MANDT
Supplier
  • Supplier
  • Client
  • P_GLACCTFLOWSEMTAGDATEFUNC.SUPPLIER == LFA1.LIFNR
  • P_GLACCTFLOWSEMTAGDATEFUNC.MANDT == LFA1.MANDT