04-12-2007 4:56 AM
i want to know in which tables i can get the budget entered against an Internal Order....
i have some requirement to makes Z Report....
04-12-2007 5:03 AM
hi abhishek
all PO-items are available in table TKEPO which is passed as table parameter; check fields MENGE and NETPR for quantity and net value.
hope this will help
reagrds
navjt
reward points
04-12-2007 5:05 AM
04-12-2007 5:12 AM
Hi,
Check table <b>BPEG</b>.
Here user
OBJNR = "Object number of internal order"
WRTTP = '41' --> Original Budget
Let me know if you have any question.
Regards,
RS
04-12-2007 5:22 AM
04-12-2007 5:40 AM
04-12-2007 5:49 AM
Hi,
Check tables <b>BPGE</b> and <b>BPJA</b>.
Check these table with
LEDNR = '0002'.
OBJNR = "Obj. of internal order"
WRTTP = '41'.
Let me know if you still do not find any values.
Regard,
RS
04-12-2007 5:56 AM
04-12-2007 8:13 AM
04-13-2007 5:31 AM
04-13-2007 5:37 AM
Hi,
I would suggest you to create a Internal order budget manually using appropriate transaction. Before doing that, turn the SQL trace on using transaction ST05. Once you save the budget, turn the trace off and display the trace.
You will see, what are the table being accesses and updated during this process.
Can you tell me which transaction you are using to manually update the budget. I may be able to find something based on that.
Regards,
RS
04-13-2007 5:48 AM
04-13-2007 6:06 AM
04-13-2007 6:11 AM
Thanx RS
i am able to find out the tables thr ST05
i am running on 4.7 may be thats why ur earlier tables (u told me) help me out
but u guided me how to go .......
abhishek