General presentation

Objective of the application

Tool Leader + IT leader of the application: 

With SAP Global Trade Services (SAP GTS), you can manage all the complexities of international trade including full regulatory compliance, electronic communication with customs authorities, and risk mitigation, while importing and exporting on a global basis. Business Content for SAP GTS enables you to analyze your import and export transactions and perform strategic reporting for the following areas:

History

A large amount of transaction data and master data is available in SAP GTS. A selection of the data is extracted into SAP Business Information Warehouse (SAP BW) and evaluated there. The data flows for transaction data that is extracted from the customs documents which are created in SAP GTS are as follows:

The following functions are available:

• Data extraction for strategic reporting for customs processing, transit procedure, preference processing, restitution handling and legal controls on imports and exports.

• Strategic reporting for customs processing

• Strategic reporting for preference processing

• Strategic reporting for restitution handling

• Strategic reporting for import legal control

• Strategic reporting for export legal control.

Using the following reports that are available, you can evaluate and analyze data for any of the services you use in SAP GTS from main tcode /SAPSLL/MENU_LEGAL:

Import

• Imports by product

• Imports by country

• Import analysis

• Imports by office of entry or destination

• Comparison of imports between transit and customs processing document items

Export

• Exports by product

• Exports by country

• Export analysis

• Export by customs office

• Comparison of exports between transit and customs document items

The SAP papers indicate the main processes by the standard datasources 0SLL_CD_1 and 0SLL_CD_2. However because we have specific requisites in Solvay, the project team recrated the compliance management process (0SLL_CD_2) in the generic function module datasource DTS_SLL_CD_2 (function module Z_BW_GET_CD_2).

• For the data extraction and strategic reporting for SAP Customs Management and SAP Risk Management, the data flow is as follows: DataSource 0SLL_CD_1 → ODS Object 0SLL_DS01 → InfoCube 0SLL_C01

• For the data extraction and strategic reporting for SAP Compliance Management, the data flow is as follows: DataSource 0SLL_CD_2 → ODS Object 0SLL_DS02 → InfoCube 0SLL_C02

   Note

  End of the note.

Starting from:

      SELECT  DISTINCT
      h~corder     AS cdnum
      h~coyear     AS cdyea
      i ~itvsy      AS cditn
      h~indei      AS indei
      h~crtsp      AS crtsp
      h~chtsp      AS chtsp
      h~guid_cuhd  AS guid_cuhd
      i ~guid_cuit  AS guid_cuit
      i ~ctydp      AS ctydp
      i ~ctyar      AS ctyar
      i ~ctypl      AS ctypl
      i ~ctyiv      AS ctyiv
      h~cuhda      AS cuhda
      i ~cuita      AS cuita
      i ~quant_flt  AS quand
      i ~quaum      AS quaud
      i ~weigro_flt AS weigro_flt
      i ~weinet_flt AS weinet_flt
      i ~weidim     AS weidim
      f~partner    AS ftorg
      i ~netval_flt AS ntval
      i ~ntcur      AS ntcur
      FROM
      /sapsll/cuhd AS h                                 "Customs Document: Header

      LEFT  JOIN /sapsll/cuit AS  i                   "Customs Document: Item
          ON h~mandt =  i ~mandt
         AND h~guid_cuhd =  i ~guid_cuhd

      LEFT  JOIN /sapsll/cuhddat AS d         "GTS: Customs Document: Header Dates
          ON h~mandt = d~mandt
         AND d~mobjt =  'O'
         AND h~guid_cuhd = d~guid_mobj

      LEFT OUTER JOIN but000 AS f            "Businness Partner: General data
          ON  h~mandt = f~ client
         AND h~guid_ftorg = f~partner_guid

    WHERE  ( h~crtsp IN g_r_crtsp
        OR h~chtsp IN g_r_crtsp )   " FD 41031
      AND   h~corder IN g_r_corder
      AND   h~cdtyp IN  (space,  'A' ,  'C' )
      AND   h~cuhda IN g_r_cuhda.

• All other DataSources for master data extraction from SAP GTS to SAP BW have the type direct update.

Roles & Access

Roles and access

The GTS objects are under SCMS layer by the roles:

Authorization objects

List of autorisation objects mandatory for the application.

Dataflow overview

GTS - Customs Document (MPR_GTS01)

Flow to control imports and exports from standard datasource 0SLL_CD_1 (no specific business rules applied in this flow).

GTS Product Compliance (IFS_PR92)

Flow to control the compliance over the existent products.

C_PRNCTY - GTS Product by Country

Master data to convert the external combination of product number and country in the corresponding objects in SAP code.

Source material plant (c_matpnt2) and DTS_PROD_EXTN (material extension)

DP_GTS92 - GTS Product - Compliance

Daily full reload to assign the corresponding legal regulation according to the combination of product and country from plant.

The source DTS_PROD_LEG takes into account the assignments done at level of product x compliance and the other one DTS_PROD_LEG2 is used by a view linked to compliance x classification of the products.

DP_GTS94

Daily full reload from master data GTS Product x Country to explode the information according to the legal regulation.

The legal regulations come from the table APSDGT01 where we retrieve data from the GTS tables /SAPSLL/ALGR01 (legal regulation per country) and /SAPSLL/ALGR11 (legal regulation per country group). 

Sales Order x Classification (CPSDGT01)

Join between sales orders and billing document with the legal regulations available by material and country assignments.

Trade Compliance (CPSDGT02)

The composite provider is composed by two different views for trade compliance documents.

• CV_SD_GT_CPSDGT02 - GTS documents by locked partner (payer, ship-to, sold-to and billing to).

• CV_SD_GT_CPSDGT02_0002 - SPL view following the movements of the blocked and released documents and licenses.

Both views have as background the provider DB_GTS03, where the main source is the customized datasource mentioned previously DTS_SLL_CD_2. 

The datasource extracts data from document item level in SAP GTS created or changed in the last 40 days.

Main business rules:

Foreign trade organization starting with LU_S belongs Solvay plants. The plant is assigned with the char 6 to 9. While Rhodia plants are based on char 4 to 7.

This table saves by look up from DB_GTS01, the actions performed on embargo, spl and others legal controls using document and year as reference.

On time that DB_GTS01 is result from the logs table (CDHDR and CDPOS) on status table (/SAPSLL/CUHDSTA) by the program ZBW_PRG_CHANGE_ST.

Locked Partners (CPSDGT03)

View ZV_BLBP (Santioned Party List Screening: Blocked Business Partners) result from partner information available on KNA1 and BUT00 with legal Control from  the corresponding address.

GTS Licenses (CPSDGT04)

View based on master data C_LICNUM, which use as source the table /SAPSLL/LCLIC.

Reporting documentation drive folder:

https://drive.google.com/drive/folders/0B0qn89R0RGdqYkZZOFZyYXlXVkE

dataflow overview :

https://drive.google.com/file/d/1_gTYCXm6O6To6xyVR58QzG0q5QnKjavSbLyHrrGG_vk/view

Functional and Technical rules on Workbench + Reporting

Rules & Explanations

•  Customs Doc. No.
• Legal Unit
• Goods Supplier
• Country of Departure
• Document Status
• Customs Procedure Code
• Customs Duty
• Customs Value
• Net Weight
• VAT Calculation Amnt
• VAT Paid Amount
• Third-Country Duty
• Percentage Duty  Rate (Third-Country Duty / Customs Value)

• Supplier Bills
• Imports by plant

Dependencies with other applications

Dependancies with SD and GSV application (old purchase application)

Check the transformation : TRSF : 0SLL_CD_1 -> ODSGTS01 

In the start routine :

Data loadings

Info providers and objects loaded

Loading frequency

Daily - process chain GTS_MASTER_MAIN

Average performance

Record Keeping

Reporting

Queries End User Documentation

Main queries

The main reports available in the GTS models are:

Main functionalities

Broadcast

Maintenance

Known bugs

Recurring procedure

DataSource for Customs Documents

 DataSource Transactional Data: 0SLL_CD_1

Technical Data

Planned Evolution

There are some changes in progress for some GTS queries according to the specifications in the link below

https://drive.google.com/a/solvay.com/folderview?id=0B2clPECaPXrkZkRqN3Y2QWlaTVE&usp=sharing_eid&ts=57209386

1) BW - GTS : Export Statistics (Core Query) - BW_QRY_MPR_GTS01_0004

2) BW - GTS : Import Statistics (Core Query) - BW_QRY_MPR_GTS01_0001

3) BW - GTS : Trade compliance follow-up (Core Query) - BW_QRY_MPR_GTS02_0001 

   This query will be splitted in 3 different ones:

⇨ SPL  - to be created

⇨ Embargo - BW_QRY_MPR_GTS02_0002 (in validation)

⇨ License - to be created

Aside from modifications in the queries (layout, filters, etc) some new developments are in progress:

• Activation of datasource DTS_USERNAME_TEXT in PF1 (currently it's available in SF1) to get user name from PF1 too
• Analysis to enhance field "Release Reason" in datasource DTS_GTS_CHANGEDOC_STATUS