﻿Parameter days

Set V[CurrentDate] "&V[today_d.m.y]"
Set V[diff] "&V[CurrentDate]" - "01.01.1900"
Set V[d] "01.01.1900" + "&V[diff]"
Set V[begin] "&V[d](7-10)&V[d](4-5)&V[d](1-2)"

Set V[CurrentDate] "&V[today-&V[days]_d.m.y]"
Set V[diff] "&V[CurrentDate]" - "01.01.1900"
Set V[d] "01.01.1900" + "&V[diff]"
Set V[end] "&V[d](7-10)&V[d](4-5)&V[d](1-2)"

// create result table
CreateTable V[orders] vbeln audat kunnr name1 ort01

// create SQL parameters
Set V[table] "VBAK join KNA1 on KNA1~KUNNR = VBAK~KUNNR"
Set V[fields] "vbak~vbeln,vbak~audat,kna1~kunnr,kna1~name1,kna1~ort01"
Set V[condition] "vbak~ernam = 'NAME' and audat between '&V[end]'  and '&V[begin]' and vbak~trvog = '0' " //&V[_user]

// execute database Select
Call "/guixt/dbselect" -currentUser _
  export.table="table" _
  export.fields="fields" _
  export.condition="condition" _
  import.values="orders"

CopyText toText="temp" fromTable=V[orders] -json


Return "&text[temp]"
