1. Home
  2. Resources
  3. SAP Tables
  4. DIIFLOX - Functional location

SAP Table DIIFLOX

Functional location

DIIFLOX (Functional location) 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 DIIFLOX to other SAP tables.

DIIFLOX table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
STRNO Functional Location Label ILOM_STRNO CHAR 40 0
MLANG Primary language for object texts MLANG T002 LANG 1 0
TPLKZ Functional location structure indicator TPLKZ T370S CHAR 5 0
FLTYP Functional location category FLTYP T370F CHAR 1 0
TPLMA Superior functional location TPLMA IFLOT CHAR 30 0
ERDAT Date on which the object was created ICRDT DATS 8 0
ERNAM Name of User Who Created the Object ICRNA CHAR 12 0
AEDAT Date on which the object was last changed IUPDT DATS 8 0
AENAM Name of the user who last changed the object IUPNA CHAR 12 0
DATAB Start-up Date of the Technical Object ILOM_DATAB DATS 8 0
BEGRU Technical object authorization group IAUTG T370B CHAR 4 0
TRPNR Reference functional location TRPNR IRLOT CHAR 30 0
PSTAE SAP Development reserve: Format CHAR, length 4 RESERVE_CHAR_004 CHAR 4 0
STNAM SAP Development Reserve: Format CHAR, Length 12 RESERVE_CHAR_012 CHAR 12 0
LVORM SAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001 CHAR 1 0
SUBMT Construction type material of the object SUBMT MARA CHAR 18 0
SUBMTI Data origin for construction type field INH_SUBMTI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
MAPAR Manufacturer part number MAPAR CHAR 30 0
MAPARI SAP Development Reserve: Format CHAR, Length 1 RESERVE_CHAR_001 CHAR 1 0
IEQUI Installation of equipment allowed at the functional location IEQUI CHAR 1 0
X Yes
NULL No
IEQUII Data origin for equip. inst. allowed field INH_IEQUII CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
EINZL Single equipment installation at functional location EINZL CHAR 1 0
X Yes
NULL No
EINZLI Data origin for authorization group field INH_BEGRUI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
IWERK Maintenance Planning Plant IWERK T399I CHAR 4 0
IWERKI Data origin for planning plant field INH_IWERKI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
INGRP Planner Group for Customer Service and Plant Maintenance INGRP T024I CHAR 3 0
INGRPI Data origin for maintenance planner group field INH_INGRPI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
PM_OBJTY Object Type of CIM Resources for Work Center PM_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
LGWID Object ID of the Work Center LGWID CRID NUMC 8 0
LGWIDI Data Origin for the Field 'Work Center' INH_LGWIDI CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
RBNR Catalog Profile RBNR T352B CHAR 9 0
RBNR_I Data origin for maintenance catalog field INH_RBNR_I CHAR 1 0
R Data transfer from reference object
H Data transfer from superior object
D Field maintained directly. No data transfer
ILOAN Location and account assignment for technical object ILOAN ILOA CHAR 12 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
POSNR Position in superior technical object ILOM_POSNR CHAR 4 0
ISTYP Object category for Industry Solutions (IS) ILOM_ISTYP CHAR 1 0
D Device location IS-U
C Connection object IS-U
PREMS Premise ILOM_PREMS CHAR 10 0
EQART Type of Technical Object EQART T370K CHAR 10 0
INVNR Inventory number INVNR CHAR 25 0
GROES Size/dimension GROSS CHAR 18 0
BRGEW Gross Weight BRGEW QUAN 13 3
GEWEI Weight Unit GEWEI T006 UNIT 3 0
ANSWT Acquisition Value ANSWT CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
ANSDT Acquisition date ANDTI DATS 8 0
HERST Manufacturer of asset HERST CHAR 30 0
HERLD Country of manufacture HERLD T005 CHAR 3 0
BAUJJ Year of construction BAUJJ CHAR 4 0
BAUMM Month of construction BAUMM CHAR 2 0
00
TYPBZ Manufacturer model number TYPBZ CHAR 20 0
EMATN Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
SERGE Manufacturer serial number SERGE CHAR 30 0
HANDLE SAP Development Reserve: Integration of Date Segment (Key) ITOBTMP_TSEGGUID CHAR 22 0
TSEGTP SAP Development Reserve: Integration Date Segment (Tempate) ITOBTMP_TSEGTEMPLA CHAR 10 0
FLLB_DUTY Logbook Duty DIACL_DUTY CHAR 1 0
NULL Blank
. Radio button
X Selection
FLLB_HIDE Hide Logbook Display DIACL_HIDE CHAR 1 0
NULL Blank
. Radio button
X Selection
IFLOT_SRTYPE Shift Report Type for Object ILOM_SR_SRTYPE CHAR 10 0
IFLOT_SNTYPE Notification Type for Shift Note for Object ILOM_SN_SNTYPE TQ80 CHAR 2 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
SPRAS Language Key SPRAS T002 LANG 1 0
PLTXT Description of functional location PLTXT CHAR 40 0
KZLTX Long Text Indicator KZLTA CHAR 1 0
X Yes
NULL No
KZMLA Primary language indicator for text segment KZMLA CHAR 1 0
ARBPL Work center ARBPL CHAR 8 0
GEWRK Main work center for maintenance tasks GEWRK CHAR 8 0
WERGW Plant associated with main work center WERGW CHAR 4 0
STTXT System status line J_STEXT CHAR 40 0
USTXT User Status Line J_ATEXT CHAR 40 0
RKEOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
NAME_LIST Name for list displays I_NAME_LST CHAR 35 0
TEL_NUMBER First telephone no.: dialling code+number AD_TLNMBR1 CHAR 30 0
POST_CODE1 City postal code AD_PSTCD1 CHAR 10 0
CITY1 City AD_CITY1 CHAR 40 0
CITY2 District AD_CITY2 CHAR 40 0
COUNTRY Country Key LAND1 CHAR 3 0
REGION Region (State, Province, County) REGIO CHAR 3 0
STREET Street AD_STREET CHAR 60 0

DIIFLOX foreign key relationships

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