| 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 | GUID | Unique Key for Identification of Notification | nvarchar | 32 | 0 | CHAR | (N' ') | No | | P01_SVGUID | Allow NULL? |
| 3 | BTRNRBS | Company Number of Place of Work | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | P01_BD_BBNRBS | Allow NULL? |
| 4 | WERKSBS | Personnel Area of Data for a Place of Work | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P01_BD_WERKSBS | Allow NULL? |
| 5 | BTRTLBS | Personnel Subarea of Data for a Place of Work | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P01_BD_BTRTLBS | Allow NULL? |
| 6 | TYP | Type in Registration Procedue for Business Data Maint. | char | 1 | 0 | CHAR | (N' ') | Yes | | P01_BD_TYP | Allow NULL? |
| 7 | STATUS | Status Indicator of Notif. for Business Data Maintenance | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P01_BD_STATUS | Allow NULL? |
| 8 | GUID_CNECT | GUID of Linked Notification | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | P01_BD_GUIDCNECT | Allow NULL? |
| 9 | DATUM | Creation/Change Date of Notification | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_SVDATUM | Allow NULL? |
| 10 | UZEIT | Creation/Change Time of a Notification | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P01_SVUZEIT | Allow NULL? |
| 11 | REPORT | Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | P01_SVREPID | Allow NULL? |
| 12 | EUSER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | P01_SVUNAME | Allow NULL? |
| 13 | WERKS | Sender or Recipient of Notification (Personnel Area) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P01_SVWERKS | Allow NULL? |
| 14 | BTRTL | Sender or Recipient of Notification (Personnel Subarea) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P01_SVBTRTL | Allow NULL? |
| 15 | KKART | Type of Organizational Unit of Health Insurance Fund | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P01_KKART | Allow NULL? |
| 16 | BTRNR | Company Number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BNR_KEY | Allow NULL? |
| 17 | PABRP | Payroll period for determining time period | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | PNPPABRP | Allow NULL? |
| 18 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PNPPABRJ | Allow NULL? |
| 19 | ADATUM | Date of Evaluation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P01_SVADATUM | Allow NULL? |
