| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | SCTYP | Planning type | nvarchar | 11 | 0 | CHAR | (N' ') | No | T445P | SCTYP | Allow NULL? |
| 2 | MAKRO | Macro name | nvarchar | 10 | 0 | CHAR | (N' ') | No | T445N | MNAME | Allow NULL? |
| 3 | CALFD | Sequence in which the macro is processed | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | CALFD | Allow NULL? |
| 4 | Z1 | Matrix line number | int | 10 | 0 | INT4 | ((0)) | Yes | | MXROW | Allow NULL? |
| 5 | O1 | Matrix column | int | 10 | 0 | INT4 | ((0)) | Yes | | MXCOL | Allow NULL? |
| 6 | OP | Operator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | OPERAT | Allow NULL? |
| 7 | Z2 | Matrix line number | int | 10 | 0 | INT4 | ((0)) | Yes | | MXROW | Allow NULL? |
| 8 | O2 | Matrix column | int | 10 | 0 | INT4 | ((0)) | Yes | | MXCOL | Allow NULL? |
| 9 | WERT | Matrix element value | float | 15 | 16 | FLTP | ((0)) | Yes | | MXVAL | |
| 10 | Z3 | Matrix line number | int | 10 | 0 | INT4 | ((0)) | Yes | | MXROW | Allow NULL? |
| 11 | SUTYP | Planning type | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | * | SCTYP | Allow NULL? |
| 12 | SUMAK | Macro name | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MNAME | Allow NULL? |
| 13 | GRPZE | Number of the routine used for copying | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | GRPNO | Allow NULL? |
| 14 | GRPNO | Number of the routine used for copying | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | GRPNO | Allow NULL? |
| 15 | ARKZ1 | Absolute/relative indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AREKZ | Allow NULL? |
| 16 | ARKZ2 | Absolute/relative indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AREKZ | Allow NULL? |
| 17 | ARKZ3 | Absolute/relative indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | AREKZ | Allow NULL? |
| 18 | RELE1 | Repetition length | smallint | 5 | 0 | INT2 | ((0)) | Yes | | RELEN | |
| 19 | VAFUN | Name of Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | RS38L_FNAM | Allow NULL? |
| 20 | EHBA1 | Indicator: conversion to structural unit | char | 1 | 0 | CHAR | (N' ') | Yes | | EHBAS | Allow NULL? |
| 21 | EHBA2 | Indicator: conversion to structural unit | char | 1 | 0 | CHAR | (N' ') | Yes | | EHBAS | Allow NULL? |
| 22 | EHBA3 | Indicator: conversion to structural unit | char | 1 | 0 | CHAR | (N' ') | Yes | | EHBAS | Allow NULL? |
| 23 | EHBA4 | Indicator: conversion to structural unit | char | 1 | 0 | CHAR | (N' ') | Yes | | EHBAS | Allow NULL? |
| 24 | RELE2 | Repetition length | smallint | 5 | 0 | INT2 | ((0)) | Yes | | RELEN | |
| 25 | RELE3 | Repetition length | smallint | 5 | 0 | INT2 | ((0)) | Yes | | RELEN | |
| 26 | DISKZ | Indicator: macro to perform disaggregation | char | 1 | 0 | CHAR | (N' ') | Yes | | DISMA | Allow NULL? |
| 27 | MARKZ | Indicator: column selection is relevant | char | 1 | 0 | CHAR | (N' ') | Yes | | MARKZ | Allow NULL? |
| 28 | OPTYP | Type of arithmetic function | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | MCP6_OPTYP | Allow NULL? |
