C_ProjectQ2201

Projects Actuals | view: CFIPROJECTQ2201 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting

Tables used: SCAL_TT_DATE, ACDOCA, BKPF, MARA, T003, T003T, TGSB, TGSBT, T004, T001, TKA02, TKA01, CSKR, CSKR, CSKV, CSKS, CSLA, CSLA, CSLT, CSKS, CSKT, T005, T005T, KNA1, T151, T151T, TVTW, TVTWT, TSPA, TSPAT, TFKB, TFKBT, SKA1, T880, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, T023T, MAKT, T001W, MARA, T023T, T023, MAKT, CEPC, CEPC, CEPCT, PROJ, T171, T171T, TVKO, TVKOT, T000, FAGL_SEGM, FAGL_SEGMT, LFA1, T016T, PRPS, SKAT, T004, FINSC_ACTVE_APPL, FINSC_LD_CMP, FINSC_LEDGER_REP, FINSC_FISC_DATE

🔑 Keys
💰 Amounts (4)
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (2)
Other (26)
🔗 Relations (27)

Column Name	Description

Column Name	Description
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency	Amount in Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency	Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency	Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency	Amount in Object Currency

Column Name	Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity	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
TimeSheetOvertimeCategory	Overtime Category	CATS_OVERTIME_CATEGORY
PartnerProject	Partner Project	FIS_PROJECT
PartnerWBSElement	Partner WBS Element	FIS_WBS
PersonnelNumber	Personnel Number	PERNR
EmployeeFullName	Full Name	TEXT80
CostAnalysisResourceName	Cost Analysis Resource Name	TEXT20
WorkItem	Work Item ID	/CPD/PFP_WORKITEM_ID
CalendarYearMonth	Year Month	NUM6
CalendarYearQuarter	Year Quarter	NUM5
CalendarYearWeek	Year Week	NUM6

Master Data Relations	Join Conditions
Billable Control Billable Control Client	`C_PROJECTQ2201.BILLABLECONTROL == TBMOT.BEMOT` `C_PROJECTQ2201.MANDT == TBMOT.MANDT`
Business Transaction Type Business Transaction Type Client	`C_PROJECTQ2201.BUSINESSTRANSACTIONTYPE == FINSC_CUSTBTTYPE.CBTTYPE` `C_PROJECTQ2201.MANDT == FINSC_CUSTBTTYPE.MANDT`
Chart of Accounts Chart of Accounts Client	`C_PROJECTQ2201.CHARTOFACCOUNTS == T004.KTOPL` `C_PROJECTQ2201.MANDT == T004.MANDT`
Company Code Company Code Client	`C_PROJECTQ2201.COMPANYCODE == T001.BUKRS` `C_PROJECTQ2201.MANDT == T001.MANDT`
Company Code Currency Company Code Currency Client	`C_PROJECTQ2201.COMPANYCODECURRENCY == TCURC.WAERS` `C_PROJECTQ2201.MANDT == TCURC.MANDT`
CO Object Currency CO Object Currency Client	`C_PROJECTQ2201.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS` `C_PROJECTQ2201.MANDT == TCURC.MANDT`
Cost Analysis Resource ? ? Cost Analysis Resource Client	`C_PROJECTQ2201.[column in domain "DATBI"] == CSKR.DATBI` `C_PROJECTQ2201.[column in domain "KOKRS"] == CSKR.KOKRS` `C_PROJECTQ2201.COSTANALYSISRESOURCE == CSKR.RESRC` `C_PROJECTQ2201.MANDT == CSKR.MANDT`
Cost Source Unit Cost Source Unit Client	`C_PROJECTQ2201.COSTSOURCEUNIT == T006.MSEHI` `C_PROJECTQ2201.MANDT == T006.MANDT`
Customer Number Customer Number Client	`C_PROJECTQ2201.CUSTOMER == KNA1.KUNNR` `C_PROJECTQ2201.MANDT == KNA1.MANDT`
Fiscal Year Variant Fiscal Year Variant Client	`C_PROJECTQ2201.FISCALYEARVARIANT == T009.PERIV` `C_PROJECTQ2201.MANDT == T009.MANDT`
Functional Area Functional Area Client	`C_PROJECTQ2201.FUNCTIONALAREA == TFKB.FKBER` `C_PROJECTQ2201.MANDT == TFKB.MANDT`
G/L Account G/L Account Company Code Client	`C_PROJECTQ2201.GLACCOUNT == SKB1.SAKNR` `C_PROJECTQ2201.COMPANYCODE == SKB1.BUKRS` `C_PROJECTQ2201.MANDT == SKB1.MANDT`
Global Currency Global Currency Client	`C_PROJECTQ2201.GLOBALCURRENCY == TCURC.WAERS` `C_PROJECTQ2201.MANDT == TCURC.MANDT`
Material Number Material Number Product Number Client	`C_PROJECTQ2201.MATERIAL == MARA.MATNR` `C_PROJECTQ2201.PRODUCT == MARA.MATNR` `C_PROJECTQ2201.MANDT == MARA.MANDT`
Origin Profit Center ? ? Client Origin Profit Center	`C_PROJECTQ2201.[column in domain "DATBI"] == CEPC.DATBI` `C_PROJECTQ2201.[column in domain "KOKRS"] == CEPC.KOKRS` `C_PROJECTQ2201.MANDT == CEPC.MANDT` `C_PROJECTQ2201.ORIGINPROFITCENTER == CEPC.PRCTR`
Company ID of Trading Partner Company ID of Trading Partner Client	`C_PROJECTQ2201.PARTNERCOMPANY == T880.RCOMP` `C_PROJECTQ2201.MANDT == T880.MANDT`
Partner Cost Center ? ? Partner Cost Center Client	`C_PROJECTQ2201.[column in domain "DATBI"] == CSKS.DATBI` `C_PROJECTQ2201.[column in domain "KOKRS"] == CSKS.KOKRS` `C_PROJECTQ2201.PARTNERCOSTCENTER == CSKS.KOSTL` `C_PROJECTQ2201.MANDT == CSKS.MANDT`
Partner Cost Center Activity Type ? ? Partner Cost Center Activity Type Client	`C_PROJECTQ2201.[column in domain "DATBI"] == CSLA.DATBI` `C_PROJECTQ2201.[column in domain "KOKRS"] == CSLA.KOKRS` `C_PROJECTQ2201.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR` `C_PROJECTQ2201.MANDT == CSLA.MANDT`
Partner Functional Area Partner Functional Area Client	`C_PROJECTQ2201.PARTNERFUNCTIONALAREA == TFKB.FKBER` `C_PROJECTQ2201.MANDT == TFKB.MANDT`
Partner Order Partner Order Client	`C_PROJECTQ2201.PARTNERORDER == AUFK.AUFNR` `C_PROJECTQ2201.MANDT == AUFK.MANDT`
Partner Profit Center ? ? Partner Profit Center Client	`C_PROJECTQ2201.[column in domain "DATBI"] == CEPC.DATBI` `C_PROJECTQ2201.[column in domain "KOKRS"] == CEPC.KOKRS` `C_PROJECTQ2201.PARTNERPROFITCENTER == CEPC.PRCTR` `C_PROJECTQ2201.MANDT == CEPC.MANDT`
Product Number Material Number Product Number Client	`C_PROJECTQ2201.MATERIAL == MARA.MATNR` `C_PROJECTQ2201.PRODUCT == MARA.MATNR` `C_PROJECTQ2201.MANDT == MARA.MANDT`
Profit Center ? ? Profit Center Client	`C_PROJECTQ2201.[column in domain "DATBI"] == CEPC.DATBI` `C_PROJECTQ2201.[column in domain "KOKRS"] == CEPC.KOKRS` `C_PROJECTQ2201.PROFITCENTER == CEPC.PRCTR` `C_PROJECTQ2201.MANDT == CEPC.MANDT`
Segment for Segmental Reporting Segment for Segmental Reporting Client	`C_PROJECTQ2201.SEGMENT == FAGL_SEGM.SEGMENT` `C_PROJECTQ2201.MANDT == FAGL_SEGM.MANDT`
Sold Material Sold Material Product Sold Client	`C_PROJECTQ2201.SOLDMATERIAL == MARA.MATNR` `C_PROJECTQ2201.SOLDPRODUCT == MARA.MATNR` `C_PROJECTQ2201.MANDT == MARA.MANDT`
Product Sold Sold Material Product Sold Client	`C_PROJECTQ2201.SOLDMATERIAL == MARA.MATNR` `C_PROJECTQ2201.SOLDPRODUCT == MARA.MATNR` `C_PROJECTQ2201.MANDT == MARA.MANDT`
Transaction Currency Transaction Currency Client	`C_PROJECTQ2201.TRANSACTIONCURRENCY == TCURC.WAERS` `C_PROJECTQ2201.MANDT == TCURC.MANDT`