SAP ABAP Table /SAPSLL/SPL_CHECK_DSP_TREE2_S (SLL: LC: SPL: Screening: Display Results: ALV Tree SPL)
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_CHECK_DSP_TREE2_S   Table Relationship Diagram
Short Description SLL: LC: SPL: Screening: Display Results: ALV Tree SPL    
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
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /SAPSLL/SPL_CHECK_DSP_TREE2_S AENAM USR02 BNAME KEY 1 CN
2 /SAPSLL/SPL_CHECK_DSP_TREE2_S ERNAM USR02 BNAME KEY 1 CN
3 /SAPSLL/SPL_CHECK_DSP_TREE2_S LGREG /SAPSLL/T606G MANDT KEY 1 CN
4 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_COUNTRY T005 LAND1 REF    
5 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_PASS_COUNTRY T005 LAND1 REF    
6 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_PO_COUNTRY T005 LAND1 REF    
7 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_PO_REGION T005S BLAND REF    
8 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_REGION T005S BLAND REF    
9 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_TZONE_ENTRY TTZZ TZONE REF    
10 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_TZONE_FROM TTZZ TZONE REF    
11 /SAPSLL/SPL_CHECK_DSP_TREE2_S SPL_TZONE_TO TTZZ TZONE REF    
History
Last changed by/on SAP  20141106 
SAP Release Created in 100