_EHSLOCATION

_EHSLOCATION is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
_BusinessArea _BusinessArea 5
_CompanyCode _CompanyCode 4
_ControllingArea _ControllingArea 2
_Country _Country 7
_EHSLocationAuthGroup _EHSLocationAuthGroup 2
_EHSLocationStatus _EHSLocationStatus 2
_EHSLocationType _EHSLocationType 5
_OrganizationalUnit _OrganizationalUnit 2
_Plant _Plant 13
_Region _Region 2
_StorageLocation _StorageLocation 2
BusinessArea BusinessArea 11
CityName CityName 10
CompanyCode CompanyCode 10
ControllingArea ControllingArea 3
CostCenter CostCenter 10
Country Country 10
EHSFunctionalLocation EHSFunctionalLocation 1
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup 3
EHSLocationID EHSLocationID 2
EHSLocationPhone EHSLocationPhone 1
EHSLocationStatus EHSLocationStatus 8
EHSLocationType EHSLocationType 9
Equipment Equipment 1
OrganizationalUnit OrganizationalUnit 2
Plant Plant 17
PostalCode PostalCode 2
Region Region 4
StorageLocation StorageLocation 2
StreetName StreetName 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _EHSLOCATION (
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COUNTRY,
    _EHSLOCATIONAUTHGROUP,
    _EHSLOCATIONSTATUS,
    _EHSLOCATIONTYPE,
    _ORGANIZATIONALUNIT,
    _PLANT,
    _REGION,
    _STORAGELOCATION,
    BUSINESSAREA,
    CITYNAME,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    EHSFUNCTIONALLOCATION,
    EHSLOCATIONAUTHORIZATIONGROUP,
    EHSLOCATIONID,
    EHSLOCATIONPHONE,
    EHSLOCATIONSTATUS,
    EHSLOCATIONTYPE,
    EQUIPMENT,
    ORGANIZATIONALUNIT,
    PLANT,
    POSTALCODE,
    REGION,
    STORAGELOCATION,
    STREETNAME
);