FCLM_BAM_SHLP_VGTYP

DDL: FCLM_BAM_SHLP_VGTYP SQL: VBAMSHLPVGTYP Type: view Package: FCLM_BAM

Search help collection view for Transaction Code

FCLM_BAM_SHLP_VGTYP is a CDS View that provides data about "Search help collection view for Transaction Code" in SAP S/4HANA. It reads from 2 data sources (t028v, t028w) and exposes 2 fields. Part of development package FCLM_BAM.

Data Sources (2)

SourceAliasJoin Type
t028v t028v from
t028w t028w left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName VBAMSHLPVGTYP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Search help collection view for Transaction Code view

Fields (2)

KeyFieldSource TableSource FieldDescription
TransactionCode
Description

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 FCLM_BAM_SHLP_VGTYP.
-- 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: VBAMSHLPVGTYP

CREATE VIEW FCLM_BAM_SHLP_VGTYP AS
SELECT
  cast ( t028v.vgtyp as fclm_bam_transaction_code ) AS TransactionCode,
  cast ( t028w.vgtxt as fclm_bam_transcode_text ) AS Description
FROM t028v
LEFT OUTER JOIN t028w ON /* join condition not captured in parsed metadata */
;