ALTERYX CONNECTORS

ALTERYX CONNECTOR FOR SAP
ALTERYX CONNECTOR FOR SAP CX
ALTERYX CONNECTOR FOR BUSINESSOBJECTS
ALTERYX CONNECTOR FOR SUCCESSFACTORS
ALTERYX CONNECTOR FOR SAP RPA
SAP METADATA CONNECTOR FOR ALTERYX CONNECT

KNIME CONNECTORS

KNIME CONNECTOR FOR SAP
KNIME CONNECTOR FOR SUCCESSFACTORS

TABLEAU CONNECTORS

TABLEAU CONNECTOR FOR SAP

POWER BI CONNECTORS

POWER BI CONNECTOR FOR SAP
FREE TRIAL
DVW Analytics
  • Products
    • Alteryx Connectors >
      • Alteryx Connector for SAP
      • Alteryx Connector for SAP Customer Experience (CX)
      • Alteryx Connector for SAP SuccessFactors
      • Alteryx Connector for SAP BusinessObjects
    • Alteryx RPA Tools
    • KNIME Connectors >
      • KNIME Connector for SAP
    • Power BI Connectors >
      • Power BI Connector for SAP
    • Tableau Connectors >
      • Tableau Connector for SAP
    • Dataiku Connectors
    • Snowflake Connectors
    • DVW Flow Tool
  • Demos
    • Alteryx Connector Demos
    • Alteryx RPA Tools Demos
    • KNIME Connector Demos
    • Power BI Connector Demos
    • Tableau Connector Demos
    • Dataiku Connector Demos
    • Snowflake Connector Demos
    • DVW Flow Tool Demos
  • Webinars
    • Alteryx Connector Webinars
    • Alteryx RPA Tools Webinars
    • KNIME Connector Webinars
    • Power BI Connector Webinars
    • Tableau Connector Webinars
    • Dataiku Connector Webinars
    • Snowflake Connector Webinars
    • DVW Flow Tool Webinars
  • Pricing
    • Alteryx Connector Pricing
    • Alteryx RPA Tools Pricing
    • KNIME Connector Pricing
    • Power BI Connector Pricing
    • Tableau Connector Pricing
    • Dataiku Connector Pricing
    • Snowflake Connector Pricing
    • DVW Flow Tool Pricing
  • Free Trial
  • Blog
  • Resources
    • About Us
    • Events
    • Customers
    • Partners
    • Resellers
    • Services
    • Sample Workflows
    • License
    • Help Centre
  • Contact Us

Blog

The SAP Finance and Controlling (FI/CO) tables every KNIME user should know

16/12/2020

 
Picture
​In this blog we identify the SAP Finance and Controlling (FI/CO) tables that users of KNIME and the DVW KNIME Connector for SAP should know.
The following SAP sytems contain SAP Finance and Controlling tables:
  • 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. 

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

​Tables that 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) 

The following SAP Financial Accounting transaction tables are also useful and can be used in association with table BKPF:
  • BSEC - One-Time Account Data Document Segment
  • ​BSET - Tax Data Document Segment

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.​
GET A FREE TRIAL TODAY

Comments are closed.

    RSS Feed

    Categories

    All
    ACS
    ACS BOP
    ACS CX
    ACS Metadata
    ACS SF
    Alteryx
    Alteryx Connector For BusinessObjects
    Alteryx Connector For SAP
    Alteryx Connector For SuccessFactors
    Alteryx Gallery
    Alteryx Inspire
    Alteryx RPA Tools
    Alteryx Server
    APA
    Audit
    Augmented Analytics
    BusinessObjects
    Dataiku
    Data Migration
    DVW Flow Tool
    DVW Integration Platform
    Finance
    Flow Tool
    KCS
    KNIME
    KNIME Connector For SAP
    Microsoft Azure
    Office Of Finance
    On Demand Webinar
    Power BI
    Power BI Connector For SAP
    Predictive Analytics
    Process Automation
    Professional Services
    Qlik
    Read Tools
    RPA
    Salesforce
    Salesforce Wave Analytics
    Sample Workflow
    SAP Business Suite
    SAP BW
    SAP C4C
    SAP ECC
    SAP ERP
    SAP HANA
    SAP S/4HANA
    SAP Tables
    SAP T Codes
    SAP T-Codes
    SAP Transaction Codes
    Snowflake
    Snowflake Connector For SAP
    SuccessFactors
    Tableau
    Tableau Connector For SAP
    Tableau Desktop
    Tableau Online
    Tableau Prep
    Tableau Server
    Tax
    TCS
    ThoughtSpot
    Tool: BOP Universe
    Tool: BOP Webi
    Tool: HTML RPA
    Tool: SAP BAPI Read
    Tool: SAP BAPI Write
    Tool: SAP BW Write
    Tool: SAP Document Read
    Tool: SAP IDoc
    Tool: SAP Query
    Tool: SAP Report
    Tool: SAP RPA
    Tool: SAP Spool Read
    Tool: SAP Table Data
    Tool: SuccessFactors Read
    Tool: SuccessFactors Write
    Top 10 Blog
    Webinar
    Write Tools

    Archives

    January 2025
    November 2024
    October 2024
    September 2024
    July 2024
    June 2024
    May 2024
    March 2024
    February 2024
    December 2023
    October 2023
    June 2023
    May 2023
    April 2023
    March 2023
    February 2023
    January 2023
    October 2022
    June 2022
    May 2022
    April 2022
    March 2022
    February 2022
    December 2021
    November 2021
    October 2021
    May 2021
    April 2021
    December 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
    April 2018
    February 2018
    July 2017
    April 2017
    March 2017
    February 2017
    January 2017
    October 2016
    September 2016
    August 2016
    July 2016
    June 2016
    May 2016
    November 2015

Products

​Alteryx Connectors
​KNIME Connectors
​Power BI Connectors
Tableau Connectors
Dataiku Connectors
Snowflake Connectors

Free Trial

​Alteryx Connectors
​Free Trial of Alteryx Connector for SAP
​Free Trial of Alteryx RPA Tools
​Free Trial of Alteryx Connector for SAP CX
Free Trial of Alteryx Connector for SAP SuccessFactors
Free Trial of Alteryx Connector for SAP IBP
Free Trial of Alteryx Connector for SAP Ariba
Free Trial of Alteryx Connector for SAP BusinessObjects

​KNIME Connectors
​Free Trial of KNIME Connector for SAP

Power BI Connectors
Free Trial of Power BI Connector for SAP

Tableau Connectors
Free Trial of Tableau Connector for SAP

Dataiku Connectors
Free Trial of Dataiku Connector for SAP

Snowflake Connectors
Free Trial of Snowflake Connector for SAP

DVW Flow Tool
Free Trial of DVW Flow Tool

Services

Pricing

Demos

Blog

Help Centre

About Us

Contact Us

DVW Analytics brings the power of SAP to users of Alteryx, KNIME, Power BI, Dataiku and other global software leaders.

© COPYRIGHT 2003 - 2024 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 SAP Customer Experience (CX)
      • Alteryx Connector for SAP SuccessFactors
      • Alteryx Connector for SAP BusinessObjects
    • Alteryx RPA Tools
    • KNIME Connectors >
      • KNIME Connector for SAP
    • Power BI Connectors >
      • Power BI Connector for SAP
    • Tableau Connectors >
      • Tableau Connector for SAP
    • Dataiku Connectors
    • Snowflake Connectors
    • DVW Flow Tool
  • Demos
    • Alteryx Connector Demos
    • Alteryx RPA Tools Demos
    • KNIME Connector Demos
    • Power BI Connector Demos
    • Tableau Connector Demos
    • Dataiku Connector Demos
    • Snowflake Connector Demos
    • DVW Flow Tool Demos
  • Webinars
    • Alteryx Connector Webinars
    • Alteryx RPA Tools Webinars
    • KNIME Connector Webinars
    • Power BI Connector Webinars
    • Tableau Connector Webinars
    • Dataiku Connector Webinars
    • Snowflake Connector Webinars
    • DVW Flow Tool Webinars
  • Pricing
    • Alteryx Connector Pricing
    • Alteryx RPA Tools Pricing
    • KNIME Connector Pricing
    • Power BI Connector Pricing
    • Tableau Connector Pricing
    • Dataiku Connector Pricing
    • Snowflake Connector Pricing
    • DVW Flow Tool Pricing
  • Free Trial
  • Blog
  • Resources
    • About Us
    • Events
    • Customers
    • Partners
    • Resellers
    • Services
    • Sample Workflows
    • License
    • Help Centre
  • Contact Us