C_PurchaseOrderGoodsReceipt

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'CPURORDGR'
@EndUserText.label: 'Purchase Order Goods Receipt'

@ObjectModel: {
    semanticKey: [ 'MaterialDocument' ],
    representativeKey: 'MaterialDocument',
    usageType.serviceQuality: #C,
    usageType.sizeCategory: #M,
    usageType.dataClass: #MIXED
}
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view C_PurchaseOrderGoodsReceipt 
  as select from I_MaterialDocumentRecord 

{
      @UI.lineItem: [{position: 10, importance: #HIGH }]
      @Consumption.semanticObject: 'MaterialMovement'
  key MaterialDocument,
      @UI.lineItem: [{position: 20, importance: #HIGH }]
  key cast ( MaterialDocumentItem as mm_grpo_item preserving type ) as MaterialDocumentItem,
      @UI.lineItem: [{position: 30, importance: #HIGH }]
  key cast ( MaterialDocumentYear as mm_grpo_year preserving type ) as MaterialDocumentYear,
      //--[ GENERATED:012:GFBfhyK17kY4ofIXD8GUQG

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_PurchaseOrderStdVH',
                     element: 'PurchaseOrder' }
        }]
      // ]--GENERATED

      @UI.hidden: true
      @ObjectModel.foreignKey.association: '_PurchaseOrder'
  key PurchaseOrder,
      //--[ GENERATED:012:GFBfhyK17kY4ofIXD8GUQG

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_PurchaseOrderItemStdVH',
                     element: 'PurchaseOrderItem' },
          additionalBinding: [{ localElement: 'PurchaseOrder',
                                element: 'PurchaseOrder' }]
        }]
      // ]--GENERATED

      @UI.hidden: true
      @ObjectModel.foreignKey.association: '_PurchaseOrderItem'
  key PurchaseOrderItem, 
      //--[ GENERATED:012:GFBfhyK17kY4ofIXD8GUQG

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'C_MM_MaterialValueHelp',
                     element: 'Material' }
        }]
      // ]--GENERATED

      @UI.lineItem: [{position: 40, importance: #HIGH }]
      @ObjectModel.foreignKey.association: '_Material'
      Material, 
      QuantityInBaseUnit,
      @UI.lineItem: [{position: 50, importance: #HIGH }] 
      QuantityInEntryUnit,
      GoodsReceiptQtyInOrderUnit,
      QtyInPurchaseOrderPriceUnit,
      @UI.lineItem: [{position: 60, importance: #HIGH }]
      @ObjectModel.foreignKey.association: '_Plant'
      Plant, 
      @UI.lineItem: [{position: 70, importance: #HIGH }]
      @ObjectModel.foreignKey.association: '_StorageLocation'
      StorageLocation, 
      @UI.lineItem: [{position: 80, importance: #HIGH }]
      cast ( GoodsMovementIsCancelled as mm_grpo_reversed preserving type ) as GoodsMovementIsCancelled, 
      GoodsMovementCancellationType, 
      GoodsMovementRefDocType,
      GoodsMovementType,
      
      StockIdentifyingMaterial,
      StockIdfgStorageLocation, 
      StockIdentifyingBatch, 
      SpecialStockIdfgSupplier, 
 //     SpecialStockIdfgSalesOrder, 

 //     SpecialStockIdfgSalesOrderItem, 

//      SpecialStockIdfgWBSElement, 

      SpecialStockIdfgCustomer, 
      InventorySpecialStockType, 
      InventoryStockType, 
//      SpecialStockIdfgStockOwner,

      Batch, 
      Supplier, 
      SalesOrder,
      SalesOrderItem, 
      SalesOrderScheduleLine, 
      Customer, 
      StockOwner, 
      WBSElementInternalID, 
      IssgOrRcvgMaterial, 
      cast ( IssuingOrReceivingPlant as umwrk preserving type) as IssuingOrReceivingPlant, 
      IssuingOrReceivingStorageLoc, 
      IssgOrRcvgBatch, 
      IssgOrRcvgSpclStockInd, 
      IssuingOrReceivingValType, 
//      IssuingOrReceivingStockType,  

      ConsumptionPosting, 
      GoodsMovementReasonCode,
      @ObjectModel.foreignKey.association: '_DebitCreditCode' // 3307123

      DebitCreditCode, 
      //InventoryUsabilityCode,

      MaterialBaseUnit, 
      DocumentDate, 
      AccountingDocumentType, 
      InventoryTransactionType, 
      InventorySpecialStockValnType, 
      CreationDate, 
      CreationTime, 
      CreatedByUser, 
//      DeliveryInMatlDocumentHeader, 

      BillOfLading, 
      ShelfLifeExpirationDate, 
      ManufactureDate, 
      EntryUnit, 
      InventoryValuationType,
      ProjectNetwork, 
      ManufacturingOrder, 
      ManufacturingOrderItem, 
      Reservation, 
      ReservationItem, 
      ReservationIsFinallyIssued, 
      DeliveryDocument, 
      DeliveryDocumentItem, 
      IsCompletelyDelivered, 
      ReversedMaterialDocumentYear, 
      ReversedMaterialDocument, 
      ReversedMaterialDocumentItem, 
      RvslOfGoodsReceiptIsAllowed, 
      IsReversalMovementType,
      GoodsRecipientName, 
      UnloadingPointName, 
      CostCenter, 
      GLAccount, 
      CostObject, 
//      @VDM.lifecycle.status: #DEPRECATED

//      @VDM.lifecycle.successor: 'profitabilitysegment_2'

//      ProfitabilitySegment,

//      ProfitabilitySegment_2,

      ProfitCenter, 
      cast ( CostEstimate as fis_kalnr preserving type ) as CostEstimate, 
      ReferenceDocument, 
      ServicePerformer, 
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'PersonWorkAgreement'
      EmploymentInternalID,
      PersonWorkAgreement, 
      AccountAssignmentCategory, 
      WorkItem, 
      ServicesRenderedDate, 
      CompanyCode, 
      BusinessArea, 
      ControllingArea, 
      FunctionalArea, 
      PostingDate, 
      FiscalYearPeriod, 
      FiscalYearVariant, 
      YearDay, 
      YearWeek, 
      YearMonth, 
      YearQuarter, 
  //    DocumentYear, 

      CalendarQuarter, 
      CalendarMonth, 
      CalendarWeek, 
      CalendarDay, 
      WeekDay, 
      FiscalYear, 
      YearPeriod, 
      TotalGoodsMvtAmtInCCCrcy, 
      GoodsMovementStkAmtInCCCrcy, 
      GoodsMvtCnsmpnAmtInCCCrcy, 
      CompanyCodeCurrency, 
      GdsMvtExtAmtInCoCodeCrcy, 
      SlsPrcAmtInclVATInCoCodeCrcy, 
      EnteredSlsAmtInCoCodeCrcy,
      /* Associations */ 
      _GoodsMovementType,  
      _Material,  
      _Plant,  
      _PurchaseOrder, 
      _PurchaseOrderItem, 
      _StorageLocation,
      _DebitCreditCode  // 3307123      

}
    where PurchaseOrder != ''           //3011678

      and MaterialDocumentRecordType = 'MDOC'      // 3170684

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MATERIALDOCUMENTRECORD"
],
"ASSOCIATED":
[
"I_DEBITCREDITCODE",
"I_GOODSMOVEMENTTYPE",
"I_MATERIAL",
"I_PLANT",
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM",
"I_STORAGELOCATION"
],
"BASE":
[
"I_MATERIALDOCUMENTRECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/