| 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 | MSGGUID | GUID in 'CHAR' Format in Uppercase | nvarchar | 32 | 0 | CHAR | (N' ') | No | | GUID_32 | Allow NULL? |
| 3 | NS | Namespace | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | /AIF/T_NS | /AIF/NS | Allow NULL? |
| 4 | IFNAME | Interface Name | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /AIF/T_FINF | /AIF/IFNAME | Allow NULL? |
| 5 | IFVER | Interface Version | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | /AIF/T_FINF | /AIF/IFVERSION | Allow NULL? |
| 6 | NUMBEROFABORTS | Abort Number | int | 10 | 0 | INT4 | ((0)) | Yes | | /AIF/NUMBEROFABORTS | Allow NULL? |
| 7 | NUMBEROFERRORS | Error Number | int | 10 | 0 | INT4 | ((0)) | Yes | | /AIF/NUMBEROFERRORS | Allow NULL? |
| 8 | NUMBEROFWARNINGS | Warning Number | int | 10 | 0 | INT4 | ((0)) | Yes | | /AIF/NUMBEROFWARNINGS | Allow NULL? |
| 9 | NUMBEROFSUCCESS | Success Number | int | 10 | 0 | INT4 | ((0)) | Yes | | /AIF/NUMBEROFSUCCESS | Allow NULL? |
| 10 | NUMBEROFINFOS | Information Number | int | 10 | 0 | INT4 | ((0)) | Yes | | /AIF/NUMBEROFINFOS | Allow NULL? |
| 11 | NSRECIP | Namespace | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | /AIF/NS | Allow NULL? |
| 12 | RECIPIENT | Alert Management Recipient | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | /AIF/ALRT_REC | Allow NULL? |
| 13 | STATUS | Processing Status | char | 1 | 0 | CHAR | (N' ') | Yes | | /AIF/PROC_STATUS | Allow NULL? |
| 14 | AIF_LOCATION | Message Location | char | 1 | 0 | CHAR | (N' ') | Yes | | /AIF/MESSAGE_LOCATION | Allow NULL? |
| 15 | LOGNUMBER | Application log: log number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | BALOGNR | Allow NULL? |
| 16 | TRACE_LEVEL | AIF Trace Level | char | 1 | 0 | CHAR | (N' ') | Yes | | /AIF/TRACE_LEVEL | Allow NULL? |
| 17 | TL_EXP_DATE | Expiration Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /AIF/EXP_DATE | Allow NULL? |
| 18 | TL_EXP_TIME | Expiration Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /AIF/EXP_TIME | Allow NULL? |
| 19 | CREATE_USER | Create User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /AIF/CREATE_USER | Allow NULL? |
| 20 | CREATE_DATE | Creation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /AIF/CREATE_DATE | Allow NULL? |
| 21 | CREATE_TIME | Creation Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /AIF/CREATE_TIME | Allow NULL? |
| 22 | LAST_USER | Last User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /AIF/LAST_USER | Allow NULL? |
| 23 | LAST_DATE | Last Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /AIF/LAST_DATE | Allow NULL? |
| 24 | LAST_TIME | Last Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /AIF/LAST_TIME | Allow NULL? |
| 25 | END_USER | End User | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | /AIF/END_USER | Allow NULL? |
| 26 | END_DATE | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | /AIF/END_DATE | Allow NULL? |
| 27 | END_TIME | End Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | /AIF/END_TIME | Allow NULL? |
| 28 | AIF_ALERT_ID | External ID for an Alert | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | SALRTEXTID | Allow NULL? |
| 29 | AIF_VARIANT_NS | Variant Namespace | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | * | /AIF/VARIANT_NS | Allow NULL? |
| 30 | AIF_VARIANT_NAME | Name of Interface Variant | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | /AIF/VARIANT_NAME | Allow NULL? |
| 31 | PID | Integration Engine: Pipeline ID | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | * | SXMSPID | Allow NULL? |
| 32 | ARFCIPID | Host ID (IP ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARFCIPID | Allow NULL? |
| 33 | ARFCPID | Process ID | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ARFCPID | Allow NULL? |
| 34 | ARFCTIME | Time Stamp | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARFCTIME | Allow NULL? |
| 35 | ARFCTIDCNT | Transaction ID (LUW -> COMMIT WORK) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ARFCTIDCNT | Allow NULL? |
| 36 | ARFCDEST | Logical Destination (Specified in Function Call) | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | RFCDES | RFCDEST | Allow NULL? |
| 37 | ARFCLUWCNT | Counter within a transaction (LUW) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARFCLUWCNT | Allow NULL? |
| 38 | ARFCSTATE | Status of an ARFC call (RECORDED,CPICERR,MAILED,READ..) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ARFCSTATE | Allow NULL? |
| 39 | ARFCFNAM | Name of Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RS38L_FNAM | Allow NULL? |
| 40 | ARFCRETURN | Reply expected | char | 1 | 0 | CHAR | (N' ') | Yes | | ARFCRETURN | Allow NULL? |
| 41 | ARFCUZEIT | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SYUZEIT | Allow NULL? |
| 42 | ARFCDATUM | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATUM | Allow NULL? |
| 43 | ARFCUSER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SYUNAME | Allow NULL? |
| 44 | ARFCRETRYS | No. of attempts | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | RETRY | Allow NULL? |
| 45 | ARFCTCODE | Transaction Code | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | SYTCODE | Allow NULL? |
| 46 | ARFCRHOST | RFCCHAR8 | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | RFCCHAR8 | Allow NULL? |
| 47 | ARFCMSG | Message Variable | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SYMSGV | Allow NULL? |
| 48 | ARFCRESERV | Horizontal Line | nvarchar | 255 | 0 | CHAR | (N' ') | Yes | | SYULINE | Allow NULL? |
| 49 | HASH | HASH for tRFC/qRFC | varbinary | 40 | 0 | RAW | | Yes | | ARFCHASH | |
| 50 | LOGSYS | Logical System | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | /AIF/LOGSYS | Allow NULL? |
| 51 | AIF_PERSIST_TYPE | Persistence Type | char | 1 | 0 | CHAR | (N' ') | Yes | | /AIF/PERSIST_TYPE | Allow NULL? |
| 52 | ORG_FUNCNAME | Original Function Module Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | /AIF/ORG_FUNCNAME | Allow NULL? |
