I_ResourceBasic

DDL: I_RESOURCEBASIC SQL: IRESOURCEBASIC Type: view BASIC

APO Resource

I_ResourceBasic is a Basic CDS View that provides data about "APO Resource" in SAP S/4HANA. It reads from 1 data source (/sapapo/res_head) and exposes 16 fields with key fields ResourceUUID, ResourceSimulationSessionUUID, ResourceSimulationVersionUUID. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
/sapapo/res_head ResourceBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ResourceTextBasic _ResourceTextBasic $projection.ResourceUUID = _ResourceTextBasic.ResourceUUID and $projection.ResourceSimulationSessionUUID = _ResourceTextBasic.ResourceSimulationSessionUUID and $projection.ResourceSimulationVersionUUID = _ResourceTextBasic.ResourceSimulationVersionUUID
[0..1] I_LocationBasic _LocationBasic $projection.ResourceHomeLocationUUID = _LocationBasic.LocationUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IRESOURCEBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ResourceUUID view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #NONE view
EndUserText.label APO Resource view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ResourceUUID /sapapo/res_head resuid
KEY ResourceSimulationSessionUUID /sapapo/res_head simsessid
KEY ResourceSimulationVersionUUID /sapapo/res_head simversid
ResourceID /sapapo/res_head name
ResourceType /sapapo/res_head type
ResourceTimeZone /sapapo/res_head tzone
ResourceFactoryCalendar /sapapo/res_head calendar
TransportMeansType /sapapo/res_head traty
ResourceHomeLocationUUID /sapapo/res_head locid
LastChangedByUser /sapapo/res_head changeuser
ChangedDateTime /sapapo/res_head changedate
ResourceHomeLocation _LocationBasic Location
IsBusinessPurposeCompleted _LocationBasic IsBusinessPurposeCompleted
AuthorizationGroup _LocationBasic AuthorizationGroup
_ResourceTextBasic _ResourceTextBasic
_LocationBasic _LocationBasic 
@AbapCatalog.sqlViewName:                   'IRESOURCEBASIC'

@AbapCatalog.compiler.compareFilter:        true
@AbapCatalog.preserveKey:                   true
@AccessControl.authorizationCheck:          #NOT_REQUIRED
@AccessControl.personalData.blocking:       #NOT_REQUIRED
@ClientHandling.algorithm:                  #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:      #C
@ObjectModel.usageType.sizeCategory:        #L
@ObjectModel.usageType.dataClass:           #MASTER
@ObjectModel.representativeKey:             'ResourceUUID'
@VDM.viewType:                              #BASIC
@VDM.lifecycle.contract.type:               #NONE

@EndUserText.label:                         'APO Resource'

define view I_ResourceBasic
  as select from /sapapo/res_head as ResourceBasic
  association [0..*] to I_ResourceTextBasic as _ResourceTextBasic on  $projection.ResourceUUID                  = _ResourceTextBasic.ResourceUUID
                                                                  and $projection.ResourceSimulationSessionUUID = _ResourceTextBasic.ResourceSimulationSessionUUID
                                                                  and $projection.ResourceSimulationVersionUUID = _ResourceTextBasic.ResourceSimulationVersionUUID
  association [0..1] to I_LocationBasic     as _LocationBasic     on  $projection.ResourceHomeLocationUUID = _LocationBasic.LocationUUID
{
  @Semantics.uuid 
  key ResourceBasic.resuid                      as ResourceUUID,
  @Semantics.uuid 
  key ResourceBasic.simsessid                   as ResourceSimulationSessionUUID,
  @Semantics.uuid 
  key ResourceBasic.simversid                   as ResourceSimulationVersionUUID,
      ResourceBasic.name                        as ResourceID,
      ResourceBasic.type                        as ResourceType,
      ResourceBasic.tzone                       as ResourceTimeZone,
      ResourceBasic.calendar                    as ResourceFactoryCalendar,
      ResourceBasic.traty                       as TransportMeansType,
      @Semantics.uuid 
      ResourceBasic.locid                       as ResourceHomeLocationUUID,
      ResourceBasic.changeuser                  as LastChangedByUser,
      ResourceBasic.changedate                  as ChangedDateTime,
      _LocationBasic.Location                   as ResourceHomeLocation,
      @Semantics.booleanIndicator
      _LocationBasic.IsBusinessPurposeCompleted as IsBusinessPurposeCompleted,
      _LocationBasic.AuthorizationGroup         as AuthorizationGroup,
      _ResourceTextBasic,
      _LocationBasic
}

Learn More