SAP AFWKFRA_KCFPL Key Figures: CfaR - Profit/Loss Distribution Table
Overview
AFWKFRA_KCFPL is a standard SAP S/4HANA table that stores Key Figures: CfaR - Profit/Loss Distribution data. There are total 11 fields in the AFWKFRA_KCFPL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFWKFRA_KCFPL belongs to Market Risk Analyzer (FIN-FSCM-TRM-MR) module and is located in the package RDB: MRA Key Figure Management (CFM_AFWKFRA).
In addition, following links provide an overview of foreign key relationships, if any, that link AFWKFRA_KCFPL to other SAP tables and standard CDS views available based on AFWKFRA_KCFPL table in S/4HANA 2020.
Techincal Settings of AFWKFRA_KCFPL
Below are technical details of the table AFWKFRA_KCFPL
- Buffering switched on
- Single entries of table were buffered
- Storage type is Column Store
List of AFWKFRA_KCFPL Fields
The following table gives you an overview of the fields available in AFWKFRA_KCFPL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| KEYFIGURE | Key Figure | AFWKF_DEFINITION | AFWKF_DEFIN | CHAR | 8 |
| BASEFIGURE | Basic Key Figure | AFWKF_BASEDEFINITION | AFWKFRA_KCFP | CHAR | 8 |
| VKVOLART | Volatility Type | TB_VOLART | ATVO1 | CHAR | 3 |
| VKKORART | Correlation Type for Cash Flow at Risk | FTBB_CORREL_TYPE_CFAR | ATKO1 | CHAR | 3 |
| CALENDAR | Calendar ID for Cash Flow at Risk Calculation | FTBB_CALENDAR_CFAR | TFACD | CHAR | 2 |
| SEED | Initial Value for Random Number Generator | FTBB_RANDOM_SEED | DEC | 10 | |
| SIMCAT | Cash Flow at Risk Simulation Category | FTBB_CFARSIMCAT | NUMC | 2 | |
| SIMRUN | Number of Simulation Runs (Random Walks) for MC Simulations | FTBB_CFARSIMRUN | NUMC | 5 | |
| TIMEGRID_METH | Method for Creating Time Grid of Random Walk | FTBB_RW_TIMEGRID_METHOD | CHAR | 2 | |
| TIMEGRID_STEPSIZE | Random Walk Step Size in Days | FTBB_RW_TIMEGRID_STEPSIZE | NUMC | 2 |
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 AFWKFRA_KCFPL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFWKFRA_KCFPL | BASEFIGURE | 1: 1 | AFWKFRA_KCFP |
| AFWKFRA_KCFPL | CALENDAR | 1: CN | TFACD |
| AFWKFRA_KCFPL | KEYFIGURE | 1: 1 | AFWKF_DEFIN |
| AFWKFRA_KCFPL | MANDT | 1: CN | T000 |
| AFWKFRA_KCFPL | VKKORART | 1: CN | ATKO1 |
| AFWKFRA_KCFPL | VKVOLART | 1: CN | ATVO1 |