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 RPA TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • DATAIKU CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS

BLOG

Extract SAP Vendor Line Item data into Alteryx (T-Code FBL1N)

7/10/2019

 
Picture
The SAP Report tool is used to extract data from SAP Transaction Codes (T-Codes) and SAP Reports directly into Alteryx.
In this blog we will show you how to use the SAP Report tool to extract data from the SAP Vendor Line Item Display transaction (T-Code FBL1N) into Alteryx.
​If you would prefer to watch rather than read, then take a look at our blog, SAP Report Tool - Extract SAP T-Code data directly into Alteryx.
This blog will be split into 2 parts. 
In the first part, we will take a look at the Vendor Line Item Display transaction in SAP.
In the second part, we will look at how the SAP Report tool can be used to execute the Vendor Line Item Display transaction from within Alteryx.
If you would like to follow the steps described in this blog, you will need:
  • Alteryx Designer - Request a trial here.
  • DVW ACS for Alteryx Designer - Request a trial here.
  • Access to an SAP ECC or SAP S/4HANA system
If you have access to Alteryx Gallery and would like to download the workflow presented in the blog, click here.

1. The SAP Vendor Line Item Display transaction (T-Code FBL1N)

The SAP Vendor Line Item Display transaction is one of the most commonly used transactions in SAP ECC and SAP S/4HANA. ​The transaction provides a number of ways for users to search for and display Vendor payment information (i.e. Vendor line item data).
Picture
Picture
The Vendor selection area is used to select the Vendor or Vendors of interest.

Picture
The Selection using search help area provides an alternative, more flexible way, of searching for the Vendors of interest with SAP search help functionality.

Picture
The Status area allows you to refine the selection to include only Open items, Cleared items or All items.

Picture
The Type area allows you to further refine the selection to include Normal items (i.e. items which do not belong to any other type), Special G/L transaction items, Noted items, Parked items or Customer items (i.e. if a Customer account also exists for the same business partner as the Vendor then those items are also displayed.

Picture
The List Output area is used to control the Layout that is used to present the transaction output. If no Layout is explicitly selected, then a default Layout is used. You can also limit the number of records displayed in the output. 

Picture
The Find Variant button retrieves any variants associated with the transaction. The variant is a powerful piece of functionality in SAP. It allows a user to save the selection criteria entered into the transaction selection screen and reuse it when running the transaction.

When the transaction is executed the results are retrieved based upon the selections specified above. The output is displayed using the selected (or default) Layout.
Picture

2. Execute the SAP Vendor Line Item Display transaction (T-Code FBL1N) using the SAP Report tool in Alteryx

So, we now have a basic understanding of how the SAP Vendor Line Item Display transaction works in SAP ECC or SAP S/4HANA. 
There are a number of ways in which we can replicate the output of the SAP Vendor Line Item Display transaction in Alteryx. 
One option is to use the SAP Table Data tool to extract data from table BSIK (Accounting: Secondary Index for Vendors). ​
Another option would be to define an SAP Query (T-Codes SQVI / SQ01 / SQ02 / SQ03) referencing table BSIK and use the SAP Query tool to extract the data into Alteryx.
In this blog though, we are going to use the SAP Report tool. The SAP Report tool is one of our Advanced Tools and unlike the SAP Table Data tool and SAP Query tool it requires the installation of a custom Function Module on your SAP system to use it.
Let's take a look at the construction of an Alteryx workflow using the SAP Report tool to extract data from the SAP Vendor Line Item Display (T-Code FBL1N) transaction.
Picture
Picture
​The SAP system to be accessed is selected on the Parameters tab of the SAP Logon tool. Details of the selected SAP system along with the credentials of the logged in user are passed to the other tools in the workflow.

Picture
Picture
Transaction Code, FBL1N is selected on the Parameters tab of the SAP Report tool. The screen shot below shows the "final state" configuration of the SAP Report tool ready for workflow execution.

Picture
In the steps below, we will show you how configure the SAP Report tool to extract data from the SAP Vendor Line Item Display (T-Code FBL1N) transaction.
The initial state of the SAP Report tool looks like this:
Picture
Picture
The Object Type drop down list supports Report and Transaction Code (T-Code). For this example, we will select Transaction Code.

Picture
Use the Search String field to enter the technical name of the Report or the Transaction Code. For this example, we will specify Transaction Code, FBL1N.

Picture
Click the Search button to trigger the search for the entered Report or Transaction Code.

Picture
The results of the search are displayed in the Select Report drop-down list.

If the Report object type is selected, then the Report entered into the Search String is displayed in the drop down list. Simply select the Report to continue. ​
If the Transaction object type is selected, then the Report linked to the specified Transaction Code is displayed in the drop down list. Simply select the Report to continue. ​ In our example, Transaction Code, FBL1N is associated with Report, RFITEMAP.
Picture
Select Variant is a key feature of the SAP Report tool. If Variants have been defined for the selected Report or Transaction Code in SAP, they are available for selection from the Select Variant drop down list. 

Selection of a Variant automatically applies the Vendor selection criteria, line item selection settings and list output settings  ​to the extract. 
If you select a Variant, you do not need to manually define the Vendor selection criteria, line item selection settings and list output settings etc. in the SAP Report tool. ​​
For our example, we will not select a Variant and will apply our selection settings manually.
Once the Report or Transaction Code is confirmed, the Filters tab is automatically populated with the available selection criteria. 
If a Variant is selected, the Filters tab can be ignored. We have chosen not to use a Variant so the FLBL1N transaction selection criteria are entered manually using the Filters tab.
Picture
We want to extract data based on the following criteria:
  • Vendor accounts between 1 and 100
  • Line items that are open on October 2nd, 2019
  • ​Normal items only
The criteria translate into the SAP Report tool as follows:
Picture
Picture
Note that the date of ​October 2nd, 2019 is entered in a Year/Month/Day format (i.e. 20191002) into the Open at key date field.
We now need to address the format of the output. 
The SAP output is not presented in a format that can be immediately used within Alteryx.
Picture
To convert the output to a format that can be used within Alteryx go to the Sample Data tab and click the Preview button. The SAP Report tool retrieves a sample extract of data from the selected Report or Transaction. 
Picture
The first step is to identify where the Header starts in the output. 
In our example, the Header starts at row number 16. The Header Row No field can be entered manually or by clicking on row number 16 in the Preview tab and using a right-mouse click to display a context menu. Select Add Header Row No ​from the context menu.
Picture
This next step is only required for SAP Reports and Transaction Codes that have an irregular format with multiple fields appearing in the Header. 
In our example, we want to also include the following additional Header fields in the extract output:
  • Vendor Number
  • Vendor Name
  • Street
  • City
  • Post Code
  • Company Code
  • Company Name
To add the Vendor Number field to the output, right-click on the Vendor row and select Process Header Field from the context menu.
Picture
The Row Tag, Field, Start and Length fields are populated with details of the selected field. These can be manually adjusted in the respective fields. To proceed, click the Add button. 
The Header Fields field is updated with the details entered. These can be adjusted directly in the Header Fields field.
This process needs to be completed for each of the Header fields to be included in the extract output. Note that this may be an iterative process requiring a number of adjustments before the format is correct.
Picture
After the additional fields have been added, click the Preview button to review the formatted output.
Picture
We are now ready to complete the workflow.
Picture
An Alteryx Select tool is used to sequence the fields in the final output.

Picture
Picture
Finally, an Alteryx browse tool is added to the workflow. 

When the workflow is run the data extracted from the SAP Vendor Line Item Display transaction (T-Code FBL1N) is output in a format ready for further analysis.
Picture
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
    BusinessObjects
    Data Migration
    DVW Integration Platform
    Finance
    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

    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
    December 2016
    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 CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF ALTERYX CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)​
FREE TRIAL OF ​ALTERYX CONNECTOR FOR SAP BUSINESSOBJECTS

​KNIME CONNECTORS
​FREE TRIAL OF KNIME CONNECTOR FOR SAP
FREE TRIAL OF KNIME CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF ​KNIME CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF KNIME CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

POWER BI CONNECTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP
​FREE TRIAL OF POWER BI CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF POWER BI CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF POWER BI CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

TABLEAU CONNECTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP
​​FREE TRIAL OF TABLEAU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)​
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF TABLEAU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

DATAIKU CONNECTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF DATAIKU CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)


SNOWFLAKE CONNECTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)

FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP SUCCESSFACTORS
FREE TRIAL OF SNOWFLAKE CONNECTOR FOR SAP INTEGRATED BUSINESS PLANNING (IBP)

SERVICES

PRICING

DEMOS

BLOG

HELP CENTRE

ABOUT US

CONTACT US

The DVW Integration Platform from DVW Analytics, brings the power of SAP to users of Alteryx, KNIME, Power BI, Tableau and other global software leaders for Analytics & Process Automation

© COPYRIGHT 2003 - 2023 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 RPA TOOLS
      • ALTERYX CONNECTOR FOR SAP CUSTOMER EXPERIENCE (CX)
      • ALTERYX CONNECTOR FOR SUCCESSFACTORS
      • ALTERYX CONNECTOR FOR BUSINESSOBJECTS
    • KNIME CONNECTORS >
      • KNIME CONNECTOR FOR SAP
      • KNIME CONNECTOR FOR SUCCESSFACTORS
    • POWER BI CONNECTORS >
      • POWER BI CONNECTOR FOR SAP
    • TABLEAU CONNECTORS >
      • TABLEAU CONNECTOR FOR SAP
    • DATAIKU CONNECTORS
    • SNOWFLAKE CONNECTORS
  • SERVICES
  • DEMOS
    • ALTERYX CONNECTOR DEMOS
    • KNIME CONNECTOR DEMOS
    • POWER BI CONNECTOR DEMOS
    • TABLEAU CONNECTOR DEMOS
    • SNOWFLAKE CONNECTOR DEMOS
  • FREE TRIAL
  • PRICING
    • ALTERYX CONNECTOR PRICING
    • KNIME CONNECTOR PRICING
    • POWER BI CONNECTOR PRICING
    • TABLEAU CONNECTOR PRICING
    • DATAIKU CONNECTOR PRICING
    • SNOWFLAKE CONNECTOR PRICING
  • RESOURCES
    • WEBINARS >
      • ALTERYX CONNECTOR WEBINARS
      • KNIME CONNECTOR WEBINARS
      • POWER BI CONNECTOR WEBINARS
      • TABLEAU CONNECTOR WEBINARS
      • SNOWFLAKE CONNECTOR WEBINARS
    • EVENTS >
      • ALTERYX EVENTS
      • KNIME EVENTS
    • SOFTWARE DOWNLOADS
    • INSTALLATION GUIDES
    • TUTORIALS
    • SAMPLE WORKFLOWS
    • FAQ
    • LICENSE
    • RESELLER RESOURCES
  • HELP CENTRE
  • BLOG
  • ABOUT
    • ABOUT US
    • CONTACT US
    • CUSTOMERS
    • PARTNERS
    • RESELLERS