P_PIRHISTBYLASTCHANGEDATETIME

CDS View
5 Fields 2 CDS Views

PIR history by last change date time

P_PIRHISTBYLASTCHANGEDATETIME is a CDS View in S/4HANA. PIR history by last change date time. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_DailyWeeklyMnthlyPIRHist view_entity from CONSUMPTION P_DailyWeeklyMnthlyPIRHist
P_PlndIndepRqmtItemHist view_entity from CONSUMPTION PIR History

Fields (5)

KeyField CDS FieldsUsed in Views
KEY DeliveryDate DeliveryDate 2
KEY Material Material 2
KEY MRPArea MRPArea 2
KEY ProductionPlant ProductionPlant 2
LastChangeDateTime LastChangeDateTime 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.

-- PIR history by last change date time
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PIRHISTBYLASTCHANGEDATETIME (
    DELIVERYDATE,
    MATERIAL,
    MRPAREA,
    PRODUCTIONPLANT,
    LASTCHANGEDATETIME,
    PRIMARY KEY (DELIVERYDATE, MATERIAL, MRPAREA, PRODUCTIONPLANT)
);

Learn More