I_InvgCsMMainImage

DDL: I_INVGCSMMAINIMAGE SQL: IICMMAINIMG Type: view BASIC

Basic view for ICM Main Image

I_InvgCsMMainImage is a Basic CDS View that provides data about "Basic view for ICM Main Image" in SAP S/4HANA. It reads from 2 data sources (I_DocumentInfoRecordObjectLink, I_DocumentInfoRecordAttachment) and exposes 13 fields with key fields InvgCsMImageFileID, InvgCsMImageObjectKey.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_DocumentInfoRecordObjectLink _DirObjectLinks from
I_DocumentInfoRecordAttachment _DirOriginals left_outer

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICMMAINIMG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Basic view for ICM Main Image view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMImageFileID FileUUID
KEY InvgCsMImageObjectKey
DocumentInfoRecordDocType I_DocumentInfoRecordObjectLink DocumentInfoRecordDocType
DocumentInfoRecordDocNumber I_DocumentInfoRecordObjectLink DocumentInfoRecordDocNumber
DocumentInfoRecordDocPart I_DocumentInfoRecordObjectLink DocumentInfoRecordDocPart
DocumentInfoRecordDocVersion I_DocumentInfoRecordObjectLink DocumentInfoRecordDocVersion
PhysicalDocument I_DocumentInfoRecordAttachment PhysicalDocument
InvgCsMImageObjectType I_DocumentInfoRecordObjectLink LinkedSAPObject
InvgCsMImageFileName I_DocumentInfoRecordAttachment FileName
WorkstationApplication I_DocumentInfoRecordAttachment WorkstationApplication
FileSize I_DocumentInfoRecordAttachment FileSize
StorageCategory I_DocumentInfoRecordAttachment StorageCategory
InvgCsMImageMimeType 
@AbapCatalog.sqlViewName: 'IICMMAINIMG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Basic view for ICM Main Image'
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_InvgCsMMainImage
  as select from    I_DocumentInfoRecordObjectLink as _DirObjectLinks
    left outer 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    cast(LinkedSAPObjectKey as char20)    as InvgCsMImageObjectKey,
         _DirObjectLinks.DocumentInfoRecordDocType,
         _DirObjectLinks.DocumentInfoRecordDocNumber,
         _DirObjectLinks.DocumentInfoRecordDocPart,
         _DirObjectLinks.DocumentInfoRecordDocVersion,
         _DirOriginals.PhysicalDocument,
         _DirObjectLinks.LinkedSAPObject       as InvgCsMImageObjectType,
         _DirOriginals.FileName                as InvgCsMImageFileName,
         _DirOriginals.WorkstationApplication,
         _DirOriginals.FileSize,
         _DirOriginals.StorageCategory,
         substring(_DirOriginals.MimeType,1,5) as InvgCsMImageMimeType

}

where
     LinkedSAPObject = 'ICM_LOC'
  or LinkedSAPObject = 'ICM_OBJ'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DOCUMENTINFORECORDATTACHMENT",
"I_DOCUMENTINFORECORDOBJECTLINK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More