Skip to Content
0

How to create view in Information Steward to track changes in the Customer Master

Feb 21 at 06:58 PM

36

avatar image
Former Member

I'm new to Information Steward. I'm tasked to create a view where changes in the customer master are tracked. Below is what I have done, but no data is being pulled. Any help would be appreciated.

I have joined tables CDHDR, CDPOS, KNA1, KNB1 and KNVV.

The OBJECTID is two leading zeros followed by an 8 digit customer number, so in the Output Schema, I mapped OBJECTID as substr(IS_DATA_STAGE.dbo.CDHDR.OBJECTID,3,8)

Below is what I have in the Filter Condition:

IS_DATA_STAGE.dbo.KNVV.VKORG = '1100' AND IS_DATA_STAGE.dbo.KNB1.BUKRS = '1110' AND IS_DATA_STAGE.dbo.KNVV.VTWEG != '40' AND IS_DATA_STAGE.dbo.CDHDR.OBJECTCLAS = 'DEBI' AND IS_DATA_STAGE.dbo.CDHDR.UDATE >= to_date(add_months(sysdate(),-1),'mm/dd/yyyy') AND IS_DATA_STAGE.dbo.CDHDR.UDATE <= sysdate() OR IS_DATA_STAGE.dbo.KNVV.VKORG = '1112' AND IS_DATA_STAGE.dbo.KNB1.BUKRS = '1120' AND IS_DATA_STAGE.dbo.KNVV.VTWEG != '40' AND IS_DATA_STAGE.dbo.CDHDR.OBJECTCLAS = 'DEBI' AND IS_DATA_STAGE.dbo.CDHDR.UDATE >= to_date(add_months(sysdate(),-2),'mm/dd/yyyy') AND IS_DATA_STAGE.dbo.CDHDR.UDATE <= sysdate()

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Arun Sasi Feb 23 at 09:17 AM
0

Former Member

As per SAP Best practice, you should not profile or create views directly on SAP Tables as they are huge and can cause performance bottleneck. CDHDR and CDPOS are very big tables and if you create view on top of them it might work but it can cause sever performance issues.

Best practice would be to extract the SAP tables in a Staging Database Schema and then profile or create Views on it. You can schedule the .job in Data Services to load the

CDHDR, CDPOS, KNA1, KNB1 and KNVV

tables on a daily basis(truncate and load)

1) Extract only the necessary information from the CDHDR, CDPOS, KNA1, KNB1 and KNVV tables and dump it in to a Staging Layer

2) Profile only on the required columns and optimize the query in the IS view as per the performance setting mentioned in the

Section 2.8.11 Work with SAP tables in views of SAP Information Steward 4.2 user guide

https://help.sap.com/doc/PRODUCTION/18ec99b2d06449c5b8b79c784d5a3af9/4.2.8/en-US/is_42_user_en.pdf

3) Create Views based on your requirement. Before creating view, build a data flow and extract the query logic in Data Services designer. This will help you understand how much time it is taken by DS job. if performance is good try creating the query in Information Steward Views

https://answers.sap.com/questions/424056/can-we-profile-on-backend-tables-of-sap-ecc-in-inf.html

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded