I_GLAccountFlowSemTag

G/L Account Flow with Semantic Tag | view: IFIGLFLOWST | TRAN | Extraction: Not supported | Component: Information System
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
GrossRevenueAmtInCCCrcy Gross Revenue
RecognizedRevnAmtInCCCrcy Recognized Revenue
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment
DeferredRevenueAmtInCCCrcy Deferred Revenue
AccruedRevenueAmtInCCCrcy Accrued Revenue
RecognizableRevenueAmtInCCCrcy Actual Revenue
BilledRevenueAmtInCoCodeCrcy Actual Revenue
UnbilledRevnInCoCodeCrcy Unbilled Revenue
RecognizedMarginAmtInCCCrcy Recognized Margin
MnlContrAccrPnLItmAmtInCCCrcy Manual Contract Accruals Income Statement in CCCrcy
CostAmountInCompanyCodeCrcy Cost Amount in Company Code Currency
RecognizedCOGSAmtInCCCrcy Recognized COS
COGSAdjustmentAmtInCCCrcy COS Adjustment
DeferredCOGSAmtInCCCrcy Deferred COS
AccruedCOGSAmtInCCCrcy Accrued COS
RecognizableCostAmtInCCCrcy Actual Cost
ImminentLossRsrvAmtInCCCrcy Reserves for Imminent Loss
SalesDeductReserveAmtInCCCrcy Reserves for Anticipated Sales Deductions
UnrlzdCostsReserveAmtInCCCrcy Reserves for Unrealized Costs
MnlContrAccrBalShtAmtInCCCrcy Manual Contract Accruals Balance Sheet in CCCrcy
SalesDeductionAmtInCoCodeCrcy Sales Deduction
AssetAmtInCCCrcy Asset Amount In CompanyCode Currency
LiabilityEquityAmtInCCCrcy Liabilities and Equity Amount In Company Code Currency
NotAssignedAmtInCCCrcy Not Assigned Amount In Company Code Currency
NetResultAmtInCCCrcy Net Result Amount In Company Code Currency
PnLResultAmtInCCCrcy Profit for the Period
GLAcctNetIncomeAmtInCCCrcy Net Income Amount In Company Code Currency
LongTermInvmtAmtInCCCrcy Increase (Decrease) in Long-term Investments
AcctsRblAmtInCCCrcy Increase (Decrease) in Accounts Receivable (Net)
AcctsOthRblAmtInCCCrcy Increase (Decrease) in Accounts Other Receivable (Net)
AcctsPyblAmtInCCCrcy Increase (Decrease) in Accounts Payable (Net)
AcctsOthPyblAmtInCCCrcy Increase (Decrease) in Accounts Other Payables (Net)
ProvisionAmtInCCCrcy Increase/Decrease of Provisions
NotesReceivableAmtInCCCrcy Increase (Decrease) in Notes Receivable
TangibleAstDeprAmtInCCCrcy Depreciation of Tangible Assets
IntngblAssetAmtznAmtInCCCrcy Amortization of Intangible Assets
TangibleAstAmtInCCCrcy Purchase (Sale) of Tangible Assets
IntangibleAstAmtInCCCrcy Purchase (Sale) of Intangible Assets
FixedAssetRtrmtAmtInCCCrcy Gain/Loss from Retirement of Fixed Assets
InventoryAmtInCCCrcy Increase/Decrease of Inventories
CommonStockAmtInCCCrcy Increase (Decrease) in Common Stocks
CashAndCashEqvlntAmtInCCCrcy Change (Increase/ Decrease) in cash and cash equivalents
AssetLiabilityAmtInCCCrcy Asset/Liability Amount in Company Code Currency
OperatingActyCashAmtInCCCrcy Net cash generated from continuing operating activities
InvestingActyCashAmtInCCCrcy Net cash used in continuing investing activities
FinancingActyCashAmtInCCCrcy Net cash generated from financing activities
NetCashAmtInCCCrcy Net Cash Amount In CompanyCode Currency
💲 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
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation Quantity
Column Name Description
ValidityEndDate FK Valid To Date
ValidityStartDate Valid-From Date
PostingDate Posting Date
Column Name Description
ActualPlanCode Actual Plan Code Show values
AccountingDocumentCategory Journal Entry Category Show values
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
GLAccountType Type of a General Ledger Account Show values
GLAccountFlowType G/L Account Flow Type Show values
GLAccountTypeFlowType G/L Account Flow Type For G/L Account Type Show values
IsBalanceSheetAccount Indicator: Account is a balance sheet account? Show values
Column Name Description Domain name
LedgerFiscalYear Ledger Fiscal Year GJAHR
PlanningCategory Plan Category FCOM_CATEGORY
OrderType Order Type AUFART
HierarchyNode Hierarchy node
FiscalPeriod Fiscal Period POPER
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarYearQuarter Year Quarter NUM5
CalendarMonth Calendar Month NUM2
CalendarYearMonth Year Month NUM6
CalendarWeek Calendar Week NUM2
CalendarYearWeek Year Week NUM6
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_GLACCOUNTFLOWSEMTAG.MANDT == T003.MANDT
  • I_GLACCOUNTFLOWSEMTAG.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Asset Class
  • Client
  • Asset Class
  • I_GLACCOUNTFLOWSEMTAG.MANDT == ANKA.MANDT
  • I_GLACCOUNTFLOWSEMTAG.ASSETCLASS == ANKA.ANLKL
Business Area
  • Business Area
  • Client
  • I_GLACCOUNTFLOWSEMTAG.BUSINESSAREA == TGSB.GSBER
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TGSB.MANDT
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_GLACCOUNTFLOWSEMTAG.MANDT == T004.MANDT
  • I_GLACCOUNTFLOWSEMTAG.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_GLACCOUNTFLOWSEMTAG.MANDT == T001.MANDT
  • I_GLACCOUNTFLOWSEMTAG.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TCURC.MANDT
  • I_GLACCOUNTFLOWSEMTAG.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TKA01.MANDT
  • I_GLACCOUNTFLOWSEMTAG.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Controlling Area
  • ?
  • Cost Center
  • I_GLACCOUNTFLOWSEMTAG.MANDT == CSKS.MANDT
  • I_GLACCOUNTFLOWSEMTAG.CONTROLLINGAREA == CSKS.KOKRS
  • I_GLACCOUNTFLOWSEMTAG.[column in domain "DATBI"] == CSKS.DATBI
  • I_GLACCOUNTFLOWSEMTAG.COSTCENTER == CSKS.KOSTL
Cost Source Unit
  • Client
  • Cost Source Unit
  • I_GLACCOUNTFLOWSEMTAG.MANDT == T006.MANDT
  • I_GLACCOUNTFLOWSEMTAG.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Client
  • Customer Number
  • I_GLACCOUNTFLOWSEMTAG.MANDT == KNA1.MANDT
  • I_GLACCOUNTFLOWSEMTAG.CUSTOMER == KNA1.KUNNR
Distribution Channel
  • Client
  • Distribution Channel
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TVTW.MANDT
  • I_GLACCOUNTFLOWSEMTAG.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • I_GLACCOUNTFLOWSEMTAG.MANDT == T009.MANDT
  • I_GLACCOUNTFLOWSEMTAG.FISCALYEARVARIANT == T009.PERIV
Asset Subnumber
  • Client
  • Fixed Asset
  • ?
  • Asset Subnumber
  • I_GLACCOUNTFLOWSEMTAG.MANDT == ANLA.MANDT
  • I_GLACCOUNTFLOWSEMTAG.MASTERFIXEDASSET == ANLA.ANLN1
  • I_GLACCOUNTFLOWSEMTAG.[column in domain "BUKRS"] == ANLA.BUKRS
  • I_GLACCOUNTFLOWSEMTAG.FIXEDASSET == ANLA.ANLN2
Functional Area
  • Client
  • Functional Area
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TFKB.MANDT
  • I_GLACCOUNTFLOWSEMTAG.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_GLACCOUNTFLOWSEMTAG.MANDT == SKB1.MANDT
  • I_GLACCOUNTFLOWSEMTAG.GLACCOUNT == SKB1.SAKNR
  • I_GLACCOUNTFLOWSEMTAG.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TCURC.MANDT
  • I_GLACCOUNTFLOWSEMTAG.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
Order ID
  • Client
  • Order ID
  • I_GLACCOUNTFLOWSEMTAG.MANDT == AUFK.MANDT
  • I_GLACCOUNTFLOWSEMTAG.ORDERID == AUFK.AUFNR
Division
  • Client
  • Division
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TSPA.MANDT
  • I_GLACCOUNTFLOWSEMTAG.ORGANIZATIONDIVISION == TSPA.SPART
Plant
  • Client
  • Plant
  • I_GLACCOUNTFLOWSEMTAG.MANDT == T001W.MANDT
  • I_GLACCOUNTFLOWSEMTAG.PLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • I_GLACCOUNTFLOWSEMTAG.MANDT == MARA.MANDT
  • I_GLACCOUNTFLOWSEMTAG.PRODUCT == MARA.MATNR
Profit Center
  • Profit Center
  • Client
  • Controlling Area
  • ?
  • I_GLACCOUNTFLOWSEMTAG.PROFITCENTER == CEPC.PRCTR
  • I_GLACCOUNTFLOWSEMTAG.MANDT == CEPC.MANDT
  • I_GLACCOUNTFLOWSEMTAG.CONTROLLINGAREA == CEPC.KOKRS
  • I_GLACCOUNTFLOWSEMTAG.[column in domain "DATBI"] == CEPC.DATBI
Sales Organization
  • Client
  • Sales Organization
  • I_GLACCOUNTFLOWSEMTAG.MANDT == TVKO.MANDT
  • I_GLACCOUNTFLOWSEMTAG.SALESORGANIZATION == TVKO.VKORG
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • I_GLACCOUNTFLOWSEMTAG.MANDT == FAGL_SEGM.MANDT
  • I_GLACCOUNTFLOWSEMTAG.SEGMENT == FAGL_SEGM.SEGMENT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Service Document ID
  • Client
  • ?
  • Service Document Type
  • Service Document ID
  • I_GLACCOUNTFLOWSEMTAG.MANDT == FCO_SRVDOC.MANDT
  • I_GLACCOUNTFLOWSEMTAG.[column in domain "FCO_SRVDOC_ITEM_ID"] == FCO_SRVDOC.SERVICE_DOC_ITEM_ID
  • I_GLACCOUNTFLOWSEMTAG.SERVICEDOCUMENTTYPE == FCO_SRVDOC.SERVICE_DOC_TYPE
  • I_GLACCOUNTFLOWSEMTAG.SERVICEDOCUMENT == FCO_SRVDOC.SERVICE_DOC_ID
Service Document Type
  • Client
  • Service Document Type
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Supplier
  • Client
  • Supplier
  • I_GLACCOUNTFLOWSEMTAG.MANDT == LFA1.MANDT
  • I_GLACCOUNTFLOWSEMTAG.SUPPLIER == LFA1.LIFNR
Valuation area
  • Client
  • Valuation area
  • I_GLACCOUNTFLOWSEMTAG.MANDT == T001K.MANDT
  • I_GLACCOUNTFLOWSEMTAG.VALUATIONAREA == T001K.BWKEY