How To Find SAP GTS License Number on Basis of Customs Document through SQVI


 Requirement:- 

SAP GTS license number is applied to customs documents after that it gets updated to license master data where we can see remaining or depreciated value in SAP GTS License master data.

On the basis of the specific time period or against a few customs documents, the user wants to see a report on which the SAP GTS customs document, the license is applied and its value or quantity in SAP GTS. In that case, we have to use the SAP GTS License table.

Solution:- Join sap gts license tables using SQVI

For this, we can develop a report but for the time being, we can fetch information from the table by using SE16 or can be used SQVI.  Let us see how we can use SQVI for this requirement. 

Use T.Code:- SQVI

Provide any name of the SQVI report.

Join sap gts tables using SQVI

Add all SAP GTS Tables

Join sap gts tables using SQVI
Join sap gts tables using SQVI
/SAPSLL/LEGCON - Legal Control at document 
/SAPSLL/LCLIC - Legal Control License header

 Join SAP GTS tables one by one as per the above screenshots. 

  1. /SAPSLL/CUHD:- Customs Document Header
  2. /SAPSLL/CORREF:- Reference Data
  3. /SAPSLL/CUIT:- Customs Documents Item
  4. /SAPSLL/LEGCON:- Legal Control in document
  5. /SAPSLL/LCLIC:-Legal Control License header or header table of License master data

Find all SAP GTS Tables:- https://sapboost.com/sap-gts-tables

Now select fields for List to display and Selection fields for inputs. 

SQVI for SAP GTS Table
SQVI for SAP GTS Table
/SAPSLL/CORREF:- Refrence Data
/SAPSLL/CUIT:- Customs Documents Item
SQVI for SAP GTS Table
image
image
image

   All Input parameters

image
image
image

        All Output Fields

image

      Now execute this SQVI and fill selection parameter values. 

image
image

We have taken a few input selection parameters you can take as per your requirements.

SQVI for SAP GTS Table

    Report Display 

SQVI for SAP GTS Table
SAP GTS License Number
SAP GTS License Number

In this way, you can find an output list of SAP License tables as per your chosen fields in SAP GTS SQVI.   


Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *