I_GLAcctLineItmSubLdgrItmTypeC

G/L Account Line Item based on SubLedger Item Type - Cube | view: IGLSUBLDGITP | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, ACDOCA, FINSC_LEDGER_REP
Column Name Description
Ledger FK Ledger in General Ledger Accounting
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
SemanticTag Semantic Tag of a Hierarchy Node
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
InptPriceVarcAmtInCoCodeCrcy Input Price Variance Amount in Company Code Currency
InptQtyVarcAmtInCoCodeCrcy Input Quantity Variance Amount in Company Code Currency
RsceUsgeVarcAmtInCoCodeCrcy Resource Usage Variance Amount in Company Code Currency
LotSizeVarcAmtInCoCodeCrcy Lot Size Variance Amount in Company Code Currency
InputRmngVarcAmtInCoCodeCrcy Input Remaining Variance Amount in Company Code Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
InptPriceVarcAmtInGlobCrcy Input Price Variance Amount in Global Currency
InptQtyVarcAmtInGlobCrcy Input Quantity Variance Amount in Global Currency
RsceUsgeVarcAmtInGlobCrcy Resource Usage Variance Amount in Global Currency
LotSizeVarcAmtInGlobCrcy Lot Size Variance Amount in Global Currency
InputRmngVarcAmtInGlobCrcy Input Remaining Variance Amount in Global Currency
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
SalesOrderItem Sales Order Item POSNR
SalesDocumentItem Sales Document Item POSNR
ConditionContract Condition Contract WCB_COCO_NUM
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
OrderType Order Type AUFART
Project Project FIS_PROJECT_NO_CONV
WBSElement WBS Element FIS_WBS_NO_CONV
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.BASEUNIT == T006.MSEHI
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T006.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.BILLTOPARTY == KNA1.KUNNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == KNA1.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Company Code
  • Company Code
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.COMPANYCODE == T001.BUKRS
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TCURC.MANDT
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.CONTROLLINGAREA == TKA01.KOKRS
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TKA01.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.COSTSOURCEUNIT == T006.MSEHI
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T006.MANDT
Customer Number
  • Customer Number
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.CUSTOMER == KNA1.KUNNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.CUSTOMERGROUP == T151.KDGRP
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TVTW.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TCURC.MANDT
Functional Area
  • Functional Area
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.FUNCTIONALAREA == TFKB.FKBER
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.GLACCOUNT == SKB1.SAKNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.COMPANYCODE == SKB1.BUKRS
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TCURC.MANDT
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.LEDGER == FINSC_LEDGER.RLDNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == FINSC_LEDGER.MANDT
Order ID
  • Order ID
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.ORDERID == AUFK.AUFNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.ORGANIZATIONDIVISION == TSPA.SPART
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TSPA.MANDT
Plant
  • Plant
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.PLANT == T001W.WERKS
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T001W.MANDT
Profit Center
  • ?
  • Controlling Area
  • Profit Center
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.[column in domain "DATBI"] == CEPC.DATBI
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.CONTROLLINGAREA == CEPC.KOKRS
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.PROFITCENTER == CEPC.PRCTR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == CEPC.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.PROJECTNETWORK == AUFK.AUFNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == AUFK.MANDT
Sales District
  • Sales District
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SALESDISTRICT == T171.BZIRK
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SALESORGANIZATION == TVKO.VKORG
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SEGMENT == FAGL_SEGM.SEGMENT
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SHIPTOPARTY == KNA1.KUNNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SOLDPRODUCT == MARA.MATNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SOLDPRODUCTGROUP == T023.MATKL
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == T023.MANDT
Source Ledger
  • Ledger in General Ledger Accounting
  • Source Ledger
  • Client
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.LEDGER == FINSC_LEDGER.RLDNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.SOURCELEDGER == FINSC_LEDGER.RLDNR
  • I_GLACCTLINEITMSUBLDGRITMTYPEC.MANDT == FINSC_LEDGER.MANDT
Subledger-Specific Line Item Type I_GLACCTLINEITMSUBLDGRITMTYPEC.SUBLEDGERACCTLINEITEMTYPE == FINSTS_SLALITTY.SLALITTYPE