SAP ABAP with GST

 

SAP ABAP with GST is mostly about ABAP development on several SAP modules, including SAP FI, SAP SD, SAP MM, and other modules depending on company's specific business processes.

 

In Malaysia, GST-registered companies are required to submit GST Audit File (GAF) to Royal Custom for audit purposes.

 

GAF file contains a standard set of accounting information as per required by Royal Malaysian Customs Department.

 

The GAF file can be in either pipe-delimited text file format or XML format.

 

The GAF file comprises of 5 sections:

1. C (Company info)

2. P (Purchase records)

3. S (Sales records)

4. L (General Ledger transactions)

5. F (Accuracy checking records)

 

For more info, kindly refer to the link at Royal Malaysian Customs Department.

In order to generate, we are required to develop a customized program, where the logic of it will be provided by functional consultant.

 

The important tables associated with SAP FI includes:

   For posted documents:

• BKPF (Header data）

• BSEG (Line item data including G/L, vendor, customer, asset)

• BSET (Tax data)

• BSEC (One time customer/vendor data)

 

   For parked documents:

• VBKPF   (header data)

• VBSEGS (G/L data)

• VBSEGK (vendor data)

• VBSEGD (customer data)

• VBSEGA (asset data)

 

The important tables associated with SAP MM includes:

• EKKO (Purchasing document header data)

• EKPO (Purchasing document item data)

• EINA (Purchasing info record: general data)

• EINE (Purchasing info record: purchasing organization data)

• KONH (Conditions header data)

• KONP (Conditions item data)

• EBAN (Purchasing requisition)

• EBKN (Purchasing requisition account assignment)

• MARA (General material data)

• LFA1 (General vendor master data)

• LFB1 (Company code vendor master data)

 

The important tables associated with SAP SD includes:

• VBUK (Header status and administrative data)

• VBAK (Sales document header data)

• VBKD (Sales document business data)

• VBUP (Item status)

• VBAP (Sales document item data)

• VBPA (Partners data)

• VBFA (Document flow)

• VBEP (Sales document schedule line)

• VBBE (Sales requirements: individual records)

• VBRK (Billing document header)

• VBRP (Billing document item)

• KNA1 (Customer general data)

• KNB1 (Customer master data - Company code data, payment method, reconciliation account

 

Note: Some customers might not be using SD/MM modules, and hence might need to query other tables (customized tables or third party sources), or might even required merging of GAF files generated from multiple sources.