C_InvgCsMLocationImageTP

DDL: C_INVGCSMLOCATIONIMAGETP SQL: CINVGCSMLOCIMGTP Type: view CONSUMPTION
15 Fields 1 Data Sources 1 Associations

Consumption View for ICM Location Image

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

Data Sources (1)

SourceAliasJoin Type
I_InvgCsMLocationImageTP I_InvgCsMLocationImageTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_InvgCsMLocationTP _Location _Location.InvgCsMLocationID = $projection.InvgCsMImageObjectKey

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CINVGCSMLOCIMGTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption View for ICM Location Image view
VDM.viewType #CONSUMPTION 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
_Location _Location

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_InvgCsMLocationImageTP.
-- 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: CINVGCSMLOCIMGTP

CREATE VIEW C_InvgCsMLocationImageTP AS
SELECT
  InvgCsMImageFileID,
  InvgCsMImageObjectKey,
  DocumentInfoRecordDocType,
  DocumentInfoRecordDocNumber,
  DocumentInfoRecordDocPart,
  DocumentInfoRecordDocVersion,
  PhysicalDocument,
  InvgCsMImageObjectType,
  InvgCsMImageFileName,
  WorkstationApplication,
  FileSize,
  StorageCategory,
  cast(' ' as crms4_icm_imageurl ) AS InvgCsMImageURL,
  InvgCsMIsMainImage
FROM I_InvgCsMLocationImageTP
LEFT OUTER JOIN C_InvgCsMLocationTP AS _Location ON _Location.InvgCsMLocationID = InvgCsMImageObjectKey  -- association [1..1]
;

Learn More