R_InsurPlcyAgentTP

DDL: R_INSURPLCYAGENTTP Type: view_entity TRANSACTIONAL

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 17 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr, InsurancePolicyAgentIdentifier. It has 3 associations to related views.

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 (14)

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
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix AGT view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view
AbapCatalog.extensibility.quota.maximumFields 250 view
AbapCatalog.extensibility.quota.maximumBytes 2500 view

Fields (17)

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
_Policy _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":""
}
}*/