R_HandlingUnitReferenceDocTP

DDL: R_HANDLINGUNITREFERENCEDOCTP Type: view_entity TRANSACTIONAL

Handling Unit Reference Doc - TP

R_HandlingUnitReferenceDocTP is a Transactional CDS View that provides data about "Handling Unit Reference Doc - TP" in SAP S/4HANA. It reads from 1 data source (P_EWM_HNDLGUNITHDRDELIVREF03) and exposes 7 fields with key fields Warehouse, HandlingUnitExternalID, HandlingUnitReferenceDocument.

Data Sources (1)

SourceAliasJoin Type
P_EWM_HNDLGUNITHDRDELIVREF03 P_EWM_HNDLGUNITHDRDELIVREF03 from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Handling Unit Reference Doc - 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 (7)

KeyFieldSource TableSource FieldDescription
KEY Warehouse EWMWarehouse
KEY HandlingUnitExternalID
KEY HandlingUnitReferenceDocument HandlingUnitReferenceDocument
HandlingUnitUUID HandlingUnitUUID
Plant _HandlingUnit Plant
ShippingPoint _HandlingUnit ShippingPoint
_HandlingUnit _HandlingUnit
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY

@EndUserText.label: 'Handling Unit Reference Doc - TP'
@Metadata.ignorePropagatedAnnotations: true

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

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

// Only for EWM -> LO HU doesn't have Cross-HUs => Entity not required for LO

define view entity R_HandlingUnitReferenceDocTP
  as select from P_EWM_HNDLGUNITHDRDELIVREF03

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

{
  key EWMWarehouse                                            as Warehouse,
  key cast( HandlingUnitExternalID as exidv preserving type ) as HandlingUnitExternalID,
      //remove leading zeros

  key HandlingUnitReferenceDocument,

      @Consumption.hidden: true
      HandlingUnitUUID,

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

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

      // Associations

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