SAP ABAP Table BCA_US_BC_ADDR (Addresses Associated with Bank Cheques)
Hierarchy
☛
EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
⤷ IS-B-BCA (Application Component) Bank Customer Accounts
⤷ BCA_US (Package) BCA modification for US specific requirements
⤷ IS-B-BCA (Application Component) Bank Customer Accounts
⤷ BCA_US (Package) BCA modification for US specific requirements
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | BCA_US_BC_ADDR | Table Relationship Diagram |
Short Description | Addresses Associated with Bank Cheques |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | BKKRS | BKK_BKKRS | BKK_BKKRS | CHAR | 4 | 0 | Bank Area | * | |
3 | PAORN | BKK_PAORN | BKK_PAORN | NUMC | 12 | 0 | Payment order number | ||
4 | .INCLUDE | 0 | 0 | Information on Check Block: Address Data | |||||
5 | .INCLUDE | 0 | 0 | BCA: Name Data of a BP (for Bank Statement) | |||||
6 | .INCLUDE | 0 | 0 | BCA: General Data of a BP (for Bank Statement) | |||||
7 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
8 | TYPE | BU_TYPE | BU_TYPE | CHAR | 1 | 0 | Business partner category | ||
9 | TITLE | AD_TITLE | AD_TITLE | CHAR | 4 | 0 | Form-of-Address Key | * | |
10 | TITLE_MEDI | AD_TITLE_T | TEXT20 | CHAR | 20 | 0 | Form of address text | ||
11 | ADDRNUMBER | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
12 | .INCLUDE | 0 | 0 | BCA: Name Data of an Organization | |||||
13 | NAME_ORG1 | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
14 | NAME_ORG2 | BU_NAMEOR2 | BU_NAME | CHAR | 40 | 0 | Name 2 of organization | ||
15 | NAME_ORG3 | BU_NAMEOR3 | BU_NAME | CHAR | 40 | 0 | Name 3 of organization | ||
16 | NAME_ORG4 | BU_NAMEOR4 | BU_NAME | CHAR | 40 | 0 | Name 4 of organization | ||
17 | LEGAL_ENTY | BU_LEGENTY | BU_LEGENTY | CHAR | 2 | 0 | BP: Legal form of organization | * | |
18 | .INCLUDE | 0 | 0 | BCA: Name Data of a Natural Person | |||||
19 | NAME_LAST | BU_NAMEP_L | BU_NAME | CHAR | 40 | 0 | Last name of business partner (person) | ||
20 | NAME_FIRST | BU_NAMEP_F | BU_NAME | CHAR | 40 | 0 | First name of business partner (person) | ||
21 | TITLE_ACA1 | AD_TITLE1 | AD_TITLE1 | CHAR | 4 | 0 | Academic Title: Key | * | |
22 | TITLE_ACA1_TXT | AD_TITLE1T | TEXT20 | CHAR | 20 | 0 | Academic Title: Written Form | ||
23 | TITLE_ACA2 | AD_TITLE2 | AD_TITLE1 | CHAR | 4 | 0 | Second academic title (key) | * | |
24 | TITLE_ACA2_TXT | AD_TITLE2T | TEXT20 | CHAR | 20 | 0 | 2nd academic title: written form | ||
25 | TITLE_ROYL | AD_TITLES | AD_TITLES | CHAR | 4 | 0 | Name supplement, e.g. noble title (key) | * | |
26 | TITLE_ROYL_TXT | AD_TITLEST | TEXT20 | CHAR | 20 | 0 | Name supplement, e.g. noble title (written form) | ||
27 | PREFIX1 | AD_PREFIX | AD_PREFIX | CHAR | 4 | 0 | Name Prefix (Key) | * | |
28 | PREFIX1_TXT | AD_PREFIXT | TEXT20 | CHAR | 20 | 0 | Name prefix | ||
29 | PREFIX2 | AD_PREFIX2 | AD_PREFIX | CHAR | 4 | 0 | 2nd name prefix (key) | * | |
30 | PREFIX2_TXT | AD_PREFIXT | TEXT20 | CHAR | 20 | 0 | Name prefix | ||
31 | NAME1_TEXT | BU_NAME1TX | TEXT80 | CHAR | 80 | 0 | Full Name | ||
32 | XSEXM | BU_XSEXM | XFELD | CHAR | 1 | 0 | Selection: Business partner is male | ||
33 | XSEXF | BU_XSEXF | XFELD | CHAR | 1 | 0 | Selection: Business partner is female | ||
34 | .INCLUDE | 0 | 0 | CBP: General data (group of people) | |||||
35 | PARTGRPTYP | BU_GRPTYP | BU_GRPTYP | CHAR | 4 | 0 | Group type | TB025 | |
36 | NAME_GRP1 | BU_NAMEGR1 | BU_NAME | CHAR | 40 | 0 | Name 1 (group) | ||
37 | NAME_GRP2 | BU_NAMEGR2 | BU_NAME | CHAR | 40 | 0 | Name 2 (group) | ||
38 | CITY1 | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
39 | CITY2 | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
40 | CITY_CODE | AD_CITYNUM | CITY_CODE | CHAR | 12 | 0 | City code for city/street file | * | |
41 | POST_CODE1 | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
42 | POST_CODE2 | AD_PSTCD2 | CHAR10 | CHAR | 10 | 0 | PO Box postal code | ||
43 | POST_CODE3 | AD_PSTCD3 | CHAR10 | CHAR | 10 | 0 | Company postal code (for large customers) | ||
44 | PO_BOX | AD_POBX | CHAR10 | CHAR | 10 | 0 | PO Box | ||
45 | PO_BOX_LOC | AD_POBXLOC | TEXT40 | CHAR | 40 | 0 | PO Box city | ||
46 | POSTALAREA | AD_PSTLAR | TEXT15 | CHAR | 15 | 0 | (Not Supported) Post Delivery District | ||
47 | TRANSPZONE | AD_TRNSPZN | ZONE | CHAR | 10 | 0 | Transportation zone | * | |
48 | STREET | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
49 | STREETCODE | AD_STRNUM | STRT_CODE | CHAR | 12 | 0 | Street Number for City/Street File | * | |
50 | STREETABBR | AD_STRABBR | STRTYPEAB | CHAR | 2 | 0 | (Not Supported) Abbreviation of Street Name | * | |
51 | HOUSE_NUM1 | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
52 | HOUSE_NUM2 | AD_HSNM2 | TEXT10 | CHAR | 10 | 0 | House number supplement | ||
53 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
54 | LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
55 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
56 | DEFLT_COMM | AD_COMM | AD_COMM | CHAR | 3 | 0 | Communication Method (Key) (Business Address Services) | * | |
57 | TEL_NUMBER | AD_TLNMBR1 | CHAR30 | CHAR | 30 | 0 | First telephone no.: dialling code+number | ||
58 | TEL_EXTENS | AD_TLXTNS1 | CHAR10 | CHAR | 10 | 0 | First Telephone No.: Extension | ||
59 | FAX_NUMBER | AD_FXNMBR1 | CHAR30 | CHAR | 30 | 0 | First fax no.: dialling code+number | ||
60 | FAX_EXTENS | AD_FXXTNS1 | CHAR10 | CHAR | 10 | 0 | First fax no.: extension |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BCA_US_BC_ADDR | PARTGRPTYP | TB025 | PARTGRPTYP | KEY | 1 | CN |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in | 463_20 |