C_ContractAccountValueHelp

DDL: C_CONTRACTACCOUNTVALUEHELP SQL: CCTRACCVH Type: view CONSUMPTION Package: ODATA_O2C_FICA_GENTOOLS

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 10 fields with key fields ContractAccount, BusinessPartner. It is exposed through 5 OData services (MANAGE_SEPA_MANDATE, UI_CAACCOUNTBALANCE_DISPLAY, UI_CACLEARINGLOCK_ANALYSIS, ...). It is used in 3 Fiori applications: Analyze Clearing Locks (Version 2), Analyze Dunning Locks (Version 2), Manage SEPA Mandates. Part of development package ODATA_O2C_FICA_GENTOOLS.

1 data source(s) Exposed by 5 service(s) Used in 3 Fiori app(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_ContractAccountPartner I_ContractAccountPartner from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCTRACCVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED 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 #C view
Search.searchable true view
Consumption.ranked true view
VDM.viewType #CONSUMPTION view

OData Services (5)

ServiceBindingVersionContractRelease
MANAGE_SEPA_MANDATE MANAGE_SEPA_MANDATE V2 C1 NOT_TO_BE_RELEASED_STABLE
UI_CAACCOUNTBALANCE_DISPLAY UI_CAACCOUNTBALANCE_DISPLAY V4 C1 NOT_RELEASED
UI_CACLEARINGLOCK_ANALYSIS UI_CACLEARINGLOCK_ANALYSIS V2 C1 NOT_RELEASED
UI_CADUNNINGLOCK_ANALYSIS UI_CADUNNINGLOCK_ANALYSIS V2 C1 NOT_RELEASED
UI_CADUNNINGVOLUME_ANALYSIS UI_CADUNNINGVOL_ANALYSIS V2 C1 NOT_RELEASED

Fiori Apps (3)

App IDApp NameTypeDescription
F1653A Analyze Clearing Locks (Version 2) Transactional, Analytical An application to analyze clearing locks based on a snapshot of the locked open business partner items.
F1655A Analyze Dunning Locks (Version 2) Transactional, Analytical An application to analyze dunning locks based on a snapshot of the locked open business partner items.
F5158 Manage SEPA Mandates Transactional Manage SEPA Mandates is to to create, display, or change SEPA mandates for a customer or a business partner, navigating to the Create SEPA Mandates app, the Display SEPA Mandates app, and the Change SEPA Mandates app.

Analyze Clearing Locks (Version 2)

Business Role: Accounts Payable and Receivable Manager (FI-CA)

With the Analyze Clearing Locks app, you display existing clearing locks for receivables and payables. Using the app, you can display the amounts related to the selected locks in different currencies.As data volume in Contract Accounting can be very high, to improve performance, a new version of the app evaluates a system snapshot of receivables and payables instead of the current live data.

Analyze Dunning Locks (Version 2)

Business Role: Accounts Payable and Receivable Manager (FI-CA)

With the Analyze Dunning Locks app, you display existing dunning locks for receivables. Using the app, you can display the amounts related to the selected locks in different currencies.As data volume in Contract Accounting can be very high, to improve performance, a new version of the app evaluates a system snapshot of receivables instead of the current live data.

Manage SEPA Mandates

Business Role: Accounts Receivable Accountant

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ContractAccount ContractAccount
KEY BusinessPartner BusinessPartner
ContractAccountCategory _ContrAcc ContractAccountCategory Kategorie
CreationDate CreationDate
CAAuthorizationGroup CAAuthorizationGroup
ContractAccountName ContractAccountName
BusinessPartnerFullName _BusinessPartner BusinessPartnerFullName
ContractAccountCategoryName
_ContrAcc _ContrAcc
_BusinessPartner _BusinessPartner 
@AbapCatalog.sqlViewName: 'CCTRACCVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@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: #C
@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 }
      @UI.textArrangement: #TEXT_FIRST
      @ObjectModel.text.element:  [ 'ContractAccountName' ]
  key ContractAccount,

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

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      @UI.textArrangement: #TEXT_FIRST
      @ObjectModel.text.element:  [ 'BusinessPartnerFullName' ]
  key BusinessPartner,

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

      CreationDate,

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

      //Text elements

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      @Semantics.text: true
      @Consumption.filter.hidden: true
      ContractAccountName,
      
      @Semantics.text: true
      @Consumption.filter.hidden: true
      _BusinessPartner.BusinessPartnerFullName,
      
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      @Semantics.text: true
      @Consumption.filter.hidden: true
      _ContrAcc._Category._Text[1:Language = $session.system_language].ContractAccountCategoryName,
      

      @Consumption.hidden: true
      _ContrAcc,
      
      @Consumption.hidden: true
      _BusinessPartner


}

Learn More