I_BusinessPartnerTP_3

DDL: I_BUSINESSPARTNERTP_3 Type: view_entity TRANSACTIONAL
105 Fields 1 Data Sources

Business Partner

I_BusinessPartnerTP_3 is a Transactional CDS View that provides data about "Business Partner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerTP_2) and exposes 105 fields with key field BusinessPartner.

Data Sources (1)

SourceAliasJoin Type
I_BusinessPartnerTP_2 I_BusinessPartnerTP_2 projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Partner view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
Search.searchable true view
ObjectModel.representativeKey BusinessPartner view
ObjectModel.sapObjectNodeType.name BusinessPartner view
Metadata.ignorePropagatedAnnotations true view

Fields (105)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerUUID BusinessPartnerUUID UUID
FullName FullName Full Name
BusinessPartnerForEdit BusinessPartnerForEdit Busn. Partner
BusinessPartnerGrouping BusinessPartnerGrouping Grouping
BusinessPartnerCategory BusinessPartnerCategory Partner Cat.
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
FormOfAddress FormOfAddress Title Key
FormOfAddressPerson FormOfAddressPerson Title Key
FirstName FirstName First Name
LastName LastName Last Name
AdditionalLastName AdditionalLastName Other Last Name
BusinessPartnerBirthName BusinessPartnerBirthName Name at Birth
MiddleName MiddleName Middle Name
AcademicTitle AcademicTitle Academic Title
AcademicTitle2 AcademicTitle2 2nd Academic
BusinessPartnerSupplementName BusinessPartnerSupplementName Name Supplement
LastNamePrefix LastNamePrefix Prefix Key
LastNameSecondPrefix LastNameSecondPrefix 2nd prefix
PersonFullName PersonFullName Full Name
BusinessPartnerNicknameLabel BusinessPartnerNicknameLabel Nickname
Initials Initials Initials
IsNaturalPerson Natural person
Language Language Report Text Language
CorrespondenceLanguage CorrespondenceLanguage Language
BirthDate BirthDate Date of Birth
BusinessPartnerBirthplaceName BusinessPartnerBirthplaceName Birthplace
BusinessPartnerBirthDateStatus BusinessPartnerBirthDateStatus Birth Date Status
BusinessPartnerDeathDate BusinessPartnerDeathDate Death date
BusinessPartnerOccupation BusinessPartnerOccupation Occupation
BusPartNationality BusPartNationality Nationality
BusPartMaritalStatus BusPartMaritalStatus Marital Status
IsMale IsMale Male
IsFemale IsFemale Female
IsSexUnknown IsSexUnknown Unknown
GenderCodeName GenderCodeName Sex
AdditionalName AdditionalName Additional Name
BusinessPartnerIDByExtSystem BusinessPartnerIDByExtSystem External Number
NonResidentCompanyOriginCntry NonResidentCompanyOriginCntry C/R of Origin
NaturalPersonEmployerName NaturalPersonEmployerName Employer
BusinessPartnerSalutation BusinessPartnerSalutation
FormOfAddressOrganization FormOfAddressOrganization Title Key
OrganizationBPName1 OrganizationBPName1 Name 1
OrganizationBPName2 OrganizationBPName2 Name 2
OrganizationBPName3 OrganizationBPName3 Name 3
OrganizationBPName4 OrganizationBPName4 Name 4
LegalForm LegalForm Legal form
LegalEntityOfOrganization LegalEntityOfOrganization Legal entity
OrganizationFoundationDate OrganizationFoundationDate Date founded
OrganizationLiquidationDate OrganizationLiquidationDate Liquidation
InternationalLocationNumber1 InternationalLocationNumber1 Location no. 1
InternationalLocationNumber2 InternationalLocationNumber2 Location no. 2
InternationalLocationNumber3 InternationalLocationNumber3 Check digit
ETag ETag Etag
FormOfAddressGroup FormOfAddressGroup Title Key
GroupBusinessPartnerName1 GroupBusinessPartnerName1 Name 1
GroupBusinessPartnerName2 GroupBusinessPartnerName2 Name 2
BusinessPartnerGroupType BusinessPartnerGroupType Group type
AuthorizationGroup AuthorizationGroup AuthorizGroup
BusinessPartnerKind BusinessPartnerType Undefined range (can be used for patch levels)
BusinessPartnerPrintFormat BusinessPartnerPrintFormat Print Format
BusinessPartnerDataOriginType BusinessPartnerDataOriginType Data Origin
BusinessPartnerIsBlocked BusinessPartnerIsBlocked Central Block
IsMarkedForArchiving IsMarkedForArchiving Archiving Flag
BusinessPartnerIsNotReleased BusinessPartnerIsNotReleased Not released
ContactPermission ContactPermission Contact
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
SearchTerm1 SearchTerm1 Search Term 1
SearchTerm2 SearchTerm2 Search Term 2
BPFirstNameSearchHelp BPFirstNameSearchHelp Name2/First Nme
BPLastNameSearchHelp BPLastNameSearchHelp Name 1/Last Nme
NameFormat NameFormat Name Format
NameCountry NameCountry Country/Region
BusPartPersonDataIsHidden BusPartPersonDataIsHidden TRUE
BusPartOrgDataIsHidden BusPartOrgDataIsHidden TRUE
BusPartGroupDataIsHidden BusPartGroupDataIsHidden TRUE
BusPartAddrLanguageIsHidden BusPartAddrLanguageIsHidden TRUE
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_BusinessPartnerGrouping _BusinessPartnerGrouping
_BusinessPartnerCategory _BusinessPartnerCategory
_AcademicTitleValueHelp _AcademicTitleValueHelp
_BusinessPartnerLegalForm _BusinessPartnerLegalForm
_BusinessPartnerLegalEntity _BusinessPartnerLegalEntity
_AuthorizationGroup _AuthorizationGroup
_BusinessPartnerType _BusinessPartnerType
_PrintFormat _PrintFormat
_DataOriginType _DataOriginType
_ContactPermission _ContactPermission
DataControllerSet DataControllerSet Data Ctrlr. Set
DataController1 DataController1 Data Controller
DataController2 DataController2 Data Controller
DataController3 DataController3 Data Controller
DataController4 DataController4 Data Controller
DataController5 DataController5 Data Controller
DataController6 DataController6 Data Controller
DataController7 DataController7 Data Controller
DataController8 DataController8 Data Controller
DataController9 DataController9 Data Controller
DataController10 DataController10 Data Controller

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_BusinessPartnerTP_3.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_BusinessPartnerTP_3 AS
SELECT
  BusinessPartner,
  BusinessPartnerUUID,
  FullName,
  BusinessPartnerForEdit,
  BusinessPartnerGrouping,
  BusinessPartnerCategory,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  FormOfAddress,
  FormOfAddressPerson,
  FirstName,
  LastName,
  AdditionalLastName,
  BusinessPartnerBirthName,
  MiddleName,
  AcademicTitle,
  AcademicTitle2,
  BusinessPartnerSupplementName,
  LastNamePrefix,
  LastNameSecondPrefix,
  PersonFullName,
  BusinessPartnerNicknameLabel,
  Initials,
  cast( IsNaturalPerson as boole_d preserving type ) AS IsNaturalPerson,
  Language,
  CorrespondenceLanguage,
  BirthDate,
  BusinessPartnerBirthplaceName,
  BusinessPartnerBirthDateStatus,
  BusinessPartnerDeathDate,
  BusinessPartnerOccupation,
  BusPartNationality,
  BusPartMaritalStatus,
  IsMale,
  IsFemale,
  IsSexUnknown,
  GenderCodeName,
  AdditionalName,
  BusinessPartnerIDByExtSystem,
  NonResidentCompanyOriginCntry,
  NaturalPersonEmployerName,
  BusinessPartnerSalutation,
  FormOfAddressOrganization,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  LegalForm,
  LegalEntityOfOrganization,
  OrganizationFoundationDate,
  OrganizationLiquidationDate,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  ETag,
  FormOfAddressGroup,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  BusinessPartnerGroupType,
  AuthorizationGroup,
  BusinessPartnerType AS BusinessPartnerKind,
  BusinessPartnerPrintFormat,
  BusinessPartnerDataOriginType,
  BusinessPartnerIsBlocked,
  IsMarkedForArchiving,
  BusinessPartnerIsNotReleased,
  ContactPermission,
  IsBusinessPurposeCompleted,
  SearchTerm1,
  SearchTerm2,
  BPFirstNameSearchHelp,
  BPLastNameSearchHelp,
  NameFormat,
  NameCountry,
  BusPartPersonDataIsHidden,
  BusPartOrgDataIsHidden,
  BusPartGroupDataIsHidden,
  BusPartAddrLanguageIsHidden,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_BusinessPartnerTP_2
;

Learn More