SAP ABAP Table IFLOT (Functional Location (Table))
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MSE (Application Component) Mobile Service
⤷ ILOM (Package) Application Development R/3 Location Management
⤷ CRM-MSE (Application Component) Mobile Service
⤷ ILOM (Package) Application Development R/3 Location Management
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | IFLOT | Table Relationship Diagram |
Short Description | Functional Location (Table) |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | TPLNR | TPLNR | TPLNR | CHAR | 30 | 0 | Functional Location | ||
3 | .INCLUDE | 0 | 0 | Data part functional location | |||||
4 | MLANG | MLANG | SPRAS | LANG | 1 | 0 | Primary language for object texts | T002 | |
5 | TPLKZ | TPLKZ | TPLKZ | CHAR | 5 | 0 | Functional location structure indicators | T370S | |
6 | FLTYP | FLTYP | FLTYP | CHAR | 1 | 0 | Functional Location Category | T370F | |
7 | TPLMA | TPLMA | TPLNR | CHAR | 30 | 0 | Superior functional location | IFLOT | |
8 | ERDAT | ICRDT | DATUM | DATS | 8 | 0 | Date on Which Object Was Created | ||
9 | ERNAM | ICRNA | USNAM | CHAR | 12 | 0 | Name of User Who Created the Object | ||
10 | AEDAT | IUPDT | DATUM | DATS | 8 | 0 | Date on which the object was last changed | ||
11 | AENAM | IUPNA | USNAM | CHAR | 12 | 0 | Name of the User Who Last Changed the Object | ||
12 | DATAB | ILOM_DATAB | DATUM | DATS | 8 | 0 | Start-up Date of the Technical Object | ||
13 | BEGRU | IAUTG | IAUTG | CHAR | 4 | 0 | Authorization Group for Technical Object | T370B | |
14 | TRPNR | TRPNR | TRPNR | CHAR | 30 | 0 | Reference functional location | IRLOT | |
15 | PSTAE | RESERVE_CHAR_004 | CHAR4 | CHAR | 4 | 0 | SAP Development reserve: Format CHAR, length 4 | ||
16 | STNAM | RESERVE_CHAR_012 | CHAR12 | CHAR | 12 | 0 | SAP Development Reserve: Format CHAR, Length 12 | ||
17 | LVORM | RESERVE_CHAR_001 | CHAR1 | CHAR | 1 | 0 | SAP Development Reserve: Format CHAR, Length 1 | ||
18 | SUBMT | SUBMT | MATNR | CHAR | 18 | 0 | Construction Type Material of the Object | MARA | |
19 | SUBMTI | INH_SUBMTI | INHER | CHAR | 1 | 0 | Data origin for construction type field | ||
20 | MAPAR | MAPAR | MAPAR | CHAR | 30 | 0 | Manufacturer part number | ||
21 | MAPARI | RESERVE_CHAR_001 | CHAR1 | CHAR | 1 | 0 | SAP Development Reserve: Format CHAR, Length 1 | ||
22 | IEQUI | IEQUI | X | CHAR | 1 | 0 | Installation of equipment allowed at the functional location | ||
23 | IEQUII | INH_IEQUII | INHER | CHAR | 1 | 0 | Data origin for equip. inst. allowed field | ||
24 | EINZL | EINZL | XFELD | CHAR | 1 | 0 | Single equipment installation at functional location | ||
25 | EINZLI | INH_BEGRUI | INHER | CHAR | 1 | 0 | Data origin for authorization group field | ||
26 | IWERK | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | T399I | |
27 | IWERKI | INH_IWERKI | INHER | CHAR | 1 | 0 | Data origin for planning plant field | ||
28 | INGRP | INGRP | INGRP | CHAR | 3 | 0 | Planner Group for Customer Service and Plant Maintenance | T024I | |
29 | INGRPI | INH_INGRPI | INHER | CHAR | 1 | 0 | Data origin for maintenance planner group field | ||
30 | PM_OBJTY | PM_OBJTY | CR_OBJTY | CHAR | 2 | 0 | Object Type of CIM Resources for Work Center | ||
31 | LGWID | LGWID | CR_OBJID | NUMC | 8 | 0 | Object ID of the Work Center | CRID | |
32 | LGWIDI | INH_LGWIDI | INHER | CHAR | 1 | 0 | Data Origin for the Field 'Work Center' | ||
33 | RBNR | RBNR | RBNR | CHAR | 9 | 0 | Report layout | T352B | |
34 | RBNR_I | INH_RBNR_I | INHER | CHAR | 1 | 0 | Data origin for maintenance catalog field | ||
35 | ILOAN | ILOAN | ILOAN | CHAR | 12 | 0 | Location and account assignment for technical object | ILOA | |
36 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
37 | POSNR | ILOM_POSNR | CHAR4 | CHAR | 4 | 0 | Position in superior technical object | ||
38 | ISTYP | ILOM_ISTYP | ILOM_ISTYP | CHAR | 1 | 0 | Object category for Industry Solutions (IS) | ||
39 | PREMS | ILOM_PREMS | CHAR10 | CHAR | 10 | 0 | Premise | ||
40 | EQART | EQART | EQART | CHAR | 10 | 0 | Type of Technical Object | T370K | |
41 | INVNR | INVNR | INVNR_ANLA | CHAR | 25 | 0 | Inventory number | ||
42 | GROES | GROSS | GROES | CHAR | 18 | 0 | Size/dimension | ||
43 | BRGEW | BRGEW | MENG13 | QUAN | 13 | 3 | Gross weight | ||
44 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | T006 | |
45 | ANSWT | ANSWT | WERT | CURR | 13 | 2 | Acquisition Value | ||
46 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
47 | ANSDT | ANDTI | DATUM | DATS | 8 | 0 | Acquisition date | ||
48 | HERST | HERST | TEXT30 | CHAR | 30 | 0 | Manufacturer of asset | ||
49 | HERLD | HERLD | LAND1 | CHAR | 3 | 0 | Country of manufacture | T005 | |
50 | BAUJJ | BAUJJ | CJAHR | CHAR | 4 | 0 | Year of construction | ||
51 | BAUMM | BAUMM | BAUMM | CHAR | 2 | 0 | Month of construction | ||
52 | TYPBZ | TYPBZ | TYPBZ | CHAR | 20 | 0 | Manufacturer model number | ||
53 | EMATN | EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | * | |
54 | SERGE | SERGE | CHAR30 | CHAR | 30 | 0 | Manufacturer serial number | ||
55 | HANDLE | ITOBTMP_TSEGGUID | SYSUUID_22 | CHAR | 22 | 0 | SAP Development Reserve: Integration of Date Segment (Key) | ||
56 | TSEGTP | ITOBTMP_TSEGTEMPLA | TSEGTEMPLA | CHAR | 10 | 0 | SAP Development Reserve: Integration Date Segment (Template) | * | |
57 | .INCLUDE | 0 | 0 | ||||||
58 | .INCLU--AP | 0 | 0 | Logbook Tech.Location Append | |||||
59 | FLLB_DUTY | DIACL_DUTY | XFLAG | CHAR | 1 | 0 | Logbook Duty | ||
60 | FLLB_HIDE | DIACL_HIDE | XFLAG | CHAR | 1 | 0 | Hide Logbook Display | ||
61 | .INCLU--AP | 0 | 0 | Enhancements to Shift Note/Report | |||||
62 | IFLOT_SRTYPE | ILOM_SR_SRTYPE | CHAR | 10 | 0 | Shift Report Type for Object | * | ||
63 | IFLOT_SNTYPE | ILOM_SN_SNTYPE | QMART | CHAR | 2 | 0 | Notification Type for Shift Note for Object | TQ80 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | IFLOT | BEGRU | T370B | BEGRU | REF | C | CN |
2 | IFLOT | EQART | T370K | EQART | REF | 1 | CN |
3 | IFLOT | FLTYP | T370F | FLTYP | REF | 1 | CN |
4 | IFLOT | GEWEI | T006 | MSEHI | REF | 1 | CN |
5 | IFLOT | HERLD | T005 | LAND1 | REF | 1 | CN |
6 | IFLOT | IFLOT_SNTYPE | TQ80 | QMART | KEY | 1 | CN |
7 | IFLOT | ILOAN | ILOA | ILOAN | REF | C | CN |
8 | IFLOT | INGRP | T024I | INGRP | REF | C | CN |
9 | IFLOT | IWERK | T399I | IWERK | REF | C | CN |
10 | IFLOT | LGWID | CRID | OBJID | REF | C | CN |
11 | IFLOT | MANDT | T000 | MANDT | KEY | 1 | CN |
12 | IFLOT | MLANG | T002 | SPRAS | REF | C | CN |
13 | IFLOT | OBJNR | ONR00 | OBJNR | REF | C | 1 |
14 | IFLOT | RBNR | T352B | RBNR | REF | C | CN |
15 | IFLOT | SUBMT | MARA | MATNR | REF | C | CN |
16 | IFLOT | TPLKZ | T370S | TPLKZ | REF | 1 | CN |
17 | IFLOT | TPLMA | IFLOT | TPLNR | REF | C | CN |
18 | IFLOT | TRPNR | IRLOT | TRPNR | REF | C | CN |
19 | IFLOT | WAERS | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |