I_SOMU_LOGO

DDL: I_SOMU_LOGO SQL: ILOGO Type: view TRANSACTIONAL Package: S_APS_OM_ODATA_FT_PARTS

Interface view for logos

I_SOMU_LOGO is a Transactional CDS View that provides data about "Interface view for logos" in SAP S/4HANA. It reads from 1 data source (p_somu_logo) and exposes 12 fields with key field LogoName. It has 1 association to related views. Part of development package S_APS_OM_ODATA_FT_PARTS.

Data Sources (1)

SourceAliasJoin Type
p_somu_logo p_somu_logo from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SOMU_RELFORM_LIST _RelFormList $projection.LogoName = _RelFormList.Logo

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILOGO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Interface view for logos view
Metadata.allowExtensions true view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.compositionRoot true view
ObjectModel.writeActivePersistence SFORM_VM_LOGO view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LogoName name Zone name
LastChangeDateTime changedat Time Stamp
LastChangedByUser changedby User Name
LogoCreationDateTime createdat Time Stamp
CreatedByUser createdby User Name
LogoDescription description Well Code Des.
FileSize filesize Safety Data Sheet File Size
LogoImage logo
MimeType mimetype MIMETYPE
LogoThumbnailImage thumbnail
NumberOfRelatedForms RelFormCount
_RelFormList _RelFormList

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_SOMU_LOGO.
-- 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: ILOGO

CREATE VIEW I_SOMU_LOGO AS
SELECT
  name AS LogoName,
  changedat AS LastChangeDateTime,
  changedby AS LastChangedByUser,
  createdat AS LogoCreationDateTime,
  createdby AS CreatedByUser,
  description AS LogoDescription,
  FileSize,
  logo AS LogoImage,
  MimeType,
  thumbnail AS LogoThumbnailImage,
  RelFormCount AS NumberOfRelatedForms
FROM p_somu_logo
LEFT OUTER JOIN I_SOMU_RELFORM_LIST AS _RelFormList ON LogoName = _RelFormList.Logo  -- association [0..*]
;