| 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 | * | MANDT | Allow NULL? |
| 2 | AKTENART | File types | nvarchar | 5 | 0 | CHAR | (N' ') | No | /XFT/EPA_CAKTART | /XFT/EPA_AKTENART | Allow NULL? |
| 3 | ACTIVE | Entry active / inactive | char | 1 | 0 | CHAR | (N' ') | No | | /XFT/EPA_ACTIVE | Allow NULL? |
| 4 | RMS_ID | RMS in which the personnel files are stored | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_RMS_ID | Allow NULL? |
| 5 | SPS_TASK | Element Type Record | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_SPS_TASK | Allow NULL? |
| 6 | SPS_TEMPLATE | Element type template | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_SPS_TEMP | Allow NULL? |
| 7 | TEMPLATE_ID | Template used to create personnel files | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_TEMPLATE_ID | Allow NULL? |
| 8 | SPS_INFOTYPE | Element type used for infotypes | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_SPS_INFTY | Allow NULL? |
| 9 | SPS_ARCHIVELINK | Element type used for ArchiveLink documents | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_SPS_ALINK | Allow NULL? |
| 10 | SPS_REPORT | Element type used to manage reports | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_SPS_REPORT | Allow NULL? |
| 11 | SPS_FOLDER | Element type used for file folder | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_SPS_FOLDER | Allow NULL? |
| 12 | SPS_KPRO | Element type used for KPro documents | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_SPS_KPRO | Allow NULL? |
| 13 | APPL_LAYER_HR | Application layer for access to HR functions | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | /XFT/APPLLAYDE | /XFT/EPA_ALAYER_HR | Allow NULL? |
| 14 | ALL_F_VISIBLE | Should all functions be visible? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_ALL_F_V | Allow NULL? |
| 15 | PHOTO_VISIBLE | Is the employee photo to be displayed in the file? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_PHOTO_VISIBLE | Allow NULL? |
| 16 | HEIGHT_HEADER | Height of attribute display | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /XFT/EPA_HEIGHT | |
| 17 | WIDTH_HEADER | Attribute display width | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /XFT/EPA_WIDTH | |
| 18 | WIDTH_HEADER_P | Photo width | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | /XFT/EPA_WIDTH_P | |
| 19 | LEND_OWN_TASK | Can an employee borrow his/her own file? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_LEND_OWN_TASK | Allow NULL? |
| 20 | AUTO_CHANGE_MODE | Should the file be started in change mode? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_AUTO_CHANGE_MODE | Allow NULL? |
| 21 | HIDE_E_FOLDER | Are empty folders to be hidden in display mode? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_HIDE_EMPTY_FOLDER | Allow NULL? |
| 22 | NOTICE_TYPE | Note type used in the personnel file | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | /XFT/SRMNOTEC01 | /XFT/EPA_NOTICE_TYPE | Allow NULL? |
| 23 | CONNECTION_TYPE | Connection type (-> document connector) | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_CONNECTION_TYPE | Allow NULL? |
| 24 | NO_HR_BUFFER | No buffering of HR data | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_NO_HR_BUFFER | Allow NULL? |
| 25 | RECORD_VIS | How will file visibility performed? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/RECORD_VIS_CHECK | Allow NULL? |
| 26 | USE_TM_SORT | Should Task Manager sort profile be used? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_USE_TM_SORT | Allow NULL? |
| 27 | FS_TYPE | Type | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | /XFT/SRMDDSC01 | /XFT/SRM_DDS_TYPE_ID | Allow NULL? |
| 28 | VIEW_NO_BUTTONS | Should no buttons be displayed in the viewer? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_VIEW_NO_BUTTONS | Allow NULL? |
| 29 | VIEW_EXTERNAL | Should documents be displayed in an external viewer? | char | 1 | 0 | CHAR | (N' ') | Yes | | /XFT/EPA_VIEW_EXTERNAL | Allow NULL? |
