I_BusPartScriptedGroupAddress

International version of a business partner address | view: IBPSCRPTGRPADDR | Extraction: Not supported | Component: Business Partner RAP
Tables used: BUT000, BUT020, ADRC
Column Name Description
BusinessPartner FK Business Partner Number
AddressNumber FK Address Number
AddressRepresentationCode FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
Column Name Description
POBoxIsWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
ValidityStartDateTime Validity Start of a Business Partner Address TZNTSTMPS
ValidityEndDateTime Validity End of a Business Partner Address TZNTSTMPS
BusinessPartnerAddressUUID null
CareOfName c/o name TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
POBox PO Box CHAR10
POBoxPostalCode PO Box Postal Code CHAR10
POBoxLobbyName PO Box Lobby TEXT40
POBoxDeviatingCityName PO Box city TEXT40
DeliveryServiceNumber Number of Delivery Service CHAR10
FullName Full name of a party (Bus. Partner, Org. Unit, Doc. address) TEXT80
CityName City TEXT40
District District TEXT40
HomeCityName City (different from postal city) TEXT40
PostalCode City postal code CHAR10
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
County County TEXT40
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
TaxJurisdiction Tax Jurisdiction AD_TXJCD
SearchTerm1 Search Term 1 CHAR20
SearchTerm2 Search Term 2 CHAR20
Master Data Relations Join Conditions
Non-Delivery Reason
  • Client
  • Street Address Undeliverable Flag
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == TSAD12.CLIENT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.ADDRESSNONDELIVERABLEREASON == TSAD12.UNDELIVER
Address Number
  • Client
  • ?
  • Address Number
  • Version ID for International Addresses
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == ADRC.CLIENT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_BUSPARTSCRIPTEDGROUPADDRESS.ADDRESSNUMBER == ADRC.ADDRNUMBER
  • I_BUSPARTSCRIPTEDGROUPADDRESS.ADDRESSREPRESENTATIONCODE == ADRC.NATION
Version ID for International Addresses I_BUSPARTSCRIPTEDGROUPADDRESS.ADDRESSREPRESENTATIONCODE == TSADV.NATION
Address time zone
  • Client
  • Address time zone
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == TTZZ.CLIENT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Business Partner Number
  • Business Partner Number
  • Client
  • I_BUSPARTSCRIPTEDGROUPADDRESS.BUSINESSPARTNER == BUT000.PARTNER
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == BUT000.CLIENT
Language key I_BUSPARTSCRIPTEDGROUPADDRESS.CORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == T005.MANDT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.COUNTRY == T005.LAND1
Address Delivery service type text table
  • ?
  • Type of Delivery Service
  • I_BUSPARTSCRIPTEDGROUPADDRESS.[column in domain "SYMANDT"] == ADDRC_DELI_SERV.CLIENT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.DELIVERYSERVICETYPECODE == ADDRC_DELI_SERV.DELI_SERV_TYPE
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == TSAD3.CLIENT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.FORMOFADDRESS == TSAD3.TITLE
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • I_BUSPARTSCRIPTEDGROUPADDRESS.POBOXDEVIATINGCOUNTRY == T005.LAND1
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == T005.MANDT
Region for PO Box (Country/Region, State, Province, ...)
  • PO Box of Country/Region
  • Client
  • Region for PO Box (Country/Region, State, Province, ...)
  • I_BUSPARTSCRIPTEDGROUPADDRESS.POBOXDEVIATINGCOUNTRY == T005S.LAND1
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == T005S.MANDT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.POBOXDEVIATINGREGION == T005S.BLAND
Non-Delivery Reason
  • Client
  • PO Box Address Undeliverable Flag
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == TSAD12.CLIENT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.POSTBOXNONDELIVERABLEREASON == TSAD12.UNDELIVER
Communication Method I_BUSPARTSCRIPTEDGROUPADDRESS.PRFRDCOMMMEDIUMTYPE == TSAC.COMM_TYPE
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == T005S.MANDT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.REGION == T005S.BLAND
  • I_BUSPARTSCRIPTEDGROUPADDRESS.COUNTRY == T005S.LAND1
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • I_BUSPARTSCRIPTEDGROUPADDRESS.MANDT == TZONE.MANDT
  • I_BUSPARTSCRIPTEDGROUPADDRESS.COUNTRY == TZONE.LAND1
  • I_BUSPARTSCRIPTEDGROUPADDRESS.TRANSPORTZONE == TZONE.ZONE1