SAP table ANLI (Link table for investment measure -> AuC)
SAP table ANLI has 4 primary key fields being MANDT,OBJNR,URSCH,URZUO.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | * | MANDT | |
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |
| URSCH | Source Structure | CHAR | 2 | 0 | TKB4A | URSCH | |
| URZUO | Source Assignment | CHAR | 3 | 0 | TKB4C | URZUO | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| ANLN1 | Main Asset Number | CHAR | 12 | 0 | ANLH | ANLN1 | |
| ANLN2 | Asset Subnumber | CHAR | 4 | 0 | * | ANLN2 | |
| XREOR | Reorg.ind. If leading object archived 'X' - yes '' - no | CHAR | 1 | 0 | IM_XREOR | ||
| IVPRO | Investment Measure Profile | CHAR | 6 | 0 | * | IM_PROFIL | |
| ABGSL | Capitalization Key | CHAR | 6 | 0 | TKKAA | AM_ABGR_SCHL |
ANLI foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ANLI | ABGSL | TKKAA | Check Table for Results Analysis Key of RA for Orders | MANDT |
| 0 ANLI | ABGSL | TKKAA | Check Table for Results Analysis Key of RA for Orders | ABGSL |
| 1 ANLI | ANLN1 | ANLH | Main asset number | BUKRS |
| 1 ANLI | ANLN1 | ANLH | Main asset number | ANLN1 |
| 0 ANLI | BUKRS | T001 | Company Codes | BUKRS |
| 1 ANLI | OBJNR | ONR00 | General Object Number | MANDT |
| 0 ANLI | URSCH | TKB4A | Original Settlement Structure | MANDT |
| 1 ANLI | URZUO | TKB4C | Original Settlement Assignment | MANDT |
| 1 ANLI | URZUO | TKB4C | Original Settlement Assignment | URZUO |