R_INSURPLCYAGENTTP

CDS View

Agent

R_INSURPLCYAGENTTP is a CDS View in S/4HANA. Agent. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_InsurancePolicyAgent view_entity projection CONSUMPTION Agent under Policy
A_InsurOpenApplicationAgent view_entity projection CONSUMPTION Agent under Policy 
@EndUserText.label: 'Agent'
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@AccessControl: {
authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   semanticKey: [ 'InsurancePolicyAgentIdentifier' ],
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}

@ObjectModel.sapObjectNodeType.name: 'InsurancePolicy'
@AbapCatalog.extensibility: {
  extensible: true,
  elementSuffix: 'AGT',
  allowNewDatasources: false,
  allowNewCompositions: true,
  dataSources: [ '_Extension' ],
  quota: {
    maximumFields: 250,
    maximumBytes: 2500
  }
}
define view entity R_InsurPlcyAgentTP
  as select from I_InsurPlcyAgentBasic

  association        to parent R_InsurancePolicyTP_2 as _Policy    on  $projection.InsurPlcyUUID = _Policy.InsurPlcyUUID

  association [1..1] to I_BusinessPartner      as _BusinessPartner on  $projection.InsurancePolicyAgentPartner = _BusinessPartner.BusinessPartner
  association [0..1] to I_Address_2            as _Address         on  $projection.InsurPlcyAgentAddrNmbr = _Address.AddressID

  association [1..1] to E_InsurancePolicyAgent as _Extension       on  $projection.InsurancePolicyAgentIdentifier = _Extension.InsurancePolicyAgentIdentifier
                                                                   and $projection.InsurPlcyUUID                  = _Extension.InsurPlcyUUID
                                                                   and $projection.InsurPlcyInsurContr            = _Extension.InsurPlcyInsurContr
                                                                   and $projection.InsurPlcyJrnlEndNmbr           = _Extension.InsurPlcyJrnlEndNmbr
                                                                   and $projection.InsurPlcyJrnlNmbr              = _Extension.InsurPlcyJrnlNmbr

{
  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
  key InsurancePolicyAgentIdentifier,
      InsurPlcyJrnlEndNmbr,
      InsurPlcyJrnlNmbr,
      InsurPlcyProductPackageID,
      InsurPlcyAgentIsCanceled,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyRepresentativeType'
      InsurPlcyRprstvType,
      @ObjectModel.sapObjectNodeTypeReference: 'InsurPlcyRepresentativeScope'
      InsurPlcyScopeAgent,
      InsurancePolicyAgentPartner,
      InsurPlcyAgentAddrNmbr,
      InsurPlcyAgentTemplate,
      InsurPlcyBusinessObject,
      LastChangeDateTime,

      /*Associations*/
      _BusinessPartner,
      _Address,
      _Policy

}
where
  InsurPlcyInsurContr = 0
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURPLCYAGENTBASIC"
],
"ASSOCIATED":
[
"I_ADDRESS_2",
"I_BUSINESSPARTNER",
"R_INSURANCEPOLICYTP_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More