/SAPCEM/SHSM_VS3

DDL: /SAPCEM/SHSM_VS3 SQL: /SAPCEM/VS3_SH Type: view
13 Fields 1 Data Sources

CDS View for Search help /SAPCEM/VS3

/SAPCEM/SHSM_VS3 is a CDS View that provides data about "CDS View for Search help /SAPCEM/VS3" in SAP S/4HANA. It reads from 1 data source (/sapcem/vs3) and exposes 13 fields with key fields j_3gbelnr, j_3gbelnri, j_3gposnri, j_3guposnr.

Data Sources (1)

SourceAliasJoin Type
/sapcem/vs3 /sapcem/vs3 from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName /SAPCEM/VS3_SH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View for Search help /SAPCEM/VS3 view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY j_3gbelnr j_3gbelnr Ext. doc. no.
KEY j_3gbelnri j_3gbelnri Document number
KEY j_3gposnri j_3gposnri Item number
KEY j_3guposnr j_3guposnr Sub-item
j_3gabsend j_3gabsend Sender
j_3gempfae j_3gempfae Recipient
j_3gbeldat j_3gbeldat Document date
j_3gbeweg j_3gbeweg Transctn type
ernam ernam User Name
erdat erdat Entered On
matnr matnr Vehicle Model
j_3gbelsta j_3gbelsta Int. doc. sts
j_3gblart j_3gblart Document type

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 /SAPCEM/SHSM_VS3.
-- 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: /SAPCEM/VS3_SH

CREATE VIEW /SAPCEM/SHSM_VS3 AS
SELECT
  j_3gbelnr,
  j_3gbelnri,
  j_3gposnri,
  j_3guposnr,
  j_3gabsend,
  j_3gempfae,
  j_3gbeldat,
  j_3gbeweg,
  ernam,
  erdat,
  matnr,
  j_3gbelsta,
  j_3gblart
FROM /sapcem/vs3
;

Learn More