C_SADL_V_EXP_TEST_VH_Def

DDL: C_SADL_V_EXP_TEST_VH_DEF SQL: SADLTEST_PARAM Type: view

Sadl Vocan Test View: UIHidden for Param

C_SADL_V_EXP_TEST_VH_Def is a CDS View that provides data about "Sadl Vocan Test View: UIHidden for Param" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 8 fields with key field salesOrderKey.

Data Sources (1)

SourceAliasJoin Type
snwd_so so from

Parameters (2)

NameTypeDefault
P_ExchangeRateType kurst_curr
P_DisplayCurrency bwaer_curv

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName SADLTEST_PARAM view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Sadl Vocan Test View: UIHidden for Param view
OData.publish true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY salesOrderKey node_key Tree Model: Node Key
salesOrderId so_id Sales Order ID
changedAt changed_at Timestamp
createdAt created_at Uploaded On
currencyCode currency_code Currency Code
grossAmount gross_amount Tax-Inclusive Amount
ExchangeRate
DisplCurrency

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_SADL_V_EXP_TEST_VH_Def.
-- 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: SADLTEST_PARAM
-- Parameters: P_ExchangeRateType : kurst_curr, P_DisplayCurrency : bwaer_curv

CREATE VIEW C_SADL_V_EXP_TEST_VH_Def AS
SELECT
  node_key AS salesOrderKey,
  so_id AS salesOrderId,
  changed_at AS changedAt,
  created_at AS createdAt,
  currency_code AS currencyCode,
  gross_amount AS grossAmount,
  $parameters.P_ExchangeRateType AS ExchangeRate,
  $parameters.P_DisplayCurrency AS DisplCurrency
FROM snwd_so AS so
;