I_SecurityClassIssuer

DDL: I_SECURITYCLASSISSUER SQL: ISECCLASSISSUER Type: view BASIC

Security Class Issuer

I_SecurityClassIssuer is a Basic CDS View that provides data about "Security Class Issuer" in SAP S/4HANA. It reads from 2 data sources (I_BusinessPartner, I_BusinessPartner_to_BP_Role) and exposes 4 fields with key field BusinessPartner.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
I_BusinessPartner BusinessPartner from
I_BusinessPartner_to_BP_Role BusinessPartnerRole inner

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ISECCLASSISSUER view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Security Class Issuer view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey BusinessPartner view
Consumption.ranked true view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner I_BusinessPartner BusinessPartner
AuthorizationGroup I_BusinessPartner AuthorizationGroup
BusinessPartnerName I_BusinessPartner BusinessPartnerName
IsBusinessPurposeCompleted I_BusinessPartner IsBusinessPurposeCompleted 
@AbapCatalog.sqlViewName: 'ISECCLASSISSUER'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED 
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass:  #TRANSACTIONAL
@EndUserText.label: 'Security Class Issuer'
@AbapCatalog.preserveKey:true
@ObjectModel.representativeKey: 'BusinessPartner'
@Consumption.ranked: true
@Search.searchable: true

define view I_SecurityClassIssuer
  as select from I_BusinessPartner            as BusinessPartner
    inner join   I_BusinessPartner_to_BP_Role as BusinessPartnerRole on  BusinessPartner.BusinessPartner         = BusinessPartnerRole.BusinessPartner
                                                                     and BusinessPartnerRole.BusinessPartnerRole = 'TR0150'
{
      @ObjectModel.text.element:  [ 'BusinessPartnerName' ]
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
  key BusinessPartner.BusinessPartner,
      //BusinessPartner.BusinessPartnerCategory,

      BusinessPartner.AuthorizationGroup,
      //BusinessPartner.BusinessPartnerUUID,

      //BusinessPartner.PersonNumber,

      @Semantics.text: true 
      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.8
      BusinessPartner.BusinessPartnerName,
      //@Semantics.text: true

      //BusinessPartner.BusinessPartnerFullName,

      /*
      BusinessPartner.CreatedByUser,
      BusinessPartner.CreationDate,
      BusinessPartner.CreationTime,
      BusinessPartner.LastChangedByUser,
      BusinessPartner.LastChangeDate,
      BusinessPartner.LastChangeTime,
      BusinessPartner.BusinessPartnerIsBlocked,
      BusinessPartner.FirstName,
      BusinessPartner.LastName,
      BusinessPartner.PersonFullName,
      */
      
      BusinessPartner.IsBusinessPurposeCompleted
      
      /*
      BusinessPartner.OrganizationBPName1,
      BusinessPartner.OrganizationBPName2,
      BusinessPartner.OrganizationBPName3,
      BusinessPartner.OrganizationBPName4,
      BusinessPartner.InternationalLocationNumber1,
      BusinessPartner.InternationalLocationNumber2,
      BusinessPartner.InternationalLocationNumber3,
      BusinessPartner.LegalForm,
      BusinessPartner.OrganizationFoundationDate,
      BusinessPartner.OrganizationLiquidationDate,
      BusinessPartner.Industry,
      BusinessPartner.IsNaturalPerson,
      BusinessPartner.IsFemale,
      BusinessPartner.IsMale,
      BusinessPartner.IsSexUnknown,
      BusinessPartner.FormOfAddress,
      BusinessPartner.AcademicTitle,
      BusinessPartner.NameFormat,
      BusinessPartner.NameCountry,
      BusinessPartner.BusinessPartnerGrouping,
      BusinessPartner.BusinessPartnerType,
      BusinessPartner.MiddleName,
      BusinessPartner.AdditionalLastName,
      BusinessPartner.GroupBusinessPartnerName1,
      BusinessPartner.GroupBusinessPartnerName2,
      BusinessPartner.CorrespondenceLanguage,
      BusinessPartner.Language,
      BusinessPartner.SearchTerm1,
      BusinessPartner.IndependentAddressID,
      BusinessPartner.BirthDate,

      BusinessPartner._AddressIndependentEmail,
      BusinessPartner._AddressIndependentFax,
      BusinessPartner._AddressIndependentMobile,
      BusinessPartner._AddressIndependentPhone,
      BusinessPartner._BusinessPartnerRole,
      BusinessPartner._CreatedByUser,
      BusinessPartner._CurrentDefaultAddress,
      BusinessPartner._DefaultAddress,
      BusinessPartner._Industries,
      BusinessPartner._LastChangedByUser
      */
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_BUSINESSPARTNER_TO_BP_ROLE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More