Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: How to use variable in SAP Input Filter field

  1. #1

    Default How to use variable in SAP Input Filter field

    I used generate rows and connected with Sap Input step. (VBFA.ktr)
    My use case is SELECT VBELV, VBELN from VBFA where VBELV = ${VAR_Y}

    In Generate rows I have created FILTER field and entered as VBELV (field) = ${VAR_Y} (variable set which has the previouse transformations value). I am getting SAPSQL_WHERE_ILLEGAL_VALUE error message.

    Kinldy help me to achieve where condition with variable in SAP filter itself in the generate rows step.


    *************************************************************************************************************

    To achieve this I have tried the other way which is not efficient but working fine.
    (VBFA1.ktr)
    I have generated rows without any filter then sorted row by VBELV.
    Get Variable step I connected with Filter Rows step and in filter rows step am checking the condition VBELV = SD_DOC (its a name for variable mentioned in get variable).
    In this case all the rows are fetched first then filteration is happening which is not efficient.


    Regards,
    Naren.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.