/SAPCEM/SHSM_VS2

DDL: /SAPCEM/SHSM_VS2 SQL: /SAPCEM/VS2_SH Type: view Package: /SAPCEM/DDIC
10 Fields 1 Data Sources

CDS view for search help for /SAPCEM/VS2

/SAPCEM/SHSM_VS2 is a CDS View that provides data about "CDS view for search help for /SAPCEM/VS2" in SAP S/4HANA. It reads from 1 data source (j_3gbelk) and exposes 10 fields with key fields j_3gbelnr, j_3gbelnri, j_3gabsend, j_3gempfae, j_3gbeldat. Part of development package /SAPCEM/DDIC.

Data Sources (1)

SourceAliasJoin Type
j_3gbelk j_3gbelk from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName /SAPCEM/VS2_SH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS view for search help for /SAPCEM/VS2 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 (10)

KeyFieldSource TableSource FieldDescription
KEY j_3gbelnr j_3gbelnr Ext. doc. no.
KEY j_3gbelnri j_3gbelnri Document number
KEY j_3gabsend j_3gabsend Sender
KEY j_3gempfae j_3gempfae Recipient
KEY j_3gbeldat j_3gbeldat Document date
KEY ernam _DocNo ernam User Name
KEY erdat _DocNo erdat Entered On
sapcemaufnr _DocNo /sapcem/aufnr
j_3gblart j_3gblart Document type
_DocNo _DocNo

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_VS2.
-- 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/VS2_SH

CREATE VIEW /SAPCEM/SHSM_VS2 AS
SELECT
  j_3gbelnr,
  j_3gbelnri,
  j_3gabsend,
  j_3gempfae,
  j_3gbeldat,
  _DocNo.ernam AS ernam,
  _DocNo.erdat AS erdat,
  _DocNo./sapcem/aufnr AS sapcemaufnr,
  j_3gblart
FROM j_3gbelk
;

Learn More