Hi All,
I am facing couple of issues while extracting data from SAP HANA data base of S4 Hana system,
1. I am not getting any data for ANLC table even though there is a data in S4 system.
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.
Does anyone know what the root cause of this issue?
Thanks & Regards
Ravi
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
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.
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.
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./)
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 :)
Hi All,
Just FYI...
We can also use SAP RFC/BOA RFC packages to extract the data instead of views.
Thanks & Regards
Ravi
Please sign in to leave a comment.
Comments
5 comments