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

3 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.