I_EHSLOCATIONREVISIONBASIC

CDS View
14 Fields 2 CDS Views

Location Revision

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_EHSLocationRevisionDEX view_entity from CONSUMPTION Location Revision Data Extractor
I_EHSLocationRevision view from BASIC EHS Location Revision

Fields (14)

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