SAP ABAP Table /SAPSLL/SPL_LIST_OUTPUT_ALL_S (SLL: LC: SPL: Output Structure All Data of an SPL Entity)

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_LIST_OUTPUT_ALL_S	Table Relationship Diagram
Short Description	SLL: LC: SPL: Output Structure All Data of an SPL Entity

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

History

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