SAP ABAP Table CRMT_BSP_CONTACT (BSP: Contact Person for Interface Layer)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP-PCU (Application Component) People-Centric UI (Business Partner)
     ⤷ CRM_BSP_MODEL_IL_BP (Package) Model Implementation: Business Partner
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_BSP_CONTACT   Table Relationship Diagram
Short Description BSP: Contact Person for Interface Layer    
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 ACCOUNT CRMT_BSP_ACCOUNT BU_PARTNER CHAR 10   0   Account ID *
2 PARTNER2 CRMT_CONTACT BU_PARTNER CHAR 10   0   Contact Person ID *
3 OBJECT_TYPE CRMT_SWO_OBJTYP_PROCESS CRM_OJ_NAME_PROCESS CHAR 10   0   Leading Business Transaction Category *
4 RELTYP BU_RELTYP BU_RELTYP CHAR 6   0   Business Partner Relationship Category *
5 VALIDFROMDATE BU_DATFROM DATUM DATS 8   0   Validity Date (Valid From)  
6 VALIDTODATE BU_DATTO DATUM DATS 8   0   Validity Date (Valid To)  
7 PARTNER2_USER SYUNAME SYCHAR12 CHAR 12   0   User Name  
8 PARTNER2_ADDR BU_ADDRESS_GUID SYSUUID RAW 16   0   GUID of a Business Partner Address  
9 XRF BU_XRF XFELD CHAR 1   0   Business partner role definition instead of BP relationship  
10 .INCLUDE       0   0   SAP BP, CP Rel.: BAPI Structure for Central Data  
11 FUNCTIONNAME BU_FNCTN TEXT40 CHAR 40   0   Function name of partner  
12 FUNCTION BU_PAFKT BU_PAFKT CHAR 4   0   Function of partner TB912
13 DEPARTMENTNAME BU_DPRTMNT TEXT40 CHAR 40   0   Department at business partner  
14 DEPARTMENT BU_ABTNR BU_ABTNR CHAR 4   0   Department TB910
15 AUTHORITY BU_PAAUTH BU_PAAUTH CHAR 1   0   Partner's Authority TB914
16 VIP BU_PAVIP BU_PAVIP CHAR 1   0   VIP Partner TB916
17 COMMENTS BU_PAREM TEXT40 CHAR 40   0   Notes for Partner  
18 TEL1_NUMBR AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
19 TEL1_EXT AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
20 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
21 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
22 E_MAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
23 DEFAULTRELATIONSHIP BU_XDFREL XFELD CHAR 1   0   Standard Relationship  
24 TEL2_NUMBR COMT_BSP_BP_TEL2_NUMBR CHAR30 CHAR 30   0   Second Telephone Number: Code + Extension  
25 TEL2_EXT AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
26 .INCLUDE       0   0   General BP Data, Independent of Business Partner Category  
27 SEARCHTERM1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
28 SEARCHTERM2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
29 PARTNERTYPE BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
30 AUTHORIZATIONGROUP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
31 PARTNERLANGUAGE BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
32 PARTNERLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
33 DATAORIGINTYPE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types TB005
34 CENTRALARCHIVINGFLAG BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
35 CENTRALBLOCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
36 TITLE_KEY AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
37 CONTACTALLOWANCE BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
38 PARTNEREXTERNAL BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
39 TITLELETTER BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
40 NOTRELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
41 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
42 PRINT_MODE BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
43 .INCLUDE       0   0   SAP BP: BAPI Structure for Personal Data  
44 FIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
45 LASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
46 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
47 MIDDLENAME BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
48 SECONDNAME BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
49 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
50 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
51 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
52 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
53 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
54 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
55 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
56 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
57 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
58 NAMCOUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
59 SEX BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
60 BIRTHPLACE BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
61 BIRTHDATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
62 DEATHDATE BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
63 MARITALSTATUS BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
64 CORRESPONDLANGUAGE BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
65 CORRESPONDLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
66 FULLNAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
67 EMPLOYER BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
68 OCCUPATION BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group *
69 NATIONALITY BU_NATIO LAND1 CHAR 3   0   Nationality *
70 NATIONALITYISO INTCA INTCA CHAR 2   0   Country ISO code  
71 COUNTRYORIGIN BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies *
72 STANDARDADDRESS BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
73 BUILDING_P AD_BLDNG_P TEXT10 CHAR 10   0   Building (number or code)  
74 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
75 ROOM_NO AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
76 INITS_SIG AD_ID_CODE TEXT10 CHAR 10   0   Short name for correspondence  
77 INHOUSE_ML AD_IH_MAIL TEXT10 CHAR 10   0   Int. mail postal code  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BSP_CONTACT AUTHORITY TB914 PAAUTH REF 1 CN
2 CRMT_BSP_CONTACT CORRESPONDLANGUAGE T002 SPRAS REF C CN
3 CRMT_BSP_CONTACT DATAORIGINTYPE TB005 SOURCE KEY 1 CN
4 CRMT_BSP_CONTACT DEPARTMENT TB910 ABTNR REF 1 CN
5 CRMT_BSP_CONTACT FUNCTION TB912 PAFKT REF 1 CN
6 CRMT_BSP_CONTACT MARITALSTATUS TB027 MARST 1 CN
7 CRMT_BSP_CONTACT NAMCOUNTRY T005 LAND1 REF C CN
8 CRMT_BSP_CONTACT NAMEFORMAT T005N NAMEFORMAT REF C CN
9 CRMT_BSP_CONTACT PARTNERLANGUAGE T002 SPRAS REF 1 CN
10 CRMT_BSP_CONTACT PARTNERTYPE TB004 BPKIND REF 1 CN
11 CRMT_BSP_CONTACT PREFIX1 TSAD4 PREFIX_KEY    
12 CRMT_BSP_CONTACT PREFIX2 TSAD4 PREFIX_KEY    
13 CRMT_BSP_CONTACT TITLE_ACA1 TSAD2 TITLE_KEY    
14 CRMT_BSP_CONTACT TITLE_ACA2 TSAD2 TITLE_KEY    
15 CRMT_BSP_CONTACT TITLE_KEY TSAD3 TITLE REF    
16 CRMT_BSP_CONTACT TITLE_SPPL TSAD5 TITLE_KEY    
17 CRMT_BSP_CONTACT VIP TB916 PAVIP REF 1 CN
History
Last changed by/on SAP  20140117 
SAP Release Created in 310