I_MRPPLANNINGSEGMENT

CDS View
18 Fields 9 CDS Views

MRP Planning Segment

I_MRPPLANNINGSEGMENT is a CDS View in S/4HANA. MRP Planning Segment. It contains 18 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_MRPPlanningSegmentExtVH view_entity from CONSUMPTION MRP Planning Segment External Code
I_CacheMRPMfgOrder view inner COMPOSITE Cache MRP Manufacturing Orders
I_MaterialCoverage view from COMPOSITE MRP Material Coverage
I_MRPAvailability view_entity from COMPOSITE MRP Availability of a Material
I_MRPMaterialCoverage view_entity from COMPOSITE MRP Material Coverage without Supplier
I_MRPProductionDemand view_entity inner COMPOSITE MRP Production Demand
I_MRPSalesDemand view inner COMPOSITE MRP Sales Demand
I_MRPTransferDemand view_entity inner COMPOSITE Transfer Demand
P_MRPProdDemandAggregation view from COMPOSITE Production Demand Aggregation

Fields (18)

KeyField CDS FieldsUsed in Views
KEY Material Material 4
KEY MaterialShortageProfile MaterialShortageProfile 7
KEY MRPArea MRPArea 4
KEY MRPPlanningSegment MRPPlanningSegment 9
KEY MRPPlanningSegmentType MRPPlanningSegmentType 5
KEY MRPPlant MRPPlant 4
MaterialHasMRPNote MaterialHasMRPNote 2
MRPMaterialNoteText MRPMaterialNoteText 2
MRPPlanningSegmentExternalCode MRPPlanningSegmentExternalCode 3
NmbrOfPastDueOpeningDateElmnts NmbrOfPastDueOpeningDateElmnts 2
NumberOfCancelProcesses NumberOfCancelProcesses 2
NumberOfPastDueEndDateElements NumberOfPastDueEndDateElements 2
NumberOfPastDueStartDateElmnts NumberOfPastDueStartDateElmnts 2
NumberOfRescheduleInElements NumberOfRescheduleInElements 2
NumberOfRescheduleOutElements NumberOfRescheduleOutElements 2
PlanningSegmentDocument PlanningSegmentDocument 7
PlanningSegmentDocumentItem PlanningSegmentDocumentItem 7
WBSElementInternalID WBSElementInternalID 2

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.

-- MRP Planning Segment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MRPPLANNINGSEGMENT (
    MATERIAL,
    MATERIALSHORTAGEPROFILE,
    MRPAREA,
    MRPPLANNINGSEGMENT,
    MRPPLANNINGSEGMENTTYPE,
    MRPPLANT,
    MATERIALHASMRPNOTE,
    MRPMATERIALNOTETEXT,
    MRPPLANNINGSEGMENTEXTERNALCODE,
    NMBROFPASTDUEOPENINGDATEELMNTS,
    NUMBEROFCANCELPROCESSES,
    NUMBEROFPASTDUEENDDATEELEMENTS,
    NUMBEROFPASTDUESTARTDATEELMNTS,
    NUMBEROFRESCHEDULEINELEMENTS,
    NUMBEROFRESCHEDULEOUTELEMENTS,
    PLANNINGSEGMENTDOCUMENT,
    PLANNINGSEGMENTDOCUMENTITEM,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (MATERIAL, MATERIALSHORTAGEPROFILE, MRPAREA, MRPPLANNINGSEGMENT, MRPPLANNINGSEGMENTTYPE, MRPPLANT)
);

Learn More