SAP Table
J_1AINFT20 Inflation: Index Definition
SAP table J_1AINFT20 has 2 primary key fields being MANDT,J_1AINDX.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
J_1AINFT20 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||
| KeyJ_1AINDX | Inflation Index | CHAR | 5 | 0 | J_1AINDXP | ||||||||
| J_1ACOINDP | Index Format | NUMC | 1 | 0 | J_1AINDICP | ||||||||
|
|||||||||||||
| J_1AVERACP | Active Version of Inflation Index | NUMC | 4 | 0 | J_1AINFT22 | J_1AVERACP | |||||||
| J_1ADECIMP | Number of decimals for reporting | NUMC | 2 | 0 | J_1ADECIMP | ||||||||
| J_1ACOINAP | Composite Index | CHAR | 1 | 0 | J_1ACOINAP | ||||||||
| J_1ANOVERP | No new versions allowed | CHAR | 1 | 0 | J_1ANOVERP | ||||||||
/ Relationships
J_1AINFT20 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| J_1AINFT20 | J_1AVERACP | J_1AINFT22 | Index Versions | MANDT |
| J_1AINFT20 | J_1AVERACP | J_1AINFT22 | Index Versions | J_1AINDX |
| J_1AINFT20 | J_1AVERACP | J_1AINFT22 | Index Versions | J_1AVERSIO |
| J_1AINFT20 | MANDT | T000 | Clients | MANDT |