I_EHSLOCATIONREVISIONBASIC

CDS View
14 Fields 3 CDS Views

Location Revision

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

CDS Views using this table (3)

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

Fields (14)

KeyField CDS FieldsUsed in Views
KEY EHSLocationRevisionUUID EHSLocationRevisionUUID 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 1
RevisionStartDate RevisionStartDate 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.

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

Learn More