R_INSURPLCYCONTREXTREFTP

CDS View

External Reference under Contract

R_INSURPLCYCONTREXTREFTP is a CDS View in S/4HANA. External Reference under Contract. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_InsurPlcyContrExtReference view_entity projection CONSUMPTION External Reference under Contract 
@EndUserText.label: 'External Reference under Contract'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   semanticKey: [ 'InsurPlcyExternalReferenceID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@ObjectModel.sapObjectNodeType.name: 'InsurancePolicy'
define root view entity R_InsurPlcyContrExtRefTP
  as select from I_InsurPlcyExtReferenceBasic

  association [1..1] to E_InsurPlcyExtRef as _Extension on  $projection.InsurPlcyInsuredObjectID     = _Extension.InsurPlcyInsuredObjectID
                                                        and $projection.InsurPlcyInsurContr          = _Extension.InsurPlcyInsurContr
                                                        and $projection.InsurPlcyJrnlEndNmbr         = _Extension.InsurPlcyJrnlEndNmbr
                                                        and $projection.InsurPlcyJrnlNmbr            = _Extension.InsurPlcyJrnlNmbr
                                                        and $projection.InsurPlcyUUID                = _Extension.InsurPlcyUUID
                                                        and $projection.InsurPlcyExternalReferenceID = _Extension.InsurPlcyExternalReferenceID
                                                        and $projection.InsurPlcyCoveragePackageID   = _Extension.InsurPlcyCoveragePackageID
                                                        and $projection.InsurPlcyCoverageOptionID    = _Extension.InsurPlcyCoverageOptionID
                                                        and $projection.InsurPlcyCoverageID          = _Extension.InsurPlcyCoverageID

{

  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
  key InsurPlcyCoveragePackageID,
  key InsurPlcyCoverageID,
  key InsurPlcyCoverageOptionID,
  key InsurPlcyInsuredObjectID,
  key InsurPlcyExternalReferenceID,
      InsurPlcyJrnlEndNmbr,
      InsurPlcyJrnlNmbr,
      InsurPlcyProductPackageID,
      InsurPlcyExtRefIsCancelled,
      InsurPlcyExtRefCompany,
      InsurPlcyExtRefReferenceNumber,
      InsurPlcyExtRefReferenceType,
      InsurPlcyExtRefTemplate,
      InsurPlcyBusinessObject,
      LastChangeDateTime
}
where
      InsurPlcyCoveragePackageID = 0
  and InsurPlcyCoverageID        = 0
  and InsurPlcyCoverageOptionID  = 0
  and InsurPlcyInsuredObjectID   = 0

Learn More