SAP ABAP Table /SAPSLL/TSPLN (Legal Control: SPL Master (Name Data))
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷
SLL-LEG (Application Component) Global Trade Services
⤷
/SAPSLL/LEGAL_CON_SPL (Package) Legal Services: Legal Control - Sanctioned Party List
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation⤷
SLL-LEG (Application Component) Global Trade Services⤷
/SAPSLL/LEGAL_CON_SPL (Package) Legal Services: Legal Control - Sanctioned Party List
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | /SAPSLL/TSPLN |
Table Relationship Diagram 
|
| Short Description | Legal Control: SPL Master (Name Data) |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  .INCLUDE |
0 | 0 | SLL: LC: SPL: SPL Master (Name Data) - PK | |||||
| 2 | MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 3 | .INCLUDE |
0 | 0 | SLL: LC: SPL: SPL Master (Name Data) - PK w/o Client | |||||
| 4 | GUID_TSPLN |
/SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
| 5 | .INCLUDE |
0 | 0 | SLL: LC: SPL: SPL Master (Name Data) - Data | |||||
| 6 | .INCLUDE |
0 | 0 | GTS: Administration: Created By, Changed By, Time Stamp | |||||
| 7 | ERNAM |
/SAPSLL/ERNAM | XUBNAME | CHAR | 12 | 0 | Name of User Who Created the Object | USR02 | |
| 8 | CRTSP |
/SAPSLL/CRTSP | /SAPSLL/TMELS | DEC | 15 | 0 | Date and Time When Object Was Added | ||
| 9 | AENAM |
/SAPSLL/AENAM | XUBNAME | CHAR | 12 | 0 | Name of User Who Changed the Object | USR02 | |
| 10 | CHTSP |
/SAPSLL/CHTSP | /SAPSLL/TMELS | DEC | 15 | 0 | Date and Time When Object Was Changed | ||
| 11 | .INCLUDE |
0 | 0 | SLL: Type of Creation / Change of Entry / Object | |||||
| 12 | CRECO |
/SAPSLL/CRECO | /SAPSLL/CRECO | CHAR | 2 | 0 | Method of Entry | ||
| 13 | .INCLUDE |
0 | 0 | SLL: Legal Control: SPL: SPL Master (Name Data) - SK | |||||
| 14 | .INCLUDE |
0 | 0 | SLL: LC: SPL: SPL Master (Header - PK w/o Client | |||||
| 15 | GUID_TSPL |
/SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | /SAPSLL/TSPL | |
| 16 | LAUNR |
/SAPSLL/LAUNR | NUMC | NUMC | 5 | 0 | Sequence Number | ||
| 17 | .INCLUDE |
0 | 0 | SLL: Valid To | |||||
| 18 | DATBI |
/SAPSLL/RPTET | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-To Date) | ||
| 19 | .INCLUDE |
0 | 0 | SLL: Valid From | |||||
| 20 | DATAB |
/SAPSLL/RPTST | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-From Time) | ||
| 21 | SPL_REF_TYPE |
/SAPSLL/SPLRE | /SAPSLL/SPLRE | CHAR | 6 | 0 | Type of Reference for SPL for Legal Control | /SAPSLL/T608R | |
| 22 | .INCLUDE |
0 | 0 | SLL: LC: SPL: Name of an SPL Address | |||||
| 23 | SPL_NAME1 |
AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
| 24 | SPL_NAME2 |
AD_NAME2 | TEXT40 | CHAR | 40 | 0 | Name 2 | ||
| 25 | SPL_NAME3 |
AD_NAME3 | TEXT40 | CHAR | 40 | 0 | Name 3 | ||
| 26 | SPL_NAME4 |
AD_NAME4 | TEXT40 | CHAR | 40 | 0 | Name 4 | ||
| 27 | SPL_NAME_CO |
AD_NAME_CO | TEXT40 | CHAR | 40 | 0 | c/o name | ||
| 28 | .INCLUDE |
0 | 0 | SLL: LC: SPL: Identification of an SPL Name - Obsolete | |||||
| 29 | SPL_PASS_COUNTRY |
/SAPSLL/SPLAP | LAND1 | CHAR | 3 | 0 | Country That Issued ID Card for SPL for Legal Control | T005 | |
| 30 | SPL_ID_NUMBER |
/SAPSLL/SPANR | /SAPSLL/SPANR | CHAR | 20 | 0 | Personal ID Card Number for SPL Screening | ||
| 31 | SPL_PASS_NUMBER |
/SAPSLL/SPPNR | /SAPSLL/SPANR | CHAR | 20 | 0 | Passport Number for SPL Legal Control | ||
| 32 | .INCLUDE |
0 | 0 | Data/Content/Service Provider for SPL for LC for SLL | |||||
| 33 | SPL_DATA_REF_ID |
/SAPSLL/EXSPL | /SAPSLL/OBJEX | CHAR | 40 | 0 | Number of Sanction Party List Entry | ||
| 34 | .INCLUDE |
0 | 0 | SLL: LEG: CMP: Match Combination for Comparison | |||||
| 35 | N1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 36 | S1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 37 | H1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 38 | H2 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 39 | B2 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 40 | I1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 41 | I2 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 42 | I3 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 43 | P1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 44 | P2 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 45 | P3 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 46 | C1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 47 | C2 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 48 | C3 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 49 | R1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 50 | R2 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 51 | K1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 52 | K2 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison | ||
| 53 | A1 |
/SAPSLL/CMPMC | XFELD | CHAR | 1 | 0 | Flag: Origin Relevant for Comparison |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /SAPSLL/TSPLN | AENAM |  USR02 |
BNAME |
KEY | 1 | CN |
| 2 | /SAPSLL/TSPLN | ERNAM | USR02 |
BNAME |
KEY | 1 | CN |
| 3 | /SAPSLL/TSPLN | GUID_TSPL | /SAPSLL/TSPL |
MANDT |
KEY | 1 | CN |
| 4 | /SAPSLL/TSPLN | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 5 | /SAPSLL/TSPLN | SPL_PASS_COUNTRY | T005 |
LAND1 |
REF |
History
| Last changed by/on | SAP | 20141106 |
| SAP Release Created in |
