Issue with extraction from HANA DB

Answered

Comments

5 comments

  • Best answer
    Avatar
    Venkata Ravi Kumar Mullamuri

    Hi All,

    Thanks for your responses.

    Joseph Flesche - There is no issues with where clause of ANLC table,

    Ben Bauer - Using the view solved the issue for MARD table, but facing same issue with ANLC table. For ANLC view name is FAAV_ANLC and even when using this also i am getting 0 records,

    I will try and get this statement executed in SAP HANA DB in parallel to see where we are missing the data.

    Guillaume Brochet - Yes for these views, we need to use Manual Cranport package as it won't allow Cranport package type.

    Thanks & Regards

    Ravi

    Comment actions Permalink
  • Avatar
    Joseph Flesche

    1. I am not getting any data for ANLC table even though there is a data in S4 system.

    Did you check the Assemble Package? Specifically there WHERE clause.

    That's where I typically start with troubleshooting this type of issue.

    2. in MARD table i am not getting value into key figure columns (decimal data type columns) even though there are values in S4 system. It is coming as value 0 for all records.

    On occasion, I see that the SQL Server table field definitions are not correct. I typically change the fields to NVARCHAR  in SQL Server to start the troubleshooting process.

    0
    Comment actions Permalink
  • Avatar
    Ben Bauer

    Hi Ravi,

    This is a result of how the table schemas were simplified in S/4 HANA. Columns are not all in the same tables where they used to be. In an effort to provide a sort of "backward compatibility", there are now database views that can be extracted from which mirror the output of the old database tables. For MARD data, you'll want to extract from a view named NSDM_V_MARD. This stands for New Simplified Data Model - View - MARD.

    (source: https://wiki.scn.sap.com/wiki/display/ERPSCM/New+Simplified+Data+Model+%28NSDM%29+for+Inventory+Management+Tables)

    ANLC is definitely in the same boat, though I'm not sure what the database view is named. I guess if we're lucky it's called NSDM_V_ANLC! Maybe an SAP person can check something like SE11 to find out the name of the view.

    (source: https://blogs.sap.com/2017/02/05/s4hana-finance-new-asset-accounting-simplified./)

    1
    Comment actions Permalink
  • Avatar
    Guillaume Brochet

    Hi Ravi,

    I faced the same issue on MARD,MBEW etc .. on HANA and if i remember well, NSDM_V_MARD cannot be added directly as a package but you'll need an intermediary step (change package type if i remember well)

    If you have access to SAP HANA Studio and sufficent privilege you can see the full details of the construction for each table / view. (ABAP Developer Tools)

     

    Checks the links provided above and good luck :)

    0
    Comment actions Permalink
  • Avatar
    Venkata Ravi Kumar Mullamuri

    Hi All,

    Just FYI...

    We can also use SAP RFC/BOA RFC packages to extract the data instead of views.

    Thanks & Regards

    Ravi

    0
    Comment actions Permalink

Please sign in to leave a comment.