BCA_US_BC_ADDR

Addresses Associated with Bank Cheques | #masterdata | #language | Component: Bank Customer Accounts
Column Name Description
MANDT Client
BKKRS Bank Area
PAORN Payment order number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
TYPE Business Partner Category Show values
XSEXM Selection: Business partner is male Show values
XSEXF Selection: Business partner is female Show values
XSEXU Selection: Sex of business partner is not known Show values
Column Name Description Domain name
PARTNER Business Partner Number BU_PARTNER
TITLE Form-of-Address Key AD_TITLE
TITLE_MEDI Form of address text TEXT20
ADDRNUMBER Address Number AD_ADDRNUM
NAME_ORG1 Name 1 of organization BU_NAME
NAME_ORG2 Name 2 of organization BU_NAME
NAME_ORG3 Name 3 of organization BU_NAME
NAME_ORG4 Name 4 of organization BU_NAME
LEGAL_ENTY BP: Legal form of organization BU_LEGENTY
NAME_LAST Last name of business partner (person) BU_NAME
NAME_FIRST First name of business partner (person) BU_NAME
TITLE_ACA1 Academic Title: Key AD_TITLE1
TITLE_ACA1_TXT Academic Title: Written Form TEXT20
TITLE_ACA2 Second academic title (key) AD_TITLE1
TITLE_ACA2_TXT 2nd academic title: written form TEXT20
TITLE_ROYL Name supplement, e.g. noble title (key) AD_TITLES
TITLE_ROYL_TXT Name supplement, e.g. noble title (written form) TEXT20
PREFIX1 Name Prefix (Key) AD_PREFIX
PREFIX1_TXT Name prefix TEXT20
PREFIX2 2nd name prefix (key) AD_PREFIX
PREFIX2_TXT Name prefix TEXT20
NAME1_TEXT Full Name TEXT80
GENDER Sex of business partner (person) BU_SEXID
NAME_GRP1 Name 1 (group) BU_NAME
NAME_GRP2 Name 2 (group) BU_NAME
CITY1 City TEXT40
CITY2 District TEXT40
CITY_CODE City code for city/street file CITY_CODE
POST_CODE1 City postal code CHAR10
POST_CODE2 PO Box Postal Code CHAR10
POST_CODE3 Company Postal Code (for Large Customers) CHAR10
PO_BOX PO Box CHAR10
PO_BOX_LOC PO Box city TEXT40
POSTALAREA (Not Supported) Post Delivery District TEXT15
TRANSPZONE Transportation Zone ZONE
STREET Street TEXT60
STREETCODE Street Number for City/Street File STRT_CODE
STREETABBR (Not Supported) Abbreviation of Street Name STRTYPEAB
HOUSE_NUM1 House Number TEXT10
HOUSE_NUM2 House number supplement TEXT10
COUNTRY Country/Region Key LAND1
LANGU Language Key SPRAS
REGION Region (State, Province, County) REGIO
DEFLT_COMM Communication Method (Key) (Business Address Services) AD_COMM
TEL_NUMBER First telephone no.: dialling code+number CHAR30
TEL_EXTENS First Telephone No.: Extension CHAR10
FAX_NUMBER First Fax No.: Area Code + Number CHAR30
FAX_EXTENS First fax no.: extension CHAR10
Master Data Relations Join Conditions
Group type
  • Group type
  • Client
  • BCA_US_BC_ADDR.PARTGRPTYP == TB025.PARTGRPTYP
  • BCA_US_BC_ADDR.MANDT == TB025.CLIENT