C_InvgCsMObjectImageTP

DDL: C_INVGCSMOBJECTIMAGETP SQL: CINVGCSMOBJIMGTP Type: view CONSUMPTION
15 Fields 1 Data Sources 1 Associations

Consumption View for ICM Object Image

C_InvgCsMObjectImageTP is a Consumption CDS View that provides data about "Consumption View for ICM Object Image" in SAP S/4HANA. It reads from 1 data source (I_InvgCsMObjectImageTP) and exposes 15 fields with key fields InvgCsMImageFileID, InvgCsMImageObjectKey. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InvgCsMObjectImageTP I_InvgCsMObjectImageTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_InvgCsMObjectTP _Object _Object.InvgCsMObjectID = $projection.InvgCsMImageObjectKey

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CINVGCSMOBJIMGTP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for ICM Object Image view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMImageFileID InvgCsMImageFileID
KEY InvgCsMImageObjectKey InvgCsMImageObjectKey
DocumentInfoRecordDocType DocumentInfoRecordDocType Document Type
DocumentInfoRecordDocNumber DocumentInfoRecordDocNumber Document
DocumentInfoRecordDocPart DocumentInfoRecordDocPart Document Part
DocumentInfoRecordDocVersion DocumentInfoRecordDocVersion Doc. Version
PhysicalDocument PhysicalDocument Phys. Document
InvgCsMImageObjectType InvgCsMImageObjectType
InvgCsMImageFileName InvgCsMImageFileName Name
WorkstationApplication WorkstationApplication Applic.
FileSize FileSize Safety Data Sheet File Size
StorageCategory StorageCategory Category
InvgCsMImageURL
InvgCsMIsMainImage InvgCsMIsMainImage Main Image
_Object _Object

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 C_InvgCsMObjectImageTP.
-- 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: CINVGCSMOBJIMGTP

CREATE VIEW C_InvgCsMObjectImageTP AS
SELECT
  InvgCsMImageFileID,
  InvgCsMImageObjectKey,
  DocumentInfoRecordDocType,
  DocumentInfoRecordDocNumber,
  DocumentInfoRecordDocPart,
  DocumentInfoRecordDocVersion,
  PhysicalDocument,
  InvgCsMImageObjectType,
  InvgCsMImageFileName,
  WorkstationApplication,
  FileSize,
  StorageCategory,
  cast(' ' as crms4_icm_imageurl ) AS InvgCsMImageURL,
  InvgCsMIsMainImage
FROM I_InvgCsMObjectImageTP
LEFT OUTER JOIN C_InvgCsMObjectTP AS _Object ON _Object.InvgCsMObjectID = InvgCsMImageObjectKey  -- association [1..1]
;

Learn More