I_InsurClmBPQuickView

DDL: I_INSURCLMBPQUICKVIEW SQL: IICLBPQUICKVIEW Type: view TRANSACTIONAL Package: ICL_VDM_CLAIMINQUIRY

Geschäftspartner für Fallauskunft

I_InsurClmBPQuickView is a Transactional CDS View that provides data about "Geschäftspartner für Fallauskunft" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 103 fields with key field BusinessPartner. It has 1 association to related views. Part of development package ICL_VDM_CLAIMINQUIRY.

1 data source(s) 103 fields

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner I_BusinessPartner from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BPGenderValueHelpText _BPGenderText $projection.GenderCodeName = _BPGenderText.GenderCodeName

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IICLBPQUICKVIEW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Geschäftspartner für Fallauskunft view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (103)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner
BusinessPartnerCategory BusinessPartnerCategory
AuthorizationGroup AuthorizationGroup
BusinessPartnerUUID BusinessPartnerUUID
PersonNumber PersonNumber
ETag ETag
BusinessPartnerName BusinessPartnerName
BusinessPartnerFullName BusinessPartnerFullName
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
BusinessPartnerIsBlocked BusinessPartnerIsBlocked
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
FirstName FirstName
LastName LastName
PersonFullName PersonFullName
OrganizationBPName1 OrganizationBPName1
OrganizationBPName2 OrganizationBPName2
OrganizationBPName3 OrganizationBPName3
OrganizationBPName4 OrganizationBPName4
InternationalLocationNumber1 InternationalLocationNumber1
InternationalLocationNumber2 InternationalLocationNumber2
InternationalLocationNumber3 InternationalLocationNumber3
LegalForm LegalForm
OrganizationFoundationDate OrganizationFoundationDate
OrganizationLiquidationDate OrganizationLiquidationDate
Industry Industry
IsNaturalPerson IsNaturalPerson
IsFemale IsFemale
IsMale IsMale
IsSexUnknown IsSexUnknown
FormOfAddress FormOfAddress
AcademicTitle AcademicTitle
AcademicTitle2 AcademicTitle2
NameFormat NameFormat
NameCountry NameCountry
BusinessPartnerGrouping BusinessPartnerGrouping
BusinessPartnerType BusinessPartnerType
MiddleName MiddleName
AdditionalLastName AdditionalLastName
GroupBusinessPartnerName1 GroupBusinessPartnerName1
GroupBusinessPartnerName2 GroupBusinessPartnerName2
CorrespondenceLanguage CorrespondenceLanguage
Language Language
SearchTerm1 SearchTerm1
SearchTerm2 SearchTerm2
BPLastNameSearchHelp BPLastNameSearchHelp
BPFirstNameSearchHelp BPFirstNameSearchHelp
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel
IndependentAddressID IndependentAddressID
IsActiveEntity IsActiveEntity
BirthDate BirthDate
PhoneNumber
EmailAddress
IsMarkedForArchiving IsMarkedForArchiving
ContactPermission ContactPermission
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem
LegalEntityOfOrganization LegalEntityOfOrganization
BusinessPartnerPrintFormat BusinessPartnerPrintFormat
BusinessPartnerDataOriginType BusinessPartnerDataOriginType
BusinessPartnerIsNotReleased BusinessPartnerIsNotReleased
IsNotContractuallyCapable IsNotContractuallyCapable
BusinessPartnerOccupation BusinessPartnerOccupation
BusPartMaritalStatus BusPartMaritalStatus
BusPartNationality BusPartNationality
NonResidentCompanyOriginCntry NonResidentCompanyOriginCntry
BusinessPartnerSalutation BusinessPartnerSalutation
BusinessPartnerBirthName BusinessPartnerBirthName
BusinessPartnerSupplementName BusinessPartnerSupplementName
BusinessPartnerBirthplaceName BusinessPartnerBirthplaceName
NaturalPersonEmployerName NaturalPersonEmployerName
BusinessPartnerDeathDate BusinessPartnerDeathDate
BusinessPartnerBirthDateStatus BusinessPartnerBirthDateStatus
BusinessPartnerGroupType BusinessPartnerGroupType
LastNamePrefix LastNamePrefix
LastNameSecondPrefix LastNameSecondPrefix
Initials Initials
GenderCodeName GenderCodeName
TrdCmplncLicenseIsMilitarySctr TrdCmplncLicenseIsMilitarySctr
TrdCmplncLicenseIsNuclearSctr TrdCmplncLicenseIsNuclearSctr
_AcademicTitleText _AcademicTitleText
_AcademicTitleValueHelp _AcademicTitleValueHelp
_AddressIndependentEmail _AddressIndependentEmail
_AddressIndependentFax _AddressIndependentFax
_AddressIndependentMobile _AddressIndependentMobile
_AddressIndependentPhone _AddressIndependentPhone
_BPCreditWorthiness _BPCreditWorthiness
_BPEmployment _BPEmployment
_BPFinancialServicesExt _BPFinancialServicesExt
_BPFinancialServicesExtn _BPFinancialServicesExtn
_BPRating _BPRating
_BuPaIdentification _BuPaIdentification
_BusinessPartnerIndustry _BusinessPartnerIndustry
_BusinessPartnerRole _BusinessPartnerRole
_CreatedByUser _CreatedByUser
_CurrentDefaultAddress _CurrentDefaultAddress
_DefaultAddress _DefaultAddress
_Industries _Industries
_LastChangedByUser _LastChangedByUser
_BPGenderText _BPGenderText 
@AbapCatalog.sqlViewName: 'IICLBPQUICKVIEW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Geschäftspartner für Fallauskunft'

@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: {
    dataClass: #MIXED, //#TRANSACTIONAL,

    sizeCategory: #L,
    serviceQuality: #D
}

define view I_InsurClmBPQuickView as select from I_BusinessPartner 
association [0..*] to I_BPGenderValueHelpText as _BPGenderText on $projection.GenderCodeName = _BPGenderText.GenderCodeName
{
  key BusinessPartner,
      BusinessPartnerCategory,
  AuthorizationGroup,
  BusinessPartnerUUID,
  PersonNumber,
  ETag,
      BusinessPartnerName,
  BusinessPartnerFullName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  BusinessPartnerIsBlocked,
  IsBusinessPurposeCompleted,
      FirstName,
      LastName,
  PersonFullName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  LegalForm,
  OrganizationFoundationDate,
  OrganizationLiquidationDate,
  Industry,
  IsNaturalPerson,
      IsFemale,
      IsMale,
      IsSexUnknown,
  FormOfAddress,
  AcademicTitle,
  AcademicTitle2,
  NameFormat,
  NameCountry,
  BusinessPartnerGrouping,
  BusinessPartnerType,
  MiddleName,
  AdditionalLastName,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  CorrespondenceLanguage,
  Language,
  SearchTerm1,
  SearchTerm2,
  BPLastNameSearchHelp,
  BPFirstNameSearchHelp,
  BusinessPartnerNicknameLabel,
  IndependentAddressID,
  IsActiveEntity,
      BirthDate,
      _CurrentDefaultAddress._Address._DefaultPhoneNumber.PhoneNumber,
      _CurrentDefaultAddress._Address._DefaultEmailAddress.EmailAddress,
  IsMarkedForArchiving,
  ContactPermission,
  BusinessPartnerIDByExtSystem,
  LegalEntityOfOrganization,
  BusinessPartnerPrintFormat,
  BusinessPartnerDataOriginType,
  BusinessPartnerIsNotReleased,
  IsNotContractuallyCapable,
  BusinessPartnerOccupation,
  BusPartMaritalStatus,
  BusPartNationality,
  NonResidentCompanyOriginCntry,
  BusinessPartnerSalutation,
  BusinessPartnerBirthName,
  BusinessPartnerSupplementName,
  BusinessPartnerBirthplaceName,
  NaturalPersonEmployerName,
  BusinessPartnerDeathDate,
  BusinessPartnerBirthDateStatus,
  BusinessPartnerGroupType,
  LastNamePrefix,
  LastNameSecondPrefix,
  Initials,
      GenderCodeName,
  TrdCmplncLicenseIsMilitarySctr,
  TrdCmplncLicenseIsNuclearSctr,
  /* Associations */
  _AcademicTitleText,
  _AcademicTitleValueHelp,
  _AddressIndependentEmail,
  _AddressIndependentFax,
  _AddressIndependentMobile,
  _AddressIndependentPhone,
  _BPCreditWorthiness,
  _BPEmployment,
  _BPFinancialServicesExt,
  _BPFinancialServicesExtn,
  _BPRating,
  _BuPaIdentification,
  _BusinessPartnerIndustry,
  _BusinessPartnerRole,
  _CreatedByUser,
  _CurrentDefaultAddress,
  _DefaultAddress,
  _Industries,
  _LastChangedByUser,
  _BPGenderText
}

Learn More