C_ContractAccountCatValueHelp

DDL: C_CONTRACTACCOUNTCATVALUEHELP SQL: CCTRACCCATVH Type: view CONSUMPTION Package: ODATA_O2C_FICA_GENTOOLS
2 Fields 2 Data Sources 49 OData Services

Vertragskontotyp Wertehilfe

C_ContractAccountCatValueHelp is a Consumption CDS View that provides data about "Vertragskontotyp Wertehilfe" in SAP S/4HANA. It reads from 2 data sources (I_CAApplicationArea, I_ContractAccountCategory) and exposes 2 fields with key field ContractAccountCategory. It is exposed through 49 OData services (ASQL_F0860, ASQL_F0860A, ASQL_F0861, ...). Part of development package ODATA_O2C_FICA_GENTOOLS.

Data Sources (2)

SourceAliasJoin Type
I_CAApplicationArea _CAApplArea inner
I_ContractAccountCategory _Category from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CCTRACCCATVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Vertragskontotyp Wertehilfe view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ContractAccountCategory view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view
Consumption.ranked true view
VDM.viewType #CONSUMPTION view

OData Services (49)

ServiceBindingVersionContractRelease
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_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_F5474A ASQL_F5474A 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_F6134 ASQL_F6134 C2 NOT_RELEASED
ASQL_F8301 ASQL_F8301 C2 NOT_RELEASED
UI_CADUNNINGVOLUME_ANALYSIS UI_CADUNNINGVOL_ANALYSIS V2 C1 NOT_RELEASED

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ContractAccountCategory I_ContractAccountCategory ContractAccountCategory Kategorie
ContractAccountCategoryName Bezeichnung

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_ContractAccountCatValueHelp.
-- 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: CCTRACCCATVH

CREATE VIEW C_ContractAccountCatValueHelp AS
SELECT
  _Category.ContractAccountCategory AS ContractAccountCategory,
  _Category._Text[1:Language = $session.system_language].ContractAccountCategoryName AS ContractAccountCategoryName
FROM I_ContractAccountCategory AS _Category
INNER JOIN I_CAApplicationArea AS _CAApplArea ON /* join condition not captured in parsed metadata */
;

Learn More