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.
    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.

    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.