2006 Nov 07 10:44 AM
Hi all,
I am trying to workiout on netting process specific to oil industry.
I am using netting tables : OIAQA and OIA12I
Can anyone explain me the mapping between these tables?
thanks in advance.
2006 Nov 07 11:54 PM
The table OIA12I contains details related to a netting document at item level and the table OIAQA contains details about the output related to this netting document. The 2 tables are linked by the netting document number NETNUM in OIA12I and NETDOC in OIAQA.
You can maintain output types related to exchanges using transaction v/40.
Hope this answers your question.
Best Regards
Vishnu
2006 Nov 07 8:28 PM
2006 Nov 07 11:07 PM
Hi,
I moved your topic to the Oil&Gas forum
Mario
Message was edited by: Mario Herger
2006 Nov 07 11:54 PM
The table OIA12I contains details related to a netting document at item level and the table OIAQA contains details about the output related to this netting document. The 2 tables are linked by the netting document number NETNUM in OIA12I and NETDOC in OIAQA.
You can maintain output types related to exchanges using transaction v/40.
Hope this answers your question.
Best Regards
Vishnu
2006 Nov 15 6:19 PM
Sachin,
Do let me know if the information was helpful to you.
Also possibly please let me know if & how is the scenario implemented.
Best Regards
Vishnu
2006 Dec 05 4:59 PM
Hi,
please can you be more clear on the business background of your question..
there are normally two kinds of netting on the industry - Old one : Financial netting and new one which consideres goods movements too : movement based netting..
i try to give you more technical design of netting ..
OIAQB is the exchange movements index. This is always filled irrespectiv
of the kind of netting which is going to happen.
In Financial based netting system posts to OIA10H, OIA10, OIA10L and
OIA10E. While other remain, OIA10L records are deleted after BTCI is
sucessfull. This process does not go back and update OIAQB since it
does not care what is happening to the exchange movements. It is a
financial based netting and hence only takes care of financial docs.
So, expecting that OIAQB-CLRNO will be updated incase of Financial based
netting would not be resonable and the main motivate of FI netting will get
defeated.
On the other hand, movement based netting posts to OIAQA, OIA12I, OIA10L
and OIA12ICOND. While OIA10L is deleted after BTCI, rest remain. Once
BTCI is completed, system updates OIAQB-CLRNO since it tells the index
of exchange movements that the documents are cleared (CLRno is the
netting document number) and need no further processing.
Ofcourse with BoM's you should already be aware that exchanges tables most of the time consider the header and not the BoM items (because the company would not really desires to let exchange partner know about the ingredients of the BoM - because there could be many many additives specific to the business)
Hope this helps to get the bigger picture..
Regards,
Kiran