<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Using SAP-FI template and the SETCLASS variable in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Using-SAP-FI-template-and-the-SETCLASS-variable/m-p/780998#M1228497</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;Hi&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;I am using the SAP Connector and using the SAP-FI template to pull out data from my clients SAP database.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;All is looking well with all the customer data looking like they have been extracted OK but we have no vendor transactional data (apart from the vendor details in LFA1 which seem OK).&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;When we run the extract we used the default SETCLASS of 0109, but when I look at the code I see that this values (SETCLASS) is used as a condition when extracting from the SAP tables SETLEAF, SETNODE and SETHEADERT.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;Using my client's SAP administrator we looked at these 3 tables and we have noted that there are more entries (that we need) other than the default 0109 (for example 0106 etc). Have others experienced this scenario and how did they deal with it other than hardcoding all these combinations in an OR statement in the template code?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;Any assistance would be appreciated&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;Alexis&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 26 Jan 2026 21:26:37 GMT</pubDate>
    <dc:creator>alexis</dc:creator>
    <dc:date>2026-01-26T21:26:37Z</dc:date>
    <item>
      <title>Using SAP-FI template and the SETCLASS variable</title>
      <link>https://community.qlik.com/t5/QlikView/Using-SAP-FI-template-and-the-SETCLASS-variable/m-p/780998#M1228497</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;Hi&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;I am using the SAP Connector and using the SAP-FI template to pull out data from my clients SAP database.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;All is looking well with all the customer data looking like they have been extracted OK but we have no vendor transactional data (apart from the vendor details in LFA1 which seem OK).&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;When we run the extract we used the default SETCLASS of 0109, but when I look at the code I see that this values (SETCLASS) is used as a condition when extracting from the SAP tables SETLEAF, SETNODE and SETHEADERT.&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;Using my client's SAP administrator we looked at these 3 tables and we have noted that there are more entries (that we need) other than the default 0109 (for example 0106 etc). Have others experienced this scenario and how did they deal with it other than hardcoding all these combinations in an OR statement in the template code?&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;Any assistance would be appreciated&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;Alexis&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt; line-height: 1.5em;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="font-size: 12pt;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Jan 2026 21:26:37 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Using-SAP-FI-template-and-the-SETCLASS-variable/m-p/780998#M1228497</guid>
      <dc:creator>alexis</dc:creator>
      <dc:date>2026-01-26T21:26:37Z</dc:date>
    </item>
    <item>
      <title>Re: Using SAP-FI template and the SETCLASS variable</title>
      <link>https://community.qlik.com/t5/QlikView/Using-SAP-FI-template-and-the-SETCLASS-variable/m-p/780999#M1228499</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;The issue has been resolved - look for my posting "Bug with SAP-FI QVD extraction application identified" &lt;SPAN style="font-size: 10pt; line-height: 1.5em;"&gt;elsewhere in this group.&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 20 Nov 2014 16:27:19 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Using-SAP-FI-template-and-the-SETCLASS-variable/m-p/780999#M1228499</guid>
      <dc:creator>alexis</dc:creator>
      <dc:date>2014-11-20T16:27:19Z</dc:date>
    </item>
  </channel>
</rss>

