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

Community

Component: expand Fivetran sap dbt package (SAP HANA)

Planned
Germann Apaev User
  • Edited

Objective: We want to leverage Fivetran’s pre-built sap dbt package for our financial reporting. However, several critical standard financial and asset accounting CDS views —like BSIK, COEP, FAGLFLEXT, ANLP, and ANEP—are currently not covered by the package models.

Expanding the package to natively derive the contents of these standard views will save us (and other customers) weeks of manual research and reverse-engineering of proprietary SAP logic.

Best regards,

Germann Apaev

Please sign in to leave a comment.

Comments

5 comments

Date Votes
  • Official comment
    Joe Fivetranner

    Hi Germann, thanks for reaching out!

    The names of the objects you mentioned sound more like compatibility views opposed to CDS views. Would you be able to confirm, are you wanting these compatibility views or CDS views replicated in the dbt package?

    If compatibility views, this is something we could support! We already include COEP and could update the model to also support the others you mentioned.

    Let me know, thanks!

  • Germann Apaev User

    Hi Joe,

    yes, i meant to say compatibility views. Honestly i dont know which of the objects are views or tables, ill just  include every object that we plan to export:

    ACDOCA,
    ANEP,
    ANLA,
    ANLH,
    ANLP,
    AUFK,
    BKPF,
    BSEG,
    CEPC,
    CEPCT,
    COBK,
    COEP,
    COEPR,
    COOI,
    CSKA,
    CSKB,
    CSKS,
    CSKT,
    DD07T,
    FAGL_011PC,
    FAGL_011QT,
    FAGL_011SC,
    FAGL_011ZC,
    FAGLFLEXT,
    GLPCA,
    GLPCP,
    KNA1,
    KNB1,
    KNB5,
    LFA1,
    LFB1,
    MHNK,
    SETHEADER,
    SETHEADERT,
    SETLEAF,
    SETNODE,
    SKA1,
    SKAT,
    T001B,
    T003,
    T003T,
    T004,
    T005S,
    T005U,
    T052,
    T052U,
    T687,
    T687T,
    T880,
    TF150,
    TF151,
    TF500,
    TF501,
    TKA01,
    TKA03,
    TSTC,
    TSTCT,
    TVZB,

    TVZBT

     

    Thanks!

    Best regards,

    Germann Apaev 
  • Joe Fivetranner

    Thanks for the additional context, Germann. Looking at your object list, the only compatibility views are FAGLFLEXT, COEP, ANEP, and ANLP. The rest are standard tables that shouldn't require them.

    Good news: COEP is already available in the dbt package. I'll log the remaining three as a feature request and kick off development in the coming week. I'll keep you posted as things progress.

  • Germann Apaev User

    Hi Joe,

    Hope you're having a great week!

    I just wanted to quickly check in and see if there are any updates on the integration of the tables into the dbt package.

    Do you have a rough timeline or estimate for when these might be available? It would help us immensely with our internal planning.

    Thanks again for your great support on this!

    Best regards, Germann

  • Joe Fivetranner

    Hi Germann, we're planning to start this effort next week and should have it implemented in the dbt package no later than 7/29. Once we begin development I'll share the PR link here where you can follow along for real time updates.