SAP ABAP Table /SAPSLL/PRN_I_GEN_S (Customs Document Item: General Data)
Hierarchy
☛
SLL-LEG (Software Component) SLL-LEG 901: Add-On Installation
⤷ SLL-LEG (Application Component) Global Trade Services
⤷ /SAPSLL/LEGAL_PRN_CORE (Package) Legal Services: Printing: Basic Functions (SmartForms)
⤷ SLL-LEG (Application Component) Global Trade Services
⤷ /SAPSLL/LEGAL_PRN_CORE (Package) Legal Services: Printing: Basic Functions (SmartForms)
Basic Data
Table Category | INTTAB | Structure |
Structure | /SAPSLL/PRN_I_GEN_S | Table Relationship Diagram |
Short Description | Customs Document Item: General Data |
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 | GUID_CUHD | /SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
2 | GUID_CUIT | /SAPSLL/GUID_16 | SYSUUID | RAW | 16 | 0 | Primary Key as GUID in 'RAW' Format | ||
3 | ITVSY | /SAPSLL/ITVSY | /SAPSLL/OBJEX_10 | CHAR | 10 | 0 | External Document Item ID from Feeder System | ||
4 | ITNEX | /SAPSLL/ITNEX | /SAPSLL/OBJEX_20 | CHAR | 20 | 0 | External Identification Number of Doc. Item for EDI Commun. | ||
5 | PRVSY | /SAPSLL/PRVSY | /SAPSLL/OBJEX_PRVSY | CHAR | 40 | 0 | Product Number | ||
6 | PRNUM | /SAPSLL/PRNUM | /SAPSLL/PRNUM | CHAR | 20 | 0 | Internal Product Number | ||
7 | PRTXT | /SAPSLL/PRTXT | TEXT60 | CHAR | 60 | 0 | Product Master Short Text | ||
8 | PRBUM | /SAPSLL/PRBUM | MEINS | UNIT | 3 | 0 | Base Unit of Measure in Product Master | * | |
9 | CCNGN | /SAPSLL/PRN_CCNGN | /SAPSLL/CCNGN | CHAR | 30 | 0 | Commodity Code in Foreign Trade | ||
10 | CCNGN_TEXT1 | /SAPSLL/PRN_TEXT60 | TEXT60 | CHAR | 60 | 0 | Goods Description (Commercial / Commodity Code Text) | ||
11 | CCNGN_TEXT2 | /SAPSLL/PRN_TEXT60 | TEXT60 | CHAR | 60 | 0 | Goods Description (Commercial / Commodity Code Text) | ||
12 | CCNGN_TEXT3 | /SAPSLL/PRN_TEXT60 | TEXT60 | CHAR | 60 | 0 | Goods Description (Commercial / Commodity Code Text) | ||
13 | CCNGN_TEXT4 | /SAPSLL/PRN_TEXT60 | TEXT60 | CHAR | 60 | 0 | Goods Description (Commercial / Commodity Code Text) | ||
14 | CCNGN_TEXT5 | /SAPSLL/PRN_TEXT60 | TEXT60 | CHAR | 60 | 0 | Goods Description (Commercial / Commodity Code Text) | ||
15 | CCNGN_TEXT6 | /SAPSLL/PRN_TEXT60 | TEXT60 | CHAR | 60 | 0 | Goods Description (Commercial / Commodity Code Text) | ||
16 | CCNGN_TEXT7 | /SAPSLL/PRN_TEXT60 | TEXT60 | CHAR | 60 | 0 | Goods Description (Commercial / Commodity Code Text) | ||
17 | CTYDP | /SAPSLL/CTYDP | LAND1 | CHAR | 3 | 0 | Country of Departure Key | * | |
18 | CTYAR | /SAPSLL/CTYAR | LAND1 | CHAR | 3 | 0 | Country of Destination Key | * | |
19 | CUCOO | /SAPSLL/CUCOO | LAND1 | CHAR | 3 | 0 | Custom Product's Country of Origin | T005 | |
20 | CUROO | /SAPSLL/CUROO | REGIO | CHAR | 3 | 0 | Product's Region of Origin (CIC) | T005S | |
21 | CUDOF | /SAPSLL/CUDOF | /SAPSLL/CUDOF | CHAR | 1 | 0 | Goods Origin Indicator - Domestic/Foreign | ||
22 | PRFCR | /SAPSLL/PRFCR | CHAR1 | CHAR | 1 | 0 | Preferential Customs Duty Rate Exists (Indicator) | ||
23 | PREFL | /SAPSLL/PREF_FLAG | /SAPSLL/PREF_FLAG | CHAR | 1 | 0 | Preference Status: 0 - No / 1 - Yes | ||
24 | PRODU | /SAPSLL/PRODU | XFELD | CHAR | 1 | 0 | Indicator: Exporter is Goods Manufacturer | ||
25 | EXART | /SAPSLL/EXART | /SAPSLL/EXART | CHAR | 2 | 0 | Customs Business Transaction Type | /SAPSLL/LEGBT | |
26 | CUPRO | /SAPSLL/CUPRO | /SAPSLL/CUPRO | CHAR | 8 | 0 | Place into a Customs Status (Procedure) | * | |
27 | ADPRO | /SAPSLL/ADPRO | /SAPSLL/ADPRO | CHAR | 4 | 0 | Additional Procedure | * | |
28 | ADPRO_TXT | /SAPSLL/TEXT60 | TEXT60 | CHAR | 60 | 0 | Text 60 Characters Long | ||
29 | PTCFL | /SAPSLL/PTCFL | /SAPSLL/CUIND | CHAR | 1 | 0 | Confirmation of Presentation to Customs | * | |
30 | CCNA1 | /SAPSLL/CCNA1 | /SAPSLL/CCNAD | CHAR | 4 | 0 | Additional Code 1 for Commodity Code | ||
31 | CCNA2 | /SAPSLL/CCNA2 | /SAPSLL/CCNAD | CHAR | 4 | 0 | Additional Code 2 for Commodity Code | ||
32 | CCAFA | /SAPSLL/CCAFA | /SAPSLL/CCAFA | CHAR | 5 | 0 | Concession Requested | * | |
33 | CCAFA_TXT | TEXT100 | TEXT100 | CHAR | 100 | 0 | Text (100 characters) | ||
34 | AUART | /SAPSLL/AUART | /SAPSLL/AUART | CHAR | 2 | 0 | ExportType | /SAPSLL/LEGEP | |
35 | CCNGA | /SAPSLL/CCNGA | /SAPSLL/CCNGA | CHAR | 2 | 0 | Range of Goods | * | |
36 | DCTYP | /SAPSLL/DCTYP | /SAPSLL/DCTYP | CHAR | 10 | 0 | Declaration Type | * | |
37 | INCOT | /SAPSLL/INCOT | /SAPSLL/INCOT | CHAR | 3 | 0 | Incoterm | /SAPSLL/TCOINC | |
38 | INCOLO | /SAPSLL/INCOLO | /SAPSLL/LOCA | CHAR | 40 | 0 | Incoterm Location | ||
39 | INCTX | /SAPSLL/INCTX | /SAPSLL/TEXT60 | CHAR | 60 | 0 | Explanation of Incoterm | ||
40 | QUANT | /SAPSLL/QUANT | /SAPSLL/QUANT | QUAN | 16 | 3 | Quantity Field as QUANT | ||
41 | QUAUM | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | T006 | |
42 | ALQUA | /SAPSLL/ALQUA | /SAPSLL/QUANT | QUAN | 16 | 3 | Quantity in Supplementary Unit | ||
43 | ALUOM | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | * | |
44 | ALQUA2 | /SAPSLL/ALQUA | /SAPSLL/QUANT | QUAN | 16 | 3 | Quantity in Supplementary Unit | ||
45 | ALUOM2 | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | * | |
46 | ALQUA3 | /SAPSLL/ALQUA | /SAPSLL/QUANT | QUAN | 16 | 3 | Quantity in Supplementary Unit | ||
47 | ALUOM3 | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | * | |
48 | CTSMU1 | /SAPSLL/CTSMU | /SAPSLL/CTSMU | CHAR | 20 | 0 | External Unit of Measurement | /SAPSLL/TCOTSM | |
49 | CTSMU2 | /SAPSLL/CTSMU | /SAPSLL/CTSMU | CHAR | 20 | 0 | External Unit of Measurement | /SAPSLL/TCOTSM | |
50 | CTSMU3 | /SAPSLL/CTSMU | /SAPSLL/CTSMU | CHAR | 20 | 0 | External Unit of Measurement | /SAPSLL/TCOTSM | |
51 | CUSVA | /SAPSLL/CUSVA | /SAPSLL/CURRB | CURR | 17 | 2 | Customs Value | ||
52 | SUMDU | /SAPSLL/SUMDU | /SAPSLL/CURRB | CURR | 17 | 2 | Customs Total | ||
53 | RESVA | /SAPSLL/RESVA | /SAPSLL/CURRB | CURR | 17 | 2 | Export Refund | ||
54 | CURCU | /SAPSLL/CURCU | WAERS | CUKY | 5 | 0 | Customs Duty Currency | * | |
55 | NETVAL | /SAPSLL/NETVAL | /SAPSLL/AMNT | CURR | 19 | 2 | Net Value | ||
56 | NTCUR | /SAPSLL/AMCUR | WAERS | CUKY | 5 | 0 | Currency of a Value | TCURC | |
57 | GROVAL | /SAPSLL/GROVAL | /SAPSLL/AMNT | CURR | 19 | 2 | Gross Value | ||
58 | GRCUR | /SAPSLL/AMCUR | WAERS | CUKY | 5 | 0 | Currency of a Value | TCURC | |
59 | STAVAL | /SAPSLL/STAVAL | /SAPSLL/AMNT | CURR | 19 | 2 | Statistical Value | ||
60 | STCUR | /SAPSLL/AMCUR | WAERS | CUKY | 5 | 0 | Currency of a Value | TCURC | |
61 | FRCHG | /SAPSLL/FRCHG | /SAPSLL/FRCHG | CHAR | 1 | 0 | Free-of-Charge Item | ||
62 | HTDUTY | /SAPSLL/AMDUTHTS | /SAPSLL/AMNT | CURR | 19 | 2 | Customs Value for Tariff Customs Duty Rate | ||
63 | ADDUTY | /SAPSLL/AMDUTADA | /SAPSLL/AMNT | CURR | 19 | 2 | Customs Value for Antidumping/CVD Rate | ||
64 | IRDUTY | /SAPSLL/AMDUTIRC | /SAPSLL/AMNT | CURR | 19 | 2 | Customs Value for IRC Rate | ||
65 | CUSRA | /SAPSLL/PRN_CUSRA | DEC3_2 | DEC | 5 | 2 | Customs Duty Rate | ||
66 | ANTRA | /SAPSLL/PRN_ANTRA | DEC3_2 | DEC | 5 | 2 | Antidumping Customs Duty Rate | ||
67 | EXCRA | /SAPSLL/PRN_EXCRA | DEC3_2 | DEC | 5 | 2 | Excise Duty Rate | ||
68 | TRINS | /SAPSLL/PRN_TRINS | /SAPSLL/AMNT | CURR | 19 | 2 | Transport and Insurance Costs | ||
69 | CUFEE | /SAPSLL/PRN_CUFEE | DEC3_2 | DEC | 5 | 2 | Customs Processing Fee in Percent | ||
70 | CHMIS | /SAPSLL/PRN_CHMIS | /SAPSLL/AMNT | CURR | 19 | 2 | Other Fees/Duty | ||
71 | CHMIS_2 | /SAPSLL/PRN_CHMIS | /SAPSLL/AMNT | CURR | 19 | 2 | Other Fees/Duty | ||
72 | WEINET | /SAPSLL/WEINET | /SAPSLL/DIMEN | QUAN | 19 | 3 | Net Weight | ||
73 | WEIGRO | /SAPSLL/WEIGRO | /SAPSLL/DIMEN | QUAN | 19 | 3 | Gross Weight | ||
74 | WEIDIM | /SAPSLL/WEIDIM | MEINS | UNIT | 3 | 0 | Unit of Weight | T006 | |
75 | SGIQU | /SAPSLL/SGIQU | /SAPSLL/DIMEN | QUAN | 19 | 3 | Sensitive SGI Quantity | ||
76 | SGICD | /SAPSLL/SGICD | CHAR2 | CHAR | 2 | 0 | SGI Code | ||
77 | DANGO | /SAPSLL/DANGO | XFELD | CHAR | 1 | 0 | Indicator for Goods Considered Dangerous | ||
78 | DANNO | /SAPSLL/DANNO | /SAPSLL/DANNO | CHAR | 4 | 0 | UNDG Dangerous Goods Number | ||
79 | SVMEB | /SAPSLL/SVMEB | CHAR01 | CHAR | 1 | 0 | Indicator: Additional Information/Export Restriction | ||
80 | SVMEA | /SAPSLL/SVMEA | CHAR01 | CHAR | 1 | 0 | Ind.: Additional Information / Export Duties | ||
81 | SVMEX | /SAPSLL/SVMEX | CHAR01 | CHAR | 1 | 0 | Ind.: Additional Information / Export | ||
82 | SVMEE | /SAPSLL/SVMEE | CHAR01 | CHAR | 1 | 0 | Ind.: Additional Information / Export EU | ||
83 | SVMCO | /SAPSLL/SVMCO | LAND1 | CHAR | 3 | 0 | Ind.: Additional Information / Export Country | T005 | |
84 | OPREL | /SAPSLL/OPREL | /SAPSLL/OPREL | CHAR | 1 | 0 | Declaration for Outward Processing | ||
85 | ECPID | /SAPSLL/ECPID_SPI | /SAPSLL/ECPID_SPI | CHAR | 10 | 0 | Customs ID for Customs Procedure with Economic Significance | * | |
86 | IDGDS | /SAPSLL/IDGDS | /SAPSLL/IDGDS | CHAR | 20 | 0 | Additional ID for Stock Separation in CWH, IP, PUCC | ||
87 | LOCID | /SAPSLL/IVM_LOCID | /SAPSLL/IVM_LOCID | CHAR | 3 | 0 | Location ID | ||
88 | CUFIS | /SAPSLL/CSTAT | /SAPSLL/CSTAT | CHAR | 1 | 0 | Customs Status | ||
89 | PCLOC | /SAPSLL/PCLOC | /SAPSLL/PCLOC | CHAR | 20 | 0 | Temporary Storage Location Key | * | |
90 | PCLOC_TXT | /SAPSLL/TEXT60 | TEXT60 | CHAR | 60 | 0 | Text 60 Characters Long | ||
91 | ZREGNR | /SAPSLL/ZREGNR | /SAPSLL/OBJEX | CHAR | 40 | 0 | Customs Registration Number | ||
92 | APLDT | /SAPSLL/APLDT | DATS | DATS | 8 | 0 | Declaration Period for Summarized Declaration | ||
93 | ULNOTE | /SAPSLL/ULNOTE | CHAR132 | CHAR | 132 | 0 | Unloading Comment | ||
94 | INVNR | /SAPSLL/INVNR | /SAPSLL/OBJEX | CHAR | 40 | 0 | Invoice Number | ||
95 | INVDT | /SAPSLL/INVDT | DATS | DATS | 8 | 0 | Invoice Date | ||
96 | ZTERM | /SAPSLL/ZTERM | /SAPSLL/ZTERM | CHAR | 6 | 0 | Term of Payment | * | |
97 | ZTERM_TXT | /SAPSLL/TEXT60 | TEXT60 | CHAR | 60 | 0 | Text 60 Characters Long | ||
98 | OPEDT | /SAPSLL/OPEDT | DATS | DATS | 8 | 0 | Re-Import Period for Outward Processing | ||
99 | PRENR | /SAPSLL/PRENR | CHAR3 | CHAR | 3 | 0 | Prefix of Form Number | ||
100 | DOCNR | /SAPSLL/DOCNR | CHAR10 | CHAR | 10 | 0 | Number of Form | ||
101 | PRDES | /SAPSLL/PRDES | /SAPSLL/PRDES | CHAR | 2 | 0 | Target Procedure | ||
102 | PRSRC | /SAPSLL/PRSRC | /SAPSLL/PRSRC | CHAR | 2 | 0 | Source Procedure | ||
103 | QLCAP | /SAPSLL/QLCAP | /SAPSLL/QLCAP | CHAR | 1 | 0 | Indicator: CAP Products | ||
104 | PYTRP | /SAPSLL/PYTRP | /SAPSLL/CUIND | CHAR | 1 | 0 | Payment Method for Transport Costs | * | |
105 | UCRNO | /SAPSLL/ECC_UCRNO | CHAR70 | CHAR | 70 | 0 | ECC: Unique Consignment Reference Number (UCR) | ||
106 | CRAMT | /SAPSLL/AMNT_CUR | /SAPSLL/CURRF | CURR | 16 | 2 | Currency amount | ||
107 | CRAMC | /SAPSLL/AMCUR | WAERS | CUKY | 5 | 0 | Currency of a Value | * | |
108 | CRPUN | /SAPSLL/PUNIT | /SAPSLL/PUNIT | DEC | 5 | 0 | Price Unit | ||
109 | CRDIM | /SAPSLL/DIMUM | MEINS | UNIT | 3 | 0 | Unit of Measurement of a Dimension | * | |
110 | CRUOM | /SAPSLL/CTSUOM | /SAPSLL/CTSUOM | CHAR | 12 | 0 | Supplementary Unit / Qualifier | * | |
111 | CUSWEI | /SAPSLL/TLC_CUSWEI | /SAPSLL/TLC_CUSWEI | CHAR | 1 | 0 | Base for Customs Duty Calculation by Weight | ||
112 | VATCAT | /SAPSLL/VATCAT | /SAPSLL/VATCAT | CHAR | 4 | 0 | VAT Rate | ||
113 | CTYEND | /SAPSLL/CTYEND | LAND1 | CHAR | 3 | 0 | Country of Ultimate Consignee | * | |
114 | MPSQN | /SAPSLL/PRSQN | NUM9 | NUMC | 9 | 0 | Sequence Number of Product | ||
115 | ADDDA | /SAPSLL/ADDDA_S | STRU | 0 | 0 | ||||
116 | ADDDA1 | /SAPSLL/ADDDA1 | CHAR10 | CHAR | 10 | 0 | Additional Data 1 | ||
117 | ADDDA2 | /SAPSLL/ADDDA2 | CHAR15 | CHAR | 15 | 0 | Additional Data 2 | ||
118 | ADDDA3 | /SAPSLL/ADDDA3 | CHAR30 | CHAR | 30 | 0 | Additional Data 3 | ||
119 | CUST_CUIT | /SAPSLL/CUIT_CUST_S | STRU | 0 | 0 | ||||
120 | ADDDA0 | /SAPSLL/ADDDA0 | CHAR1 | CHAR | 1 | 0 | Additional Data for Unrestricted Use | ||
121 | CUST_LEGCUS | /SAPSLL/LEGCUS_CUST_S | STRU | 0 | 0 | ||||
122 | ADDDA0 | /SAPSLL/ADDDA0 | CHAR1 | CHAR | 1 | 0 | Additional Data for Unrestricted Use |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | /SAPSLL/PRN_I_GEN_S | CUCOO | T005 | LAND1 | |||
2 | /SAPSLL/PRN_I_GEN_S | CUROO | T005S | BLAND | |||
3 | /SAPSLL/PRN_I_GEN_S | GRCUR | TCURC | WAERS | |||
4 | /SAPSLL/PRN_I_GEN_S | INCOT | /SAPSLL/TCOINC | MANDT | |||
5 | /SAPSLL/PRN_I_GEN_S | NTCUR | TCURC | WAERS | |||
6 | /SAPSLL/PRN_I_GEN_S | QUAUM | T006 | MSEHI | |||
7 | /SAPSLL/PRN_I_GEN_S | STCUR | TCURC | WAERS | |||
8 | /SAPSLL/PRN_I_GEN_S | SVMCO | T005 | LAND1 | |||
9 | /SAPSLL/PRN_I_GEN_S | WEIDIM | T006 | MSEHI |
History
Last changed by/on | SAP | 20141106 |
SAP Release Created in | 200 |