C_REAcctgObjectPlanActualQ

Real Estate Objects Plan and Actuals Q | view: CREACCOBJPLNACTQ | Extraction: Not supported | Component: Real Estate Controlling
Tables used: SCAL_TT_DATE, AFKO, PRTE, ACDOCA, ACDOCP, T004, T001, TKA02, SKA1, AUFK, PROJ, PRPS, SKAT, 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
Column Name Description
📏 Cost Source Unit (CostSourceUnit):
ValuationQuantity Valuation quantity
ActualValuationQuantity Actual Valuation Quantity
PlanValuationQuantity Plan Valuation Quantity
Column Name Description
SettlementReferenceDate Settlement Reference Date
PostingDate Posting Date
Column Name Description
ControllingDebitCreditCode Controlling Debit Credit Code Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
WBSIsStatisticalWBSElement Indicator: WBS Element is Statistical Account Assignment Show values
Column Name Description Domain name
GLAccountName G/L Account Short Text TEXT20
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
REBusinessEntity RE Business Entity REBDVDMBENO
RealEstateBuilding Real Estate Building REBDVDMBUNO
RealEstateProperty Real Estate Property REBDVDMPRNO
RERentalObject RE Rental Object REBDVDMRONO
RealEstateContract Real Estate Contract RECNVDMCNNR
REServiceChargeKey RE Service Charge Key RESCVDMSCKEY
RESettlementUnitID RE Settlement Unit RESCVDMSUID
AccountingDocument Journal Entry BELNR
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
LedgerFiscalYear Ledger Fiscal Year GJAHR
PlanningCategory Plan Category FCOM_CATEGORY
ProjectExternalID Project External ID FIS_PROJECTEXT_NO_CONV
WBSElementExternalID WBS Element External ID FIS_WBSEXT_NO_CONV
DifferenceAmtInTransCrcy null
TransCrcyDifferencePct null
DifferenceAmtInCoCodeCrcy null
CoCodeCrcyDifferencePct null
DifferenceAmtInGlobalCrcy null
GlobalCrcyDifferencePct null
Master Data Relations Join Conditions
Business Transaction Type
  • Business Transaction Type
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.CHARTOFACCOUNTS == T004.KTOPL
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.COMPANYCODE == T001.BUKRS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == TCURC.MANDT
  • C_REACCTGOBJECTPLANACTUALQ.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.CONTROLLINGAREA == TKA01.KOKRS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == TKA01.MANDT
Cost Center
  • ?
  • Cost Center
  • Controlling Area
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.[column in domain "DATBI"] == CSKS.DATBI
  • C_REACCTGOBJECTPLANACTUALQ.COSTCENTER == CSKS.KOSTL
  • C_REACCTGOBJECTPLANACTUALQ.CONTROLLINGAREA == CSKS.KOKRS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == CSKS.MANDT
Activity Type
  • ?
  • Activity Type
  • Controlling Area
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.[column in domain "DATBI"] == CSLA.DATBI
  • C_REACCTGOBJECTPLANACTUALQ.COSTCTRACTIVITYTYPE == CSLA.LSTAR
  • C_REACCTGOBJECTPLANACTUALQ.CONTROLLINGAREA == CSLA.KOKRS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == CSLA.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.COSTSOURCEUNIT == T006.MSEHI
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == T006.MANDT
Customer Number
  • Customer Number
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.CUSTOMER == KNA1.KUNNR
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == KNA1.MANDT
Customer Group
  • Customer Group
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.CUSTOMERGROUP == T151.KDGRP
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == T151.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.FISCALYEARVARIANT == T009.PERIV
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == T009.MANDT
Functional Area
  • Functional Area
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.FUNCTIONALAREA == TFKB.FKBER
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == TFKB.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.GLACCOUNT == SKB1.SAKNR
  • C_REACCTGOBJECTPLANACTUALQ.COMPANYCODE == SKB1.BUKRS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.GLOBALCURRENCY == TCURC.WAERS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == TCURC.MANDT
Order ID
  • Order ID
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.ORDERID == AUFK.AUFNR
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == AUFK.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.PARTNERCOMPANY == T880.RCOMP
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == T880.MANDT
Profit Center
  • ?
  • Profit Center
  • Controlling Area
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.[column in domain "DATBI"] == CEPC.DATBI
  • C_REACCTGOBJECTPLANACTUALQ.PROFITCENTER == CEPC.PRCTR
  • C_REACCTGOBJECTPLANACTUALQ.CONTROLLINGAREA == CEPC.KOKRS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == CEPC.MANDT
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.SEGMENT == FAGL_SEGM.SEGMENT
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == FAGL_SEGM.MANDT
Transaction Currency
  • Transaction Currency
  • Client
  • C_REACCTGOBJECTPLANACTUALQ.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_REACCTGOBJECTPLANACTUALQ.MANDT == TCURC.MANDT