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