I_TMBusinessPartnerByIntKey
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)
| Source | Alias | Join Type |
|---|---|---|
| I_BusinessPartner | I_BusinessPartner | from |
Annotations (13)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA