I_TMBusinessPartnerByIntKey

DDL: I_TMBUSINESSPARTNERBYINTKEY Type: view BASIC

Business Partner

I_TMBusinessPartnerByIntKey is a Basic CDS View (Dimension) that provides data about "Business Partner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 52 fields with key field BusinessPartnerUUID.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartner I_BusinessPartner from

Annotations (13)

NameValueLevelField
EndUserText.label Business Partner view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey BusinessPartnerUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ITMBPBYINTKEY view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (52)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartnerUUID BusinessPartnerUUID
BusinessPartner BusinessPartner
BusinessPartnerCategory BusinessPartnerCategory
AuthorizationGroup AuthorizationGroup
PersonNumber PersonNumber
BusinessPartnerName BusinessPartnerName
BusinessPartnerFullName BusinessPartnerFullName
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
BusinessPartnerIsBlocked BusinessPartnerIsBlocked
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
FirstName FirstName
LastName LastName
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
GenderCodeName GenderCodeName
FormOfAddress FormOfAddress
AcademicTitle AcademicTitle
NameFormat NameFormat
NameCountry NameCountry
BusinessPartnerGrouping BusinessPartnerGrouping
BusinessPartnerType BusinessPartnerType
MiddleName MiddleName
AdditionalLastName AdditionalLastName
GroupBusinessPartnerName1 GroupBusinessPartnerName1
GroupBusinessPartnerName2 GroupBusinessPartnerName2
CorrespondenceLanguage CorrespondenceLanguage
Language Language
SearchTerm1 SearchTerm1
IndependentAddressID IndependentAddressID
_BusinessPartnerRole _BusinessPartnerRole
_CreatedByUser _CreatedByUser
_CurrentDefaultAddress _CurrentDefaultAddress
_DefaultAddress _DefaultAddress
_LastChangedByUser _LastChangedByUser
@EndUserText:   {label:              'Business Partner'}
@Analytics:     {dataCategory:       #DIMENSION,
                 internalName:       #LOCAL}
@ObjectModel:   {representativeKey:  'BusinessPartnerUUID',
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XL,
                                      dataClass:      #MASTER}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'ITMBPBYINTKEY' /*,
                 buffering:          {status: #NOT_ALLOWED}*/}
@AccessControl: {authorizationCheck: #CHECK,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@ClientHandling.algorithm:           #SESSION_VARIABLE
@Metadata.allowExtensions:           true
/*--------------------------------------------------------------------------------------
 * Copy from ER9 I_BusinessPartner on 27/JUN/2016
 * Modifications:
 * - changed name to I_TMBusinessPartnerByIntKey
 * - added buffering information (removed due to dataExtraction problem)
 * - changed selection from but000 to I_TMBusinessPartner
 * - changed key to internal key
 * - removed address independent contact data and industries associations
 * - removed AddressID
 * - removed dead code
 * - added authorization check
 * 04/JAN/2017
 * - added @ClientHandling.algorithm
 *--------------------------------------------------------------------------------------*/

// value help for this view:

// I_TranspMgmtBPByIntKeyStdVH


define view I_TMBusinessPartnerByIntKey
  as select from I_BusinessPartner
{
      @ObjectModel.text.element:  [ 'BusinessPartnerName' ]
  key BusinessPartnerUUID,
      BusinessPartner,
      BusinessPartnerCategory,
      AuthorizationGroup,
      PersonNumber,
      @Semantics.text: true
      BusinessPartnerName,
      @Semantics.text: true
      BusinessPartnerFullName,
      CreatedByUser,
      CreationDate,
      CreationTime,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,
      BusinessPartnerIsBlocked,
      IsBusinessPurposeCompleted,
      FirstName,
      LastName,
      OrganizationBPName1,
      OrganizationBPName2,
      OrganizationBPName3,
      OrganizationBPName4,
      InternationalLocationNumber1,
      InternationalLocationNumber2,
      InternationalLocationNumber3,
      LegalForm,
      OrganizationFoundationDate,
      OrganizationLiquidationDate,
      Industry,
      IsNaturalPerson,
      IsFemale,
      IsMale,
      IsSexUnknown,
      GenderCodeName,
      FormOfAddress,
      AcademicTitle,
      NameFormat,
      NameCountry,
      BusinessPartnerGrouping,
      BusinessPartnerType,
      MiddleName,
      AdditionalLastName,
      GroupBusinessPartnerName1,
      GroupBusinessPartnerName2,
      CorrespondenceLanguage,
      Language,
      SearchTerm1,
      IndependentAddressID,

      /* Associations */
      _BusinessPartnerRole,
      _CreatedByUser,
      _CurrentDefaultAddress,
      _DefaultAddress,
      _LastChangedByUser
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_BPCURRENTDEFAULTADDRESS",
"I_BUSINESSPARTNERDEFAULTADDR",
"I_BUSINESSPARTNER_TO_BP_ROLE",
"I_USER"
],
"BASE":
[
"I_BUSINESSPARTNER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/