EHHSSD_INC_BINFA

Transparent Table Application Table
47 Fields 2 CDS Views

Incident - Basic Information All

EHHSSD_INC_BINFA is an SAP database table in S/4HANA. Incident - Basic Information All. It contains 47 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_IncidentBasicInfo view from EXTENSION Extenstion View for Basic Information for an Incident
I_IncidentBasicInfo view from BASIC Basic Information of an Incident

Fields (47)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key EHHSS_INC_BINFA_KEY Basic Inform.
parent_key EHHSS_INC_ROOT_KEY Incident - Root
datetime_cr /BOBF/DATETIME_CR Created On/At
user_id_cr /BOBF/USER_ID_CR Created By
datetime_ch /BOBF/DATETIME_CH Changed On/At
user_id_ch /BOBF/USER_ID_CH Changed By
title EHHSS_INC_TITLE Title
org_id EHHSS_ORG_UNIT_ID Org. Unit ID
plant_id EHFND_PLANT_ID Plant ID
loc_root_key_ref EHFND_LOCATION_KEY_REF Location
loc_type EHHSS_LOCATION_TYPE_CODE Loc. Class.
start_timestamp EHFND_START_TIME_STAMP Start date(UTC)
start_time_zone EHHSS_INC_START_TIME_ZONE Time Zone
end_timestamp EHFND_END_TIME_STAMP End date(UTC)
end_time_zone EHHSS_INC_END_TIME_ZONE Time Zone
time_not_det_ind EHHSS_INC_TIME_NOT_DET_IND Time Unknown
rep_timestamp EHHSS_INC_REP_TIME_STAMP Time(UTC)
rep_time_zone EHHSS_INC_REPORTED_TIME_ZONE Time Zone
confidential_ts EHHSS_INC_CONFID_TS Restricted
loss_of_prod_ts EHHSS_LOSS_OF_PRODUCTION_TS Loss of Product.
emerg_resp_ts EHHSS_EMERGENCY_RESPONDER_TS Emerg. Resp.
latit_meas EHHSS_GEO_LATITUDE_MEAS Latitude
long_meas EHHSS_GEO_LONGITUDE_MEAS Longitude
altit_meas EHHSS_GEO_ALTIT_MEAS Altitude
altit_unit EHHSS_GEO_ALTIT_UNIT_CODE Unit
street_house_num EHHSS_INC_STREET_HOUSE_NUM Street / House No.
postal_code EHHSS_INC_POSTAL_CODE Postal Code
city EHHSS_INC_CITY City
country EHHSS_INC_COUNTRY_CODE Country/Region
region EHHSS_INC_REGION_CODE Region
shift_group EHFND_SHIFT_GROUP_ORGUNIT Shift Group
shift_plan_id EHFND_SHIFT_PLAN_ABBR Shift
rep_anonym_ind EHHSS_INC_REPORTED_ANONYM_IND Anonymous
dis_wa_meas EHHSS_DIS_WATER_MEAS Dist. to Water
dis_wa_unit EHHSS_DIS_WATER_UNIT_CODE Unit
precip_meas EHHSS_PRECIPIT_MEAS Precipitation
precip_unit EHHSS_PRECIPIT_UNIT_CODE Unit
wi_direc EHHSS_WIND_DIRECTION_CODE Wind Direction
wi_fo_meas EHHSS_WIND_FOR_MEAS Wind Speed
wi_fo_unit EHHSS_WIND_FOR_UNIT_CODE Unit
txc_wea_comm_key /BOBF/CONF_KEY NodeID
txc_desc_key /BOBF/CONF_KEY NodeID
txc_loc_desc_key /BOBF/CONF_KEY NodeID
txc_ima_desc_key /BOBF/CONF_KEY NodeID
type EHHSS_INC_INJ_ENTRY_TYPE_CODE Type
eew_inc_binfa_d DUMMY Dummy function in length 1

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.

-- Incident - Basic Information All
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHHSSD_INC_BINFA (
    MANDT,             -- Client [MANDT]
    DB_KEY,            -- Basic Inform. [EHHSS_INC_BINFA_KEY]
    PARENT_KEY,        -- Incident - Root [EHHSS_INC_ROOT_KEY]
    DATETIME_CR,       -- Created On/At [/BOBF/DATETIME_CR]
    USER_ID_CR,        -- Created By [/BOBF/USER_ID_CR]
    DATETIME_CH,       -- Changed On/At [/BOBF/DATETIME_CH]
    USER_ID_CH,        -- Changed By [/BOBF/USER_ID_CH]
    TITLE,             -- Title [EHHSS_INC_TITLE]
    ORG_ID,            -- Org. Unit ID [EHHSS_ORG_UNIT_ID]
    PLANT_ID,          -- Plant ID [EHFND_PLANT_ID]
    LOC_ROOT_KEY_REF,  -- Location [EHFND_LOCATION_KEY_REF]
    LOC_TYPE,          -- Loc. Class. [EHHSS_LOCATION_TYPE_CODE]
    START_TIMESTAMP,   -- Start date(UTC) [EHFND_START_TIME_STAMP]
    START_TIME_ZONE,   -- Time Zone [EHHSS_INC_START_TIME_ZONE]
    END_TIMESTAMP,     -- End date(UTC) [EHFND_END_TIME_STAMP]
    END_TIME_ZONE,     -- Time Zone [EHHSS_INC_END_TIME_ZONE]
    TIME_NOT_DET_IND,  -- Time Unknown [EHHSS_INC_TIME_NOT_DET_IND]
    REP_TIMESTAMP,     -- Time(UTC) [EHHSS_INC_REP_TIME_STAMP]
    REP_TIME_ZONE,     -- Time Zone [EHHSS_INC_REPORTED_TIME_ZONE]
    CONFIDENTIAL_TS,   -- Restricted [EHHSS_INC_CONFID_TS]
    LOSS_OF_PROD_TS,   -- Loss of Product. [EHHSS_LOSS_OF_PRODUCTION_TS]
    EMERG_RESP_TS,     -- Emerg. Resp. [EHHSS_EMERGENCY_RESPONDER_TS]
    LATIT_MEAS,        -- Latitude [EHHSS_GEO_LATITUDE_MEAS]
    LONG_MEAS,         -- Longitude [EHHSS_GEO_LONGITUDE_MEAS]
    ALTIT_MEAS,        -- Altitude [EHHSS_GEO_ALTIT_MEAS]
    ALTIT_UNIT,        -- Unit [EHHSS_GEO_ALTIT_UNIT_CODE]
    STREET_HOUSE_NUM,  -- Street / House No. [EHHSS_INC_STREET_HOUSE_NUM]
    POSTAL_CODE,       -- Postal Code [EHHSS_INC_POSTAL_CODE]
    CITY,              -- City [EHHSS_INC_CITY]
    COUNTRY,           -- Country/Region [EHHSS_INC_COUNTRY_CODE]
    REGION,            -- Region [EHHSS_INC_REGION_CODE]
    SHIFT_GROUP,       -- Shift Group [EHFND_SHIFT_GROUP_ORGUNIT]
    SHIFT_PLAN_ID,     -- Shift [EHFND_SHIFT_PLAN_ABBR]
    REP_ANONYM_IND,    -- Anonymous [EHHSS_INC_REPORTED_ANONYM_IND]
    DIS_WA_MEAS,       -- Dist. to Water [EHHSS_DIS_WATER_MEAS]
    DIS_WA_UNIT,       -- Unit [EHHSS_DIS_WATER_UNIT_CODE]
    PRECIP_MEAS,       -- Precipitation [EHHSS_PRECIPIT_MEAS]
    PRECIP_UNIT,       -- Unit [EHHSS_PRECIPIT_UNIT_CODE]
    WI_DIREC,          -- Wind Direction [EHHSS_WIND_DIRECTION_CODE]
    WI_FO_MEAS,        -- Wind Speed [EHHSS_WIND_FOR_MEAS]
    WI_FO_UNIT,        -- Unit [EHHSS_WIND_FOR_UNIT_CODE]
    TXC_WEA_COMM_KEY,  -- NodeID [/BOBF/CONF_KEY]
    TXC_DESC_KEY,      -- NodeID [/BOBF/CONF_KEY]
    TXC_LOC_DESC_KEY,  -- NodeID [/BOBF/CONF_KEY]
    TXC_IMA_DESC_KEY,  -- NodeID [/BOBF/CONF_KEY]
    TYPE,              -- Type [EHHSS_INC_INJ_ENTRY_TYPE_CODE]
    EEW_INC_BINFA_D,   -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More