I_InvgCsMMainImage

DDL: I_INVGCSMMAINIMAGE SQL: IICMMAINIMG Type: view COMPOSITE
13 Fields 2 Data Sources

ICM Main Image

I_InvgCsMMainImage is a Composite CDS View that provides data about "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.

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 ICM Main Image view
VDM.viewType #COMPOSITE 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 UUID
KEY InvgCsMImageObjectKey SAP Object Key
DocumentInfoRecordDocType I_DocumentInfoRecordObjectLink DocumentInfoRecordDocType Document Type
DocumentInfoRecordDocNumber I_DocumentInfoRecordObjectLink DocumentInfoRecordDocNumber Document
DocumentInfoRecordDocPart I_DocumentInfoRecordObjectLink DocumentInfoRecordDocPart Document Part
DocumentInfoRecordDocVersion I_DocumentInfoRecordObjectLink DocumentInfoRecordDocVersion Doc. Version
PhysicalDocument I_DocumentInfoRecordAttachment PhysicalDocument Phys. Document
InvgCsMImageObjectType I_DocumentInfoRecordObjectLink LinkedSAPObject Object
InvgCsMImageFileName I_DocumentInfoRecordAttachment FileName URL or Filenam Path
WorkstationApplication I_DocumentInfoRecordAttachment WorkstationApplication Applic.
FileSize I_DocumentInfoRecordAttachment FileSize Safety Data Sheet File Size
StorageCategory I_DocumentInfoRecordAttachment StorageCategory Category
InvgCsMImageMimeType

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_InvgCsMMainImage.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IICMMAINIMG

CREATE VIEW I_InvgCsMMainImage AS
SELECT
  FileUUID AS InvgCsMImageFileID,
  cast(LinkedSAPObjectKey as char20) AS InvgCsMImageObjectKey,
  _DirObjectLinks.DocumentInfoRecordDocType AS DocumentInfoRecordDocType,
  _DirObjectLinks.DocumentInfoRecordDocNumber AS DocumentInfoRecordDocNumber,
  _DirObjectLinks.DocumentInfoRecordDocPart AS DocumentInfoRecordDocPart,
  _DirObjectLinks.DocumentInfoRecordDocVersion AS DocumentInfoRecordDocVersion,
  _DirOriginals.PhysicalDocument AS PhysicalDocument,
  _DirObjectLinks.LinkedSAPObject AS InvgCsMImageObjectType,
  _DirOriginals.FileName AS InvgCsMImageFileName,
  _DirOriginals.WorkstationApplication AS WorkstationApplication,
  _DirOriginals.FileSize AS FileSize,
  _DirOriginals.StorageCategory AS StorageCategory,
  substring(_DirOriginals.MimeType,1,5) AS InvgCsMImageMimeType
FROM I_DocumentInfoRecordObjectLink AS _DirObjectLinks
LEFT OUTER JOIN I_DocumentInfoRecordAttachment AS _DirOriginals ON /* join condition not captured in parsed metadata */
;

Learn More