Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Other: HVR6: Mix SAP Custom Tables and SAP tables

Answered
Mark Ericson Que User

Problem: Cannot mix sap tables with SAP custom tables (tbtco_cs tables) in a channel when using SAP Unpack.  F_JR2A01 Channel 'f62_l_01' has Transform with parameter SapUnpack defined, but none of the capture locations ('s_han_f62_01') is a SAP location

Suggestion: Activate jobs will fail when sap tables and non-sap tables are mixed in channel with sapunpack in channel and HANA DB dictionary is used in source. Can these restriction be removed?

Please sign in to leave a comment.

Comments

1 comment

Date Votes
  • Official comment
    Edwin Fivetranner

    Hi Mark,

    Acknowledgement: Your objective to mix SAP standard tables and custom tables within a single HVR6 channel is noted.

    Currently, it isn’t possible to include both SAP standard and custom tables in the same channel when using SAP Unpack, especially if the source location does not meet SAP location requirements.

    Workaround: You can achieve this by creating two separate channels as you already stated:

    • One channel dedicated to SAP standard tables using SAP Unpack and the required SAP location settings.

    • A second channel handling the SAP custom tables (e.g., tbtco_cs) without SAP Unpack.

    Detailed steps and documentation can be found in the Fivetran Help Center.

    Would this approach solve your immediate requirements?

    Thanks,
    Edwin