05-15-2011 9:50 AM
Hi Experts,
whenever we create/change Purchase requisition/Purchase Order,
table COOI(Commitment line items) gets updated with the Purchase requisition/purchase order
item details and table COSP gets updated with the sum values of COOI entries order by primary keys
of the table.For better explanation i am taking fields from tables
COOI (taken few fields for example)
REFBT REFBN RFKNT LIFNR HRKFT OBJNR WTGBTR(Total value in transaction cuu)
1234 0010 00512 (empty) (empty) PR00148 10
1234 0020 00512 (empty) (empty) PR00148 10
1234 0030 00512 (empty) (empty) PR00149 20
table updated COSP with sum value of COOI order by it's primary keys
COSP (taken few fields for example)
OBJNR KSTAR HRKFT WTG010
PR00148 00512 (empty) 20
PR00149 00512 (empty) 20
I want to pass the value HRKFT(CO key subnumber/Origin grp) to table COOI
to update each commitment line item,so that sum will update table COSP order by it's primary keys
The same example revised with origin group.
COOI
REFBT REFBN RFKNT LIFNR HRKFT OBJNR WTGBTR(Total value in transaction cuu)
1234 0010 00512 (empty) 3100 PR00148 10
1234 0020 00512 (empty) 3200 PR00148 10
1234 0030 00512 (empty) 3300 PR00149 20
table COSP get update with sum value of COOI order by it's primary keys
of COSP considering HRKFT values now(taken few fields for example)
OBJNR KSTAR HRKFT WTG010
PR00148 00512 3100 10
PR00148 00512 3200 10
PR00149 00512 3200 20
and this table is used in report painter to show the commitment
COSTS's segregated by Origin Group.
I need to show the report in report painter HRKFT(origin grp) wise cost's for commitments.
which is using the COSP table to display.
Now my requirement is any exit/BADI/Enhancement where i can modify table COOI contents
with HRKFT value for each line item before sum calucalation for COSP table in detail while creating
Purhcase requisition/Purchase order.
We are using SAP GUI version 6.0
Helpfull answeres will be rewarded
<< Moderator message - Please do not promise points >>
Edited by: Rob Burbank on May 15, 2011 4:28 PM
05-15-2011 9:28 PM
Moderator message - When closing old threads, there is no need to add a comment. Adding a pasted answer like "answered" only brings old threads to the top of the forum list and pushes current ones down. If you do add a comment, please indicate just how the problem was resolved.