1. Home
  2. Resources
  3. SAP Tables
  4. ILOAW - WORK STRUCTURE LOCATION AND ACCOUNT ASSIGNMENT DATA

SAP Table ILOAW

WORK STRUCTURE LOCATION AND ACCOUNT ASSIGNMENT DATA

ILOAW (WORK STRUCTURE LOCATION AND ACCOUNT ASSIGNMENT DATA) 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 ILOAW to other SAP tables.

ILOAW table fields

Field Data element Checktable Datatype Length Decimals
TPLNR Functional Location TPLNR IFLOT CHAR 30 0
ABCKZ ABC indicator for technical object ABCKZ T370C CHAR 1 0
EQFNR Sort field EQFNR CHAR 30 0
SWERK Maintenance plant SWERK T001W CHAR 4 0
STORT Asset location STORT T499S CHAR 10 0
MSGRP Room RAUMNR CHAR 8 0
BEBER Plant section BEBER T357 CHAR 3 0
CR_OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
PPSID Object ID of PP work center PPSID CRID NUMC 8 0
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
DAUFN Standing order number DAUFN AUFK CHAR 12 0
KOSTL Cost Center KOSTL CSKS CHAR 10 0
ANLNR Main Asset Number ANLN1 ANLH CHAR 12 0
ANLUN Asset Subnumber ANLN2 ANLA CHAR 4 0
IAUFNR Order Number AUFNR AUFK CHAR 12 0
IKOKRS Controlling Area KOKRS TKA01 CHAR 4 0
IBUKRS Company Code BUKRS T001 CHAR 4 0
IGSBER Business Area GSBER TGSB CHAR 4 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
ADRNR Addresses: Address Number CADNR CHAR 10 0
OWNER Object reference indicator ILOM_OWNER CHAR 1 0
NULL Equipment, current time segment
1 Equipment, historical time segment
2 Functional location
3 Maintenance item without object reference
4 Notification, current, without object reference
5 Notification, historical
6 Order, current, without object reference
7 Order, historical

ILOAW foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ILOAW ABCKZ CAUFVD MANDT T370C ABC indicator for technical objects MANDT
ILOAW ABCKZ ILOAW ABCKZ T370C ABC indicator for technical objects ABCKZ
ILOAW ANLNR ILOAW ANLNR ANLH Main asset number ANLN1
ILOAW ANLNR CAUFVD MANDT ANLH Main asset number MANDT
ILOAW ANLNR ILOAW IBUKRS ANLH Main asset number BUKRS
ILOAW ANLUN CAUFVD MANDT ANLA Asset Master Record Segment MANDT
ILOAW ANLUN ILOAW IBUKRS ANLA Asset Master Record Segment BUKRS
ILOAW ANLUN ILOAW ANLNR ANLA Asset Master Record Segment ANLN1
ILOAW ANLUN ILOAW ANLUN ANLA Asset Master Record Segment ANLN2
ILOAW BEBER ILOAW SWERK T357 Plant Section WERKS
ILOAW BEBER ILOAW BEBER T357 Plant Section BEBER
ILOAW BEBER CAUFVD MANDT T357 Plant Section MANDT
ILOAW DAUFN CAUFVD MANDT AUFK Order master data MANDT
ILOAW DAUFN ILOAW DAUFN AUFK Order master data AUFNR
ILOAW IAUFNR CAUFVD MANDT AUFK Order master data MANDT
ILOAW IAUFNR ILOAW IAUFNR AUFK Order master data AUFNR
ILOAW IBUKRS CAUFVD MANDT T001 Company Codes MANDT
ILOAW IBUKRS ILOAW IBUKRS T001 Company Codes BUKRS
ILOAW IGSBER CAUFVD MANDT TGSB Business Areas MANDT
ILOAW IGSBER ILOAW IGSBER TGSB Business Areas GSBER
ILOAW IKOKRS CAUFVD MANDT TKA01 Controlling Areas MANDT
ILOAW IKOKRS ILOAW IKOKRS TKA01 Controlling Areas KOKRS
ILOAW KOSTL ILOAW KOSTL CSKS Cost Center Master Data KOSTL
ILOAW KOSTL SYST DATUM CSKS Cost Center Master Data DATBI
ILOAW KOSTL CAUFVD MANDT CSKS Cost Center Master Data MANDT
ILOAW KOSTL ILOAW IKOKRS CSKS Cost Center Master Data KOKRS
ILOAW PPSID CAUFVD MANDT CRID CIM Resource - Entities MANDT
ILOAW PPSID ILOAW CR_OBJTY CRID CIM Resource - Entities OBJTY
ILOAW PPSID ILOAW PPSID CRID CIM Resource - Entities OBJID
ILOAW PROID CAUFVD MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
ILOAW PROID ILOAW PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
ILOAW SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
ILOAW SPART ILOAW SPART TSPA Organizational Unit: Sales Divisions SPART
ILOAW STORT ILOAW SWERK T499S Location WERKS
ILOAW STORT ILOAW STORT T499S Location STAND
ILOAW STORT CAUFVD MANDT T499S Location MANDT
ILOAW SWERK CAUFVD MANDT T001W Plants/Branches MANDT
ILOAW SWERK ILOAW SWERK T001W Plants/Branches WERKS
ILOAW TPLNR CAUFVD MANDT IFLOT Functional Location (Table) MANDT
ILOAW TPLNR ILOAW TPLNR IFLOT Functional Location (Table) TPLNR
ILOAW VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
ILOAW VKORG ILOAW VKORG TVKO Organizational Unit: Sales Organizations VKORG
ILOAW VTWEG ILOAW VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
ILOAW VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT