Site Tools

User Tools


sapconnector:config

ASPTAX SAP Integration Configuration Manual

Objective

Objective of this document is to provide the information on set of configurations involved in ASPTAX SAP Integration Kit.

Target Audience

  • ASPTAX SAP Integration Kit using Customers
  • ASPTAX Implementation Partners
  • SAP Integration Kit Developers
  • ASPTAX product development team

Configuration Manager

  • All the configurations of ASPPTAX are managed through the recursively related tables which can generate n-level hierarchy and implemented using view cluster.
  • All the configuration activities related to ASPTAX SAP Integration Kit will be performed from ASPTAX Cockpit (/N/INCASP/COCKPIT) or from the view cluster /INCASP/VC_CONFIG.

Configuration value Updation

Please follow the below steps to upload the configuration sheet provided to below attachment

Step1: Please execute the T-code /INCASP/COCKPIT select configuration tab and click over Config Data CSV Upload

Step2: Please upload the excel sheet related to configurations provided in the e-mail and select the radio button Upload file and execute it.

Step3: Please capture the customizing TR in the development system.

Step4: Please give the description related to captured TR (ASPTAX - <Version no> configuration values)

Please import the captured TR into QAS and PRD systems without fail.

Configuration Groups and Configuration Parameters

erp_aspCommParams

  • Maintain ERP to ASP communication parameters in Connector configuration:
  • Create config ID with below details:

  • Map SAP configuration values to Connector for the configuration ID ‘erp_aspCommParams

aspCompanyCodes

Purpose: The Purpose of this configuration is to maintain the corresonding company codes.

  • Maintain List of Company Codes in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘aspCompanyCodes’.

  • Consider the Company code values from ‘T001’ table and maintain in SM34 like below for this.

aspCompanyBP

Purpose: The Purpose of this configuration is to maintain the corresponding business places related to company code.

  • Maintain List of Business Places in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘aspCompanyBP’.

  • Consider the Business Place values from ‘J_1BBRANCV’ view and maintain the configuration as below

countries

Purpose: The Purpose of this configuration is to maintain the countrt code IN (INDIA).

  • Maintain List of countries in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘countries’.

  • Map country key value from ‘T005T’ table to ASP Key in Config.

states

Purpose: The Purpose of this configuration is to maintain the State Codes as part of GST.

  • Maintain List of states in Connector Configuration:

  • Map SAP Configuration values to Connector for the configuration ID ‘states’.

  • Consider the states values from ‘T005U’ table and maintain in SM34 like below for this.

erp_gstDocCat

Purpose: The Purpose of this configuration is to maintain the various document categories against Sales and Purchase Invoices Taxpaid/ Advance Payments/ ITC Reversals

  • Maintain GST Document Categories in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstDocCat’.

erp_gstDocTypes

Purpose:

  • Maintain GST Document Types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstDocTypes’.

erp_gstDocClass

Purpose: The Purpose of this configuration is to maintain the various document classifications such as B2B/B2BA/B2BU/B2CS /B2CSA/CDNR/CDNRA/CDNURA Intersate/Intra state/Import of Goods & Services and its ammendments.

  • Maintain ERP Document Classification in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstDocClass’.

erp_gstDocSts

Purpose: The Purpose of this configuration is to know the Status of the documents that were sent to ASP (RECEIVED/UPLOAD_IN_PROCESS/UPLOADED/SUBMITTED/FILED/ERROR/DUPLICATE/ACTION_PENDING/ACTION_SAVED_LOCAL/ACTION_SAVED_GST/ACTION_FILED/MARKED_HOLD)

  • Maintain ERP Document Status in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstDocTypes’.

logType

Purpose: The Purpose of this configuration is to maintain the Log type such as API / Document/User Activity/Exception

  • Maintain Log Type in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘logType’.

  • Maintained SAP values in ‘YIG_DM_LOGTYPE’ domain value ranges.

gstUom

Purpose: The Purpose of this configuration is to maintain Unit of Measures as part of GST.

  • Maintain GST Unit of Measures in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstUom’.

  • Map gstUom values from T006A table

gstReturnSts

Purpose: The Purpose of this configuration is to maintain return status from GST whether the docuemt is in GST Upload in Progress/Reconcilation of Documents in Progress/Submit in Progress/Filing in Progress/Return Process Completed

  • Maintain GST Return Status in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstReturnSts’.

gstReturntypes

Purpose:

  • Maintain GST Return Types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstReturntypes’.

gstrDates

Purpose: The Purpose of this configuration is to maintain GSTR Dates as part of GST ( Such as 10th/15/20/17/13 of every month)

  • Maintain GSTR Dates in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstrDates’.

gstActionFlag

Purpose: The Purpose of this configuration is to maintain action raised from GST Portal whether the document is Accepted/Deleted/Modified/Upload/Pending.

  • Maintain GST Action Flag in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstActionFlag’.

aspCredentials

Purpose: The Purpose of this configuration is to maintain the User Key and Secret Key related to ASP fo individual business places

  • Maintain ASP Application Credentials in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘aspCredentials’.

wsCredentials

  • Maintain Web Server Credentials in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘wsCredentials’.

aspRestAPIParams

  • Maintain ASP Rest AP IRelated Parameters in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘aspRestAPIParams’.

apiResponseCode

  • Maintain API Reponse Code in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘apiResponseCode’.

dlJobSts

Purpose: The Purpose of this configuration is to know the batch status activity of the documents that were sent to ASP ( Ie, Scheduled, In_Process, Completed, Error, Cancelled, Rescheduled)

  • Maintain Upload Batch Status in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘dlJobSts’.

audLog

Purpose: The Purpose of this configuration is to maintain the Exception logs handeled inside our Programes, User Activity log,Document History Log

  • Maintain Audit Log Settings in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘audLog’.

erp_dataExtract

Purpose: The Purpose of this configuration is to maintain the document types related to Outwards/ Inwards supplies

  • Maintain Data Extraction from SAP to Connector in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_dataExtract’.

erp_dlJobSts

Purpose: The Purpose of this configuration is to know the data load job status from SAP side (Ie, Scheduled, In_Process, Completed, Error, Cancelled, Rescheduled)

  • Maintain ERP Dataload Job Status in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_dlJobSts’.

erp_dlTypes

Purpose: The Purpose of this configuration is to maintain the data load types of Documents from ASP side (Ie, Invoices/Credit/Debit Notes/Advance payments/Advance taxpaid/Import/Taxpaid/ITC Reversal Data

  • Maintain ERP Dataload Types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_dlTypes’.

erp_gstAuthObjects

Purpose: The Purpose of this configuration is to maintain the authorization checks on multiple tabs of our tool based on Sales/ Purchas/Admin/Company code/Business place

  • Maintain Authorization Objects in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstAuthObjects’.

erp_gstFinPeriod

Purpose: The Purpose of this configuration is to maintain the financial period ( Ie, 012017 till 122017 ) for GST filling for the particular period

  • Maintain ERP GST Financial Period in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstFinPeriod’.

erp_gstInvOPCondTypes

  • Maintain GST Output Tax Invoice Condition Types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstInvOPCondTypes’.

erp_gstReturnSts

Purpose: The Purpose of this configuration is to maintain the activities related to documents submitted to GST ( Ie Saved to GST/RECONCILIATION/Submit in progress/Filing in progress/COMPLETED/Submit Error/Submit/Submitted/Filed

  • Maintain ERP GST Return Status in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstReturnSts’.

erp_gstReturntypes

  • Maintain ERP GST Return Types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_gstReturntypes’.

erp_osTaxes

Purpose: The Purpose of this configuration is to maintain the Material Tax related Classifications from Outwards (Ie. GST Relevent/ Exempted/Excisable/Nill Rated)

  • Maintain SAP Sales Taxes Classificatins in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_osTaxes’.

  • Make sure that all details are maintained for below fields:

'CGST_GST_EXEMPT',
'SGST_GST_EXEMPT',
'IGST_GST_EXEMPT',


'CGST_GST_NIL_RATED',
'SGST_GST_NIL_RATED',
'IGST_GST_NIL_RATED',


'CGST_NON_GST',
'SGST_NON_GST',
'IGST_NON_GST',


'CUST_CGST_GST_EXEMPT',
'CUST_SGST_GST_EXEMPT',
'CUST_IGST_GST_EXEMPT',


'CUST_CGST_GST_NIL_RATED',
'CUST_SGST_GST_NIL_RATED',
'CUST_IGST_GST_NIL_RATED',


'CUST_CGST_NON_GST',
'CUST_SGST_NON_GST',
'CUST_IGST_NON_GST',

ftpCredentials

Purpose: The Purpose of this configuration is to maintain theFTP Credentials Such as Path In/ Path Out/ FTP Usre/ FTP Key/FTP Host name

  • Maintain FTP Credentials in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘ftpCredentials’.

  • Before this in SAP , make sure that FTP host details are maintained in table SAPFTP_SERVERS through SE16 .

gstDocAction

Purpose: The Purpose of this configuration is to maintain action while sending the Document to GST Such as Over write/ skip that were already submitted

  • Maintain Action on while saving the document in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstDocAction’.

gstDocCat

Purpose: The Purpose of this configuration is to maintain Document categories related to GST such as Invoices/ Credit/Debit /Advance payments/Tax Paid/Purchase Invoices/ Purchase Credit/Debit/Purchase Advance payments/Purchase Taxpaid

  • Maintain GST Document Categories in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstDocCat’.

gstDocClass

Purpose: The Purpose of this configuration is to maintain the various document classifications such as B2B/B2BA/B2BU/B2CS/ B2CSA/CDNR/CDNRA/CDNURA Intersate/Intra state/Import of Goods & Services and its ammendments/

  • Maintain GST Document Classification in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstDocClass’.

gstDocIssued

Purpose: The Purpose of this configuration is to maintain numbering series against the document categories as part of GST such as GF2/GDR/GKR/GL2

  • Maintain Document Issued Number Series in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstDocIssued’.

gstDocSource

Purpose: The Purpose of this configuration is to maintain Source of document from such as ERP

  • Maintain Document Source in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstDocSource’.

gstDocSts

Purpose: The Purpose of this configuration is to maintain status of doument once submitted to ASP / GST

  • Maintain GST Document Status in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstDocSts’.

gstDocTypes

  • Maintain GST Document Types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘gstDocTypes’.

invoiceTypes

Purpose: The Purpose of this configuration is to maintain Invoice types such as Deemed/SEZ with Pay/SEZ Without pay/ Regual invoices to classify

  • Maintain Invoice Types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘invoiceTypes’.

jobScheduleParams

  • Maintain Job Scheduling Parameters in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘jobScheduleParams’.

notSettings

  • Maintain Notify Settings in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘notSettings’.

retainLog

  • How to Maintain Retain Log deletion for Last 30 Days in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘retainLog’.

scheduledJobSettings

  • Maintain Scheduled Job Settings in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘scheduledJobSettings’.

scheduledJobs

  • Maintain Scheduled Jobs of ASPTax Connector in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘scheduledJobs’.

usrActivity

  • Maintain User Activity Types in Connector Configuration:
  • Create config ID with below details:

erp_taxCode

Purpose: The Purpose of this configuration is to maintain the tax codes against the Inward Invocies for Nill rated/ Exemepted/Non GST materials

  • Maintain TaxCode Configurations in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_taxCode’.

erp_venClass

  • Maintain ERP Vendor Classification in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘Erp_venClass’.

erp_reasonCode

Purpose: The Purpose of this configuration is to maintain the reason codes against GST specific against the Outward Invocies that were raised on behalf of sales order

  • Maintain Reason Code for Credit/Debit Notes in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_reasonCode’.

erp_isTaxes

Purpose: The Purpose of this configuration is to maintain the Material Tax related Classifications from Inwards (Ie. GST Relevent/ Exempted/Excisable/Nill Rated)

  • Maintain SAP Purchases Taxes Classifications in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_isTaxes ’.

erp_defaultHSNSAC

Purpose: The Purpose of this configuration is to maintain the default HSN/SAC Codes if not maintained at Material master level

  • Maintain Default HSN/SAC for empty handling in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_defaultHSNSAC’.

erp_ODN

Purpose: The Purpose of this configuration is to maintain the ODN status related activity for Outward & Inward Supplies based on XBNLR_ALT/ XBLNR fields

  • Maintain ODN Configuration in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_ODN’.

aspFtpLocalApiParams

Purpose: The Purpose of this configuration is to maintain the corresonding company codes

  • Maintain FTP / Local Service Type & File Patterns in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘aspFtpLocalApiParams’.

aspInvType

  • Maintain Invoice Type Classification Params in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘aspInvType’.

localServerPath

Purpose: The Purpose of this configuration is to maintain the Local Folder path if the uploadmode is in LOCAL

  • Maintain Local Application Server Path in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘localServerPath’.

erp_cpDetails

Purpose: The Purpose of this configuration is to maintain the partner functions based on Bill to party/ ship to Party/ Sold to pay for the Outward supplies

  • Maintain Counter party Details in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_cpDetails’.

erp_bpProfitCenter

Purpose: The Purpose of this configuration is to maintain the corresponding Profit Centers based on Buisness places

  • Maintain Map Profit Center with Business Place in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_bpProfitCenter’.

erp_rcmConditions

Purpose: The Purpose of this configuration is to maintain the RCM related condition types

  • Maintain RCM Conditions Mapping in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_rcmConditions’.

erp_condNames

Purpose: The Purpose of this configuration is to maintain the corresonding Outward and Inward Tax Condition names as part of GST

  • Maintain GST Tax Condition Names in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_condNames’.

itcRules

Purpose: The Purpose of this configuration is to maintain ITC Reversal Rules as part of GST

  • Maintain ITC Rules in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘itcRules’.

threShold_Days

Purpose: The Purpose of this configuration is to maintain the Threshold limit for the days to be calculated to alert the customers with the overdue of payments which are applicable for ITC

  • Maintain Threshold Days in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘threShold_Days’.

erp_ExportsData

Purpose: The Purpose of this configuration is to maintain the Exports related data of Outward Supplies such as Shippinh Bill No, Shipping Bill Date, Port Code

  • Maintain Exports Data in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_ExportsData’.

erp_osDefCondTypes

Purpose: The Purpose of this configuration is to maintain the Outward related taxes if the pricing procedure is not maintained in J_1iEXCDEFN view

  • Maintain Outward Default condition types in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_osDefCondTypes’.

erp_dataExtract

Purpose: The Purpose of this configuration is to maintain the document types related to Outwards/ Inwards supplies

  • Maintain Data Extraction from SAP to Connector conditions in Connector Configuration:
  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘erp_dataExtract’.

ewb_addrFields

  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘ewb_addrFields’.

ewb_docType

  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘ewb_docType’.

ewb_prepare

  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘ewb_prepare’.

ewb_subSupplyType

  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘ewb_subSupplyType’.

ewb_supplyType

  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘ewb_supplyType’.

ewb_uom

  • Create config ID with below details:

  • Map SAP Configuration values to Connector for the configuration ID ‘ewb_uom’.

Transporting of configuration changes

  • Create a customizing request and open the request data and add the Config Tables

  • Maintain the keys of modified or newly created objects relevant to the table

  • Release transport to the target environments
Last modified: 2018/06/21 11:05 by chekri