EHFNDD_LOC_REV

Transparent Table Application Table
50 Fields 7 CDS Views

Location - Revisions

EHFNDD_LOC_REV is an SAP database table in S/4HANA. Location - Revisions. It contains 50 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
Ehenv_Location_All view from Retrieves current revision locations
Ehenv_Location_Filter view inner Retrieves current revision location and its sublocations
Ehenv_Scen_Loc_Active view from Active Scenarios for a User
Ehenv_Scen_Usr_Active view from Active Scenarios for a User
Ehfnd_Loc_Curr_Rev_All view from Current revision of a locations
Ehfnd_Loc_Current_Revision view from Current revision of a location
I_EHSLocationRevisionBasic view_entity from BASIC Location Revision

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key EHFND_LOC_REV_KEY Loc. - Revision
parent_key EHFND_LOC_ROOT_KEY Loc. - Root
crea_date_time TIMESTAMPL Time Stamp
crea_uname UNAME User Name
lchg_date_time TIMESTAMPL Time Stamp
lchg_uname UNAME User Name
revision_descr EHFND_REVISION_DESCRIPTION Revision
split_date EHFND_REVISION_SPLIT_DATE Rev. Start Date
split_time EHFND_REVISION_SPLIT_TIME Split Time
end_date EHFND_REVISION_END_DATE Rev. End Date
type EHFND_LOC_TYPE_CODE Loc. Type
status EHFND_LOC_STATUS Status
funct_loc_id EHFND_FUNCT_LOC_ID Functional Loc.
equipment_id EHFND_EQU_ID Equipment
plant_id EHFND_PLANT_ID Plant ID
company_code EHFND_COMPANY_CODE_ID Company Code
buss_area EHFND_BUSINESS_AREA_ID Business Area
cost_center EHFND_COST_CENTER_ID Cost Center
controlling_area EHFND_CONTROLLING_AREA_ID CO Area
org_unit EHFND_ORG_UNIT_ID Org. Unit ID
auth_group EHFND_LOC_AUTH_GROUP Auth. Group
desc_key_ref /BOBF/CONF_KEY NodeID
syncup_timestamp TZNTSTMPS Time Stamp
name1 EHFND_ADDR_NAME1 Name
name2 EHFND_ADDR_NAME2 Name
city1 EHFND_ADDR_CITY1 City
post_code1 EHFND_ADDR_POST_CODE1 Postal Code
street EHFND_ADDR_STREET Street
country EHFND_COUNTRY_ID Country / Region
region EHFND_REGION_ID Region
phone EHFND_ADDR_PHONE Phone No.
fax EHFND_ADDR_FAX Fax No.
longitute EHFND_GEOLOC_LONGITUDE Longitude
latitude EHFND_GEOLOC_LATITUDE Latitude
elevation EHFND_GEOLOC_ELEVATION Elevation
time_zone EHFND_LOC_TIME_ZONE Time Zone
street_number EHFND_ADDR_HOUSE_NUMBER1 House No.
po_box EHFND_ADDR_PO_BOX PO Box
po_box_post_code EHFND_ADDR_PO_BOX_POST_CODE PO Box Postal Code
municipality EHFND_ADDR_MUNICIPALITY Municipality
storage_loc EHFND_STORAGE_LOC Storage Location
warehouse_num EHFND_WAREHOUSE_NUM Warehouse Number
storage_type EHFND_STORAGE_TYPE Storage Type
storage_section EHFND_STORAGE_SECTION Storage Section
storage_bin EHFND_STORAGE_BIN Storage Bin
image_key_ref EHFND_LOC_IMAGE_KEY Location Image
eew_ehfnd_lrev_d DUMMY Dummy function in length 1
dynamic_bin_area_id /SCWM/DE_DYNBIN_AREA_ID Flexible Bin Area
dfps_bin_type DFPS_BIN_TYPE Bin 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.

-- Location - Revisions
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFNDD_LOC_REV (
    MANDT,                -- Client [MANDT]
    DB_KEY,               -- Loc. - Revision [EHFND_LOC_REV_KEY]
    PARENT_KEY,           -- Loc. - Root [EHFND_LOC_ROOT_KEY]
    CREA_DATE_TIME,       -- Time Stamp [TIMESTAMPL]
    CREA_UNAME,           -- User Name [UNAME]
    LCHG_DATE_TIME,       -- Time Stamp [TIMESTAMPL]
    LCHG_UNAME,           -- User Name [UNAME]
    REVISION_DESCR,       -- Revision [EHFND_REVISION_DESCRIPTION]
    SPLIT_DATE,           -- Rev. Start Date [EHFND_REVISION_SPLIT_DATE]
    SPLIT_TIME,           -- Split Time [EHFND_REVISION_SPLIT_TIME]
    END_DATE,             -- Rev. End Date [EHFND_REVISION_END_DATE]
    TYPE,                 -- Loc. Type [EHFND_LOC_TYPE_CODE]
    STATUS,               -- Status [EHFND_LOC_STATUS]
    FUNCT_LOC_ID,         -- Functional Loc. [EHFND_FUNCT_LOC_ID]
    EQUIPMENT_ID,         -- Equipment [EHFND_EQU_ID]
    PLANT_ID,             -- Plant ID [EHFND_PLANT_ID]
    COMPANY_CODE,         -- Company Code [EHFND_COMPANY_CODE_ID]
    BUSS_AREA,            -- Business Area [EHFND_BUSINESS_AREA_ID]
    COST_CENTER,          -- Cost Center [EHFND_COST_CENTER_ID]
    CONTROLLING_AREA,     -- CO Area [EHFND_CONTROLLING_AREA_ID]
    ORG_UNIT,             -- Org. Unit ID [EHFND_ORG_UNIT_ID]
    AUTH_GROUP,           -- Auth. Group [EHFND_LOC_AUTH_GROUP]
    DESC_KEY_REF,         -- NodeID [/BOBF/CONF_KEY]
    SYNCUP_TIMESTAMP,     -- Time Stamp [TZNTSTMPS]
    NAME1,                -- Name [EHFND_ADDR_NAME1]
    NAME2,                -- Name [EHFND_ADDR_NAME2]
    CITY1,                -- City [EHFND_ADDR_CITY1]
    POST_CODE1,           -- Postal Code [EHFND_ADDR_POST_CODE1]
    STREET,               -- Street [EHFND_ADDR_STREET]
    COUNTRY,              -- Country / Region [EHFND_COUNTRY_ID]
    REGION,               -- Region [EHFND_REGION_ID]
    PHONE,                -- Phone No. [EHFND_ADDR_PHONE]
    FAX,                  -- Fax No. [EHFND_ADDR_FAX]
    LONGITUTE,            -- Longitude [EHFND_GEOLOC_LONGITUDE]
    LATITUDE,             -- Latitude [EHFND_GEOLOC_LATITUDE]
    ELEVATION,            -- Elevation [EHFND_GEOLOC_ELEVATION]
    TIME_ZONE,            -- Time Zone [EHFND_LOC_TIME_ZONE]
    STREET_NUMBER,        -- House No. [EHFND_ADDR_HOUSE_NUMBER1]
    PO_BOX,               -- PO Box [EHFND_ADDR_PO_BOX]
    PO_BOX_POST_CODE,     -- PO Box Postal Code [EHFND_ADDR_PO_BOX_POST_CODE]
    MUNICIPALITY,         -- Municipality [EHFND_ADDR_MUNICIPALITY]
    STORAGE_LOC,          -- Storage Location [EHFND_STORAGE_LOC]
    WAREHOUSE_NUM,        -- Warehouse Number [EHFND_WAREHOUSE_NUM]
    STORAGE_TYPE,         -- Storage Type [EHFND_STORAGE_TYPE]
    STORAGE_SECTION,      -- Storage Section [EHFND_STORAGE_SECTION]
    STORAGE_BIN,          -- Storage Bin [EHFND_STORAGE_BIN]
    IMAGE_KEY_REF,        -- Location Image [EHFND_LOC_IMAGE_KEY]
    EEW_EHFND_LREV_D,     -- Dummy function in length 1 [DUMMY]
    DYNAMIC_BIN_AREA_ID,  -- Flexible Bin Area [/SCWM/DE_DYNBIN_AREA_ID]
    DFPS_BIN_TYPE,        -- Bin Type [DFPS_BIN_TYPE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More