What is I_BusPartScriptedPersAddrGov in SAP S/4HANA?

I_BusPartScriptedPersAddrGov is a composite CDS view in SAP S/4HANA. Bus Partner Person Addr Vers for Gov It contains 137 fields.

Which tables does I_BusPartScriptedPersAddrGov read from?

I_BusPartScriptedPersAddrGov reads data from: I_BusPartScriptedPersAddrProc, I_BusPartScriptedPersonAddress.

What VDM layer is I_BusPartScriptedPersAddrGov?

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

I_BusPartScriptedPersAddrGov

DDL: I_BUSPARTSCRIPTEDPERSADDRGOV Type: view_entity COMPOSITE Package: MDC_BUPA_GOV_BO

137 Fields 2 Data Sources 3 Associations

Bus Partner Person Addr Vers for Gov

I_BusPartScriptedPersAddrGov is a Composite CDS View that provides data about "Bus Partner Person Addr Vers for Gov" in SAP S/4HANA. It reads from 2 data sources (I_BusPartScriptedPersAddrProc, I_BusPartScriptedPersonAddress) and exposes 137 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 3 associations to related views. Part of development package MDC_BUPA_GOV_BO.

Data Sources (2)

Source	Alias	Join Type
I_BusPartScriptedPersAddrProc	I_BusPartScriptedPersAddrProc	from
I_BusPartScriptedPersonAddress	I_BusPartScriptedPersonAddress	union_all

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_BusinessPartnerGov	_BusinessPartnerGov	`$projection.MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess and $projection.MDChgProcessStep = _BusinessPartnerGov.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject`
[0..1]	I_BPProtectedAddressGov	_BPProtectedAddress	`$projection.MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess and $projection.MDChgProcessStep = _BPProtectedAddress.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _BPProtectedAddress.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _BPProtectedAddress.MDChgProcessSrceObject and $projection.AddressNumber = _BPProtectedAddress.AddressNumber`
[0..1]	I_MasterDataChangeProcess	_MasterDataChangeProcess	`$projection.MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Bus Partner Person Addr Vers for Gov	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#X	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.viewType	#COMPOSITE	view

Fields (137)

Key	Field	Source Field	Description
KEY	MasterDataChangeProcess	MasterDataChangeProcess	Process ID
KEY	MDChgProcessStep	MDChgProcessStep	Step Number
KEY	MDChgProcessSrceSystem	MDChgProcessSrceSystem	Source System
KEY	MDChgProcessSrceObject	MDChgProcessSrceObject	Issuing Authority
KEY	AddressNumber	AddressNumber	Src Address No
KEY	AddressRepresentationCode	AddressRepresentationCode	Address Version
	ValidityStartDate	ValidityStartDate	Valid From Timestamp
	ValidityEndDate	ValidityEndDate	Valid To Timestamp
	BusinessPartnerAddressUUID	BusinessPartnerAddressUUID	UUID
	CareOfName	CareOfName	c/o
	AdditionalStreetSuffixName	AdditionalStreetSuffixName	Street 5
	CorrespondenceLanguage	CorrespondenceLanguage	Language
	PrfrdCommMediumType	PrfrdCommMediumType	Comm. Method
	POBox	POBox	PO Box
	POBoxIsWithoutNumber	POBoxIsWithoutNumber	PO Box w/o No.
	POBoxPostalCode	POBoxPostalCode	PO Box Postal Code
	POBoxLobbyName	POBoxLobbyName	PO Box Lobby
	POBoxDeviatingCityName	POBoxDeviatingCityName	PO Box City
	POBoxDeviatingRegion	POBoxDeviatingRegion	PO Region
	POBoxDeviatingCountry	POBoxDeviatingCountry	PO Box C/R
	DeliveryServiceTypeCode	DeliveryServiceTypeCode	Delvry Serv Type
	DeliveryServiceNumber	DeliveryServiceNumber	Delivery Service No.
	AddressTimeZone	AddressTimeZone	Time Zone
	CityFileTestStatus	CityFileTestStatus	Check Status
	AddressNonDeliverableReason	AddressNonDeliverableReason	Undeliverable
	PostBoxNonDeliverableReason	PostBoxNonDeliverableReason	Undeliverable
	FullName	FullName	Name
	CityName	CityName	Name
	DistrictName	DistrictName	District
	HomeCityName	HomeCityName	Different City
	PostalCode	PostalCode	Postal Code
	CompanyPostalCode	CompanyPostalCode	Company Post Cd
	StreetName	StreetName	Text
	StreetPrefixName	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	AdditionalStreetPrefixName	Street 3
	StreetSuffixName	StreetSuffixName	Street 4
	HouseNumber	HouseNumber	House Number
	HouseNumberSupplementText	HouseNumberSupplementText	Supplement
	Building	Building	Building code
	Floor	Floor	Floor
	RoomNumber	RoomNumber	Room Number
	Country	Country	Venue: Ctry/Reg
	Region	Region	Venue Region
	BPCountyText	BPCountyText	County
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	TransportZone	TransportZone	Transport Zone
	Person	Person	Person/ Farm/ Field
	FormOfAddress	FormOfAddress	Title Key
	SearchTerm1	SearchTerm1	Search Term 1
	SearchTerm2	SearchTerm2	Search Term 2
	FirstName	FirstName	First Name
	LastName	LastName	Last Name
	BusinessPartnerBirthName	BusinessPartnerBirthName	Name at Birth
	MiddleName	MiddleName	Middle Name
	AdditionalLastName	AdditionalLastName	Other Last Name
	PersonFullName	PersonFullName	Full Name
	AcademicTitle	AcademicTitle	Academic Title
	AcademicTitle2	AcademicTitle2	2nd Academic
	LastNamePrefix	LastNamePrefix	Prefix Key
	LastNameSecondPrefix	LastNameSecondPrefix	2nd prefix
	BusinessPartnerSupplementName	BusinessPartnerSupplementName	Name Supplement
	BusinessPartnerNicknameLabel	BusinessPartnerNicknameLabel	Nickname
	Initials	Initials	Initials
	NameFormat	NameFormat	Name Format
	NameCountry	NameCountry	Country/Region
	BPFirstNameSearchHelp	BPFirstNameSearchHelp	Name2/First Nme
	BPLastNameSearchHelp	BPLastNameSearchHelp	Name 1/Last Nme
	_BPProtectedAddress	_BPProtectedAddress
KEY	MDChgProcessStep		Step Number
KEY	MDChgProcessSrceSystem		Source System
KEY	MDChgProcessSrceObject	BusinessPartner	Issuing Authority
KEY	AddressNumber	AddressNumber	Src Address No
KEY	AddressRepresentationCode	AddressRepresentationCode	Address Version
	ValidityStartDate	ValidityStartDateTime	Valid From Timestamp
	ValidityEndDate	ValidityEndDateTime	Valid To Timestamp
	BusinessPartnerAddressUUID		UUID
	CareOfName	CareOfName	c/o
	AdditionalStreetSuffixName	AdditionalStreetSuffixName	Street 5
	CorrespondenceLanguage	CorrespondenceLanguage	Language
	PrfrdCommMediumType	PrfrdCommMediumType	Comm. Method
	POBox	POBox	PO Box
	POBoxIsWithoutNumber	POBoxIsWithoutNumber	PO Box w/o No.
	POBoxPostalCode	POBoxPostalCode	PO Box Postal Code
	POBoxLobbyName	POBoxLobbyName	PO Box Lobby
	POBoxDeviatingCityName	POBoxDeviatingCityName	PO Box City
	POBoxDeviatingRegion	POBoxDeviatingRegion	PO Region
	POBoxDeviatingCountry	POBoxDeviatingCountry	PO Box C/R
	DeliveryServiceTypeCode	DeliveryServiceTypeCode	Delvry Serv Type
	DeliveryServiceNumber	DeliveryServiceNumber	Delivery Service No.
	AddressTimeZone	AddressTimeZone	Time Zone
	CityFileTestStatus	CityFileTestStatus	Check Status
	AddressNonDeliverableReason	AddressNonDeliverableReason	Undeliverable
	PostBoxNonDeliverableReason	PostBoxNonDeliverableReason	Undeliverable
	FullName	FullName	Name
	CityName	CityName	Name
	DistrictName	DistrictName	District
	HomeCityName	HomeCityName	Different City
	PostalCode	PostalCode	Postal Code
	CompanyPostalCode	CompanyPostalCode	Company Post Cd
	StreetName	StreetName	Text
	StreetPrefixName	StreetPrefixName	Street 2
	AdditionalStreetPrefixName	AdditionalStreetPrefixName	Street 3
	StreetSuffixName	StreetSuffixName	Street 4
	HouseNumber	HouseNumber	House Number
	HouseNumberSupplementText	HouseNumberSupplementText	Supplement
	Building	Building	Building code
	Floor	Floor	Floor
	RoomNumber	RoomNumber	Room Number
	Country	Country	Venue: Ctry/Reg
	Region	Region	Venue Region
	BPCountyText	BPCountyText	County
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	TransportZone	TransportZone	Transport Zone
	Person	Person	Person/ Farm/ Field
	FormOfAddress	FormOfAddress	Title Key
	SearchTerm1	SearchTerm1	Search Term 1
	SearchTerm2	SearchTerm2	Search Term 2
	FirstName	FirstName	First Name
	LastName	LastName	Last Name
	BusinessPartnerBirthName	BusinessPartnerBirthName	Name at Birth
	MiddleName	MiddleName	Middle Name
	AdditionalLastName	AdditionalLastName	Other Last Name
	PersonFullName	PersonFullName	Full Name
	AcademicTitle	AcademicTitle	Academic Title
	AcademicTitle2	AcademicTitle2	2nd Academic
	LastNamePrefix	LastNamePrefix	Prefix Key
	LastNameSecondPrefix	LastNameSecondPrefix	2nd prefix
	BusinessPartnerSupplementName	BusinessPartnerSupplementName	Name Supplement
	BusinessPartnerNicknameLabel	BusinessPartnerNicknameLabel	Nickname
	Initials	Initials	Initials
	NameFormat	NameFormat	Name Format
	NameCountry	NameCountry	Country/Region
	BPFirstNameSearchHelp	BPFirstNameSearchHelp	Name2/First Nme
	BPLastNameSearchHelp	BPLastNameSearchHelp	Name 1/Last Nme
	MasterDataIsCurrent
	_BPProtectedAddress	_BPProtectedAddress
	_BusinessPartnerGov	_BusinessPartnerGov

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_BusPartScriptedPersAddrGov.
-- 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_BusPartScriptedPersAddrGov AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  AddressRepresentationCode,
  ValidityStartDate,
  ValidityEndDate,
  BusinessPartnerAddressUUID,
  CareOfName,
  AdditionalStreetSuffixName,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  CityFileTestStatus,
  AddressNonDeliverableReason,
  PostBoxNonDeliverableReason,
  FullName,
  CityName,
  DistrictName,
  HomeCityName,
  PostalCode,
  CompanyPostalCode,
  StreetName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  BPCountyText,
  TaxJurisdiction,
  TransportZone,
  Person,
  FormOfAddress,
  SearchTerm1,
  SearchTerm2,
  FirstName,
  LastName,
  BusinessPartnerBirthName,
  MiddleName,
  AdditionalLastName,
  PersonFullName,
  AcademicTitle,
  AcademicTitle2,
  LastNamePrefix,
  LastNameSecondPrefix,
  BusinessPartnerSupplementName,
  BusinessPartnerNicknameLabel,
  Initials,
  NameFormat,
  NameCountry,
  BPFirstNameSearchHelp,
  BPLastNameSearchHelp,
  cast( 'X' as abap_boolean preserving type ) AS MasterDataIsCurrent
FROM I_BusPartScriptedPersAddrProc
LEFT OUTER JOIN I_BusinessPartnerGov AS _BusinessPartnerGov ON MasterDataChangeProcess = _BusinessPartnerGov.MasterDataChangeProcess AND MDChgProcessStep = _BusinessPartnerGov.MDChgProcessStep AND MDChgProcessSrceSystem = _BusinessPartnerGov.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BusinessPartnerGov.MDChgProcessSrceObject  -- association [1..1]
LEFT OUTER JOIN I_BPProtectedAddressGov AS _BPProtectedAddress ON MasterDataChangeProcess = _BPProtectedAddress.MasterDataChangeProcess AND MDChgProcessStep = _BPProtectedAddress.MDChgProcessStep AND MDChgProcessSrceSystem = _BPProtectedAddress.MDChgProcessSrceSystem AND MDChgProcessSrceObject = _BPProtectedAddress.MDChgProcessSrceObject AND AddressNumber = _BPProtectedAddress.AddressNumber  -- association [0..1]
LEFT OUTER JOIN I_MasterDataChangeProcess AS _MasterDataChangeProcess ON MasterDataChangeProcess = _MasterDataChangeProcess.MasterDataChangeProcess  -- association [0..1]
-- UNION ALL with additional select branch(es): I_BusPartScriptedPersonAddress
;

Depth:

I_BusPartScriptedPersAddrGov view_entity

I_BusPartScriptedPersAddrProc view_entity
I_BusPartScriptedPersonAddress view

I_BusPartScriptedPersAddrGovTP view_entity