C_ProjectPlanActQ2201

Project Plan Actual | view: CFIPRPLANACT2201 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, MARA, T003, T003T, TGSB, TGSBT, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, T004, T001, TKA02, TKA01, CSKR, CSKV, CSKS, CSLA, CSLT, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, T023, T023T, MAKT, AUFK, T001W, CRTX, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, T016T, PRPS, CRHD, SKAT, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_FISC_DATE, FINSC_PERIOD
Column Name Description
Column Name Description
💲 Transaction Currency (TransactionCurrency):
ActualAmountInTransactionCrcy Amount in Global Currency
PlanAmountInTransactionCrcy Amount in Company Code Currency
💲 Company Code Currency (CompanyCodeCurrency):
ActualAmountInCompanyCodeCrcy Amount in Company Code Currency
PlanAmountInCompanyCodeCrcy Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
ActualAmountInGlobalCurrency Amount in Global Currency
PlanAmountInGlobalCurrency Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
ActualAmountInObjectCurrency Actual Amount in Object Currency
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation quantity
ActualValuationQuantity Actual Valuation Quantity
PlanValuationQuantity Plan Valuation Quantity
Column Name Description
PostingDate Posting Date
ServicesRenderedDate Date on which services are rendered
Column Name Description
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
ControllingDebitCreditCode Controlling Debit Credit Code Show values
Column Name Description Domain name
Project Project FIS_PROJECT
WBSElement WBS Element FIS_WBS
GLAccountName G/L Account Short Text TEXT20
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
CalendarYear Calendar Year NUM4
FiscalPeriod Fiscal Period POPER
FiscalQuarter Fiscal Quarter FINS_FSCALQUARTER
FiscalWeek Fiscal Week FINS_FISCALWEEK
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
FiscalYearQuarter Fiscal Year + Fiscal Quarter FINS_FYEARQUARTER
FiscalYearWeek Fiscal Year + Fiscal Week FINS_FYEARWEEK
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
LedgerFiscalYear Ledger Fiscal Year GJAHR
PartnerProject Partner Project FIS_PROJECT
PartnerWBSElement Partner WBS Element FIS_WBS
PersonnelNumber Personnel Number PERNR
PlanningCategory Plan Category FCOM_CATEGORY
CostAnalysisResourceName Cost Analysis Resource Name TEXT20
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
YearMonth Year Month NUM6
YearQuarter Year Quarter NUM5
YearWeek Year Week NUM6
DifferenceAmtInTransCrcy null
TransCrcyDifferencePct null
DifferenceAmtInCoCodeCrcy null
CoCodeCrcyDifferencePct null
DifferenceAmtInGlobalCrcy null
GlobalCrcyDifferencePct null
Master Data Relations Join Conditions
Billable Control
  • Client
  • Billable Control
  • C_PROJECTPLANACTQ2201.MANDT == TBMOT.MANDT
  • C_PROJECTPLANACTQ2201.BILLABLECONTROL == TBMOT.BEMOT
Business Transaction Type
  • Client
  • Business Transaction Type
Chart of Accounts
  • Client
  • Chart of Accounts
  • C_PROJECTPLANACTQ2201.MANDT == T004.MANDT
  • C_PROJECTPLANACTQ2201.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • C_PROJECTPLANACTQ2201.MANDT == T001.MANDT
  • C_PROJECTPLANACTQ2201.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • C_PROJECTPLANACTQ2201.MANDT == TCURC.MANDT
  • C_PROJECTPLANACTQ2201.COMPANYCODECURRENCY == TCURC.WAERS
CO Object Currency
  • Client
  • CO Object Currency
  • C_PROJECTPLANACTQ2201.MANDT == TCURC.MANDT
  • C_PROJECTPLANACTQ2201.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Analysis Resource
  • ?
  • Client
  • ?
  • Cost Analysis Resource
  • C_PROJECTPLANACTQ2201.[column in domain "DATBI"] == CSKR.DATBI
  • C_PROJECTPLANACTQ2201.MANDT == CSKR.MANDT
  • C_PROJECTPLANACTQ2201.[column in domain "KOKRS"] == CSKR.KOKRS
  • C_PROJECTPLANACTQ2201.COSTANALYSISRESOURCE == CSKR.RESRC
Cost Source Unit
  • Client
  • Cost Source Unit
  • C_PROJECTPLANACTQ2201.MANDT == T006.MANDT
  • C_PROJECTPLANACTQ2201.COSTSOURCEUNIT == T006.MSEHI
Customer Number
  • Customer Number
  • Client
  • C_PROJECTPLANACTQ2201.CUSTOMER == KNA1.KUNNR
  • C_PROJECTPLANACTQ2201.MANDT == KNA1.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_PROJECTPLANACTQ2201.FISCALYEARVARIANT == T009.PERIV
  • C_PROJECTPLANACTQ2201.MANDT == T009.MANDT
Functional Area
  • Client
  • Functional Area
  • C_PROJECTPLANACTQ2201.MANDT == TFKB.MANDT
  • C_PROJECTPLANACTQ2201.FUNCTIONALAREA == TFKB.FKBER
G/L Account
  • Client
  • G/L Account
  • Company Code
  • C_PROJECTPLANACTQ2201.MANDT == SKB1.MANDT
  • C_PROJECTPLANACTQ2201.GLACCOUNT == SKB1.SAKNR
  • C_PROJECTPLANACTQ2201.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • C_PROJECTPLANACTQ2201.MANDT == TCURC.MANDT
  • C_PROJECTPLANACTQ2201.GLOBALCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Product Number
  • Client
  • C_PROJECTPLANACTQ2201.MATERIAL == MARA.MATNR
  • C_PROJECTPLANACTQ2201.PRODUCT == MARA.MATNR
  • C_PROJECTPLANACTQ2201.MANDT == MARA.MANDT
Origin Profit Center
  • ?
  • Client
  • Origin Profit Center
  • ?
  • C_PROJECTPLANACTQ2201.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTPLANACTQ2201.MANDT == CEPC.MANDT
  • C_PROJECTPLANACTQ2201.ORIGINPROFITCENTER == CEPC.PRCTR
  • C_PROJECTPLANACTQ2201.[column in domain "KOKRS"] == CEPC.KOKRS
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • C_PROJECTPLANACTQ2201.MANDT == T880.MANDT
  • C_PROJECTPLANACTQ2201.PARTNERCOMPANY == T880.RCOMP
Partner Cost Center
  • ?
  • Client
  • Partner Cost Center
  • ?
  • C_PROJECTPLANACTQ2201.[column in domain "DATBI"] == CSKS.DATBI
  • C_PROJECTPLANACTQ2201.MANDT == CSKS.MANDT
  • C_PROJECTPLANACTQ2201.PARTNERCOSTCENTER == CSKS.KOSTL
  • C_PROJECTPLANACTQ2201.[column in domain "KOKRS"] == CSKS.KOKRS
Partner Cost Center Activity Type
  • ?
  • Client
  • ?
  • Partner Cost Center Activity Type
  • C_PROJECTPLANACTQ2201.[column in domain "DATBI"] == CSLA.DATBI
  • C_PROJECTPLANACTQ2201.MANDT == CSLA.MANDT
  • C_PROJECTPLANACTQ2201.[column in domain "KOKRS"] == CSLA.KOKRS
  • C_PROJECTPLANACTQ2201.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Partner Functional Area
  • Client
  • Partner Functional Area
  • C_PROJECTPLANACTQ2201.MANDT == TFKB.MANDT
  • C_PROJECTPLANACTQ2201.PARTNERFUNCTIONALAREA == TFKB.FKBER
Partner Order
  • Client
  • Partner Order
  • C_PROJECTPLANACTQ2201.MANDT == AUFK.MANDT
  • C_PROJECTPLANACTQ2201.PARTNERORDER == AUFK.AUFNR
Partner Profit Center
  • ?
  • Partner Profit Center
  • Client
  • ?
  • C_PROJECTPLANACTQ2201.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTPLANACTQ2201.PARTNERPROFITCENTER == CEPC.PRCTR
  • C_PROJECTPLANACTQ2201.MANDT == CEPC.MANDT
  • C_PROJECTPLANACTQ2201.[column in domain "KOKRS"] == CEPC.KOKRS
Product Number
  • Material Number
  • Product Number
  • Client
  • C_PROJECTPLANACTQ2201.MATERIAL == MARA.MATNR
  • C_PROJECTPLANACTQ2201.PRODUCT == MARA.MATNR
  • C_PROJECTPLANACTQ2201.MANDT == MARA.MANDT
Profit Center
  • ?
  • Profit Center
  • Client
  • ?
  • C_PROJECTPLANACTQ2201.[column in domain "DATBI"] == CEPC.DATBI
  • C_PROJECTPLANACTQ2201.PROFITCENTER == CEPC.PRCTR
  • C_PROJECTPLANACTQ2201.MANDT == CEPC.MANDT
  • C_PROJECTPLANACTQ2201.[column in domain "KOKRS"] == CEPC.KOKRS
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • C_PROJECTPLANACTQ2201.MANDT == FAGL_SEGM.MANDT
  • C_PROJECTPLANACTQ2201.SEGMENT == FAGL_SEGM.SEGMENT
Sold Material
  • Client
  • Product Sold
  • Sold Material
  • C_PROJECTPLANACTQ2201.MANDT == MARA.MANDT
  • C_PROJECTPLANACTQ2201.SOLDPRODUCT == MARA.MATNR
  • C_PROJECTPLANACTQ2201.SOLDMATERIAL == MARA.MATNR
Product Sold
  • Client
  • Product Sold
  • Sold Material
  • C_PROJECTPLANACTQ2201.MANDT == MARA.MANDT
  • C_PROJECTPLANACTQ2201.SOLDPRODUCT == MARA.MATNR
  • C_PROJECTPLANACTQ2201.SOLDMATERIAL == MARA.MATNR
Transaction Currency
  • Client
  • Transaction Currency
  • C_PROJECTPLANACTQ2201.MANDT == TCURC.MANDT
  • C_PROJECTPLANACTQ2201.TRANSACTIONCURRENCY == TCURC.WAERS