SAP ABAP Table CCHRS_PARTNERDATA (EHS-INT: Business Partner Data - General Data)
Hierarchy
SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   EHS (Application Component) Environment, Health and Safety
     CBHR (Package) EH&S: Interface Development HR/EHS
Basic Data
Table Category INTTAB    Structure 
Structure CCHRS_PARTNERDATA   Table Relationship Diagram
Short Description EHS-INT: Business Partner Data - General Data    
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 BU_PARTNER BU_PARTNER CHAR 10   0   Business Partner Number *
2 ADDRNUMBER AD_ADDRNUM AD_ADDRNUM CHAR 10   0   Address number *
3 .INCLUDE       0   0   BP: General Data I (Data Fields - External)  
4 .INCLUDE       0   0   CBP: General data (independent of partner cat.)  
5 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Initial Screen  
6 TYPE BU_TYPE BU_TYPE CHAR 1   0   Business partner category  
7 BPKIND BU_BPKIND BU_KIND CHAR 4   0   Business Partner Type TB004
8 BU_GROUP BU_GROUP BU_GROUP CHAR 4   0   Business Partner Grouping TB001
9 BPEXT BU_BPEXT CHAR20 CHAR 20   0   Business Partner Number in External System  
10 .INCLUDE       0   0   CBP: General Data (not dep. on Part. Cat.), Data Screens  
11 BU_SORT1 BU_SORT1 BU_SORT1 CHAR 20   0   Search term 1 for business partner  
12 BU_SORT2 BU_SORT2 BU_SORT1 CHAR 20   0   Search term 2 for business partner  
13 SOURCE BU_SOURCE BU_SOURCE CHAR 4   0   Data Origin Types TB005
14 TITLE AD_TITLE AD_TITLE CHAR 4   0   Form-of-Address Key TSAD3
15 XDELE BU_XDELE XFELD CHAR 1   0   Central Archiving Flag  
16 XBLCK BU_XBLCK XFELD CHAR 1   0   Central Block for Business Partner  
17 AUGRP BU_AUGRP BU_AUGRP CHAR 4   0   Authorization Group *
18 TITLE_LET BU_TITLE_LET TEXT50 CHAR 50   0   Salutation  
19 BU_LOGSYS LOGSYS LOGSYS CHAR 10   0   Logical system TBDLS
20 CONTACT BU_CONTACT BU_CONTACT CHAR 1   0   Business Partner: Contact Permission  
21 NOT_RELEASED BU_XNOT_RELEASED XFELD CHAR 1   0   Indicator: Not Released  
22 NOT_LG_COMPETENT BU_NOT_LEG_COMPETENT BOOLE CHAR 1   0   Indicator: Not Legally Competent  
23 PRINT_MODE BU_PRINT_MODE BU_PRINT_MODE CHAR 1   0   Business Partner Print Format  
24 .INCLUDE       0   0   EEW Extension of BUT000 (Contains CI)  
25 BP_EEW_DUMMY DUMMY DUMMY CHAR 1   0   Dummy function in length 1  
26 .INCLUDE       0   0    
27 .INCLU--AP       0   0   Cost/Revenue Type in Resource Role  
28 RATE DPR_TV_RATE DPR_RATE_TYPE CHAR 15   0   Cost Rate/Revenue Rate for Project Costing DPR_RATES
29 .INCLUDE       0   0   CBP: General data (Organization)  
30 .INCLUDE       0   0   CBP: General Data, Organization (CHAR Fields)  
31 NAME_ORG1 BU_NAMEOR1 BU_NAME CHAR 40   0   Name 1 of organization  
32 NAME_ORG2 BU_NAMEOR2 BU_NAME CHAR 40   0   Name 2 of organization  
33 NAME_ORG3 BU_NAMEOR3 BU_NAME CHAR 40   0   Name 3 of organization  
34 NAME_ORG4 BU_NAMEOR4 BU_NAME CHAR 40   0   Name 4 of organization  
35 LEGAL_ENTY BU_LEGENTY BU_LEGENTY CHAR 2   0   BP: Legal form of organization TB019
36 IND_SECTOR BU_INDSECT BU_INDSECT CHAR 10   0   Industry sector TB023
37 LEGAL_ORG BU_LEGAL_ORG BU_LEGAL_ORG CHAR 2   0   Legal Entity of Organization TB032
38 .INCLUDE       0   0   CBP: General Data, Organization (Non CHAR Fields)  
39 FOUND_DAT BU_FOUND_DAT DATUM DATS 8   0   Date organization founded  
40 LIQUID_DAT BU_LIQUID_DAT   DATS 8   0   Liquidation date of organization  
41 LOCATION_1 BBBNR NUM07 NUMC 7   0   International location number (part 1)  
42 LOCATION_2 BBSNR NUM05 NUMC 5   0   International location number (Part 2)  
43 LOCATION_3 BUBKZ NUM01 NUMC 1   0   Check digit for the international location number  
44 .INCLUDE       0   0   CBP: General Data, Person  
45 .INCLUDE       0   0   CBP: General Data, Person (CHAR Fields)  
46 NAME_LAST BU_NAMEP_L BU_NAME CHAR 40   0   Last name of business partner (person)  
47 NAME_FIRST BU_NAMEP_F BU_NAME CHAR 40   0   First name of business partner (person)  
48 NAME_LST2 BU_NAMEPL2 BU_NAME CHAR 40   0   Other Last Name of a Person  
49 NAME_LAST2 BU_BIRTHNM BU_NAME CHAR 40   0   Name at birth of business partner  
50 NAMEMIDDLE BU_NAMEMID BU_NAME CHAR 40   0   Middle name or second forename of a person  
51 TITLE_ACA1 AD_TITLE1 AD_TITLE1 CHAR 4   0   Academic Title: Key TSAD2
52 TITLE_ACA2 AD_TITLE2 AD_TITLE1 CHAR 4   0   Second academic title (key) TSAD2
53 TITLE_ROYL AD_TITLES AD_TITLES CHAR 4   0   Name supplement, e.g. noble title (key) TSAD5
54 PREFIX1 AD_PREFIX AD_PREFIX CHAR 4   0   Name Prefix (Key) TSAD4
55 PREFIX2 AD_PREFIX2 AD_PREFIX CHAR 4   0   2nd name prefix (key) TSAD4
56 NAME1_TEXT BU_NAME1TX TEXT80 CHAR 80   0   Full Name  
57 NICKNAME BU_NICKNAM BU_NAME CHAR 40   0   Nickname of Business Partner (Person)  
58 INITIALS AD_INITS CHAR10 CHAR 10   0   "Middle Initial" or personal initials  
59 NAMEFORMAT AD_FORMAT AD_NAMFORM CHAR 2   0   Name format T005N
60 NAMCOUNTRY AD_NAMCTRY LAND1 CHAR 3   0   Country for name format rule T005
61 LANGU_CORR BU_LANGU_CORR SPRAS LANG 1   0   Business Partner: Correspondence Language T002
62 XSEXM BU_XSEXM XFELD CHAR 1   0   Selection: Business partner is male  
63 XSEXF BU_XSEXF XFELD CHAR 1   0   Selection: Business partner is female  
64 BIRTHPL BU_BIRTHPL TEXT40 CHAR 40   0   Birthplace of business partner  
65 MARST BU_MARST BU_MARST CHAR 1   0   Marital Status of Business Partner TB027
66 EMPLO BU_EMPLO BU_EMPLO CHAR 35   0   Name of Employer of a Natural Person  
67 JOBGR BU_JOBGR BU_JOBGR CHAR 4   0   Occupation/group TB028
68 NATIO BU_NATIO LAND1 CHAR 3   0   Nationality T005
69 CNTAX BU_CNTAX LAND1 CHAR 3   0   Obsolete Field *
70 CNDSC BU_CNDSC LAND1 CHAR 3   0   Ctry of Origin: Non-Res. Companies T005
71 PERSNUMBER AD_PERSNUM AD_PERSNUM CHAR 10   0   Person number *
72 XSEXU BU_XSEXU XFELD CHAR 1   0   Selection: Sex of business partner is not known  
73 XUBNAME BU_XUBNAME XUBNAME CHAR 12   0   Obsolete Field USR02
74 BU_LANGU BU_LANGU SPRAS LANG 1   0   Business partner: Language T002
75 .INCLUDE       0   0   CBP: General Data, Person (Non CHAR Fields)  
76 BIRTHDT BU_BIRTHDT DATUM DATS 8   0   Date of Birth of Business Partner  
77 DEATHDT BU_DEATHDT DATUM DATS 8   0   Date of death of business partner  
78 PERNO BU_PERNO PERSONID NUMC 8   0   Personnel Number  
79 CHILDREN BU_CHILDREN NUMC2 NUMC 2   0   Obsolete Field  
80 MEM_HOUSE BU_MEM_HOUSE DEC2 DEC 2   0   Obsolete Field  
81 .INCLUDE       0   0   CBP: General data (group of people)  
82 PARTGRPTYP BU_GRPTYP BU_GRPTYP CHAR 4   0   Group type TB025
83 NAME_GRP1 BU_NAMEGR1 BU_NAME CHAR 40   0   Name 1 (group)  
84 NAME_GRP2 BU_NAMEGR2 BU_NAME CHAR 40   0   Name 2 (group)  
85 .INCLUDE       0   0   BP: General data II  
86 .INCLUDE       0   0   BP: General Data II (CHAR Fields)  
87 LGTYP BU_LGTYP BU_LGTYP CHAR 4   0   Legitimation Type TB029
88 LGNUM BU_LGNUM BU_LGNUM CHAR 16   0   Identification number of legitimation document  
89 INFCT BU_INFCT BU_INFCT CHAR 30   0   Responsible local court  
90 COMRG BU_COMRG CHAR30 CHAR 30   0   Entry in commercial register  
91 CLBRG BU_CLBRG CHAR30 CHAR 30   0   BP: Entry in register of associations  
92 COPRG BU_COPRG CHAR30 CHAR 30   0   Entry in Register of Cooperatives  
93 .INCLUDE       0   0   BP: General Data II (Non CHAR Fields)  
94 COMREG_DAT BU_COMREG_DAT DATUM DATS 8   0   Date of entry in trade register  
95 .INCLUDE       0   0   CBP: Name fields combined (lower case)  
96 NAME1 BU_NAME1 BU_NAME CHAR 40   0   Name field 1 (name1/last name)  
97 NAME2 BU_NAME2 BU_NAME CHAR 40   0   Name field 2 (name2/first name)  
98 .INCLUDE       0   0   BP: Address Data (Read)  
99 .INCLUDE       0   0   Include structure with ADRC attributes without name fields  
100 NAME_CO AD_NAME_CO TEXT40 CHAR 40   0   c/o name  
101 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
102 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
103 CITY_CODE AD_CITYNUM CITY_CODE CHAR 12   0   City code for city/street file ADRCITY
104 CITYP_CODE AD_CITYPNM CITYP_CODE CHAR 8   0   District code for City and Street file ADRCITYPRT
105 HOME_CITY AD_CITY3 TEXT40 CHAR 40   0   City (different from postal city)  
106 CITYH_CODE AD_CITYHNM CITY_CODE CHAR 12   0   Different city for city/street file ADRCITY
107 CHCKSTATUS AD_CHECKST AD_CHECKST CHAR 1   0   City file test status  
108 REGIOGROUP REGIOGROUP REGIOGROUP CHAR 8   0   Regional structure grouping ADRREGGRP
109 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
110 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
111 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
112 PCODE1_EXT AD_PST1XT CHAR10 CHAR 10   0   (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code  
113 PCODE2_EXT AD_PST2XT CHAR10 CHAR 10   0   (Not Supported) PO Box Postal Code Extension  
114 PCODE3_EXT AD_PST3XT CHAR10 CHAR 10   0   (Not Supported) Major Customer Postal Code Extension  
115 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
116 DONT_USE_P AD_NO_USEP AD_NO_USE CHAR 4   0   PO Box Address Undeliverable Flag TSAD12
117 PO_BOX_NUM AD_POBXNUM XFELD CHAR 1   0   Flag: PO Box without number  
118 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
119 CITY_CODE2 AD_CIT2NUM CITY_CODE CHAR 12   0   City PO box code (City file) ADRCITY
120 PO_BOX_REG AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
121 PO_BOX_CTY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
122 POSTALAREA AD_PSTLAR TEXT15 CHAR 15   0   (Not Supported) Post Delivery District  
123 TRANSPZONE LZONE ZONE CHAR 10   0   Transportation zone to or from which the goods are delivered TZONE
124 STREET AD_STREET TEXT60 CHAR 60   0   Street  
125 DONT_USE_S AD_NO_USES AD_NO_USE CHAR 4   0   Street Address Undeliverable Flag TSAD12
126 STREETCODE AD_STRNUM STRT_CODE CHAR 12   0   Street Number for City/Street File ADRSTREET
127 STREETABBR AD_STRABBR STRTYPEAB CHAR 2   0   (Not Supported) Abbreviation of Street Name ADRSTRTYPE
128 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
129 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
130 HOUSE_NUM3 AD_HSNM3 TEXT10 CHAR 10   0   (Not supported) House Number Range  
131 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
132 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
133 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
134 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
135 BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
136 FLOOR AD_FLOOR TEXT10 CHAR 10   0   Floor in building  
137 ROOMNUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
138 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key T005
139 LANGU SPRAS SPRAS LANG 1   0   Language Key T002
140 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
141 SORT1 AD_SORT1UL TEXT20 CHAR 20   0   Search Term 1  
142 SORT2 AD_SORT2UL TEXT20 CHAR 20   0   Search Term 2  
143 SORT_PHN AD_SRTPHN CHAR20 CHAR 20   0   (Not Supported) Phonetic Search Sort Field  
144 ADDRORIGIN AD_ORIGINA AD_ORIGIN CHAR 4   0   (Not Supported) Address Data Source (Key) TSAD6
145 EXTENSION1 AD_EXTENS1 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. data line)  
146 EXTENSION2 AD_EXTENS2 TEXT40 CHAR 40   0   Extension (only for data conversion) (e.g. telebox)  
147 TIME_ZONE AD_TZONE TZNZONE CHAR 6   0   Address time zone TTZZ
148 TAXJURCODE AD_TXJCD AD_TXJCD CHAR 15   0   Tax Jurisdiction  
149 ADDRESS_ID AD_ADDR_ID AD_ADDR_ID CHAR 10   0   (Not supported) Physical address ID  
150 REMARK AD_REMARK1 TEXT50 CHAR 50   0   Address notes  
151 LANGU_CREA AD_LANGUCR SPRAS LANG 1   0   Address record creation original language T002
152 PO_BOX_LOBBY AD_PO_BOX_LBY TEXT40 CHAR 40   0   PO Box Lobby  
153 DELI_SERV_TYPE AD_DELIVERY_SERVICE_TYPE AD_DELIVERY_SERVICE_TYPE CHAR 4   0   Type of Delivery Service ADDRC_DELI_SERV
154 DELI_SERV_NUMBER AD_DELIVERY_SERVICE_NUMBER CHAR10 CHAR 10   0   Number of Delivery Service  
155 COUNTY_CODE AD_CNTYNUM CNTY_CODE CHAR 8   0   County code for county ADRCOUNTY
156 COUNTY AD_COUNTY TEXT40 CHAR 40   0   County  
157 TOWNSHIP_CODE AD_TWSHPNUM TWSHP_CODE CHAR 8   0   Township code for Township ADRTOWNSHIP
158 TOWNSHIP AD_TOWNSHIP TEXT40 CHAR 40   0   Township  
159 DEFLT_COMM AD_DFLTCMM AD_COMTYPE CHAR 3   0   Standard communication type TSADC
160 TEL_NUMBER AD_TLNMBR CHAR30 CHAR 30   0   Telephone no.: dialling code+number  
161 TEL_EXTENS AD_TLXTNS CHAR10 CHAR 10   0   Telephone no.: Extension  
162 FAX_NUMBER AD_FXNMBR CHAR30 CHAR 30   0   Fax number: dialling code+number  
163 FAX_EXTENS AD_FXXTNS CHAR10 CHAR 10   0   Fax no.: Extension  
164 VALID_FROM BU_VALID_FROM_DATS DATUM DATS 8   0   Valid From  
165 VALID_TO BU_VALID_TO_DATS DATUM DATS 8   0   Valid To  
166 TITLETXT AD_TITLETX TEXT30 CHAR 30   0   Title text  
167 MARSTTXT BU_BEZ20 TEXT20 CHAR 20   0   Short name  
168 NATIOTXT NATIO TEXT15 CHAR 15   0   Nationality  
169 ACTITLETXT AD_TITLE1T TEXT20 CHAR 20   0   Academic Title: Written Form  
170 .INCLUDE       0   0   EHS-INT: Reserve Structure to Link into Other Structures  
171 RESEFLAG1 CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
172 RESEFLAG2 CHAR1 CHAR1 CHAR 1   0   Single-Character Flag  
173 RESEDOUBLE1 TEXT2 UDCHA2 CHAR 2   0   Text  
174 RESEDOUBLE2 TEXT2 UDCHA2 CHAR 2   0   Text  
175 RESETEXT1 TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
176 RESETEXT2 TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
177 RESETEXT3 TEXT30 TEXT30 CHAR 30   0   Text (30 Characters)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CCHRS_PARTNERDATA ADDRORIGIN TSAD6 ORIGIN REF C CN
2 CCHRS_PARTNERDATA BPKIND TB004 BPKIND REF 1 CN
3 CCHRS_PARTNERDATA BU_GROUP TB001 BU_GROUP REF 1 CN
4 CCHRS_PARTNERDATA BU_LANGU T002 SPRAS REF C CN
5 CCHRS_PARTNERDATA BU_LOGSYS TBDLS LOGSYS 1 CN
6 CCHRS_PARTNERDATA CITYH_CODE ADRCITY CITY_CODE REF C CN
7 CCHRS_PARTNERDATA CITYP_CODE ADRCITYPRT CITYP_CODE REF C CN
8 CCHRS_PARTNERDATA CITY_CODE ADRCITY CITY_CODE REF C CN
9 CCHRS_PARTNERDATA CITY_CODE2 ADRCITY CITY_CODE REF C CN
10 CCHRS_PARTNERDATA CNDSC T005 LAND1 REF 1 CN
11 CCHRS_PARTNERDATA COUNTRY T005 LAND1    
12 CCHRS_PARTNERDATA COUNTY_CODE ADRCOUNTY COUNTY_CODE REF C CN
13 CCHRS_PARTNERDATA DEFLT_COMM TSADC COMINT REF C CN
14 CCHRS_PARTNERDATA DELI_SERV_TYPE ADDRC_DELI_SERV DELI_SERV_TYPE 1 CN
15 CCHRS_PARTNERDATA DONT_USE_P TSAD12 UNDELIVER KEY C CN
16 CCHRS_PARTNERDATA DONT_USE_S TSAD12 UNDELIVER KEY C CN
17 CCHRS_PARTNERDATA IND_SECTOR TB023 IND_SECTOR REF 1 CN
18 CCHRS_PARTNERDATA JOBGR TB028 JOBGR REF 1 CN
19 CCHRS_PARTNERDATA LANGU T002 SPRAS KEY 1 CN
20 CCHRS_PARTNERDATA LANGU_CORR T002 SPRAS REF C CN
21 CCHRS_PARTNERDATA LANGU_CREA T002 SPRAS REF C CN
22 CCHRS_PARTNERDATA LEGAL_ENTY TB019 LEGAL_ENTY KEY 1 CN
23 CCHRS_PARTNERDATA LEGAL_ORG TB032 LEGAL_ORG REF 1 CN
24 CCHRS_PARTNERDATA LGTYP TB029 LGTYP    
25 CCHRS_PARTNERDATA MARST TB027 MARST 1 CN
26 CCHRS_PARTNERDATA NAMCOUNTRY T005 LAND1 REF C CN
27 CCHRS_PARTNERDATA NAMEFORMAT T005N NAMEFORMAT REF C CN
28 CCHRS_PARTNERDATA NATIO T005 LAND1 1 CN
29 CCHRS_PARTNERDATA PARTGRPTYP TB025 PARTGRPTYP KEY 1 CN
30 CCHRS_PARTNERDATA PO_BOX_CTY T005 LAND1 REF C CN
31 CCHRS_PARTNERDATA PO_BOX_REG T005S BLAND REF C CN
32 CCHRS_PARTNERDATA PREFIX1 TSAD4 PREFIX_KEY KEY 1 CN
33 CCHRS_PARTNERDATA PREFIX2 TSAD4 PREFIX_KEY KEY 1 CN
34 CCHRS_PARTNERDATA RATE DPR_RATES RATE KEY    
35 CCHRS_PARTNERDATA REGIOGROUP ADRREGGRP REGIOGROUP REF C CN
36 CCHRS_PARTNERDATA REGION T005S BLAND REF C CN
37 CCHRS_PARTNERDATA SOURCE TB005 SOURCE KEY 1 CN
38 CCHRS_PARTNERDATA STREETABBR ADRSTRTYPE STRTYPEAB REF C CN
39 CCHRS_PARTNERDATA STREETCODE ADRSTREET STRT_CODE REF C CN
40 CCHRS_PARTNERDATA TIME_ZONE TTZZ TZONE REF C CN
41 CCHRS_PARTNERDATA TITLE TSAD3 TITLE KEY 1 CN
42 CCHRS_PARTNERDATA TITLE_ACA1 TSAD2 TITLE_KEY KEY 1 CN
43 CCHRS_PARTNERDATA TITLE_ACA2 TSAD2 TITLE_KEY KEY 1 CN
44 CCHRS_PARTNERDATA TITLE_ROYL TSAD5 TITLE_KEY KEY 1 CN
45 CCHRS_PARTNERDATA TOWNSHIP_CODE ADRTOWNSHIP TOWNSHIP_CODE REF C CN
46 CCHRS_PARTNERDATA TRANSPZONE TZONE ZONE1 REF C CN
47 CCHRS_PARTNERDATA XUBNAME USR02 BNAME KEY 1 CN
History
Last changed by/on SAP  20141109 
SAP Release Created in