P_MATLAVGDAILYUSGECALHRZNDATES

CDS View
3 Fields 2 CDS Views

P view to get the ADU start and end dates

P_MATLAVGDAILYUSGECALHRZNDATES is a CDS View in S/4HANA. P view to get the ADU start and end dates. It contains 3 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_AvgDailyUsgeHrznForCalDte view from COMPOSITE P view
P_DailyWeeklyMnthlyPIRByDate view left_outer COMPOSITE P_DailyWeeklyMnthlyPIRByDate

Fields (3)

KeyField CDS FieldsUsed in Views
EndDate EDate 1
StartDate SDate 1
TotalNoOfDays TotalNoOfDays 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.

-- P view to get the ADU start and end dates
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MATLAVGDAILYUSGECALHRZNDATES (
    ENDDATE,
    STARTDATE,
    TOTALNOOFDAYS
);

Learn More