DVW Analytics
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
      • ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

BLOG

The most important SAP Finance and Controlling (FI/CO) tables for Alteryx users

17/5/2019

 
Picture
​In this blog we identify the most important SAP Finance and Controlling (FI/CO) tables for users of Alteryx and the DVW Alteryx Connector for SAP.
SAP Finance and Controlling tables are found in the following SAP systems:
  • SAP ECC 
  • SAP ERP
  • SAP S/4HANA

The "Big Two" SAP Financial Accounting (FI) Transaction Data Tables

  • BKPF - Accounting Document Header
  • BSEG - ​Accounting Document Segment
Table BKPF holds the Header data for all Financial transactions in SAP while table BSEG holds the Segment or Item data for all Financial transaction in SAP.  ​In Alteryx you will typically extract data from both tables in order to get the full picture for a Financial transaction.
There are a number of other SAP Financial Accounting transaction tables that can be used in association with BKPF and BSEG. 

The following tables can be used with BKPF:
  • BVOR - Intercompany posting procedures
  • BSIP - Index for Vendor Validation of Double Documents (Note: "Double" means Duplicate)

The following tables can be used with BSEG:
  • BSID - Accounting: Secondary Index for Customers  (Open Items) 
  • BSAD - Accounting: Secondary Index for Customers (Cleared Items) 
  • BSIK -  Accounting: Secondary Index for Vendors  (Open Items)
  • BSAK - Accounting: Secondary Index for Vendors (Cleared Items)
  • ​BSIS - Accounting: Secondary Index for G/L accounts (Open Items)
  • BSAS - Accounting: Secondary Index for G/L Accounts (Cleared Items) 
In addition to the above the following SAP Financial Accounting transaction tables are useful to know:
  • BSEC - One-Time Account Data Document Segment
  • ​BSET - Tax Data Document Segment

Tables BSEC and BSET can be used in association with table BKPF.

Key SAP Controlling (CO) Transaction Data Tables

Cost Centre Accounting

  • COBK - CO Object: Document Header
  • COEP - CO Object: Line Items (by Period)
  • COSP - CO Object: Cost Totals for External Postings

Profit Centre Accounting

  • GLPCC - EC-PCA: Transaction Attributes
  • GLPCO - EC-PCA: Object Table for Account Assignment Elements
  • GLPCA - EC-PCA: Actual Line Items
  • GLPCT - ​EC-PCA: Totals Table

Important SAP Finance and Controlling (FI/CO) Master Data Tables

General Ledger 

  • SKA1 - G/L Account Master (Chart of Accounts)
  • SKAT - G/L Account Master Record (Chart of Accounts: Description)
  • SKB1 - G/L account master (Company Code)

Cost Centre

  • CSKS - Cost Center Master Record
  • CSKT - Cost Center Texts

Cost Element

  • CSKA - ​Cost Elements (Data Dependent on Chart of Accounts)
  • CSKU - Cost Element Texts
  • CSKB - Cost Elements (Data Dependent on Controlling Area)

Profit Centre

  • CEPC - Profit Center Master Data Table
  • CEPCT -  Profit Center Master Data​

Accounts Payable - Vendor Master Data

Vendor Master - General Data

  • LFA1 -  Vendor / Supplier Master (General Section)
  • ​LFBK - Vendor / Supplier Master (Bank Details)

Vendor Master - Purchasing Data

  • LFM1 - Vendor Master Record purchasing organization data
  • ​LFM2 - Vendor Master Record: Purchasing Data

Vendor Master - Company Code Data

  • LFB1 - Vendor Master (Company Code)
  • LFB5 - Vendor master (dunning data)

Accounts Receivable - Customer Master Data

Customer Master - General Data

  • KNA1 - ​General Data in Customer Master

Customer Master - Sales Area Data

  • KNVP - Customer Master Partner Functions
  • KNVV - Customer Master Sales Data

Customer Master - Company Code Data

  • KNB1 - Customer Master (Company Code)
  • ​KNB5 - Customer master (dunning data)

Useful SAP Finance and Controlling (FI/CO) Configuration Data Tables

  • M_KOSTS - Generated View for Matchcode ID KOST-S (Cost Centre Texts)
  • T001 - Company Codes
  • T001K - Valuation area
  • T077S - G/L account groups
  • TBSL and TBSLT - Posting Key and Posting Key Names

SAP S/4HANA Finance Tables

  • ACDOCA - Universal Journal Entry Line Items
With SAP S/4HANA, table ACDOCA contains all the Item data for Finance ( Controlling (CO) and Asset Accounting (AA).
ACDOCA can be used as an alternative to:
  • BSEG - Accounting Document Segment
  • COEP - CO Object: Line Items (by Period)
Table BKPF still holds the Header data for all Financial transactions in SAP S/4HANA.

Other Sources of SAP Table Information

Google is your best friend when searching for SAP Table data. Give it a go!

​​Check out our sample Alteryx workflows that use SAP Finance and Controlling data
GET A FREE TRIAL TODAY
GET A FREE TRIAL TODAY

Comments are closed.

    RSS Feed

    Categories

    All
    ACS
    ACS BusinessObjects
    ACS BW Write
    ACS Cloud
    ACS Metadata
    Alteryx
    Alteryx Gallery
    Alteryx Server
    Analytic Process Automation
    APA
    Audit
    BusinessObjects
    Consulting
    DVW Integration Platform
    DVW IP
    Inspire
    Jobs
    KCS
    KNIME
    Microsoft Azure
    Microsoft Power BI
    Office Of Finance
    Predictive Analytics
    Qlik
    Salesforce
    Salesforce Wave Analytics
    SAP BAPI Read Tool
    SAP BAPI Write Tool
    SAP BusinessObjects
    SAP Business Suite
    SAP BW
    SAP Data Migration
    SAP Document Tool
    SAP ECC
    SAP ERP
    SAP HANA
    SAP IDoc Tool
    SAP Query Tool
    SAP Read Tools
    SAP Report Tool
    SAP S/4HANA
    SAP Table Data Tool
    SAP Tables
    SAP Transaction Codes
    SAP Write Tools
    Services
    Tableau
    Tax
    TCS
    ThoughtSpot
    Top 10 Blog
    Training
    Webinar

    Archives

    December 2020
    November 2020
    October 2020
    July 2020
    June 2020
    May 2020
    February 2020
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    September 2018
    August 2018
    June 2018
    May 2018
    April 2018
    February 2018
    July 2017
    April 2017
    March 2017
    February 2017
    January 2017
    December 2016
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    November 2015

PRODUCTS

ALTERYX CONNECTOR FOR SAP​
​
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
​ALTERYX CONNECTOR FOR SUCCESSFACTORS
SAP METADATA CONNECTOR FOR ALTERYX CONNECT​
​KNIME CONNECTOR FOR SAP

POWER BI CONNECTOR FOR SAP
TABLEAU CONNECTOR FOR SAP

SERVICES

PROFESSIONAL SERVICES
TRAINING

DEMOS

FREE TRIAL

FREE TRIAL OF ALTERYX CONNECTOR FOR SAP
FREE TRIAL OF ALTERYX CONNECTOR FOR BUSINESSOBJECTS
FREE TRIAL OF ALTERYX CONNECTOR FOR SUCCESSFACTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
​
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​​
​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP

PRICING

BLOG

ABOUT US

CONTACT US

DVW Analytics, from De Villiers Walton, is dedicated to bringing the power of SAP to users of Alteryx, KNIME, Power BI, Tableau & other global leaders in BI and analytics.

© COPYRIGHT 2003 - 2021 DE VILLIERS WALTON LIMITED. ALL RIGHTS RESERVED.

SAP® Business Suite, SAP® BusinessObjects™, SAP® BW, SAP® SuccessFactors are the trademarks or registered trademarks of SAP SE in Germany and in several other countries.
PRIVACY POLICY
  • PRODUCTS
    • ALTERYX CONNECTORS >
      • ALTERYX CONNECTOR FOR SAP
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • SAP METADATA CONNECTOR FOR ALTERYX CONNECT
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
  • SERVICES
    • PROFESSIONAL SERVICES
    • TRAINING
  • DEMOS
  • FREE TRIAL
  • PRICING
  • RESOURCES
    • WEBINARS >
      • ON-DEMAND WEBINAR: SAP IN ALTERYX DESIGNER AND SERVER 101 - LEARN HOW TO ACCESS YOUR DATA LIKE A PRO
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA WITH COCA-COLA EUROPEAN PARTNERS
      • ON-DEMAND WEBINAR: ANALYSE + AUTOMATE YOUR SAP DATA FULL DEMO
      • ON-DEMAND WEBINAR: DETAILED WALKTHROUGH OF THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: WHAT'S NEW WITH THE ALTERYX CONNECTOR FOR SAP
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP FOR ALTERYX USERS
      • ON-DEMAND WEBINAR: AN INTRODUCTION TO SAP DATA PREP & ANALYTICS WITH ALTERYX
      • ON-DEMAND WEBINAR: ALTERYX AND THE ALTERYX CONNECTOR FOR SAP
    • EVENTS >
      • BEER AND ANALYTICS 2020
      • BI INNOVATION & TECH FEST 2020
      • ALTERYX INSPIRE 2019
      • ALTERYX INSPIRE EUROPE 2019
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
    • GETTING STARTED
    • INSTALLATION GUIDES
    • SOFTWARE DOWNLOADS
    • TUTORIALS
    • SAMPLE WORKFLOWS
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS