Which Table Store Vendor, Customer & Company & Plant GST Number in SAP ABAP

You find GST Number technical field name and which table store of vendor, customer, company and plant GST Number in sap . In all vendor, customer, company and plant GST Number technical field name is different or may be same. GST Number means Goods and Service Tax Number, This number length is 15 and this 15 number is combination of alphabet and numeric character or alphanumeric character.

In sap vendor, customer and company all GST Number are store in different different table and differnt field name. So, functional and ABAPer can not find GST number field name easily, This post is more helpful for both functional and ABAPer.

Customer GST Number Table in SAP

Customer GST Number store in Customer Master Table KNA1, short description of KNA1 is General Data in Customer Master and GST Number technical field name is STCD3, Data element name is STCD3, Data type is CHAR, short description is Tax Number 3. Now you know that what is table name and what is the field name of customer GST number in sap. But you does not know how to find the GST number in using the customer number, Then follow the below example.

How to Find the GST Number in Using the Customer Number

Means User input is customer number and output is required both customer number and customer 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.

Company GST Number Table in SAP

Company GST Number store in Business Place Table J_1BBRANCH, short description of J_1BBRANCH is Business Place and GST Number technical field name is GSTIN, Data element name is J_1IGSTCD3, Data type is CHAR, short description is Tax Number 3. Now you know that what is table name and what is the field name of company GST number in sap. But you does not know how to find the GST number in using the company code, Then follow the below example.

How to Find the GST Number in Using the Company Code

Means User input is company code and output is required both company code and company 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.

Vendor GST Number Table in SAP

Vendor GST Number store in vendor master Table LFA1, short description of LFA1 is Supplier Master (General Section) and GST Number technical field name is STCD3, Data element name is STCD3, Data type is CHAR, short description is Tax Number 3. Now you know that what is table name and what is the field name of vendor GST number in sap. But you does not know how to find the GST number in using the vendor number, Then follow the below example.

How to Find the GST Number in Using the Vendor Number

Means User input is vendor number and output is required both vendor number and vendor 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.

Plant GST Number Table in SAP

Plant GST Number store in Business Place Table J_1BBRANCH, short description of J_1BBRANCH is Business Place and GST Number technical field name is GSTIN, Data element name is J_1IGSTCD3, Data type is CHAR, short description is Tax Number 3. Now you know that what is table name and what is the field name of Plant GST number in sap. But you does not know how to find the GST number in using the Plant Number, Then follow the below example.

How to Find the GST Number in Using the Plant Number

Means User input is Plant number and output is required both plant number and plant 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.