I_SalesOrderRequestSourceImage

DDL: I_SALESORDERREQUESTSOURCEIMAGE SQL: ISORSRCIMG Type: view BASIC

Source Image of Sales Order Request

I_SalesOrderRequestSourceImage is a Basic CDS View that provides data about "Source Image of Sales Order Request" in SAP S/4HANA. It reads from 1 data source (sdsor_ae_srcimg) and exposes 6 fields with key fields SalesOrderRequest, SlsOrdReqSourceImagePageNumber. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
sdsor_ae_srcimg sdsor_ae_srcimg from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesOrderRequest _SalesOrderRequest $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
[0..1] I_SalesOrderRequestSource _SalesOrderRequestSource $projection.SalesOrderRequest = _SalesOrderRequestSource.SalesOrderRequest

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISORSRCIMG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Source Image of Sales Order Request view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SalesOrderRequest salesorderrequest
KEY SlsOrdReqSourceImagePageNumber slsordreqsourceimagepagenumber
SlsOrdReqSourceImageMimeType slsordreqsourceimagemimetype
SlsOrdReqSrceImgContentBinary slsordreqsrceimgcontentbinary
_SalesOrderRequest _SalesOrderRequest
_SalesOrderRequestSource _SalesOrderRequestSource 
@AbapCatalog.sqlViewName: 'ISORSRCIMG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Source Image of Sales Order Request'
@ObjectModel:{
  usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@VDM: {
  viewType: #BASIC
}
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_SalesOrderRequestSourceImage 
as select from sdsor_ae_srcimg 
association [1..1] to I_SalesOrderRequest           as _SalesOrderRequest           on  $projection.SalesOrderRequest = _SalesOrderRequest.SalesOrderRequest
association [0..1] to I_SalesOrderRequestSource     as _SalesOrderRequestSource     on  $projection.SalesOrderRequest = _SalesOrderRequestSource.SalesOrderRequest
{
  key salesorderrequest as SalesOrderRequest,
  key slsordreqsourceimagepagenumber as SlsOrdReqSourceImagePageNumber,
  
  @Semantics.mimeType: true
  slsordreqsourceimagemimetype as SlsOrdReqSourceImageMimeType,
  
  @Semantics.largeObject.mimeType: 'SlsOrdReqSourceImageMimeType'
  @Semantics.largeObject.contentDispositionPreference: #ATTACHMENT
  @ObjectModel.filter.enabled:false
  @ObjectModel.sort.enabled:false
  slsordreqsrceimgcontentbinary as SlsOrdReqSrceImgContentBinary,  

  
//  Associations

  _SalesOrderRequest,
  _SalesOrderRequestSource
}

Learn More