| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | PROJECT | Project | nvarchar | 15 | 0 | CHAR | (N' ') | No | | /SAPDMC/LS_PROJECT | Allow NULL? |
| 2 | SUBPROJ | Subproject | nvarchar | 15 | 0 | CHAR | (N' ') | No | | /SAPDMC/LS_SUBPROJ | Allow NULL? |
| 3 | OBJECT | Object | nvarchar | 15 | 0 | CHAR | (N' ') | No | | /SAPDMC/LS_OBJECT | Allow NULL? |
| 4 | FILE_NR | File Number (for Files with Legacy Data) | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | /SAPDMC/LS_FILENUMBER | Allow NULL? |
| 5 | LOCATION | File Location: FE=Frontend, AS=Application Server | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_LOCATION | Allow NULL? |
| 6 | FILENAME | File Name (with Directory) | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_FILENAME | Allow NULL? |
| 7 | FILETEXT | File description | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_FILETEXT | Allow NULL? |
| 8 | CPAGEID | Code Page ID of Legacy System | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | TCP00 | /SAPDMC/MG_CPAGEID | Allow NULL? |
| 9 | X_ENDOFREC | Flag: Record End Marker (Text File) | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_ENDOFRC | Allow NULL? |
| 10 | X_FIXEDLEN | Flag: Fixed Record Length | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_FIXEDLN | Allow NULL? |
| 11 | REC_LENGTH | Fixed Record Length | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | /SAPDMC/MG_RECLEN | Allow NULL? |
| 12 | X_LENFLD | Flag: Hexadecimal Length Field (4 Bytes) at Start of Record | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_LENFLD | Allow NULL? |
| 13 | FILLER32 | Character field, length 32 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CHAR32 | Allow NULL? |
| 14 | X_DELTAB | Flag: Separator Tabulator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_DELTAB | Allow NULL? |
| 15 | X_DELSEM | Flag: Separator Semi-Colon | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_DELSEM | Allow NULL? |
| 16 | X_DELCOM | Flag: Separator Comma | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_DELCOM | Allow NULL? |
| 17 | X_DELBLK | Flag: Separators Blanks | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_DELBLK | Allow NULL? |
| 18 | X_DELOTH | Flag: Other Separator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_DELOTH | Allow NULL? |
| 19 | DELIMITER | Delimiter | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_DELIMIT | Allow NULL? |
| 20 | X_NODEL | Flag: No Separator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/MG_NODEL | Allow NULL? |
| 21 | X_FLATTAB | Flag: Data for One Source Structure (Table) | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_XFLATTAB | Allow NULL? |
| 22 | X_SEQFILE | Flag: Data for Multiple Source Structures (Sequential File) | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_XSEQFILE | Allow NULL? |
| 23 | X_FLDNAMES | Flag: Field Names at Start of File | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_XFLDNAMES | Allow NULL? |
| 24 | X_COLORDER | Flag: Field Order Matches Source Structure Definition | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_XCOLORDER | Allow NULL? |
| 25 | X_IGNORE | Flag: Continue Despite Conversion Error CONVT_CODEPAGE | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_XIGNORE | Allow NULL? |
| 26 | REPCHR | Replacement Characters for OPEN DATASET | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPDMC/LS_REPLACE | Allow NULL? |
