C_InsurIntClmTypeAllwdRsrvVH

DDL: C_INSURINTCLMTYPEALLWDRSRVVH SQL: CICLRSRVTYPEVH Type: view CONSUMPTION
6 Fields 1 Data Sources 1 Associations

Allowed Reserve Types

C_InsurIntClmTypeAllwdRsrvVH is a Consumption CDS View that provides data about "Allowed Reserve Types" in SAP S/4HANA. It reads from 1 data source (I_InsurIntClmTypeAllwdReserve) and exposes 6 fields with key fields InsurClmType, InsurClmTypeGeneration, InsurClmTypeVers, InsurClmRsrvType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurIntClmTypeAllwdReserve I_InsurIntClmTypeAllwdReserve from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InsurClmReserveTypeText _ReserveType $projection.InsurClmRsrvType = _ReserveType.InsurClmRsrvType and _ReserveType.Language = $session.system_language

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CICLRSRVTYPEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Allowed Reserve Types view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY InsurClmType InsurClmType Claim Type
KEY InsurClmTypeGeneration InsurClmTypeGeneration Claim Type Gen
KEY InsurClmTypeVers InsurClmTypeVers Claim Type Version
KEY InsurClmRsrvType InsurClmRsrvType Reserve Type
InsurClmRsrvTypeName _ReserveType InsurClmRsrvTypeName Reserve Type Name
InsurClmReserveIsNotVisible InsurClmReserveIsNotVisible Res. NotVisible

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_InsurIntClmTypeAllwdRsrvVH.
-- 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: CICLRSRVTYPEVH

CREATE VIEW C_InsurIntClmTypeAllwdRsrvVH AS
SELECT
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers,
  InsurClmRsrvType,
  _ReserveType.InsurClmRsrvTypeName AS InsurClmRsrvTypeName,
  InsurClmReserveIsNotVisible
FROM I_InsurIntClmTypeAllwdReserve
LEFT OUTER JOIN I_InsurClmReserveTypeText AS _ReserveType ON InsurClmRsrvType = _ReserveType.InsurClmRsrvType AND _ReserveType.Language = $session.system_language  -- association [1..1]
;

Learn More