IFLOT

Transparent Table Application Table
63 Fields 19 CDS Views

Functional Location (Table)

IFLOT is an SAP database table in S/4HANA. Functional Location (Table). It contains 63 fields. 19 CDS views read from this table.

CDS Views using this table (19)

ViewTypeJoinVDMDescription
/merp/pm_Measuring_Point view inner CDS View: Measuring Point
CRMS4_IU_C_CONPA view inner Connection object by partner
CRMS4_IU_C_PRMADDR view inner Premise by Address
CRMS4_IU_I_CON view inner Connection object
CRMS4_IU_I_DEV view left_outer Device
CRMS4_IU_I_DEVH view left_outer Device History
CRMS4_IU_I_DEVLOC view_entity inner Device Location
E_FunctionalLocation view from EXTENSION Functional Location Extension
I_FuncLocationLabelSearch view union_all BASIC Functional Location Search
I_FunctionalLocation view from BASIC Functional Location
I_GhoIflot_Db view from BASIC Functional Location
SHSM_I_EDISCDOCCONNOBJ view inner CDS SH for Disc. Doc. with Ref. Obj. Conn Obj
UPOV_PR_DN_UOM view left_outer Delivery Network(UOM)
UPOV_PR_DNVD_UOM view inner Delivery Network Variable Data_UOM
UPOV_PR_MP_UOM view inner Measurement Point (UOM)
UPOV_PR_MPVD_UOM view left_outer Measure Point Variable Data UOM data
UPOV_PR_WC_UOM view left_outer UOM: Well Completion
UPOV_PR_WCVD_UOM view left_outer UOM: Well Completion Variable Data UOM
UPOV_PR_WELL_UOM view left_outer UOM: Well

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tplnr TPLNR Functional loc.
mlang MLANG Primary lang.
tplkz TPLKZ StrIndicator
fltyp FLTYP FunctLocCat.
tplma TPLMA SupFunctLoc.
erdat ICRDT Created on
ernam ICRNA Created by
aedat IUPDT Changed on
aenam IUPNA Changed by
datab ILOM_DATAB Start-up date
begru IAUTG AuthorizGroup
trpnr TRPNR RefLocation
pstae RESERVE_CHAR_004 SAP Development reserve: Format CHAR, length 4
stnam RESERVE_CHAR_012 SAP Development Reserve: Format CHAR, Length 12
lvorm RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
submt SUBMT ConstType
submti INH_SUBMTI ConsType orig.
mapar MAPAR ManufPartNo.
mapari RESERVE_CHAR_001 SAP Development Reserve: Format CHAR, Length 1
iequi IEQUI EquipInstall.
iequii INH_IEQUII EqInst. orig.
einzl EINZL Single inst.
einzli INH_BEGRUI AuthGrp orig.
iwerk IWERK Planning Plant
iwerki INH_IWERKI PlPlan orig.
ingrp INGRP Planner Group
ingrpi INH_INGRPI MPlGroup orig.
pm_objty PM_OBJTY Object Type
lgwid LGWID Work Center
lgwidi INH_LGWIDI WorkCtr origin
rbnr RBNR Catalog Profile
rbnr_i INH_RBNR_I MntCatlg orig.
iloan ILOAN Loc/AccAssmt
objnr J_OBJNR Object number
posnr ILOM_POSNR Position
istyp ILOM_ISTYP IS category
prems ILOM_PREMS Premise
eqart EQART Object Type
invnr INVNR Inventory No.
groes GROSS Size/dimens.
brgew BRGEW Gross Weight
gewei GEWEI Unit of Weight
answt ANSWT AcquistnValue
waers WAERS Currency
ansdt ANDTI Acquistion date
herst HERST Manufacturer
herld HERLD Mfr Ctry/Reg
baujj BAUJJ ConstructYear
baumm BAUMM ConstructMth
typbz TYPBZ Model number
ematn EMATN MPN: Material
serge SERGE Manuf. SerialNr
handle ITOBTMP_TSEGGUID Handle
tsegtp ITOBTMP_TSEGTEMPLA Template
changeddatetime TZNTSTMPS Time Stamp
endofuse ENDOFUSE_DATE End-of-Use Date
functionallocationoid FUNCTIONALLOCATION_OID FuncLoc Instce ID
dummy_iflot_incl_eew_ps CFD_DUMMY Dummy
fllb_duty DIACL_DUTY Logbk Duty
fllb_hide DIACL_HIDE Hide Logbook
iflot_srtype ILOM_SR_SRTYPE Report Type
iflot_sntype ILOM_SN_SNTYPE Shift Note Type

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Functional Location (Table)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IFLOT (
    MANDT,                    -- Client [MANDT]
    TPLNR,                    -- Functional loc. [TPLNR]
    MLANG,                    -- Primary lang. [MLANG]
    TPLKZ,                    -- StrIndicator [TPLKZ]
    FLTYP,                    -- FunctLocCat. [FLTYP]
    TPLMA,                    -- SupFunctLoc. [TPLMA]
    ERDAT,                    -- Created on [ICRDT]
    ERNAM,                    -- Created by [ICRNA]
    AEDAT,                    -- Changed on [IUPDT]
    AENAM,                    -- Changed by [IUPNA]
    DATAB,                    -- Start-up date [ILOM_DATAB]
    BEGRU,                    -- AuthorizGroup [IAUTG]
    TRPNR,                    -- RefLocation [TRPNR]
    PSTAE,                    -- SAP Development reserve: Format CHAR, length 4 [RESERVE_CHAR_004]
    STNAM,                    -- SAP Development Reserve: Format CHAR, Length 12 [RESERVE_CHAR_012]
    LVORM,                    -- SAP Development Reserve: Format CHAR, Length 1 [RESERVE_CHAR_001]
    SUBMT,                    -- ConstType [SUBMT]
    SUBMTI,                   -- ConsType orig. [INH_SUBMTI]
    MAPAR,                    -- ManufPartNo. [MAPAR]
    MAPARI,                   -- SAP Development Reserve: Format CHAR, Length 1 [RESERVE_CHAR_001]
    IEQUI,                    -- EquipInstall. [IEQUI]
    IEQUII,                   -- EqInst. orig. [INH_IEQUII]
    EINZL,                    -- Single inst. [EINZL]
    EINZLI,                   -- AuthGrp orig. [INH_BEGRUI]
    IWERK,                    -- Planning Plant [IWERK]
    IWERKI,                   -- PlPlan orig. [INH_IWERKI]
    INGRP,                    -- Planner Group [INGRP]
    INGRPI,                   -- MPlGroup orig. [INH_INGRPI]
    PM_OBJTY,                 -- Object Type [PM_OBJTY]
    LGWID,                    -- Work Center [LGWID]
    LGWIDI,                   -- WorkCtr origin [INH_LGWIDI]
    RBNR,                     -- Catalog Profile [RBNR]
    RBNR_I,                   -- MntCatlg orig. [INH_RBNR_I]
    ILOAN,                    -- Loc/AccAssmt [ILOAN]
    OBJNR,                    -- Object number [J_OBJNR]
    POSNR,                    -- Position [ILOM_POSNR]
    ISTYP,                    -- IS category [ILOM_ISTYP]
    PREMS,                    -- Premise [ILOM_PREMS]
    EQART,                    -- Object Type [EQART]
    INVNR,                    -- Inventory No. [INVNR]
    GROES,                    -- Size/dimens. [GROSS]
    BRGEW,                    -- Gross Weight [BRGEW]
    GEWEI,                    -- Unit of Weight [GEWEI]
    ANSWT,                    -- AcquistnValue [ANSWT]
    WAERS,                    -- Currency [WAERS]
    ANSDT,                    -- Acquistion date [ANDTI]
    HERST,                    -- Manufacturer [HERST]
    HERLD,                    -- Mfr Ctry/Reg [HERLD]
    BAUJJ,                    -- ConstructYear [BAUJJ]
    BAUMM,                    -- ConstructMth [BAUMM]
    TYPBZ,                    -- Model number [TYPBZ]
    EMATN,                    -- MPN: Material [EMATN]
    SERGE,                    -- Manuf. SerialNr [SERGE]
    HANDLE,                   -- Handle [ITOBTMP_TSEGGUID]
    TSEGTP,                   -- Template [ITOBTMP_TSEGTEMPLA]
    CHANGEDDATETIME,          -- Time Stamp [TZNTSTMPS]
    ENDOFUSE,                 -- End-of-Use Date [ENDOFUSE_DATE]
    FUNCTIONALLOCATIONOID,    -- FuncLoc Instce ID [FUNCTIONALLOCATION_OID]
    DUMMY_IFLOT_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    FLLB_DUTY,                -- Logbk Duty [DIACL_DUTY]
    FLLB_HIDE,                -- Hide Logbook [DIACL_HIDE]
    IFLOT_SRTYPE,             -- Report Type [ILOM_SR_SRTYPE]
    IFLOT_SNTYPE,             -- Shift Note Type [ILOM_SN_SNTYPE]
    PRIMARY KEY (MANDT, TPLNR)
);

Learn More