IFLOS

Transparent Table Application Table
12 Fields 12 CDS Views

Functional Location Labels

IFLOS is an SAP database table in S/4HANA. Functional Location Labels. It contains 12 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
I_FunclocationLabelInternal view from BASIC Functional Location Label Internal
I_FuncLocationLabelSearch view from BASIC Functional Location Search
I_GHOProdnNtwkLabel view from BASIC Production Network Alternate Label
UPOV_GET_WC view inner Separate WC from STRNO
UPOV_NWOBJ_NAME_TYPE view inner NW Object Name - Alpha Numeric / Numeric
UPOV_PPN_EV_SET_X view left_outer PPN event to Set Cross Reference
UPOV_PPN_EVENT view left_outer PPN Event
UPOV_PPN_EVRF_BA view left_outer Event Detail Ref - Before/After data
UPOV_PPN_SET_WC view left_outer PPN for Well Test
UPOV_PR_ALKEY_OBJ view inner Alternate Labelling for Network objects
UPOV_TRIM_FUNCLABEL_UOM view from Trimmed Function Location Label UOM
UPOV_TRIM_FUNCLABEL_UOMWC view inner Trimmed Functional Location for Label WC

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tplnr TPLNR Functional loc.
KEY alkey ILOM_ALKEY Labeling system
KEY versn ILOM_VERSN Version
actvs ILOM_ACTVS Active version
strno ILOM_STRNO Functional Loc.
tplkz TPLKZ StrIndicator
prkey ILOM_PRKEY Primary
reuse ILOM_REUSE Reusable
erdat ICRDT Created on
ernam ICRNA Created by
labelchangeddatetime TZNTSTMPS Time Stamp

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 Labels
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE IFLOS (
    MANDT,                 -- Client [MANDT]
    TPLNR,                 -- Functional loc. [TPLNR]
    ALKEY,                 -- Labeling system [ILOM_ALKEY]
    VERSN,                 -- Version [ILOM_VERSN]
    ACTVS,                 -- Active version [ILOM_ACTVS]
    STRNO,                 -- Functional Loc. [ILOM_STRNO]
    TPLKZ,                 -- StrIndicator [TPLKZ]
    PRKEY,                 -- Primary [ILOM_PRKEY]
    REUSE,                 -- Reusable [ILOM_REUSE]
    ERDAT,                 -- Created on [ICRDT]
    ERNAM,                 -- Created by [ICRNA]
    LABELCHANGEDDATETIME,  -- Time Stamp [TZNTSTMPS]
    PRIMARY KEY (MANDT, TPLNR, ALKEY, VERSN)
);

Learn More