I_InsurIntClmTypeAllwdSubclm

DDL: I_INSURINTCLMTYPEALLWDSUBCLM Type: view BASIC
9 Fields 1 Data Sources 2 Associations

Interne Fallart: erlaubte Teilfallart

I_InsurIntClmTypeAllwdSubclm is a Basic CDS View that provides data about "Interne Fallart: erlaubte Teilfallart" in SAP S/4HANA. It reads from 1 data source (ticl005) and exposes 9 fields with key fields InsurClmType, InsurClmTypeGeneration, InsurClmTypeVers, InsurClmSubclmType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ticl005 ticl005 from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_InsurIntClmTypeAllwdReserve _AllowedReserveType $projection.InsurClmType = _AllowedReserveType.InsurClmType and $projection.InsurClmTypeGeneration = _AllowedReserveType.InsurClmTypeGeneration and $projection.InsurClmTypeVers = _AllowedReserveType.InsurClmTypeVers and $projection.InsurClmSubclmType = _AllowedReserveType.InsurClmSubclmType
[0..*] I_InsurIntClmTypeAllwdCvrg _AllowedCoverageType $projection.InsurClmType = _AllowedCoverageType.InsurClmType and $projection.InsurClmTypeGeneration = _AllowedCoverageType.InsurClmTypeGeneration and $projection.InsurClmTypeVers = _AllowedCoverageType.InsurClmTypeVers and $projection.InsurClmSubclmType = _AllowedCoverageType.InsurClmSubclmType

Annotations (11)

NameValueLevelField
EndUserText.label Interne Fallart: erlaubte Teilfallart view
AbapCatalog.sqlViewName IICLPERMSUBCLTYP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.status #ACTIVE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InsurClmType cltype Claim Type
KEY InsurClmTypeGeneration generat Generation
KEY InsurClmTypeVers version XML Vers.
KEY InsurClmSubclmType subcltype Subclaim Type
InsurClmBenefitTypeTree bentree Diff.Ben.T.Tree
InsurClmSubrogtnRcvryRsrvType sbrrestype Subro/RcvryResT
InsurClmSalvageReserveType salrestype Salvage ResType
_AllowedReserveType _AllowedReserveType
_AllowedCoverageType _AllowedCoverageType

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 I_InsurIntClmTypeAllwdSubclm.
-- 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.

CREATE VIEW I_InsurIntClmTypeAllwdSubclm AS
SELECT
  cltype AS InsurClmType,
  generat AS InsurClmTypeGeneration,
  version AS InsurClmTypeVers,
  subcltype AS InsurClmSubclmType,
  bentree AS InsurClmBenefitTypeTree,
  sbrrestype AS InsurClmSubrogtnRcvryRsrvType,
  salrestype AS InsurClmSalvageReserveType
FROM ticl005
LEFT OUTER JOIN I_InsurIntClmTypeAllwdReserve AS _AllowedReserveType ON InsurClmType = _AllowedReserveType.InsurClmType AND InsurClmTypeGeneration = _AllowedReserveType.InsurClmTypeGeneration AND InsurClmTypeVers = _AllowedReserveType.InsurClmTypeVers AND InsurClmSubclmType = _AllowedReserveType.InsurClmSubclmType  -- association [0..*]
LEFT OUTER JOIN I_InsurIntClmTypeAllwdCvrg AS _AllowedCoverageType ON InsurClmType = _AllowedCoverageType.InsurClmType AND InsurClmTypeGeneration = _AllowedCoverageType.InsurClmTypeGeneration AND InsurClmTypeVers = _AllowedCoverageType.InsurClmTypeVers AND InsurClmSubclmType = _AllowedCoverageType.InsurClmSubclmType  -- association [0..*]
;

Learn More