I_ProfitabilityCube

G/L Account Line Item of Profitability - Cube | view: IPROFITABIC | TRAN | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, PROJ, HRRP_FSV_DIR, PRPS, PRPS, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE
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
BilledRevenueAmtInCoCodeCrcy Billed Revenue Amount in Company Code Currency
SalesDeductionAmtInCoCodeCrcy Sales Deduction Amount in Company Code Currency
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment Amount in Company Code Currency
RecognizedRevnAmtInCCCrcy Recognized Revenue Amount in Company Code Currency
VarblCOGSAmtInCCCrcy COGS - Variable Amount in Company Code Currency
ContrbnMargin1AmtInCoCodeCrcy COGS - Contribution Margin 1 Amount in Company Code Currency
FxdCOGSAmtInCCCrcy COGS - Fixed Amount in Company Code Currency
PriceDifferenceAmtInCCCrcy COGS - Price Differences Amount in Company Code Currency
ContrbnMargin2AmtInCoCodeCrcy COGS - Contribution Margin 2 Amount in Company Code Currency
AdminOverheadAmtInCoCodeCrcy COGS - Administration Overhead Amt in Company Code Currency
SalesOverheadAmtInCoCodeCrcy COGS - Sales Overhead Amount in Company Code Currency
MarketingOvhdAmtInCoCodeCrcy COGS - Marketing Overhead Amount in Company Code Currency
RnDOverheadAmtInCCCrcy COGS - Research and Dev Overhead Amount in Company Code Crcy
ContrbnMargin3AmtInCoCodeCrcy COGS - Contribution Margin 3 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
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
BilledRevenueAmtInGlobCrcy Actual Revenue
SalesDeductionAmountInGlobCrcy Sales Deduction
RevenueAdjustAmtInGlobCrcy Revenue Adjustment
RecognizedRevnAmtInGlobCrcy Recognized Revenue
VarblCOGSAmtInGlobCrcy Cost of Goods Sold - Variable
ContrbnMargin1AmtInGlobCrcy Contribution Margin I
FxdCOGSAmtInGlobCrcy Cost of Goods Sold - Fixed
PriceDifferenceAmtInGlobCrcy Price Differences
ContrbnMargin2AmtInGlobCrcy Contribution Margin II
AdminOverheadAmtInGlobCrcy Administration Overhead
SalesOverheadAmtInGlobCrcy Sales Overhead
MarketingOverheadAmtInGlobCrcy Marketing Overhead
RnDOverheadAmtInGlobCrcy Research and Development Overhead
ContrbnMargin3AmtInGlobCrcy Contribution Margin III
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
📏 Cost Source Unit (CostSourceUnit):
BilledValnQtyInCostSourceUnit Billed Quantity
Column Name Description
Column Name Description
LineIsSemTagCalculated Indicator: Calculated by Semantic Tag Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
SalesDocumentItem Sales Document Item POSNR
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_PROFITABILITYCUBE.BASEUNIT == T006.MSEHI
  • I_PROFITABILITYCUBE.MANDT == T006.MANDT
Bill-to Party
  • Bill-to Party
  • Client
  • I_PROFITABILITYCUBE.BILLTOPARTY == KNA1.KUNNR
  • I_PROFITABILITYCUBE.MANDT == KNA1.MANDT
Company Code
  • Company Code
  • Client
  • I_PROFITABILITYCUBE.COMPANYCODE == T001.BUKRS
  • I_PROFITABILITYCUBE.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_PROFITABILITYCUBE.COMPANYCODECURRENCY == TCURC.WAERS
  • I_PROFITABILITYCUBE.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_PROFITABILITYCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_PROFITABILITYCUBE.MANDT == TKA01.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • I_PROFITABILITYCUBE.COSTSOURCEUNIT == T006.MSEHI
  • I_PROFITABILITYCUBE.MANDT == T006.MANDT
Customer Number
  • Customer Number
  • Client
  • I_PROFITABILITYCUBE.CUSTOMER == KNA1.KUNNR
  • I_PROFITABILITYCUBE.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • I_PROFITABILITYCUBE.CUSTOMERGROUP == T151.KDGRP
  • I_PROFITABILITYCUBE.MANDT == T151.MANDT
Customer or Supplier Country/Region
  • Customer or Supplier Country/Region
  • Client
  • I_PROFITABILITYCUBE.CUSTOMERSUPPLIERCOUNTRY == T005.LAND1
  • I_PROFITABILITYCUBE.MANDT == T005.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • I_PROFITABILITYCUBE.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • I_PROFITABILITYCUBE.MANDT == T016.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • I_PROFITABILITYCUBE.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • I_PROFITABILITYCUBE.MANDT == TVTW.MANDT
Functional Area
  • Functional Area
  • Client
  • I_PROFITABILITYCUBE.FUNCTIONALAREA == TFKB.FKBER
  • I_PROFITABILITYCUBE.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_PROFITABILITYCUBE.GLACCOUNT == SKB1.SAKNR
  • I_PROFITABILITYCUBE.COMPANYCODE == SKB1.BUKRS
  • I_PROFITABILITYCUBE.MANDT == SKB1.MANDT
Global Currency
  • Client
  • Global Currency
  • I_PROFITABILITYCUBE.MANDT == TCURC.MANDT
  • I_PROFITABILITYCUBE.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client
Order ID
  • Order ID
  • Client
  • I_PROFITABILITYCUBE.ORDERID == AUFK.AUFNR
  • I_PROFITABILITYCUBE.MANDT == AUFK.MANDT
Division
  • Division
  • Client
  • I_PROFITABILITYCUBE.ORGANIZATIONDIVISION == TSPA.SPART
  • I_PROFITABILITYCUBE.MANDT == TSPA.MANDT
Plant
  • Plant
  • Client
  • I_PROFITABILITYCUBE.PLANT == T001W.WERKS
  • I_PROFITABILITYCUBE.MANDT == T001W.MANDT
Profit Center
  • Controlling Area
  • ?
  • Profit Center
  • Client
  • I_PROFITABILITYCUBE.CONTROLLINGAREA == CEPC.KOKRS
  • I_PROFITABILITYCUBE.[column in domain "DATBI"] == CEPC.DATBI
  • I_PROFITABILITYCUBE.PROFITCENTER == CEPC.PRCTR
  • I_PROFITABILITYCUBE.MANDT == CEPC.MANDT
Network Number for Account Assignment
  • Network Number for Account Assignment
  • Client
  • I_PROFITABILITYCUBE.PROJECTNETWORK == AUFK.AUFNR
  • I_PROFITABILITYCUBE.MANDT == AUFK.MANDT
Sales District
  • Sales District
  • Client
  • I_PROFITABILITYCUBE.SALESDISTRICT == T171.BZIRK
  • I_PROFITABILITYCUBE.MANDT == T171.MANDT
Sales Organization
  • Sales Organization
  • Client
  • I_PROFITABILITYCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_PROFITABILITYCUBE.MANDT == TVKO.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • I_PROFITABILITYCUBE.SEGMENT == FAGL_SEGM.SEGMENT
  • I_PROFITABILITYCUBE.MANDT == FAGL_SEGM.MANDT
Ship-to Party
  • Ship-to Party
  • Client
  • I_PROFITABILITYCUBE.SHIPTOPARTY == KNA1.KUNNR
  • I_PROFITABILITYCUBE.MANDT == KNA1.MANDT
Product Sold
  • Product Sold
  • Client
  • I_PROFITABILITYCUBE.SOLDPRODUCT == MARA.MATNR
  • I_PROFITABILITYCUBE.MANDT == MARA.MANDT
Product Sold Group
  • Product Sold Group
  • Client
  • I_PROFITABILITYCUBE.SOLDPRODUCTGROUP == T023.MATKL
  • I_PROFITABILITYCUBE.MANDT == T023.MANDT
Source Ledger
  • Source Ledger
  • Ledger in General Ledger Accounting
  • Client