SADL_V_EXP_Test_VH_Def

DDL: SADL_V_EXP_TEST_VH_DEF SQL: SADLTEST_VHDEF Type: view

Test VH Definition with param

SADL_V_EXP_Test_VH_Def is a CDS View that provides data about "Test VH Definition with param" in SAP S/4HANA. It reads from 1 data source (snwd_so) and exposes 1 field.

1 data source(s) 1 fields

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_VHDEF view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Test VH Definition with param view
OData.publish true view

Fields (1)

KeyFieldSource TableSource FieldDescription
P_DisplayCurrencyasDisplCurrency 
@AbapCatalog.sqlViewName: 'SADLTEST_VHDEF'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Test VH Definition with param'
@OData.publish: true

define view SADL_V_EXP_Test_VH_Def
  with parameters
    @Consumption.valueHelpDefinition: [{ entity : { name    : 'SADL_V_EXP_Test_Chg_Rate',                   // value-list = true

                                                    element : 'ExchangeRateType'
                                                  },
                                                    additionalBinding : [{ localParameter : 'P_DisplayCurrency',
                                                                           parameter      : 'ReferenceCurrency'
                                                                        }],
                                                    label : 'Exchange Rate Type VH Label'
                                      }]
    --    @Consumption.hidden: true
    P_ExchangeRateType : kurst_curr, --EURO
    @UI.hidden: true
    --    @Consumption.hidden: true
    P_DisplayCurrency  : bwaer_curv --EUR
  as select from snwd_so as so

  //    association [0..1] to SADL_V_EXP_Test_Chg_Rate as _ExchangeRateType on  _ExchangeRateType.ExchangeRateType  = $projection.ExchangeRate

  //                                                                        and _ExchangeRateType.ReferenceCurrency = $projection.DisplCurrency


  // association to SADL_V_EXP_Test_Chg_Rate as _ExchangeRateType on  _ExchangeRateType.ExchangeRateType  = $parameters.P_ExchangeRateType

  //                                                         and _ExchangeRateType.ReferenceCurrency = $parameters.P_DisplayCurrency

{
  key node_key                        as salesOrderKey,
      @UI.selectionField.position:20
      @UI.lineItem.position: 10
      so_id                           as salesOrderId,
      created_by                      as createdBy,
      created_at                      as createdAt,
      changed_by                      as changedBy,
      changed_at                      as changedAt,
      @UI.lineItem.position: 20
      currency_code                   as currencyCode,
      @UI.lineItem.position: 30
      gross_amount                    as grossAmount,

      //            @Consumption.valueHelp: '_ExchangeRateType'

      //                  @Consumption.valueHelpDefinition: [{ entity : { name    : 'SADL_V_EXP_Test_Chg_Rate',                   // value-list = true

      //                                                            element : 'ExchangeRateType'

      //                                                          },

      //                                                            additionalBinding : [{ localParameter : 'P_DisplayCurrency',

      //                                                                                   parameter      : 'ReferenceCurrency'

      //                                                                                }],

      //                                                            label : 'Exchange Rate Type VH Label'

      //                                              }]

      @UI.selectionField.position:30
      $parameters.P_ExchangeRateType  as ExchangeRate,
      $parameters.P_DisplayCurrency   as DisplCurrency
      //

      //            _ExchangeRateType


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SNWD_SO"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More