SAP ABAP Table /SAPSLL/TSPLA_S (SLL: LC: SPL: SPL Master (Address Data) - 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

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPSLL/TSPLA_S	Table Relationship Diagram
Short Description	SLL: LC: SPL: SPL Master (Address Data) - Data

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	GTS: Administration: Created By, Changed By, Time Stamp
2	ERNAM	☐	/SAPSLL/ERNAM	XUBNAME	CHAR	12	0	Name of User Who Created the Object	USR02
3	CRTSP	☐	/SAPSLL/CRTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Added
4	AENAM	☐	/SAPSLL/AENAM	XUBNAME	CHAR	12	0	Name of User Who Changed the Object	USR02
5	CHTSP	☐	/SAPSLL/CHTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Changed
6	.INCLUDE	☐				0	0	SLL: Type of Creation / Change of Entry / Object
7	CRECO	☐	/SAPSLL/CRECO	/SAPSLL/CRECO	CHAR	2	0	Method of Entry
8	.INCLUDE	☐				0	0	SLL: Legal Control: SPL: SPL Master (Address Data) - SK
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	/SAPSLL/TSPL
11	LAUNR	☐	/SAPSLL/LAUNR	NUMC	NUMC	5	0	Sequence Number
12	.INCLUDE	☐				0	0	SLL: Valid To
13	DATBI	☐	/SAPSLL/RPTET	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-To Date)
14	.INCLUDE	☐				0	0	SLL: Valid From
15	DATAB	☐	/SAPSLL/RPTST	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-From Time)
16	.INCLUDE	☐				0	0	SLL: LC: SPL: Street of an SPL Address
17	SPL_STREET1	☐	AD_STREET	TEXT60	CHAR	60	0	Street
18	SPL_STREET2	☐	AD_STREET	TEXT60	CHAR	60	0	Street
19	SPL_STREET3	☐	AD_STREET	TEXT60	CHAR	60	0	Street
20	.INCLUDE	☐				0	0	SLL: LC: SPL: Postal Address of an SPL Address
21	SPL_PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
22	SPL_PO_CITY	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
23	SPL_PO_CODE	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
24	SPL_PO_COUNTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
25	SPL_PO_REGION	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
26	.INCLUDE	☐				0	0	SLL: LC: SPL: Building of an SPL Address
27	SPL_HOUSE_NUMBER	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
28	SPL_BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
29	SPL_ROOM_NUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
30	.INCLUDE	☐				0	0	SLL: LC: SPL: Telecommunication Data of an SPL Address
31	SPL_PHONE	☐	AD_TELNRLG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
32	SPL_FAX	☐	AD_FXNRLNG	CHAR30	CHAR	30	0	Complete number: dialling code+number+extension
33	SPL_TELEX	☐	AD_TLXNMBR	TEXT30	CHAR	30	0	Telex number
34	SPL_EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
35	SPL_PAGER	☐	AD_PAGNMBR	TEXT30	CHAR	30	0	Pager number
36	SPL_MOB_NUMBER	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
37	.INCLUDE	☐				0	0	SLL: LC: SPL: City of an SPL Address
38	SPL_POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
39	SPL_CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
40	SPL_DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
41	.INCLUDE	☐				0	0	SLL: LC: SPL: Country/Region of an SPL Address
42	SPL_COUNTRY	☐	/SAPSLL/LAND1	LAND1	CHAR	3	0	Country Key	T005
43	SPL_REGION	☐	/SAPSLL/REGIO	REGIO	CHAR	3	0	Region Key	T005S
44	.INCLUDE	☐				0	0	Data/Content/Service Provider for SPL for LC for SLL
45	SPL_DATA_REF_ID	☐	/SAPSLL/EXSPL	/SAPSLL/OBJEX	CHAR	40	0	Number of Sanction Party List Entry
46	.INCLUDE	☐				0	0	SLL: LEG: CMP: Match Combination for Comparison
47	N1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
48	S1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
49	H1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
50	H2	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
51	B2	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
52	I1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
53	I2	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
54	I3	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
55	P1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
56	P2	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
57	P3	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
58	C1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
59	C2	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
60	C3	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
61	R1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
62	R2	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
63	K1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
64	K2	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
65	A1	☐	/SAPSLL/CMPMC	XFELD	CHAR	1	0	Flag: Origin Relevant for Comparison
66	DPCTY	☐	/SAPSLL/DPCTY	/SAPSLL/DPCTY	CHAR	3	0	External Country Definition for Data Upload	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPSLL/TSPLA_S	AENAM	USR02	BNAME	KEY	1	CN
2	/SAPSLL/TSPLA_S	ERNAM	USR02	BNAME	KEY	1	CN
3	/SAPSLL/TSPLA_S	GUID_TSPL	/SAPSLL/TSPL	MANDT	KEY	1	CN
4	/SAPSLL/TSPLA_S	SPL_COUNTRY	T005	LAND1	REF
5	/SAPSLL/TSPLA_S	SPL_PO_COUNTRY	T005	LAND1	REF
6	/SAPSLL/TSPLA_S	SPL_PO_REGION	T005S	BLAND	REF
7	/SAPSLL/TSPLA_S	SPL_REGION	T005S	BLAND	REF

History

Last changed by/on	SAP	20141106
SAP Release Created in