C_Profitability_Q0001

Project Profitability | view: CFIPROFQ0001 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, PRTE, ACDOCA, FAAC_KFCSET_SPEC, FAAC_KFCT, BUT0ID, BUT000, T004, SKA1, PROJ, HRRP_FSV_DIR, PRPS, PRPS, SKAT, T004, FINSC_HRRP2SEMTA, HRRP_NODE, FINSC_HRRP2SEMTA, HRRP_NODE, FAAC_KFC_SPEC, FINSC_LEDGER_REP, FINSC_FISC_DATE
Column Name Description
Column Name Description
BilledRevenueAmtInCoCodeCrcy Actual Revenue
RecognizableCostAmtInCCCrcy Actual Cost
RecognizedRevnAmtInCCCrcy Recognized Revenue
RecognizedCOGSAmtInCCCrcy Recognized COS
RecognizedMarginAmtInCCCrcy Recognized Margin
AssetLiabilityAmtInCCCrcy Asset/Liability Amount in Company Code Currency
RevenueAdjustmentAmtInCCCrcy Revenue Adjustment
COGSAdjustmentAmtInCCCrcy COS Adjustment
DeferredCOGSAmtInCCCrcy Deferred COS
DeferredRevenueAmtInCCCrcy Deferred Revenue
AccruedRevenueAmtInCCCrcy Accrued Revenue
AccruedCOGSAmtInCCCrcy Accrued COS
Reserves Reserves
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Project Project FIS_PROJECT
WBSElement Work Breakdown Structure Element (WBS Element) PS_POSID
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
EmployeeFullName Full Name TEXT80
PersonnelNumber Personnel Number PERNR
GLAccountLongName G/L Account Long Text TEXT50
FiscalYearPeriod Fiscal Year Period
DocumentItemText Item Text TEXT50
MarginInPct Margin in Percent REB_PERC
Master Data Relations Join Conditions
Billable Control
  • Billable Control
  • Client
  • C_PROFITABILITY_Q0001.BILLABLECONTROL == TBMOT.BEMOT
  • C_PROFITABILITY_Q0001.MANDT == TBMOT.MANDT
Business Transaction Type
  • Business Transaction Type
  • Client
Company Code
  • Company Code
  • Client
  • C_PROFITABILITY_Q0001.COMPANYCODE == T001.BUKRS
  • C_PROFITABILITY_Q0001.MANDT == T001.MANDT
Cost Analysis Resource
  • Cost Analysis Resource
  • ?
  • ?
  • Client
  • C_PROFITABILITY_Q0001.COSTANALYSISRESOURCE == CSKR.RESRC
  • C_PROFITABILITY_Q0001.[column in domain "DATBI"] == CSKR.DATBI
  • C_PROFITABILITY_Q0001.[column in domain "KOKRS"] == CSKR.KOKRS
  • C_PROFITABILITY_Q0001.MANDT == CSKR.MANDT
Customer Number
  • Customer Number
  • Client
  • C_PROFITABILITY_Q0001.CUSTOMER == KNA1.KUNNR
  • C_PROFITABILITY_Q0001.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • C_PROFITABILITY_Q0001.CUSTOMERGROUP == T151.KDGRP
  • C_PROFITABILITY_Q0001.MANDT == T151.MANDT
Customer Supplier Industry
  • Customer Supplier Industry
  • Client
  • C_PROFITABILITY_Q0001.CUSTOMERSUPPLIERINDUSTRY == T016.BRSCH
  • C_PROFITABILITY_Q0001.MANDT == T016.MANDT
G/L Account
  • Company Code
  • G/L Account
  • Client
  • C_PROFITABILITY_Q0001.COMPANYCODE == SKB1.BUKRS
  • C_PROFITABILITY_Q0001.GLACCOUNT == SKB1.SAKNR
  • C_PROFITABILITY_Q0001.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Product Sold Group
  • Product Sold Group
  • Client
  • C_PROFITABILITY_Q0001.MATERIALGROUP == T023.MATKL
  • C_PROFITABILITY_Q0001.MANDT == T023.MANDT
Division
  • Division
  • Client
  • C_PROFITABILITY_Q0001.ORGANIZATIONDIVISION == TSPA.SPART
  • C_PROFITABILITY_Q0001.MANDT == TSPA.MANDT
Origin Profit Center
  • ?
  • Origin Profit Center
  • ?
  • Client
  • C_PROFITABILITY_Q0001.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROFITABILITY_Q0001.ORIGINPROFITCENTER == CEPC.PRCTR
  • C_PROFITABILITY_Q0001.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROFITABILITY_Q0001.MANDT == CEPC.MANDT
Profit Center
  • Profit Center
  • ?
  • ?
  • Client
  • C_PROFITABILITY_Q0001.PROFITCENTER == CEPC.PRCTR
  • C_PROFITABILITY_Q0001.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROFITABILITY_Q0001.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_PROFITABILITY_Q0001.MANDT == CEPC.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_PROFITABILITY_Q0001.SALESORGANIZATION == TVKO.VKORG
  • C_PROFITABILITY_Q0001.MANDT == TVKO.MANDT
Semantic Tag of a Hierarchy Node
  • Client
  • Semantic Tag of a Hierarchy Node
Product Sold
  • Product Sold
  • Client
  • C_PROFITABILITY_Q0001.SOLDPRODUCT == MARA.MATNR
  • C_PROFITABILITY_Q0001.MANDT == MARA.MANDT