P_GRItmOverview

@AbapCatalog.sqlViewName: 'PGRITEMOVW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'GR Item Overview'
define view P_GRItmOverview as select from I_PurchaseOrderHistoryBasic

  association [1..1] to I_MaterialDocumentRecord as _MatDocRec on  $projection.MaterialDocument          =  _MatDocRec.MaterialDocument
                                                               and $projection.MaterialDocumentItem      =  _MatDocRec.MaterialDocumentItem
                                                               and $projection.MaterialDocumentYear      =  _MatDocRec.MaterialDocumentYear
                                                               and _MatDocRec.MaterialDocumentRecordType =  'MDOC'
                                                               and _MatDocRec.IsAutomaticallyCreated     <> 'X'

{

  key PurchasingHistoryDocument                                                                                                          as MaterialDocument,

  key PurchasingHistoryDocumentItem                                                                                                      as MaterialDocumentItem,

  key PurchasingHistoryDocumentYear                                                                                                      as MaterialDocumentYear,

//      concat(concat(concat(concat(PurchasingHistoryDocument, '/'), PurchasingHistoryDocumentItem), '/' ), PurchasingHistoryDocumentYear) as FormattedPurDoc,

//

      // -----------------------------------------------------------------------------------

      // Filters

      // -----------------------------------------------------------------------------------


      _PurchaseOrder.Supplier,

      _PurchaseOrder._Supplier.SupplierName,

      _PurchaseOrderItem.MaterialGroup,

      _PurchaseOrder.PurchasingGroup,

      Plant,

      case GoodsMovementType
                  when '101' then cast('22' as abap.char(2)) --> Goods Received
                  when '102' then cast('14' as abap.char(2)) --> Cancelled
            else cast(' ' as abap.char(2))
            end                                                                                                                          as Status, --> GoodsReceiptStatus - GR status

      cast('2' as numc1)                                                                                                                 as ObjectType,

      Material,

      _PurchaseOrder.PurchasingOrganization,

      _PurchaseOrderItem.ServicePerformer,


      ''                                                                                                                                 as CostCenter,

      ''                                                                                                                                 as SalesOrder,

      ''                                                                                                                                 as WBSElementExternalID,
      _PurchaseOrder.PurchaseOrderType, //Required for DCL


      PurchaseOrder,

    ''                                                                                                                                 as SupplyingPlant,

      cast ('00000000' as mm_a_delivery_date)                                                                                            as DeliveryDate,

      PurchasingHistoryDocument                                                                                                          as PurchasingDocument,
//

      ''                                                                                                                                 as AccountAssignmentCategory,

      '_'                                                                                                                                as PurchasingDocumentItemCategory,
//

//      // -----------------------------------------------------------------------------------

//      // Associations

//      // -----------------------------------------------------------------------------------

//      _PurchaseOrderItem,

//

      _MatDocRec
}
where
  PurchasingHistoryCategory = 'E'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDERHISTORYBASIC",
"I_SUPPLIER",
"R_PURCHASEORDER",
"R_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_MATERIALDOCUMENTRECORD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/