I_PlannedOrderQuickView

@AbapCatalog.sqlViewName: 'IPLNDORDQV'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Planned Order Data'
@ObjectModel.usageType: {serviceQuality: #X, sizeCategory: #XXL, dataClass: #MIXED}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@AbapCatalog.preserveKey:true

define view I_PlannedOrderQuickView
  with parameters
    P_MRPElementCategory : delkz
  as select from    P_PlannedOrderQuickView(P_MRPElementCategory:'PA')          as _PPlannedOrder
  
   association [0..1] to I_WorkCenterTextBySemanticKey as _ProductionLineText on $projection.MRPPlant = _ProductionLineText.Plant
                                                                           and _ProductionLineText.Language  = $session.system_language
                                                                            and $projection.ProductionLine = _ProductionLineText.WorkCenter
{
  key PlannedOrder,
      Material,
      MRPPlant,
      Supplier,


      MaterialProcurementCategory,

      //Internal Contact

      ProductionSupervisor,
      ProductionSupervisorName,
      PurchasingGroup,
      PurchasingGroupName,
      PurchasingGroupPhoneNumber,
       PurchasingGroupEmailAddress,
      MRPController,
     _PPlannedOrder.MRPControllerName,
       _PPlannedOrder.InternalContactPersonName,
       _PPlannedOrder.InternalContactPhoneNumber,
       _PPlannedOrder.InternalContactEmailAddress,

      // Vendor

      _PPlannedOrder.SupplierName,
      _PPlannedOrder.SupplierFullName,
      _PPlannedOrder.ContactPersonPhoneNumber,
      _PPlannedOrder.ContactPersonEmailAddress,

      //Supplying Plant

      _PPlannedOrder.SupplyingPlant,

      //Planned Order

      MaterialProcurementType,
 _PPlannedOrder.MaterialProcurementTypeName,
        _PPlannedOrder.  ProcurementType,
_PPlannedOrder.MaterialProcurementCatName,

      PlannedOrderOpeningDate,
      PlndOrderPlannedStartDate,
      PlndOrderPlannedEndDate,
      MaterialGoodsReceiptDuration,
      _PPlannedOrder.PlndOrderPlannedTotalQty,

      PlannedOrderType,
      _PPlannedOrder.PlannedOrderTypeName,
      _PPlannedOrder.PlndOrderPlannedScrapQty,                                                                                                                      
      _PPlannedOrder.GoodsReceiptQty,                                                                                                                 
      _PPlannedOrder.BaseUnit,//alias added as Supplyplanning also have BaseUnit now

      ProductionPlant,
      _PPlannedOrder.ProductionPlantName,                                              
      ProductionVersion,
      _PPlannedOrder.ProductionVersionText,
        ProductionLine,
      _ProductionLineText.WorkCenterText                        as ProductionLineText,
      _PPlannedOrder.OpenQuantity,

      //Procurement Data

      _PPlannedOrder.MaterialPlannedDeliveryDurn,
      _PPlannedOrder.FixedLotSizeQuantity,
      _PPlannedOrder.MinimumLotSizeQuantity,
      _PPlannedOrder.MaximumLotSizeQuantity,
      _PPlannedOrder.LotSizeRoundingQuantity,
      _PPlannedOrder.RoundingProfile,
      _PPlannedOrder.MaterialRoundingProfileName,
      _PPlannedOrder.MaterialPlannedProductionDurn,
      _PPlannedOrder.TotalReplenishmentLeadDuration,

      //Related Objects

      SalesOrder,
      SalesOrderItem,
      Customer,
      _PPlannedOrder._Customer.CustomerName,
       WBSElement,
      _ProductionLineText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_WORKCENTERTEXTBYSEMANTICKEY",
"P_PLANNEDORDERQUICKVIEW"
],
"ASSOCIATED":
[
"I_WORKCENTERTEXTBYSEMANTICKEY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/