Saturday 3 January 2015

tables co

TABLES IN SAP CONTROLLING

 
Table Name : AUSP
Table Purpose : Characteristic Values
Fields:
  • MANDT
  • OBJEK
  • ATINN
  • ATZHL
  • MAFID
  • KLART
  • ADZHL

CO-KBAS – Overhead Cost Controlling

Table Name : A132
Table Purpose : Price per CostCenter
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • KOKRS
  • VERSN
  • RESRC
  • KOSTL
  • DATBI

Table Name : A136
Table Purpose : Price per Controlling Area
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • KOKRS
  • VERSN
  • RESRC
  • DATBI

Table Name : A137
Table Purpose : Price per Country / Region
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • KOKRS
  • VERSN
  • RESRC
  • LAND1
  • REGIO
  • DATBI

Table Name : COSC
Table Purpose : CO Objects: Assignment of Original Costing Sheets
Fields:
  • MANDT
  • OBJNR
  • SCTYP
  • VERSN
  • GJAHR

Table Name : CSSK
Table Purpose : CostCenter / Cost Element
Fields:
  • MANDT
  • VERSN
  • KOKRS
  • GJAHR
  • KOSTL
  • KSTAR

Table Name : CSSL
Table Purpose : CostCenter / Activity Type
Fields:
  • MANDT
  • KOKRS
  • KOSTL
  • LSTAR
  • GJAHR

Table Name : KAPS
Table Purpose : CO Period Locks
Fields:
  • MANDT
  • KOKRS
  • GJAHR
  • VERSN
  • VRGNG
  • PERBL

CO-KBASCORE – Overhead Cost Controlling: General Services

Table Name : CSKA
Table Purpose : Cost Elements (Data Dependent on Chart of Accounts)
Fields:
  • MANDT
  • KTOPL
  • KSTAR


Table Name : CSKB
Table Purpose : Cost Elements (Data Dependent on Controlling Area)
Fields:
  • MANDT
  • KOKRS
  • KSTAR
  • DATBI

Table Name : CSKS
Table Purpose : CostCenter Master Data
Fields:
  • MANDT
  • KOKRS
  • KOSTL
  • DATBI

Table Name : CSLA
Table Purpose : Activity Master
Fields:
  • MANDT
  • KOKRS
  • LSTAR
  • DATBI

CO-OM (KACC) – Overhead Cost Controlling

Table Name : COBK
Table Purpose : CO Object: Document Header
Fields:
  • MANDT
  • KOKRS
  • BELNR

Table Name : COEJ
Table Purpose : CO Object: Line Items (by Fiscal Year)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI
  • PERBL

Table Name : COEJL
Table Purpose : CO Object: Line Items for Activity Types (by Fiscal Yr)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI
  • PERBL

Table Name : COEJR
Table Purpose : CO Object: Line Items for SKF (by Fiscal Year)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI
  • PERBL

Table Name : COEJT
Table Purpose : CO Object: Line Items for Prices (by Fiscal Year)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI
  • PERBL

Table Name : COEP
Table Purpose : CO Object: Line Items (by Period)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI

Table Name : COEPL
Table Purpose : CO Object: Line Items for Activity Types (by Period)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI

Table Name : COEPR
Table Purpose : CO Object: Line Items for SKF (by Period)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI

Table Name : COEPT
Table Purpose : CO Object: Line Items for Prices (by Period)
Fields:
  • MANDT
  • KOKRS
  • BELNR
  • BUZEI

Table Name : COKA
Table Purpose : CO Object: Control Data for Cost Elements
Fields:
  • MANDT
  • OBJNR
  • GJAHR
  • KSTAR
  • HRKFT

Table Name : COKL
Table Purpose : CO Object: Control Data for Activity Types
Fields:
  • MANDT
  • LEDNR
  • OBJNR
  • GJAHR
  • VERSN

Table Name : COKP
Table Purpose : CO Object: Control Data for Primary Planning
Fields:
  • MANDT
  • LEDNR
  • OBJNR
  • GJAHR
  • WRTTP
  • VERSN
  • KSTAR
  • HRKFT
  • VRGNG
  • VBUND
  • PARGB
  • BEKNZ
  • TWAER

Table Name : COKR
Table Purpose : CO Object: Control Data for Statistical Key Figures
Fields:
  • MANDT
  • LEDNR
  • OBJNR
  • GJAHR
  • WRTTP
  • VERSN
  • STAGR
  • HRKFT
  • VRGNG

Table Name : COKS
Table Purpose : CO Object: Control Data for Secondary Planning
Fields:
  • MANDT
  • LEDNR
  • OBJNR
  • GJAHR
  • WRTTP
  • VERSN
  • KSTAR
  • HRKFT
  • VRGNG
  • PAROB
  • USPOB
  • BEKNZ
  • TWAER

CO-OM-CEL (KKAL) –  Cost Element Accounting (Reconciliation Ledger)
Table Name : COFI01
Table Purpose : Object Table for Reconciliation Ledger COFIT
Fields:
  • MANDT
  • OBJNR

Table Name : COFI02
Table Purpose : Transaction Dependent Fields for Reconciliation Ledger
Fields:
  • MANDT
  • OBJNR

Table Name : COFIP
Table Purpose : Single Plan Items for Reconciliation Ledger
Fields:
  • RCLNT
  • GL_SIRID

Table Name : COFIS
Table Purpose : Actual Line Items for Reconciliation Ledger
Fields:
  • RCLNT
  • GL_SIRID

CO-OM-CCA – Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S

Table Name : A138
Table Purpose : Price per Company Code
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • KOKRS
  • VERSN
  • RESRC
  • BUKRS
  • GSBER
  • DATBI

Table Name : A139
Table Purpose : Price per ProfitCenter
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • KOKRS
  • VERSN
  • RESRC
  • PRCTR
  • DATBI

CO-OM-OPA(KABR) – Overhead Orders: Application Development R/3 Cost Accounting Settlement
Table Name : AUAA
Table Purpose : Settlement Document: Receiver Segment
Fields:
  • MANDT
  • BELNR
  • LFDNR

Table Name : AUAB
Table Purpose : Settlement Document: Distribution Rules
Fields:
  • MANDT
  • BELNR
  • BUREG
  • LFDNR

Table Name : AUAI
Table Purpose : Settlement Rules per Depreciation Area
Fields:
  • MANDT
  • BELNR
  • LFDNR
  • AFABE

Table Name : AUAK
Table Purpose : Document Header for Settlement
Fields:
  • MANDT
  • BELNR

Table Name : AUAO
Table Purpose : Document Segment: CO Objects to be Settled
Fields:
  • MANDT
  • BELNR
  • LFDNR

Table Name : AUAV
Table Purpose : Document Segment: Transactions
Fields:
  • MANDT
  • BELNR
  • LFDNR

Table Name : COBRA
Table Purpose : Settlement Rule for Order Settlement
Fields:
  • MANDT
  • OBJNR

Table Name : COBRB
Table Purpose : Distribution Rules Settlement Rule Order Settlement
Fields:
  • MANDT
  • OBJNR
  • BUREG
  • LFDNR

CO-OM-OPA(KAUF) – Overhead Orders: Cost Accounting Orders

Table Name : AUFK
Table Purpose : Order Master Data
Fields:
  • MANDT
  • AUFNR

Table Name : AUFLAY0
Table Purpose : Enttity Table: Order Layouts
Fields:
  • MANDT
  • LAYOUT

EC-PCA (KE1) – Profit Center Accounting

Table Name : CEPC
Table Purpose : ProfitCenter Master Data Table
Fields:
  • MANDT
  • PRCTR
  • DATBI
  • KOKRS

Table Name : CEPCT
Table Purpose : Texts for ProfitCenter Master Data
Fields:
  • MANDT
  • SPRAS
  • PRCTR
  • DATBI
  • KOKRS

Table Name : CEPC_BUKRS
Table Purpose : Assignment of ProfitCenter to a Company Code
Fields:
  • MANDT
  • KOKRS
  • PRCTR
  • BUKRS

Table Name : GLPCA
Table Purpose : EC-PCA: Actual Line Items
Fields:
  • RCLNT
  • GL_SIRID

Table Name : GLPCC
Table Purpose : EC-PCA: Transaction Attributes
Fields:
  • MANDT
  • OBJNR

Table Name : GLPCO
Table Purpose : EC-PCA: Object Table for Account Assignment Element
Fields:
  • MANDT
  • OBJNR

Table Name : GLPCP
Table Purpose : EC-PCA: Plan Line Items
Fields:
  • RCLNT
  • GL_SIRID

EC-PCA BS (KE1C) – PCA Basic Settings: Customizing for ProfitCenter Accounting

Table Name : A141
Table Purpose : Dependent on Material and ReceiverProfitCenter
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • KOKRS
  • WERKS
  • MATNR
  • PPRCTR
  • DATBI

Table Name : A142
Table Purpose : Dependent on Material
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • WERKS
  • MATNR
  • DATBI

Table Name : A143
Table Purpose : Dependent on Material Group
Fields:
  • MANDT
  • KAPPL
  • KSCHL
  • WERKS
  • MATKL
  • DATBI

No comments:

Post a Comment