R_InsuranceContractTP

DDL: R_INSURANCECONTRACTTP Type: view_entity TRANSACTIONAL
45 Fields 1 Data Sources 11 Associations

Contract in Insur Policy - TP

R_InsuranceContractTP is a Transactional CDS View that provides data about "Contract in Insur Policy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsuranceContract) and exposes 45 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr. It has 11 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsuranceContract I_InsuranceContract from

Associations (11)

CardinalityTargetAliasCondition
[1..1] E_InsuranceContract _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr
[1..1] E_InsurancePolicyPremium _Extension_Prem $projection.InsurPlcyUUID = _Extension_Prem.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension_Prem.InsurPlcyInsurContr and 0 = _Extension_Prem.InsurPlcyCoveragePackageID and 0 = _Extension_Prem.InsurPlcyCoverageID and 0 = _Extension_Prem.InsurPlcyCoverageOptionID and 0 = _Extension_Prem.InsurPlcyInsuredObjectID and $projection.InsurancePolicyPremium = _Extension_Prem.InsurancePolicyPremium and $projection.InsurPlcyPremiumJournalNumber = _Extension_Prem.InsurPlcyJrnlNmbr and $projection.InsurPlcyPremJournalEndNumber = _Extension_Prem.InsurPlcyJrnlEndNmbr
[1..*] R_InsurPolicyContrCoverageTP _InsurancePolicyContrCoverage
[0..*] R_InsurPlcyCoveragePackageTP _InsurPlcyCoveragePackage
[0..*] R_InsurancePolicyContrLimitTP _InsurancePolicyContrLimit
[0..*] R_InsurancePolicyContrClauseTP _InsurancePolicyContrClause
[0..*] R_InsurPlcyContrSurchrgDiscTP _InsurPlcyContrSurchrgDisc
[1..*] R_InsurancePolicyPremPayerTP _InsurancePolicyPremPayer
[0..*] R_InsurPolicyContrDeductibleTP _InsurPolicyContrDeductible
[0..*] R_InsurPlcyContrInsrdObjectTP _InsurPlcyContrInsuredObject
[0..*] R_InsurContrPlndProcessingTP _InsurContrPlndProcg

Annotations (8)

NameValueLevelField
EndUserText.label Contract in Insur Policy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcyInsurContr view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID Policy UUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr Contract Key
InsurPolicyContractPackageID InsurPlcyProductPackageID Prod. Pckg. Key
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr Journal Number
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr Term. Jour. No.
InsuranceContract InsuranceContract Contract
InsuranceContractControl InsurPlcyProductTemplate Product
InsurPlcyLineOfBusiness InsurPlcyLineOfBusiness LoB Name
InsurPlcyContractStartDateTime InsurPlcyContractStartDateTime Contract Start
InsurPlcyContractEndDateTime InsurPlcyContractEndDateTime Contract End
InsrrIDByInsrr InsrrIDByInsrr Company ID
InsurContrLifeCycSts InsurContrLifeCycSts
InsurContrTrifVar InsurContrTrifVar
InsurCollDisbmtInsurObj InsurCollDisbmtInsurObj
InsurContrRnwlType InsurContrRnwlType
InsurContrCanclnRsn InsurContrCanclnRsn
InsurPlcyContrCanclnDateTime InsurPlcyContrCanclnDateTime Contract Reversal Date/Time
InsurApplRjcnRsn InsurApplRjcnRsn
InsurApplLifeCycSts InsurApplLifeCycSts Policy Status
InsurPlcyCountry InsurPlcyCountry Country/Reg.
InsurancePolicyPremium InsurancePolicyPremium Premium ID
InsurPlcyPremiumJournalNumber InsurPlcyPremiumJournalNumber Journal Number
InsurPlcyPremJournalEndNumber InsurPlcyPremJournalEndNumber Term. Jour. No.
InsurPremSpecPaytRcrrcFrqcy InsurPremSpecPaytRcrrcFrqcy Payment Frequency
InsurPerdPremBfrTaxPaytAmt InsurPerdPremBfrTaxPaytAmt Prem. Bef. Tax
InsurPerdPremAftTaxPaytAmt InsurPerdPremAftTaxPaytAmt Prem. After Tax
InsurPremType InsurPremType Premium Type
InsurContrIsPremExempt InsurContrIsPremExempt Premium Exempt
InsurContrPremExmpEndDte InsurContrPremExmpEndDte PremExmptEndDte
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency Currency
InsurPlcyTotAnnPremAmt InsurPlcyTotAnnPremAmt AnnPremAfterTax
InsurPlcyPerdPremBfrTxPaytAmt InsurPlcyPerdPremBfrTxPaytAmt DelAPremBef.Tax
InsurPlcyMainDueDayMonth InsurPlcyMainDueDayMonth Main Due Date
InsurancePolicyPremiumControl InsurPlcyPremiumTemplate Premium Type
LastChangeDateTime LastChangeDateTime Timestamp
_InsurancePolicy _InsurancePolicy
_InsurPlcyCoveragePackage _InsurPlcyCoveragePackage
_InsurancePolicyPremPayer _InsurancePolicyPremPayer
_InsurancePolicyContrLimit _InsurancePolicyContrLimit
_InsurancePolicyContrClause _InsurancePolicyContrClause
_InsurPlcyContrSurchrgDisc _InsurPlcyContrSurchrgDisc
_InsurPolicyContrDeductible _InsurPolicyContrDeductible
_InsurPlcyContrInsuredObject _InsurPlcyContrInsuredObject
_InsurancePolicyContrCoverage _InsurancePolicyContrCoverage
_InsurContrPlndProcg _InsurContrPlndProcg

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 R_InsuranceContractTP.
-- 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 R_InsuranceContractTP AS
SELECT
  InsurPlcyUUID,
  InsurPlcyInsurContr,
  InsurPlcyProductPackageID AS InsurPolicyContractPackageID,
  InsurPlcyJrnlNmbr,
  InsurPlcyJrnlEndNmbr,
  InsuranceContract,
  InsurPlcyProductTemplate AS InsuranceContractControl,
  InsurPlcyLineOfBusiness,
  InsurPlcyContractStartDateTime,
  InsurPlcyContractEndDateTime,
  InsrrIDByInsrr,
  InsurContrLifeCycSts,
  InsurContrTrifVar,
  InsurCollDisbmtInsurObj,
  InsurContrRnwlType,
  InsurContrCanclnRsn,
  InsurPlcyContrCanclnDateTime,
  InsurApplRjcnRsn,
  InsurApplLifeCycSts,
  InsurPlcyCountry,
  InsurancePolicyPremium,
  InsurPlcyPremiumJournalNumber,
  InsurPlcyPremJournalEndNumber,
  InsurPremSpecPaytRcrrcFrqcy,
  InsurPerdPremBfrTaxPaytAmt,
  InsurPerdPremAftTaxPaytAmt,
  InsurPremType,
  InsurContrIsPremExempt,
  InsurContrPremExmpEndDte,
  InsurPlcyPremiumCurrency,
  InsurPlcyTotAnnPremAmt,
  InsurPlcyPerdPremBfrTxPaytAmt,
  InsurPlcyMainDueDayMonth,
  InsurPlcyPremiumTemplate AS InsurancePolicyPremiumControl,
  LastChangeDateTime
FROM I_InsuranceContract
LEFT OUTER JOIN E_InsuranceContract AS _Extension ON InsurPlcyUUID = _Extension.InsurPlcyUUID AND InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr AND InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr AND InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr  -- association [1..1]
LEFT OUTER JOIN E_InsurancePolicyPremium AS _Extension_Prem ON InsurPlcyUUID = _Extension_Prem.InsurPlcyUUID AND InsurPlcyInsurContr = _Extension_Prem.InsurPlcyInsurContr AND 0 = _Extension_Prem.InsurPlcyCoveragePackageID AND 0 = _Extension_Prem.InsurPlcyCoverageID AND 0 = _Extension_Prem.InsurPlcyCoverageOptionID AND 0 = _Extension_Prem.InsurPlcyInsuredObjectID AND InsurancePolicyPremium = _Extension_Prem.InsurancePolicyPremium AND InsurPlcyPremiumJournalNumber = _Extension_Prem.InsurPlcyJrnlNmbr AND InsurPlcyPremJournalEndNumber = _Extension_Prem.InsurPlcyJrnlEndNmbr  -- association [1..1]
LEFT OUTER JOIN R_InsurPolicyContrCoverageTP AS _InsurancePolicyContrCoverage ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_InsurPlcyCoveragePackageTP AS _InsurPlcyCoveragePackage ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyContrLimitTP AS _InsurancePolicyContrLimit ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyContrClauseTP AS _InsurancePolicyContrClause ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrSurchrgDiscTP AS _InsurPlcyContrSurchrgDisc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurancePolicyPremPayerTP AS _InsurancePolicyPremPayer ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN R_InsurPolicyContrDeductibleTP AS _InsurPolicyContrDeductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurPlcyContrInsrdObjectTP AS _InsurPlcyContrInsuredObject ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_InsurContrPlndProcessingTP AS _InsurContrPlndProcg ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More