| 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 | T000 | MANDT | Allow NULL? |
| 2 | GUID_ADRCON | Primary Key as GUID in 'RAW' Format | varbinary | 16 | 0 | RAW | | No | | /SAPSLL/GUID_16 | |
| 3 | ERNAM | Name of User Who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | /SAPSLL/ERNAM | Allow NULL? |
| 4 | CRTSP | UTC Time Stamp When Object Was Added | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPSLL/CRTSP | |
| 5 | AENAM | Name of User Who Changed the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | USR02 | /SAPSLL/AENAM | Allow NULL? |
| 6 | CHTSP | UTC Time Stamp When Object Was Changed | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPSLL/CHTSP | |
| 7 | ADRNR | Address Number of Entry in Address File | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | ADRC | /SAPSLL/ADRNR | Allow NULL? |
| 8 | LGREG | Legal Regulation | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | /SAPSLL/T606G | /SAPSLL/LGREG | Allow NULL? |
| 9 | DATBI | Definitive Date (Valid-To Date) | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPSLL/RPTET | |
| 10 | DATAB | Definitive Date (Valid-From Time) | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPSLL/RPTST | |
| 11 | PIDEX | External Identification of Customs Business Partner | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/PIDEX | Allow NULL? |
| 12 | MCUSE | Military / Civilian Usage Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MCUSE | Allow NULL? |
| 13 | BPCCB | Indicator for Chemical/Biological Warfare | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPCCB | Allow NULL? |
| 14 | BPCNT | Nuclear Nonproliferation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPCNT | Allow NULL? |
| 15 | BPCMT | Indicator for Missile Technology | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPCMT | Allow NULL? |
| 16 | BPCNS | Indicator for National Security | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPCNS | Allow NULL? |
| 17 | BPCDR | Indicator for Drug Products | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPCDR | Allow NULL? |
| 18 | BPCNU | Flag: Operator of a Nuclear Facility | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BPCNU | Allow NULL? |
| 19 | CRECO | Method of Entry | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CRECO | Allow NULL? |
| 20 | SPL_CHK_DATE | Date of Sanctioned Party List Screening | decimal | 15 | 0 | DEC | ((0)) | Yes | | /SAPSLL/SPLCT | |
| 21 | SPL_CHK_POSITIVE | Indicator: Address Appears in Sanction List | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/SPLCO | Allow NULL? |
| 22 | SPLPN | Flagged on Positive/Negative List | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/SPLPN | Allow NULL? |
| 23 | SPLIB | Indicator for "Indirectly Locked" | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/SPLIB | Allow NULL? |
| 24 | BLKST | Processing Status for Sanctioned Party List Screening | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/BLKST | Allow NULL? |
| 25 | CSSPL | Determination Procedure for Release Reason | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TCSSCH | /SAPSLL/CSSCH | Allow NULL? |
| 26 | OPSPL | Option for Release Reason | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TCSSCHO | /SAPSLL/OPTID | Allow NULL? |
| 27 | CASPL | Open Case Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/CASOP | Allow NULL? |
| 28 | PGLOC | Partner Group Relevant for Letter of Credit | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | /SAPSLL/TCOPS | /SAPSLL/PGLOC | Allow NULL? |
| 29 | MOBJT | Type of Main Object | char | 1 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/MOBJT | Allow NULL? |
| 30 | GUID_MOBJ | Primary Key of Main Object | varbinary | 16 | 0 | RAW | | Yes | | /SAPSLL/MOBJ_GUID_16 | |
| 31 | POBJT | Type of Preceding Object | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /SAPSLL/POBJT | Allow NULL? |
| 32 | GUID_POBJ | Primary Key of Preceding Object | varbinary | 16 | 0 | RAW | | Yes | * | /SAPSLL/POBJ_GUID_16 | |
