SAP ABAP Table /SAPSLL/SPL_CHECK_SPL_UI_S (Output Structure for SPL Entities)

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

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPSLL/SPL_CHECK_SPL_UI_S	Table Relationship Diagram
Short Description	Output Structure for SPL Entities

Delivery and Maintenance

Pool/cluster
Delivery Class
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	ADRNR	☐	/SAPSLL/ADRNR	AD_ADDRNUM	CHAR	10	0	Address Number of Entry in Address File	*
2	SPL_CHK_DATE	☐	/SAPSLL/SPLCT	/SAPSLL/TSTMP	DEC	15	0	Date of Sanctioned Party List Screening
3	SPL_PROVIDER	☐	/SAPSLL/SPL_PROVIDER	BU_PARTNER	CHAR	10	0	Data Provider	*
4	SPL_PRO_NAME	☐	/SAPSLL/TEXT40	TEXT40	CHAR	40	0	Text 40 Characters Long
5	SPL_REF_TYPE	☐	/SAPSLL/SPLRE	/SAPSLL/SPLRE	CHAR	6	0	Type of Reference for SPL for Legal Control	*
6	.INCLUDE	☐				0	0	Legal & Logistics Services: LC: SPL Master (Header Data)
7	.INCLUDE	☐				0	0	SLL: Legal Cont.: SPL: SPL Master (Header Data) - Prim. Key
8	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
9	.INCLUDE	☐				0	0	SLL: LC: SPL: SPL Master (Header - PK w/o Client
10	GUID_TSPL	☐	/SAPSLL/GUID_16	SYSUUID	RAW	16	0	Primary Key as GUID in 'RAW' Format
11	.INCLUDE	☐				0	0	SLL: LC: SPL: SPL Master (Header Data) - Data Part
12	.INCLUDE	☐				0	0	GTS: Administration: Created By, Changed By, Time Stamp
13	ERNAM	☐	/SAPSLL/ERNAM	XUBNAME	CHAR	12	0	Name of User Who Created the Object	USR02
14	CRTSP	☐	/SAPSLL/CRTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Added
15	AENAM	☐	/SAPSLL/AENAM	XUBNAME	CHAR	12	0	Name of User Who Changed the Object	USR02
16	CHTSP	☐	/SAPSLL/CHTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Changed
17	.INCLUDE	☐				0	0	SLL: Type of Creation / Change of Entry / Object
18	CRECO	☐	/SAPSLL/CRECO	/SAPSLL/CRECO	CHAR	2	0	Method of Entry
19	.INCLUDE	☐				0	0	SLL: Legal Cont.: SPL: SPL Master (Header Data) - Sec. Key
20	LGREG	☐	/SAPSLL/LGREG	/SAPSLL/LGREG	CHAR	5	0	Legal Regulation	/SAPSLL/T606G
21	SPL_LIST_TYPE	☐	/SAPSLL/SPCAT	/SAPSLL/SPCAT	CHAR	5	0	Type of Sanctioned Party List for Legal Control	/SAPSLL/T608L
22	SPL_PROVIDER_ID	☐	/SAPSLL/PRTN_GUID_16	SYSUUID	RAW	16	0	Primary Key of Business Partner
23	SPL_DATA_REF_ID	☐	/SAPSLL/EXSPL	/SAPSLL/OBJEX	CHAR	40	0	Number of Sanction Party List Entry
24	.INCLUDE	☐				0	0	SLL: Valid To
25	DATBI	☐	/SAPSLL/RPTET	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-To Date)
26	.INCLUDE	☐				0	0	SLL: Valid From
27	DATAB	☐	/SAPSLL/RPTST	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-From Time)
28	SPL_ENTRY_DATE	☐	/SAPSLL/SPDOE	/SAPSLL/TSTMP	DEC	15	0	Date Added to Sanctioned Party List for Legal Control
29	SPL_TZONE_ENTRY	☐	/SAPSLL/TZNST	TZNZONE	CHAR	6	0	From-Time Zone	TTZZ
30	SPL_VALID_FROM	☐	/SAPSLL/SPLST	/SAPSLL/TSTMP	DEC	15	0	Valid-From Date of an SPL Entry for Legal Control
31	SPL_TZONE_FROM	☐	/SAPSLL/TZNST	TZNZONE	CHAR	6	0	From-Time Zone	TTZZ
32	SPL_VALID_TO	☐	/SAPSLL/SPLET	/SAPSLL/TSTMP	DEC	15	0	Valid-To Date of an SPL Entry for Legal Control
33	SPL_TZONE_TO	☐	/SAPSLL/TZNEN	TZNZONE	CHAR	6	0	To-Time Zone	TTZZ
34	SPL_FILE_ID	☐	/SAPSLL/EXRID	/SAPSLL/OBJEX	CHAR	40	0	File ID for SPL for Legal Control
35	.INCLUDE	☐				0	0	SLL: LC: SPL: Law for Boycott List - Obsolete
36	SPL_LAW1	☐	/SAPSLL/SPLLW	TEXT60	CHAR	60	0	Regulation of Sanctioned Party List for Legal Control
37	SPL_LAW2	☐	/SAPSLL/SPLLW	TEXT60	CHAR	60	0	Regulation of Sanctioned Party List for Legal Control
38	SPL_LAW3	☐	/SAPSLL/SPLLW	TEXT60	CHAR	60	0	Regulation of Sanctioned Party List for Legal Control
39	.INCLUDE	☐				0	0	SLL: LC: SPL: Comment for List Type - Obsolete
40	SPL_COMMENT1	☐	/SAPSLL/SPCOM	TEXT60	CHAR	60	0	Comment for Sanctioned Party List for SPL Screening
41	SPL_COMMENT2	☐	/SAPSLL/SPCOM	TEXT60	CHAR	60	0	Comment for Sanctioned Party List for SPL Screening
42	SPL_COMMENT3	☐	/SAPSLL/SPCOM	TEXT60	CHAR	60	0	Comment for Sanctioned Party List for SPL Screening
43	VRSIO	☐	/SAPSLL/LAUNR	NUMC	NUMC	5	0	Sequence Number
44	SPL_ENTITY_TYPE	☐	/SAPSLL/SPTYP	/SAPSLL/SPTYP	CHAR	1	0	SPL Master Category
45	SPL_GROUP	☐	/SAPSLL/SPGRP	/SAPSLL/SPGRP	CHAR	6	0	Group of Sanctioned Party List	*
46	SPL_SUSPEND	☐	/SAPSLL/SPSUS	XFELD	CHAR	1	0	Exclude SPL Master from Sanctioned Party List Screening
47	LAUNR	☐	/SAPSLL/LAUNR	NUMC	NUMC	5	0	Sequence Number
48	.INCLUDE	☐				0	0	GTS: Reference Data for Previous Object
49	POBJT	☐	/SAPSLL/POBJT	/SAPSLL/POBJT	CHAR	2	0	Type of Preceding Object
50	GUID_POBJ	☐	/SAPSLL/POBJ_GUID_16	SYSUUID	RAW	16	0	Primary Key of Preceding Object
51	.INCLUDE	☐				0	0	SLL: LC: SPL: Name of an SPL Address
52	SPL_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
53	SPL_NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
54	SPL_NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
55	SPL_NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
56	SPL_NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
57	.INCLUDE	☐				0	0	SLL: LC: SPL: Identification of an SPL Name - Obsolete
58	SPL_PASS_COUNTRY	☐	/SAPSLL/SPLAP	LAND1	CHAR	3	0	Country That Issued ID Card for SPL for Legal Control	T005
59	SPL_ID_NUMBER	☐	/SAPSLL/SPANR	/SAPSLL/SPANR	CHAR	20	0	Personal ID Card Number for SPL Screening
60	SPL_PASS_NUMBER	☐	/SAPSLL/SPPNR	/SAPSLL/SPANR	CHAR	20	0	Passport Number for SPL Legal Control
61	.INCLUDE	☐				0	0	SLL: LC: SPL: Street of an SPL Address
62	SPL_STREET1	☐	AD_STREET	TEXT60	CHAR	60	0	Street
63	SPL_STREET2	☐	AD_STREET	TEXT60	CHAR	60	0	Street
64	SPL_STREET3	☐	AD_STREET	TEXT60	CHAR	60	0	Street
65	.INCLUDE	☐				0	0	SLL: LC: SPL: Postal Address of an SPL Address
66	SPL_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
67	SPL_PO_CITY	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
68	SPL_PO_CODE	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
69	SPL_PO_COUNTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
70	SPL_PO_REGION	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
71	.INCLUDE	☐				0	0	SLL: LC: SPL: Building of an SPL Address
72	SPL_HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
73	SPL_BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
74	SPL_ROOM_NUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
75	.INCLUDE	☐				0	0	SLL: LC: SPL: Telecommunication Data of an SPL Address
76	SPL_PHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
77	SPL_FAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
78	SPL_TELEX	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
79	SPL_EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
80	SPL_PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
81	SPL_MOB_NUMBER	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
82	.INCLUDE	☐				0	0	SLL: LC: SPL: City of an SPL Address
83	SPL_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
84	SPL_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
85	SPL_DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
86	.INCLUDE	☐				0	0	SLL: LC: SPL: Country/Region of an SPL Address
87	SPL_COUNTRY	☐	/SAPSLL/LAND1	LAND1	CHAR	3	0	Country Key	T005
88	SPL_REGION	☐	/SAPSLL/REGIO	REGIO	CHAR	3	0	Region Key	T005S
89	GUID_SPLAUDD	☐	/SAPSLL/GUID_16	SYSUUID	RAW	16	0	Primary Key as GUID in 'RAW' Format

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPSLL/SPL_CHECK_SPL_UI_S	AENAM	USR02	BNAME	KEY	1	CN
2	/SAPSLL/SPL_CHECK_SPL_UI_S	ERNAM	USR02	BNAME	KEY	1	CN
3	/SAPSLL/SPL_CHECK_SPL_UI_S	LGREG	/SAPSLL/T606G	MANDT	KEY	1	CN
4	/SAPSLL/SPL_CHECK_SPL_UI_S	MANDT	T000	MANDT	KEY	1	CN
5	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_COUNTRY	T005	LAND1	REF
6	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_PASS_COUNTRY	T005	LAND1	REF
7	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_PO_COUNTRY	T005	LAND1	REF
8	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_PO_REGION	T005S	BLAND	REF
9	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_REGION	T005S	BLAND	KEY	1	CN
10	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_TZONE_ENTRY	TTZZ	TZONE	REF
11	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_TZONE_FROM	TTZZ	TZONE	REF
12	/SAPSLL/SPL_CHECK_SPL_UI_S	SPL_TZONE_TO	TTZZ	TZONE	REF

History

Last changed by/on	SAP	20141106
SAP Release Created in	720