R_HandlingUnitItemSerialNoTP

DDL: R_HANDLINGUNITITEMSERIALNOTP Type: view_entity TRANSACTIONAL

Handling Unit Item Serial Number - TP

R_HandlingUnitItemSerialNoTP is a Transactional CDS View that provides data about "Handling Unit Item Serial Number - TP" in SAP S/4HANA. It reads from 2 data sources (I_HndlgUnitItemSrlNoCombined, R_HandlingUnitItemTP) and exposes 10 fields with key fields HandlingUnitItem, HandlingUnitExternalID, Warehouse, StockItemUUID, SerialNumber. It has 1 association to related views.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_HndlgUnitItemSrlNoCombined I_HndlgUnitItemSrlNoCombined from
R_HandlingUnitItemTP R_HandlingUnitItemTP inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_HandlingUnitTP _HandlingUnit $projection.HandlingUnitExternalID = _HandlingUnit.HandlingUnitExternalID and $projection.Warehouse = _HandlingUnit.Warehouse

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Handling Unit Item Serial Number - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitItem I_HndlgUnitItemSrlNoCombined HandlingUnitItem
KEY HandlingUnitExternalID R_HandlingUnitItemTP HandlingUnitExternalID
KEY Warehouse R_HandlingUnitItemTP Warehouse
KEY StockItemUUID R_HandlingUnitItemTP StockItemUUID
KEY SerialNumber I_HndlgUnitItemSrlNoCombined SerialNumber
Equipment I_HndlgUnitItemSrlNoCombined Equipment
HandlingUnitInternalID I_HndlgUnitItemSrlNoCombined HandlingUnitInternalID
Material I_HndlgUnitItemSrlNoCombined Material
_HandlingUnitItem _HandlingUnitItem
_HandlingUnit _HandlingUnit 
@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
}

Learn More