SHSM_V_EPROP

DDL: SHSM_V_EPROP SQL: SHSMVEPROP Type: view
7 Fields 2 Data Sources

Ownership by Owner Search Help

SHSM_V_EPROP is a CDS View that provides data about "Ownership by Owner Search Help" in SAP S/4HANA. It reads from 2 data sources (but000, eprop) and exposes 7 fields.

Data Sources (2)

SourceAliasJoin Type
but000 but000 inner
eprop eprop from

Annotations (11)

NameValueLevelField
EndUserText.label Ownership by Owner Search Help view
AbapCatalog.sqlViewName SHSMVEPROP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (7)

KeyFieldSource TableSource FieldDescription
owner eprop owner Vehicle Owner
property eprop property TrgtObjPrprty
acbact eprop acbact Generate event
mc_name1 but000 mc_name1 Name 1/Last Nme
mc_name2 but000 mc_name2 Name2/First Nme
augrp but000 augrp Component of the Version Number
xpcpt but000 xpcpt PurposeComplete Flag

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 SHSM_V_EPROP.
-- 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: SHSMVEPROP

CREATE VIEW SHSM_V_EPROP AS
SELECT
  eprop.owner AS owner,
  eprop.property AS property,
  eprop.acbact AS acbact,
  but000.mc_name1 AS mc_name1,
  but000.mc_name2 AS mc_name2,
  but000.augrp AS augrp,
  but000.xpcpt AS xpcpt
FROM eprop
INNER JOIN but000 ON /* join condition not captured in parsed metadata */
;

Learn More