I_HandlingUnitHistory

DDL: I_HANDLINGUNITHISTORY Type: view BASIC

Handling Unit History

I_HandlingUnitHistory is a Basic CDS View that provides data about "Handling Unit History" in SAP S/4HANA. It reads from 1 data source (vevw) and exposes 8 fields with key fields SourceHandlingUnitUUID, HandlingUnitObjectKeyType, HandlingUnitObjectKey. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
vevw HandlingUnitHistory from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_HandlingUnitObjectKeyType _HandlingUnitObjectKeyType _HandlingUnitObjectKeyType.HandlingUnitObjectKeyType = $projection.HandlingUnitObjectKeyType
[1..1] I_HandlingUnitHeader _HandlingUnitHeader _HandlingUnitHeader.SourceHandlingUnitUUID = $projection.SourceHandlingUnitUUID

Annotations (12)

NameValueLevelField
EndUserText.label Handling Unit History view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName IHANDLGUNITHIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
ObjectModel.usageType.sizeCategory #XL view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY SourceHandlingUnitUUID handle
KEY HandlingUnitObjectKeyType object
KEY HandlingUnitObjectKey objkey
LastChangeDateTime tstamp
HandlingUnitExternalID _HandlingUnitHeader HandlingUnitExternalID
HandlingUnitInternalID _HandlingUnitHeader HandlingUnitInternalID
_HandlingUnitObjectKeyType _HandlingUnitObjectKeyType
_HandlingUnitHeader _HandlingUnitHeader 
@EndUserText.label: 'Handling Unit History'

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

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@AbapCatalog: { 
    sqlViewName: 'IHANDLGUNITHIST',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel: {
   usageType: {
     serviceQuality:  #C,
     dataClass:       #ORGANIZATIONAL,
     sizeCategory:    #XL
   }
}
define view I_HandlingUnitHistory
  as select from vevw  as HandlingUnitHistory
  association [0..1]   to I_HandlingUnitObjectKeyType   as _HandlingUnitObjectKeyType    on _HandlingUnitObjectKeyType.HandlingUnitObjectKeyType    = $projection.HandlingUnitObjectKeyType
  association [1..1]   to I_HandlingUnitHeader          as _HandlingUnitHeader           on _HandlingUnitHeader.SourceHandlingUnitUUID              = $projection.SourceHandlingUnitUUID

//    associations to authorization views

//    association [0..*] to I_PPM_AuthznByUsrH        as _AuthUser

//            on      _AuthUser.ReferencedObjectUUID   = $projection.TaskUUID

//             and    _AuthUser.UserID                 = $session.user

//             and (  _AuthUser.Activity = 'Admin'     or _AuthUser.Activity = 'Write'      or _AuthUser.Activity = 'Read' )        

{

//HandlingUnitHistory 

                 key handle as SourceHandlingUnitUUID, 
                 key object as HandlingUnitObjectKeyType, 
                 key objkey as HandlingUnitObjectKey, 
                 tstamp     as LastChangeDateTime,                   
                 _HandlingUnitHeader.HandlingUnitExternalID as HandlingUnitExternalID,
                 _HandlingUnitHeader.HandlingUnitInternalID as HandlingUnitInternalID,
                 
//                 direction  as OutboundDelivery

 // Associations     

_HandlingUnitObjectKeyType,
_HandlingUnitHeader
 }                               
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HANDLINGUNITHEADER",
"VEVW"
],
"ASSOCIATED":
[
"I_HANDLINGUNITHEADER",
"I_HANDLINGUNITOBJECTKEYTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More