Here, you can view the GST Number table name & technical field name in SAP GUI or SAP on-premise system, which can store the vendor GST Number, customer GST Number, company GST Number, and plant GST Number. All technical field names may be the same or different.
GST Number means Goods and Services Tax Number. This number length is 15, and this 15-digit number is a combination of alphanumeric characters. Know more about What is a GST Number?
Table of Contents
In the SAP vendor, customer, and company, all GST Numbers are stored in different tables and field names. So, functional and ABAPers are not able to find the GST number table and field name easily. This post is more helpful for both functional and ABAPers.
Find the Customer GST Number Table name in SAP GUI
Customer GST Number table name is KNA1 (Customer Master), short description is General Data in Customer Master, and GST Number technical field name is STCD3 (Tax Number 3), Data element name is STCD3, Data type is CHAR.
Now you know the table name and the field name of the customer's GST number in SAP GUI. Here, we will see how to find the GST number by using the customer number. Then follow the example below.
Example: When the user inputs a customer number, the system should return both the customer number and its associated GST number.
Program:
TABLES: KNA1.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETERS: P_KUNNR TYPE KNA1-KUNNR.
SELECTION-SCREEN END OF BLOCK B1.
SELECT SINGLE
KUNNR,
STCD3
INTO @DATA(WA_KNA1) FROM KNA1
WHERE KUNNR = @P_KUNNR.
WRITE: 'CUSTOMER NUMBER IS', WA_KNA1-KUNNR,/, 'CUSTOMER GST NUMBER IS', WA_KNA1-STCD3.
Find the Company GST Number Table name in SAP GUI
Company GST Number table name is J_1BBRANCH (Business Place), and GST Number technical field name is GSTIN (Tax Number 3), Data element name is J_1IGSTCD3, Data type is CHAR.
Now you know the table name and the field name of the Company GST number in SAP GUI. Here, we will see how to find the GST number by using the Company code. Then follow the example below.
Example: When the user inputs a company code, the system should return both the company code and its associated GST number.
Program:
TABLES: T001.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETERS: P_BUKRS TYPE T001-BUKRS.
SELECTION-SCREEN END OF BLOCK B1.
SELECT SINGLE
BUKRS,
GSTIN
INTO @DATA(WA_J_1BBRANCH) FROM J_1BBRANCH
WHERE BUKRS = @P_BUKRS.
WRITE: 'COMPANY NUMBER IS' , WA_J_1BBRANCH-BUKRS, / , 'COMPANY GST NUMBER IS' , WA_J_1BBRANCH-GSTIN.
Find the Vendor GST Number Table name in SAP GUI
Vendor GST Number table is LFA1 (vendor master ), description is Supplier Master (General Section), and the technical field name is STCD3 (Tax Number 3), Data element name is STCD3.
Now you know the table name and the field name of the vendor GST number in SAP GUI. Here, we will see how to find the GST number by using the vendor number. Then follow the example below.
Example: When the user inputs a vendor number, the system should return both the vendor number and its associated GST number.
Program :
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETERS: P_LIFNR TYPE LFA1-LIFNR.
SELECTION-SCREEN END OF BLOCK B1.
SELECT SINGLE
LIFNR,
STCD3
INTO @DATA(WA_LFA1) FROM LFA1
WHERE LIFNR = @P_LIFNR.
WRITE: 'Account Number of Vendor IS', WA_LFA1-LIFNR,/, 'Vendor GST NUMBER IS', WA_LFA1-STCD3.
Find the Plant GST Number Table name in SAP GUI
Plant GST Number table is J_1BBRANCH ( Business Place), and GST Number technical field name is GSTIN (Tax Number 3), Data element name is J_1IGSTCD3, Data type is CHAR.
Now you know the table name and the field name of the Plant GST number in SAP GUI. Here, we will see how to find the GST number by using the Plant code. Then follow the example below
Example: When the user inputs a plant number, the system should return both the plant number and its associated GST number.
Program :
TABLES : T001W.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETERS: P_WERKS TYPE T001W-WERKS.
SELECTION-SCREEN END OF BLOCK B1.
SELECT SINGLE
WERKS,
J_1BBRANCH
INTO @DATA(WA_T001W) FROM T001W
WHERE WERKS = @P_WERKS.
SELECT SINGLE
BRANCH,
GSTIN
INTO @DATA(WA_J_1BBRANCH) FROM J_1BBRANCH
WHERE BRANCH = @WA_T001W-J_1BBRANCH.
WRITE: 'PLANT NUMBER IS' , WA_T001W-WERKS, / , 'PLANT GST NUMBER IS' , WA_J_1BBRANCH-GSTIN.
Thanks for Reading.
Read More: