SAP table DIIFLOX (Functional location)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
STRNO Functional Location Label CHAR 40 0 ILOM_STRNO
MLANG Primary language for object texts LANG 1 0 T002 MLANG
TPLKZ Functional Location Structure Indicator CHAR 5 0 T370S TPLKZ
FLTYP Functional location category CHAR 1 0 T370F FLTYP
TPLMA Superior functional location CHAR 30 0 IFLOT TPLMA
ERDAT Date on which the object was created DATS 8 0 ICRDT
ERNAM Name of User Who Created the Object CHAR 12 0 ICRNA
AEDAT Date on which the object was last changed DATS 8 0 IUPDT
AENAM Name of the user who last changed the object CHAR 12 0 IUPNA
DATAB Start-up Date of the Technical Object DATS 8 0 ILOM_DATAB
BEGRU Technical Object Authorization Group CHAR 4 0 T370B IAUTG
TRPNR Reference functional location CHAR 30 0 IRLOT TRPNR
PSTAE SAP Development reserve: Format CHAR, length 4 CHAR 4 0 RESERVE_CHAR_004
STNAM SAP Development Reserve: Format CHAR, Length 12 CHAR 12 0 RESERVE_CHAR_012
LVORM SAP Development Reserve: Format CHAR, Length 1 CHAR 1 0 RESERVE_CHAR_001
SUBMT Construction type material of the object CHAR 40 0 MARA SUBMT
SUBMTI Data origin for construction type field CHAR 1 0 INH_SUBMTI
MAPAR Manufacturer part number CHAR 30 0 MAPAR
MAPARI SAP Development Reserve: Format CHAR, Length 1 CHAR 1 0 RESERVE_CHAR_001
IEQUI Installation of equipment allowed at the functional location CHAR 1 0 IEQUI
IEQUII Data origin for equip. inst. allowed field CHAR 1 0 INH_IEQUII
EINZL Single equipment installation at functional location CHAR 1 0 EINZL
EINZLI Data origin for authorization group field CHAR 1 0 INH_BEGRUI
IWERK Maintenance Planning Plant CHAR 4 0 T399I IWERK
IWERKI Data origin for planning plant field CHAR 1 0 INH_IWERKI
INGRP Planner Group for Customer Service and Plant Maintenance CHAR 3 0 T024I INGRP
INGRPI Data origin for maintenance planner group field CHAR 1 0 INH_INGRPI
PM_OBJTY Object Type of CIM Resources for Work Center CHAR 2 0 PM_OBJTY
LGWID Object ID of the Work Center NUMC 8 0 CRID LGWID
LGWIDI Data Origin for the Field 'Work Center' CHAR 1 0 INH_LGWIDI
RBNR Catalog Profile CHAR 9 0 T352B RBNR
RBNR_I Data origin for maintenance catalog field CHAR 1 0 INH_RBNR_I
ILOAN Location and account assignment for technical object CHAR 12 0 ILOA ILOAN
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
POSNR Position in superior technical object CHAR 4 0 ILOM_POSNR
ISTYP Object category for Industry Solutions (IS) CHAR 1 0 ILOM_ISTYP
C Connection object IS-U
D Device location IS-U
PREMS Premise CHAR 10 0 ILOM_PREMS
EQART Type of Technical Object CHAR 10 0 T370K EQART
INVNR Inventory number CHAR 25 0 INVNR
GROES Size/dimension CHAR 18 0 GROSS
BRGEW Gross weight QUAN 13 3 BRGEW
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
ANSWT Acquisition Value CURR 13 2 ANSWT
WAERS Currency Key CUKY 5 0 TCURC WAERS
ANSDT Acquisition date DATS 8 0 ANDTI
HERST Manufacturer of Asset CHAR 30 0 HERST
HERLD Country/Region of Manufacture CHAR 3 0 T005 HERLD
BAUJJ Year of construction CHAR 4 0 BAUJJ
BAUMM Month of construction CHAR 2 0 BAUMM
00
TYPBZ Manufacturer model number CHAR 20 0 TYPBZ
EMATN Material number corresponding to manufacturer part number CHAR 40 0 * EMATN
SERGE Manufacturer's Serial Number CHAR 30 0 SERGE
HANDLE SAP Development Reserve: Integration of Date Segment (Key) CHAR 22 0 ITOBTMP_TSEGGUID
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) CHAR 10 0 * ITOBTMP_TSEGTEMPLA
CHANGEDDATETIME UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
ENDOFUSE End-of-Use Date of the Technical Object DATS 8 0 ENDOFUSE_DATE
DUMMY_IFLOT_INCL_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
FLLB_DUTY Logbook Duty CHAR 1 0 DIACL_DUTY
FLLB_HIDE Hide Logbook Display CHAR 1 0 DIACL_HIDE
IFLOT_SRTYPE Shift Report Type for Object CHAR 10 0 ILOM_SR_SRTYPE
IFLOT_SNTYPE Notification Type for Shift Note for Object CHAR 2 0 TQ80 ILOM_SN_SNTYPE
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
ABCKZ ABC Indicator for Technical Object CHAR 1 0 T370C ABCKZ
ABCKZI Data origin for ABC indicator field CHAR 1 0 INH_ABCKZI
EQFNR Sort Field CHAR 30 0 EQFNR
EQFNRI Data origin for sort field CHAR 1 0 INH_EQFNRI
SWERK Maintenance Plant CHAR 4 0 T001W SWERK
SWERKI Data origin for maintenance plant field CHAR 1 0 INH_SWERKI
STORT Location of maintenance object CHAR 10 0 T499S PMLOC
STORTI Data origin for location field CHAR 1 0 INH_STORTI
MSGRP Room CHAR 8 0 RAUMNR
MSGRPI Data origin for room number field CHAR 1 0 INH_MSGRPI
BEBER Plant Section CHAR 3 0 T357 BEBER
BEBERI Data origin for plant section field CHAR 1 0 INH_BEBERI
CR_OBJTY Object types of the CIM resource CHAR 2 0 CR_OBJTY
A Work Center
AA Work center alias
FH Production resources/tools
G Group
H Hierarchy
PPSID Object ID of PP work center NUMC 8 0 CRID PPSID
PPSIDI Data origin for PP work center field CHAR 1 0 INH_PPSIDI
GSBER Business Area CHAR 4 0 TGSB GSBER
GSBERI Data origin for business area field CHAR 1 0 INH_GSBERI
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KOKRSI Data origin for controlling area field CHAR 1 0 INH_KOKRSI
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
KOSTLI Data origin for cost center field CHAR 1 0 INH_KOSTLI
PROID Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
PROIDI Data origin for WBS element field CHAR 1 0 INH_PROIDI
BUKRS Company Code CHAR 4 0 T001 BUKRS
BUKRSI Data origin for company code field CHAR 1 0 INH_BUKRSI
ANLNR Main Asset Number CHAR 12 0 ANLH ANLN1
ANLNRI Data origin for asset main no./sub-no. fields CHAR 1 0 INH_ANLNRI
ANLUN Asset Subnumber CHAR 4 0 ANLA ANLN2
ANLUNI Data origin indicator CHAR 1 0 INHER
D Field maintained directly. No data transfer
H Data transfer from superior object
R Data transfer from reference object
DAUFN Standing order number CHAR 12 0 AUFK DAUFN
DAUFNI Data origin of standing order number field CHAR 1 0 INH_DAUFNI
AUFNR Settlement order CHAR 12 0 AUFK ILOM_ORDST
AUFNRI Data origin for settlement order field CHAR 1 0 INH_AUFNRI
TPLNRI Data origin for functional location field CHAR 1 0 INH_TPLNRI
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VKORGI Data origin for sales organization field CHAR 1 0 INH_VKORGI
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
VTWEGI Data origin of distribution channel field CHAR 1 0 INH_VTWEGI
SPART Division CHAR 2 0 TVTA SPART
SPARTI Data origin for division field CHAR 1 0 INH_SPARTI
ADRNR Address Number CHAR 10 0 ADRC AD_ADDRNUM
ADRNRI Data origin for address field CHAR 1 0 INH_ADRNRI
OWNER Object reference indicator CHAR 1 0 ILOM_OWNER
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 CHAR 4 0 TVKBZ VKBUR
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
SPRAS Language Key LANG 1 0 T002 SPRAS
PLTXT Description of functional location CHAR 40 0 PLTXT
KZLTX Long Text Indicator CHAR 1 0 KZLTA
KZMLA Primary language indicator for text segment CHAR 1 0 KZMLA
ARBPL Work Center CHAR 8 0 ARBPL
GEWRK Main work center for maintenance tasks CHAR 8 0 GEWRK
WERGW Plant associated with main work center CHAR 4 0 * WERGW
STTXT System status line CHAR 40 0 J_STEXT
USTXT User Status Line CHAR 40 0 J_ATEXT
RKEOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
NAME_LIST Name for List Displays CHAR 35 0 I_NAME_LST
TEL_NUMBER First telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR1
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
COUNTRY Country/Region Key CHAR 3 0 * LAND1
REGION Region (State, Province, County) CHAR 3 0 * REGIO
STREET Street CHAR 60 0 AD_STREET

DIIFLOX foreign key relationships

Table Field Check Table Check Field
0 DIIFLOX ABCKZ T370C ABC indicator for technical objects MANDT
1 DIIFLOX ADRNR ADRC Addresses (Business Address Services) DATE_FROM
1 DIIFLOX ADRNR ADRC Addresses (Business Address Services) NATION
0 DIIFLOX ANLNR ANLH Main asset number BUKRS
0 DIIFLOX ANLNR ANLH Main asset number ANLN1
1 DIIFLOX ANLUN ANLA Asset Master Record Segment BUKRS
1 DIIFLOX ANLUN ANLA Asset Master Record Segment ANLN1
1 DIIFLOX ANLUN ANLA Asset Master Record Segment ANLN2
0 DIIFLOX AUFNR AUFK Order master data AUFNR
1 DIIFLOX BEBER T357 Plant Section MANDT
1 DIIFLOX BEBER T357 Plant Section BEBER
0 DIIFLOX BEGRU T370B Technical object authorization group MANDT
0 DIIFLOX BEGRU T370B Technical object authorization group BEGRU
1 DIIFLOX BUKRS T001 Company Codes BUKRS
0 DIIFLOX DAUFN AUFK Order master data AUFNR
1 DIIFLOX EQART T370K Type of technical object MANDT
1 DIIFLOX EQART T370K Type of technical object EQART
0 DIIFLOX FLTYP T370F Functional Location Category MANDT
0 DIIFLOX FLTYP T370F Functional Location Category FLTYP
1 DIIFLOX GEWEI T006 Units of Measurement MANDT
1 DIIFLOX GEWEI T006 Units of Measurement MSEHI
0 DIIFLOX GSBER TGSB Business Areas MANDT
0 DIIFLOX GSBER TGSB Business Areas GSBER
1 DIIFLOX HERLD T005 Countries MANDT
1 DIIFLOX HERLD T005 Countries LAND1
0 DIIFLOX IFLOT_SNTYPE TQ80 Notification Types MANDT
0 DIIFLOX IFLOT_SNTYPE TQ80 Notification Types QMART
1 DIIFLOX ILOAN ILOA PM Object Location and Account Assignment MANDT
1 DIIFLOX ILOAN ILOA PM Object Location and Account Assignment ILOAN
0 DIIFLOX INGRP T024I Maintenance planner groups INGRP
1 DIIFLOX IWERK T399I Planning plant parameters MANDT
0 DIIFLOX KOKRS TKA01 Controlling Areas MANDT
1 DIIFLOX KOSTL CSKS Cost Center Master Record MANDT
1 DIIFLOX KOSTL CSKS Cost Center Master Record KOKRS
1 DIIFLOX KOSTL CSKS Cost Center Master Record KOSTL
1 DIIFLOX KOSTL CSKS Cost Center Master Record DATBI
0 DIIFLOX LGWID CRID CIM Resource - Entities MANDT
0 DIIFLOX LGWID CRID CIM Resource - Entities OBJID
1 DIIFLOX MANDT T000 Clients MANDT
0 DIIFLOX MLANG T002 Language Keys (Component BC-I18) SPRAS
1 DIIFLOX OBJNR ONR00 General Object Number MANDT
0 DIIFLOX PPSID CRID CIM Resource - Entities MANDT
0 DIIFLOX PPSID CRID CIM Resource - Entities OBJID
1 DIIFLOX PROID PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 DIIFLOX PROID PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 DIIFLOX RBNR T352B Technical report MANDT
1 DIIFLOX SPART TVTA Organizational Unit: Sales Area(s) MANDT
1 DIIFLOX SPART TVTA Organizational Unit: Sales Area(s) VKORG
1 DIIFLOX SPART TVTA Organizational Unit: Sales Area(s) VTWEG
1 DIIFLOX SPART TVTA Organizational Unit: Sales Area(s) SPART
0 DIIFLOX SPRAS T002 Language Keys (Component BC-I18) SPRAS
1 DIIFLOX STORT T499S Location MANDT
1 DIIFLOX STORT T499S Location WERKS
0 DIIFLOX SUBMT MARA General Material Data MANDT
0 DIIFLOX SUBMT MARA General Material Data MATNR
1 DIIFLOX SWERK T001W Plants/Branches MANDT
1 DIIFLOX SWERK T001W Plants/Branches WERKS
0 DIIFLOX TPLKZ T370S Functional Location Structure Indicators MANDT
0 DIIFLOX TPLKZ T370S Functional Location Structure Indicators TPLKZ
1 DIIFLOX TRPNR IRLOT Reference Functional Location (Table) TRPNR
0 DIIFLOX VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
0 DIIFLOX VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
0 DIIFLOX VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
0 DIIFLOX VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
1 DIIFLOX VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
0 DIIFLOX VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 DIIFLOX VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 DIIFLOX VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
1 DIIFLOX VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
1 DIIFLOX VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
0 DIIFLOX WAERS TCURC Currency Codes MANDT
0 DIIFLOX WAERS TCURC Currency Codes WAERS