SAP ABAP Table /SAPSLL/LLNS_ECCN_CODE_TREE_S (SLL: Structure of Tree for Numbering Schemes)

Hierarchy

☛ SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
   ⤷ SLL (Application Component) Global Trade Services
     ⤷ /SAPSLL/WEBUI_CORE (Package) GTS: WEB UI: Common Basic Functions

Basic Data

Table Category	INTTAB	Structure
Structure	/SAPSLL/LLNS_ECCN_CODE_TREE_S	Table Relationship Diagram
Short Description	SLL: Structure of Tree for Numbering Schemes

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: Generic Part of Customs Tariff Number - PK
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	SLL: Generic Part of Customs Tariff Number - PK w/o Client
4	GUID_CTSGEN	☐	/SAPSLL/GUID_16	SYSUUID	RAW	16	0	Primary Key as GUID in 'RAW' Format
5	.INCLUDE	☐				0	0	SLL: Generic Part of Customs Tariff Number - Data Part
6	.INCLUDE	☐				0	0	SLL: Generic Part of Customs Tariff Number - SK
7	.INCLUDE	☐				0	0	SLL: Structure Segment Customs Tariff System - PK w/o Client
8	STCTS	☐	/SAPSLL/STCTS	/SAPSLL/STCTS	CHAR	10	0	Numbering Scheme for Customs Tariff System	/SAPSLL/TCOTS
9	EXSID	☐	/SAPSLL/EXSID	/SAPSLL/EXSID	CHAR	40	0	External Identification of Data Record by Data Provider
10	.INCLUDE	☐				0	0	SLL: Valid To
11	DATBI	☐	/SAPSLL/RPTET	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-To Date)
12	.INCLUDE	☐				0	0	SLL: Customs Tariff No. - Data Part W/O SK
13	.INCLUDE	☐				0	0	SLL: Valid From
14	DATAB	☐	/SAPSLL/RPTST	/SAPSLL/TSTMP	DEC	15	0	Definitive Date (Valid-From Time)
15	CRECO	☐	/SAPSLL/CRECO	/SAPSLL/CRECO	CHAR	2	0	Method of Entry
16	GUID_MOBJ	☐	/SAPSLL/MOBJ_GUID_16	SYSUUID	RAW	16	0	Primary Key of Main Object	/SAPSLL/CTSGEN
17	GUID_POBJ	☐	/SAPSLL/POBJ_GUID_16	SYSUUID	RAW	16	0	Primary Key of Preceding Object	/SAPSLL/CTSGEN
18	STRCN	☐	/SAPSLL/STRCN	/SAPSLL/STRCN	NUMC	3	0	Level of Structure Segment of Customs Tariff System	*
19	CCNGN	☐	/SAPSLL/CCNGN	/SAPSLL/CCNGN	CHAR	30	0	Number (Generic/Structured)
20	GROUPING	☐	/SAPSLL/GROUPING	CHAR10	CHAR	10	0	Dashes of LLNS Numbers
21	OGAGO	☐	/SAPSLL/OGAGO	/SAPSLL/OGAGO	CHAR	12	0	Authority/Agency of OGA Codes
22	.INCLUDE	☐				0	0	GTS: Administration: Created By, Changed By, Time Stamp
23	ERNAM	☐	/SAPSLL/ERNAM	XUBNAME	CHAR	12	0	Name of User Who Created the Object	USR02
24	CRTSP	☐	/SAPSLL/CRTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Added
25	AENAM	☐	/SAPSLL/AENAM	XUBNAME	CHAR	12	0	Name of User Who Changed the Object	USR02
26	CHTSP	☐	/SAPSLL/CHTSP	/SAPSLL/TMELS	DEC	15	0	Date and Time When Object Was Changed
27	ENDLINE	☐	/SAPSLL/ENDLINE	XFELD	CHAR	1	0	Indicates a Number as Final Level
28	VALID_FROM	☐	/SAPSLL/DATAB	DATS	DATS	8	0	"Valid From" Date for SAP GTS
29	VALID_TO	☐	/SAPSLL/DATBI	DATS	DATS	8	0	"Valid To" Date for SAP GTS
30	CTSTT	☐	/SAPSLL/CTSTT	/SAPSLL/CTSTT	CHAR	1	0	Text Type for Customs Tariff System
31	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
32	LAUNR	☐	/SAPSLL/LAUNR	NUMC	NUMC	5	0	Sequence Number
33	TEXT1	☐			CHAR	6000	0
34	DUTY_RATEA	☐	/SAPSLL/TEXT120	TEXT120	CHAR	120	0	Description of Length 120
35	DUTY_RATEB	☐	/SAPSLL/TEXT120	TEXT120	CHAR	120	0	Description of Length 120
36	DUTY_RATEC	☐	/SAPSLL/TEXT120	TEXT120	CHAR	120	0	Description of Length 120
37	CCNGN_SORT	☐	/SAPSLL/CCNGN	/SAPSLL/CCNGN	CHAR	30	0	Number (Generic/Structured)
38	IS_LEAF	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
39	IS_EXPANDED	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
40	CHILDREN_LOADED	☐	BOOLEAN	BOOLEAN	CHAR	1	0	Boolean Variable (X=True, -=False, Space=Unknown)
41	PATH	☐			STRG	0	0
42	PARENT_PATH	☐			STRG	0	0
43	TEXT2	☐	/SAPSLL/TEXT240	TEXT240	CHAR	240	0	Description of Length 240
44	ORIGIN_CCNGN	☐	/SAPSLL/CCNGN	/SAPSLL/CCNGN	CHAR	30	0	Number (Generic/Structured)
45	LAND1	☐	/SAPSLL/LAND1	LAND1	CHAR	3	0	Country Key	*
46	.INCLUDE	☐				0	0	SLL: Customs Tariff Number - 3 Dimensions
47	DIMUM01	☐	/SAPSLL/DIMUM	MEINS	UNIT	3	0	Unit of Measurement of a Dimension	T006
48	DIMUM02	☐	/SAPSLL/DIMUM	MEINS	UNIT	3	0	Unit of Measurement of a Dimension	T006
49	DIMUM03	☐	/SAPSLL/DIMUM	MEINS	UNIT	3	0	Unit of Measurement of a Dimension	T006
50	CTSPC	☐	/SAPSLL/CTSPC	/SAPSLL/CTSPC	CHAR	5	0	Code Number Category	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/SAPSLL/LLNS_ECCN_CODE_TREE_S	AENAM	USR02	BNAME	KEY	1	CN
2	/SAPSLL/LLNS_ECCN_CODE_TREE_S	DIMUM01	T006	MSEHI	REF
3	/SAPSLL/LLNS_ECCN_CODE_TREE_S	DIMUM02	T006	MSEHI	REF
4	/SAPSLL/LLNS_ECCN_CODE_TREE_S	DIMUM03	T006	MSEHI	REF
5	/SAPSLL/LLNS_ECCN_CODE_TREE_S	ERNAM	USR02	BNAME	KEY	1	CN
6	/SAPSLL/LLNS_ECCN_CODE_TREE_S	GUID_MOBJ	/SAPSLL/CTSGEN	MANDT	KEY	1	CN
7	/SAPSLL/LLNS_ECCN_CODE_TREE_S	GUID_POBJ	/SAPSLL/CTSGEN	MANDT	KEY	1	CN
8	/SAPSLL/LLNS_ECCN_CODE_TREE_S	MANDT	T000	MANDT	KEY	1	CN
9	/SAPSLL/LLNS_ECCN_CODE_TREE_S	STCTS	/SAPSLL/TCOTS	MANDT	KEY	1	CN

History

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