I_EHSLOCATIONREVISIONBASIC

CDS View
15 Fields 4 CDS Views

Location Revision

I_EHSLOCATIONREVISIONBASIC is a CDS View in S/4HANA. Location Revision. It contains 15 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_EHSLocationRevisionDEX view_entity from CONSUMPTION EHS Location Revision
C_OccupationalHealthLocationVH view_entity from CONSUMPTION Occupational Health Location
I_CurEHSLocationInclRoot view inner COMPOSITE Current revision of EHS Locations
I_EHSLocationRevision view from BASIC EHS Location Revision

Fields (15)

KeyField CDS FieldsUsed in Views
KEY EHSLocationRevisionUUID EHSLocationRevisionUUID 1
KEY EHSLocationUUID EHSLocationUUID 1
BusinessArea BusinessArea 2
CompanyCode CompanyCode 2
ControllingArea ControllingArea 1
CostCenter CostCenter 2
Country Country 1
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup 1
EHSLocationStatus EHSLocationStatus 2
EHSLocationType EHSLocationType 2
OrganizationalUnit OrganizationalUnit 1
Plant Plant 2
Region Region 1
RevisionEndDate RevisionEndDate 2
RevisionStartDate RevisionStartDate 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.

-- Location Revision
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_EHSLOCATIONREVISIONBASIC (
    EHSLOCATIONREVISIONUUID,
    EHSLOCATIONUUID,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COUNTRY,
    EHSLOCATIONAUTHORIZATIONGROUP,
    EHSLOCATIONSTATUS,
    EHSLOCATIONTYPE,
    ORGANIZATIONALUNIT,
    PLANT,
    REGION,
    REVISIONENDDATE,
    REVISIONSTARTDATE,
    PRIMARY KEY (EHSLOCATIONREVISIONUUID, EHSLOCATIONUUID)
);

Learn More