I_MRPPLANNINGSEGMENT

CDS View

MRP Planning Segment

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

Used by 6 CDS view(s) 17 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_MRPPlanningSegmentExtVH view 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 from COMPOSITE MRP Availability of a Material
I_MRPSalesDemand view inner COMPOSITE MRP Sales Demand
P_MRPProdDemandAggregation view from COMPOSITE

Fields (17)

KeyField CDS FieldsUsed in Views
KEY Material Material 3
KEY MaterialShortageProfile MaterialShortageProfile 4
KEY MRPArea MRPArea 3
KEY MRPPlanningSegment MRPPlanningSegment 6
KEY MRPPlanningSegmentType MRPPlanningSegmentType 5
KEY MRPPlant MRPPlant 3
MaterialHasMRPNote MaterialHasMRPNote 1
MRPMaterialNoteText MRPMaterialNoteText 1
MRPPlanningSegmentExternalCode MRPPlanningSegmentExternalCode 1
NmbrOfPastDueOpeningDateElmnts NmbrOfPastDueOpeningDateElmnts 1
NumberOfCancelProcesses NumberOfCancelProcesses 1
NumberOfPastDueEndDateElements NumberOfPastDueEndDateElements 1
NumberOfPastDueStartDateElmnts NumberOfPastDueStartDateElmnts 1
NumberOfRescheduleInElements NumberOfRescheduleInElements 1
NumberOfRescheduleOutElements NumberOfRescheduleOutElements 1
PlanningSegmentDocument PlanningSegmentDocument 2
PlanningSegmentDocumentItem PlanningSegmentDocumentItem 2 
@AbapCatalog.sqlViewName: 'IMRPPLANSEGMENT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'MRP Planning Segment'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    usageType: {serviceQuality: #A, sizeCategory: #XXL, dataClass: #TRANSACTIONAL }
}

@VDM.viewType: #BASIC

/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view I_MRPPlanningSegment
  as select from pph_cache_plseg

  association [1..1] to I_Plant           as _Plant       on  $projection.MRPPlant = _Plant.Plant
  association [1..1] to I_Material        as _Material    on  $projection.Material = _Material.Material
  association [0..1] to I_MRPArea         as _MRPArea     on  $projection.MRPArea = _MRPArea.MRPArea
  //  association [0..1] to I_ProjectMaterialComponent as _Reservation on  $projection.Reservation     = _Reservation.Reservation

  //                                                                   and $projection.ReservationItem = _Reservation.ReservationItem

  //                                                                   and _Reservation.RecordType     = ''


  association [0..1] to I_ReservationItem as _Reservation on  $projection.Reservation     = _Reservation.Reservation
                                                          and $projection.ReservationItem = _Reservation.ReservationItem
                                                          and _Reservation.RecordType     = ''

  association [0..1] to I_WBSElement                      as _WBSElement  on  $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID

{
  key mrpplant                                                   as MRPPlant,
  key material                                                   as Material,
  key mrparea                                                    as MRPArea,
  key mrpplanningsegmenttype                                     as MRPPlanningSegmentType,
  key mrpplanningsegmentnumber                                   as MRPPlanningSegment,
  key materialshortageprofile                                    as MaterialShortageProfile,
      mrpplanningsegmentnumberext                                as MRPPlanningSegmentExternalCode,
      substring(pph_cache_plseg.mrpplanningsegmentnumber, 1, 10) as Reservation,
      substring(pph_cache_plseg.mrpplanningsegmentnumber, 11, 4) as ReservationItem,
      mrpavailablestockquantity                                  as MRPAvailableStockQty,

      case mrpplanningsegmenttype
        when '22' then substring(mrpplanningsegmentnumber, 1, 8)
        else ''
      end                                                        as WBSElementInternalID,

      case mrpplanningsegmenttype
        when '00' then ''
        when '02' then ''               -- net segment
        when '04' then ''               -- gross reqmt planning
        when '20' then substring(mrpplanningsegmentnumber, 1, 10) -- MTO
        when '22' then substring(mrpplanningsegmentnumber, 1, 8)  -- MTP
        when '24' then substring(mrpplanningsegmentnumber, 1, 10) -- direct planning
        when '41' then ''               -- DIMPcustomer
        else ''
      end                                                        as PlanningSegmentDocument, //represents MRPPLANNINGSEGMENTID


      case mrpplanningsegmenttype
        when '00' then ''
        when '02' then''                -- net segment
        when '04' then ''               -- gross reqmt planning
        when '20' then substring(mrpplanningsegmentnumber, 11, 6) -- MTO
        when '22' then ''               -- MTP
        when '24' then substring(mrpplanningsegmentnumber, 11, 4) -- direct planning
        when '41' then ''               -- DIMPcustomer
        else ''
      end                                                        as PlanningSegmentDocumentItem, //represents MRPPLANNINGSEGMENTITEM


      pastdueopeningdateelements                                 as NmbrOfPastDueOpeningDateElmnts,
      pastduestartdateelements                                   as NumberOfPastDueStartDateElmnts,
      pastduefinishdateelements                                  as NumberOfPastDueEndDateElements,
      materialhasmrpnote                                         as MaterialHasMRPNote,
      ''                                                         as MRPMaterialNoteText,
      reschedulein                                               as NumberOfRescheduleInElements,
      rescheduleout                                              as NumberOfRescheduleOutElements,
      cancelprocess                                              as NumberOfCancelProcesses,

      // associations

      _Plant,
      _Material,
      _MRPArea,
      _Reservation,
      _WBSElement
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"PPH_CACHE_PLSEG"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_MRPAREA",
"I_PLANT",
"I_RESERVATIONITEM",
"I_WBSELEMENT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More