SAP Table
J_1AINFT22 Index Versions
SAP table J_1AINFT22 has 3 primary key fields being MANDT,J_1AINDX,J_1AVERSIO.
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_1AINFT22 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_1AINFT20 | J_1AINDXP | |||||||||||||||||||||||
| KeyJ_1AVERSIO | Inflation Index Version | NUMC | 4 | 0 | J_1AVERCPZ | ||||||||||||||||||||||||
| J_1AINFRND | Inflation Rate Rounding | CHAR | 1 | 0 | J_1AINFRND | ||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||
/ Relationships
J_1AINFT22 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| J_1AINFT22 | J_1AINDX | J_1AINFT20 | Inflation: Index Definition | MANDT |
| J_1AINFT22 | MANDT | T000 | Clients | MANDT |