Problem Description

You get a request from ZWW to find or repeat a transmission. The request normally has a excel sheet attached where you can see the ZWW/SAP order number in question:

Here the order number is in the first column, Lieferung.

How it is done

Open a command line on the scheduler pc by the windows startmenu:

Click Start
Click Execute…
In the open: entryfield enter cmd
Click OK

On the command line, change into the BPS programm folder and start the TSS sql query tool (you might use sqlplus as well):

  Microsoft Windows 2000 [Version 5.00.2195]
  (C) Copyright 1985-2000 Microsoft Corp.
  
  H:\>c:
  C:\>cd programme\bps
  C:\Programme\BPS>tss
  Tini SQL Shell V1.3
  Copyright (C) 1995-1997 by IBK-Landquart-Switzerland
  Enter "?" or "HELP" for instructions.
  TSS>

Now do some initial settings and connect to the database:

  TSS> set database oracle
  TSS> connect zkswin/blablabla@zks
  connected to ORACLE
  TSS> set output vertical

To find the record with the transmission info, enter the query below to select the matching order row in the history data. The ZWW order number must be preceeded by '%P;00' and trailed by ';%':

  TSS> select * from zks.historderrows where info like '%P;0084503178;%';
  
  IDENT...............: 158532
  TRIPDATE............: 02.06.06
  TRIP................: HL
  PARTNER.............: 0090443
  ORDER_ID............: 4713438383
  ORDER_CD............: 0
  ORDER_DATE..........: 01.06.06
  ORDER_BY............: zksbatch
  INV_ID..............: NULL
  INV_RUN.............: 1
  CMT.................: NULL
  PNR_XFER............: NULL
  MOD_DATE............: 01.06.06
  MOD_BY..............: M463728
  INFO................: ZWW;7624400080191;10310359000001;INSDES;
  HSTAT...............: NULL
  HOST_XFER...........: 171763
  1 row(s) selected.
  TSS>

You see the transmission number in the column host_xfer, this transmission number is also the one used to create the GD records. In case this value is NULL, the transmission has not yet been executed but will take place at the next run of ZwwSendOrders.cmd.

You can find the date when this transmission was done by a query of the table hostxfers:

  TSS> select * from zks.hostxfers where ident=171763;
  
  IDENT...............: 171763
  XDATE...............: 01.06.06
  TABLENAME...........: historderrows
  APPLICATION.........: ZwwSendOrders
  1 row(s) selected.
  TSS>

In case you need to repeat the transmission, you can set host_xfer to NULL as:

  TSS> update zks.historderrows set host_xfer=NULL where host_xfer=171763;
  1 row(s) processed.
  TSS> commit;
  committed.
  TSS>