Skip to Content
author's profile photo
Former Member

Adding additional tables to the extractor configuration

Hi Experts,

Can you please help me adding additional tables to the SAP extractor and to configure the field data in the orgstructure to show a flag against the position.

Luke - I have tried using the option said by you from Application-wide Settings-->Data Centre --> Read SAP Table, it has properly save the added table, but not able to see it from SAP extractor configruation and not able to extract any data. Also, can you please guide me how to use the fields from this table (HRP1010) to write a small piece of logic to show a flag for a particualr position based on data.

Thanks in advance,

Purandhar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 03, 2011 at 11:31 AM

    Hi Purandhar,

    Did you start the extraction afterwards? like on page 27 of OrgChart Admin guide.

    Do you receive any errors on the CDS.LOG?

    Make sure that the user you are using has authorization within SAP ERP to view this table?

    Hope this helps,

    Kind Regards,

    Matthew

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Luke Marson

      Hi Luke,

      You are Brilliant and thanks for your help to sort out this issue.

      I am sharing some steps below, what I have done to get this functionallity worked(TVN 3.0 OrgChart).

      1) Modified 'functionConfiguration.xml' in extractorSchema to add additional table and its fields

      file path: /SAP/sap/TVD/J00/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/.system/Admin_Config/__000__TVN_S11_1/.delta/SAPExtractor/extractorSchema

      2) created new data element called 'ASL' from 'Application wide Settings->Data Centre->Read RDBMS Table' and mapped to 'POS_ASL' Oracle database table, where 'POS_ASL' is the destination table name in step1.

      3) Created a new XSL file 'aslxsl.xsl' for Icon rendering and placed into the below path.

      /SAP/sap/TVD/J00/j2ee/cluster/apps/Nakisa/OrgChart/servlet_jsp/OrgChart/root/Templates

      4) Copied presentationresources.xml from the current build to it's '.delta' root folder, and then modified this file to include new presentation called 'AslXsl'.

      <presentation name="AslXsl">

      <file name="Templates\aslxsl.xsl"/>

      </presentation>

      5) Configure your Position View to add 'newly created Data element ie. ASL in step2 by clicking on Views->standard View-> Design Details.

      Detail name: ASL

      Select a detail to link to SAPPositionBasicViewDetailsConfiguration (which is in blue at the top)

      Select a dataelement to use: ASL

      with the above steps, you will be able to see the field ASL to use in the Views, add this field to the view. which creates a file in your .delta/AppResources/detailconfiguration path

      Find the respective file which created newly and modify that XML file to include or replace presentation name with your custom/rendering presentation name.

      eg:

      changed from the below line

      <presentation>SimpleValueXSL</presentation>

      to the below

      <presentation>AslXsl</presentation>

      6) Once, the above steps are done, open your build from admin console then 'Save' and 'Publish'

      7) Then Open your orgchart to see Icon/Flag as required for a particular additional/custom field.

      Thanks and Regards

      Purandhar