R_InsurPlcyAgentTP

DDL: R_INSURPLCYAGENTTP Type: view_entity TRANSACTIONAL Package: VDM_PM_PLCY_API_COMMON

Agent

R_InsurPlcyAgentTP is a Transactional CDS View that provides data about "Agent" in SAP S/4HANA. It reads from 1 data source (I_InsurPlcyAgentBasic) and exposes 16 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurancePolicyAgentIdentifier. It has 3 associations to related views. Part of development package VDM_PM_PLCY_API_COMMON.

Data Sources (1)

SourceAliasJoin Type
I_InsurPlcyAgentBasic I_InsurPlcyAgentBasic from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.InsurancePolicyAgentPartner = _BusinessPartner.BusinessPartner
[0..1] I_Address_2 _Address $projection.InsurPlcyAgentAddrNmbr = _Address.AddressID
[1..1] E_InsurancePolicyAgent _Extension $projection.InsurancePolicyAgentIdentifier = _Extension.InsurancePolicyAgentIdentifier and $projection.InsurPlcyUUID = _Extension.InsurPlcyUUID and $projection.InsurPlcyInsurContr = _Extension.InsurPlcyInsurContr and $projection.InsurPlcyJrnlEndNmbr = _Extension.InsurPlcyJrnlEndNmbr and $projection.InsurPlcyJrnlNmbr = _Extension.InsurPlcyJrnlNmbr

Annotations (8)

NameValueLevelField
EndUserText.label Agent view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name InsurancePolicy view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr
KEY InsurancePolicyAgentIdentifier InsurancePolicyAgentIdentifier
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr
InsurPlcyProductPackageID InsurPlcyProductPackageID
InsurPlcyAgentIsCanceled InsurPlcyAgentIsCanceled
InsurPlcyRprstvType InsurPlcyRprstvType
InsurPlcyScopeAgent InsurPlcyScopeAgent
InsurancePolicyAgentPartner InsurancePolicyAgentPartner
InsurPlcyAgentAddrNmbr InsurPlcyAgentAddrNmbr
InsurPlcyAgentTemplate InsurPlcyAgentTemplate
InsurPlcyBusinessObject InsurPlcyBusinessObject
LastChangeDateTime LastChangeDateTime
_BusinessPartner _BusinessPartner
_Address _Address
@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'
define root view entity R_InsurPlcyAgentTP
  as select from I_InsurPlcyAgentBasic

  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

}
where
  InsurPlcyInsurContr = 0