I_BusinessPartnerAddressProc

Core View: Bus Part Address (Process) | view: IBPADDRPROC | TRAN | Extraction: Not supported | Component: Consolidation & Mass Processing.
Tables used: BUT020_PRCBUT_ADRC_PRC
Column Name Description
MasterDataChangeProcess Master Data Change Process Identifier
MDChgProcessStep Master Data Change Process Step Number
MDChgProcessSrceSystem Source System
MDChgProcessSrceObject Master Data Consolidation: ID of a Source Objects
AddressNumber Address Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
StandardUsage Indicator: Address is standard address Show values
CityFileTestStatus City file test status Show values
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
BusinessPartnerAddressUUID GUID of a Business Partner Address SYSUUID
ValidityStartDate Validity Start of a Business Partner Address TZNTSTMPS
ValidityEndDate Validity End of a Business Partner Address TZNTSTMPS
FormOfAddress Form-of-Address Key AD_TITLE
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
CareOfName c/o name TEXT40
CityName City TEXT40
District District TEXT40
CityCode City code for city/street file CITY_CODE
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
POBox PO Box CHAR10
AddressPostBoxUnusable PO Box Address Undeliverable Flag AD_NO_USE
POBoxDeviatingCityName PO Box city TEXT40
POBoxDeviatingRegion Region for PO Box (Country/Region, State, Province, ...) REGIO
POBoxDeviatingCountry PO Box of Country/Region LAND1
TransportZone Transportation zone to or from which the goods are delivered ZONE
StreetName Street TEXT60
AddressStreetUnusable Street Address Undeliverable Flag AD_NO_USE
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
Country Country/Region Key LAND1
CorrespondenceLanguage Language Key SPRAS
Region Region (State, Province, County) REGIO
SearchTerm1 Search Term 1 CHAR20
SearchTerm2 Search Term 2 CHAR20
PrfrdCommMediumType Communication Method (Key) (Business Address Services) AD_COMM
PhoneNumber First telephone no.: dialling code+number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
CitySearch City name in Uppercase for Search Help CHAR25
StreetSearch Street Name in Uppercase for Search Help CHAR25
AddressTimeZone Address time zone TZNZONE
TaxJurisdiction Tax Jurisdiction AD_TXJCD
POBoxLobbyName PO Box Lobby TEXT40
DeliveryServiceTypeCode Type of Delivery Service AD_DELIVERY_SERVICE_TYPE
DeliveryServiceNumber Number of Delivery Service CHAR10
CountyCode County code for county CNTY_CODE
County County TEXT40
MDChgProcessSourceModified Indicator: Source Record modified MDC_SOURCE_MODIFIED