P_COActualLineItem

Private view for CO Actual Line Items | view: PFICOACTULITEM | 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
AmountInGlobalCurrency Amount in Freely Defined Currency 8
FixedAmountInGlobalCrcy PrCtr Valuation Fixed Amount in Global Currency
AmountInObjectCurrency Amount in Freely Defined Currency 8
💲 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
FINS_XAUFNR_STAT Indicator: Internal Order is Statistical Account Assignment Show values
FINS_XKOSTL_STAT 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
Version CO Version COVERSI
AccountAssignment Account Assignment ACCAS
PartnerAccountAssignment Partner Account Assignment ACCAS
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
  • ?
  • Controlling Area
  • Activity Type
  • Client
  • P_COACTUALLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • P_COACTUALLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • P_COACTUALLINEITEM.ACTIVITYTYPE == CSLA.LSTAR
  • P_COACTUALLINEITEM.MANDT == CSLA.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_COACTUALLINEITEM.MANDT == T006.MANDT
  • P_COACTUALLINEITEM.BASEUNIT == T006.MSEHI
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_COACTUALLINEITEM.MANDT == T004.MANDT
  • P_COACTUALLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_COACTUALLINEITEM.MANDT == T001.MANDT
  • P_COACTUALLINEITEM.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Company Code Currency
  • Client
  • P_COACTUALLINEITEM.COMPANYCODECURRENCY == TCURC.WAERS
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
Controlling Area
  • Controlling Area
  • Client
  • P_COACTUALLINEITEM.CONTROLLINGAREA == TKA01.KOKRS
  • P_COACTUALLINEITEM.MANDT == TKA01.MANDT
CO key subnumber
  • Client
  • CO key subnumber
  • P_COACTUALLINEITEM.MANDT == COKEY.MANDT
  • P_COACTUALLINEITEM.CONTROLLINGKEYSUBNUMBER == COKEY.HRKFT
Cost Center
  • ?
  • Controlling Area
  • Client
  • Cost Center
  • P_COACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_COACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • P_COACTUALLINEITEM.MANDT == CSKS.MANDT
  • P_COACTUALLINEITEM.COSTCENTER == CSKS.KOSTL
Account Number
  • Client
  • Account Number
  • Company Code
  • P_COACTUALLINEITEM.MANDT == SKB1.MANDT
  • P_COACTUALLINEITEM.COSTELEMENT == SKB1.SAKNR
  • P_COACTUALLINEITEM.COMPANYCODE == SKB1.BUKRS
Origin Group as Subdivision of Cost Element
  • Origin Group as Subdivision of Cost Element
  • ?
  • Controlling Area
  • Client
  • P_COACTUALLINEITEM.COSTORIGINGROUP == TKKH1.HRKFT
  • P_COACTUALLINEITEM.[column in domain "HRKTYP"] == TKKH1.KOATY
  • P_COACTUALLINEITEM.CONTROLLINGAREA == TKKH1.KOKRS
  • P_COACTUALLINEITEM.MANDT == TKKH1.MANDT
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY2 == TCURC.WAERS
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Freely Defined Currency 8
  • Client
  • P_COACTUALLINEITEM.FREEDEFINEDCURRENCY8 == TCURC.WAERS
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
Global Currency
  • Client
  • Global Currency
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
  • P_COACTUALLINEITEM.GLOBALCURRENCY == TCURC.WAERS
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
Material Number
  • Client
  • Material Number
  • P_COACTUALLINEITEM.MANDT == MARA.MANDT
  • P_COACTUALLINEITEM.MATERIAL == MARA.MATNR
Order Number
  • Client
  • Order Number
  • P_COACTUALLINEITEM.MANDT == AUFK.MANDT
  • P_COACTUALLINEITEM.ORDERID == AUFK.AUFNR
Origin cost center
  • Origin cost center
  • ?
  • Controlling Area
  • Client
  • P_COACTUALLINEITEM.ORIGINCOSTCENTER == CSKS.KOSTL
  • P_COACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_COACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • P_COACTUALLINEITEM.MANDT == CSKS.MANDT
Origin activity
  • ?
  • Controlling Area
  • Client
  • Origin activity
  • P_COACTUALLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • P_COACTUALLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • P_COACTUALLINEITEM.MANDT == CSLA.MANDT
  • P_COACTUALLINEITEM.ORIGINCOSTCTRACTIVITYTYPE == CSLA.LSTAR
Partner Business Process
  • ?
  • Controlling Area
  • Client
  • Partner Business Process
  • P_COACTUALLINEITEM.[column in domain "DATBI"] == CBPR.DATBI
  • P_COACTUALLINEITEM.CONTROLLINGAREA == CBPR.KOKRS
  • P_COACTUALLINEITEM.MANDT == CBPR.MANDT
  • P_COACTUALLINEITEM.PARTNERBUSINESSPROCESS == CBPR.PRZNR
Sender cost center
  • ?
  • Controlling Area
  • Client
  • Sender cost center
  • P_COACTUALLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • P_COACTUALLINEITEM.CONTROLLINGAREA == CSKS.KOKRS
  • P_COACTUALLINEITEM.MANDT == CSKS.MANDT
  • P_COACTUALLINEITEM.PARTNERCOSTCENTER == CSKS.KOSTL
Partner activity
  • Partner activity
  • ?
  • Controlling Area
  • Client
  • P_COACTUALLINEITEM.PARTNERCOSTCTRACTIVITYTYPE == CSLA.LSTAR
  • P_COACTUALLINEITEM.[column in domain "DATBI"] == CSLA.DATBI
  • P_COACTUALLINEITEM.CONTROLLINGAREA == CSLA.KOKRS
  • P_COACTUALLINEITEM.MANDT == CSLA.MANDT
Partner order number
  • Client
  • Partner order number
  • P_COACTUALLINEITEM.MANDT == AUFK.MANDT
  • P_COACTUALLINEITEM.PARTNERORDER == AUFK.AUFNR
Plant
  • Plant
  • Client
  • P_COACTUALLINEITEM.PLANT == T001W.WERKS
  • P_COACTUALLINEITEM.MANDT == T001W.MANDT
Balance Transaction Currency
  • Balance Transaction Currency
  • Client
  • P_COACTUALLINEITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • P_COACTUALLINEITEM.MANDT == TCURC.MANDT
Unit of Measure for Valuation Quantity
  • Client
  • Unit of Measure for Valuation Quantity
  • P_COACTUALLINEITEM.MANDT == T006.MANDT
  • P_COACTUALLINEITEM.UNITOFMEASURE == T006.MSEHI
Object ID of the resource
  • ?
  • Client
  • Object ID of the resource
  • P_COACTUALLINEITEM.[column in domain "CR_OBJTY"] == CRID.OBJTY
  • P_COACTUALLINEITEM.MANDT == CRID.MANDT
  • P_COACTUALLINEITEM.WORKCENTERINTERNALID == CRID.OBJID