SAP AIS_FORMULA_ADM Customizing of Formulas in AIS Table
Overview
AIS_FORMULA_ADM is a standard SAP S/4HANA table that stores Customizing of Formulas in AIS data. There are total 8 fields in the AIS_FORMULA_ADM table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AIS_FORMULA_ADM belongs to Information System (FIN-FSCM-TRM-AN-IS) module and is located in the package RDB: Information System (CFM_AIS).
In addition, following links provide an overview of foreign key relationships, if any, that link AIS_FORMULA_ADM to other SAP tables and standard CDS views available based on AIS_FORMULA_ADM table in S/4HANA 2020.
Techincal Settings of AIS_FORMULA_ADM
Below are technical details of the table AIS_FORMULA_ADM
- Buffering not allowed
- No buffering
- Storage type is Not Defined
List of AIS_FORMULA_ADM Fields
The following table gives you an overview of the fields available in AIS_FORMULA_ADM
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT | 3 |
| AREA | CFM: Standard Reporting Areas on Results Database | AIS_REP_AREA | CHAR | 2 | |
| FORMULAID | Formula ID | SFBEID | CHAR | 32 | |
| DECIMALS | Number of Decimal Places | DECIMALS | NUMC | 6 | |
| FORMULACAT | Formula Category | AIS_FORMULACAT | CHAR | 1 | |
| DINTERVAL | Yield Period | AIS_YLDPERIOD | CHAR | 1 | |
| FLG_PERIODEND | Period End Indicator | AIS_PERIODEND | CHAR | 1 | |
| PERIV | Fiscal Year Variant for Period-to-Date Yield | AFWKFPA_PERIV | T009 | CHAR | 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 AIS_FORMULA_ADM
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AIS_FORMULA_ADM | PERIV | : | T009 |