I_EHSLOCATIONREVISION

CDS View
44 Fields 31 CDS Views

EHS Location Revision

I_EHSLOCATIONREVISION is a CDS View in S/4HANA. EHS Location Revision. It contains 44 fields. 31 CDS views read from this table.

CDS Views using this table (31)

ViewTypeJoinVDMDescription
A_EHSLocationForSafetyInfo view from COMPOSITE EHS Location for Safety Relevant Information
C_EHSLocationForSafetyInsights view from CONSUMPTION EHS Location for Safety Insights
C_EquipSftyInstrnAreaFltrVH view inner CONSUMPTION All Factory Area for Safety Instruction for Equipment
C_EquipSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction for Equipment
C_GnrcSftyInstrnAreaFltrVH view inner CONSUMPTION Factory location areas for generic safety instruction
C_GnrcSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Generic Safety Instruction
C_SafetyInstrnEquipmentFltrVH view inner CONSUMPTION SI: Equipment Value Help for Filter Bar
C_SafetyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction
C_SafetyInstructionEquipmentVH view inner CONSUMPTION SI: Equipment Value Help
C_SftyInstrnFactoryAreaFltrVH view inner CONSUMPTION All Factory Areas for Safety Instruction
C_SubstSftyInstrnAreaFltrVH view inner CONSUMPTION All Factory Areas for Safety Instruction for Substance
C_SubstSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction for Substance
Ehhss_Sampling_Campaign_Allres view inner All results of a sampling campaign
I_BldngForHzdsSubstInvtryActv view inner COMPOSITE HSI: Buildings belong to active HSI
I_BldngForHzdsSubstInvtryItem view inner COMPOSITE Building for hazardous substance inventory item
I_EHSLocation view from BASIC EHS Location
I_EHSLocationByIdentifier view_entity from BASIC Location by identifier
I_EHSLocationForLocIDC view_entity from COMPOSITE EHS Locations - Cube
I_EHSLocationGeoPoint view_entity from COMPOSITE Location map position
I_EHSLocationIdentifier view_entity from BASIC EHS Location Identifier
I_EHSLocationWithFilter view from COMPOSITE EHS Location with filter
I_EHSLocationWithUUIDFilter view_entity from COMPOSITE EHS Location with filter
I_EHSLocNameRevsnFallbackLang view from COMPOSITE Location Name for Revision with Fallback
I_HzdsSubstInvtryProdQty view inner COMPOSITE HSI: Product Quantitiy
I_LocationDescFallbackLang view from COMPOSITE Location Description Fallback
I_ReldSftyInstrnFctryAreaVH view_entity inner COMPOSITE Factory Areas for Safety Instruction
I_SafetyInstrnStructureByPlant view from BASIC Interface View to get SI Structure by Plant
P_EHSLocHierarchyLocName view from BASIC
P_GnrcSftyInstrnStrucById view_entity from CONSUMPTION
P_HzdsSubstInvtrySubstProposal view inner CONSUMPTION
P_SubstSftyInstrnStrucByPlnt view_entity from CONSUMPTION

Fields (44)

KeyField CDS FieldsUsed in Views
KEY EHSLocationRevisionUUID EHSLocationRevisionUUID 7
KEY EHSLocationUUID EHSLocationUUID 13
KEY RevisionEndDate RevisionEndDate 4
_BusinessArea _BusinessArea 2
_CompanyCode _CompanyCode 2
_ControllingArea _ControllingArea 1
_Country _Country 1
_CreatedByUser _CreatedByUser 1
_EHSLocationAuthGroup _EHSLocationAuthGroup 2
_EHSLocationRevisionName _EHSLocationRevisionName 1
_EHSLocationStatus _EHSLocationStatus 2
_EHSLocationType _EHSLocationType 2
_Equipment _Equipment 1
_FunctionalLocation _FunctionalLocation 1
_LastChangedByUser _LastChangedByUser 1
_OrganizationalUnit _OrganizationalUnit 1
_Plant _Plant 1
_Region _Region 1
_StorageLocation _StorageLocation 1
BusinessArea BusinessArea,buss_area 7
CityName CityName 1
CompanyCode company_code,CompanyCode 7
ControllingArea ControllingArea 2
CostCenter cost_center,CostCenter 7
Country Country 2
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup,loc_auth_group 2
EHSLocationPhone EHSLocationPhone 1
EHSLocationStatus EHSLocationStatus 6
EHSLocationType EHSLocationType 6
Equipment Equipment 1
FunctionalLocation FunctionalLocation 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
Latitude Latitude 1
Longitude Longitude 1
OrganizationalUnit OrganizationalUnit 1
Plant Plant,plant_id 8
PostalCode PostalCode 1
Region Region 2
RevisionStartDate RevisionStartDate 4
StorageLocation StorageLocation 1
StreetName StreetName 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.

-- EHS Location Revision
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSLOCATIONREVISION (
    EHSLOCATIONREVISIONUUID,
    EHSLOCATIONUUID,
    REVISIONENDDATE,
    _BUSINESSAREA,
    _COMPANYCODE,
    _CONTROLLINGAREA,
    _COUNTRY,
    _CREATEDBYUSER,
    _EHSLOCATIONAUTHGROUP,
    _EHSLOCATIONREVISIONNAME,
    _EHSLOCATIONSTATUS,
    _EHSLOCATIONTYPE,
    _EQUIPMENT,
    _FUNCTIONALLOCATION,
    _LASTCHANGEDBYUSER,
    _ORGANIZATIONALUNIT,
    _PLANT,
    _REGION,
    _STORAGELOCATION,
    BUSINESSAREA,
    CITYNAME,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    EHSLOCATIONAUTHORIZATIONGROUP,
    EHSLOCATIONPHONE,
    EHSLOCATIONSTATUS,
    EHSLOCATIONTYPE,
    EQUIPMENT,
    FUNCTIONALLOCATION,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    LATITUDE,
    LONGITUDE,
    ORGANIZATIONALUNIT,
    PLANT,
    POSTALCODE,
    REGION,
    REVISIONSTARTDATE,
    STORAGELOCATION,
    STREETNAME,
    PRIMARY KEY (EHSLOCATIONREVISIONUUID, EHSLOCATIONUUID, REVISIONENDDATE)
);

Learn More