R_InsurPlcyContrSurchrgDiscTP

DDL: R_INSURPLCYCONTRSURCHRGDISCTP Type: view_entity TRANSACTIONAL

Contr Surchrg Disc in Insur Plcy - TP

R_InsurPlcyContrSurchrgDiscTP is a Transactional CDS View that provides data about "Contr Surchrg Disc in Insur Plcy - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyContrSurchrgDisc) and exposes 17 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurPlcySurchargeDiscID. It has 1 association to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyContrSurchrgDisc SurchargeDiscount from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurPolicySurchargeDiscount _Extension $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and 0 = _Extension.InsurPlcyCoveragePackageID and 0 = _Extension.InsurPlcyCoverageID and 0 = _Extension.InsurPlcyInsuredObjectID and $projection.InsurPlcySurchargeDiscID = _Extension.InsurPlcySurchargeDiscID and 0 = _Extension.InsurPlcyCoverageOptionID and 0 = _Extension.InsurPlcyUndrwrtgDcsnRiskID and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr

Annotations (8)

NameValueLevelField
EndUserText.label Contr Surchrg Disc in Insur Plcy - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey InsurPlcySurchargeDiscID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID I_InsurPlcyContrSurchrgDisc InsurPlcyUUID
KEY InsurPlcyInsurContr I_InsurPlcyContrSurchrgDisc InsurPlcyInsurContr
KEY InsurPlcySurchargeDiscID I_InsurPlcyContrSurchrgDisc InsurPlcySurchargeDiscID
InsurPlcyJrnlNmbr I_InsurPlcyContrSurchrgDisc InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr I_InsurPlcyContrSurchrgDisc InsurPlcyJrnlEndNmbr
InsurPolicyContractPackageID I_InsurPlcyContrSurchrgDisc InsurPlcyProductPackageID
InsurPlcySurchrgDiscControl I_InsurPlcyContrSurchrgDisc InsurPlcySurchrgDiscTemplate
InsurPlcySurchargeDiscStrtDate I_InsurPlcyContrSurchrgDisc InsurPlcySurchargeDiscStrtDate
InsurPlcySurchargeDiscEndDate I_InsurPlcyContrSurchrgDisc InsurPlcySurchargeDiscEndDate
InsurPlcySurchrgDiscBaseAmtPct I_InsurPlcyContrSurchrgDisc InsurPlcySurchrgDiscBaseAmtPct
InsurPlcySurchargeDiscAmount I_InsurPlcyContrSurchrgDisc InsurPlcySurchargeDiscAmount
InsurPlcySurchrgDiscAmtType I_InsurPlcyContrSurchrgDisc InsurPlcySurchrgDiscAmtType
InsurPlcySurchrgDiscAmtUnit I_InsurPlcyContrSurchrgDisc InsurPlcySurchrgDiscAmtUnit
InsurPlcySurchargeDiscountType I_InsurPlcyContrSurchrgDisc InsurPlcySurchargeDiscTypeID
InsurPlcySurchrgDiscCurrency I_InsurPlcyContrSurchrgDisc InsurPlcySurchrgDiscCurrency
LastChangeDateTime I_InsurPlcyContrSurchrgDisc LastChangeDateTime
_InsuranceContract _InsuranceContract 
@EndUserText.label: 'Contr Surchrg Disc in Insur Plcy - TP'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'InsurPlcySurchargeDiscID',
   semanticKey: [ 'InsurPlcySurchargeDiscID' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

define view entity R_InsurPlcyContrSurchrgDiscTP
  as select from I_InsurPlcyContrSurchrgDisc as SurchargeDiscount

  association        to parent R_InsuranceContractTP   as _InsuranceContract on  $projection.InsurPlcyUUID       = _InsuranceContract.InsurPlcyUUID
                                                                             and $projection.InsurPlcyInsurContr = _InsuranceContract.InsurPlcyInsurContr

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

{

  key SurchargeDiscount.InsurPlcyUUID,
  key SurchargeDiscount.InsurPlcyInsurContr,
  key SurchargeDiscount.InsurPlcySurchargeDiscID,
      SurchargeDiscount.InsurPlcyJrnlNmbr,
      SurchargeDiscount.InsurPlcyJrnlEndNmbr,
      SurchargeDiscount.InsurPlcyProductPackageID    as InsurPolicyContractPackageID,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurancePolicyTemplate'
      SurchargeDiscount.InsurPlcySurchrgDiscTemplate as InsurPlcySurchrgDiscControl,
      SurchargeDiscount.InsurPlcySurchargeDiscStrtDate,
      SurchargeDiscount.InsurPlcySurchargeDiscEndDate,
      SurchargeDiscount.InsurPlcySurchrgDiscBaseAmtPct,
      SurchargeDiscount.InsurPlcySurchargeDiscAmount,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcySurchrgDiscAmountType'
      SurchargeDiscount.InsurPlcySurchrgDiscAmtType,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcySurchrgDiscAmtUnit'
      SurchargeDiscount.InsurPlcySurchrgDiscAmtUnit,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcySurchargeDiscountType'
      SurchargeDiscount.InsurPlcySurchargeDiscTypeID as InsurPlcySurchargeDiscountType,
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      SurchargeDiscount.InsurPlcySurchrgDiscCurrency,
      SurchargeDiscount.LastChangeDateTime,

      /* Associations */
      _InsuranceContract

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYCONTRSURCHRGDISC"
],
"ASSOCIATED":
[
"R_INSURANCECONTRACTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More