I_GLAcctFlowSemTagByDateFuncC

GL Account Flow by Date Function | view: IFIACTPLNBFDF | TRAN | Extraction: Not supported | Component: Information System
Column Name Description
GLAccountHierarchy FK Financial Statement Version
DateFunction Relative Date Function ID
PlanningCategory Plan Category
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
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
RevenueInGlobalCurrency Revenue Amount in Global Currency
RevenueAdjustAmtInGlobCrcy Revenue Adjustment
RecognizableRevnAmtInGlobCrcy Actual Revenue
BilledRevenueAmtInGlobCrcy Actual Revenue
FxdCOGSAmtInGlobCrcy Cost of Goods Sold - Fixed
SalesDeductionAmountInGlobCrcy Sales Deduction
PriceDifferenceAmtInGlobCrcy Price Differences
AdminOverheadAmtInGlobCrcy Administration Overhead
SalesOverheadAmtInGlobCrcy Sales Overhead
MarketingOverheadAmtInGlobCrcy Marketing Overhead
RnDOverheadAmtInGlobCrcy Research and Development Overhead
VarblCOGSAmtInGlobCrcy Cost of Goods Sold - Variable
ContrbnMargin1AmtInGlobCrcy Contribution Margin I
ContrbnMargin2AmtInGlobCrcy Contribution Margin II
ContrbnMargin3AmtInGlobCrcy Contribution Margin III
CurrentAssetAmtInGlobCrcy Current Asset Amount In Global Currency
CurrentLiabilityAmtInGlobCrcy Current Liability Amount in Global Currency
AssetAmtInGlobCrcy Asset Amount in Global Currency
LiabilityEquityAmtInGlobCrcy Liability and Equity Amount In Global Currency
CostOfGoodsSoldAmtInGlobCrcy Cost Of Goods Sold Amount In Global Currency
GrossRevenueAmtInGlobCrcy Gross Revenue Amount in Global Currency
RecognizedRevnAmtInGlobCrcy Recognized Revenue Amount In Global Currency
NetIncomeAmtInGlobCrcy Net Income Amount in Global Currency
OpgExpnInGlobCrcy Operating Expense Amount in Global Currency
OthOpgExpnInGlobCrcy Other Operating Expense Amount in Global Currency
StrtgInventoryAmtInGlobCrcy Starting Inventory Amount in Global Currency
ChgsInventoryAmtInGlobCrcy Changes of Inventory Amount in Global Currency
InventoryAmtInGlobCrcy Inventory Amount in Global Currency
IncomeTaxAmtInGlobCrcy Income Tax Amount in Global Currency
InterestAmtInGlobCrcy Interest Amount in Global Currency
TngblAstDeprAmtInGlobCrcy Tangible Asset Depreciation Amount in Global Currency
IntngblAssetAmtznAmtInGlobCrcy Intangible Asset Amortization Amount in Global Currency
FxdAssetRtrmtAmtInGlobCrcy Fixed Asset Retirement Amount in Global Currency
ChgsProvisionAmtInGlobCrcy Changes Provision Amount in Global Currency
ProvisionAmtInGlobCrcy Provisions Amount in Global Currency
ChgsAcctsRblAmtInGlobCrcy Changes of Accounts Receivable Amount in Global Currency
AcctsRblAmtInGlobCrcy Accounts Receivable Amount in Global Currency
ChgsAcctsOthRblAmtInGlobCrcy Changes of Accounts Other Receivable Amount in Global Crcy
AcctsOthRblAmtInGlobCrcy Accounts Other Receivables Amount in Global Currency
ChgsAcctsPyblAmtInGlobCrcy Changes of Accounts Payable Amount in Global Currency
AcctsPyblAmtInGlobCrcy Accounts Payable Amount in Global Currency
ChgsAcctsOthPyblAmtInGlobCrcy Changes of Accounts Other Payable Amount in Global Crcy
AcctsOthPyblAmtInGlobCrcy Accounts Other Payable Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
GLAccountFlowType G/L Account Flow Type Show values
ActualPlanCode Actual Plan Code 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
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.BUSINESSAREA == TGSB.GSBER
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == TGSB.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.CHARTOFACCOUNTS == T004.KTOPL
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.COMPANYCODE == T001.BUKRS
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == T001.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.CONTROLLINGAREA == TKA01.KOKRS
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • Controlling Area
  • ?
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.COSTCENTER == CSKS.KOSTL
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.CONTROLLINGAREA == CSKS.KOKRS
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.[column in domain "DATBI"] == CSKS.DATBI
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == CSKS.MANDT
Customer Number
  • Customer Number
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.CUSTOMER == KNA1.KUNNR
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.CUSTOMERGROUP == T151.KDGRP
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == T151.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.FISCALYEARVARIANT == T009.PERIV
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == T009.MANDT
Functional Area
  • Functional Area
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.FUNCTIONALAREA == TFKB.FKBER
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == TFKB.MANDT
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.COMPANYCODE == SKB1.BUKRS
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == SKB1.MANDT
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.GLACCOUNT == SKB1.SAKNR
Global Currency
  • Client
  • Global Currency
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == TCURC.MANDT
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Client
Profit Center
  • Profit Center
  • Controlling Area
  • ?
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.PROFITCENTER == CEPC.PRCTR
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.CONTROLLINGAREA == CEPC.KOKRS
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.[column in domain "DATBI"] == CEPC.DATBI
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == FAGL_SEGM.MANDT
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.SEMANTICTAG == FINSC_SEM_TAG.FINS_SEM_TAG
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == FINSC_SEM_TAG.MANDT
Product Sold
  • Product Sold
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.SOLDPRODUCT == MARA.MATNR
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == MARA.MANDT
Product Sold Group
  • Client
  • Product Sold Group
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == T023.MANDT
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.SOLDPRODUCTGROUP == T023.MATKL
Supplier
  • Supplier
  • Client
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.SUPPLIER == LFA1.LIFNR
  • I_GLACCTFLOWSEMTAGBYDATEFUNCC.MANDT == LFA1.MANDT