What is I_TravelExpenseBusinessPartner in SAP S/4HANA?

I_TravelExpenseBusinessPartner is a composite CDS view in SAP S/4HANA. Travel Expense Business Partner It contains 115 fields.

Which tables does I_TravelExpenseBusinessPartner read from?

I_TravelExpenseBusinessPartner reads data from: I_BusinessPartner.

What VDM layer is I_TravelExpenseBusinessPartner?

I_TravelExpenseBusinessPartner is classified as a Composite view that combines data from multiple basic views.

I_TravelExpenseBusinessPartner

DDL: I_TRAVELEXPENSEBUSINESSPARTNER Type: view COMPOSITE

115 Fields 1 Data Sources 2 Associations

Travel Expense Business Partner

I_TravelExpenseBusinessPartner is a Composite CDS View that provides data about "Travel Expense Business Partner" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartner) and exposes 115 fields with key field BusinessPartner. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_BusinessPartner	I_BusinessPartner	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	I_BusinessPartnerAddress	_BusinessPartnerAddress	`$projection.BusinessPartner = _BusinessPartnerAddress.BusinessPartner`
[0..1]	I_BusinessPartnerRoleText	_BusinessPartnerRoleText	`$projection.BusinessPartnerRole = _BusinessPartnerRoleText.BusinessPartnerRole and _BusinessPartnerRoleText.Language = $session.system_language`

Annotations (13)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.sqlViewName	ITRVLEXPNBP	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.representativeKey	BusinessPartner	view
EndUserText.label	Travel Expense Business Partner	view

Fields (115)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner		BusinessPartner	Issuing Authority
	BusinessPartnerCategory		BusinessPartnerCategory	Partner Cat.
	AuthorizationGroup		AuthorizationGroup	AuthorizGroup
	BusinessPartnerUUID		BusinessPartnerUUID	UUID
	PersonNumber		PersonNumber	Person Number
	ETag		ETag	Update Token
	BusinessPartnerName		BusinessPartnerName	Extracted Customer Name
	BusinessPartnerFullName		BusinessPartnerFullName	Broker Name
	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
	BusinessPartnerIsBlocked		BusinessPartnerIsBlocked	Central Block
	IsBusinessPurposeCompleted		IsBusinessPurposeCompleted	Purpose Completed
	FirstName		FirstName	First Name
	LastName		LastName	Last Name
	PersonFullName		PersonFullName	Full Name
	OrganizationBPName1		OrganizationBPName1	Name 1
	OrganizationBPName2		OrganizationBPName2	Name 2
	OrganizationBPName3		OrganizationBPName3	Name 3
	OrganizationBPName4		OrganizationBPName4	Name 4
	InternationalLocationNumber1		InternationalLocationNumber1	Location no. 1
	InternationalLocationNumber2		InternationalLocationNumber2	Location no. 2
	InternationalLocationNumber3		InternationalLocationNumber3	Check digit
	LegalForm		LegalForm	Legal form
	OrganizationFoundationDate		OrganizationFoundationDate	Date founded
	OrganizationLiquidationDate		OrganizationLiquidationDate	Liquidation
	IsNaturalPerson		IsNaturalPerson	Natural person
	IsFemale		IsFemale	Female
	IsMale		IsMale	Male
	IsSexUnknown		IsSexUnknown	Unknown
	FormOfAddress		FormOfAddress	Title Key
	AcademicTitle		AcademicTitle	Academic Title
	AcademicTitle2		AcademicTitle2	2nd Academic
	NameFormat		NameFormat	Name Format
	NameCountry		NameCountry	Country/Region
	BusinessPartnerGrouping		BusinessPartnerGrouping	Grouping
	BusinessPartnerType		BusinessPartnerType	Undefined range (can be used for patch levels)
	MiddleName		MiddleName	Middle Name
	AdditionalLastName		AdditionalLastName	Other Last Name
	GroupBusinessPartnerName1		GroupBusinessPartnerName1	Name 1
	GroupBusinessPartnerName2		GroupBusinessPartnerName2	Name 2
	CorrespondenceLanguage		CorrespondenceLanguage	Language
	Language		Language	Report Text Language
	SearchTerm1		SearchTerm1	Search Term 1
	SearchTerm2		SearchTerm2	Search Term 2
	BPLastNameSearchHelp		BPLastNameSearchHelp	Name 1/Last Nme
	BPFirstNameSearchHelp		BPFirstNameSearchHelp	Name2/First Nme
	BusinessPartnerNicknameLabel		BusinessPartnerNicknameLabel	Nickname
	IndependentAddressID		IndependentAddressID	Address Number
	IsActiveEntity		IsActiveEntity	Is active
	BirthDate		BirthDate	Date of Birth
	IsMarkedForArchiving		IsMarkedForArchiving	Archiving Flag
	ContactPermission		ContactPermission	Contact
	BusinessPartnerIDByExtSystem		BusinessPartnerIDByExtSystem	External Number
	LegalEntityOfOrganization		LegalEntityOfOrganization	Legal entity
	BusinessPartnerPrintFormat		BusinessPartnerPrintFormat	Print Format
	BusinessPartnerDataOriginType		BusinessPartnerDataOriginType	Data Origin
	BusinessPartnerIsNotReleased		BusinessPartnerIsNotReleased	Not released
	IsNotContractuallyCapable		IsNotContractuallyCapable	Not Legally Competnt
	BusinessPartnerOccupation		BusinessPartnerOccupation	Occupation
	BusPartMaritalStatus		BusPartMaritalStatus	Marital Status
	BusPartNationality		BusPartNationality	Nationality
	NonResidentCompanyOriginCntry		NonResidentCompanyOriginCntry	C/R of Origin
	BusinessPartnerSalutation		BusinessPartnerSalutation	Salutation
	BusinessPartnerBirthName		BusinessPartnerBirthName	Name at Birth
	BusinessPartnerSupplementName		BusinessPartnerSupplementName	Name Supplement
	BusinessPartnerBirthplaceName		BusinessPartnerBirthplaceName	Birthplace
	NaturalPersonEmployerName		NaturalPersonEmployerName	Employer
	BusinessPartnerDeathDate		BusinessPartnerDeathDate	Death date
	BusinessPartnerBirthDateStatus		BusinessPartnerBirthDateStatus	Birth Date Status
	BusinessPartnerGroupType		BusinessPartnerGroupType	Group type
	LastNamePrefix		LastNamePrefix	Prefix Key
	LastNameSecondPrefix		LastNameSecondPrefix	2nd prefix
	Initials		Initials	Initials
	GenderCodeName		GenderCodeName	Sex
	TrdCmplncLicenseIsMilitarySctr		TrdCmplncLicenseIsMilitarySctr
	TrdCmplncLicenseIsNuclearSctr		TrdCmplncLicenseIsNuclearSctr
	CityName	_BusinessPartnerAddress	CityName	Name
	BusinessPartnerRole	_BusinessPartnerRole	BusinessPartnerRole	BP Role
	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
	BPDataControllerIsNotRequired		BPDataControllerIsNotRequired	DC Not Required
	_AcademicTitleText		_AcademicTitleText
	_AcademicTitleValueHelp		_AcademicTitleValueHelp
	_AddressIndependentEmail		_AddressIndependentEmail
	_AddressIndependentFax		_AddressIndependentFax
	_AddressIndependentMobile		_AddressIndependentMobile
	_AddressIndependentPhone		_AddressIndependentPhone
	_BPCreditWorthiness		_BPCreditWorthiness
	_BPEmployment		_BPEmployment
	_BPFinancialServicesExt		_BPFinancialServicesExt
	_BPFinancialServicesExtn		_BPFinancialServicesExtn
	_BPRating		_BPRating
	_BPRelationship		_BPRelationship
	_BuPaIdentification		_BuPaIdentification
	_BusinessPartnerIndustry		_BusinessPartnerIndustry
	_BusinessPartnerRole		_BusinessPartnerRole
	_CreatedByUser		_CreatedByUser
	_CurrentDefaultAddress		_CurrentDefaultAddress
	_DefaultAddress		_DefaultAddress
	_LastChangedByUser		_LastChangedByUser
	_BusinessPartnerAddress		_BusinessPartnerAddress
	_BusinessPartnerRoleText		_BusinessPartnerRoleText

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_TravelExpenseBusinessPartner.
-- 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_TravelExpenseBusinessPartner AS
SELECT
  BusinessPartner,
  BusinessPartnerCategory,
  AuthorizationGroup,
  BusinessPartnerUUID,
  PersonNumber,
  ETag,
  BusinessPartnerName,
  BusinessPartnerFullName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  BusinessPartnerIsBlocked,
  IsBusinessPurposeCompleted,
  FirstName,
  LastName,
  PersonFullName,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  LegalForm,
  OrganizationFoundationDate,
  OrganizationLiquidationDate,
  IsNaturalPerson,
  IsFemale,
  IsMale,
  IsSexUnknown,
  FormOfAddress,
  AcademicTitle,
  AcademicTitle2,
  NameFormat,
  NameCountry,
  BusinessPartnerGrouping,
  BusinessPartnerType,
  MiddleName,
  AdditionalLastName,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  CorrespondenceLanguage,
  Language,
  SearchTerm1,
  SearchTerm2,
  BPLastNameSearchHelp,
  BPFirstNameSearchHelp,
  BusinessPartnerNicknameLabel,
  IndependentAddressID,
  IsActiveEntity,
  BirthDate,
  IsMarkedForArchiving,
  ContactPermission,
  BusinessPartnerIDByExtSystem,
  LegalEntityOfOrganization,
  BusinessPartnerPrintFormat,
  BusinessPartnerDataOriginType,
  BusinessPartnerIsNotReleased,
  IsNotContractuallyCapable,
  BusinessPartnerOccupation,
  BusPartMaritalStatus,
  BusPartNationality,
  NonResidentCompanyOriginCntry,
  BusinessPartnerSalutation,
  BusinessPartnerBirthName,
  BusinessPartnerSupplementName,
  BusinessPartnerBirthplaceName,
  NaturalPersonEmployerName,
  BusinessPartnerDeathDate,
  BusinessPartnerBirthDateStatus,
  BusinessPartnerGroupType,
  LastNamePrefix,
  LastNameSecondPrefix,
  Initials,
  GenderCodeName,
  TrdCmplncLicenseIsMilitarySctr,
  TrdCmplncLicenseIsNuclearSctr,
  _BusinessPartnerAddress.CityName AS CityName,
  _BusinessPartnerRole.BusinessPartnerRole AS BusinessPartnerRole,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10,
  BPDataControllerIsNotRequired
FROM I_BusinessPartner
LEFT OUTER JOIN I_BusinessPartnerAddress AS _BusinessPartnerAddress ON BusinessPartner = _BusinessPartnerAddress.BusinessPartner  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartnerRoleText AS _BusinessPartnerRoleText ON BusinessPartnerRole = _BusinessPartnerRoleText.BusinessPartnerRole AND _BusinessPartnerRoleText.Language = $session.system_language  -- association [0..1]
;

Depth:

I_TravelExpenseBusinessPartner view

I_BusinessPartner view