SAP S/4 Technical Tables for Tax Integrations

 List of technical tables for SAP Tax Engines

General Tax Tables:

  1. T007A - Tax Types
  2. T007S - Tax Calculation Procedure
  3. T007V - Tax Codes
  4. T007L - Tax Jurisdictions
  5. T007B - Tax Processing: Tax Base Amounts

Sales and Distribution (SD):

  1. KONV - Conditions (Transaction Data) (including tax conditions)
  2. VBRK - Billing Document: Header Data
  3. VBRP - Billing Document: Item Data
  4. VBPA - Sales Document: Partner

Materials Management (MM):

  1. EKPO - Purchasing Document Item (includes tax code for items)
  2. EKKN - Account Assignment in Purchasing Document
  3. RBKP - Invoice Document Header
  4. RSEG - Document Item: Incoming Invoice

Financial Accounting (FI):

  1. BSEG - Accounting Document Segment (includes tax codes and amounts)
  2. BKPF - Accounting Document Header
  3. BSIS - G/L Account Transaction Figures
  4. BSIK - Accounting: Secondary Index for Vendors
  5. BSID - Accounting: Secondary Index for Customers
  6. FAGLFLEXA - General Ledger: Actual Line Items

Accounts Payable (AP) and Accounts Receivable (AR):

  1. LFA1 - Vendor Master (General Section)
  2. LFB1 - Vendor Master (Company Code)
  3. KNA1 - Customer Master (General Section)
  4. KNB1 - Customer Master (Company Code)

Inventory Management (IM):

  1. MSEG - Document Segment: Material
  2. MKPF - Material Document Header

Project System (PS):

  1. PRPS - WBS (Work Breakdown Structure) Element Master Data

Controlling (CO):

  1. COEP - CO Object: Line Items (by Period)
  2. COSP - CO Object: Cost Totals for Internal Postings

Tax Reporting and Compliance:

  1. WITH_ITEM - Withholding Tax Data
  2. WITH_HEADER - Withholding Tax Header

These tables store various aspects of tax data such as tax codes, tax conditions, tax amounts, and other related information that is essential for tax calculation, reporting, and compliance within SAP.

Comments

Post a Comment

Popular posts from this blog

How to Use MDS_LOAD_COCKPIT - a Quick View

How to Use MDS_LOAD_COCKPIT for Synchronizing Business Partners with Customers/Vendors Many customers often inquire about how to effectively use the MDS_LOAD_COCKPIT tool to synchronize Business Partners (BP) with Customers or Vendors in SAP. In this article, I will guide you through the step-by-step process to achieve this synchronization using the MDS_LOAD_COCKPIT transaction. Step 1: Launching MDS_LOAD_COCKPIT To begin the synchronization process, you first need to run the transaction code MDS_LOAD_COCKPIT in SAP. This transaction is specifically designed for synchronizing master data between Business Partners and Customers/Vendors. Step 2: Selecting the Synchronization Process Once you enter the MDS_LOAD_COCKPIT, you will see the "Synchronization Process" section in the top-left corner of the screen. This is where you can choose the synchronization process that fits your requirements. Before proceeding, it's essential to ensure that the desired synchronization proces...
Read more

How to Check Error Logs in MDS_PPO2 - Quick View

 How to Check Error Logs in MDS_PPO2 for Synchronization Issues in SAP In a previous blog, I introduced how to use the transaction code MDS_LOAD_COCKPIT for synchronizing Business Partner (BP) data with Customer or Vendor data in SAP. However, when working with S/4HANA systems or after activating Customer Vendor Integration (CVI) in an ERP system, you might encounter issues where changes made to a BP in the customer/vendor role are not saved correctly. These issues are often due to errors in the synchronization process. To troubleshoot these issues, you can use the transaction code MDS_PPO2 to check error logs. In this article, I will guide you through the steps to identify and analyze synchronization errors using MDS_PPO2 . Scenario: Failed Synchronization of Customer Data Imagine you’ve just made a change to the house number for Customer 100430 and saved it. However, upon checking, you notice that the corresponding BP data hasn’t been updated successfully. This indicates that a...
Read more

Integration of GRC and C-IAG

GRC / IAC Integrating SAP Access Control 12.0 with SAP Cloud Identity Access Governance: A Step-by-Step Guide This guide provides a comprehensive overview of integrating SAP Access Control 12.0 (GRC AC) with SAP Cloud Identity Access Governance (IAG). The integration allows GRC AC to facilitate access requests and perform risk analysis for cloud applications. If you do not have a GRC AC system, consider using the IAG Standard edition. Prerequisites Before beginning the integration, ensure the following steps are completed: IAG Initial Setup : Ensure that SAP Cloud Identity Access Governance is properly set up. Cloud Application Connection : Connect at least one cloud application (e.g., SAP Ariba). Repository Synchronization : Run the repository sync job in IAG for the target cloud application. Cloud Connector Setup : Complete the initial configuration, including user credentials. Integration Process Overview 1. Connect Cloud Connector with IAG Subaccount Action Details Log in to Cloud ...
Read more