R_HANDLINGUNITITEMSERIALNOTP

CDS View

Handling Unit Item Serial Number - TP

R_HANDLINGUNITITEMSERIALNOTP is a CDS View in S/4HANA. Handling Unit Item Serial Number - TP. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_HandlingUnitItemSerialNumber view_entity projection CONSUMPTION Serial Number of Handling Unit Item
I_HandlingUnitItemSerialNoTP view_entity projection TRANSACTIONAL Handling Unit Item Serial Number - TP 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Handling Unit Item Serial Number - TP'

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL

define view entity R_HandlingUnitItemSerialNoTP
  as select from I_HndlgUnitItemSrlNoCombined
  
    inner join   R_HandlingUnitItemTP on  R_HandlingUnitItemTP.Warehouse              = I_HndlgUnitItemSrlNoCombined.Warehouse
                                      and R_HandlingUnitItemTP.HandlingUnitExternalID = I_HndlgUnitItemSrlNoCombined.HandlingUnitExternalID
                                      and R_HandlingUnitItemTP.StockItemUUID          = I_HndlgUnitItemSrlNoCombined.StockItemUUID
                                      and R_HandlingUnitItemTP.HandlingUnitItem       = I_HndlgUnitItemSrlNoCombined.HandlingUnitItem
                                  
  association        to parent R_HandlingUnitItemTP as _HandlingUnitItem on  $projection.HandlingUnitExternalID = _HandlingUnitItem.HandlingUnitExternalID
                                                                         and $projection.StockItemUUID          = _HandlingUnitItem.StockItemUUID
                                                                         and $projection.Warehouse              = _HandlingUnitItem.Warehouse

  // association to HU Header needed for RAP authorization/lock

  association [1..1] to R_HandlingUnitTP            as _HandlingUnit     on  $projection.HandlingUnitExternalID = _HandlingUnit.HandlingUnitExternalID
                                                                         and $projection.Warehouse              = _HandlingUnit.Warehouse
{
  key I_HndlgUnitItemSrlNoCombined.HandlingUnitItem,
  key R_HandlingUnitItemTP.HandlingUnitExternalID as HandlingUnitExternalID,
  @Environment.sql.passValue: true
  key R_HandlingUnitItemTP.Warehouse              as Warehouse,
  key R_HandlingUnitItemTP.StockItemUUID          as StockItemUUID,
  key I_HndlgUnitItemSrlNoCombined.SerialNumber,
      I_HndlgUnitItemSrlNoCombined.Equipment,
      I_HndlgUnitItemSrlNoCombined.HandlingUnitInternalID,
      I_HndlgUnitItemSrlNoCombined.Material,

      /* Associations */
      _HandlingUnitItem,
      _HandlingUnit
}

Learn More