SAP ABAP Table CRMT_TREX_BP_RESULT (Result-Strukture TREX)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-BP (Application Component) Business Partners
     ⤷ CRM_BP_SPEEDY_TREX (Package) Speedy/TREX Integration
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_TREX_BP_RESULT   Table Relationship Diagram
Short Description Result-Strukture TREX    
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 PARTNER_GUID BU_PARTNER_GUID_32 SYSUUID_C CHAR 32   0   Business Partner GUID  
2 PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
3 RLTYP BU_RLTYP BU_RLTYP CHAR 6   0   BDT: Object part *
4 PARTN_GRP BU_GROUP BU_GROUP CHAR 4   0   Business Partner Grouping *
5 PARTN_TYP BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
6 .INCLUDE       0   0   General BP Data, Independent of Business Partner Category  
7 SEARCHTERM1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
8 SEARCHTERM2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
9 PARTNERTYPE BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
10 AUTHORIZATIONGROUP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
11 PARTNERLANGUAGE BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
12 PARTNERLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
13 DATAORIGINTYPE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types TB005
14 CENTRALARCHIVINGFLAG BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
15 CENTRALBLOCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
16 TITLE_KEY AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
17 CONTACTALLOWANCE BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
18 PARTNEREXTERNAL BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
19 TITLELETTER BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
20 NOTRELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
21 COMM_TYPE AD_COMM AD_COMM CHAR 3   0   Communication Method (Key) (Business Address Services) *
22 PRINT_MODE BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
23 .INCLUDE       0   0   SAP BP: BAPI Structure for Personal Data  
24 FIRSTNAME BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
25 LASTNAME BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
26 BIRTHNAME BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
27 MIDDLENAME BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
28 SECONDNAME BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
29 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
30 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
31 TITLE_SPPL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
32 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
33 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
34 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
35 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
36 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
37 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
38 NAMCOUNTRYISO INTCA INTCA CHAR 2   0   Country ISO code  
39 SEX BU_SEXID BU_SEXID CHAR 1   0   Sex of business partner (person)  
40 BIRTHPLACE BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
41 BIRTHDATE BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
42 DEATHDATE BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
43 MARITALSTATUS BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
44 CORRESPONDLANGUAGE BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
45 CORRESPONDLANGUAGEISO LAISO LAISO CHAR 2   0   2-Character SAP Language Code  
46 FULLNAME BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
47 EMPLOYER BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
48 OCCUPATION BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group *
49 NATIONALITY BU_NATIO LAND1 CHAR 3   0   Nationality *
50 NATIONALITYISO INTCA INTCA CHAR 2   0   Country ISO code  
51 COUNTRYORIGIN BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies *
52 .INCLUDE       0   0   SAP BP: BAPI Structure for Organization Data  
53 NAME1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
54 NAME2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
55 NAME3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
56 NAME4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
57 LEGALFORM BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
58 INDUSTRYSECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
59 FOUNDATIONDATE BU_FOUND_DAT DATUM DATS 8   0   Date organization founded  
60 LIQUIDATIONDATE BU_LIQUID_DAT   DATS 8   0   Liquidation date of organization  
61 LOC_NO_1 BBBNR NUM07 NUMC 7   0   International location number (part 1)  
62 LOC_NO_2 BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
63 CHK_DIGIT BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
64 LEGALORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization *
65 .INCLUDE       0   0   SAP BP: BAPI Structure for Group Data  
66 NAMEGROUP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
67 NAMEGROUP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
68 GROUPTYPE BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
69 .INCLUDE       0   0   Primary Address Attributes  
70 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
71 STANDARDADDRESS BU_XDFADR XFELD CHAR 1   0   Indicator: Address is standard address  
72 ADDRESS_GUID BU_ADDRESS_GUID SYSUUID RAW 16   0   GUID of a Business Partner Address  
73 ADDRESS_TYPE AD_ADRTYPE AD_ADRTYPE CHAR 1   0   Address type (1=Organization, 2=Person, 3=Contact person)  
74 COMPANY_PARTNER BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
75 ADDR_VERS AD_NATION AD_NATION CHAR 1   0   Version ID for International Addresses *
76 STREET AD_STREET TEXT60 CHAR 60   0   Street  
77 HOUSE_NO AD_HSNM1 TEXT10 CHAR 10   0   House Number  
78 POSTL_COD1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
79 CITY AD_CITY1 TEXT40 CHAR 40   0   City  
80 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) *
81 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key *
82 .INCLUDE       0   0   Contact Person Telephone Numbers  
83 P_COUNTRY AD_COMCTRY LAND1 CHAR 3   0   Country for telephone/fax number *
84 TELEPHONE AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
85 EXTENSION AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
86 CALLER_NO AD_TELNRCL CHAR30 CHAR 30   0   Telephone number for determining caller  
87 TELNR_LONG AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
88 .INCLUDE       0   0   Contact Person Telephone Numbers  
89 E_MAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
90 .INCLUDE       0   0   URI, for Example, Homepage, FTP Address  
91 URI_TYPE AD_URITYPE AD_URITYPE CHAR 3   0   URI type flag  
92 URI AD_URISCR AD_URISCR CHAR 132   0   URI, e.g. Homepage or ftp Address  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_TREX_BP_RESULT CORRESPONDLANGUAGE T002 SPRAS REF C CN
2 CRMT_TREX_BP_RESULT DATAORIGINTYPE TB005 SOURCE KEY 1 CN
3 CRMT_TREX_BP_RESULT GROUPTYPE TB025 PARTGRPTYP 1 CN
4 CRMT_TREX_BP_RESULT INDUSTRYSECTOR TB023 IND_SECTOR REF 1 CN
5 CRMT_TREX_BP_RESULT LEGALFORM TB019 LEGAL_ENTY KEY 1 CN
6 CRMT_TREX_BP_RESULT MARITALSTATUS TB027 MARST 1 CN
7 CRMT_TREX_BP_RESULT NAMCOUNTRY T005 LAND1 REF C CN
8 CRMT_TREX_BP_RESULT NAMEFORMAT T005N NAMEFORMAT REF C CN
9 CRMT_TREX_BP_RESULT PARTNERLANGUAGE T002 SPRAS REF 1 CN
10 CRMT_TREX_BP_RESULT PARTNERTYPE TB004 BPKIND REF 1 CN
11 CRMT_TREX_BP_RESULT PREFIX1 TSAD4 PREFIX_KEY    
12 CRMT_TREX_BP_RESULT PREFIX2 TSAD4 PREFIX_KEY    
13 CRMT_TREX_BP_RESULT TITLE_ACA1 TSAD2 TITLE_KEY    
14 CRMT_TREX_BP_RESULT TITLE_ACA2 TSAD2 TITLE_KEY    
15 CRMT_TREX_BP_RESULT TITLE_KEY TSAD3 TITLE REF    
16 CRMT_TREX_BP_RESULT TITLE_SPPL TSAD5 TITLE_KEY    
History
Last changed by/on SAP  20140117 
SAP Release Created in