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

1 - CONTROL IF ONE DOCUMENT HAS BEEN ALREADY SENT by RCS to BI4 ?

1.1 Control in RCS

for ORDERS, VA03

One ZPI1 message is created in SAP each time the order is updated (max 1 by day)

Each ZPI1 message means the order has been sent to BI4 (line inserted/updated in ZWOCT010 → see below)

for DELIVERIES, VL03n

for invoices, VF03

One ZPI3 message is created in SAP each time the invoice is updated (max 1 by day)

Each ZPI3 message means the invoice has been sent to BI4 (line inserted/updated in ZWOCT010 → see below)

1.2 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.3 SE16 / ZWOCT010

This table contain the list of documents that have been sent from RCS to BI4, with the date of the last sending to BI4

If the send-date = null value, it means that the document will be taken by the next SAP extraction job

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 order + 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	Extraction of the shipment only

2.1 SE38 / ZWOCO01500

2.2 Refresh of only one document

Choose « treatment 1 » - 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.

You will have the following message :

You can see the last date when data was sent to BI4 (in the example : 05.05.2012)

And the RETDAT has been reset to zero ==> it will be taken by the next RCS extraction job.

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