I_PLNDINDEPRQMTITEMBASIC

CDS View
16 Fields 5 CDS Views

Planned Independent Requirement Item Basic with internal key

I_PLNDINDEPRQMTITEMBASIC is a CDS View in S/4HANA. Planned Independent Requirement Item Basic with internal key. It contains 16 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_PlndIndepRqmtItem view from COMPOSITE Planned Independent Requirement Item
P_DailyPlndIndepRqmt view from COMPOSITE
P_DailyWeeklyMnthlyPIR view from COMPOSITE
P_MonthlyPlndIndepRqmt view from COMPOSITE
P_WeeklyPlndIndepRqmt view from COMPOSITE

Fields (16)

KeyField CDS FieldsUsed in Views
KEY MRPArea MRPArea 1
KEY PeriodType PeriodType 2
KEY Plant Plant 2
KEY PlndIndepRqmtType PlndIndepRqmtType 2
KEY PlndIndepRqmtVersion PlndIndepRqmtVersion 1
KEY Product Product 2
KEY RequirementPlan RequirementPlan 1
KEY RequirementSegment RequirementSegment 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
PlannedQuantity PlannedQuantity 1
PlndIndepRqmtInternalID PlndIndepRqmtInternalID 1
PlndIndepRqmtIsActive PlndIndepRqmtIsActive 1
UnitOfMeasure UnitOfMeasure 2
WithdrawalQuantity WithdrawalQuantity 1
WorkingDayDate WorkingDayDate 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.

-- Planned Independent Requirement Item Basic with internal key
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PLNDINDEPRQMTITEMBASIC (
    MRPAREA,
    PERIODTYPE,
    PLANT,
    PLNDINDEPRQMTTYPE,
    PLNDINDEPRQMTVERSION,
    PRODUCT,
    REQUIREMENTPLAN,
    REQUIREMENTSEGMENT,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    PLANNEDQUANTITY,
    PLNDINDEPRQMTINTERNALID,
    PLNDINDEPRQMTISACTIVE,
    UNITOFMEASURE,
    WITHDRAWALQUANTITY,
    WORKINGDAYDATE,
    PRIMARY KEY (MRPAREA, PERIODTYPE, PLANT, PLNDINDEPRQMTTYPE, PLNDINDEPRQMTVERSION, PRODUCT, REQUIREMENTPLAN, REQUIREMENTSEGMENT)
);

Learn More