SAP ABAP Table COMT_BSP_BP_ADDR_DUPLICATE (BSP: Display Structure for Duplicates)
Hierarchy
☛ SAP_ABA (Software Component) Cross-Application Component
   ⤷ CA-GTF-PCU-BP (Application Component) Dialog People-Centric UI for Business Partner
     ⤷ COM_BSP_MODEL_IL_BP (Package) Central Parts of BP from the BSP Development
Basic Data
Table Category INTTAB    Structure 
Structure COMT_BSP_BP_ADDR_DUPLICATE   Table Relationship Diagram
Short Description BSP: Display Structure for Duplicates    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 OBJECT_KEY CRMT_BSP_OBJECTKEY   CHAR 100   0   Object Key  
2 BP_NAME1 COMT_BSP_BP_NAME1 BU_NAME CHAR 40   0   Name 1 / Last Name (Search Help Field 1)  
3 BP_NAME2 COMT_BSP_BP_NAME2 BU_NAME CHAR 40   0   Name 2 / First Name (Search Help Field 2)  
4 .INCLUDE       0   0   SAP BP: Return Structure for Address Duplicates in the BAPI  
5 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
6 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
7 PERCENTAGE AD_PERCENT DEC2_1 DEC 3   1   (Obsolete) Percentage: Similarity in Duplicate Check  
8 BUSINESSPARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
9 ADDRESSGUID BU_ADDRESS_GUID_BAPI SYSUUID_C CHAR 32   0   GUID of a BP Address in CHAR 32 Format for BAPIs  
10 PERCENT_COMPL AD_PERCNT3 DEC3_1 DEC 4   1   Percentage: Similarity in Duplicate Check  
11 .INCLUDE       0   0   SAP BP: BAPI Structure for Address Data  
12 STANDARDADDRESS BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
13 C_O_NAME AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
14 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
15 DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
16 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
17 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
18 POSTL_COD2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
19 POSTL_COD3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
20 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
21 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
22 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
23 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
24 PO_W_O_NO AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
25 PO_BOX_CIT AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
26 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
27 POBOX_CTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
28 PO_CTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
29 STREET AD_STREET TEXT60 CHAR 60   0   Street  
30 STR_ABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
31 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
32 HOUSE_NO2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
33 HOUSE_NO3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
34 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
35 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
36 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
37 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
38 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
39 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
40 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
41 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
42 COUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
43 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
44 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
45 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
46 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
47 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered *
48 LANGU SPRAS SPRAS LANG 1   0   Language Key *
49 LANGUISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
50 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
51 EXTADDRESSNUMBER BU_ADEXT BU_ADEXT CHAR 20   0   Address number in external system  
52 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag *
53 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag *
54 MOVE_DATE BU_MOVEDAT DATUM DATS 8   0   Date of Move  
55 MOVE_ADDRESS BU_MOVE_ADDR AD_ADDRNUM CHAR 10   0   Number of Move Target Address for Address Moves *
56 VALIDFROMDATE BU_DATFROM DATUM DATS 8   0   Validity Date (Valid From)  
57 VALIDTODATE BU_DATTO DATUM DATS 8   0   Validity Date (Valid To)  
58 MOVE_ADDR_GUID SYSUUID_C SYSUUID_C CHAR 32   0   UUID in character form  
59 CITY_NO AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file *
60 DISTRCT_NO AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file *
61 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
62 PBOXCIT_NO AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) *
63 STREET_NO AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File *
64 HOMECITYNO AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file *
65 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
66 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service *
67 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
68 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
69 COUNTY_NO AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county *
70 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
71 TOWNSHIP_NO AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township *
72 SEARCHTERM1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
73 SEARCHTERM2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
74 PARTNERTYPE BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
75 AUTHORIZATIONGROUP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
76 PARTNERLANGUAGE BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
77 PARTNERLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
78 DATAORIGINTYPE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types *
79 CENTRALARCHIVINGFLAG BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
80 CENTRALBLOCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
81 TITLE_KEY AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
82 CONTACTALLOWANCE BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
83 PARTNEREXTERNAL BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
84 TITLELETTER BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
85 NOTRELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
86 .INCLUDE       0   0   SAP BP: BAPI Structure for Personal Data  
87 FIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
88 LASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
89 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
90 MIDDLENAME BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
91 SECONDNAME BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
92 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
93 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
94 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
95 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
96 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
97 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
98 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
99 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
100 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
101 NAMCOUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
102 SEX BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
103 BIRTHPLACE BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
104 BIRTHDATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
105 DEATHDATE BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
106 MARITALSTATUS BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
107 CORRESPONDLANGUAGE BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
108 CORRESPONDLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
109 FULLNAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
110 EMPLOYER BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
111 OCCUPATION BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group *
112 NATIONALITY BU_NATIO LAND1 CHAR 3   0   Nationality *
113 NATIONALITYISO INTCA INTCA CHAR 2   0   Country ISO code  
114 COUNTRYORIGIN BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies *
115 .INCLUDE       0   0   SAP BP: BAPI Structure for Organization Data  
116 NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
117 NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
118 NAME3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
119 NAME4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
120 LEGALFORM BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
121 INDUSTRYSECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
122 FOUNDATIONDATE BU_FOUND_DAT DATUM DATS 8   0   Date organization founded  
123 LIQUIDATIONDATE BU_LIQUID_DAT   DATS 8   0   Liquidation date of organization  
124 LOC_NO_1 BBBNR NUM07 NUMC 7   0   International location number (part 1)  
125 LOC_NO_2 BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
126 CHK_DIGIT BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
127 LEGALORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization *
128 .INCLUDE       0   0   SAP BP: BAPI Structure for Group Data  
129 NAMEGROUP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
130 NAMEGROUP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
131 GROUPTYPE BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
132 .INCLUDE       0   0   Business Partner: Search Criteria for Communication  
133 CONSNO_TEL AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
134 TEL1_NUMBR AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
135 TEL1_EXT AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
136 TELEPHONE AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
137 CONSNO_FAX AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
138 FAX AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
139 FAX_EXT AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
140 FAX_NO AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
141 CONSNO_EMAIL AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
142 EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
143 CONSNO_URL AD_CONSNUM NUMC3 NUMC 3   0   Sequence Number  
144 URL BSP_AD_URISCR AD_URISCR CHAR 132   0   URL, for Example, Homepage or ftp Address  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 COMT_BSP_BP_ADDR_DUPLICATE CORRESPONDLANGUAGE T002 SPRAS REF C CN
2 COMT_BSP_BP_ADDR_DUPLICATE COUNTRY T005 LAND1 REF   C
3 COMT_BSP_BP_ADDR_DUPLICATE GROUPTYPE TB025 PARTGRPTYP 1 CN
4 COMT_BSP_BP_ADDR_DUPLICATE INDUSTRYSECTOR TB023 IND_SECTOR REF 1 CN
5 COMT_BSP_BP_ADDR_DUPLICATE LEGALFORM TB019 LEGAL_ENTY KEY 1 CN
6 COMT_BSP_BP_ADDR_DUPLICATE MARITALSTATUS TB027 MARST 1 CN
7 COMT_BSP_BP_ADDR_DUPLICATE NAMCOUNTRY T005 LAND1 REF C CN
8 COMT_BSP_BP_ADDR_DUPLICATE NAMEFORMAT T005N NAMEFORMAT REF C CN
9 COMT_BSP_BP_ADDR_DUPLICATE PARTNERLANGUAGE T002 SPRAS REF 1 CN
10 COMT_BSP_BP_ADDR_DUPLICATE PARTNERTYPE TB004 BPKIND REF 1 CN
11 COMT_BSP_BP_ADDR_DUPLICATE POBOX_CTRY T005 LAND1 REF C CN
12 COMT_BSP_BP_ADDR_DUPLICATE PO_BOX_REG T005S BLAND C CN
13 COMT_BSP_BP_ADDR_DUPLICATE PREFIX1 TSAD4 PREFIX_KEY    
14 COMT_BSP_BP_ADDR_DUPLICATE PREFIX2 TSAD4 PREFIX_KEY    
15 COMT_BSP_BP_ADDR_DUPLICATE REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
16 COMT_BSP_BP_ADDR_DUPLICATE REGION T005S BLAND REF   C
17 COMT_BSP_BP_ADDR_DUPLICATE STR_ABBR ADRSTRTYPE STRTYPEAB REF C CN
18 COMT_BSP_BP_ADDR_DUPLICATE TIME_ZONE TTZZ TZONE REF C CN
19 COMT_BSP_BP_ADDR_DUPLICATE TITLE_ACA1 TSAD2 TITLE_KEY    
20 COMT_BSP_BP_ADDR_DUPLICATE TITLE_ACA2 TSAD2 TITLE_KEY    
21 COMT_BSP_BP_ADDR_DUPLICATE TITLE_KEY TSAD3 TITLE REF    
22 COMT_BSP_BP_ADDR_DUPLICATE TITLE_SPPL TSAD5 TITLE_KEY    
History
Last changed by/on SAP  20141013 
SAP Release Created in 400