SE11 ABAP Dictionary SE11 ILOA

Data SE16 SE16
Popular:
VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

ILOA

PM Object Location and Account Assignment
SAP SAP Transparent Table 48 Fields
Primary Key:
MANDT ILOAN

Dictionary Fields Fields

(48 dari 48 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
ILOAN
KEY Loc/Acc. CHAR 12 - - Location and account assignment for technical object
3
TPLNR
- Func. Loc. CHAR 30 - - Functional Location
4
ABCKZ
- ABC ind. CHAR 1 - - ABC indicator for technical object
5
ABCKZI
- Origin CHAR 1 - - Data origin for ABC indicator field
6
EQFNR
- Sort fld CHAR 30 - - Sort field
7
EQFNRI
- Origin CHAR 1 - - Data origin for sort field
8
SWERK
- MntPlant CHAR 4 - - Maintenance plant
9
SWERKI
- Origin CHAR 1 - - Data origin for maintenance plant field
10
STORT
- Location CHAR 10 - - Location of maintenance object
11
STORTI
- Origin CHAR 1 - - Data origin for location field
12
MSGRP
- Room CHAR 8 - - Room
13
MSGRPI
- Origin CHAR 1 - - Data origin for room number field
14
BEBER
- PlSectn CHAR 3 - - Plant section
15
BEBERI
- Origin CHAR 1 - - Data origin for plant section field
16
CR_OBJTY
- Type CHAR 2 - - Object types of the CIM resource
17
PPSID
- PP WkCtr NUMC 8 - - Object ID of PP work center
18
PPSIDI
- Origin CHAR 1 - - Data origin for PP work center field
19
GSBER
- Bus. Area CHAR 4 - - Business Area
20
GSBERI
- Origin CHAR 1 - - Data origin for business area field
21
KOKRS
- CO Area CHAR 4 - - Controlling Area
22
KOKRSI
- Origin CHAR 1 - - Data origin for controlling area field
23
KOSTL
- Cost Ctr CHAR 10 - - Cost Center
24
KOSTLI
- Origin CHAR 1 - - Data origin for cost center field
25
PROID
- WBS Elem. NUMC 8 - - Work Breakdown Structure Element (WBS Element)
26
PROIDI
- Origin CHAR 1 - - Data origin for WBS element field
27
BUKRS
- CoCode CHAR 4 - T001 Company Code
28
BUKRSI
- Origin CHAR 1 - - Data origin for company code field
29
ANLNR
- Asset CHAR 12 - - Main Asset Number
30
ANLNRI
- Origin CHAR 1 - - Data origin for asset main no./sub-no. fields
31
ANLUN
- Subnumber CHAR 4 - - Asset Subnumber
32
ANLUNI
- Origin CHAR 1 - - Data origin indicator
33
DAUFN
- StdgOrd. CHAR 12 - - Standing order number
34
DAUFNI
- Origin CHAR 1 - - Data origin of standing order number field
35
AUFNR
- StlmtOrder CHAR 12 - - Settlement order
36
AUFNRI
- Origin CHAR 1 - - Data origin for settlement order field
37
TPLNRI
- Origin CHAR 1 - - Data origin for functional location field
38
VKORG
- Sales org. CHAR 4 - - Sales Organization
39
VKORGI
- Origin CHAR 1 - - Data origin for sales organization field
40
VTWEG
- Distr. Chl CHAR 2 - - Distribution Channel
41
VTWEGI
- Origin CHAR 1 - - Data origin of distribution channel field
42
SPART
- Division CHAR 2 - - Division
43
SPARTI
- Origin CHAR 1 - - Data origin for division field
44
ADRNR
- Addr. no. CHAR 10 - - Address number
45
ADRNRI
- Origin CHAR 1 - - Data origin for address field
46
OWNER
- Object ref CHAR 1 - - Object reference indicator
47
VKBUR
- Sales Off. CHAR 4 - - Sales Office
48
VKGRP
- Sales Grp CHAR 3 - - Sales Group

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk ILOA.

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation →
Standard T-Codes
SE11 SE16
Related Tables
T001 EQUI EQKT EQUZ EQST IFLOT IFLOTX IHPA
ANSI SQL Query 
SELECT a.ILOAN,
       a.TPLNR,
       a.ABCKZ,
       a.ABCKZI,
       a.EQFNR,
       a.EQFNRI
FROM ILOA AS a
WHERE a.ILOAN = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~iloan,
       a~tplnr,
       a~abckz,
       a~abckzi,
       a~eqfnr,
       a~eqfnri
  FROM iloa AS a
  WHERE a~iloan = '0001'
  INTO TABLE @DATA(lt_iloa)
  UP TO 100 ROWS.