=======================================================================

1 - Control if one document has been already sent by RCS ?

1.1 RCS ZWOCT010 table

RCS ZWOCT010 is dedicated to PPS.

Every day, as soon as one order, delivery, shipment, or invoice, is created in RCS, one line is created in this table.

At night, if the document is sent from RCS to PPS, one date is populated :

when orders are extracted from RCS, one ZPI1 message is saved in RCS, the date is populated for the order (not at the order line level, but at the order level)
when orders 45% are extracted from RCS, one ZNE5 message is saved in RCS, the date is populated for the order 45% (not at the order line level, but at the order level)
when deliveries are extracted from RCS, one ZPI2 message is saved in RCS, the date is populated for the delivery (not at the delivery line level, but at the delivery level)
when invoices are extracted from RCS, one ZPI3 message is saved in RCS, the date is populated for the invoice (not at the invoice line level, but at the invoice level)
when shipments are extracted from RCS, one ZPI4 message is saved in RCS, the date is populated for the shipment

It means that you can find in this table the date of the last sent of the document from RCS to PPS.

ATTENTION :

If RCS had a problem during the extraction, dates can be not populated in ZWOCT010.

1.2 SE16 / ZWOCT010

TECHNO - BI TEAM > PPS - reload documents from RCS > image2021-11-4_11-7-40.png

TECHNO - BI TEAM > PPS - reload documents from RCS > image2021-11-4_11-8-9.png

TECHNO - BI TEAM > PPS - reload documents from RCS > image2021-11-4_11-9-24.png

In « object key » (clé d’objet), you indicate the document number on 10 digits

In « application », you have to indicate the type of document :

V1 = ZPI1 : for one order

V2 = ZPI2 : for one delivery

V3 = ZPI3 : for one invoice

V7 = ZPI4 : for one shipment (dossier de transport)

EF = ZNE5 : for one order 45% (purchase order)

« Data extraction date » indicates the last sent of the document thru PPS.

In this example, it means that the invoice has been sent to PPS on 05.05.2012

2 - Asking for the refresh of documents

If you ask for the refresh of one document, it’s not working like in the RCS extraction job :

	RCS daily extraction job	Refresh asked via ZWOCO01500
ORDER	Extraction of the order + linked schedule	Extraction of the + linked schedule
DELIVERY	Extraction of the delivery + linked shipments + linked order(s)	Extraction of the delivery only
INVOICE	Extraction of the invoice + linked deliverie(s) + linked order(s)	Extraction of the invoice only
SHIPMENT		Extraction of the shipment only

2.1 SE38 / ZWOCO01500

2.2 Asking for the refresh of only one document

Choose « treatment 1 » (Default). Never use « treatment 2 » because no controls are done in this extraction.

Mandatory :

V1 to ask the refresh for one ORDER

V2 to ask the refresh for one DELIVERY

V3 to ask the refresh for one INVOICE

V7 to ask the refresh for one SHIPMENT

EF to ask the refresh for one ORDER 45%

==> Don’t forget to flag the « Extraction date » button. Nothing must be populated in « Date update value » field (valeur de MAJ de la date).

==> Don’t forget to populate the document number on 10 digits, including zeroes in front of it.

Clik on

You will have the following message :

Affichage du résultat de la demande : ancienne date d’extraction (CREADAT) et nouvelle date d’extraction remise à 00

2.3 No result

If the result is like :

It means that no document corresponding to your selection is existing in the ZWOCT010 table (and no one can be refreshed). It can be :

because you have populated the wrong “V1, V2, V3” that do not correspond to the type of document number you have populated in “Id document selection”
because the document you want to refresh has never been sent to PPS (To refresh one document, one line must exists in the ZWOCT010 table for this document) ==> esk RCS team
because the document is currently not sent by the interface to PPS (not all RCS orders are sent to PPS …)

2.4 Asking for the refresh of a list of documents

Copy in your clip-board a list of document having one document code by line, like following :

0060085785

0060085870

0060086561

0060086609

…

NB : you have to take documents having the same nature : only invoices, or only orders … i.e., documents having the same “V1, V2, V3 … selection”.

Past your clip-board using the button :

When you click on , you come back and you can’t see the document codes you have passed. But they have been saved in memory. It is shown by the green arrow.

after and the confirmation message, you can see the list of documents that have been asked for refresh in Pilotages