Dynamic Syntax for DocEntry and ObjType in Uf-sqlreport Answered

Massimo Sardi

Dear All

how could be possible in  B1Up SQL report to use the Damic Syntax to recall DocEntry and ObjType as parameters in a Stored procedure?

DocKey@ and ObjectId@       

example

from inside a SP  use a SQL-report UF  with a stored procedure inside

 

exec MySP DocKey@,  ObjectId@

do not work

while

exec MySp  $[ORDR.DocEntry],$[ORDR.ObjType]

it works

 

the aim is to use the same Sp on multiple Objtypes

Massimo

 

 

Comments

3 comments

Date Votes
  • Comment author
    SSP Automation
    Thank you for your request. It has been scheduled for review by the development team that will get back to you should there be questions.
    (Please note that as we are user-driven we can't guarantee that your request will be met unless it gets many votes and/or fit the product vision)
    Read more about the Feature Request process here
    [Internal Id: 47058]
    0
  • Comment author
    Rasmus Jensen

    Hi Massimo

    Thank you for the request. Actually, a bit surprised that they do not already work there.

    ´We will see if we can make it happen but until then you can use the $[BOY_TABLE] keyword to accomplish the same output... So if you write this:

    $[$[BOY_TABLE].DocEntry],$[$[BOY_TABLE].ObjType]

    It would work on all common screens that have a DocEntry and an ObjType field

    0
  • Comment author
    Massimo Sardi

    Dear Rasmus,

    thank for your reply.

    I'll use the proper table syntax $[$[BOY_TABLE].DocEntry],$[$[BOY_TABLE].ObjType] 

    for each target form till news.

    have a nice day

    Note: I'm running a sap 9.3 pl14 SQL version and B1Up_2020.11.00.0

    Massimo

     

    0

Please sign in to leave a comment.