I_BusPartIdentificationType

DDL: I_BUSPARTIDENTIFICATIONTYPE SQL: IBPIDTYPE Type: view COMPOSITE

Business Partner identification Type View

I_BusPartIdentificationType is a Composite CDS View (Fact) that provides data about "Business Partner identification Type View" in SAP S/4HANA. It reads from 3 data sources (tb039a, tb039a, tb039a) and exposes 8 fields with key fields BPIdentificationType, BusinessPartnerCategory, BusinessPartnerCategory, BusinessPartnerCategory. It has 2 associations to related views.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
tb039a tb039a from
tb039a tb039a union
tb039a tb039a union

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_BusPartIdentificationTypeT_2 _Text $projection.BPIdentificationType = _Text.BPIdentificationType
[1..1] I_BusPartCategory _BusinessPartnerCategory $projection.BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IBPIDTYPE view
Analytics.dataCategory #FACT view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Business Partner identification Type View view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BPIdentificationType type
KEY BusinessPartnerCategory
_Text _Text
KEY BusinessPartnerCategory
_Text _Text
KEY BusinessPartnerCategory
_Text _Text
_BusinessPartnerCategory _BusinessPartnerCategory 
@AbapCatalog.sqlViewName: 'IBPIDTYPE'
@Analytics.dataCategory: #FACT
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck:  #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm : #SESSION_VARIABLE
@Search.searchable: true
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Business Partner identification Type View'
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_BusPartIdentificationType
   as select from tb039a
    association [1..*] to I_BusPartIdentificationTypeT_2 as _Text on $projection.BPIdentificationType = _Text.BPIdentificationType
    association [1..1] to I_BusPartCategory as _BusinessPartnerCategory on $projection.BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory
{
      @ObjectModel.text.association: '_Text'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      key type as BPIdentificationType,
      key cast('1' as bu_type) as BusinessPartnerCategory,
      _Text,
      _BusinessPartnerCategory
} where xperson = 'X'
     
union

  select from tb039a
    association [1..*] to I_BusPartIdentificationTypeT_2 as _Text on $projection.BPIdentificationType = _Text.BPIdentificationType
    association [1..1] to I_BusPartCategory as _BusinessPartnerCategory on $projection.BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory
{
      @ObjectModel.text.association: '_Text'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      key type as BPIdentificationType,
      key cast('2' as bu_type) as BusinessPartnerCategory,
      _Text,
      _BusinessPartnerCategory
} where xorganisation = 'X'

union

  select from tb039a
    association [1..*] to I_BusPartIdentificationTypeT_2 as _Text on $projection.BPIdentificationType = _Text.BPIdentificationType
    association [1..1] to I_BusPartCategory as _BusinessPartnerCategory on $projection.BusinessPartnerCategory = _BusinessPartnerCategory.BusinessPartnerCategory
{
      @ObjectModel.text.association: '_Text'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      key type as BPIdentificationType,
      key cast('3' as bu_type) as BusinessPartnerCategory,
      _Text,
      _BusinessPartnerCategory
} where xgroup = 'X'

Learn More