I_FldLogsProcessReceiptsTP

@AbapCatalog.sqlViewName: 'IFLPRTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
authorizationCheck: #CHECK,
personalData.blocking: #REQUIRED
}
@EndUserText.label: 'Field Logistics : Process Receipts'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view I_FldLogsProcessReceiptsTP
  as select from I_FldLogsProcRcptSrchEnbld as SearchEnabled

    inner join   I_PurchasingDocumentItem   as _PO on  _PO.PurchasingDocument     = SearchEnabled.PurchasingDocument
                                                   and _PO.PurchasingDocumentItem = SearchEnabled.PurchasingDocumentItem

  association [0..1] to I_PurgDocumentItemCategoryText as _PoDocCatTxt                 on  _PoDocCatTxt.PurchasingDocumentItemCategory = SearchEnabled.PurchasingDocumentItemCategory
                                                                                       and _PoDocCatTxt.Language                       = $session.system_language

  association [1..1] to I_Plant                        as _PlantName                   on  SearchEnabled.Plant = _PlantName.Plant
                                                                                       and _PlantName.Language = $session.system_language
  association [0..1] to I_FldLogsSupplierItem          as _SupplierItem                on  _SupplierItem.FldLogsSuplrItemUUID = $projection.FldLogsSuplrItemUUID
  association [1..1] to I_FldLogsSuplrItmVislInspVH    as _FldLogsSuplrItmVislInspText on  _FldLogsSuplrItmVislInspText.FldLogsSuplrItemVislInspCode = $projection.FldLogsSuplrItemVislInspCode
                                                                                       and _FldLogsSuplrItmVislInspText.Language                     = $session.system_language
  association [0..1] to I_GenericPriorityText          as _GenericPriorityText         on  _GenericPriorityText.PriorityCode        = $projection.MaintPriority
                                                                                       and _GenericPriorityText.Language            = $session.system_language
                                                                                       and _GenericPriorityText.GenericPriorityType = 'PM'
  association [0..1] to I_FldLogsItemTypeVH            as _ItemType                    on  _ItemType.FldLogsItemType = $projection.FldLogsItemType
                                                                                       and _ItemType.Language        = $session.system_language
  association [0..1] to I_GoodsMovementTypeT           as _GoodsMovementTypeT          on  $projection.GoodsMovementType = _GoodsMovementTypeT.GoodsMovementType
                                                                                       and _GoodsMovementTypeT.Language  = $session.system_language
  //for storage location name

  association [0..1] to I_StorageLocation              as _StorageLocation             on  $projection.StorageLocation = _StorageLocation.StorageLocation
                                                                                       and $projection.Plant           = _StorageLocation.Plant

  association [0..1] to I_FldLogsStatusVH              as _FldLogsStatusTxt            on  $projection.FldLogsStatus  = _FldLogsStatusTxt.FldLogsStatus
                                                                                       and _FldLogsStatusTxt.Language = $session.system_language
  // Stock Type - Text

  association [0..1] to I_StockTypeText_2              as _StockTypeText               on  _StockTypeText.StockType = $projection.InventoryUsabilityCode
                                                                                       and _StockTypeText.Language  = $session.system_language

  association [0..1] to I_Supplier                     as _Supplier                    on  _Supplier.Supplier = $projection.Supplier
  //Commented as part of Decommissioning of Storage Type

  //  association [0..1] to I_FldLogsDestinationVH         as _StorageTypeTxt              on  $projection.EWMWarehouse       = _StorageTypeTxt.EWMWarehouse

  //                                                                                       and $projection.FldLogsStorageType = _StorageTypeTxt.FldLogsStorageType

  association [0..1] to I_FldLogsMaterialDetails       as _PackagingMaterialTxt        on  $projection.PackagingMaterial = _PackagingMaterialTxt.MaterialName

  association [0..1] to I_FldLogsRblShipmentItem       as _OBDContainerItem            on  $projection.DeliveryDocument     is not initial
                                                                                       and $projection.DeliveryDocument     = _OBDContainerItem.DeliveryDocument
                                                                                       and $projection.DeliveryDocumentItem = _OBDContainerItem.DeliveryDocumentItem
  association [0..1] to I_FldLogsEWMStockTypeVH        as _EWMStockTypeTxt             on  $projection.FldLogsEWMStockType = _EWMStockTypeTxt.FldLogsEWMStockType
                                                                                       and $projection.EWMWarehouse        = _EWMStockTypeTxt.EWMWarehouse
                                                                                       and _EWMStockTypeTxt.Language       = $session.system_language

  association [0..1] to I_MaterialGroupText            as _MaterialGroupText           on  $projection.MaterialGroup   = _MaterialGroupText.MaterialGroup
                                                                                       and _MaterialGroupText.Language = $session.system_language
  association [0..1] to I_FldLogsProcRcptRcvgStatus    as _FldLogsProcRcptRcvgStatus   on  _FldLogsProcRcptRcvgStatus.FldLogsProcRecRcvgStatus = $projection.FldLogsProcRecRcvgStatus
                                                                                       and _FldLogsProcRcptRcvgStatus.Language                 = $session.system_language
  // description text for FL Status from EWM Ibd

  association [0..1] to I_FldLogsStatusVH              as _FldLogsStatusEWMTxt         on  $projection.FldLogsStatusFrmEWMInbDeliv = _FldLogsStatusEWMTxt.FldLogsStatus
                                                                                       and _FldLogsStatusEWMTxt.Language           = $session.system_language
  association [0..1] to I_BatchCrossPlant              as _Batch                       on  $projection.Batch    = _Batch.Batch
                                                                                       and $projection.Material = _Batch.Material                                                                                       
  //association [0..1] to I_Supplier                  as _ContainerOwnerTxt           on  _ContainerOwnerTxt.Supplier = $projection.FldLogsContainerOwner

  association [0..1] to I_OrderCategoryText             as _OrderCatTxt                on   $projection.OrderCategory  = _OrderCatTxt.OrderCategory and _OrderCatTxt.Language   = $session.system_language

{
  key  _PO.PurchasingDocument,
  key  _PO.PurchasingDocumentItem,
  key  SearchEnabled.DeliveryDocument,
  key  SearchEnabled.DeliveryDocumentItem,
  key  SearchEnabled.MaterialDocument,
  key  SearchEnabled.MaterialDocumentItem,
  key  SearchEnabled.MaterialDocumentYear,
  key  SearchEnabled.FldLogsSuplrItemUUID,
       SearchEnabled.FldLogsSuplrItmMatlDoc,
       SearchEnabled.GoodsMovementItem,
       SearchEnabled.GoodsMovementYear,
       SearchEnabled.FldLogsPurOrdItem,
       SearchEnabled.FldLogsDelivDocItem,
       SearchEnabled.OrderCategory,

       SearchEnabled.DeliveryDate,

       @ObjectModel.virtualElement: true
       @ObjectModel.virtualElementCalculatedBy: 'CL_FLOG_PROCRCPT_DLVSTATUS_TXT'
       cast('' as abap.char(20))                                                      as FldLogsSuplrItmDelivStatusText,
       _ItemType.FldLogsSuplrItemTypeText,

       SearchEnabled.FldLogsItemType,

       case
        when  SearchEnabled.DeliveryDate = $session.system_date then 3
        when  SearchEnabled.DeliveryDate < $session.system_date then 1
        else 0
        end                                                                           as FldLogsSuplrItmDelivCritlty,

       SearchEnabled.IsCompletelyDelivered,
       SearchEnabled.Supplier,
       _Supplier.SupplierName,

       //       @Semantics.booleanIndicator: true

       //       _Supplier.IsBusinessPurposeCompleted,

       SearchEnabled.Material,

       _PO.Material                                                                   as Product,

       _SupplierItem.FldLogsSuplrItemSerialNumber                                     as FldLogsSuplrItemSerialNumber,

       SearchEnabled.Plant,
       SearchEnabled.FldLogsRemotePlant,
       _PlantName.PlantName,
       //// Delivery qty

       @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
       SearchEnabled.FldLogsDelivQty,
       //// PO Open qty

       @Semantics.quantity.unitOfMeasure: 'POUnitOfMeasure'
       SearchEnabled.OpenQtyInPurchaseOrderUnit,
       //// Material Document confirmed qty

       @Semantics.quantity.unitOfMeasure: 'GoodsMovementEntryUnit'
       SearchEnabled.FldLogsGRQty,
       SearchEnabled.GoodsMovementEntryUnit,
       SearchEnabled.POUnitOfMeasure,
       /////Reversed quantity I354124

       SearchEnabled.FldLogsReversedQty,
       //// Actual PO qty

       @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
       SearchEnabled.FldLogsPOTotalQty,
       //// Blocked Qty in object page Receipt Info - Only for Pre-received Section

       @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
       SearchEnabled.FldLogsBlockedQty,
       //// Actual Delivered Qty in object page Receipt Info

       @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
       SearchEnabled.FldLogsActlDeliveredQuantity,

       SearchEnabled.OrderQuantityUnit,
       SearchEnabled.MaterialBaseUnit,
       SearchEnabled.FldLogsItmIsToBeReceived,
       SearchEnabled.FldLogsItmIsReceived,
       //failed receipts

       SearchEnabled.FldLogsItmIsFailed,
       SearchEnabled.FldLogsItmIsPreReceived,
       SearchEnabled.StorageLocation,
       SearchEnabled.DocumentCurrency,
       @Semantics.amount.currencyCode: 'DocumentCurrency'
       SearchEnabled.NetPriceAmount,
       @Semantics.quantity.unitOfMeasure:'HandlingUnitQuantityUnit'
       SearchEnabled.FldLogsOpenPackQty,
       //This is casted to BSTME as in App. Language translation is not happening due to data type for the below field

       //is predefined to UNIT(3)

       cast( SearchEnabled.HandlingUnitQuantityUnit as bstme )                        as HandlingUnitQuantityUnit,
       SearchEnabled.MaterialName,

       SearchEnabled.MaintPriority,
       SearchEnabled.MaintenanceOrder,
       _GenericPriorityText.GenericPriorityDesc,
       SearchEnabled.FldLogsDelivIsHeldOnShore,
       SearchEnabled.QltyMgmtInProcmtIsActive,

       SearchEnabled.EWMWarehouse,
       case
       when  SearchEnabled.EWMWarehouse is not initial or SearchEnabled.FldLogsIsSupplierItem is not initial
       then cast('X' as boolean)
       else cast( '' as boolean )
       end                                                                            as FldLogsIsWarehouseMngd,
       //Commented as part of Decommissioning of Storage Type and Storage bin

       //       SearchEnabled.FldLogsStorageType,

       //       SearchEnabled.EWMStorageBin,

       case
       when  SearchEnabled.FldLogsProcRecRcvgStatus = '01' or SearchEnabled.FldLogsProcRecRcvgStatus = '04'
       then 0
       // 2 step GR for future release

       //       when  SearchEnabled.FldLogsProcRecRcvgStatus = '02' or  SearchEnabled.FldLogsProcRecRcvgStatus = '04'

       //       then 3

       when  SearchEnabled.FldLogsProcRecRcvgStatus = '03'
       then 1
       else 3
       end                                                                            as FldLogsProcRecRcvgStsCritlty,
       SearchEnabled.FldLogsProcRecRcvgStatus,
       _FldLogsProcRcptRcvgStatus.FldLogsProcRcptRcvgStatusTxt,

       //Material document details

       SearchEnabled.PostingDate, //Goods receipt date

       SearchEnabled.DocumentDate,
       SearchEnabled.DocumentReferenceID, //Delivery Note

       SearchEnabled.GoodsMovementStatus,
       SearchEnabled.GoodsMovementType,
       SearchEnabled.InventoryValuationType,
       _GoodsMovementTypeT.GoodsMovementTypeName,

       SearchEnabled.InventoryUsabilityCode,
       SearchEnabled.InventoryUsabilityCode as StockType,
       _StockTypeText.StockTypeName,
       SearchEnabled.DeliveryDocumentBySupplier,
       //       @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'

       //       SearchEnabled.ItemGrossWeight,

       //       SearchEnabled.ItemWeightUnit,


       //Delivery Document header

       SearchEnabled.LoadingPoint,
       SearchEnabled.UnloadingPointName,
       SearchEnabled.FldLogsSuplrItemVislInspCode,
       _FldLogsSuplrItmVislInspText.FldLogsSuplrItemVislInspText,
       SearchEnabled.ReversedMaterialDocument,

       //failed receipts

       case when  SearchEnabled.FldLogsItmIsFailed = 'X'
       then 1 end                                                                     as FldLogsFailedRcptCritlty,

       //received tab

       SearchEnabled.Batch,
       //Commented for Performance issues, logic pushed up using _BATCH association

       //       SearchEnabled.ManufactureDate,

       //       SearchEnabled.ShelfLifeExpirationDate,

       _Batch,
       SearchEnabled.CreatedByUser,
       //serial number

       SearchEnabled.MaterialIsSerialManaged                                          as MaterialIsSerialManaged,
       //Show the serial numbers section only for V3 when materila is serial managed, V1 and V2 updated from action

       case
            when  SearchEnabled.MaterialIsSerialManaged is not initial and
       //( SearchEnabled.DeliveryDocument is initial and

       //                   ( ( SearchEnabled.EWMWarehouse is  initial or SearchEnabled.EWMWarehouse is  null ) and

                 ( SearchEnabled.FldLogsProcRecRcvgStatus = '01' or SearchEnabled.FldLogsProcRecRcvgStatus = '03' )
            then cast('' as boolean  preserving type  )
            else cast('X' as boolean  preserving type  ) end                          as FldLogsSerialSecIsHidden,
       case
       when  SearchEnabled.MaterialIsSerialManaged is not initial and
       // 2 step GR for future release

       //             ( SearchEnabled.FldLogsProcRecRcvgStatus = '02' or

       //               SearchEnabled.FldLogsProcRecRcvgStatus = '04' )

              SearchEnabled.FldLogsProcRecRcvgStatus = '02'
       then cast('' as boolean  preserving type  )
       else cast('X' as boolean  preserving type  ) end                               as FldLogsSrlSecAggrgnIsHidden,

       case
       when SearchEnabled.FldLogsItmIsReceived is not initial and
            SearchEnabled.MaterialIsSerialManaged is not initial
       then cast('X' as boolean  preserving type  )
       else cast('' as boolean  preserving type  ) end                                as FldLogsIsAutoSerialization,
       //batch managed

       case
       when SearchEnabled.IsBatchManagementRequired is not initial
       then cast('' as boolean  preserving type  )
       else cast('X' as boolean  preserving type  )
       end                                                                            as IsBatchManagementRequired,
       FldLogsIsSupplierItem,
       concat(concat( FldLogsSuplrItmMatlDoc, '/'),  SearchEnabled.GoodsMovementItem) as FldLogsMatlDocItem,

       SearchEnabled.InventoryStockType,
       SearchEnabled.InventoryStockTypeName,
       //cast('' as bktxt )                                                                             as MaterialDocumentHeaderText,

       SearchEnabled.MaterialDocumentHeaderText,
       cast( $session.system_date as budat preserving type )                          as FldLogsRvslPostingDate,
       SearchEnabled.FldLogsIsValnType,
       SearchEnabled.FldLogsManufactureDate,
       SearchEnabled.FldLogsShelfLifeExpiryDate,
       SearchEnabled.FldLogsItmIsAtRemote,
       SearchEnabled.FldLogsIsContainerHidden,
       case
         when
         SearchEnabled.FldLogsItmIsFailed is initial
         then cast('X' as boolean  preserving type  )
         else
         cast('' as boolean  preserving type  )
       end                                                                            as FldLogsErrorLogSecIsHidden,
       case
         when SearchEnabled.FldLogsItmIsReceived is initial
         then cast('X' as boolean  preserving type  )
         else
         cast('' as boolean  preserving type  ) end                                   as FldLogsIsVisibleInRcvd,
       SearchEnabled.PurchasingDocumentSubtype,
       _StorageLocation.StorageLocationName,

       //              case when SearchEnabled.ReversedMaterialDocument is not initial

       //              then cast( -1 * SearchEnabled.FldLogsGRQty as labst )

       //              else cast( SearchEnabled.FldLogsGRQty as labst ) end                           as FldLogsReversedQty,



       //


       PackagingMaterial,
       SearchEnabled.FldLogsStatus,
       SearchEnabled.FldLogsStatusFrmEWMInbDeliv, //Status IDB

       _FldLogsStatusTxt.FldLogsStatusTxt,
       _FldLogsStatusEWMTxt.FldLogsStatusTxt                                          as FldLogsStatusFrmEWMInbDelivTxt,
       SearchEnabled.MaterialGroup,
       _MaterialGroupText.MaterialGroupName,

       //       SearchEnabled.FldLogsContainerOwner,

       //       SearchEnabled.FldLogsSealNumber1,

       //       SearchEnabled.FldLogsSealNumber2,

       //       SearchEnabled.FldLogsSealNumber3,

       //       SearchEnabled.FldLogsSealNumber4,

       //       SearchEnabled.FldLogsSealNumber5,

       //       SearchEnabled.FldLogsSuplrItmPackggTypeCode,

       //       SearchEnabled.FldLogsSuplrItmPackggTypeTxt,

       //Hide Container information section for all items except package type "02 = Container"

       //Other types "00 = Item" "01 = Package"

       //       case

       //       when SearchEnabled.FldLogsSuplrItmPackggTypeCode = '02'

       //       then cast('' as boolean  preserving type  )

       //       else cast('X' as boolean  preserving type  ) end                                            as FldLogsCtnInfoSecIsHidden,

       cast('' as boolean)                                                            as FldLogsCtnInfoSecIsHidden,
       //hide the handling units section for supplier items and OBD items at remote

       case
       when SearchEnabled.FldLogsIsSupplierItem is not initial and
            ( SearchEnabled.FldLogsProcRecRcvgStatus = '01' or SearchEnabled.FldLogsProcRecRcvgStatus = '03' )
       then cast('X' as boolean  preserving type  )
       when SearchEnabled.FldLogsIsSupplierItem is initial and
            (SearchEnabled.DistrStatusByDecentralizedWrhs = '' or SearchEnabled.DistrStatusByDecentralizedWrhs is null or SearchEnabled.DistrStatusByDecentralizedWrhs is initial)
       // or SearchEnabled.PurchasingDocumentSubtype = 'T'

       // or SearchEnabled.FldLogsItmIsAtRemote is not initial

       then cast('X' as boolean  preserving type  )
       else cast (''as boolean  preserving type  ) end                                as FldLogsHandlingUnitSecIsHidden,
       // Supplier Item HU

       SearchEnabled.HandlingUnitExternalID,
       SearchEnabled.HandlingUnitId,
       //Commented as part of Decommissioning of Storage Type

       //       _StorageTypeTxt.StorageTypeName,

       _PackagingMaterialTxt.MaterialName                                             as PackagingMaterialName,
       case when _OBDContainerItem.DeliveryDocument is not null
            then cast( 'X' as boolean )
            else cast( '' as boolean ) end                                            as FldLogsOutbDelivIsAssgdToCtn,
       SearchEnabled.PickingStatus,
       SearchEnabled.IsToBeAcceptedAtOrigin,
       // 2 step GR for future release

       // Set read only for V1, receive at remote, supplier item, Pre-received, To be received if Origin flag is set

       //       case when ( SearchEnabled.FldLogsIsSupplierItem is not initial or

       //                   SearchEnabled.PurchasingDocumentSubtype = 'T' or

       //                   SearchEnabled.FldLogsProcRecRcvgStatus = '04' or

       //                   ( SearchEnabled.EWMWarehouse is not initial and SearchEnabled.FldLogsProcRecRcvgStatus = '01' ) or

       //                   ( SearchEnabled.FldLogsProcRecRcvgStatus = '01' and

       //                     SearchEnabled.IsToBeAcceptedAtOrigin is not initial )

       //                  )

       //       then cast('' as boolean )

       //       else

       //       cast('X' as boolean) end                                                                    as FldLogsGdsMvtTypeIsEditable,

       cast('' as boolean preserving type  )                                          as FldLogsGdsMvtTypeIsEditable,
       //Enable the print label button only for Received items and items not at remote and non-reversed items

       case

        when  SearchEnabled.FldLogsItmIsReceived is not initial and
              SearchEnabled.ReversedMaterialDocument is not initial
        then cast('' as boolean  preserving type  )
        when(SearchEnabled.FldLogsItmIsReceived is not initial and
             SearchEnabled.FldLogsItmIsAtRemote is initial)
        then cast('X' as boolean  preserving type  )
        else
        cast('' as boolean  preserving type  ) end                                    as FldLogsPrintLabelIsVisible,
       SearchEnabled.FldLogsPutawayQty,
       SearchEnabled.FldLogsEWMStockType,
       @Semantics.quantity.unitOfMeasure: 'MaterialBaseUnit'
       SearchEnabled.FldLogsOpenDelivQty,
       _EWMStockTypeTxt.StockTypeName                                                 as FldLogsEWMStockTypeText,
       SearchEnabled.IsBusinessPurposeCompleted,
       SearchEnabled.SuplrCoIsBusPrpsCmpltd,

       SearchEnabled.IsBusPrpsCmpltdCustomer,
       SearchEnabled.IsEndOfPurposeBlocked,
       _PoDocCatTxt.PurgDocItemCategoryName,
       _PoDocCatTxt.PurgDocExternalItemCategory,
       SearchEnabled.FldLogsProcRcptExtUnionID,
       _OrderCatTxt.OrderCategoryName
       
             // _ContainerOwnerTxt.SupplierName                                                             as FldLogsContainerOwnerName

       //       SearchEnabled.MORecipientLoc          //Add by Himanshu Gupta OGFIELDLOGISTICS8-1822

}