What is I_BusPartDetailsGeneralTP in SAP S/4HANA?

I_BusPartDetailsGeneralTP is a transactional CDS view in SAP S/4HANA. BP General Details for Process Data It contains 79 fields.

Which tables does I_BusPartDetailsGeneralTP read from?

I_BusPartDetailsGeneralTP reads data from: I_BusinessPartnerProcessTP.

What VDM layer is I_BusPartDetailsGeneralTP?

I_BusPartDetailsGeneralTP is classified as a Transactional view that supports create, update, and delete operations.

I_BusPartDetailsGeneralTP

DDL: I_BUSPARTDETAILSGENERALTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_GOV_BO

79 Fields 1 Data Sources 1 Associations

BP General Details for Process Data

I_BusPartDetailsGeneralTP is a Transactional CDS View that provides data about "BP General Details for Process Data" in SAP S/4HANA. It reads from 1 data source (I_BusinessPartnerProcessTP) and exposes 79 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject. It has 1 association to related views. Part of development package MDC_BUPA_GOV_BO.

Data Sources (1)

Source	Alias	Join Type
I_BusinessPartnerProcessTP	I_BusinessPartnerProcessTP	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..1]	I_BusinessPartnerAddressProcTP	_BusPartStandardAddr	`$projection.MasterDataChangeProcess = _BusPartStandardAddr.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusPartStandardAddr.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusPartStandardAddr.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusPartStandardAddr.MDChgProcessSrceObject and _BusPartStandardAddr.StandardUsage = 'X'`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	BP General Details for Process Data	view
AccessControl.personalData.blocking	#REQUIRED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
Search.searchable	true	view
VDM.viewType	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view

Fields (79)

Key	Field	Source Table	Source Field	Description
KEY	MasterDataChangeProcess		MasterDataChangeProcess	Process ID
KEY	MDChgProcessStep		MDChgProcessStep	Step Number
KEY	MDChgProcessSrceSystem		MDChgProcessSrceSystem	Source System
KEY	MDChgProcessSrceObject		MDChgProcessSrceObject	Source ID
	MDChgProcessSourceModified		MDChgProcessSourceModified	Modified
	MDChgProcessSourceModifBinary		MDChgProcessSourceModifBinary
	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
	IsMarkedForArchiving		IsMarkedForArchiving	Archiving Flag
	ContactPermission		ContactPermission	Contact
	BusinessPartnerIsNotReleased		BusinessPartnerIsNotReleased	Not released
	IsNotContractuallyCapable		IsNotContractuallyCapable	Not Legally Competnt
	FormOfAddress		FormOfAddress	Title Key
	BusinessPartnerGrouping		BusinessPartnerGrouping	Grouping
	SearchTerm1		SearchTerm1	Search Term 1
	SearchTerm2		SearchTerm2	Search Term 2
	BPLastNameSearchHelp		BPLastNameSearchHelp	Name 1/Last Nme
	BPFirstNameSearchHelp		BPFirstNameSearchHelp	Name2/First Nme
	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
	IsFemale		IsFemale	Female
	IsMale		IsMale	Male
	IsSexUnknown		IsSexUnknown	Unknown
	GenderCodeName		GenderCodeName	Sex
	FirstName		FirstName	First Name
	LastName		LastName	Last Name
	AcademicTitle		AcademicTitle	Academic Title
	BirthDate		BirthDate	Date of Birth
	GroupBusinessPartnerName1		GroupBusinessPartnerName1	Name 1
	GroupBusinessPartnerName2		GroupBusinessPartnerName2	Name 2
	BusinessPartnerGroupType		BusinessPartnerGroupType	Group type
	Country	_BusPartStandardAddr	Country	Venue: Ctry/Reg
	Region	_BusPartStandardAddr	Region	Venue Region
	DistrictName	_BusPartStandardAddr	DistrictName	District
	PostalCode	_BusPartStandardAddr	PostalCode	Postal Code
	CityName	_BusPartStandardAddr	CityName	Name
	StreetName	_BusPartStandardAddr	StreetName	Text
	HouseNumber	_BusPartStandardAddr	HouseNumber	House Number
	Country1elseendasAddressLine2Text
	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
	_BusinessPartnerCategory		_BusinessPartnerCategory
	_AuthorizationGroup		_AuthorizationGroup
	_BusinessPartnerGrouping		_BusinessPartnerGrouping
	_FormOfAddress		_FormOfAddress
	_BusinessPartnerLegalForm		_BusinessPartnerLegalForm
	_BusinessPartnerGender		_BusinessPartnerGender
	_AcademicTitleValueHelp		_AcademicTitleValueHelp
	_GroupType		_GroupType
	_BusPartStandardAddr		_BusPartStandardAddr

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_BusPartDetailsGeneralTP.
-- 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_BusPartDetailsGeneralTP AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  MDChgProcessSourceModified,
  MDChgProcessSourceModifBinary,
  BusinessPartner,
  BusinessPartnerCategory,
  AuthorizationGroup,
  BusinessPartnerUUID,
  PersonNumber,
  ETag,
  BusinessPartnerName,
  BusinessPartnerFullName,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  BusinessPartnerIsBlocked,
  IsBusinessPurposeCompleted,
  IsMarkedForArchiving,
  ContactPermission,
  BusinessPartnerIsNotReleased,
  IsNotContractuallyCapable,
  FormOfAddress,
  BusinessPartnerGrouping,
  SearchTerm1,
  SearchTerm2,
  BPLastNameSearchHelp,
  BPFirstNameSearchHelp,
  OrganizationBPName1,
  OrganizationBPName2,
  OrganizationBPName3,
  OrganizationBPName4,
  InternationalLocationNumber1,
  InternationalLocationNumber2,
  InternationalLocationNumber3,
  LegalForm,
  IsFemale,
  IsMale,
  IsSexUnknown,
  GenderCodeName,
  FirstName,
  LastName,
  AcademicTitle,
  BirthDate,
  GroupBusinessPartnerName1,
  GroupBusinessPartnerName2,
  BusinessPartnerGroupType,
  _BusPartStandardAddr.Country AS Country,
  _BusPartStandardAddr.Region AS Region,
  _BusPartStandardAddr.DistrictName AS DistrictName,
  _BusPartStandardAddr.PostalCode AS PostalCode,
  _BusPartStandardAddr.CityName AS CityName,
  _BusPartStandardAddr.StreetName AS StreetName,
  _BusPartStandardAddr.HouseNumber AS HouseNumber,
  case when _BusPartStandardAddr.Country <> '' then concat_with_space( concat_with_space( concat_with_space( concat_with_space(_BusPartStandardAddr.StreetName,_BusPartStandardAddr.HouseNumber,1) ,_BusPartStandardAddr.PostalCode,1) ,_BusPartStandardAddr.CityName,1) ,_BusPartStandardAddr.Country,1) else '' end as AddressLine2Text AS Country1elseendasAddressLine2Text,
  DataControllerSet,
  DataController1,
  DataController2,
  DataController3,
  DataController4,
  DataController5,
  DataController6,
  DataController7,
  DataController8,
  DataController9,
  DataController10
FROM I_BusinessPartnerProcessTP
LEFT OUTER JOIN I_BusinessPartnerAddressProcTP AS _BusPartStandardAddr ON MasterDataChangeProcess = _BusPartStandardAddr.MasterDataChangeProcess AND MDChgProcessStep = _BusPartStandardAddr.MDChgProcessStep AND MDChgProcessSrceSystem = _BusPartStandardAddr.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusPartStandardAddr.MDChgProcessSrceObject AND _BusPartStandardAddr.StandardUsage = 'X'  -- association [0..1]
;

Depth:

I_BusPartDetailsGeneralTP view_entity

I_BusinessPartnerProcessTP view_entity