SAP ABAP Table /SAPSLL/PR_OGA_S (Output Structure: Products with OGA Codes)
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷ SLL-LEG (Application Component) Global Trade Services
⤷ /SAPSLL/CORE_PRODUCT (Package) Legal Services: Basic Functions: Product
⤷ SLL-LEG (Application Component) Global Trade Services
⤷ /SAPSLL/CORE_PRODUCT (Package) Legal Services: Basic Functions: Product
Basic Data
Table Category | INTTAB | Structure |
Structure | /SAPSLL/PR_OGA_S | Table Relationship Diagram |
Short Description | Output Structure: Products with OGA Codes |
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 | STCTS | /SAPSLL/STCTS | /SAPSLL/STCTS | CHAR | 10 | 0 | Numbering Scheme for Customs Tariff System | * | |
2 | PRVSY | /SAPSLL/PRVSY | /SAPSLL/OBJEX_PRVSY | CHAR | 40 | 0 | Product Number | ||
3 | PRTXT | /SAPSLL/PRTXT | TEXT60 | CHAR | 60 | 0 | Product Master Short Text | ||
4 | CCNGN | /SAPSLL/CCNGN_CLASSIFICATION | /SAPSLL/CCNGN | CHAR | 30 | 0 | Tariff No. | ||
5 | CCNGN_TXT | /SAPSLL/TEXT60 | TEXT60 | CHAR | 60 | 0 | Text 60 Characters Long | ||
6 | OGAGO | /SAPSLL/OGAGO | /SAPSLL/OGAGO | CHAR | 12 | 0 | Authority/Agency of OGA Codes | ||
7 | OGACO | /SAPSLL/OGACO | /SAPSLL/CCNGN | CHAR | 30 | 0 | OGA Code | ||
8 | OGA_TXT | /SAPSLL/TEXT60_OGA | TEXT60 | CHAR | 60 | 0 | Description of OGA Code | ||
9 | CTSPC | /SAPSLL/CTSPC | /SAPSLL/CTSPC | CHAR | 5 | 0 | Code Number Category | * | |
10 | OGA_REL_TXT | /SAPSLL/TEXT60_CTSPC | TEXT60 | CHAR | 60 | 0 | Category Description: Code Number | ||
11 | DATBI | /SAPSLL/RPTET | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-To Date) | ||
12 | GUID_CTSREF_NZR | /SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
13 | GUID_PR | /SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
14 | GUID_CTSNUM_PR | /SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
15 | DATAB8 | /SAPSLL/DATAB | DATS | DATS | 8 | 0 | "Valid From" Date for SAP GTS | ||
16 | DATBI8 | /SAPSLL/DATBI | DATS | DATS | 8 | 0 | "Valid To" Date for SAP GTS | ||
17 | DATAB | /SAPSLL/RPTST | /SAPSLL/TSTMP | DEC | 15 | 0 | Definitive Date (Valid-From Time) | ||
18 | ENDUSE | /SAPSLL/ENDUSE | /SAPSLL/ENDUSE | CHAR | 5 | 0 | End Use of a Customs Product (for Classification) | * | |
19 | .INCLUDE | 0 | 0 | GTS: Product Master: Generic Character. Values - Data w/o SK | |||||
20 | .INCLUDE | 0 | 0 | GTS: Attribute Values Length 01 for Feeder System Chars | |||||
21 | ATTR01A | /SAPSLL/ATTRV01 | /SAPSLL/ATTRV01 | CHAR | 1 | 0 | Attribute Value for Chars from Feeder System (Length 01) | * | |
22 | ATTR01B | /SAPSLL/ATTRV01 | /SAPSLL/ATTRV01 | CHAR | 1 | 0 | Attribute Value for Chars from Feeder System (Length 01) | * | |
23 | ATTR01C | /SAPSLL/ATTRV01 | /SAPSLL/ATTRV01 | CHAR | 1 | 0 | Attribute Value for Chars from Feeder System (Length 01) | * | |
24 | ATTR01D | /SAPSLL/ATTRV01 | /SAPSLL/ATTRV01 | CHAR | 1 | 0 | Attribute Value for Chars from Feeder System (Length 01) | * | |
25 | ATTR01E | /SAPSLL/ATTRV01 | /SAPSLL/ATTRV01 | CHAR | 1 | 0 | Attribute Value for Chars from Feeder System (Length 01) | * | |
26 | .INCLUDE | 0 | 0 | GTS: Attribute Values Length 02 for Feeder System Chars | |||||
27 | ATTR02A | /SAPSLL/ATTRV02 | /SAPSLL/ATTRV02 | CHAR | 2 | 0 | Attribute Value for Chars from Feeder System (Length 02) | * | |
28 | ATTR02B | /SAPSLL/ATTRV02 | /SAPSLL/ATTRV02 | CHAR | 2 | 0 | Attribute Value for Chars from Feeder System (Length 02) | * | |
29 | ATTR02C | /SAPSLL/ATTRV02 | /SAPSLL/ATTRV02 | CHAR | 2 | 0 | Attribute Value for Chars from Feeder System (Length 02) | * | |
30 | ATTR02D | /SAPSLL/ATTRV02 | /SAPSLL/ATTRV02 | CHAR | 2 | 0 | Attribute Value for Chars from Feeder System (Length 02) | * | |
31 | ATTR02E | /SAPSLL/ATTRV02 | /SAPSLL/ATTRV02 | CHAR | 2 | 0 | Attribute Value for Chars from Feeder System (Length 02) | * | |
32 | .INCLUDE | 0 | 0 | GTS: Attribute Values Length 05 for Feeder System Chars | |||||
33 | ATTR05A | /SAPSLL/ATTRV05 | /SAPSLL/ATTRV05 | CHAR | 5 | 0 | Attribute Value for Chars from Feeder System (Length 05) | * | |
34 | ATTR05B | /SAPSLL/ATTRV05 | /SAPSLL/ATTRV05 | CHAR | 5 | 0 | Attribute Value for Chars from Feeder System (Length 05) | * | |
35 | ATTR05C | /SAPSLL/ATTRV05 | /SAPSLL/ATTRV05 | CHAR | 5 | 0 | Attribute Value for Chars from Feeder System (Length 05) | * | |
36 | ATTR05D | /SAPSLL/ATTRV05 | /SAPSLL/ATTRV05 | CHAR | 5 | 0 | Attribute Value for Chars from Feeder System (Length 05) | * | |
37 | ATTR05E | /SAPSLL/ATTRV05 | /SAPSLL/ATTRV05 | CHAR | 5 | 0 | Attribute Value for Chars from Feeder System (Length 05) | * | |
38 | .INCLUDE | 0 | 0 | GTS: Attribute Values Length 10 for Feeder System Chars | |||||
39 | ATTR10A | /SAPSLL/ATTRV10 | /SAPSLL/ATTRV10 | CHAR | 10 | 0 | Attribute Value for Chars from Feeder System (Length 10) | * | |
40 | ATTR10B | /SAPSLL/ATTRV10 | /SAPSLL/ATTRV10 | CHAR | 10 | 0 | Attribute Value for Chars from Feeder System (Length 10) | * | |
41 | ATTR10C | /SAPSLL/ATTRV10 | /SAPSLL/ATTRV10 | CHAR | 10 | 0 | Attribute Value for Chars from Feeder System (Length 10) | * | |
42 | ATTR10D | /SAPSLL/ATTRV10 | /SAPSLL/ATTRV10 | CHAR | 10 | 0 | Attribute Value for Chars from Feeder System (Length 10) | * | |
43 | ATTR10E | /SAPSLL/ATTRV10 | /SAPSLL/ATTRV10 | CHAR | 10 | 0 | Attribute Value for Chars from Feeder System (Length 10) | * | |
44 | .INCLUDE | 0 | 0 | GTS: Attribute Values Length 20 for Feeder System Chars | |||||
45 | ATTR20A | /SAPSLL/ATTRV20 | /SAPSLL/ATTRV20 | CHAR | 20 | 0 | Attribute Value for Chars from Feeder System (Length 20) | * | |
46 | ATTR20B | /SAPSLL/ATTRV20 | /SAPSLL/ATTRV20 | CHAR | 20 | 0 | Attribute Value for Chars from Feeder System (Length 20) | * | |
47 | ATTR20C | /SAPSLL/ATTRV20 | /SAPSLL/ATTRV20 | CHAR | 20 | 0 | Attribute Value for Chars from Feeder System (Length 20) | * | |
48 | ATTR20D | /SAPSLL/ATTRV20 | /SAPSLL/ATTRV20 | CHAR | 20 | 0 | Attribute Value for Chars from Feeder System (Length 20) | * | |
49 | ATTR20E | /SAPSLL/ATTRV20 | /SAPSLL/ATTRV20 | CHAR | 20 | 0 | Attribute Value for Chars from Feeder System (Length 20) | * | |
50 | .INCLUDE | 0 | 0 | GTS: Attribute Values Length 40 for Feeder System Chars | |||||
51 | ATTR40A | /SAPSLL/ATTRV40 | /SAPSLL/ATTRV40 | CHAR | 40 | 0 | Attribute Value for Chars from Feeder System (Length 40) | * | |
52 | ATTR40B | /SAPSLL/ATTRV40 | /SAPSLL/ATTRV40 | CHAR | 40 | 0 | Attribute Value for Chars from Feeder System (Length 40) | * | |
53 | ATTR40C | /SAPSLL/ATTRV40 | /SAPSLL/ATTRV40 | CHAR | 40 | 0 | Attribute Value for Chars from Feeder System (Length 40) | * | |
54 | ATTR40D | /SAPSLL/ATTRV40 | /SAPSLL/ATTRV40 | CHAR | 40 | 0 | Attribute Value for Chars from Feeder System (Length 40) | * | |
55 | ATTR40E | /SAPSLL/ATTRV40 | /SAPSLL/ATTRV40 | CHAR | 40 | 0 | Attribute Value for Chars from Feeder System (Length 40) | * | |
56 | .INCLUDE | 0 | 0 | GTS: Attribute Values Length 60 for Feeder System Chars | |||||
57 | ATTR60A | /SAPSLL/ATTRV60 | /SAPSLL/ATTRV60 | CHAR | 60 | 0 | Attribute Value Length 60 for Feeder System Characteristics | * | |
58 | ATTR60B | /SAPSLL/ATTRV60 | /SAPSLL/ATTRV60 | CHAR | 60 | 0 | Attribute Value Length 60 for Feeder System Characteristics | * | |
59 | ATTR60C | /SAPSLL/ATTRV60 | /SAPSLL/ATTRV60 | CHAR | 60 | 0 | Attribute Value Length 60 for Feeder System Characteristics | * | |
60 | ATTR60D | /SAPSLL/ATTRV60 | /SAPSLL/ATTRV60 | CHAR | 60 | 0 | Attribute Value Length 60 for Feeder System Characteristics | * | |
61 | ATTR60E | /SAPSLL/ATTRV60 | /SAPSLL/ATTRV60 | CHAR | 60 | 0 | Attribute Value Length 60 for Feeder System Characteristics | * | |
62 | .INCLUDE | 0 | 0 | Customs Prod. Master: Extendable Structure for /SAPSLL/PRGEN | |||||
63 | ADDDA0 | /SAPSLL/ADDDA0 | CHAR1 | CHAR | 1 | 0 | Additional Data for Unrestricted Use | ||
64 | .INCLUDE | 0 | 0 | GTS: Administration: Created By, Changed By, Time Stamp | |||||
65 | ERNAM | /SAPSLL/ERNAM | XUBNAME | CHAR | 12 | 0 | Name of User Who Created the Object | USR02 | |
66 | CRTSP | /SAPSLL/CRTSP | /SAPSLL/TMELS | DEC | 15 | 0 | Date and Time When Object Was Added | ||
67 | AENAM | /SAPSLL/AENAM | XUBNAME | CHAR | 12 | 0 | Name of User Who Changed the Object | USR02 | |
68 | CHTSP | /SAPSLL/CHTSP | /SAPSLL/TMELS | DEC | 15 | 0 | Date and Time When Object Was Changed |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /SAPSLL/PR_OGA_S | AENAM | USR02 | BNAME | KEY | 1 | CN |
2 | /SAPSLL/PR_OGA_S | ERNAM | USR02 | BNAME | KEY | 1 | CN |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in | 900 |