I_BusinessPartnerAddressGov

DDL: I_BUSINESSPARTNERADDRESSGOV SQL: IBPADDRESSGOV Type: view COMPOSITE Package: MDC_BUPA_GOV_BO
89 Fields 3 Data Sources 3 Associations

Business Partner Address (Governance)

I_BusinessPartnerAddressGov is a Composite CDS View that provides data about "Business Partner Address (Governance)" in SAP S/4HANA. It reads from 3 data sources (I_Address, I_BusPartAddress, I_BusinessPartnerAddressProc) and exposes 89 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 (3)

SourceAliasJoin Type
I_Address BPAddressActive inner
I_BusPartAddress BPAddressLinkActive union_all
I_BusinessPartnerAddressProc I_BusinessPartnerAddressProc from

Associations (3)

CardinalityTargetAliasCondition
[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 (11)

NameValueLevelField
AbapCatalog.sqlViewName IBPADDRESSGOV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Business Partner Address (Governance) view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (89)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess Process ID
KEY MDChgProcessStep MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject MDChgProcessSrceObject Issuing Authority
KEY AddressNumber AddressNumber Ship-to address
BusinessPartner BusinessPartner Issuing Authority
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
BusinessPartnerAddressUUID BusinessPartnerAddressUUID UUID
CareOfName CareOfName c/o
HouseNumber HouseNumber House Number
StreetName StreetName Text
HouseNumberSupplementText HouseNumberSupplementText Supplement
DistrictName DistrictName District Court
PostalCode PostalCode Postal Code
CityName CityName Name
Country Country Venue: Ctry/Reg
Region Region Venue Region
AddressTimeZone AddressTimeZone Time Zone
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
TransportZone TransportZone Transport Zone
CompanyPostalCode CompanyPostalCode Company Post Cd
DeliveryServiceNumber DeliveryServiceNumber Delivery Service No.
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
CorrespondenceLanguage CorrespondenceLanguage Language
PrfrdCommMediumType PrfrdCommMediumType Comm. Method
StreetPrefixName StreetPrefixName Street 2
AdditionalStreetPrefixName AdditionalStreetPrefixName Street 3
StreetSuffixName StreetSuffixName Street 4
AdditionalStreetSuffixName AdditionalStreetSuffixName Street 5
Building Building Building code
Floor Floor Floor
RoomNumber RoomNumber Room Number
HomeCityName HomeCityName Different City
DeliveryServiceTypeCode DeliveryServiceTypeCode Delvry Serv Type
MDChgProcessSourceModified MDChgProcessSourceModified Modified
CityFileTestStatus CityFileTestStatus Check Status
_BusinessPartnerGov _BusinessPartnerGov
KEY MDChgProcessStep Step Number
KEY MDChgProcessSrceSystem Source System
KEY MDChgProcessSrceObject I_BusPartAddress BusinessPartner Issuing Authority
KEY AddressNumber I_BusPartAddress AddressID Ship-to address
BusinessPartner I_BusPartAddress BusinessPartner Issuing Authority
ValidityStartDate I_BusPartAddress ValidityStartDate Validity Start Date
ValidityEndDate I_BusPartAddress ValidityEndDate ValidTo
BusinessPartnerAddressUUID I_BusPartAddress AddressUUID UUID
CareOfName I_Address CareOfName c/o
HouseNumber I_Address HouseNumber House Number
StreetName I_Address StreetName Text
HouseNumberSupplementText I_Address HouseNumberSupplementText Supplement
DistrictName I_Address District District Court
PostalCode I_Address PostalCode Postal Code
CityName I_Address CityName Name
Country I_Address Country Venue: Ctry/Reg
Region I_Address Region Venue Region
AddressTimeZone I_Address AddressTimeZone Time Zone
TaxJurisdiction I_Address TaxJurisdiction Tax Jurisdiction
TransportZone I_Address TransportZone Transport Zone
CompanyPostalCode I_Address CompanyPostalCode Company Post Cd
DeliveryServiceNumber I_Address DeliveryServiceNumber Delivery Service No.
POBox I_Address POBox PO Box
POBoxIsWithoutNumber I_Address POBoxIsWithoutNumber PO Box w/o No.
POBoxPostalCode I_Address POBoxPostalCode PO Box Postal Code
POBoxLobbyName I_Address POBoxLobbyName PO Box Lobby
POBoxDeviatingCityName I_Address POBoxDeviatingCityName PO Box City
POBoxDeviatingRegion I_Address POBoxDeviatingRegion PO Region
POBoxDeviatingCountry I_Address POBoxDeviatingCountry PO Box C/R
CorrespondenceLanguage I_Address CorrespondenceLanguage Language
PrfrdCommMediumType I_Address PrfrdCommMediumType Comm. Method
StreetPrefixName I_Address StreetPrefixName Street 2
AdditionalStreetPrefixName I_Address AdditionalStreetPrefixName Street 3
StreetSuffixName I_Address StreetSuffixName Street 4
AdditionalStreetSuffixName I_Address AdditionalStreetSuffixName Street 5
Building I_Address Building Building code
Floor I_Address Floor Floor
RoomNumber I_Address RoomNumber Room Number
HomeCityName I_Address HomeCityName Different City
DeliveryServiceTypeCode I_Address DeliveryServiceTypeCode Delvry Serv Type
MDChgProcessSourceModified Modified
CityFileTestStatus I_Address CityFileTestStatus Check Status
MasterDataIsCurrent
_BusinessPartnerGov _BusinessPartnerGov
_BPProtectedAddress _BPProtectedAddress

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_BusinessPartnerAddressGov.
-- 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.
-- SQL view name: IBPADDRESSGOV

CREATE VIEW I_BusinessPartnerAddressGov AS
SELECT
  MasterDataChangeProcess,
  MDChgProcessStep,
  MDChgProcessSrceSystem,
  MDChgProcessSrceObject,
  AddressNumber,
  BusinessPartner,
  ValidityStartDate,
  ValidityEndDate,
  BusinessPartnerAddressUUID,
  CareOfName,
  HouseNumber,
  StreetName,
  HouseNumberSupplementText,
  DistrictName,
  PostalCode,
  CityName,
  Country,
  Region,
  AddressTimeZone,
  TaxJurisdiction,
  TransportZone,
  CompanyPostalCode,
  DeliveryServiceNumber,
  POBox,
  POBoxIsWithoutNumber,
  POBoxPostalCode,
  POBoxLobbyName,
  POBoxDeviatingCityName,
  POBoxDeviatingRegion,
  POBoxDeviatingCountry,
  CorrespondenceLanguage,
  PrfrdCommMediumType,
  StreetPrefixName,
  AdditionalStreetPrefixName,
  StreetSuffixName,
  AdditionalStreetSuffixName,
  Building,
  Floor,
  RoomNumber,
  HomeCityName,
  DeliveryServiceTypeCode,
  MDChgProcessSourceModified,
  CityFileTestStatus,
  cast( 'X' as abap_boolean preserving type ) AS MasterDataIsCurrent
FROM I_BusinessPartnerAddressProc
INNER JOIN I_Address AS BPAddressActive ON /* join condition not captured in parsed metadata */
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_BusPartAddress
;

Learn More