SAP ABAP Table /SAPSLL/EUI_SPL_SGL_OUTPUT_S (SLL: LC: SPL: EUI: Output Structure for SPL Single Screening)

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/EUI_SPL_SGL_OUTPUT_S	Table Relationship Diagram
Short Description	SLL: LC: SPL: EUI: Output Structure for SPL Single Screening

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: Legal Cont.: SPL: SPL Master (Header Data) - Prim. Key
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	SLL: LC: SPL: SPL Master (Header - PK w/o Client
4	GUID_TSPL	☐	/SAPSLL/GUID_16	SYSUUID	RAW	16	0	Primary Key as GUID in 'RAW' Format
5	.INCLUDE	☐				0	0	SLL: Legal Cont.: SPL: SPL Master (Header Data) - Sec. Key
6	LGREG	☐	/SAPSLL/LGREG	/SAPSLL/LGREG	CHAR	5	0	Legal Regulation	/SAPSLL/T606G
7	SPL_LIST_TYPE	☐	/SAPSLL/SPCAT	/SAPSLL/SPCAT	CHAR	5	0	Type of Sanctioned Party List for Legal Control	/SAPSLL/T608L
8	SPL_PROVIDER_ID	☐	/SAPSLL/PRTN_GUID_16	SYSUUID	RAW	16	0	Primary Key of Business Partner
9	SPL_DATA_REF_ID	☐	/SAPSLL/EXSPL	/SAPSLL/OBJEX	CHAR	40	0	Number of Sanction Party List Entry
10	.INCLUDE	☐				0	0	Validity Period
11	DATAB8	☐	/SAPSLL/DATAB	DATS	DATS	8	0	"Valid From" Date for SAP GTS
12	DATBI8	☐	/SAPSLL/DATBI	DATS	DATS	8	0	"Valid To" Date for SAP GTS
13	DATTO	☐	/SAPSLL/DATTO	DATS	DATS	8	0	Date Added to Boycott List for SPL for Legal Control
14	SPL_REF_TYPE	☐	/SAPSLL/SPLRE	/SAPSLL/SPLRE	CHAR	6	0	Type of Reference for SPL for Legal Control	*
15	.INCLUDE	☐				0	0	SLL: LC: SPL: Name of an SPL Address
16	SPL_NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
17	SPL_NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
18	SPL_NAME3	☐	AD_NAME3	TEXT40	CHAR	40	0	Name 3
19	SPL_NAME4	☐	AD_NAME4	TEXT40	CHAR	40	0	Name 4
20	SPL_NAME_CO	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
21	.INCLUDE	☐				0	0	SLL: LC: SPL: Street of an SPL Address
22	SPL_STREET1	☐	AD_STREET	TEXT60	CHAR	60	0	Street
23	SPL_STREET2	☐	AD_STREET	TEXT60	CHAR	60	0	Street
24	SPL_STREET3	☐	AD_STREET	TEXT60	CHAR	60	0	Street
25	.INCLUDE	☐				0	0	SLL: LC: SPL: Postal Address of an SPL Address
26	SPL_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
27	SPL_PO_CITY	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
28	SPL_PO_CODE	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
29	SPL_PO_COUNTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
30	SPL_PO_REGION	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
31	.INCLUDE	☐				0	0	SLL: LC: SPL: Building of an SPL Address
32	SPL_HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
33	SPL_BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
34	SPL_ROOM_NUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
35	.INCLUDE	☐				0	0	SLL: LC: SPL: City of an SPL Address
36	SPL_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
37	SPL_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
38	SPL_DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
39	.INCLUDE	☐				0	0	SLL: LC: SPL: Country/Region of an SPL Address
40	SPL_COUNTRY	☐	/SAPSLL/LAND1	LAND1	CHAR	3	0	Country Key	T005
41	SPL_REGION	☐	/SAPSLL/REGIO	REGIO	CHAR	3	0	Region Key	T005S
42	QUALITY	☐	/SAPSLL/SPL_QUALITY	PROZPB	DEC	3	0	LC: SPL: SPL Screening Hit Rate in Percent
43	TXT_LIST_TYPE	☐	/SAPSLL/TEXT60	TEXT60	CHAR	60	0	Text 60 Characters Long

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPSLL/EUI_SPL_SGL_OUTPUT_S	LGREG	/SAPSLL/T606G	MANDT	KEY	1	CN
2	/SAPSLL/EUI_SPL_SGL_OUTPUT_S	MANDT	T000	MANDT	KEY	1	CN
3	/SAPSLL/EUI_SPL_SGL_OUTPUT_S	SPL_COUNTRY	T005	LAND1	REF
4	/SAPSLL/EUI_SPL_SGL_OUTPUT_S	SPL_PO_COUNTRY	T005	LAND1	REF
5	/SAPSLL/EUI_SPL_SGL_OUTPUT_S	SPL_PO_REGION	T005S	BLAND	REF
6	/SAPSLL/EUI_SPL_SGL_OUTPUT_S	SPL_REGION	T005S	BLAND	REF

History

Last changed by/on	SAP	20141106
SAP Release Created in