P_PRODUCTPLANTMRP

@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PPRDPLNTMRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: {
 usageType.serviceQuality: #D,
  usageType.sizeCategory : #L,
  usageType.dataClass: #TRANSACTIONAL}
@VDM.viewType : #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.privilegedAssociations: ['_MRPResponsible']
define view P_PRODUCTPLANTMRP
  as select from mdma as MRPAreaData

  association [0..1] to I_MRPType                as _MRPType               on  $projection.MRPType = _MRPType.MRPType
  association [0..*] to I_MRPTypeText            as _MRPTypeName           on  $projection.MRPType = _MRPTypeName.MRPType
  association [0..1] to I_MRPLotSizingProcedure  as _LotSizingProcedure    on  $projection.LotSizingProcedure = _LotSizingProcedure.MaterialLotSizingProcedure
  association [0..1] to I_StorageLocation        as _PlantInvtryManagedLoc on  $projection.StorageLocation = _PlantInvtryManagedLoc.StorageLocation
                                                                           and $projection.Plant           = _PlantInvtryManagedLoc.Plant
  association [1..1] to I_Product                as _Product               on  $projection.Product = _Product.Product
  association [0..1] to I_MRPController          as _MRPResponsible        on  $projection.MRPResponsible = _MRPResponsible.MRPController
                                                                           and $projection.Plant          = _MRPResponsible.Plant
  association [0..1] to I_MRPArea                as _MRPArea               on  $projection.MRPArea = _MRPArea.MRPArea
                                                                                                                                          

{
  key matnr                                                      as Product,
  key berid                                                      as MRPArea,
  key werks                                                      as Plant,
 
      _MRPArea.MRPAreaCategory                                   as MRPAreaCategory,
      @ObjectModel.foreignKey.association: '_MRPType'
      @ObjectModel.text.association: '_MRPTypeName'
      dismm                                                      as MRPType,
      @ObjectModel.foreignKey.association: '_MRPResponsible'
      dispo                                                      as MRPResponsible,
      disgr                                                      as MRPGroup,

      minbe                                                      as ReorderThresholdQuantity,
      lfrhy                                                      as PlanAndOrderDayDetermination,
      fxhor                                                      as PlanningTimeFence,
      @ObjectModel.foreignKey.association: '_LotSizingProcedure'                                     
      disls                                                      as LotSizingProcedure,
      rdprf                                                      as RoundingProfile,
      bstrf                                                      as LotSizeRoundingQuantity,
      bstmi                                                      as MinimumLotSizeQuantity,
      bstma                                                      as MaximumLotSizeQuantity,
      mabst                                                      as MaximumStockQuantity,
      ausss                                                      as AssemblyScrapPercent,
      sobsl                                                      as ProcurementSubType,
      @ObjectModel.foreignKey.association: '_PlantInvtryManagedLoc'
      lgpro                                                      as StorageLocation,
      lgfsb                                                      as DfltStorageLocationExtProcmt,
      mrppp                                                      as MRPPlanningCalendar,
      eisbe                                                      as SafetyStockQuantity,
      rwpro                                                      as RangeOfCvrgPrflCode,
      shzet                                                      as SafetyDuration,
      bstfe                                                      as FixedLotSizeQuantity,
      losfx                                                      as LotSizeIndependentCosts,
      lagpr                                                      as IsStorageCosts,
      lgrad                                                      as SrvcLvl,
      vrbdt                                                      as CreationDate,
      loekz                                                      as IsMarkedForDeletion,
      shpro                                                      as PerdPrflForSftyTme,
      ahdis                                                      as IsMRPDependentRqmt,
      pstat                                                      as MaintenanceStatusName,
      shflg                                                      as IsSafetyTime,
      plifz                                                      as PlannedDeliveryDurationInDays,
      cast(plifzx as boole_d)                                    as IsPlannedDeliveryTime,
      takzt                                                      as TaktTime,
      _MRPType,
      _MRPTypeName,
      _MRPResponsible,
      _LotSizingProcedure,
      _PlantInvtryManagedLoc,
      _Product,
      _MRPArea

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MRPAREA",
"MDMA"
],
"ASSOCIATED":
[
"I_MRPAREA",
"I_MRPCONTROLLER",
"I_MRPLOTSIZINGPROCEDURE",
"I_MRPTYPE",
"I_MRPTYPETEXT",
"I_PRODUCT",
"I_STORAGELOCATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/