SAP ABAP Table /SAPSLL/SPL_AT_ITEM_UI_S (SLL: SPL: Audit Trail Structure - Item)

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_AT_ITEM_UI_S	Table Relationship Diagram
Short Description	SLL: SPL: Audit Trail Structure - Item

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	GUID_SPLAUD	☐	/SAPSLL/GUID_16	SYSUUID	RAW	16	0	Primary Key as GUID in 'RAW' Format
2	.INCLUDE	☐				0	0	Legal & Logistics Services: LC: SPL Master (Header Data)
3	.INCLUDE	☐				0	0	SLL: Legal Cont.: SPL: SPL Master (Header Data) - Prim. Key
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	.INCLUDE	☐				0	0	SLL: LC: SPL: SPL Master (Header - PK w/o Client
6	GUID_TSPL	☐	/SAPSLL/GUID_16	SYSUUID	RAW	16	0	Primary Key as GUID in 'RAW' Format
7	.INCLUDE	☐				0	0	SLL: LC: SPL: SPL Master (Header Data) - Data Part
8	.INCLUDE	☐				0	0	GTS: Administration: Created By, Changed By, Time Stamp
9	ERNAM	☐	/SAPSLL/ERNAM	XUBNAME	CHAR	12	0	Name of User Who Created the Object	USR02
10	CRTSP	☐	/SAPSLL/CRTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Added
11	AENAM	☐	/SAPSLL/AENAM	XUBNAME	CHAR	12	0	Name of User Who Changed the Object	USR02
12	CHTSP	☐	/SAPSLL/CHTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Changed
13	.INCLUDE	☐				0	0	SLL: Type of Creation / Change of Entry / Object
14	CRECO	☐	/SAPSLL/CRECO	/SAPSLL/CRECO	CHAR	2	0	Method of Entry
15	.INCLUDE	☐				0	0	SLL: Legal Cont.: SPL: SPL Master (Header Data) - Sec. Key
16	LGREG	☐	/SAPSLL/LGREG	/SAPSLL/LGREG	CHAR	5	0	Legal Regulation	/SAPSLL/T606G
17	SPL_LIST_TYPE	☐	/SAPSLL/SPCAT	/SAPSLL/SPCAT	CHAR	5	0	Type of Sanctioned Party List for Legal Control	/SAPSLL/T608L
18	SPL_PROVIDER_ID	☐	/SAPSLL/PRTN_GUID_16	SYSUUID	RAW	16	0	Primary Key of Business Partner
19	SPL_DATA_REF_ID	☐	/SAPSLL/EXSPL	/SAPSLL/OBJEX	CHAR	40	0	Number of Sanction Party List Entry
20	.INCLUDE	☐				0	0	SLL: Valid To
21	DATBI	☐	/SAPSLL/RPTET	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-To Date)
22	.INCLUDE	☐				0	0	SLL: Valid From
23	DATAB	☐	/SAPSLL/RPTST	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-From Time)
24	SPL_ENTRY_DATE	☐	/SAPSLL/SPDOE	/SAPSLL/TSTMP	DEC	15	0	Date Added to Sanctioned Party List for Legal Control
25	SPL_TZONE_ENTRY	☐	/SAPSLL/TZNST	TZNZONE	CHAR	6	0	From-Time Zone	TTZZ
26	SPL_VALID_FROM	☐	/SAPSLL/SPLST	/SAPSLL/TSTMP	DEC	15	0	Valid-From Date of an SPL Entry for Legal Control
27	SPL_TZONE_FROM	☐	/SAPSLL/TZNST	TZNZONE	CHAR	6	0	From-Time Zone	TTZZ
28	SPL_VALID_TO	☐	/SAPSLL/SPLET	/SAPSLL/TSTMP	DEC	15	0	Valid-To Date of an SPL Entry for Legal Control
29	SPL_TZONE_TO	☐	/SAPSLL/TZNEN	TZNZONE	CHAR	6	0	To-Time Zone	TTZZ
30	SPL_FILE_ID	☐	/SAPSLL/EXRID	/SAPSLL/OBJEX	CHAR	40	0	File ID for SPL for Legal Control
31	.INCLUDE	☐				0	0	SLL: LC: SPL: Law for Boycott List - Obsolete
32	SPL_LAW1	☐	/SAPSLL/SPLLW	TEXT60	CHAR	60	0	Regulation of Sanctioned Party List for Legal Control
33	SPL_LAW2	☐	/SAPSLL/SPLLW	TEXT60	CHAR	60	0	Regulation of Sanctioned Party List for Legal Control
34	SPL_LAW3	☐	/SAPSLL/SPLLW	TEXT60	CHAR	60	0	Regulation of Sanctioned Party List for Legal Control
35	.INCLUDE	☐				0	0	SLL: LC: SPL: Comment for List Type - Obsolete
36	SPL_COMMENT1	☐	/SAPSLL/SPCOM	TEXT60	CHAR	60	0	Comment for Sanctioned Party List for SPL Screening
37	SPL_COMMENT2	☐	/SAPSLL/SPCOM	TEXT60	CHAR	60	0	Comment for Sanctioned Party List for SPL Screening
38	SPL_COMMENT3	☐	/SAPSLL/SPCOM	TEXT60	CHAR	60	0	Comment for Sanctioned Party List for SPL Screening
39	VRSIO	☐	/SAPSLL/LAUNR	NUMC	NUMC	5	0	Sequence Number
40	SPL_ENTITY_TYPE	☐	/SAPSLL/SPTYP	/SAPSLL/SPTYP	CHAR	1	0	SPL Master Category
41	SPL_GROUP	☐	/SAPSLL/SPGRP	/SAPSLL/SPGRP	CHAR	6	0	Group of Sanctioned Party List	*
42	SPL_SUSPEND	☐	/SAPSLL/SPSUS	XFELD	CHAR	1	0	Exclude SPL Master from Sanctioned Party List Screening
43	LAUNR	☐	/SAPSLL/LAUNR	NUMC	NUMC	5	0	Sequence Number
44	ICON_SPL_TYP	☐	/SAPSLL/TYP	ICONNAME	CHAR	30	0	SPL - Types - Address - Name
45	SPL_STREET1	☐	AD_STREET	TEXT60	CHAR	60	0	Street
46	SPL_STREET2	☐	AD_STREET	TEXT60	CHAR	60	0	Street
47	SPL_STREET3	☐	AD_STREET	TEXT60	CHAR	60	0	Street
48	SPL_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
49	SPL_PO_CITY	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
50	SPL_PO_CODE	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
51	SPL_PO_COUNTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
52	SPL_HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
53	SPL_PHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
54	SPL_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
55	SPL_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
56	SPL_COUNTRY	☐	/SAPSLL/LAND1	LAND1	CHAR	3	0	Country Key	*
57	SPL_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
58	SPL_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
59	SPL_NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
60	SPL_NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
61	SPL_NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
62	SPL_NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
63	SPL_PASS_COUNTRY	☐	/SAPSLL/SPLAP	LAND1	CHAR	3	0	Country That Issued ID Card for SPL for Legal Control	*
64	ICON_SPL_RES_SYSTEM	☐	/SAPSLL/ICON_SPL_RES_SYSTEM	ICONNAME	CHAR	30	0	Icon for List Output - System Status
65	ICON_SPL_RES_USER	☐	/SAPSLL/ICON_SPL_RES_USER	ICONNAME	CHAR	30	0	Icon for List Output - User Status
66	ICON_SPL_NOTE	☐	/SAPSLL/ICON_SPL_NOTE	ICONNAME	CHAR	30	0	Icon for List Output - Comment
67	ICON_SPL_ALGO	☐	/SAPSLL/ICON_SPL_ALGO	ICONNAME	CHAR	30	0	SPL Algorithm (GTS/TREX)
68	GUID_SPLAUDD	☐	/SAPSLL/GUID_16	SYSUUID	RAW	16	0	Primary Key as GUID in 'RAW' Format
69	COMNT1	☐	/SAPSLL/TEXT80	TEXT80	CHAR	80	0	Descriptive Text 80 Characters Long
70	COMNT2	☐	/SAPSLL/TEXT80	TEXT80	CHAR	80	0	Descriptive Text 80 Characters Long
71	COMNT3	☐	/SAPSLL/TEXT80	TEXT80	CHAR	80	0	Descriptive Text 80 Characters Long
72	NOTE	☐	/SAPSLL/SPL_AUDIT_NOTE	XFELD	CHAR	1	0	SPL: Audit Indicator for Existing Comment

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPSLL/SPL_AT_ITEM_UI_S	AENAM	USR02	BNAME	KEY	1	CN
2	/SAPSLL/SPL_AT_ITEM_UI_S	ERNAM	USR02	BNAME	KEY	1	CN
3	/SAPSLL/SPL_AT_ITEM_UI_S	LGREG	/SAPSLL/T606G	MANDT	KEY	1	CN
4	/SAPSLL/SPL_AT_ITEM_UI_S	MANDT	T000	MANDT	KEY	1	CN
5	/SAPSLL/SPL_AT_ITEM_UI_S	SPL_TZONE_ENTRY	TTZZ	TZONE	REF
6	/SAPSLL/SPL_AT_ITEM_UI_S	SPL_TZONE_FROM	TTZZ	TZONE	REF
7	/SAPSLL/SPL_AT_ITEM_UI_S	SPL_TZONE_TO	TTZZ	TZONE	REF

History

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