| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | KOKRS | Controlling Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 3 | PRZNR | Business Process | nvarchar | 12 | 0 | | | | Allow NULL? |
| 4 | DATBI | Valid To Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | DATAB | Valid-From Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ERFDT | Created on | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ERFNM | Entered by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 8 | AENDT | Date of last change | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | AENNM | Last changed by | nvarchar | 12 | 0 | | | | Allow NULL? |
| 10 | PRART | CO-OM-ABC: Business Process Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | PRTYP | CO-ABC: Business Process Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 12 | OBJNR | Object number | nvarchar | 22 | 0 | | | | Allow NULL? |
| 13 | OWAER | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 14 | VERAP | Person Responsible | nvarchar | 20 | 0 | | | | Allow NULL? |
| 15 | VERAP_USER | Person Responsible for Business Process | nvarchar | 12 | 0 | | | | Allow NULL? |
| 16 | BUKRS | Company Code | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | GSBER | Business Area | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | WERKS | Plant | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | PRCTR | Profit Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 20 | VKORG | Sales Organization | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | SPART | Division | nvarchar | 2 | 0 | | | | Allow NULL? |
| 23 | PHINR | Standard Hierarchy Area | nvarchar | 12 | 0 | | | | Allow NULL? |
| 24 | ATTRI | Business Process Attributes/CO Tasks | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | KOSTL | Cost Center | nvarchar | 10 | 0 | | | | Allow NULL? |
| 26 | KHINR | Cost Center Group | nvarchar | 15 | 0 | | | | Allow NULL? |
| 27 | ATTR1 | First Business Process Attribute | nvarchar | 24 | 0 | | | | Allow NULL? |
| 28 | ATTR2 | Second Business Process Attribute | nvarchar | 24 | 0 | | | | Allow NULL? |
| 29 | BP_STAT | Indicator "Statistical Business Process" | char | 1 | 0 | | | | Allow NULL? |
| 30 | TEMPLCLASS | Valid Environments | nvarchar | 3 | 0 | | | | Allow NULL? |
| 31 | TEMPLATE | Template: Allocation of Business Processes | nvarchar | 10 | 0 | | | | Allow NULL? |
| 32 | TEMPL_BPP | Template for Formula Planning on Business Processes | nvarchar | 10 | 0 | | | | Allow NULL? |
| 33 | KALSM | Costing Sheet | nvarchar | 6 | 0 | | | | Allow NULL? |
| 34 | PD_TASK_TP | Task Type | nvarchar | 2 | 0 | | | | Allow NULL? |
| 35 | PD_TASK_ID | Task (ID of Task) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | CBRKE | External Value Added Ranking (CO-OM-ABC) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 37 | CBRKI | Internal Value Added Ranking (CO-OM-ABC) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 38 | CBART | Business Process Attribute: Category | nvarchar | 2 | 0 | | | | Allow NULL? |
| 39 | DRVTP | Business Process Attribute: Allocation Category (CO-OM-ABC) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 40 | CBAT | Business Process Attribute: Additional Attribute (CO-OM-ABC) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 41 | WFD_ID | Number of workflow definition | nvarchar | 10 | 0 | | | | Allow NULL? |
| 42 | VERSION | Version | nvarchar | 4 | 0 | | | | Allow NULL? |
| 43 | EXETYP | Workflow Type | char | 1 | 0 | | | | Allow NULL? |
| 44 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | | | | Allow NULL? |
| 45 | LEINH | Activity Unit (CO-OM-ABC) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 46 | AUSEH | Output Unit | nvarchar | 3 | 0 | | | | Allow NULL? |
| 47 | AUSFK | Output factor | decimal | 5 | 2 | | | | |
| 48 | VKSTA | Allocation Cost Element | nvarchar | 10 | 0 | | | | Allow NULL? |
| 49 | TARKZ | Price Indicator: Calculate Allocation Price | nvarchar | 3 | 0 | | | | Allow NULL? |
| 50 | TARKZ_I | Indicator: Actual Allocation Price | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | YRATE | Price Calculation with Period-Based Average Prices | char | 1 | 0 | | | | Allow NULL? |
| 52 | LATYP | Allocation Category (CO-OM-ABC) | char | 1 | 0 | | | | Allow NULL? |
| 53 | LATYPI | Variant Allocation Category in Actual (CO-OM-ABC) | char | 1 | 0 | | | | Allow NULL? |
| 54 | MANIST | Indicator: Confirm quantity manually in actual | char | 1 | 0 | | | | Allow NULL? |
| 55 | MANPLAN | Indicator: Plan quantity manually set. | char | 1 | 0 | | | | Allow NULL? |
| 56 | FIXVO | Predistribution of fixed costs for acty type/bus. process | char | 1 | 0 | | | | Allow NULL? |
| 57 | FERC_IND | Regulatory indicator | nvarchar | 4 | 0 | | | | Allow NULL? |