C_InsurPlcyDeductible

DDL: C_INSURPLCYDEDUCTIBLE Type: view_entity CONSUMPTION
28 Fields 1 Data Sources

Deductible

C_InsurPlcyDeductible is a Consumption CDS View that provides data about "Deductible" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyContrCvrgDeductible) and exposes 28 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcyCoveragePackageID, InsurPlcyCoverageID, InsurPlcyInsuredObjectID.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyContrCvrgDeductible I_InsurPlcyContrCvrgDeductible from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Deductible view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr Contract Key
KEY InsurPlcyCoveragePackageID InsurPlcyCoveragePackageID Cov.Package ID
KEY InsurPlcyCoverageID InsurPlcyCoverageID Coverage Key
KEY InsurPlcyInsuredObjectID InsurPlcyInsuredObjectID Ins. Obj. No.
KEY InsurPlcySubCvrgID InsurPlcySubCvrgID Subcoverage Key
KEY InsurPlcyDeductibleID InsurPlcyDeductibleID Deduct. ID
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsurPlcyProductPackageID InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyDeductibleCategory InsurPlcyDeductibleCategory Deductible Type
InsurPlcyDcblCategoryName
InsurPlcyDeductibleAmount InsurPlcyDeductibleAmount Deductible Amt
InsurPlcyDeductibleStartDate InsurPlcyDeductibleStartDate Deductible Start
InsurPlcyDeductibleEndDate InsurPlcyDeductibleEndDate Deductible End
InsurPlcyDeductibleTemplate InsurPlcyDeductibleTemplate Deductible Template
InsurPlcyTemplateLongName
InsurPlcyDeductibleCurrency InsurPlcyDeductibleCurrency Currency
InsurPlcyDeductibleAmountUnit InsurPlcyDeductibleAmountUnit Deductible Cat.
InsurPlcyDeductibleValue InsurPlcyDeductibleValue Ded. Percentage
LastChangeDateTime LastChangeDateTime Timestamp
InsrrIDByInsrr
InsurPlcyAuthznSlsProductGroup
_Currency _Currency
_InsurancePolicyContrCoverage _InsurancePolicyContrCoverage
_InsurPlcyDcblAmountUnit _InsurPlcyDcblAmountUnit
_InsurPlcyDeductibleCategory _InsurPlcyDeductibleCategory
_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 C_InsurPlcyDeductible.
-- 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 C_InsurPlcyDeductible AS
SELECT
  InsurPlcyUUID,
  InsurPlcyInsurContr,
  InsurPlcyCoveragePackageID,
  InsurPlcyCoverageID,
  InsurPlcyInsuredObjectID,
  InsurPlcySubCvrgID,
  InsurPlcyDeductibleID,
  InsurPlcyJrnlNmbr,
  InsurPlcyJrnlEndNmbr,
  InsurPlcyProductPackageID,
  InsurPlcyDeductibleCategory,
  _InsurPlcyDeductibleCategory._Text[Language=$session.system_language].InsurPlcyDcblCategoryName AS InsurPlcyDcblCategoryName,
  InsurPlcyDeductibleAmount,
  InsurPlcyDeductibleStartDate,
  InsurPlcyDeductibleEndDate,
  InsurPlcyDeductibleTemplate,
  _InsurPlcyTemplateT [Language = $session.system_language].InsurPlcyTemplateLongName AS InsurPlcyTemplateLongName,
  InsurPlcyDeductibleCurrency,
  InsurPlcyDeductibleAmountUnit,
  InsurPlcyDeductibleValue,
  LastChangeDateTime,
  _InsurancePolicyContrCoverage._InsuranceContract._InsurancePolicy.InsrrIDByInsrr AS InsrrIDByInsrr,
  _InsurancePolicyContrCoverage._InsuranceContract._InsurancePolicy.InsurPlcyAuthznSlsProductGroup AS InsurPlcyAuthznSlsProductGroup
FROM I_InsurPlcyContrCvrgDeductible
;

Learn More