SAP Table BCA_US_BC_ADDR - Addresses Associated with Bank Cheques

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
BKKRS X BKK_BKKRS CHAR 3 4 0 TBKK01 Bank Area
PAORN X BKK_PAORN NUMC 7 12 0 Payment order number
PARTNER BU_PARTNER CHAR 19 10 0 Business Partner Number
TYPE BU_TYPE CHAR 29 1 0 Business partner category
TITLE AD_TITLE CHAR 30 4 0 TSAD3 Form-of-Address Key
TITLE_MEDI AD_TITLE_T CHAR 34 20 0 Form of address text
ADDRNUMBER AD_ADDRNUM CHAR 54 10 0 Address number
NAME_ORG1 BU_NAMEOR1 CHAR 64 40 0 Name 1 of organization
NAME_ORG2 BU_NAMEOR2 CHAR 104 40 0 Name 2 of organization
NAME_ORG3 BU_NAMEOR3 CHAR 144 40 0 Name 3 of organization
NAME_ORG4 BU_NAMEOR4 CHAR 184 40 0 Name 4 of organization
LEGAL_ENTY BU_LEGENTY CHAR 224 2 0 TB019 BP: Legal form of organization
NAME_LAST BU_NAMEP_L CHAR 226 40 0 Last name of business partner (person)
NAME_FIRST BU_NAMEP_F CHAR 266 40 0 First name of business partner (person)
TITLE_ACA1 AD_TITLE1 CHAR 306 4 0 Academic Title: Key
TITLE_ACA1_TXT AD_TITLE1T CHAR 310 20 0 Academic Title: Written Form
TITLE_ACA2 AD_TITLE2 CHAR 330 4 0 Second academic title (key)
TITLE_ACA2_TXT AD_TITLE2T CHAR 334 20 0 2nd academic title: written form
TITLE_ROYL AD_TITLES CHAR 354 4 0 Name supplement, e.g. noble title (key)
TITLE_ROYL_TXT AD_TITLEST CHAR 358 20 0 Name supplement, e.g. noble title (written form)
PREFIX1 AD_PREFIX CHAR 378 4 0 Name Prefix (Key)
PREFIX1_TXT AD_PREFIXT CHAR 382 20 0 Name prefix
PREFIX2 AD_PREFIX2 CHAR 402 4 0 2nd name prefix (key)
PREFIX2_TXT AD_PREFIXT CHAR 406 20 0 Name prefix
NAME1_TEXT BU_NAME1TX CHAR 426 80 0 Full Name
XSEXM BU_XSEXM CHAR 506 1 0 Selection: Business partner is male
XSEXF BU_XSEXF CHAR 507 1 0 Selection: Business partner is female
PARTGRPTYP BU_GRPTYP CHAR 508 4 0 Group type
NAME_GRP1 BU_NAMEGR1 CHAR 512 40 0 Name 1 (group)
NAME_GRP2 BU_NAMEGR2 CHAR 552 40 0 Name 2 (group)
CITY1 AD_CITY1 CHAR 592 40 0 City
CITY2 AD_CITY2 CHAR 632 40 0 District
CITY_CODE AD_CITYNUM CHAR 672 12 0 City code for city/street file
POST_CODE1 AD_PSTCD1 CHAR 684 10 0 City postal code
POST_CODE2 AD_PSTCD2 CHAR 694 10 0 PO Box postal code
POST_CODE3 AD_PSTCD3 CHAR 704 10 0 Company postal code (for large customers)
PO_BOX AD_POBX CHAR 714 10 0 PO Box
PO_BOX_LOC AD_POBXLOC CHAR 724 40 0 PO Box city
POSTALAREA AD_PSTLAR CHAR 764 15 0 (Not Supported) Post Delivery District
TRANSPZONE AD_TRNSPZN CHAR 779 10 0 Transportation zone
STREET AD_STREET CHAR 789 60 0 Street
STREETCODE AD_STRNUM CHAR 849 12 0 Street Number for City/Street File
STREETABBR AD_STRABBR CHAR 861 2 0 ADRSTRTYPE (Not Supported) Abbreviation of Street Name
HOUSE_NUM1 AD_HSNM1 CHAR 863 10 0 House Number
HOUSE_NUM2 AD_HSNM2 CHAR 873 10 0 House number supplement
COUNTRY LAND1 CHAR 883 3 0 T005 Country Key
LANGU SPRAS LANG 886 1 0 T002 Language Key
REGION REGIO CHAR 887 3 0 T005S Region (State, Province, County)
DEFLT_COMM AD_COMM CHAR 890 3 0 Communication Method (Key) (Business Address Services)
TEL_NUMBER AD_TLNMBR1 CHAR 893 30 0 First telephone no.: dialling code+number
TEL_EXTENS AD_TLXTNS1 CHAR 923 10 0 First Telephone No.: Extension
FAX_NUMBER AD_FXNMBR1 CHAR 933 30 0 First fax no.: dialling code+number
FAX_EXTENS AD_FXXTNS1 CHAR 963 10 0 First fax no.: extension