EHFND_LOC_CURR_REV_ALL
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA