SAP ABAP Table /SAPSLL/TSPLA_UPD_S (SLL: Update Structure for /SAPSLL/TSPLA)
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_UPD_S   Table Relationship Diagram
Short Description SLL: Update Structure for /SAPSLL/TSPLA    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
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   Legal Control: SPL Master (Address Data)  
2 .INCLUDE       0   0   SLL: LC: SPL: SPL Master (Address Data) - PK  
3 MANDT MANDT MANDT CLNT 3   0   Client T000
4 .INCLUDE       0   0   SLL: LC: SPL: SPL Master (Address Data) - PK w/o Client  
5 GUID_TSPLA /SAPSLL/GUID_16 SYSUUID RAW 16   0   Primary Key as GUID in 'RAW' Format  
6 .INCLUDE       0   0   SLL: LC: SPL: SPL Master (Address Data) - Data  
7 .INCLUDE       0   0   GTS: Administration: Created By, Changed By, Time Stamp  
8 ERNAM /SAPSLL/ERNAM XUBNAME CHAR 12   0   Name of User Who Created the Object USR02
9 CRTSP /SAPSLL/CRTSP /SAPSLL/TMELS DEC 15   0   Date and Time When Object Was Added  
10 AENAM /SAPSLL/AENAM XUBNAME CHAR 12   0   Name of User Who Changed the Object USR02
11 CHTSP /SAPSLL/CHTSP /SAPSLL/TMELS DEC 15   0   Date and Time When Object Was Changed  
12 .INCLUDE       0   0   SLL: Type of Creation / Change of Entry / Object  
13 CRECO /SAPSLL/CRECO /SAPSLL/CRECO CHAR 2   0   Method of Entry  
14 .INCLUDE       0   0   SLL: Legal Control: SPL: SPL Master (Address Data) - SK  
15 .INCLUDE       0   0   SLL: LC: SPL: SPL Master (Header - PK w/o Client  
16 GUID_TSPL /SAPSLL/GUID_16 SYSUUID RAW 16   0   Primary Key as GUID in 'RAW' Format /SAPSLL/TSPL
17 LAUNR /SAPSLL/LAUNR NUMC NUMC 5   0   Sequence Number  
18 .INCLUDE       0   0   SLL: Valid To  
19 DATBI /SAPSLL/RPTET /SAPSLL/TSTMP DEC 15   0   Definitive Date (Valid-To Date)  
20 .INCLUDE       0   0   SLL: Valid From  
21 DATAB /SAPSLL/RPTST /SAPSLL/TSTMP DEC 15   0   Definitive Date (Valid-From Time)  
22 .INCLUDE       0   0   SLL: LC: SPL: Street of an SPL Address  
23 SPL_STREET1 AD_STREET TEXT60 CHAR 60   0   Street  
24 SPL_STREET2 AD_STREET TEXT60 CHAR 60   0   Street  
25 SPL_STREET3 AD_STREET TEXT60 CHAR 60   0   Street  
26 .INCLUDE       0   0   SLL: LC: SPL: Postal Address of an SPL Address  
27 SPL_PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
28 SPL_PO_CITY AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
29 SPL_PO_CODE AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
30 SPL_PO_COUNTRY AD_POBXCTY LAND1 CHAR 3   0   PO box country T005
31 SPL_PO_REGION AD_POBXREG REGIO CHAR 3   0   Region for PO Box (Country, State, Province, ...) T005S
32 .INCLUDE       0   0   SLL: LC: SPL: Building of an SPL Address  
33 SPL_HOUSE_NUMBER AD_HSNM1 TEXT10 CHAR 10   0   House Number  
34 SPL_BUILDING AD_BLDNG TEXT20 CHAR 20   0   Building (Number or Code)  
35 SPL_ROOM_NUMBER AD_ROOMNUM TEXT10 CHAR 10   0   Room or Appartment Number  
36 .INCLUDE       0   0   SLL: LC: SPL: Telecommunication Data of an SPL Address  
37 SPL_PHONE AD_TELNRLG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
38 SPL_FAX AD_FXNRLNG CHAR30 CHAR 30   0   Complete number: dialling code+number+extension  
39 SPL_TELEX AD_TLXNMBR TEXT30 CHAR 30   0   Telex number  
40 SPL_EMAIL AD_SMTPADR AD_SMTPADR CHAR 241   0   E-Mail Address  
41 SPL_PAGER AD_PAGNMBR TEXT30 CHAR 30   0   Pager number  
42 SPL_MOB_NUMBER AD_MBNMBR1 CHAR30 CHAR 30   0   First Mobile Telephone No.: Dialing Code + Number  
43 .INCLUDE       0   0   SLL: LC: SPL: City of an SPL Address  
44 SPL_POST_CODE AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
45 SPL_CITY AD_CITY1 TEXT40 CHAR 40   0   City  
46 SPL_DISTRICT AD_CITY2 TEXT40 CHAR 40   0   District  
47 .INCLUDE       0   0   SLL: LC: SPL: Country/Region of an SPL Address  
48 SPL_COUNTRY /SAPSLL/LAND1 LAND1 CHAR 3   0   Country Key T005
49 SPL_REGION /SAPSLL/REGIO REGIO CHAR 3   0   Region Key T005S
50 .INCLUDE       0   0   Data/Content/Service Provider for SPL for LC for SLL  
51 SPL_DATA_REF_ID /SAPSLL/EXSPL /SAPSLL/OBJEX CHAR 40   0   Number of Sanction Party List Entry  
52 .INCLUDE       0   0   SLL: LEG: CMP: Match Combination for Comparison  
53 N1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
54 S1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
55 H1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
56 H2 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
57 B2 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
58 I1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
59 I2 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
60 I3 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
61 P1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
62 P2 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
63 P3 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
64 C1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
65 C2 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
66 C3 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
67 R1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
68 R2 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
69 K1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
70 K2 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
71 A1 /SAPSLL/CMPMC XFELD CHAR 1   0   Flag: Origin Relevant for Comparison  
72 DPCTY /SAPSLL/DPCTY /SAPSLL/DPCTY CHAR 3   0   External Country Definition for Data Upload *
73 .INCLUDE       0   0   Legal & Logistics Services: Change Indicator  
74 UPDFL /SAPSLL/UPDFL /SAPSLL/UPDFL CHAR 1   0   Change Indicator  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPSLL/TSPLA_UPD_S AENAM USR02 BNAME KEY 1 CN
2 /SAPSLL/TSPLA_UPD_S ERNAM USR02 BNAME KEY 1 CN
3 /SAPSLL/TSPLA_UPD_S GUID_TSPL /SAPSLL/TSPL MANDT KEY 1 CN
4 /SAPSLL/TSPLA_UPD_S MANDT T000 MANDT KEY 1 CN
5 /SAPSLL/TSPLA_UPD_S SPL_COUNTRY T005 LAND1 REF    
6 /SAPSLL/TSPLA_UPD_S SPL_PO_COUNTRY T005 LAND1 REF    
7 /SAPSLL/TSPLA_UPD_S SPL_PO_REGION T005S BLAND REF    
8 /SAPSLL/TSPLA_UPD_S SPL_REGION T005S BLAND REF    
History
Last changed by/on SAP  20141106 
SAP Release Created in