Skip to Content
avatar image
Former Member

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

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()

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 23 at 09:17 AM

    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

    Add comment
    10|10000 characters needed characters exceeded