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. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_HandlingUnitItemSerialNumber view_entity projection CONSUMPTION Serial Number of Handling Unit Item 
@AccessControl.authorizationCheck: #CHECK
@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,
  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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HNDLGUNITITEMSRLNOCOMBINED",
"R_HANDLINGUNITITEMTP"
],
"ASSOCIATED":
[
"R_HANDLINGUNITITEMTP",
"R_HANDLINGUNITTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More