R_INSURANCEPOLICYCVRGCLAUSETP

CDS View

Cvrg Clause of Cvrg Pckg in Plcy - TP

R_INSURANCEPOLICYCVRGCLAUSETP is a CDS View in S/4HANA. Cvrg Clause of Cvrg Pckg in Plcy - TP. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_InsurancePolicyCvrgClause view_entity projection CONSUMPTION Coverage Clause of Coverage Package
@EndUserText.label: 'Cvrg Clause of Cvrg Pckg in Plcy - TP'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcyClauseID',
   semanticKey: [ 'InsurPlcyClauseID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #D,
     sizeCategory:   #XL
   }
}
@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'CLS',
  allowNewDatasources: false,
  allowNewCompositions: true,
  dataSources: [ '_Extension' ],
  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}
define view entity R_InsurancePolicyCvrgClauseTP
  as select from I_InsurancePolicyCvrgClause as Clause

  association        to parent R_InsurancePolicyCoverageTP as _InsurancePolicyCoverage on  $projection.InsurPlcyUUID              = _InsurancePolicyCoverage.InsurPlcyUUID
                                                                                       and $projection.InsurPlcyInsurContr        = _InsurancePolicyCoverage.InsurPlcyInsurContr
                                                                                       and $projection.InsurPlcyCoveragePackageID = _InsurancePolicyCoverage.InsurPlcyCoveragePackageID
                                                                                       and $projection.InsurPlcyCoverageID        = _InsurancePolicyCoverage.InsurPlcyCoverageID

  association [1..1] to E_InsurancePolicyClause            as _Extension               on  $projection.InsurPlcyUUID              = _Extension.InsurPlcyUUID
                                                                                       and $projection.InsurPlcyInsurContr        = _Extension.InsurPlcyInsurContr
                                                                                       and $projection.InsurPlcyCoveragePackageID = _Extension.InsurPlcyCoveragePackageID
                                                                                       and $projection.InsurPlcyCoverageID        = _Extension.InsurPlcyCoverageID
                                                                                       and 0                                      = _Extension.InsurPlcySubCvrgID
                                                                                       and 0                                      = _Extension.InsurPlcyInsuredObjectID
                                                                                       and $projection.InsurPlcyClauseID          = _Extension.InsurPlcyClauseID
                                                                                       and 0                                      = _Extension.InsurPlcyCoverageOptionID
                                                                                       and 0                                      = _Extension.InsurPlcyUndrwrtgDcsnRiskID
                                                                                       and $projection.InsurPlcyJrnlNmbr          = _Extension.InsurPlcyJrnlNmbr
                                                                                       and $projection.InsurPlcyJrnlEndNmbr       = _Extension.InsurPlcyJrnlEndNmbr

{

  key Clause.InsurPlcyUUID,
  key Clause.InsurPlcyInsurContr,
  key Clause.InsurPlcyCoveragePackageID,
  key Clause.InsurPlcyCoverageID,
  key Clause.InsurPlcyClauseID,
      Clause.InsurPlcyJrnlNmbr,
      Clause.InsurPlcyJrnlEndNmbr,
      Clause.InsurPlcyProductPackageID as InsurPolicyContractPackageID,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'
      Clause.InsurPlcyClauseTemplate   as InsurancePolicyClauseControl,
      Clause.InsurPlcyIndivClauseAgrmtText,
      Clause.InsurPlcyClauseDetailTextUUID,
      Clause.LongText,
      Clause.TextObjectCategory,
      Clause.TextObjectKey,
      Clause.Language,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyClauseType'
      Clause.InsurPlcyClauseType,
      Clause.InsurPlcyClauseStartDate,
      Clause.InsurPlcyClauseEndDate,
      Clause.LastChangeDateTime,

      /* Associations */
      _InsurancePolicyCoverage

}