P_DunningProcedureValueHelp

DDL: P_DUNNINGPROCEDUREVALUEHELP SQL: PDUNNPROCVH Type: view BASIC Package: ODATA_CUSTOMER_LIST

Dunning Procedure Value Help

P_DunningProcedureValueHelp is a Basic CDS View that provides data about "Dunning Procedure Value Help" in SAP S/4HANA. It reads from 2 data sources (t047a, t047t) and exposes 2 fields with key field DunningProcedure. Part of development package ODATA_CUSTOMER_LIST.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
t047a _DunningProcedure from
t047t _Text left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PDUNNPROCVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable true view
Consumption.ranked true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY DunningProcedure t047a mahna
DunningProcedureDescription t047t textm 
@AbapCatalog.sqlViewName: 'PDUNNPROCVH'
@ClientHandling.algorithm : #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@VDM.viewType: #BASIC
@VDM.private: true
@Search.searchable: true
@Consumption.ranked: true

define view P_DunningProcedureValueHelp
  as select from t047a as _DunningProcedure
    left outer join   t047t as _Text on  _Text.mahna = _DunningProcedure.mahna
                                and _Text.spras = $session.system_language
{

  @ObjectModel.text.element: 'DunningProcedureDescription'
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #HIGH
  key _DunningProcedure.mahna       as  DunningProcedure,

  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #LOW
  _Text.textm                       as  DunningProcedureDescription
}

Learn More