I_InsurApplContrCvrgTypeRgnlCl

DDL: I_INSURAPPLCONTRCVRGTYPERGNLCL Type: view_entity COMPOSITE
20 Fields 2 Data Sources 2 Associations

Cvrg Type Rgnl Cl of Contr in Insur Appl

I_InsurApplContrCvrgTypeRgnlCl is a Composite CDS View that provides data about "Cvrg Type Rgnl Cl of Contr in Insur Appl" in SAP S/4HANA. It reads from 2 data sources (P_InsurPolicyJournalKeys, I_InsurPlcyTypeRgnlClassBasic) and exposes 20 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyTypeRgnlClassID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
P_InsurPolicyJournalKeys PlcyJrnl from
I_InsurPlcyTypeRgnlClassBasic TypeRgnl inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InsurPolicyRegionalClassLink _InsurPolicyRegionalClassLink $projection.InsurPlcyRegionalClass = _InsurPolicyRegionalClassLink.InsurPlcyRegionalClass and $projection.InsurPlcyTypeRgnlClassTemplate = _InsurPolicyRegionalClassLink.InsurPlcyTypeRgnlClassTemplate
[1..*] I_InsurPlcyTemplateT _InsurPlcyTemplateT $projection.InsurPlcyTypeRgnlClassTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate

Annotations (11)

NameValueLevelField
EndUserText.label Cvrg Type Rgnl Cl of Contr in Insur Appl view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyTypeRgnlClassID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations false view
Analytics.technicalName IACoCvTypeRgnlCl view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyTypeRgnlClassBasic InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr I_InsurPlcyTypeRgnlClassBasic InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID I_InsurPlcyTypeRgnlClassBasic InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID I_InsurPlcyTypeRgnlClassBasic InsurPlcyCoverageID Coverage Key
KEY InsurPlcyTypeRgnlClassID I_InsurPlcyTypeRgnlClassBasic InsurPlcyTypeRgnlClassID
KEY InsurPlcyContrDataDetnJrnlNmbr
InsurPlcyJrnlNmbr I_InsurPlcyTypeRgnlClassBasic InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr I_InsurPlcyTypeRgnlClassBasic InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID I_InsurPlcyTypeRgnlClassBasic InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyTypeRgnlClassTemplate I_InsurPlcyTypeRgnlClassBasic InsurPlcyTypeRgnlClassTemplate
InsurPlcyTypeClass I_InsurPlcyTypeRgnlClassBasic InsurPlcyTypeClass
InsurPlcyManualTypeClass I_InsurPlcyTypeRgnlClassBasic InsurPlcyManualTypeClass
InsurPlcyManualTypeClassIsUsed I_InsurPlcyTypeRgnlClassBasic InsurPlcyManualTypeClassIsUsed
InsurPlcyTmpTypeClIsFrmGIA I_InsurPlcyTypeRgnlClassBasic InsurPlcyTmpTypeClIsFrmGIA
InsurPlcyTmpTypeClIsFrmInsurCo I_InsurPlcyTypeRgnlClassBasic InsurPlcyTmpTypeClIsFrmInsurCo
InsurPlcyRegionalClass I_InsurPlcyTypeRgnlClassBasic InsurPlcyRegionalClass
LastChangeDateTime I_InsurPlcyTypeRgnlClassBasic LastChangeDateTime Timestamp
_InsurApplContrCoverage _InsurApplContrCoverage
_InsurPolicyRegionalClassLink _InsurPolicyRegionalClassLink
_InsurPlcyTemplateT _InsurPlcyTemplateT

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_InsurApplContrCvrgTypeRgnlCl.
-- 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_InsurApplContrCvrgTypeRgnlCl AS
SELECT
  TypeRgnl.InsurPlcyUUID AS InsurPlcyUUID,
  TypeRgnl.InsurPlcyInsurContr AS InsurPlcyInsurContr,
  TypeRgnl.InsurPlcyCoveragePackageID AS InsurPlcyCoveragePackageID,
  TypeRgnl.InsurPlcyCoverageID AS InsurPlcyCoverageID,
  TypeRgnl.InsurPlcyTypeRgnlClassID AS InsurPlcyTypeRgnlClassID,
  cast( PlcyJrnl.InsurPlcyContrDataDetnJrnlNmbr as /pm0/vdm_contr_detn_jrnlnmbr preserving type ) AS InsurPlcyContrDataDetnJrnlNmbr,
  TypeRgnl.InsurPlcyJrnlNmbr AS InsurPlcyJrnlNmbr,
  TypeRgnl.InsurPlcyJrnlEndNmbr AS InsurPlcyJrnlEndNmbr,
  TypeRgnl.InsurPlcyProductPackageID AS InsurPlcyProductPackageID,
  TypeRgnl.InsurPlcyTypeRgnlClassTemplate AS InsurPlcyTypeRgnlClassTemplate,
  TypeRgnl.InsurPlcyTypeClass AS InsurPlcyTypeClass,
  TypeRgnl.InsurPlcyManualTypeClass AS InsurPlcyManualTypeClass,
  TypeRgnl.InsurPlcyManualTypeClassIsUsed AS InsurPlcyManualTypeClassIsUsed,
  TypeRgnl.InsurPlcyTmpTypeClIsFrmGIA AS InsurPlcyTmpTypeClIsFrmGIA,
  TypeRgnl.InsurPlcyTmpTypeClIsFrmInsurCo AS InsurPlcyTmpTypeClIsFrmInsurCo,
  TypeRgnl.InsurPlcyRegionalClass AS InsurPlcyRegionalClass,
  TypeRgnl.LastChangeDateTime AS LastChangeDateTime
FROM P_InsurPolicyJournalKeys AS PlcyJrnl
INNER JOIN I_InsurPlcyTypeRgnlClassBasic AS TypeRgnl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InsurPolicyRegionalClassLink AS _InsurPolicyRegionalClassLink ON InsurPlcyRegionalClass = _InsurPolicyRegionalClassLink.InsurPlcyRegionalClass AND InsurPlcyTypeRgnlClassTemplate = _InsurPolicyRegionalClassLink.InsurPlcyTypeRgnlClassTemplate  -- association [1..1]
LEFT OUTER JOIN I_InsurPlcyTemplateT AS _InsurPlcyTemplateT ON InsurPlcyTypeRgnlClassTemplate = _InsurPlcyTemplateT.InsurPlcyTemplate  -- association [1..*]
;

Learn More