p_somu_logo

DDL: P_SOMU_LOGO SQL: PLOGO Type: view BASIC Package: S_APS_OM_ODATA_FT_PARTS
11 Fields 1 Data Sources 1 Associations

Private view for Logos

p_somu_logo is a Basic CDS View that provides data about "Private view for Logos" in SAP S/4HANA. It reads from 1 data source (sform_w_logo) and exposes 11 fields with key field name. It has 1 association to related views. Part of development package S_APS_OM_ODATA_FT_PARTS.

Data Sources (1)

SourceAliasJoin Type
sform_w_logo _logo from

Associations (1)

CardinalityTargetAliasCondition
[0..1] p_somu_relform _RelForms $projection.name = _RelForms.Logo

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PLOGO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Private view for Logos view
VDM.private true view
VDM.viewType #BASIC view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY name name Zone name
changedat changedat Time Stamp
changedby changedby User Name
createdat createdat Time Stamp
createdby createdby User Name
description description Well Code Des.
filesize filesize Safety Data Sheet File Size
logo logo
mimetype mimetype MIMETYPE
thumbnail thumbnail
RelFormCount _RelForms RelFormCount

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 p_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: PLOGO

CREATE VIEW p_somu_logo AS
SELECT
  name,
  changedat,
  changedby,
  createdat,
  createdby,
  description,
  filesize,
  logo,
  mimetype,
  thumbnail,
  _RelForms.RelFormCount AS RelFormCount
FROM sform_w_logo AS _logo
LEFT OUTER JOIN p_somu_relform AS _RelForms ON name = _RelForms.Logo  -- association [0..1]
;

Learn More