P_DAILYWEEKLYMNTHLYPIRHIST

CDS View
7 Fields 1 CDS Views

P_DailyWeeklyMnthlyPIRHist

P_DAILYWEEKLYMNTHLYPIRHIST is a CDS View in S/4HANA. P_DailyWeeklyMnthlyPIRHist. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DailyWeeklyMnthlyPIRHistDate view_entity from CONSUMPTION P_DailyWeeklyMnthlyPIRHistDate

Fields (7)

KeyField CDS FieldsUsed in Views
KEY ForecastPeriodMode ForecastPeriodMode 1
KEY Material Material 1
KEY MRPArea MRPArea 1
KEY ProductionPlant ProductionPlant 1
QuantityInBaseUnit QuantityInBaseUnit 1
TotalMonthlyPlndIndepRqmtQty TotalMonthlyPlndIndepRqmtQty 1
TotalWeeklyPlndIndepRqmtQty TotalWeeklyPlndIndepRqmtQty 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_DailyWeeklyMnthlyPIRHist
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_DAILYWEEKLYMNTHLYPIRHIST (
    FORECASTPERIODMODE,
    MATERIAL,
    MRPAREA,
    PRODUCTIONPLANT,
    QUANTITYINBASEUNIT,
    TOTALMONTHLYPLNDINDEPRQMTQTY,
    TOTALWEEKLYPLNDINDEPRQMTQTY,
    PRIMARY KEY (FORECASTPERIODMODE, MATERIAL, MRPAREA, PRODUCTIONPLANT)
);

Learn More