Fclm_Bm_Address

Address data for bank master and business partner | view: VFCLM_BM_ADDRESS | Extraction: Not supported | Component: Bank Account Management
Tables used: ADCP, ADRC, ADR2, ADR3, ADR6, ADRCT, ADRREGGRPT, BNKA, BUT020, T005K, T005T, T005U, TSADVT, TTZZT, TZONT, TSAD12T, BUT000, TSAD3T, ADDRC_DELI_SERV, T002T
Column Name Description
AddressID Address Number
Nation FK Version ID for International Addresses
Column Name Description
Column Name Description
Column Name Description
Column Name Description
PoBoxWithoutNumber Flag: PO Box Without Number Show values
Column Name Description Domain name
NationText International address version name TEXT16
BankCountryName Country/Region Name TEXT50
BankInternalId Bank Keys BANKK
BankName Name of Financial Institution TEXT60
CareOfName c/o name TEXT40
AddressLine1 Street 2 TEXT40
AddressLine2 Street 3 TEXT40
HouseNumber House Number TEXT10
Street Street TEXT60
HouseNumberSupplement House number supplement TEXT10
AddressLine3 Street 4 TEXT40
AddressLine4 Street 5 TEXT40
Village City (different from postal city) TEXT40
District District TEXT40
PostalCode City postal code CHAR10
AddressCity City TEXT40
AddressCountryText Name of Country/Region (Short) TEXT15
StateText Description TEXT20
TimeZoneText Time Zone Text TEXT30
TransportationZoneText Description TEXT20
TaxJurisdiction Tax Jurisdiction AD_TXJCD
CompanyPostalCode Company Postal Code (for Large Customers) CHAR10
DeliveryServiceNumber Number of Delivery Service CHAR10
PoBox PO Box CHAR10
PoBoxPostalCode PO Box Postal Code CHAR10
PoBoxLobby PO Box Lobby TEXT40
PoBoxCity PO Box city TEXT40
PoBoxRegionText Description TEXT20
PoBoxCountryText Name of Country/Region (Short) TEXT15
Comments Address notes TEXT50
Name Name 1 TEXT40
Name2 Name 2 TEXT40
Name3 Name 3 TEXT40
Name4 Name 4 TEXT40
DataLine Extension (only for data conversion) (e.g. data line) TEXT40
TeleBox Extension (only for data conversion) (e.g. telebox) TEXT40
SearchTeam1 Search Term 1 CHAR20
SearchTeam2 Search Term 2 CHAR20
TownShip Township TEXT40
County County TEXT40
DeliveryServiceText Delivery Service Text TEXT40
CommunicationLanguageText Name of Language SPTXT16
TitleText Title text TEXT30
StructureGroupText Text Field TEXT50
StreetAddrUndeliverableFlagTxt Reason for Non-Delivery (Text) TEXT30
POBoxAddrUndeliverableFlagTxt Reason for Non-Delivery (Text) TEXT30
TelephoneDialingNumber null
TelephoneNumber Telephone no.: dialling code+number CHAR30
PhoneNumberExtension Telephone no.: Extension CHAR10
MobileDialingNumber null
MobileNumber Telephone no.: dialling code+number CHAR30
FaxDialingNumber null
FaxNumber Fax number: dialling code+number CHAR30
FaxNumberExtension Fax no.: Extension CHAR10
EmailAddress E-Mail Address AD_SMTPADR
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
RatingMethod null
RatingLevel null
BusinessPartnerFullName null
Master Data Relations Join Conditions
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • FCLM_BM_ADDRESS.TELEPHONENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.ADDRESSCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.FAXCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MOBILENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MANDT == T005.MANDT
Address group FCLM_BM_ADDRESS.ADDRESSGROUP == TSAD7.ADDR_GROUP
Address time zone
  • Client
  • Address time zone
  • FCLM_BM_ADDRESS.MANDT == TTZZ.CLIENT
  • FCLM_BM_ADDRESS.ADDRESSTIMEZONE == TTZZ.TZONE
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • FCLM_BM_ADDRESS.BANKCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MANDT == T005.MANDT
Business Partner Number
  • Client
  • Business Partner Number
  • FCLM_BM_ADDRESS.MANDT == BUT000.CLIENT
  • FCLM_BM_ADDRESS.BUSINESSPARTNERNO == BUT000.PARTNER
Language key FCLM_BM_ADDRESS.COMMUNICATIONLANGUAGE == T002.SPRAS
Address Delivery service type text table
  • Type of Delivery Service
  • ?
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • FCLM_BM_ADDRESS.TELEPHONENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.ADDRESSCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.FAXCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MOBILENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MANDT == T005.MANDT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • FCLM_BM_ADDRESS.TELEPHONENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.ADDRESSCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.FAXCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MOBILENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MANDT == T005.MANDT
Version ID for International Addresses FCLM_BM_ADDRESS.NATION == TSADV.NATION
Non-Delivery Reason
  • PO Box Address Undeliverable Flag
  • Client
  • FCLM_BM_ADDRESS.POBOXADDRESSUNDELIVERABLEFLAG == TSAD12.UNDELIVER
  • FCLM_BM_ADDRESS.MANDT == TSAD12.CLIENT
PO Box of Country/Region
  • PO Box of Country/Region
  • Client
  • FCLM_BM_ADDRESS.POBOXCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.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, ...)
  • FCLM_BM_ADDRESS.POBOXCOUNTRY == T005S.LAND1
  • FCLM_BM_ADDRESS.MANDT == T005S.MANDT
  • FCLM_BM_ADDRESS.POBOXREGION == T005S.BLAND
Region code
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Region (State, Province, County)
  • Client
  • FCLM_BM_ADDRESS.TELEPHONENUMBERCOUNTRY == T005S.LAND1
  • FCLM_BM_ADDRESS.ADDRESSCOUNTRY == T005S.LAND1
  • FCLM_BM_ADDRESS.FAXCOUNTRY == T005S.LAND1
  • FCLM_BM_ADDRESS.MOBILENUMBERCOUNTRY == T005S.LAND1
  • FCLM_BM_ADDRESS.STATE == T005S.BLAND
  • FCLM_BM_ADDRESS.MANDT == T005S.MANDT
Non-Delivery Reason
  • Street Address Undeliverable Flag
  • Client
  • FCLM_BM_ADDRESS.STREETADDRESSUNDELIVERABLEFLAG == TSAD12.UNDELIVER
  • FCLM_BM_ADDRESS.MANDT == TSAD12.CLIENT
Regional structure grouping
  • Regional structure grouping
  • Client
  • FCLM_BM_ADDRESS.STRUCTUREGROUP == ADRREGGRP.REGIOGROUP
  • FCLM_BM_ADDRESS.MANDT == ADRREGGRP.CLIENT
Country key
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • FCLM_BM_ADDRESS.TELEPHONENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.ADDRESSCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.FAXCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MOBILENUMBERCOUNTRY == T005.LAND1
  • FCLM_BM_ADDRESS.MANDT == T005.MANDT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • FCLM_BM_ADDRESS.MANDT == TSAD3.CLIENT
  • FCLM_BM_ADDRESS.TITLE == TSAD3.TITLE
Transportation zone to or from which the goods are delivered
  • Country/Region for Telephone/Fax Number
  • Country/Region Key
  • Country/Region for Telephone/Fax Number
  • Country/Region for Telephone/Fax Number
  • Client
  • Transportation zone to or from which the goods are delivered
  • FCLM_BM_ADDRESS.TELEPHONENUMBERCOUNTRY == TZONE.LAND1
  • FCLM_BM_ADDRESS.ADDRESSCOUNTRY == TZONE.LAND1
  • FCLM_BM_ADDRESS.FAXCOUNTRY == TZONE.LAND1
  • FCLM_BM_ADDRESS.MOBILENUMBERCOUNTRY == TZONE.LAND1
  • FCLM_BM_ADDRESS.MANDT == TZONE.MANDT
  • FCLM_BM_ADDRESS.TRANSPORTATIONZONE == TZONE.ZONE1