I_BUSINESSPARTADDRESS_2
Business Partner Address
I_BUSINESSPARTADDRESS_2 is a CDS View in S/4HANA. Business Partner Address. It contains 37 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_BusinessPartnerAddressTP_2 | view_entity | from | TRANSACTIONAL | Business Partner Address |
Fields (37)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | AddressNumber | AddressIDForEdit,AddressNumber | 1 |
| KEY | BusinessPartner | BusinessPartner | 1 |
| AdditionalStreetPrefixName | AdditionalStreetPrefixName | 1 | |
| AdditionalStreetSuffixName | AdditionalStreetSuffixName | 1 | |
| AddressPostBoxUnusable | PostBoxNonDeliverableReason | 1 | |
| AddressStreetUnusable | AddressNonDeliverableReason | 1 | |
| AddressTimeZone | AddressTimeZone | 1 | |
| Building | Building | 1 | |
| CareOfName | CareOfName | 1 | |
| CityName | CityName | 1 | |
| CompanyPostalCode | CompanyPostalCode | 1 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 1 | |
| Country | Country | 1 | |
| County | BPCountyText,County | 1 | |
| DeliveryServiceNumber | DeliveryServiceNumber | 1 | |
| DeliveryServiceTypeCode | DeliveryServiceTypeCode | 1 | |
| District | District,DistrictName | 1 | |
| Floor | Floor | 1 | |
| HomeCityName | HomeCityName | 1 | |
| HouseNumber | HouseNumber | 1 | |
| HouseNumberSupplementText | HouseNumberSupplementText | 1 | |
| POBox | POBox | 1 | |
| POBoxDeviatingCityName | POBoxDeviatingCityName | 1 | |
| POBoxDeviatingCountry | POBoxDeviatingCountry | 1 | |
| POBoxDeviatingRegion | POBoxDeviatingRegion | 1 | |
| POBoxIsWithoutNumber | POBoxIsWithoutNumber | 1 | |
| POBoxLobbyName | POBoxLobbyName | 1 | |
| POBoxPostalCode | POBoxPostalCode | 1 | |
| PostalCode | PostalCode | 1 | |
| PrfrdCommMediumType | PrfrdCommMediumType | 1 | |
| Region | Region | 1 | |
| RoomNumber | RoomNumber | 1 | |
| StreetName | StreetName | 1 | |
| StreetPrefixName | StreetPrefixName | 1 | |
| StreetSuffixName | StreetSuffixName | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TransportZone | TransportZone | 1 |
@AbapCatalog.sqlViewName: 'IBPADDR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.privilegedAssociations: [ '_Address' ]
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Business Partner Address'
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
define view I_BusinessPartAddress_2
as select from but020 as BusinessPartnerAddress
inner join but000 on but000.partner = BusinessPartnerAddress.partner
association [1..1] to I_BusinessPartner as _BusinessPartner on $projection.BusinessPartner = _BusinessPartner.BusinessPartner
association [1..1] to I_Address_2 as _Address on $projection.AddressNumber = _Address.AddressID
and _Address.AddressRepresentationCode is initial
and $projection.PersonNumber = _Address.AddressPersonID
association [0..1] to I_BPProtectedAddress as _BPProtectedAddress on $projection.BusinessPartner = _BPProtectedAddress.BusinessPartner
and $projection.AddressNumber = _BPProtectedAddress.AddressID
// association [0..*] to I_BPDataControllerUsage as _BPDataControllerUsage on $projection.BusinessPartner = _BPDataControllerUsage.BusinessPartner
{
key BusinessPartnerAddress.partner as BusinessPartner,
key BusinessPartnerAddress.addrnumber as AddressNumber,
BusinessPartnerAddress.addr_valid_from as ValidityStartDate,
BusinessPartnerAddress.addr_valid_to as ValidityEndDate,
BusinessPartnerAddress.address_guid as BusinessPartnerAddressUUID,
BusinessPartnerAddress.move_addr as BPTargetAddressID,
BusinessPartnerAddress.addr_move_date as BPAddressMoveDateTime,
_Address.CareOfName,
_Address.FormOfAddress,
_Address.AddresseeFullName as FullName,
_Address.HouseNumber,
_Address.StreetName,
_Address.HouseNumberSupplementText,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'DistrictName'
_Address.DistrictName as District,
_Address.DistrictName as DistrictName,
_Address.PostalCode,
_Address.CityName,
_Address.Country,
_Address.Region,
_Address.AddressTimeZone,
_Address.TaxJurisdiction,
_Address.TransportZone,
_Address.CompanyPostalCode,
_Address.DeliveryServiceNumber,
_Address.POBox,
_Address.POBoxIsWithoutNumber,
_Address.POBoxPostalCode,
_Address.POBoxLobbyName,
_Address.POBoxDeviatingCityName,
_Address.POBoxDeviatingRegion,
_Address.POBoxDeviatingCountry,
_Address.CorrespondenceLanguage,
_Address.PrfrdCommMediumType,
_Address.StreetPrefixName1 as StreetPrefixName,
_Address.StreetPrefixName2 as AdditionalStreetPrefixName,
_Address.StreetSuffixName1 as StreetSuffixName,
_Address.StreetSuffixName2 as AdditionalStreetSuffixName,
_Address.VillageName as HomeCityName,
_Address.DeliveryServiceTypeCode,
_Address.StreetAddrNonDeliverableReason as AddressStreetUnusable,
_Address.POBoxAddrNonDeliverableReason as AddressPostBoxUnusable,
_Address.Building,
_Address.Floor,
_Address.RoomNumber,
@VDM.lifecycle.status: #DEPRECATED
@VDM.lifecycle.successor: 'BPCountyText'
_Address.SecondaryRegionName as County,
_Address.SecondaryRegionName as BPCountyText,
_Address.SecondaryRegion as CountyCode,
_Address.TertiaryRegion as TownshipCode,
_Address.TertiaryRegionName as TownshipName,
_Address.RegionalStructureCheckStatus as CityFileTestStatus,
_Address._CurrentDfltLandlinePhoneNmbr.PhoneAreaCodeSubscriberNumber as PhoneNumber,
_Address._CurrentDfltLandlinePhoneNmbr.PhoneNumberCountry as PhoneNumberCountry,
_Address._CurrentDfltLandlinePhoneNmbr.PhoneExtensionNumber as PhoneNumberExtension,
_Address._CurrentDfltFaxNumber.FaxAreaCodeSubscriberNumber as FaxNumber,
_Address._CurrentDfltFaxNumber.FaxNumberCountry as FaxCountry,
_Address._CurrentDfltFaxNumber.FaxExtensionNumber as FaxNumberExtension,
_Address._CurrentDfltMobilePhoneNumber.PhoneAreaCodeSubscriberNumber as MobilePhoneNumber,
_Address._CurrentDfltMobilePhoneNumber.PhoneNumberCountry as MobilePhoneCountry,
_Address._CurrentDfltEmailAddress.EmailAddress as EmailAddress,
cast ('00000' as abap.int2 ) as URLFieldLength,
_Address._MainWebsiteURL.UniformResourceIdentifier as WebsiteURL,
but000.persnumber as PersonNumber,
_Address,
_BusinessPartner,
_BPProtectedAddress
// _BPDataControllerUsage
}