ACCOSTRATE is a standard SAP table in SAP ECC (or) S/4HANA which stores Cost Rate data. There are total 35 fields in ACCOSTRATE table.This blog post provides key technical details of SAP table ACCOSTRATE, including its availability across SAP S/4HANA versions and the list of CDS views for ACCOSTRATE table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | Management Accounting – Cost Rate (FINS_CO_COST_RATE) |
| Technical Component | Overhead Cost Controlling (CO-OM) |
SAP ACCOSTRATE Table Fields
The following is the list of fields that are available in SAP ACCOSTRATE table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | MANDT | T000 | CLNT (3) |
| RATEUUID | Cost Rate UUID | FCO_RATE_UUID | SYSUUID_X16 | RAW (16) | |
| LEDGER | Ledger in General Ledger Accounting | FINS_LEDGER | FINS_LEDGER | FINSC_LEDGER | CHAR (2) |
| BUKRS | Company Code | BUKRS | BUKRS | T001 | CHAR (4) |
| CVTYP | Currency and Valuation Type | CVTYP | CVTYP | CHAR (2) | |
| BTTYPE | Business Transaction Type | FINS_BTTYPE | FINS_BTTYPE | CHAR (4) | |
| CATEGORY | Plan Category | FCOM_CATEGORY | FCOM_CATEGORY | FCOMC_CATEGORY | CHAR (10) |
| GJAHRFROM | From Fiscal Year | FCO_GJAHR_FROM | GJAHR | NUMC (4) | |
| PERIODFROM | From Period | FCO_PERIOD_FROM | PERBL | NUMC (3) | |
| DATEFROM | Validity Start Date | FCO_VALID_FROM | DATUM | DATS (8) | |
| GJAHRTO | To Fiscal Year | FCO_GJAHR_TO | GJAHR | NUMC (4) | |
| PERIODTO | To Period | FCO_PERIOD_TO | PERBL | NUMC (3) | |
| DATETO | Validity End Date | FCO_VALID_TO | DATUM | DATS (8) | |
| CURRENCY | Currency Key | WAERS | WAERS | TCURC | CUKY (5) |
| TOTALAMOUNT | Total Rate | FCO_RATE_TOTAL_AMOUNT | AFLE11D2O16S_TO_23D2O31S | CURR (23) | |
| FIXEDAMOUNT | Fixed Rate | FCO_RATE_FIXED_AMOUNT | AFLE11D2O16S_TO_23D2O31S | CURR (23) | |
| SCALEFACTOR | per | FCO_RATE_SCALE_FACTOR | FCO_RATE_SCALE_FACTOR | DEC (5) | |
| ACTIVITY_UNIT | Activity Unit | FCO_ACTIVITY_UNIT | MEINS | T006 | UNIT (3) |
| USNAM | Created By User | FCO_CREATED_BY | XUBNAME | CHAR (12) | |
| TIMESTAMP | Creation Time | FCO_CREATED_TIME | TZNTSTMPS | DEC (15) | |
| DELETED | Cost Rate Deleted Indicator | FCO_RATE_DELETED | XFELD | CHAR (1) | |
| DELETED_BY | Deleted By User | FCO_DELETED_BY | XUBNAME | CHAR (12) | |
| DELETED_TIME | Deletion Time | FCO_DELETED_TIME | TZNTSTMPS | DEC (15) | |
| REF_RATEUUID | Cost Rate UUID | FCO_RATE_UUID | SYSUUID_X16 | RAW (16) | |
| KOKRS | Controlling Area | KOKRS | CACCD | TKA01 | CHAR (4) |
| KOSTL | Cost Center | KOSTL | KOSTL | CSKS | CHAR (10) |
| ACTIVITY_TYPE | Activity Type | LSTAR | LSTAR | CSLA | CHAR (6) |
| ICO_RATE | Intercompany Cost Rate Indicator | FCO_INTER_COMPANY_RATE | XFELD | CHAR (1) | |
| COMP_RECEIVING | Receiving Company Code | FCO_RECEIVING_COMPANY_CODE | BUKRS | T001 | CHAR (4) |
| SRV_COST_LEVEL | Service Cost Level | FCO_SERVICE_COST_LEVEL | FCO_SRV_COST_LEVEL | NUMC (4) | |
| PERNR | Personnel Number | PERNR_D | PERNR | NUMC (8) | |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | PS_POSID | CHAR (24) | |
| WORK_ITEM_ID | Work Item ID | /CPD/PFP_WORKITEM_ID | /CPD/PFP_WORKITEM_ID | CHAR (10) | |
| OVERTIMECAT | Overtime Category | CATS_OVERTIME_CATEGORY | CATS_OVERTIME_CATEGORY | TCATS_SSC_OVTM | CHAR (4) |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PS_POSNR | NUMC (8) |
Availability
The SAP table ACCOSTRATE is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for ACCOSTRATE table
The following is the list of ACCOSTRATE CDS views, which can also be used instead of ACCOSTRATE table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| A_ACTUALCOSTRATE | BASIC | Actual Cost Rate |
| A_PLANCOSTRATE | BASIC | Plan Cost Rate |
| A_SERVICECOSTRATE | BASIC | Service Cost Rate |
| I_ACCOUNTINGCOSTRATE | BASIC | Interface view for search model CostRate |
| I_ACCOUNTINGCOSTRATEHISTORY | BASIC | Interface View for Service Cost Rate with History |
| I_ACTUALCOSTRATE | BASIC | Interface View for Actual Cost Rate |
| I_PLANCOSTRATE | BASIC | Interface View for Plan Cost Rate |
| I_PLANCOSTRATEBYPERIOD | BASIC | Interface View for Cost Rate By Period |
| I_SERVICECOSTRATE | BASIC | Interface View for Service Cost Rate |
| P_ACCOSTRATERAWDATA | BASIC | ACCOSTRATE Table Data |
| P_ACCOUNTINGCOSTRATE | BASIC | Accounting Cost Rate |
| P_PLANCOSTRATEBYPERIOD | BASIC | Private view for Cost Rate by Period |
| C_ACTUALCOSTRATE | CONSUMPTION | Actual Cost Rate |
| C_ACTUALCOSTRATEHISTORY | CONSUMPTION | Actual Cost Rate with History |
| C_ACTUALCOSTRATETIMELINE | CONSUMPTION | Actual Cost Rate Timeline |
| C_PLANCOSTRATE | CONSUMPTION | Plan Cost Rate |
| C_PLANCOSTRATEBYPERIOD | CONSUMPTION | Consumption View for Cost Rate By Period |
| C_PLANCOSTRATEBYTYPEANDPERIOD | CONSUMPTION | Consumption View for Cost Rate By Type and Period |
| C_PLANCOSTRATEHISTORY | CONSUMPTION | Plan Cost Rate with History |
| C_PLANCOSTRATEINTRANSCRCY | CONSUMPTION | Consumption View for Plan Cost Rate In Transaction Currency |
| C_PLANCOSTRATETIMELINE | CONSUMPTION | Plan Cost Rate Timeline |
| C_SERVICECOSTRATE | CONSUMPTION | Service Cost Rate |
| C_SERVICECOSTRATEHISTORY | CONSUMPTION | Service Cost Rate with History |
| C_SERVICECOSTRATETIMELINE | CONSUMPTION | Service Cost Rate Timeline Chart |
| E_ACCOUNTINGCOSTRATE | EXTENSION | Include View for Cost Rate |
