DPR_LOCATION

Transparent Table Customizing Table
8 Fields 1 CDS Views

Location

DPR_LOCATION is an SAP database table in S/4HANA. Location. It contains 8 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_DevelopmentProjectLocation view_entity from BASIC Location Type

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY location dpr_tv_location Location
area dpr_tv_area Area
calendar_id dpr_tv_calendar_id Calendar
hours_per_day dpr_tv_hours_per_day Hours per Day
country land1 Country/Reg.
region regio Region
post_code post_code Postal Code

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
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DPR_LOCATION (
    MANDT,          -- Client [mandt]
    LOCATION,       -- Location [dpr_tv_location]
    AREA,           -- Area [dpr_tv_area]
    CALENDAR_ID,    -- Calendar [dpr_tv_calendar_id]
    HOURS_PER_DAY,  -- Hours per Day [dpr_tv_hours_per_day]
    COUNTRY,        -- Country/Reg. [land1]
    REGION,         -- Region [regio]
    POST_CODE,      -- Postal Code [post_code]
    PRIMARY KEY (MANDT, LOCATION)
);

Learn More