SAP Table
CBPR CO-ABC: Activity Master Table
SAP table CBPR has 4 primary key fields being MANDT,KOKRS,PRZNR,DATBI.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
CBPR columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||
| KeyKOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |||||||||||||
| KeyPRZNR | Business Process | CHAR | 12 | 0 | CO_PRZNR | ||||||||||||||
| KeyDATBI | Valid To Date | DATS | 8 | 0 | DATBI | ||||||||||||||
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||||||||||||||
| ERFDT | Entered On | DATS | 8 | 0 | ERFDT | ||||||||||||||
| ERFNM | Entered By | CHAR | 12 | 0 | ERFNM | ||||||||||||||
| AENDT | Date of last change | DATS | 8 | 0 | AENDT | ||||||||||||||
| AENNM | Last Changed By | CHAR | 12 | 0 | AENNM | ||||||||||||||
| PRART | CO-OM-ABC: Business Process Category | CHAR | 4 | 0 | CBPL | CO_CBART_4 | |||||||||||||
| PRTYP | CO-ABC: Business Process Type | NUMC | 2 | 0 | CO_BPTYP | ||||||||||||||
| OBJNR | Object number | CHAR | 22 | 0 | ONR00 | J_OBJNR | |||||||||||||
| OWAER | Currency Key | CUKY | 5 | 0 | TCURC | OWAER | |||||||||||||
| VERAP | Person Responsible | CHAR | 20 | 0 | CO_VERAP | ||||||||||||||
| VERAP_USER | Person Responsible for Business Process | CHAR | 12 | 0 | USR02 | VERAP_USER | |||||||||||||
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |||||||||||||
| GSBER | Business Area | CHAR | 4 | 0 | TGSB | GSBER | |||||||||||||
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |||||||||||||
| PRCTR | Profit Center | CHAR | 10 | 0 | CEPC | PRCTR | |||||||||||||
| VKORG | Sales Organization | CHAR | 4 | 0 | TVKO | VKORG | |||||||||||||
| VTWEG | Distribution Channel | CHAR | 2 | 0 | TVTW | VTWEG | |||||||||||||
| SPART | Division | CHAR | 2 | 0 | TSPA | SPART | |||||||||||||
| PHINR | Standard Hierarchy Area | CHAR | 12 | 0 | CO_BPHINR | ||||||||||||||
| ATTRI | Business Process Attributes/CO Tasks | CHAR | 4 | 0 | CB_ATTRI | ||||||||||||||
| KOSTL | Cost Center | CHAR | 10 | 0 | * | KOSTL | |||||||||||||
| KHINR | Cost Center Group | CHAR | 15 | 0 | KSGRU | ||||||||||||||
| ATTR1 | First Business Process Attribute | CHAR | 24 | 0 | ABC_ATTRI1 | ||||||||||||||
| ATTR2 | Second Business Process Attribute | CHAR | 24 | 0 | ABC_ATTRI2 | ||||||||||||||
| BP_STAT | Indicator "Statistical Business Process" | CHAR | 1 | 0 | BP_STAT | ||||||||||||||
| TEMPLCLASS | Valid Environments | CHAR | 3 | 0 | COTPLCLASS | ABC_CLASS | |||||||||||||
| TEMPLATE | Template: Allocation of Business Processes | CHAR | 10 | 0 | COTPL | ABC_TEMPL_SBP | |||||||||||||
| TEMPL_BPP | Template for Formula Planning on Business Processes | CHAR | 10 | 0 | COTPL | ABC_TEMPL_BPP | |||||||||||||
| KALSM | Costing Sheet | CHAR | 6 | 0 | T683 | AUFKALSM | |||||||||||||
| PD_TASK_TP | Task Type | CHAR | 2 | 0 | * | PD_TASK_TP | |||||||||||||
| PD_TASK_ID | Task (ID of Task) | NUMC | 8 | 0 | * | PD_TASK_ID | |||||||||||||
| CBRKE | External Value Added Ranking (CO-OM-ABC) | NUMC | 2 | 0 | CBRK | CO_CBRKE | |||||||||||||
| CBRKI | Internal Value Added Ranking (CO-OM-ABC) | NUMC | 2 | 0 | CBRK | CO_CBRKI | |||||||||||||
| CBART | Business Process Attribute: Category | CHAR | 2 | 0 | CBAR | CO_CBART | |||||||||||||
| DRVTP | Business Process Attribute: Allocation Category (CO-OM-ABC) | CHAR | 3 | 0 | CBDT | CO_DRVTP | |||||||||||||
| CBAT | Business Process Attribute: Additional Attribute (CO-OM-ABC) | CHAR | 10 | 0 | CBAT | CO_CBAT | |||||||||||||
| WFD_ID | Number of workflow definition | CHAR | 10 | 0 | SWD_WFD_ID | ||||||||||||||
| VERSION | Version | CHAR | 4 | 0 | SWD_VERSIO | ||||||||||||||
| EXETYP | Workflow Type | CHAR | 1 | 0 | SWD_EXETYP | ||||||||||||||
|
|||||||||||||||||||
| LOGSYSTEM | Logical System | CHAR | 10 | 0 | TBDLS | LOGSYSTEM | |||||||||||||
| LEINH | Activity Unit (CO-OM-ABC) | UNIT | 3 | 0 | T006 | LEINH_ABC | |||||||||||||
| AUSEH | Output Unit | UNIT | 3 | 0 | T006 | AUSEH | |||||||||||||
| AUSFK | Output factor | DEC | 5 | 2 | AUSFK | ||||||||||||||
| VKSTA | Allocation Cost Element | CHAR | 10 | 0 | * | VKSTA | |||||||||||||
| TARKZ | Price Indicator: Calculate Allocation Price | CHAR | 3 | 0 | TKA10 | TARKZ | |||||||||||||
| TARKZ_I | Indicator: Actual Allocation Price | CHAR | 3 | 0 | TKA10 | CO_TARKZ_I | |||||||||||||
| YRATE | Price Calculation with Period-Based Average Prices | CHAR | 1 | 0 | CO_YRATE | ||||||||||||||
| LATYP | Allocation Category (CO-OM-ABC) | CHAR | 1 | 0 | LATYP_ABC | ||||||||||||||
| LATYPI | Variant Allocation Category in Actual (CO-OM-ABC) | CHAR | 1 | 0 | LATYPI_ABC | ||||||||||||||
| MANIST | Indicator: Confirm quantity manually in actual | CHAR | 1 | 0 | CO_MANIST | ||||||||||||||
| MANPLAN | Indicator: Plan quantity manually set. | CHAR | 1 | 0 | CO_MANPLAN | ||||||||||||||
| FIXVO | Predistribution of fixed costs for acty type/bus. process | CHAR | 1 | 0 | CO_FIXVO | ||||||||||||||
| FERC_IND | Regulatory indicator | CHAR | 4 | 0 | FERC_C7 | FE_IND | |||||||||||||
/ Relationships
CBPR foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| CBPR | AUSEH | T006 | Units of Measurement | MANDT |
| CBPR | BUKRS | T001 | Company Codes | BUKRS |
| CBPR | CBART | CBAR | Type of business process | MANDT |
| CBPR | CBAT | CBAT | Business Process Attribute | CBAT |
| CBPR | CBRKE | CBRK | Value-Added Ranking for Business Processes | MANDT |
| CBPR | CBRKI | CBRK | Value-Added Ranking for Business Processes | MANDT |
| CBPR | DRVTP | CBDT | Allocation type for business processes | MANDT |
| CBPR | FERC_IND | FERC_C7 | Regulatory indicators | MANDT |
| CBPR | FERC_IND | FERC_C7 | Regulatory indicators | IND |
| CBPR | GSBER | TGSB | Business Areas | MANDT |
| CBPR | GSBER | TGSB | Business Areas | GSBER |
| CBPR | KALSM | T683 | Pricing procedures | KAPPL |
| CBPR | KALSM | T683 | Pricing procedures | KALSM |
| CBPR | KOKRS | TKA01 | Controlling Areas | MANDT |
| CBPR | LEINH | T006 | Units of Measurement | MANDT |
| CBPR | LOGSYSTEM | TBDLS | Logical system | LOGSYS |
| CBPR | MANDT | T000 | Clients | MANDT |
| CBPR | OBJNR | ONR00 | General Object Number | MANDT |
| CBPR | OWAER | TCURC | Currency Codes | MANDT |
| CBPR | OWAER | TCURC | Currency Codes | WAERS |
| CBPR | PRART | CBPL | CO-OM-ABC: Customizing Table, Process Category Defaults | MANDT |
| CBPR | PRART | CBPL | CO-OM-ABC: Customizing Table, Process Category Defaults | PRART |
| CBPR | PRCTR | CEPC | Profit Center Master Data Table | PRCTR |
| CBPR | PRCTR | CEPC | Profit Center Master Data Table | DATBI |
| CBPR | PRCTR | CEPC | Profit Center Master Data Table | KOKRS |
| CBPR | SPART | TSPA | Organizational Unit: Sales Divisions | MANDT |
| CBPR | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| CBPR | TARKZ | TKA10 | Master Data Table, Price Indicators | MANDT |
| CBPR | TARKZ | TKA10 | Master Data Table, Price Indicators | TARKZ |
| CBPR | TARKZ_I | TKA10 | Master Data Table, Price Indicators | MANDT |
| CBPR | TARKZ_I | TKA10 | Master Data Table, Price Indicators | TARKZ |
| CBPR | TEMPLATE | COTPL | CO-ABC Template Master Data | MANDT |
| CBPR | TEMPLATE | COTPL | CO-ABC Template Master Data | KOKRS |
| CBPR | TEMPLATE | COTPL | CO-ABC Template Master Data | TEMPLATE |
| CBPR | TEMPLCLASS | COTPLCLASS | Template environments | CLASS |
| CBPR | TEMPL_BPP | COTPL | CO-ABC Template Master Data | MANDT |
| CBPR | TEMPL_BPP | COTPL | CO-ABC Template Master Data | KOKRS |
| CBPR | TEMPL_BPP | COTPL | CO-ABC Template Master Data | TEMPLATE |
| CBPR | VERAP_USER | USR02 | Logon Data (Kernel-Side Use) | BNAME |
| CBPR | VKORG | TVKO | Organizational Unit: Sales Organizations | MANDT |
| CBPR | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| CBPR | VTWEG | TVTW | Organizational Unit: Distribution Channels | MANDT |
| CBPR | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| CBPR | WERKS | T001W | Plants/Branches | MANDT |
| CBPR | WERKS | T001W | Plants/Branches | WERKS |