UPOV_RUNID_DESTINATIONID

DDL: UPO_INT_V_RUNID_DESTINATIONID SQL: UPOS_RUNID_DEST Type: view

Allocation Results - Unique Destination

UPOV_RUNID_DESTINATIONID is a CDS View that provides data about "Allocation Results - Unique Destination" in SAP S/4HANA. It reads from 1 data source (gho_allocres_i) and exposes 2 fields with key fields RunId, DestinationNode.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
gho_allocres_i item inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_RUNID_DEST view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Allocation Results - Unique Destination view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY RunId gho_allocres_i alloc_run_id
KEY DestinationNode gho_allocres_i dest_node_id 
@AbapCatalog.sqlViewName: 'UPOS_RUNID_DEST'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@EndUserText.label: 'Allocation Results - Unique Destination'
define view UPOV_RUNID_DESTINATIONID
  as select distinct from gho_allocres_h as header
    inner join            gho_allocres_i as item on item.alloc_run_id   = header.alloc_run_id
                                                 and(
                                                   item.theo_act_ind    = 'A'
                                                   or item.theo_act_ind = 'B'
                                                   or item.theo_act_ind = 'R'
                                                   or item.theo_act_ind = 'S'
                                                   or item.theo_act_ind = 'D'
                                                 )

{
  key item.alloc_run_id as RunId,
  key item.dest_node_id as DestinationNode
}
where
       header.frequency    = 'M'
  and(
       header.alloc_status = '01'
    or header.alloc_status = '04'
  )
  and  header.final_ind    = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"GHO_ALLOCRES_H",
"GHO_ALLOCRES_I"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More