SAP ACCOSTRATE Cost Rate Table
Overview
ACCOSTRATE is a standard SAP S/4HANA table that stores Cost Rate data. There are total 35 fields in the ACCOSTRATE table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ACCOSTRATE belongs to Overhead Cost Controlling (CO-OM) module and is located in the package Management Accounting - Cost Rate (FINS_CO_COST_RATE).
In addition, following links provide an overview of foreign key relationships, if any, that link ACCOSTRATE to other SAP tables and standard CDS views available based on ACCOSTRATE table in S/4HANA 2020.
Techincal Settings of ACCOSTRATE
Below are technical details of the table ACCOSTRATE
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ACCOSTRATE Fields
The following table gives you an overview of the fields available in ACCOSTRATE
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 |
| RATEUUID | Cost Rate UUID | FCO_RATE_UUID | RAW | 16 | |
| LEDGER | Ledger in General Ledger Accounting | FINS_LEDGER | FINSC_LEDGER | CHAR | 2 |
| BUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| CVTYP | Currency and Valuation Type | CVTYP | CHAR | 2 | |
| BTTYPE | Business Transaction Type | FINS_BTTYPE | CHAR | 4 | |
| CATEGORY | Plan Category | FCOM_CATEGORY | FCOMC_CATEGORY | CHAR | 10 |
| GJAHRFROM | From Fiscal Year | FCO_GJAHR_FROM | NUMC | 4 | |
| PERIODFROM | From Period | FCO_PERIOD_FROM | NUMC | 3 | |
| DATEFROM | Validity Start Date | FCO_VALID_FROM | DATS | 8 | |
| GJAHRTO | To Fiscal Year | FCO_GJAHR_TO | NUMC | 4 | |
| PERIODTO | To Period | FCO_PERIOD_TO | NUMC | 3 | |
| DATETO | Validity End Date | FCO_VALID_TO | DATS | 8 | |
| CURRENCY | Currency Key | WAERS | TCURC | CUKY | 5 |
| TOTALAMOUNT | Total Rate | FCO_RATE_TOTAL_AMOUNT | CURR | 23 | |
| FIXEDAMOUNT | Fixed Rate | FCO_RATE_FIXED_AMOUNT | CURR | 23 | |
| SCALEFACTOR | per | FCO_RATE_SCALE_FACTOR | DEC | 5 | |
| ACTIVITY_UNIT | Activity Unit | FCO_ACTIVITY_UNIT | T006 | UNIT | 3 |
| USNAM | Created By User | FCO_CREATED_BY | CHAR | 12 | |
| TIMESTAMP | Creation Time | FCO_CREATED_TIME | DEC | 15 | |
| DELETED | Cost Rate Deleted Indicator | FCO_RATE_DELETED | CHAR | 1 | |
| DELETED_BY | Deleted By User | FCO_DELETED_BY | CHAR | 12 | |
| DELETED_TIME | Deletion Time | FCO_DELETED_TIME | DEC | 15 | |
| REF_RATEUUID | Cost Rate UUID | FCO_RATE_UUID | RAW | 16 | |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 |
| ACTIVITY_TYPE | Activity Type | LSTAR | CSLA | CHAR | 6 |
| ICO_RATE | Intercompany Cost Rate Indicator | FCO_INTER_COMPANY_RATE | CHAR | 1 | |
| COMP_RECEIVING | Receiving Company Code | FCO_RECEIVING_COMPANY_CODE | T001 | CHAR | 4 |
| SRV_COST_LEVEL | Service Cost Level | FCO_SERVICE_COST_LEVEL | NUMC | 4 | |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| PS_POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | |
| WORK_ITEM_ID | Work Item ID | /CPD/PFP_WORKITEM_ID | CHAR | 10 | |
| OVERTIMECAT | Overtime Category | CATS_OVERTIME_CATEGORY | TCATS_SSC_OVTM | CHAR | 4 |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ACCOSTRATE
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| ACCOSTRATE | ACTIVITY_TYPE | : | CSLA |
| ACCOSTRATE | ACTIVITY_UNIT | : | T006 |
| ACCOSTRATE | BUKRS | : | T001 |
| ACCOSTRATE | CATEGORY | : | FCOMC_CATEGORY |
| ACCOSTRATE | CLIENT | 1: CN | T000 |
| ACCOSTRATE | COMP_RECEIVING | : | T001 |
| ACCOSTRATE | CURRENCY | : | TCURC |
| ACCOSTRATE | KOKRS | : | TKA01 |
| ACCOSTRATE | KOSTL | : | CSKS |
| ACCOSTRATE | LEDGER | : | FINSC_LEDGER |
| ACCOSTRATE | OVERTIMECAT | : | TCATS_SSC_OVTM |