| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | KOKRS | Controlling Area | nvarchar | 4 | 0 | CHAR | (N' ') | No | TKA01 | KOKRS | Allow NULL? |
| 3 | PRZNR | Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | No | | CO_PRZNR | Allow NULL? |
| 4 | DATBI | Valid To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | DATBI | Allow NULL? |
| 5 | DATAB | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATAB | Allow NULL? |
| 6 | ERFDT | Created on | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERFDT | Allow NULL? |
| 7 | ERFNM | Entered by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERFNM | Allow NULL? |
| 8 | AENDT | Date of last change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AENDT | Allow NULL? |
| 9 | AENNM | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | AENNM | Allow NULL? |
| 10 | PRART | CO-OM-ABC: Business Process Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | CBPL | CO_CBART_4 | Allow NULL? |
| 11 | PRTYP | CO-ABC: Business Process Type | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | CO_BPTYP | Allow NULL? |
| 12 | OBJNR | Object number | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | ONR00 | J_OBJNR | Allow NULL? |
| 13 | OWAER | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | OWAER | Allow NULL? |
| 14 | VERAP | Person Responsible | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CO_VERAP | Allow NULL? |
| 15 | VERAP_USER | Person Responsible for Business Process | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | VERAP_USER | Allow NULL? |
| 16 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 17 | GSBER | Business Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TGSB | GSBER | Allow NULL? |
| 18 | WERKS | Plant | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001W | WERKS_D | Allow NULL? |
| 19 | PRCTR | Profit Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CEPC | PRCTR | Allow NULL? |
| 20 | VKORG | Sales Organization | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TVKO | VKORG | Allow NULL? |
| 21 | VTWEG | Distribution Channel | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVTW | VTWEG | Allow NULL? |
| 22 | SPART | Division | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TSPA | SPART | Allow NULL? |
| 23 | PHINR | Standard Hierarchy Area | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CO_BPHINR | Allow NULL? |
| 24 | ATTRI | Business Process Attributes/CO Tasks | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CB_ATTRI | Allow NULL? |
| 25 | KOSTL | Cost Center | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | KOSTL | Allow NULL? |
| 26 | KHINR | Cost Center Group | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | KSGRU | Allow NULL? |
| 27 | ATTR1 | First Business Process Attribute | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | ABC_ATTRI1 | Allow NULL? |
| 28 | ATTR2 | Second Business Process Attribute | nvarchar | 24 | 0 | CHAR | (N' ') | Yes | | ABC_ATTRI2 | Allow NULL? |
| 29 | BP_STAT | Indicator "Statistical Business Process" | char | 1 | 0 | CHAR | (N' ') | Yes | | BP_STAT | Allow NULL? |
| 30 | TEMPLCLASS | Valid Environments | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | COTPLCLASS | ABC_CLASS | Allow NULL? |
| 31 | TEMPLATE | Template: Allocation of Business Processes | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | COTPL | ABC_TEMPL_SBP | Allow NULL? |
| 32 | TEMPL_BPP | Template for Formula Planning on Business Processes | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | COTPL | ABC_TEMPL_BPP | Allow NULL? |
| 33 | KALSM | Costing Sheet | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T683 | AUFKALSM | Allow NULL? |
| 34 | PD_TASK_TP | Task Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | PD_TASK_TP | Allow NULL? |
| 35 | PD_TASK_ID | Task (ID of Task) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | PD_TASK_ID | Allow NULL? |
| 36 | CBRKE | External Value Added Ranking (CO-OM-ABC) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | CBRK | CO_CBRKE | Allow NULL? |
| 37 | CBRKI | Internal Value Added Ranking (CO-OM-ABC) | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | CBRK | CO_CBRKI | Allow NULL? |
| 38 | CBART | Business Process Attribute: Category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | CBAR | CO_CBART | Allow NULL? |
| 39 | DRVTP | Business Process Attribute: Allocation Category (CO-OM-ABC) | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | CBDT | CO_DRVTP | Allow NULL? |
| 40 | CBAT | Business Process Attribute: Additional Attribute (CO-OM-ABC) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | CBAT | CO_CBAT | Allow NULL? |
| 41 | WFD_ID | Number of workflow definition | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SWD_WFD_ID | Allow NULL? |
| 42 | VERSION | Version | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SWD_VERSIO | Allow NULL? |
| 43 | EXETYP | Workflow Type | char | 1 | 0 | CHAR | (N' ') | Yes | | SWD_EXETYP | Allow NULL? |
| 44 | LOGSYSTEM | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TBDLS | LOGSYSTEM | Allow NULL? |
| 45 | LEINH | Activity Unit (CO-OM-ABC) | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | LEINH_ABC | Allow NULL? |
| 46 | AUSEH | Output Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | AUSEH | Allow NULL? |
| 47 | AUSFK | Output factor | decimal | 5 | 2 | DEC | ((0)) | Yes | | AUSFK | |
| 48 | VKSTA | Allocation Cost Element | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | VKSTA | Allow NULL? |
| 49 | TARKZ | Price Indicator: Calculate Allocation Price | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKA10 | TARKZ | Allow NULL? |
| 50 | TARKZ_I | Indicator: Actual Allocation Price | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TKA10 | CO_TARKZ_I | Allow NULL? |
| 51 | YRATE | Price Calculation with Period-Based Average Prices | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_YRATE | Allow NULL? |
| 52 | LATYP | Allocation Category (CO-OM-ABC) | char | 1 | 0 | CHAR | (N' ') | Yes | | LATYP_ABC | Allow NULL? |
| 53 | LATYPI | Variant Allocation Category in Actual (CO-OM-ABC) | char | 1 | 0 | CHAR | (N' ') | Yes | | LATYPI_ABC | Allow NULL? |
| 54 | MANIST | Indicator: Confirm quantity manually in actual | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_MANIST | Allow NULL? |
| 55 | MANPLAN | Indicator: Plan quantity manually set. | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_MANPLAN | Allow NULL? |
| 56 | FIXVO | Predistribution of fixed costs for acty type/bus. process | char | 1 | 0 | CHAR | (N' ') | Yes | | CO_FIXVO | Allow NULL? |
| 57 | FERC_IND | Regulatory indicator | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | FERC_C7 | FE_IND | Allow NULL? |
