C_ContractAccountValueHelp
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 63 OData services (ASQL_F0860, ASQL_F0860A, ASQL_F0861, ...). 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.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ContractAccountPartner | I_ContractAccountPartner | from |
Annotations (14)
| Name | Value | Level | Field |
|---|---|---|---|
| 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 (63)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| ASQL_F0860 | ASQL_F0860 | C2 | NOT_RELEASED | |
| ASQL_F0860A | ASQL_F0860A | C2 | NOT_RELEASED | |
| ASQL_F0861 | ASQL_F0861 | C2 | NOT_RELEASED | |
| ASQL_F0861A | ASQL_F0861A | C2 | NOT_RELEASED | |
| ASQL_F1239 | ASQL_F1239 | C2 | NOT_RELEASED | |
| ASQL_F1653 | ASQL_F1653 | C2 | NOT_RELEASED | |
| ASQL_F1653A | ASQL_F1653A | C2 | NOT_RELEASED | |
| ASQL_F1655 | ASQL_F1655 | C2 | NOT_RELEASED | |
| ASQL_F1655A | ASQL_F1655A | C2 | NOT_RELEASED | |
| ASQL_F2122 | ASQL_F2122 | C2 | NOT_RELEASED | |
| ASQL_F2122A | ASQL_F2122A | C2 | NOT_RELEASED | |
| ASQL_F2123 | ASQL_F2123 | C2 | NOT_RELEASED | |
| ASQL_F2124 | ASQL_F2124 | C2 | NOT_RELEASED | |
| ASQL_F2124A | ASQL_F2124A | C2 | NOT_RELEASED | |
| ASQL_F2125A | ASQL_F2125A | C2 | NOT_RELEASED | |
| ASQL_F2208 | ASQL_F2208 | C2 | NOT_RELEASED | |
| ASQL_F2208A | ASQL_F2208A | C2 | NOT_RELEASED | |
| ASQL_F2209 | ASQL_F2209 | C2 | NOT_RELEASED | |
| ASQL_F2363 | ASQL_F2363 | C2 | NOT_RELEASED | |
| ASQL_F2363A | ASQL_F2363A | C2 | NOT_RELEASED | |
| ASQL_F2364 | ASQL_F2364 | C2 | NOT_RELEASED | |
| ASQL_F2364A | ASQL_F2364A | C2 | NOT_RELEASED | |
| ASQL_F2402A | ASQL_F2402A | C2 | NOT_RELEASED | |
| ASQL_F2596 | ASQL_F2596 | C2 | NOT_RELEASED | |
| ASQL_F2596A | ASQL_F2596A | C2 | NOT_RELEASED | |
| ASQL_F2600 | ASQL_F2600 | C2 | NOT_RELEASED | |
| ASQL_F2600A | ASQL_F2600A | C2 | NOT_RELEASED | |
| ASQL_F2622 | ASQL_F2622 | C2 | NOT_RELEASED | |
| ASQL_F3068 | ASQL_F3068 | C2 | NOT_RELEASED | |
| ASQL_F3126 | ASQL_F3126 | C2 | NOT_RELEASED | |
| ASQL_F3338A | ASQL_F3338A | C2 | NOT_RELEASED | |
| ASQL_F3977 | ASQL_F3977 | C2 | NOT_RELEASED | |
| ASQL_F4294 | ASQL_F4294 | C2 | NOT_RELEASED | |
| ASQL_F4398 | ASQL_F4398 | C2 | NOT_RELEASED | |
| ASQL_F4443 | ASQL_F4443 | C2 | NOT_RELEASED | |
| ASQL_F4522 | ASQL_F4522 | C2 | NOT_RELEASED | |
| ASQL_F4537 | ASQL_F4537 | C2 | NOT_RELEASED | |
| ASQL_F4664 | ASQL_F4664 | C2 | NOT_RELEASED | |
| ASQL_F4824 | ASQL_F4824 | C2 | NOT_RELEASED | |
| ASQL_F4866 | ASQL_F4866 | C2 | NOT_RELEASED | |
| ASQL_F4943 | ASQL_F4943 | C2 | NOT_RELEASED | |
| ASQL_F5081 | ASQL_F5081 | C2 | NOT_RELEASED | |
| ASQL_F5158 | ASQL_F5158 | C2 | NOT_RELEASED | |
| ASQL_F5493 | ASQL_F5493 | C2 | NOT_RELEASED | |
| ASQL_F5494 | ASQL_F5494 | C2 | NOT_RELEASED | |
| ASQL_F5720 | ASQL_F5720 | C2 | NOT_RELEASED | |
| ASQL_F6109 | ASQL_F6109 | C2 | NOT_RELEASED | |
| ASQL_F6134 | ASQL_F6134 | C2 | NOT_RELEASED | |
| ASQL_F6350 | ASQL_F6350 | C2 | NOT_RELEASED | |
| ASQL_F7105 | ASQL_F7105 | C2 | NOT_RELEASED | |
| ASQL_F7437 | ASQL_F7437 | C2 | NOT_RELEASED | |
| ASQL_F7575 | ASQL_F7575 | C2 | NOT_RELEASED | |
| ASQL_F7761 | ASQL_F7761 | C2 | NOT_RELEASED | |
| ASQL_F7988 | ASQL_F7988 | C2 | NOT_RELEASED | |
| ASQL_F7989 | ASQL_F7989 | C2 | NOT_RELEASED | |
| ASQL_F7991 | ASQL_F7991 | C2 | NOT_RELEASED | |
| ASQL_F8301 | ASQL_F8301 | C2 | NOT_RELEASED | |
| ASQL_F8302 | ASQL_F8302 | C2 | NOT_RELEASED | |
| 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 ID | App Name | Type | Description |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ContractAccount | ContractAccount | Contract Acct | |
| KEY | BusinessPartner | BusinessPartner | Issuing Authority | |
| ContractAccountCategory | _ContrAcc | ContractAccountCategory | Kategorie | |
| CreationDate | CreationDate | Time Stamp | ||
| CAAuthorizationGroup | CAAuthorizationGroup | AuthorizGroup | ||
| ContractAccountName | ContractAccountName | Cont. acct name | ||
| BusinessPartnerFullName | _BusinessPartner | BusinessPartnerFullName | Broker Name | |
| ContractAccountCategoryName | ||||
| _ContrAcc | _ContrAcc | |||
| _BusinessPartner | _BusinessPartner |
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_ContractAccountValueHelp.
-- 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: CCTRACCVH
CREATE VIEW C_ContractAccountValueHelp AS
SELECT
ContractAccount,
BusinessPartner,
_ContrAcc.ContractAccountCategory AS ContractAccountCategory,
CreationDate,
CAAuthorizationGroup,
ContractAccountName,
_BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
_ContrAcc._Category._Text[1:Language = $session.system_language].ContractAccountCategoryName AS ContractAccountCategoryName
FROM I_ContractAccountPartner
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA