Customs Documents 
DataSource Transactional Data: 0SLL_CD_1
This DataSource contains transaction data from customs documents created in SAP Global Trade Services (SAP GTS), such as customs declarations and customs shipments, that were created in the following services:
Customs processing
Transit procedure
Preference processing
Restitution handling
That data that is extracted in SAP NetWeaver Business Intelligence (BI) is used to update DataStore object Customs Document, 0SLL_DS_01.
The customs document date, which is extracted from either field SHPTS or PTCTS in the table of origin /SAPSLL/CUHDDAT, depends on whether the customs procedure is for an import or export transaction. In the import case, the presentation/declaration date is used as the document date (Presentation/Declaration Date). Fore more information, see the transportation tab page (Transport.) in the "Customs Processing" service of SAP GTS. In the case of an export transaction, the source field in the customs document is called the transit date for export (Shipping Date). Fore more information, see the transportation tab page (Transport.) in the "Transit Procedure" service of SAP GTS.
In any of the services you use in SAP GTS, the country of departure, which is extracted from field CTYDP in either table of origin /SAPSLL/CUIT or /SAPSLL/CUHD, can be extracted at both header and item level in the customs document. For more information, see the transportation tab page (Transport.) at header level, under 
Countries 
Issue 
and at item level in the Destination tab page: Country of Departure
The country of destination, which is extracted from the field CTYAR in either table of origin /SAPSLL/CUIT or /SAPSLL/CUHD, can only be extracted at header level in the customs document. More information is available in SAP Customs Management, in the transportation tab page (Transport.) at header level through path: Countries Issue .
The following fields contain values that you maintain in the Implementation Guide (IMG) for SAP GTS under SAP Customs Management Customs Processing Service Calculation of Customs Duties Define Customs Duty Framework :
NETVA: Net Price/Invoice Value (001)
STAVA: Statistical Value (003)
CUSVA: Customs Value or Value not Shown Separately (002 or C1)
TCODU: Value not Shown Separately (third-country duty - B1)
PREDU: Value not Shown Separately (preferential duty - B2)
PHPDU: Value not Shown Separately (duty on pharmaceutical products - B3)
SUSDU: Value not Shown Separately (suspension of duty - B4)
ADUDU: Value not Shown Separately (anti-dumping duty - B5)
SUMDU: Value not Shown Separately (total duties - B2)
CURCU: Customs currency
For more information on the value types, such as invoice values and statistical values, and the customs duty types to which you assign the values, see the IMG documentation.
Technical Data
Application Component | SAP GTS (SLL-LEG) |
|---|---|
Available as of Release | 3.0 |
Shipment | November 2004 |
Content Versions | – |
RemoteCube-Capable | No |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Prerequisites
You have completed the following steps in the Implementation Guide (IMG) for SAP GTS:
You have set the BIW flag to transfer customs documents from SAP GTS to BI, using path
SAP Global Trade Services General Settings Organizational Structure Control at Foreign Trade Organization Level . You have entered a unit of weight in the table for GTS: Control Settings at Foreign Trade Organization Level. This unit of weight must be the common unit of weight that you want to be used in strategic reporting in BI . The values in the fields for gross weight (WEIGR), net weight (WEINE) and unit of weight (WEIDI) depend on the unit of weight you maintain at FTO level in the IMG for converting weights for SAP BW. Note that the value for field NUMIT, number of document items, is always one.
You have activated document types for transferring relevant data from customs documents in SAP GTS to BI. To do so, in the Implementation Guide (IMG) for SAP GTS, you choose path
SAP Customs Management General Settings Document Structure Define Customs Document Types . You have set the indicator Transfer to SAP Business Information Warehouse Active.You have activated the appropriate item categories in the customs documents for transferring relevant data from business transactions in SAP GTS to BI. To do so, in the Implementation Guide (IMG) for SAP GTS, you choose path
SAP Customs Management General Settings Document Structure Define Customs Document Item . You have set the indicator Transfer to SAP Business Information Warehouse Active.
Note
You must have set the indicators at all of the following three levels in the Customizing settings for SAP GTS to ensure the necessary transfer of data to BI.
Document level
Item level
Organizational unit level (FTO).
Data Modeling
Delta Update
It is possible to perform a delta extraction for this DataSource using the delta method AIMD. However, delta data cannot be extracted from data archives.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
CDNUM |
Customs Document Number |
/SAPSLL/CUHD |
CORDER |
CDYEA |
Customs Document Year |
/SAPSLL/CUHD |
COYEAR |
CDITN |
Customs Document Item Number |
/SAPSLL/CUIT |
ITVSY |
INDEI |
Import/Export Indicator |
/SAPSLL/CUHD |
INDEI |
ROCANCEL |
Cancel Field |
Hard-coded |
Hard-coded |
CDSTA |
Status of Customs Document |
/SAPSLL/CUHDSTA |
PROST |
FCOTD |
Flag: Customs or Transit Document |
Hard-coded |
Hard-coded |
FRELP |
Flag: Relevant for Preference Processing |
Hard-coded |
Hard-coded |
PREFL |
Flag: Preference authorization |
Hard-coded |
Hard-coded |
FRELR |
Flag: Relevant for Restitution |
Hard-coded |
Hard-coded |
CDDAT |
Customs Document Date |
/SAPSLL/CUHDDAT |
SHPTS, PTCTS |
EXDAT |
Export date |
/SAPSLL/CUHDDAT |
EXPTS |
CRDAT |
Created-On Date |
/SAPSLL/CUHD |
CRTSP |
NSCTC |
Numbering Scheme for Tariff Code Number |
/SAPSLL/CTSNUMC, /SAPSLL/CTSNUM |
STCTS |
NUCTC |
Country Code |
/SAPSLL/CTSNUMC |
LAND1 |
NUMTC |
Tariff Code Number |
/SAPSLL/CTSNUMC, /SAPSLL/CTSNUM |
EXSID |
NSCCC |
Numbering Scheme for Commodity Code |
/SAPSLL/CTSNUMC, /SAPSLL/CTSNUM |
STCTS |
NUCCC |
Country for Commodity Code |
/SAPSLL/CTSNUMC |
LAND1 |
NUMCC |
Commodity Code |
/SAPSLL/CTSNUMC, /SAPSLL/CTSNUM |
EXSID |
NSCRC |
Numbering Scheme for Common Agricultural Policy (CAP) Numbers for Restitution Handling |
/SAPSLL/CTSNUMC, /SAPSLL/CTSNUM |
STCTS |
NUMRC |
Common Agricultural Policy Number |
/SAPSLL/CTSNUM |
EXSID |
BOPNO |
Bill of Product Number |
/SAPSLL/BOPHD |
BOPNPO |
SECNC |
Security Number for Customs Processing and Transit Procedure |
/SAPSLL/LCLIC |
EXTNO |
SECNR |
Security Number for Restitution |
/SAPSLL/LCLIC |
EXTNO |
PRNUM |
Customs product |
/SAPSLL/PR |
PRNUM |
CTYDP |
Country of Departure |
/SAPSLL/CUIT, /SAPSLL/CUHD |
CTYDP |
CTYAR |
Country of Destination |
/SAPSLL/CUIT, /SAPSLL/CUHD |
CTYAR |
CUCOO |
Country of origin |
/SAPSLL/CUIT |
CUCOO |
FTORG |
Foreign Trade Organization |
BUT000 |
PARTNER |
LEGUN |
Legal Unit |
/SAPSLL/CORPAR |
PARNO |
PSEND |
Sender/Exporter |
/SAPSLL/CORPAR |
PARNO |
VSEND |
Sender/Exporter SAP R/3 Vendor (Import) |
/SAPSLL/PNTBP |
BPVSY |
PRECP |
Recipient/Importer |
/SAPSLL/CORPAR |
PARNO |
CRECP |
Recipient/Importer SAP R/3 Customer (Export) |
/SAPSLL/PNTBP |
BPVSY |
PDECL |
Declarant |
/SAPSLL/CORPAR |
PARNO |
PDECS |
Declarant (Substitute) |
/SAPSLL/CORPAR |
PARNO |
POENT |
Office of Entry |
/SAPSLL/CORPAR |
PARNO |
PODES |
Office of Destination |
/SAPSLL/CORPAR |
PARNO |
PODEP |
Office of Departure |
/SAPSLL/CORPAR |
PARNO |
POEXI |
Office of exit |
/SAPSLL/CORPAR |
PARNO |
CCAFA |
Requested Concession |
/SAPSLL/LEGCUS |
CCAFA |
CUPRO |
Procedure |
/SAPSLL/LEGCUS |
CUPRO |
DCTYP |
Declaration type |
/SAPSLL/LEGACT |
DCTYP |
CSSTA |
Customs Status of Goods |
LEGCUS |
CSSTA |
MTRDO |
Domestic Mode of Transport |
/SAPSLL/LEGTPR |
MTRDO |
MTBRC |
Mode of Transport at the Border |
/SAPSLL/LEGTPR |
MTBRC |
CUHDA |
Document Type of Customs Document |
/SAPSLL/CUHD |
CUHDA |
CUITA |
Customs Document Item Category |
/SAPSLL/CUIT |
CUITA |
LREGC |
Legal Regulation for Customs Processing and Transit Procedure |
/SAPSLL/LEGTPR |
LGREG |
LREGP |
Legal Regulation for Preference Processing |
Hard-coded |
LGREG |
LREGR |
Legal Regulation for Preference Processing |
/SAPSLL/LEGCON |
LGREG |
INCOT |
Incoterm 1 |
/SAPSLL/CUHD |
INCOT |
INCOL |
Incoterm 2 |
/SAPSLL/CUHD |
INCOLO |
EXART |
Customs Business Transaction Type |
/SAPSLL/LEGTPR |
EXART |
PYTYP |
Payment Method |
/SAPSLL/LEGTPR |
PYTYP |
AUTNO |
Authorization number |
/SAPSLL/LCLIC |
EXTNO |
ADDD1 |
Additional Data 1 |
/SAPSLL/CUIT |
ADDDA1 |
ADDD2 |
Additional Data 2 |
/SAPSLL/CUIT |
ADDDA2 |
ADDD3 |
Additional Data 3 |
/SAPSLL/CUIT |
ADDDA3 |
NETVA |
Net Price/Invoice Value |
/SAPSLL/LEGCULC |
AMNT_CUS |
STAVA |
Statistical Value |
/SAPSLL/LEGCULC |
AMNT_CUS |
CUSVA |
Customs Value |
/SAPSLL/LEGCULC |
AMNT_CUS |
TCODU |
Third-Country Duty |
/SAPSLL/LEGCULC |
AMNT_CUS |
PREDU |
Preferential Duty |
/SAPSLL/LEGCULC |
AMNT_CUS |
PHPDU |
Pharmaceutical Products Duty |
/SAPSLL/LEGCULC |
AMNT_CUS |
SUSDU |
Suspension of Duty |
/SAPSLL/LEGCULC |
AMNT_CUS |
ADUDU |
Anti-Dumping Duty |
/SAPSLL/LEGCULC |
AMNT_CUS |
SUMDU |
Total Duties |
/SAPSLL/LEGCULC |
AMNT_CUS |
CURCU |
Customs currency |
/SAPSLL/LEGCULC |
CUR_CUS |
PRRVA |
Comparison Value |
/SAPSLL/CUIT |
EXPVAL_FLT |
PRTVA |
Threshold value |
/SAPSLL/CUIT |
CPVAL_FLT |
CURPR |
Preference Currency |
/SAPSLL/CUIT |
PRCUR |
RESVA |
Export Refund Amount for Restitution |
/SAPSLL/LEGCULC |
AMNT_CUS |
CURRE |
Restitution Currency |
/SAPSLL/LEGCULC |
CUR_CUS |
QUANB |
Quantity in Base Unit of Measure |
Calculated |
Hard-coded |
QUAUB |
Base unit of measure |
Calculated |
Hard-coded |
QUAND |
Quantity in Document Unit of Measure |
/SAPSLL/CUIT |
QUANT_FLT |
QUAUD |
Document Unit of Measure |
/SAPSLL/CUIT |
QUAUM |
WEIGR |
Gross Weight |
/SAPSLL/CUIT |
WEIGRO_FLT |
WEINE |
Net Weight |
/SAPSLL/CUIT |
WEINET_FLT |
WEIDI |
Unit of Weight |
/SAPSLL/CUIT |
WEIDIM |
NUMIT |
Number of Document Items |
Calculated |
Hard-coded |
PREPD |
Flag: Price-Dependent Preference |
||
ECPID |
Customs ID for Customs Procedures with Economic Impact |
/SAPSLL/CUIT |
ECPID |
PRSRC |
Source Procedure |
/SAPSLL/CUIT, /SAPSLL/CUPEDRI |
PRSRC |
PRDES |
Target Procedure |
/SAPSLL/CUIT, /SAPSLL/CUPEDRI |
PRDES |
Extractor Logic
This DataSource has the following data flow: DataSource 0SLL_CD_1 → DataStore object 0SLL_DS01 → InfoCube 0SLL_C01. The extractor method is F1.