SAP ABAP Table /SAPSLL/LLNS_KN_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
⤷ 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_KN_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 | VALID_FROM | /SAPSLL/DATAB | DATS | DATS | 8 | 0 | "Valid From" Date for SAP GTS | ||
2 | VALID_TO | /SAPSLL/DATBI | DATS | DATS | 8 | 0 | "Valid To" Date for SAP GTS | ||
3 | .INCLUDE | 0 | 0 | L & L Services - Country-Specific Customs Tariff No. | |||||
4 | .INCLUDE | 0 | 0 | SLL: Country-Specific Customs Tariff Number - PK | |||||
5 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
6 | .INCLUDE | 0 | 0 | SLL: Country-Specific Customs Tariff Number - PK w/o Client | |||||
7 | GUID_CTSNUMC | /SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
8 | .INCLUDE | 0 | 0 | SLL: Country-Specific Customs Tariff No. - Data Part | |||||
9 | .INCLUDE | 0 | 0 | SLL: Country-Specific Customs Tariff Number - SK | |||||
10 | LAND1 | /SAPSLL/LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
11 | .INCLUDE | 0 | 0 | SLL: Customs Tariff Number - SK | |||||
12 | .INCLUDE | 0 | 0 | SLL: Generic Part of Customs Tariff Number - SK | |||||
13 | .INCLUDE | 0 | 0 | SLL: Structure Segment Customs Tariff System - PK w/o Client | |||||
14 | STCTS | /SAPSLL/STCTS | /SAPSLL/STCTS | CHAR | 10 | 0 | Numbering Scheme for Customs Tariff System | /SAPSLL/TCOTS | |
15 | EXSID | /SAPSLL/EXSID | /SAPSLL/EXSID | CHAR | 40 | 0 | External Identification of Data Record by Data Provider | ||
16 | .INCLUDE | 0 | 0 | SLL: Valid To | |||||
17 | DATBI | /SAPSLL/RPTET | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-To Date) | ||
18 | .INCLUDE | 0 | 0 | SLL: Customs Tariff No. - Data Part W/O SK | |||||
19 | .INCLUDE | 0 | 0 | SLL: Valid From | |||||
20 | DATAB | /SAPSLL/RPTST | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-From Time) | ||
21 | CRECO | /SAPSLL/CRECO | /SAPSLL/CRECO | CHAR | 2 | 0 | Method of Entry | ||
22 | GUID_MOBJ | /SAPSLL/MOBJ_GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key of Main Object | /SAPSLL/CTSGEN | |
23 | GUID_POBJ | /SAPSLL/POBJ_GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key of Preceding Object | /SAPSLL/CTSGEN | |
24 | STRCN | /SAPSLL/STRCN | /SAPSLL/STRCN | NUMC | 3 | 0 | Level of Structure Segment of Customs Tariff System | * | |
25 | CCNGN | /SAPSLL/CCNGN | /SAPSLL/CCNGN | CHAR | 30 | 0 | Number (Generic/Structured) | ||
26 | GROUPING | /SAPSLL/GROUPING | CHAR10 | CHAR | 10 | 0 | Dashes of LLNS Numbers | ||
27 | OGAGO | /SAPSLL/OGAGO | /SAPSLL/OGAGO | CHAR | 12 | 0 | Authority/Agency of OGA Codes | ||
28 | .INCLUDE | 0 | 0 | GTS: Administration: Created By, Changed By, Time Stamp | |||||
29 | ERNAM | /SAPSLL/ERNAM | XUBNAME | CHAR | 12 | 0 | Name of User Who Created the Object | USR02 | |
30 | CRTSP | /SAPSLL/CRTSP | /SAPSLL/TMELS | DEC | 15 | 0 | Date and Time When Object Was Added | ||
31 | AENAM | /SAPSLL/AENAM | XUBNAME | CHAR | 12 | 0 | Name of User Who Changed the Object | USR02 | |
32 | CHTSP | /SAPSLL/CHTSP | /SAPSLL/TMELS | DEC | 15 | 0 | Date and Time When Object Was Changed | ||
33 | .INCLUDE | 0 | 0 | SLL: Customs Tariff Number - 3 Dimensions | |||||
34 | DIMUM01 | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | T006 | |
35 | DIMUM02 | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | T006 | |
36 | DIMUM03 | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | T006 | |
37 | .INCLUDE | 0 | 0 | SLL: External Units of Measurement - Set of 3 | |||||
38 | CTSMU1 | /SAPSLL/CTSMU | /SAPSLL/CTSMU | CHAR | 20 | 0 | External Unit of Measurement | /SAPSLL/TCOTSM | |
39 | CTSMU2 | /SAPSLL/CTSMU | /SAPSLL/CTSMU | CHAR | 20 | 0 | External Unit of Measurement | /SAPSLL/TCOTSM | |
40 | CTSMU3 | /SAPSLL/CTSMU | /SAPSLL/CTSMU | CHAR | 20 | 0 | External Unit of Measurement | /SAPSLL/TCOTSM | |
41 | CTSPC | /SAPSLL/CTSPC | /SAPSLL/CTSPC | CHAR | 5 | 0 | Code Number Category | /SAPSLL/TCOTSP | |
42 | CTSTT | /SAPSLL/CTSTT | /SAPSLL/CTSTT | CHAR | 1 | 0 | Text Type for Customs Tariff System | ||
43 | LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
44 | TEXT | /SAPSLL/TEXT240 | TEXT240 | CHAR | 240 | 0 | Description of Length 240 | ||
45 | LAUNR | /SAPSLL/LAUNR | NUMC | NUMC | 5 | 0 | Sequence Number |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /SAPSLL/LLNS_KN_CODE_TREE_S | AENAM | USR02 | BNAME | KEY | 1 | CN |
2 | /SAPSLL/LLNS_KN_CODE_TREE_S | CTSPC | /SAPSLL/TCOTSP | MANDT | 1 | CN | |
3 | /SAPSLL/LLNS_KN_CODE_TREE_S | DIMUM01 | T006 | MSEHI | REF | ||
4 | /SAPSLL/LLNS_KN_CODE_TREE_S | DIMUM02 | T006 | MSEHI | REF | ||
5 | /SAPSLL/LLNS_KN_CODE_TREE_S | DIMUM03 | T006 | MSEHI | REF | ||
6 | /SAPSLL/LLNS_KN_CODE_TREE_S | ERNAM | USR02 | BNAME | KEY | 1 | CN |
7 | /SAPSLL/LLNS_KN_CODE_TREE_S | GUID_MOBJ | /SAPSLL/CTSGEN | MANDT | KEY | 1 | CN |
8 | /SAPSLL/LLNS_KN_CODE_TREE_S | GUID_POBJ | /SAPSLL/CTSGEN | MANDT | KEY | 1 | CN |
9 | /SAPSLL/LLNS_KN_CODE_TREE_S | LAND1 | T005 | LAND1 | KEY | 1 | CN |
10 | /SAPSLL/LLNS_KN_CODE_TREE_S | MANDT | T000 | MANDT | KEY | 1 | CN |
11 | /SAPSLL/LLNS_KN_CODE_TREE_S | STCTS | /SAPSLL/TCOTS | MANDT | KEY | 1 | CN |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in | 700 |