SAP table ANLE (Asset Origin by Line Item)
SAP table ANLE has 8 primary key fields being MANDT,BUKRS,ANLN1,ANLN2,GJAHR,LNRAN,COBELNR,COBUZEI.
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 | T000 | MANDT | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| ANLN1 | Main Asset Number | CHAR | 12 | 0 | ANLH | ANLN1 | |
| ANLN2 | Asset Subnumber | CHAR | 4 | 0 | ANLA | ANLN2 | |
| GJAHR | Fiscal Year | NUMC | 4 | 0 | GJAHR | ||
| LNRAN | Sequence Number of Asset Line Items in Fiscal Year | NUMC | 5 | 0 | ANEK | LNRAN | |
| COBELNR | Document Number | CHAR | 10 | 0 | COBK | CO_BELNR | |
| COBUZEI | Posting Row | NUMC | 3 | 0 | CO_BUZEI | ||
| FIBELNR | Doc. number of orig. accounting document | CHAR | 10 | 0 | IM_FIURBEL | ||
| FIBUZEI | Number of line item in original accounting document | NUMC | 3 | 0 | IM_FIURBUZ | ||
| FIGJAHR | Fiscal year from origin document | NUMC | 4 | 0 | IM_FIURGJ | ||
| GKOAR | Offsetting Account Type | CHAR | 1 | 0 | GKOAR | ||
| GKONT | Offsetting Account Number | CHAR | 10 | 0 | GKONT | ||
| KSTAR | Cost Element | CHAR | 10 | 0 | CSKA | KSTAR | |
| HRKFT | CO key subnumber | CHAR | 14 | 0 | CO_SUBKEY | ||
| WBGBTR | Total value of original line item in company code currency | CURR | 23 | 2 | IM_WBGBTR | ||
| WBABTR | Settled value of line item in company code currency | CURR | 23 | 2 | IM_WBABTR | ||
| USPOB | Source Object (Cost Center/Activity Type) | CHAR | 22 | 0 | USPOB | ||
| COGJAHR | Fiscal year of the CO posting | NUMC | 4 | 0 | IM_COGJAHR |
ANLE foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ANLE | ANLN1 | ANLH | Main asset number | BUKRS |
| 0 ANLE | ANLN1 | ANLH | Main asset number | ANLN1 |
| 1 ANLE | ANLN2 | ANLA | Asset Master Record Segment | BUKRS |
| 1 ANLE | ANLN2 | ANLA | Asset Master Record Segment | ANLN1 |
| 1 ANLE | ANLN2 | ANLA | Asset Master Record Segment | ANLN2 |
| 0 ANLE | BUKRS | T001 | Company Codes | BUKRS |
| 1 ANLE | COBELNR | COBK | CO Object: Document Header | KOKRS |
| 1 ANLE | COBELNR | COBK | CO Object: Document Header | BELNR |
| 0 ANLE | KSTAR | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| 0 ANLE | KSTAR | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL |
| 1 ANLE | LNRAN | ANEK | Document Header Asset Posting | MANDT |
| 1 ANLE | LNRAN | ANEK | Document Header Asset Posting | BUKRS |
| 1 ANLE | LNRAN | ANEK | Document Header Asset Posting | ANLN1 |
| 1 ANLE | LNRAN | ANEK | Document Header Asset Posting | ANLN2 |
| 1 ANLE | LNRAN | ANEK | Document Header Asset Posting | GJAHR |
| 1 ANLE | LNRAN | ANEK | Document Header Asset Posting | LNRAN |
| 0 ANLE | MANDT | T000 | Clients | MANDT |