I_InsurPolicyInquiryContract

DDL: I_INSURPOLICYINQUIRYCONTRACT Type: view_entity COMPOSITE

Contract

I_InsurPolicyInquiryContract is a Composite CDS View that provides data about "Contract" in SAP S/4HANA. It reads from 1 data source (I_InsuranceContract) and exposes 65 fields with key fields InsurPlcyUUID, InsurPlcyInsurContr. It has 3 associations to related views.

1 data source(s) 65 fields

Data Sources (1)

SourceAliasJoin Type
I_InsuranceContract I_InsuranceContract from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_InsurClmVehicleMfrTxt _InsurClmVehicleMfrTxt $projection.InsurPlcyInsrblVehIntlMfrID = _InsurClmVehicleMfrTxt.InsurClmVehicleMfr and _InsurClmVehicleMfrTxt.InsurClmVehicleCat = 'AU'
[0..*] I_BusinessPartnerBank _BusinessPartnerBank $projection.InsurPlcyPremiumPayerID = _BusinessPartnerBank.BusinessPartner and $projection.BankIdentification = _BusinessPartnerBank.BankIdentification
[0..*] I_Paymentcard _Paymentcard $projection.InsurPlcyPremiumPayerID = _Paymentcard.BusinessPartner and $projection.PaymentCardID = _Paymentcard.PaymentCardID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Contract view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY InsurPlcyUUID InsurPlcyUUID
KEY InsurPlcyInsurContr InsurPlcyInsurContr
InsuranceContract InsuranceContract
InsurPlcyCumltvContract
InsurPlcyJrnlNmbr InsurPlcyJrnlNmbr
InsurPlcyJrnlEndNmbr InsurPlcyJrnlEndNmbr
InsurPlcyProductPackageID InsurPlcyProductPackageID
InsrrIDByInsrr InsrrIDByInsrr
InsurPlcyProductTemplate InsurPlcyProductTemplate
InsurPlcyTemplateLongName
InsurPlcyLineOfBusiness InsurPlcyLineOfBusiness
InsurPlcyContractStartDateTime InsurPlcyContractStartDateTime
InsurPlcyContractEndDateTime InsurPlcyContractEndDateTime
InsurContrLifeCycSts InsurContrLifeCycSts
InsurContrLifeCycStsName
InsurPlcyPremiumCurrency InsurPlcyPremiumCurrency
InsurPlcyTotAnnPremAmt InsurPlcyTotAnnPremAmt
InsurPlcyPerdPremBfrTxPaytAmt InsurPlcyPerdPremBfrTxPaytAmt
InsurPlcyMainDueDayMonth InsurPlcyMainDueDayMonth
InsurPlcyInsrblVehIntlMfrID
InsurPlcyInsrblVehIntlMfrName
InsurPlcyInsrblVehIntlTypeID
InsurPlcyInsrblVehIntlTypeName
InsurPlcyInsrblVehMfgYear
InsurPlcyInsrblVehUsgeOfVeh
InsurPlcyVehUsgeOfVehName
InsurPlcyInsrblVehIdnNumber
InsurPlcyInsrblVehLicPltNumber
InsurPlcyInsrdVehCurrency
InsurPlcyInsrdVehMnlListPrice
InsurPlcyInsrdVehYrlyMlgeQty
InsurPlcyInsrdVehYrlyMlgeUnit
InsurPlcyInsuredObjectCategory
InsurPlcyInsrdObjSubCategory
InsurPremSpecPaytRcrrcFrqcy InsurPremSpecPaytRcrrcFrqcy
InsurPremPaytRcrrcFrqcyName
CAPaymentMethod _InsurancePolicyPremPayer CAPaymentMethod
CAPaymentMethodName
InsurPlcyPremiumPayerID _InsurancePolicyPremPayer InsurPlcyPremiumPayerID
SEPAMandate _InsurancePolicyPremPayer SEPAMandate
BankIdentification _InsurancePolicyPremPayer BankIdentification
PaymentCardID _InsurancePolicyPremPayer PaymentCardID
InsurPlcyCollectionType
InsurPlcyCollTypeDescName
InsurPlcyChartColorCode
InsurPlcyColumnChartColorCode
_Currency _Currency
_InsurancePolicy _InsurancePolicy
_InsurancePolicyContrClause _InsurancePolicyContrClause
_InsurancePolicyContrCoverage _InsurancePolicyContrCoverage
_InsurancePolicyContrLimit _InsurancePolicyContrLimit
_InsurancePolicyPremPayer _InsurancePolicyPremPayer
_InsurContrLifeCycleStatus _InsurContrLifeCycleStatus
_InsurPlcyContrInsuredObject _InsurPlcyContrInsuredObject
_InsurPlcyContrSurchrgDisc _InsurPlcyContrSurchrgDisc
_InsurPlcyCoveragePackage _InsurPlcyCoveragePackage
_InsurPlcyInsurer _InsurPlcyInsurer
_InsurPlcyLineOfBusiness _InsurPlcyLineOfBusiness
_InsurPlcyTemplateT _InsurPlcyTemplateT
_InsurPolicyContrDeductible _InsurPolicyContrDeductible
_InsurPolicyProductTemplate _InsurPolicyProductTemplate
_InsurPremPaytRcrrcFrqcy _InsurPremPaytRcrrcFrqcy
_BusinessPartnerBank _BusinessPartnerBank
_Paymentcard _Paymentcard
_InsurClmVehicleMfrTxt _InsurClmVehicleMfrTxt 
@AbapCatalog.viewEnhancementCategory    : [#NONE]
@AccessControl.authorizationCheck       : #CHECK
@EndUserText.label                      : 'Contract'
@VDM.viewType                           : #COMPOSITE
@Metadata.ignorePropagatedAnnotations   : true
@ObjectModel.usageType                  : {
  serviceQuality                        : #C,
  sizeCategory                          : #XXL,
  dataClass                             : #TRANSACTIONAL }

define view entity I_InsurPolicyInquiryContract
  as select from I_InsuranceContract
  association [0..1] to I_InsurClmVehicleMfrTxt as _InsurClmVehicleMfrTxt on  $projection.InsurPlcyInsrblVehIntlMfrID   = _InsurClmVehicleMfrTxt.InsurClmVehicleMfr
                                                                          and _InsurClmVehicleMfrTxt.InsurClmVehicleCat = 'AU'
  association [0..*] to I_BusinessPartnerBank   as _BusinessPartnerBank   on  $projection.InsurPlcyPremiumPayerID = _BusinessPartnerBank.BusinessPartner
                                                                          and $projection.BankIdentification      = _BusinessPartnerBank.BankIdentification
  association [0..*] to I_Paymentcard           as _Paymentcard           on  $projection.InsurPlcyPremiumPayerID = _Paymentcard.BusinessPartner
                                                                          and $projection.PaymentCardID           = _Paymentcard.PaymentCardID
{
  key InsurPlcyUUID,
  key InsurPlcyInsurContr,
      InsuranceContract                                                                                                                                                              as InsuranceContract,
      cast( concat('*', (substring (InsuranceContract,14,20))) as /pm0/abt_pol_inq_contract_num )                                                                                    as InsurPlcyCumltvContract,

      InsurPlcyJrnlNmbr,
      InsurPlcyJrnlEndNmbr,
      InsurPlcyProductPackageID,
      InsrrIDByInsrr,

      InsurPlcyProductTemplate                                                                                                                                                       as InsurPlcyProductTemplate,
      _InsurPlcyTemplateT[Language = $session.system_language].InsurPlcyTemplateLongName                                                                                             as InsurPlcyTemplateLongName,
      InsurPlcyLineOfBusiness,
      @Semantics.dateTime:true
      InsurPlcyContractStartDateTime                                                                                                                                                 as InsurPlcyContractStartDateTime,
      @Semantics.dateTime:true
      InsurPlcyContractEndDateTime                                                                                                                                                   as InsurPlcyContractEndDateTime,
      InsurContrLifeCycSts                                                                                                                                                           as InsurContrLifeCycSts,
      _InsurContrLifeCycleStatus._Text[Language = $session.system_language].InsurContrLifeCycStsName                                                                                 as InsurContrLifeCycStsName,
      case
      when InsurContrLifeCycSts = '001' then 3
      else 1
      end                                                                                                                                                                            as InsurContrStatusColorCode,


      InsurPlcyPremiumCurrency                                                                                                                                                       as InsurPlcyPremiumCurrency,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      InsurPlcyTotAnnPremAmt                                                                                                                                                         as InsurPlcyTotAnnPremAmt,
      @Semantics.amount.currencyCode: 'InsurPlcyPremiumCurrency'
      InsurPlcyPerdPremBfrTxPaytAmt                                                                                                                                                  as InsurPlcyPerdPremBfrTxPaytAmt,
      InsurPlcyMainDueDayMonth,

      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle.InsurPlcyInsrblVehIntlMfrID                                                                       as InsurPlcyInsrblVehIntlMfrID,
      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle._InsurPlcyInsrblVehIntlMfr.InsurPlcyInsrblVehIntlMfrName                                          as InsurPlcyInsrblVehIntlMfrName,
      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle.InsurPlcyInsrblVehIntlTypeID                                                                      as InsurPlcyInsrblVehIntlTypeID,
      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle._InsurPlcyVehIntlTypeLink.InsurPlcyInsrblVehIntlTypeName                                          as InsurPlcyInsrblVehIntlTypeName,

      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle.InsurPlcyInsrblVehMfgYear                                                                         as InsurPlcyInsrblVehMfgYear,

      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle.InsurPlcyInsrblVehUsgeOfVeh                                                                       as InsurPlcyInsrblVehUsgeOfVeh,
      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle._InsurPlcyInsrblVehUsgeOfVeh._Text[Language = $session.system_language].InsurPlcyVehUsgeOfVehName as InsurPlcyVehUsgeOfVehName,

      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle.InsurPlcyInsrblVehIdnNumber                                                                       as InsurPlcyInsrblVehIdnNumber,
      _InsurPlcyContrInsuredObject._InsurInsurableObject._InsurInsrblObjectVehicle.InsurPlcyInsrblVehLicPltNumber                                                                    as InsurPlcyInsrblVehLicPltNumber,

      _InsurPlcyContrInsuredObject._InsurPlcyContrInsuredVehicle.InsurPlcyInsrdVehCurrency                                                                                           as InsurPlcyInsrdVehCurrency,
      @Semantics.amount.currencyCode: 'InsurPlcyInsrdVehCurrency'
      _InsurPlcyContrInsuredObject._InsurPlcyContrInsuredVehicle.InsurPlcyInsrdVehMnlListPrice                                                                                       as InsurPlcyInsrdVehMnlListPrice,

      @Semantics.quantity.unitOfMeasure: 'InsurPlcyInsrdVehYrlyMlgeUnit'
      _InsurPlcyContrInsuredObject._InsurPlcyContrInsuredVehicle.InsurPlcyInsrdVehYrlyMlgeQty                                                                                        as InsurPlcyInsrdVehYrlyMlgeQty,
      _InsurPlcyContrInsuredObject._InsurPlcyContrInsuredVehicle.InsurPlcyInsrdVehYrlyMlgeUnit                                                                                       as InsurPlcyInsrdVehYrlyMlgeUnit,

      _InsurPlcyContrInsuredObject._InsurInsrdObjectCategory.InsurPlcyInsuredObjectCategory                                                                                            as InsurPlcyInsuredObjectCategory,
      _InsurPlcyContrInsuredObject._InsurInsrdObjSubCategory.InsurPlcyInsrdObjSubCategory                                                                                                as InsurPlcyInsrdObjSubCategory,
      concat_with_space(
      _InsurPlcyContrInsuredObject._InsurInsrdObjectCategory._Text[Language = $session.system_language].InsurPlcyInsrdObjCategoryName,
      _InsurPlcyContrInsuredObject._InsurInsrdObjSubCategory._Text[Language = $session.system_language].InsurPlcyInsrdObjSubCatName,
      1 )                                                                                                                                                                            as InsurInsrblObjName,

      InsurPremSpecPaytRcrrcFrqcy                                                                                                                                                    as InsurPremSpecPaytRcrrcFrqcy,
      _InsurPremPaytRcrrcFrqcy._Text[Language = $session.system_language].InsurPremPaytRcrrcFrqcyName                                                                                as InsurPremPaytRcrrcFrqcyName,

      _InsurancePolicyPremPayer.CAPaymentMethod                                                                                                                                      as CAPaymentMethod,
      _InsurancePolicyPremPayer._CAPaymentMethodText[Language = $session.system_language].CAPaymentMethodName                                                                        as CAPaymentMethodName,

      _InsurancePolicyPremPayer.InsurPlcyPremiumPayerID                                                                                                                              as InsurPlcyPremiumPayerID,
      _InsurancePolicyPremPayer.SEPAMandate                                                                                                                                          as SEPAMandate,
      _InsurancePolicyPremPayer.BankIdentification                                                                                                                                   as BankIdentification,
      _InsurancePolicyPremPayer.PaymentCardID                                                                                                                                        as PaymentCardID,
      _InsurancePolicyPremPayer._InsurPlcyCollectionType.InsurPlcyCollectionType                                                                                                     as InsurPlcyCollectionType,
      _InsurancePolicyPremPayer._InsurPlcyCollectionType._Text[Language = $session.system_language].InsurPlcyCollTypeDescName                                                        as InsurPlcyCollTypeDescName,

      //Pie Chart Color code

      cast( '3' as abap.int1 )                                                                                                                                                       as InsurPlcyChartColorCode,
      //Column Chart Color code

      cast( '0' as abap.int4 )                                                                                                                                                       as InsurPlcyColumnChartColorCode,

      /* Associations */
      _Currency,
      _InsurancePolicy,
      _InsurancePolicyContrClause,
      _InsurancePolicyContrCoverage,
      _InsurancePolicyContrLimit,
      _InsurancePolicyPremPayer,
      _InsurContrLifeCycleStatus,
      _InsurPlcyContrInsuredObject,
      _InsurPlcyContrSurchrgDisc,
      _InsurPlcyCoveragePackage,
      _InsurPlcyInsurer,
      _InsurPlcyLineOfBusiness,
      _InsurPlcyTemplateT,
      _InsurPolicyContrDeductible,
      _InsurPolicyProductTemplate,
      _InsurPremPaytRcrrcFrqcy,

      /* Associations */
      _BusinessPartnerBank,
      _Paymentcard,
      _InsurClmVehicleMfrTxt
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAPAYMENTMETHODTEXT",
"I_INSURANCECONTRACT",
"I_INSURANCEPOLICYPREMPAYER",
"I_INSURCONTRLIFECYCLESTATUS",
"I_INSURCONTRLIFECYCLESTATUST",
"I_INSURINSRBLOBJECTVEHICLE",
"I_INSURINSRDOBJECTCATEGORY",
"I_INSURINSRDOBJECTCATEGORYT",
"I_INSURINSRDOBJSUBCATEGORY",
"I_INSURINSRDOBJSUBCATEGORYT",
"I_INSURINSURABLEOBJECT",
"I_INSURPLCYCOLLECTIONTYPE",
"I_INSURPLCYCOLLECTIONTYPET",
"I_INSURPLCYCONTRINSUREDOBJECT",
"I_INSURPLCYCONTRINSUREDVEHICLE",
"I_INSURPLCYINSRBLVEHINTLMFR",
"I_INSURPLCYINSRBLVEHUSGEOFVEH",
"I_INSURPLCYINSRBLVEHUSGEOFVEHT",
"I_INSURPLCYTEMPLATET",
"I_INSURPLCYVEHINTLTYPELINK",
"I_INSURPREMPAYTRCRRCFRQCY",
"I_INSURPREMPAYTRCRRCFRQCYT"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNERBANK",
"I_CURRENCY",
"I_INSURANCEPOLICY",
"I_INSURANCEPOLICYCONTRCLAUSE",
"I_INSURANCEPOLICYCONTRCOVERAGE",
"I_INSURANCEPOLICYCONTRLIMIT",
"I_INSURANCEPOLICYPREMPAYER",
"I_INSURCLMVEHICLEMFRTXT",
"I_INSURCONTRLIFECYCLESTATUS",
"I_INSURPLCYCONTRINSUREDOBJECT",
"I_INSURPLCYCONTRSURCHRGDISC",
"I_INSURPLCYCOVERAGEPACKAGE",
"I_INSURPLCYINSURER",
"I_INSURPLCYLINEOFBUSINESS",
"I_INSURPLCYTEMPLATET",
"I_INSURPOLICYCONTRDEDUCTIBLE",
"I_INSURPOLICYPRODUCTTEMPLATE",
"I_INSURPREMPAYTRCRRCFRQCY",
"I_PAYMENTCARD"
],
"BASE":
[
"I_INSURANCECONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More