R_ControllingActualLineItem

Internal view for CO actual line item | view: RFICOACTULITEM | TRAN | Extraction: Not supported | Component: Cost Object Controlling
Tables used: ACDOCA
Column Name Description
Ledger FK Ledger in General Ledger Accounting
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Document Number of an Accounting Document
LedgerGLLineItem Six-Character Posting Item for Ledger
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
FixedAmountInGlobalCrcy Fixed Amount in Global Currency
💲 CO Object Currency (ControllingObjectCurrency):
AmountInObjectCurrency Amount in CO Object Currency
💲 Balance Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Balance Transaction Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
📏 Base Unit of Measure (BaseUnit):
Quantity Quantity
📏 Unit of Measure for Valuation Quantity (UnitOfMeasure):
TotalQuantity Valuation quantity
FixedQuantity Fixed valuation quantity
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
Column Name Description
GLAccountType Type of a General Ledger Account Show values
CtrlgOriginClassification Type of a General Ledger Account Show values
OriginCtrlgDebitCreditCode Debit/Credit Indicator (Origin) Show values
ControllingDebitCreditCode CO Debit/Credit Indicator Show values
OrderCategory Order category Show values
OffsettingAccountType Offsetting Account Type Show values
IsStatisticalOrder Indicator: Internal Order is Statistical Account Assignment Show values
IsStatisticalCostCenter Indicator: Cost Center is Statistical Account Assignment Show values
Column Name Description Domain name
ControllingDocument Document Number CO_BELNR
ControllingDocumentItem Posting Row BUZEI
FiscalPeriod Posting period POPER
FiscalYearPeriod Fiscal Year + Fiscal Period FINS_FYEARPERIOD
AccountAssignment Account Assignment ACCAS
OrderItem Order item number CO_POSNR
PartnerAccountAssignment Partner Account Assignment ACCAS
TransactionTypeDetermination Transaction Key CHAR3
OrderOperation Operation/Activity Number VORNR
PersonnelNumber Personnel Number PERNR
OffsettingAccount Offsetting Account Number GKONT
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
Master Data Relations Join Conditions
Activity Type
  • ?
  • Client
  • Activity Type
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CSLA.MANDT
  • R_CONTROLLINGACTUALLINEITEM.ACTIVITYTYPE == CSLA.LSTAR
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • R_CONTROLLINGACTUALLINEITEM.MANDT == T006.MANDT
  • R_CONTROLLINGACTUALLINEITEM.BASEUNIT == T006.MSEHI
Business Transaction Category
  • Client
  • Business Transaction Category
  • R_CONTROLLINGACTUALLINEITEM.MANDT == FINSC_BTTYPE.MANDT
  • R_CONTROLLINGACTUALLINEITEM.BUSINESSTRANSACTIONCATEGORY == FINSC_BTTYPE.BTTYPE
Chart of Accounts
  • Client
  • Chart of Accounts
  • R_CONTROLLINGACTUALLINEITEM.MANDT == T004.MANDT
  • R_CONTROLLINGACTUALLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • R_CONTROLLINGACTUALLINEITEM.COMPANYCODE == T001.BUKRS
  • R_CONTROLLINGACTUALLINEITEM.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TKA01.MANDT
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
CO key subnumber
  • Client
  • CO key subnumber
  • R_CONTROLLINGACTUALLINEITEM.MANDT == COKEY.MANDT
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGKEYSUBNUMBER == COKEY.HRKFT
CO Object Currency
  • Client
  • CO Object Currency
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGOBJECTCURRENCY == TCURC.WAERS
Cost Center
  • ?
  • Client
  • Cost Center
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CSKS.MANDT
  • R_CONTROLLINGACTUALLINEITEM.COSTCENTER == CSKS.KOSTL
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
Account Number
  • Account Number
  • Company Code
  • Client
  • R_CONTROLLINGACTUALLINEITEM.COSTELEMENT == SKB1.SAKNR
  • R_CONTROLLINGACTUALLINEITEM.COMPANYCODE == SKB1.BUKRS
  • R_CONTROLLINGACTUALLINEITEM.MANDT == SKB1.MANDT
Origin Group as Subdivision of Cost Element
  • ?
  • Client
  • Origin Group as Subdivision of Cost Element
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "HRKTYP"] == TKKH1.KOATY
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TKKH1.MANDT
  • R_CONTROLLINGACTUALLINEITEM.COSTORIGINGROUP == TKKH1.HRKFT
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == TKKH1.KOKRS
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
Global Currency
  • Client
  • Global Currency
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Material Number
  • Client
  • Material Number
  • R_CONTROLLINGACTUALLINEITEM.MANDT == MARA.MANDT
  • R_CONTROLLINGACTUALLINEITEM.MATERIAL == MARA.MATNR
Order Number
  • Order Number
  • Client
  • R_CONTROLLINGACTUALLINEITEM.ORDERID == AUFK.AUFNR
  • R_CONTROLLINGACTUALLINEITEM.MANDT == AUFK.MANDT
Origin cost center
  • ?
  • Client
  • Origin cost center
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CSKS.MANDT
  • R_CONTROLLINGACTUALLINEITEM.ORIGINCOSTCENTER == CSKS.KOSTL
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
Origin activity
  • ?
  • Client
  • Origin activity
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CSLA.MANDT
  • R_CONTROLLINGACTUALLINEITEM.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
Partner Business Process
  • ?
  • Partner Business Process
  • Client
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "DATBI"] == CBPR.DATBI
  • R_CONTROLLINGACTUALLINEITEM.PARTNERBUSINESSPROCESS == CBPR.PRZNR
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CBPR.MANDT
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == CBPR.KOKRS
Sender cost center
  • ?
  • Client
  • Controlling Area
  • Sender cost center
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CSKS.MANDT
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • R_CONTROLLINGACTUALLINEITEM.PARTNERCOSTCENTER == CSKS.KOSTL
Partner activity
  • ?
  • Client
  • Partner activity
  • Controlling Area
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CSLA.MANDT
  • R_CONTROLLINGACTUALLINEITEM.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • R_CONTROLLINGACTUALLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
Partner order number
  • Client
  • Partner order number
  • R_CONTROLLINGACTUALLINEITEM.MANDT == AUFK.MANDT
  • R_CONTROLLINGACTUALLINEITEM.PARTNERORDER == AUFK.AUFNR
Plant
  • Client
  • Plant
  • R_CONTROLLINGACTUALLINEITEM.MANDT == T001W.MANDT
  • R_CONTROLLINGACTUALLINEITEM.PLANT == T001W.WERKS
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • R_CONTROLLINGACTUALLINEITEM.MANDT == TCURC.MANDT
  • R_CONTROLLINGACTUALLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Unit of Measure for Valuation Quantity
  • Client
  • Unit of Measure for Valuation Quantity
  • R_CONTROLLINGACTUALLINEITEM.MANDT == T006.MANDT
  • R_CONTROLLINGACTUALLINEITEM.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • ?
  • Client
  • Object ID of the resource
  • R_CONTROLLINGACTUALLINEITEM.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • R_CONTROLLINGACTUALLINEITEM.MANDT == CRID.MANDT
  • R_CONTROLLINGACTUALLINEITEM.WORKCENTERINTERNALID == CRID.OBJID