C_SSPMaterialValueHelp

DDL: C_SSPMATERIALVALUEHELP SQL: CSSPMATVALHELP Type: view CONSUMPTION
5 Fields 1 Associations

Value Help for local and hub Plant

C_SSPMaterialValueHelp is a Consumption CDS View that provides data about "Value Help for local and hub Plant" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material and _MaterialText.Language = $session.system_language

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.sqlViewName CSSPMATVALHELP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Value Help for local and hub Plant view
ObjectModel.dataCategory #VALUE_HELP view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
PurReqnSSPAuthor PurReqnSSPAuthor Author
MaterialName _MaterialText MaterialName Material Description
AuthorizationGroup AuthorizationGroup AuthorizGroup
BusinessUser BusinessUser

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 C_SSPMaterialValueHelp.
-- 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: CSSPMATVALHELP

CREATE VIEW C_SSPMaterialValueHelp AS
SELECT
  Material,
  PurReqnSSPAuthor,
  _MaterialText.MaterialName AS MaterialName,
  AuthorizationGroup,
  BusinessUser
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
;

Learn More