| 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 | LINE | Line number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | DZEILN | Allow NULL? |
| 3 | BLOKZ | Area in planning screen | char | 1 | 0 | CHAR | (N' ') | Yes | | BLOKZ | Allow NULL? |
| 4 | LINET | Line category | char | 1 | 0 | CHAR | (N' ') | Yes | | LINET | Allow NULL? |
| 5 | TABHK | Origin table | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | TABHK | Allow NULL? |
| 6 | FELDH | Table field | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | FELDH | Allow NULL? |
| 7 | LINKZ | Text indicator: SOP | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LINKZ | Allow NULL? |
| 8 | INFUN | Name of Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | RS38L_FNAM | Allow NULL? |
| 9 | OUFUN | Name of Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | RS38L_FNAM | Allow NULL? |
| 10 | VGFUN | Name of Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | RS38L_FNAM | Allow NULL? |
| 11 | FLGEV | Indicator: event | char | 1 | 0 | CHAR | (N' ') | Yes | | FLGEV | Allow NULL? |
| 12 | FLGIS | Indicator: actual data | char | 1 | 0 | CHAR | (N' ') | Yes | | FLGIS | Allow NULL? |
| 13 | FLGFC | Indicator: forecast is possible | char | 1 | 0 | CHAR | (N' ') | Yes | | FLGFC | Allow NULL? |
| 14 | FLGVI | Indicator: copy from SIS | char | 1 | 0 | CHAR | (N' ') | Yes | | FLGVI | Allow NULL? |
| 15 | FLGDS | Indicator: structural aggregation | char | 1 | 0 | CHAR | (N' ') | Yes | | FLGDS | Allow NULL? |
| 16 | FLGDZ | Time-based disaggregation, carried out proportionally | char | 1 | 0 | CHAR | (N' ') | Yes | | FLGDZ | Allow NULL? |
| 17 | LMAKR | Macro name | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MNAME | Allow NULL? |
| 18 | IMAKR | Macro name | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | MNAME | Allow NULL? |
| 19 | RETYP | Repetition type | char | 1 | 0 | CHAR | (N' ') | Yes | | REPTY | Allow NULL? |
| 20 | RELEN | Repetition length | smallint | 5 | 0 | INT2 | ((0)) | Yes | | RELEN | |
| 21 | LDESC | Indicator: line description | char | 1 | 0 | CHAR | (N' ') | Yes | | LDESC | Allow NULL? |
| 22 | LINTX | Line text: SOP | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | LINTX | Allow NULL? |
| 23 | MTVFP | Checking Group for Availability Check | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TMVF | MTVFP | Allow NULL? |
| 24 | PRREG | Checking Rule for Availability Check | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T441R | PRREG | Allow NULL? |
| 25 | FCSTSTFNA | Key figure for forecast history | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FCSTSTFNA | Allow NULL? |
| 26 | FCSTVRSIO | Version for forecast history | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | FCSTVRSIO | Allow NULL? |
| 27 | PLANSTFNA | Key figure for planning history | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | PLANSTFNA | Allow NULL? |
| 28 | PLANVRSIO | Version for planning past | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | PLANVRSIO | Allow NULL? |
| 29 | ELINE | Line number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | DZEILN | Allow NULL? |
