EHFND_LOC_CURR_REV_ALL

CDS View

Current revision of a locations

EHFND_LOC_CURR_REV_ALL is a CDS View in S/4HANA. Current revision of a locations. It contains 10 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
Ehenv_Adef_Amns view inner Aggregation Amounts
Ehenv_Adef_Amns_At_Location view inner Aggregation Amounts At Location
Ehenv_Cdef_Amns view inner Calculation Amounts
Ehenv_Cdef_Amns_At_Location view inner Calculation Amounts At Location
Ehenv_Mdef_Amns view inner Measurement Amounts
Ehenv_Mdef_Amns_At_Location view inner Measurement Amounts At Location
Ehenv_Scen_Usra_Loc_Curr_Rev view from Active Scenarios per user and location current revision
Ehenv_Sdef_Amns view inner Sampling Amounts
Ehenv_Sdef_Amns_At_Location view inner Sampling Amounts at Location

Fields (10)

KeyField CDS FieldsUsed in Views
auth_group loc_auth_group 8
buss_area buss_area 8
company_code company_code 8
cost_center cost_center 8
country country 8
name location_text 8
plant_id plant_id 8
region region 8
status loc_status 8
type type 8

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.

-- Current revision of a locations
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EHFND_LOC_CURR_REV_ALL (
    AUTH_GROUP,
    BUSS_AREA,
    COMPANY_CODE,
    COST_CENTER,
    COUNTRY,
    NAME,
    PLANT_ID,
    REGION,
    STATUS,
    TYPE
);