1. Home
  2. Resources
  3. SAP Tables
  4. PILOA - Iloa from archive date

SAP Table PILOA

Iloa from archive date

PILOA (Iloa from archive date) 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 PILOA to other SAP tables.

PILOA table fields

Field Data element Checktable Datatype Length Decimals
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
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EQFNR Sort field EQFNR CHAR 30 0
EQFNRI Data origin for sort field INH_EQFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SWERK Maintenance plant SWERK T001W CHAR 4 0
SWERKI Data origin for maintenance plant field INH_SWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
STORT Location of maintenance object PMLOC T499S CHAR 10 0
STORTI Data origin for location field INH_STORTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
MSGRP Room RAUMNR CHAR 8 0
MSGRPI Data origin for room number field INH_MSGRPI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BEBER Plant section BEBER T357 CHAR 3 0
BEBERI Data origin for plant section field INH_BEBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
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
PPSIDI Data origin for PP work center field INH_PPSIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
GSBER Business Area GSBER TGSB CHAR 4 0
GSBERI Data origin for business area field INH_GSBERI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
KOKRSI Data origin for controlling area field INH_KOKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
KOSTL Cost Center KOSTL CSKS CHAR 10 0
KOSTLI Data origin for cost center field INH_KOSTLI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
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
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
BUKRS Company Code BUKRS T001 CHAR 4 0
BUKRSI Data origin for company code field INH_BUKRSI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLNR Main Asset Number ANLN1 ANLH CHAR 12 0
ANLNRI Data origin for asset main no./sub-no. fields INH_ANLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ANLUN Asset Subnumber ANLN2 ANLA CHAR 4 0
ANLUNI Data origin indicator INHER CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
DAUFN Standing order number DAUFN AUFK CHAR 12 0
DAUFNI Data origin of standing order number field INH_DAUFNI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
AUFNR Settlement order ILOM_ORDST AUFK CHAR 12 0
AUFNRI Data origin for settlement order field INH_AUFNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
TPLNRI Data origin for functional location field INH_TPLNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VKORG Sales Organization VKORG TVKO CHAR 4 0
VKORGI Data origin for sales organization field INH_VKORGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
VTWEG Distribution Channel VTWEG TVKOV CHAR 2 0
VTWEGI Data origin of distribution channel field INH_VTWEGI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
SPART Division SPART TVTA CHAR 2 0
SPARTI Data origin for division field INH_SPARTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ADRNR Address number AD_ADDRNUM ADRC CHAR 10 0
ADRNRI Data origin for address field INH_ADRNRI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
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
VKBUR Sales Office VKBUR TVKBZ CHAR 4 0
VKGRP Sales Group VKGRP TVBVK CHAR 3 0

PILOA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PILOA ABCKZ PILOA MANDT T370C ABC indicator for technical objects MANDT
PILOA ABCKZ PILOA ABCKZ T370C ABC indicator for technical objects ABCKZ
PILOA ADRNR PILOA MANDT ADRC Addresses (Business Address Services) CLIENT
PILOA ADRNR PILOA ADRNR ADRC Addresses (Business Address Services) ADDRNUMBER
PILOA ADRNR * ADRC Addresses (Business Address Services) DATE_FROM
PILOA ADRNR * ADRC Addresses (Business Address Services) NATION
PILOA ANLNR PILOA ANLNR ANLH Main asset number ANLN1
PILOA ANLNR PILOA MANDT ANLH Main asset number MANDT
PILOA ANLNR PILOA BUKRS ANLH Main asset number BUKRS
PILOA ANLUN PILOA BUKRS ANLA Asset Master Record Segment BUKRS
PILOA ANLUN PILOA ANLNR ANLA Asset Master Record Segment ANLN1
PILOA ANLUN PILOA ANLUN ANLA Asset Master Record Segment ANLN2
PILOA ANLUN PILOA MANDT ANLA Asset Master Record Segment MANDT
PILOA AUFNR PILOA MANDT AUFK Order master data MANDT
PILOA AUFNR PILOA AUFNR AUFK Order master data AUFNR
PILOA BEBER PILOA SWERK T357 Plant Section WERKS
PILOA BEBER PILOA BEBER T357 Plant Section BEBER
PILOA BEBER PILOA MANDT T357 Plant Section MANDT
PILOA BUKRS PILOA MANDT T001 Company Codes MANDT
PILOA BUKRS PILOA BUKRS T001 Company Codes BUKRS
PILOA DAUFN PILOA MANDT AUFK Order master data MANDT
PILOA DAUFN PILOA DAUFN AUFK Order master data AUFNR
PILOA GSBER PILOA MANDT TGSB Business Areas MANDT
PILOA GSBER PILOA GSBER TGSB Business Areas GSBER
PILOA KOKRS PILOA KOKRS TKA01 Controlling Areas KOKRS
PILOA KOKRS PILOA MANDT TKA01 Controlling Areas MANDT
PILOA KOSTL SYST DATUM CSKS Cost Center Master Data DATBI
PILOA KOSTL PILOA MANDT CSKS Cost Center Master Data MANDT
PILOA KOSTL PILOA KOKRS CSKS Cost Center Master Data KOKRS
PILOA KOSTL PILOA KOSTL CSKS Cost Center Master Data KOSTL
PILOA MANDT PILOA MANDT T000 Clients MANDT
PILOA PPSID PILOA CR_OBJTY CRID CIM Resource - Entities OBJTY
PILOA PPSID PILOA PPSID CRID CIM Resource - Entities OBJID
PILOA PPSID PILOA MANDT CRID CIM Resource - Entities MANDT
PILOA PROID PILOA MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
PILOA PROID PILOA PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
PILOA SPART PILOA VTWEG TVTA Organizational Unit: Sales Area(s) VTWEG
PILOA SPART PILOA SPART TVTA Organizational Unit: Sales Area(s) SPART
PILOA SPART PILOA MANDT TVTA Organizational Unit: Sales Area(s) MANDT
PILOA SPART PILOA VKORG TVTA Organizational Unit: Sales Area(s) VKORG
PILOA STORT PILOA SWERK T499S Location WERKS
PILOA STORT PILOA STORT T499S Location STAND
PILOA STORT PILOA MANDT T499S Location MANDT
PILOA SWERK PILOA MANDT T001W Plants/Branches MANDT
PILOA SWERK PILOA SWERK T001W Plants/Branches WERKS
PILOA TPLNR PILOA MANDT IFLOT Functional Location (Table) MANDT
PILOA TPLNR PILOA TPLNR IFLOT Functional Location (Table) TPLNR
PILOA VKBUR PILOA VTWEG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
PILOA VKBUR PILOA SPART TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
PILOA VKBUR PILOA VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKBUR
PILOA VKBUR PILOA MANDT TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
PILOA VKBUR PILOA VKORG TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
PILOA VKGRP PILOA MANDT TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
PILOA VKGRP PILOA VKBUR TVBVK Organizational Unit: Sales Groups per Sales Office VKBUR
PILOA VKGRP PILOA VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office VKGRP
PILOA VKORG PILOA MANDT TVKO Organizational Unit: Sales Organizations MANDT
PILOA VKORG PILOA VKORG TVKO Organizational Unit: Sales Organizations VKORG
PILOA VTWEG PILOA MANDT TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
PILOA VTWEG PILOA VKORG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
PILOA VTWEG PILOA VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG