_EHSLOCATIONREVISION

14 Fields

_EHSLOCATIONREVISION is an SAP database table in S/4HANA. It contains 14 fields.

Fields (14)

KeyField CDS FieldsUsed in Views
KEY EHSLocationUUID EHSLocationUUID 1
KEY RevisionEndDate RevisionEndDate 3
_EHSLocationRevisionName _Name 1
BusinessArea BusinessArea 12
CompanyCode CompanyCode 12
ControllingArea ControllingArea 11
CostCenter CostCenter 12
EHSLocationAuthorizationGroup EHSLocationAuthorizationGroup 1
EHSLocationRevisionUUID EHSLocationRevisionUUID 2
EHSLocationStatus EHSLocationStatus 12
EHSLocationType EHSLocationType 12
Equipment Equipment 2
Plant Plant 12
RevisionStartDate RevisionStartDate 3

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 _EHSLOCATIONREVISION (
    EHSLOCATIONUUID,
    REVISIONENDDATE,
    _EHSLOCATIONREVISIONNAME,
    BUSINESSAREA,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    EHSLOCATIONAUTHORIZATIONGROUP,
    EHSLOCATIONREVISIONUUID,
    EHSLOCATIONSTATUS,
    EHSLOCATIONTYPE,
    EQUIPMENT,
    PLANT,
    REVISIONSTARTDATE,
    PRIMARY KEY (EHSLOCATIONUUID, REVISIONENDDATE)
);

Learn More