R_HandlingUnitAlternativeIdTP

DDL: R_HANDLINGUNITALTERNATIVEIDTP Type: view_entity TRANSACTIONAL

Handling Unit Alternative ID - TP

R_HandlingUnitAlternativeIdTP is a Transactional CDS View that provides data about "Handling Unit Alternative ID - TP" in SAP S/4HANA. It reads from 1 data source (P_EWM_HandlingUnitAltvId) and exposes 7 fields with key fields HandlingUnitExternalID, Warehouse, EWMHndlgUnitAltvIDType.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
P_EWM_HandlingUnitAltvId P_EWM_HandlingUnitAltvId from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Handling Unit Alternative ID - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.sapObjectNodeType.name HandlingUnit view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY HandlingUnitExternalID
KEY Warehouse EWMWarehouse
KEY EWMHndlgUnitAltvIDType EWMHndlgUnitAltvIDType
EWMHndlgUnitAltvID EWMHndlgUnitAltvID
Plant _HandlingUnit Plant
ShippingPoint _HandlingUnit ShippingPoint
_HandlingUnit _HandlingUnit 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Handling Unit Alternative ID - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}

@ObjectModel.sapObjectNodeType.name:'HandlingUnit'

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view entity R_HandlingUnitAlternativeIdTP
  as select from P_EWM_HandlingUnitAltvId

  association to parent R_HandlingUnitTP as _HandlingUnit on  $projection.Warehouse              = _HandlingUnit.Warehouse
                                                          and $projection.HandlingUnitExternalID = _HandlingUnit.HandlingUnitExternalID

{
  // Keep Keys stable

  key cast( HandlingUnitNumber as exidv preserving type ) as HandlingUnitExternalID,
  key EWMWarehouse                                        as Warehouse,
      // Discussed with Baris: Keep EWM GFNs to make clear, that those fields are not supported for LO-HUs

      // LO-HUs have "only" a field EXIDV2 (CHAR 20) to enter some additional information like vendor

  key EWMHndlgUnitAltvIDType,
      EWMHndlgUnitAltvID,

      // Property Plant is required for Access Control ( Header Access Control is reused )

      @Consumption.hidden:true
      _HandlingUnit.Plant,
      @Consumption.hidden: true
      _HandlingUnit.ShippingPoint,

      // Association to parent/root

      _HandlingUnit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EWM_HANDLINGUNITALTVID",
"R_HANDLINGUNITTP"
],
"ASSOCIATED":
[
"R_HANDLINGUNITTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More