Fclm_Bm_Contacts

Contact person for bank | view: VFCLM_BM_CONTACT | Extraction: Not supported | Component: Bank Account Management
Tables used: ADCP, ADRC, BUT000, BUT020, BUT051, BUT100, FCLM_BAM_BNKABP2, TB911, TB913, TSAD3, ADCP, ADRC, ADR6, ADR3, ADR2, BNKA, BUT000, T005T
Column Name Description
BusinessPartnerNo FK Business Partner Number
ContactPersonNo Business Partner Number
RELNR FK BP Relationship Number
BankCountry FK Country/Region Key of Bank
BankInternalId FK Bank Keys
Column Name Description
Column Name Description
Column Name Description
BIRTHDT Date of Birth of Business Partner
Column Name Description
Column Name Description Domain name
BankName Name of Financial Institution TEXT60
CountryName Country/Region Name TEXT50
Title Form-of-Address Key AD_TITLE
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
TelephoneNumber Telephone no.: dialling code+number CHAR30
MobileNumber Telephone no.: dialling code+number CHAR30
FaxNumber Fax number: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
Street Street TEXT60
HouseNumber House Number TEXT10
AddressCity City TEXT40
PostalCode City postal code CHAR10
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
FunctionName Description TEXT30
DepartmentName Description TEXT20
BusinessPartnerFullName null
ContactBusinessNoFullname null
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Client
  • FCLM_BM_CONTACTS.ADDRESSCOUNTRY == T005.LAND1
  • FCLM_BM_CONTACTS.MANDT == T005.MANDT
Address Number
  • ?
  • ?
  • Address Number
  • Client
  • FCLM_BM_CONTACTS.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • FCLM_BM_CONTACTS.[column in domain "AD_NATION"] == ADRC.NATION
  • FCLM_BM_CONTACTS.ADDRESSID == ADRC.ADDRNUMBER
  • FCLM_BM_CONTACTS.MANDT == ADRC.CLIENT
Country/Region Key of Bank
  • Client
  • Bank Keys
  • Country/Region Key of Bank
  • FCLM_BM_CONTACTS.MANDT == BNKA.MANDT
  • FCLM_BM_CONTACTS.BANKINTERNALID == BNKA.BANKL
  • FCLM_BM_CONTACTS.BANKCOUNTRY == BNKA.BANKS
Bank Keys
  • Client
  • Bank Keys
  • Country/Region Key of Bank
  • FCLM_BM_CONTACTS.MANDT == BNKA.MANDT
  • FCLM_BM_CONTACTS.BANKINTERNALID == BNKA.BANKL
  • FCLM_BM_CONTACTS.BANKCOUNTRY == BNKA.BANKS
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • FCLM_BM_CONTACTS.BUSINESSPARTNERNO == BUT000.PARTNER
  • FCLM_BM_CONTACTS.CONTACTPERSONNO == BUT000.PARTNER
  • FCLM_BM_CONTACTS.MANDT == BUT000.CLIENT
Department
  • Department
  • Client
  • FCLM_BM_CONTACTS.DEPARTMENT == TB910.ABTNR
  • FCLM_BM_CONTACTS.MANDT == TB910.CLIENT
Function of partner
  • Function of partner
  • Client
  • FCLM_BM_CONTACTS.FUNCTION == TB912.PAFKT
  • FCLM_BM_CONTACTS.MANDT == TB912.CLIENT
Key of person
  • ?
  • Person Number
  • ?
  • Client
  • FCLM_BM_CONTACTS.[column in domain "AD_DATE_FR"] == ADRP.DATE_FROM
  • FCLM_BM_CONTACTS.PERSNUMBER == ADRP.PERSNUMBER
  • FCLM_BM_CONTACTS.[column in domain "AD_NATION"] == ADRP.NATION
  • FCLM_BM_CONTACTS.MANDT == ADRP.CLIENT
BP Relationship Number
  • ?
  • ?
  • ?
  • Client
  • BP Relationship Number
  • FCLM_BM_CONTACTS.[column in domain "BU_DATTO"] == BUT050.DATE_TO
  • FCLM_BM_CONTACTS.[column in domain "BU_PARTNER"] == BUT050.PARTNER2
  • FCLM_BM_CONTACTS.[column in domain "BU_PARTNER"] == BUT050.PARTNER1
  • FCLM_BM_CONTACTS.MANDT == BUT050.CLIENT
  • FCLM_BM_CONTACTS.RELNR == BUT050.RELNR
BP Role
  • Client
  • BP Role
  • FCLM_BM_CONTACTS.MANDT == TB003.CLIENT
  • FCLM_BM_CONTACTS.ROLE == TB003.ROLE
Region code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • FCLM_BM_CONTACTS.ADDRESSCOUNTRY == T005S.LAND1
  • FCLM_BM_CONTACTS.MANDT == T005S.MANDT
  • FCLM_BM_CONTACTS.STATE == T005S.BLAND