I_InvgCsMPersonImage

DDL: I_INVGCSMPERSONIMAGE SQL: IICMPERSONIMAGE Type: view BASIC

Image of an ICM person

I_InvgCsMPersonImage is a Basic CDS View that provides data about "Image of an ICM person" in SAP S/4HANA. It reads from 1 data source (I_DocumentInfoRecordObjectLink) and exposes 15 fields with key fields InvgCsMImageFileID, InvgCsMImageObjectKey.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_DocumentInfoRecordObjectLink _DirObjectLinks from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICMPERSONIMAGE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Image of an ICM person view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMImageFileID FileUUID
KEY InvgCsMImageObjectKey LinkedSAPObjectKey
DocumentInfoRecordDocType I_DocumentInfoRecordObjectLink DocumentInfoRecordDocType
InvgCsMImageURL
InvgCsMIsMainImage
InvgCsMImageMimeType
DocumentInfoRecordDocNumber I_DocumentInfoRecordObjectLink DocumentInfoRecordDocNumber
DocumentInfoRecordDocPart I_DocumentInfoRecordObjectLink DocumentInfoRecordDocPart
DocumentInfoRecordDocVersion I_DocumentInfoRecordObjectLink DocumentInfoRecordDocVersion
PhysicalDocument _DirOriginals PhysicalDocument
InvgCsMImageObjectType I_DocumentInfoRecordObjectLink LinkedSAPObject
InvgCsMImageFileName _DirOriginals FileName
WorkstationApplication _DirOriginals WorkstationApplication
FileSize _DirOriginals FileSize
StorageCategory _DirOriginals StorageCategory 
@AbapCatalog.sqlViewName: 'IICMPERSONIMAGE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Image of an ICM person'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_InvgCsMPersonImage
  as select from           I_DocumentInfoRecordObjectLink as _DirObjectLinks
    left outer to one join I_DocumentInfoRecordAttachment as _DirOriginals on  _DirObjectLinks.DocumentInfoRecordDocType    = _DirOriginals.DocumentInfoRecordDocType
                                                                           and _DirObjectLinks.DocumentInfoRecordDocNumber  = _DirOriginals.DocumentInfoRecordDocNumber
                                                                           and _DirObjectLinks.DocumentInfoRecordDocPart    = _DirOriginals.DocumentInfoRecordDocPart
                                                                           and _DirObjectLinks.DocumentInfoRecordDocVersion = _DirOriginals.DocumentInfoRecordDocVersion
{
  key    FileUUID                              as InvgCsMImageFileID,
  key    LinkedSAPObjectKey                    as InvgCsMImageObjectKey,
         _DirObjectLinks.DocumentInfoRecordDocType,
         cast(' ' as crms4_icm_imageurl )      as InvgCsMImageURL,
         cast('' as boolean)                   as InvgCsMIsMainImage,
         substring(_DirOriginals.MimeType,1,5) as InvgCsMImageMimeType,
         _DirObjectLinks.DocumentInfoRecordDocNumber,
         _DirObjectLinks.DocumentInfoRecordDocPart,
         _DirObjectLinks.DocumentInfoRecordDocVersion,
         _DirOriginals.PhysicalDocument,
         _DirObjectLinks.LinkedSAPObject       as InvgCsMImageObjectType,
         _DirOriginals.FileName                as InvgCsMImageFileName,
         _DirOriginals.WorkstationApplication,
         _DirOriginals.FileSize,
         _DirOriginals.StorageCategory



}

where
  LinkedSAPObject = 'ICM_BP'

Learn More