SE11 ABAP Dictionary SE11 IFLOT

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

IFLOT

Functional Location (Table)
SAP SAP Transparent Table 59 Fields
Primary Key:
MANDT TPLNR

Dictionary Fields Fields

(59 dari 59 kolom)
# Field Name Key Field Label Type Length Dec Check Table Short Description
1
MANDT
KEY Client CLNT 3 - T000 Client
2
TPLNR
KEY Func. Loc. CHAR 30 - - Functional Location
3
MLANG
- PriLang. LANG 1 - - Primary language for object texts
4
TPLKZ
- StrInd. CHAR 5 - - Functional location structure indicator
5
FLTYP
- Category CHAR 1 - - Functional location category
6
TPLMA
- SupFLoc. CHAR 30 - - Superior functional location
7
ERDAT
- Created DATS 8 - - Date on which the object was created
8
ERNAM
- Name CHAR 12 - - Name of User Who Created the Object
9
AEDAT
- Changed DATS 8 - - Date on which the object was last changed
10
AENAM
- Name CHAR 12 - - Name of the user who last changed the object
11
DATAB
- Start from DATS 8 - - Start-up Date of the Technical Object
12
BEGRU
- AuthGrp CHAR 4 - - Technical object authorization group
13
TRPNR
- RefLoc. CHAR 30 - - Reference functional location
14
PSTAE
- SAP Development reserve: Format CHAR, length 4 CHAR 4 - - SAP Development reserve: Format CHAR, length 4
15
STNAM
- SAP Development Reserve: Format CHAR, Length 12 CHAR 12 - - SAP Development Reserve: Format CHAR, Length 12
16
LVORM
- SAP Development Reserve: Format CHAR, Length 1 CHAR 1 - - SAP Development Reserve: Format CHAR, Length 1
17
SUBMT
- ConstType CHAR 18 - - Construction type material of the object
18
SUBMTI
- Origin CHAR 1 - - Data origin for construction type field
19
MAPAR
- ManParNo CHAR 30 - - Manufacturer part number
20
MAPARI
- SAP Development Reserve: Format CHAR, Length 1 CHAR 1 - - SAP Development Reserve: Format CHAR, Length 1
21
IEQUI
- EqInstall. CHAR 1 - - Installation of equipment allowed at the functional location
22
IEQUII
- Origin CHAR 1 - - Data origin for equip. inst. allowed field
23
EINZL
- Single CHAR 1 - - Single equipment installation at functional location
24
EINZLI
- Origin CHAR 1 - - Data origin for authorization group field
25
IWERK
- Plng plant CHAR 4 - - Maintenance Planning Plant
26
IWERKI
- Origin CHAR 1 - - Data origin for planning plant field
27
INGRP
- PlannerGrp CHAR 3 - - Planner Group for Customer Service and Plant Maintenance
28
INGRPI
- Origin CHAR 1 - - Data origin for maintenance planner group field
29
PM_OBJTY
- Type CHAR 2 - - Object Type of CIM Resources for Work Center
30
LGWID
- WorkCtr NUMC 8 - - Object ID of the Work Center
31
LGWIDI
- Origin CHAR 1 - - Data Origin for the Field 'Work Center'
32
RBNR
- Cat. Prof. CHAR 9 - - Catalog Profile
33
RBNR_I
- Origin CHAR 1 - - Data origin for maintenance catalog field
34
ILOAN
- Loc/Acc. CHAR 12 - - Location and account assignment for technical object
35
OBJNR
- Obj. no. CHAR 22 - - Object number
36
POSNR
- Position CHAR 4 - - Position in superior technical object
37
ISTYP
- IS cat. CHAR 1 - - Object category for Industry Solutions (IS)
38
PREMS
- Premise CHAR 10 - - Premise
39
EQART
- ObjectType CHAR 10 - - Type of Technical Object
40
INVNR
- InvNo. CHAR 25 - - Inventory number
41
GROES
- Size CHAR 18 - - Size/dimension
42
BRGEW
- Gross QUAN 13 3 - Gross Weight
43
GEWEI
- WeightUnit UNIT 3 - - Weight Unit
44
ANSWT
- Acq.value CURR 13 2 - Acquisition Value
45
WAERS
- Currency CUKY 5 - TCURC Currency Key
46
ANSDT
- AcqDate DATS 8 - - Acquisition date
47
HERST
- Mfr CHAR 30 - - Manufacturer of asset
48
HERLD
- ManCtry CHAR 3 - - Country of manufacture
49
BAUJJ
- ConstYr CHAR 4 - - Year of construction
50
BAUMM
- ConstMth CHAR 2 - - Month of construction
51
TYPBZ
- Model no. CHAR 20 - - Manufacturer model number
52
EMATN
- MPN Mat. CHAR 18 - - Material Number Corresponding to Manufacturer Part Number
53
SERGE
- SerNo. CHAR 30 - - Manufacturer serial number
54
HANDLE
- Handle CHAR 22 - - SAP Development Reserve: Integration of Date Segment (Key)
55
TSEGTP
- Template CHAR 10 - - SAP Development Reserve: Integration Date Segment (Tempate)
56
FLLB_DUTY
- Logbk Duty CHAR 1 - - Logbook Duty
57
FLLB_HIDE
- Hide Logbk CHAR 1 - - Hide Logbook Display
58
IFLOT_SRTYPE
- Type CHAR 10 - - Shift Report Type for Object
59
IFLOT_SNTYPE
- Note Type CHAR 2 - - Notification Type for Shift Note for Object

Related References & SQL

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

Interactive ERD Diagrams
SAP PM & SD - Plant Maintenance Main Tables Relation →
Standard T-Codes
IL03 IL01 IL02 IH06
Related Tables
TCURC EQUI EQKT EQUZ EQST IFLOTX ILOA IHPA
ANSI SQL Query 
SELECT a.TPLNR,
       a.MLANG,
       a.TPLKZ,
       a.FLTYP,
       a.TPLMA,
       a.ERDAT
FROM IFLOT AS a
WHERE a.TPLNR = '0001';
ABAP OpenSQL (7.40+) 
SELECT a~tplnr,
       a~mlang,
       a~tplkz,
       a~fltyp,
       a~tplma,
       a~erdat
  FROM iflot AS a
  WHERE a~tplnr = '0001'
  INTO TABLE @DATA(lt_iflot)
  UP TO 100 ROWS.