C_GLAccountLineItemSemTag

G/L Line Item with Semantic Tag - Query | view: CFIGLACCTLITST | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, PROJ, HRRP_FSV_DIR, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
GLAccountHierarchy FK Financial Statement Version
CompanyCode FK Company Code
LedgerFiscalYear Ledger Fiscal Year
Ledger FK Ledger in General Ledger Accounting
Column Name Description
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
RevenueAmountInCompanyCodeCrcy Revenue Amount in Company Code Currency
RevenueInGlobalCurrency Revenue Amount in Global Currency
GrossRevenueAmtInCCCrcy Gross Revenue
RecognizedRevnAmtInCCCrcy Recognized Revenue
RecognizedRevnAmtInGlobCrcy Recognized Revenue
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment
RevenueAdjustAmtInGlobCrcy Revenue Adjustment
DeferredRevenueAmtInCCCrcy Deferred Revenue
AccruedRevenueAmtInCCCrcy Accrued Revenue
RecognizableRevenueAmtInCCCrcy Actual Revenue
RecognizableRevnAmtInGlobCrcy Actual Revenue
BilledRevenueAmtInCoCodeCrcy Actual Revenue
BilledRevenueAmtInGlobCrcy Actual Revenue
UnbilledRevnInCoCodeCrcy Unbilled Revenue
RecognizedMarginAmtInCCCrcy Recognized Margin
MnlContrAccrPnLItmAmtInCCCrcy Manual Contract Accruals Income Statement in CCCrcy
CostAmountInCompanyCodeCrcy Cost Amount in Company Code Currency
CostOfGoodsSoldAmtInGlobCrcy Cost of Goods Sold - Total
FxdCOGSAmtInGlobCrcy Cost of Goods Sold - Fixed
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
SalesDeductionAmountInGlobCrcy Sales Deduction
SalesDeductionAmtInCoCodeCrcy Sales Deduction
PriceDifferenceAmtInGlobCrcy Price Differences
AdminOverheadAmtInGlobCrcy Administration Overhead
SalesOverheadAmtInGlobCrcy Sales Overhead
MarketingOverheadAmtInGlobCrcy Marketing Overhead
RnDOverheadAmtInGlobCrcy Research and Development Overhead
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
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
VarblCOGSAmtInGlobCrcy Cost of Goods Sold - Variable
ContrbnMargin1AmtInGlobCrcy Contribution Margin I
ContrbnMargin2AmtInGlobCrcy Contribution Margin II
ContrbnMargin3AmtInGlobCrcy Contribution Margin III
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
AssetLiabilityAmtInCCCrcy Asset/Liability Amount in Company Code Currency
AmountInCompanyCodeCurrency Amount in Company Code Currency
AmountInTransactionCurrency Amount in Transaction Currency
AmountInGlobalCurrency Amount in Global Currency
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AmountInFunctionalCurrency Amount in Functional Currency
DebitAmountInFunctionalCrcy Debit Amount in Functional Currency
CreditAmountInFunctionalCrcy Credit Amount in Functional Currency
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
BilledValnQtyInCostSourceUnit Billed Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
Project Project FIS_PROJECT
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
AccountingDocument Journal Entry BELNR
RecognizedMarginPercent null
FiscalYear Fiscal Year GJAHR
Master Data Relations Join Conditions
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.CHARTOFACCOUNTS == T004.KTOPL
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.COMPANYCODE == T001.BUKRS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.COMPANYCODECURRENCY == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.CONTROLLINGAREA == TKA01.KOKRS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Controlling Area
  • Cost Center
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.[column in domain "DATBI"] == CSKS.DATBI
  • C_GLACCOUNTLINEITEMSEMTAG.CONTROLLINGAREA == CSKS.KOKRS
  • C_GLACCOUNTLINEITEMSEMTAG.COSTCENTER == CSKS.KOSTL
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == CSKS.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FISCALYEARVARIANT == T009.PERIV
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == T009.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Functional Area
  • Functional Area
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FUNCTIONALAREA == TFKB.FKBER
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TFKB.MANDT
Functional Currency
  • Functional Currency
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.FUNCTIONALCURRENCY == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.GLACCOUNT == SKB1.SAKNR
  • C_GLACCOUNTLINEITEMSEMTAG.COMPANYCODE == SKB1.BUKRS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.GLOBALCURRENCY == TCURC.WAERS
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.[column in domain "DATBI"] == CEPC.DATBI
  • C_GLACCOUNTLINEITEMSEMTAG.CONTROLLINGAREA == CEPC.KOKRS
  • C_GLACCOUNTLINEITEMSEMTAG.PROFITCENTER == CEPC.PRCTR
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_GLACCOUNTLINEITEMSEMTAG.SEGMENT == FAGL_SEGM.SEGMENT
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == FAGL_SEGM.MANDT
Semantic Tag of a Hierarchy Node
  • Semantic Tag of a Hierarchy Node
  • Client
Transaction Currency
  • Client
  • Transaction Currency
  • C_GLACCOUNTLINEITEMSEMTAG.MANDT == TCURC.MANDT
  • C_GLACCOUNTLINEITEMSEMTAG.TRANSACTIONCURRENCY == TCURC.WAERS