What is I_BusPartScriptedOrgAddrGov in SAP S/4HANA?

I_BusPartScriptedOrgAddrGov is a basic CDS view in SAP S/4HANA. Bus Partner Org Addr Vers for Gov It contains 107 fields.

Which tables does I_BusPartScriptedOrgAddrGov read from?

I_BusPartScriptedOrgAddrGov reads data from: I_BusPartScriptedOrgAddress, I_BusPartScriptedOrgAddrProc.

What VDM layer is I_BusPartScriptedOrgAddrGov?

I_BusPartScriptedOrgAddrGov is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_BusPartScriptedOrgAddrGov

DDL: I_BUSPARTSCRIPTEDORGADDRGOV Type: view_entity BASIC

107 Fields 2 Data Sources 3 Associations

Bus Partner Org Addr Vers for Gov

I_BusPartScriptedOrgAddrGov is a Basic CDS View that provides data about "Bus Partner Org Addr Vers for Gov" in SAP S/4HANA. It reads from 2 data sources (I_BusPartScriptedOrgAddress, I_BusPartScriptedOrgAddrProc) and exposes 107 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, AddressNumber. It has 3 associations to related views.

Data Sources (2)

Source	Alias	Join Type
I_BusPartScriptedOrgAddress	I_BusPartScriptedOrgAddress	union_all
I_BusPartScriptedOrgAddrProc	I_BusPartScriptedOrgAddrProc	from

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 Org 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	#BASIC	view

Fields (107)

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
	BusinessPartner	BusinessPartner	Issuing Authority
	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
	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
	BusinessPartnerName1	BusinessPartnerName1	Name
	BusinessPartnerName2	BusinessPartnerName2	Name 2
	BusinessPartnerName3	BusinessPartnerName3	Name 3
	BusinessPartnerName4	BusinessPartnerName4	Name 4
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	TransportZone	TransportZone	Transport Zone
	FormOfAddress	FormOfAddress	Title Key
	SearchTerm1	SearchTerm1	Search Term 1
	SearchTerm2	SearchTerm2	Search Term 2
	_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
	BusinessPartner	BusinessPartner	Issuing Authority
	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
	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
	BusinessPartnerName1	BusinessPartnerName1	Name
	BusinessPartnerName2	BusinessPartnerName2	Name 2
	BusinessPartnerName3	BusinessPartnerName3	Name 3
	BusinessPartnerName4	BusinessPartnerName4	Name 4
	TaxJurisdiction	TaxJurisdiction	Tax Jurisdiction
	TransportZone	TransportZone	Transport Zone
	FormOfAddress	FormOfAddress	Title Key
	SearchTerm1	SearchTerm1	Search Term 1
	SearchTerm2	SearchTerm2	Search Term 2
	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_BusPartScriptedOrgAddrGov.
-- 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_BusPartScriptedOrgAddrGov AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  AddressRepresentationCode,
  BusinessPartner,
  ValidityStartDate,
  ValidityEndDate,
  BusinessPartnerAddressUUID,
  CareOfName,
  AdditionalStreetSuffixName,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  DeliveryServiceTypeCode,
  DeliveryServiceNumber,
  AddressTimeZone,
  CityFileTestStatus,
  FullName,
  CityName,
  DistrictName,
  HomeCityName,
  PostalCode,
  CompanyPostalCode,
  StreetName,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  HouseNumber,
  HouseNumberSupplementText,
  Building,
  Floor,
  RoomNumber,
  Country,
  Region,
  BPCountyText,
  BusinessPartnerName1,
  BusinessPartnerName2,
  BusinessPartnerName3,
  BusinessPartnerName4,
  TaxJurisdiction,
  TransportZone,
  FormOfAddress,
  SearchTerm1,
  SearchTerm2,
  cast( 'X' as abap_boolean preserving type ) AS MasterDataIsCurrent
FROM I_BusPartScriptedOrgAddrProc
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_BusPartScriptedOrgAddress
;

Depth:

I_BusPartScriptedOrgAddrGov view_entity

I_BusPartScriptedOrgAddrProc view_entity
I_BusPartScriptedOrgAddress view

I_BusPartScriptedOrgAddrGovTP view_entity