SAP Table AILOA
Change Document Structure; Generated by RSSCD000
AILOA (Change Document Structure; Generated by RSSCD000) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link AILOA to other SAP tables.
AILOA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||
|
ILOAN
Location and account assignment for technical object
|
ILOAN |
CHAR
|
12 | 0 | ||||||||||||||||||||
|
TPLNR
Functional Location
|
TPLNR | IFLOT |
CHAR
|
30 | 0 | |||||||||||||||||||
|
ABCKZ
ABC indicator for technical object
|
ABCKZ | T370C |
CHAR
|
1 | 0 | |||||||||||||||||||
|
ABCKZI
Data origin for ABC indicator field
|
INH_ABCKZI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
EQFNR
Sort field
|
EQFNR |
CHAR
|
30 | 0 | ||||||||||||||||||||
|
EQFNRI
Data origin for sort field
|
INH_EQFNRI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
SWERK
Maintenance plant
|
SWERK | T001W |
CHAR
|
4 | 0 | |||||||||||||||||||
|
SWERKI
Data origin for maintenance plant field
|
INH_SWERKI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
STORT
Location of maintenance object
|
PMLOC | T499S |
CHAR
|
10 | 0 | |||||||||||||||||||
|
STORTI
Data origin for location field
|
INH_STORTI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
MSGRP
Room
|
RAUMNR |
CHAR
|
8 | 0 | ||||||||||||||||||||
|
MSGRPI
Data origin for room number field
|
INH_MSGRPI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
BEBER
Plant section
|
BEBER | T357 |
CHAR
|
3 | 0 | |||||||||||||||||||
|
BEBERI
Data origin for plant section field
|
INH_BEBERI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
CR_OBJTY
Object types of the CIM resource
|
CR_OBJTY |
CHAR
|
2 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
PPSID
Object ID of PP work center
|
PPSID | CRID |
NUMC
|
8 | 0 | |||||||||||||||||||
|
PPSIDI
Data origin for PP work center field
|
INH_PPSIDI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||||||||||
|
GSBERI
Data origin for business area field
|
INH_GSBERI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
KOKRS
Controlling Area
|
KOKRS | TKA01 |
CHAR
|
4 | 0 | |||||||||||||||||||
|
KOKRSI
Data origin for controlling area field
|
INH_KOKRSI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
KOSTL
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||||||||||||||
|
KOSTLI
Data origin for cost center field
|
INH_KOSTLI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
PROID
Work Breakdown Structure Element (WBS Element)
|
PS_PSP_PNR | PRPS |
NUMC
|
8 | 0 | |||||||||||||||||||
|
PROIDI
Data origin for WBS element field
|
INH_PROIDI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||
|
BUKRSI
Data origin for company code field
|
INH_BUKRSI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
ANLNR
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||||||||||||||
|
ANLNRI
Data origin for asset main no./sub-no. fields
|
INH_ANLNRI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
ANLUN
Asset Subnumber
|
ANLN2 | ANLA |
CHAR
|
4 | 0 | |||||||||||||||||||
|
ANLUNI
Data origin indicator
|
INHER |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
DAUFN
Standing order number
|
DAUFN | AUFK |
CHAR
|
12 | 0 | |||||||||||||||||||
|
DAUFNI
Data origin of standing order number field
|
INH_DAUFNI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
AUFNR
Settlement order
|
ILOM_ORDST | AUFK |
CHAR
|
12 | 0 | |||||||||||||||||||
|
AUFNRI
Data origin for settlement order field
|
INH_AUFNRI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
TPLNRI
Data origin for functional location field
|
INH_TPLNRI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
VKORG
Sales Organization
|
VKORG | TVKO |
CHAR
|
4 | 0 | |||||||||||||||||||
|
VKORGI
Data origin for sales organization field
|
INH_VKORGI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
VTWEG
Distribution Channel
|
VTWEG | TVKOV |
CHAR
|
2 | 0 | |||||||||||||||||||
|
VTWEGI
Data origin of distribution channel field
|
INH_VTWEGI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
SPART
Division
|
SPART | TVTA |
CHAR
|
2 | 0 | |||||||||||||||||||
|
SPARTI
Data origin for division field
|
INH_SPARTI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
ADRNR
Address number
|
AD_ADDRNUM | ADRC |
CHAR
|
10 | 0 | |||||||||||||||||||
|
ADRNRI
Data origin for address field
|
INH_ADRNRI |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
OWNER
Object reference indicator
|
ILOM_OWNER |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
VKBUR
Sales Office
|
VKBUR | TVKBZ |
CHAR
|
4 | 0 | |||||||||||||||||||
|
VKGRP
Sales Group
|
VKGRP | TVBVK |
CHAR
|
3 | 0 | |||||||||||||||||||
|
KZ
Change Type (U, I, S, D)
|
CDCHNGIND |
CHAR
|
1 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
AILOA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| AILOA | ABCKZ | AILOA | MANDT |
T370C
ABC indicator for technical objects
|
MANDT |
| AILOA | ABCKZ | AILOA | ABCKZ |
T370C
ABC indicator for technical objects
|
ABCKZ |
| AILOA | ADRNR | AILOA | MANDT |
ADRC
Addresses (Business Address Services)
|
CLIENT |
| AILOA | ADRNR | AILOA | ADRNR |
ADRC
Addresses (Business Address Services)
|
ADDRNUMBER |
| AILOA | ADRNR | * |
ADRC
Addresses (Business Address Services)
|
DATE_FROM | |
| AILOA | ADRNR | * |
ADRC
Addresses (Business Address Services)
|
NATION | |
| AILOA | ANLNR | AILOA | MANDT |
ANLH
Main asset number
|
MANDT |
| AILOA | ANLNR | AILOA | BUKRS |
ANLH
Main asset number
|
BUKRS |
| AILOA | ANLNR | AILOA | ANLNR |
ANLH
Main asset number
|
ANLN1 |
| AILOA | ANLUN | AILOA | ANLNR |
ANLA
Asset Master Record Segment
|
ANLN1 |
| AILOA | ANLUN | AILOA | ANLUN |
ANLA
Asset Master Record Segment
|
ANLN2 |
| AILOA | ANLUN | AILOA | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| AILOA | ANLUN | AILOA | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| AILOA | AUFNR | AILOA | MANDT |
AUFK
Order master data
|
MANDT |
| AILOA | AUFNR | AILOA | AUFNR |
AUFK
Order master data
|
AUFNR |
| AILOA | BEBER | AILOA | SWERK |
T357
Plant Section
|
WERKS |
| AILOA | BEBER | AILOA | BEBER |
T357
Plant Section
|
BEBER |
| AILOA | BEBER | AILOA | MANDT |
T357
Plant Section
|
MANDT |
| AILOA | BUKRS | AILOA | MANDT |
T001
Company Codes
|
MANDT |
| AILOA | BUKRS | AILOA | BUKRS |
T001
Company Codes
|
BUKRS |
| AILOA | DAUFN | AILOA | MANDT |
AUFK
Order master data
|
MANDT |
| AILOA | DAUFN | AILOA | DAUFN |
AUFK
Order master data
|
AUFNR |
| AILOA | GSBER | AILOA | MANDT |
TGSB
Business Areas
|
MANDT |
| AILOA | GSBER | AILOA | GSBER |
TGSB
Business Areas
|
GSBER |
| AILOA | KOKRS | AILOA | MANDT |
TKA01
Controlling Areas
|
MANDT |
| AILOA | KOKRS | AILOA | KOKRS |
TKA01
Controlling Areas
|
KOKRS |
| AILOA | KOSTL | AILOA | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| AILOA | KOSTL | AILOA | KOKRS |
CSKS
Cost Center Master Data
|
KOKRS |
| AILOA | KOSTL | AILOA | KOSTL |
CSKS
Cost Center Master Data
|
KOSTL |
| AILOA | KOSTL | SYST | DATUM |
CSKS
Cost Center Master Data
|
DATBI |
| AILOA | MANDT | AILOA | MANDT |
T000
Clients
|
MANDT |
| AILOA | PPSID | AILOA | CR_OBJTY |
CRID
CIM Resource - Entities
|
OBJTY |
| AILOA | PPSID | AILOA | PPSID |
CRID
CIM Resource - Entities
|
OBJID |
| AILOA | PPSID | AILOA | MANDT |
CRID
CIM Resource - Entities
|
MANDT |
| AILOA | PROID | AILOA | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| AILOA | PROID | AILOA | PROID |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| AILOA | SPART | AILOA | SPART |
TVTA
Organizational Unit: Sales Area(s)
|
SPART |
| AILOA | SPART | AILOA | MANDT |
TVTA
Organizational Unit: Sales Area(s)
|
MANDT |
| AILOA | SPART | AILOA | VKORG |
TVTA
Organizational Unit: Sales Area(s)
|
VKORG |
| AILOA | SPART | AILOA | VTWEG |
TVTA
Organizational Unit: Sales Area(s)
|
VTWEG |
| AILOA | STORT | AILOA | STORT |
T499S
Location
|
STAND |
| AILOA | STORT | AILOA | MANDT |
T499S
Location
|
MANDT |
| AILOA | STORT | AILOA | SWERK |
T499S
Location
|
WERKS |
| AILOA | SWERK | AILOA | MANDT |
T001W
Plants/Branches
|
MANDT |
| AILOA | SWERK | AILOA | SWERK |
T001W
Plants/Branches
|
WERKS |
| AILOA | TPLNR | AILOA | MANDT |
IFLOT
Functional Location (Table)
|
MANDT |
| AILOA | TPLNR | AILOA | TPLNR |
IFLOT
Functional Location (Table)
|
TPLNR |
| AILOA | VKBUR | AILOA | VTWEG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VTWEG |
| AILOA | VKBUR | AILOA | SPART |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
SPART |
| AILOA | VKBUR | AILOA | VKBUR |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKBUR |
| AILOA | VKBUR | AILOA | MANDT |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
MANDT |
| AILOA | VKBUR | AILOA | VKORG |
TVKBZ
Org.Unit: Sales Office: Assignment to Organizational Unit
|
VKORG |
| AILOA | VKGRP | AILOA | MANDT |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
MANDT |
| AILOA | VKGRP | AILOA | VKBUR |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKBUR |
| AILOA | VKGRP | AILOA | VKGRP |
TVBVK
Organizational Unit: Sales Groups per Sales Office
|
VKGRP |
| AILOA | VKORG | AILOA | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| AILOA | VKORG | AILOA | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| AILOA | VTWEG | AILOA | VKORG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VKORG |
| AILOA | VTWEG | AILOA | VTWEG |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
VTWEG |
| AILOA | VTWEG | AILOA | MANDT |
TVKOV
Org. Unit: Distribution Channels per Sales Organization
|
MANDT |