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