C_ContractAccountValueHelp

DDL: C_CONTRACTACCOUNTVALUEHELP SQL: CCTRACCVH Type: view CONSUMPTION

Vertragskonto

C_ContractAccountValueHelp is a Consumption CDS View that provides data about "Vertragskonto" in SAP S/4HANA. It reads from 1 data source (I_ContractAccountPartner) and exposes 7 fields with key fields ContractAccount, BusinessPartner.

Data Sources (1)

SourceAliasJoin Type
I_ContractAccountPartner I_ContractAccountPartner from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCTRACCVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Vertragskonto view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ContractAccount view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #B view
Search.searchable true view
Consumption.ranked true view
VDM.viewType #CONSUMPTION view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount ContractAccount
KEY BusinessPartner BusinessPartner
ContractAccountName ContractAccountName Bezeichnung
ContractAccountCategory _ContrAcc ContractAccountCategory Kategorie
CreationDate CreationDate
CAAuthorizationGroup CAAuthorizationGroup
_ContrAcc _ContrAcc
@AbapCatalog.sqlViewName: 'CCTRACCVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Vertragskonto'
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'ContractAccount'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #B
@Search.searchable: true
@Consumption.ranked: true
@VDM.viewType: #CONSUMPTION
define view C_ContractAccountValueHelp
  as select from I_ContractAccountPartner
{

      @Consumption.valueHelpDefinition: null
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      @ObjectModel.text.element: 'ContractAccountName'
  key ContractAccount,

//      @Consumption.valueHelpDefinition: [{entity: { name: 'C_CAContractPartnerValueHelp', element: 'BusinessPartner'}}]

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
  key BusinessPartner,

      @EndUserText.label: 'Bezeichnung'
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      @Semantics.text: true
      ContractAccountName,

      @EndUserText.label: 'Kategorie'
      @Consumption.valueHelpDefinition: [{entity: { name: 'C_ContractAccountCatValueHelp', element: 'ContractAccountCategory'}}]
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      _ContrAcc.ContractAccountCategory,

      CreationDate,

      @UI.hidden: true
      CAStandardCompanyCode,
      @UI.hidden: true
      CAAuthorizationGroup,

      _ContrAcc


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CONTRACTACCOUNTHEADER",
"I_CONTRACTACCOUNTPARTNER"
],
"ASSOCIATED":
[
"I_CONTRACTACCOUNTHEADER"
],
"BASE":
[
"I_CONTRACTACCOUNTPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/