topic Re: table bpja in Application Development and Automation Discussions

table bpja

Former Member — Mon, 28 May 2007 08:43:29 GMT

i need to get a field from this table. however i am not able to get the link between sd billing and this table.

any ideas about the flow.

please help.

Re: table bpja

Former Member — Mon, 28 May 2007 08:48:25 GMT

You have to link this table OBJNR with other SD tables OBJNR

this field may not be straight field link, but objnr is a combination of 2 to 3 fields

Give the VORGA field = SD00 (some SD related value) and check the field OBJNR field you will get some link.

can you elaborate more on your requirement. means what exactly you are trying to get from Sd point of view from this table?

Reward points if useful

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: table bpja

Former Member — Mon, 28 May 2007 19:15:41 GMT

hi aanji

i am doing a report for sd billing which shows the total quantity and value of materials bought per customer. In this i also need to find the annual budget for a cost center for that fiscal year. My functional team mate gave me this table to find the budget. but i am not getting as to how to link the cost center i got from vbrp , and find the annual budget.

Re: table bpja

Former Member — Mon, 28 May 2007 19:36:38 GMT

I think you'll find that the object number is a concatenated key of 'FS' (or some other identifier), the controling area and the cost center.

Rob

Re: table bpja

Former Member — Mon, 28 May 2007 19:58:34 GMT

Maybe 'KS' instead of 'FS'.

And the relationship is maintained in table ONRKS.

Rob

Message was edited by:

Rob Burbank

Re: table bpja

Former Member — Mon, 28 May 2007 20:28:52 GMT

hi rob thanks for ur reply. i still have some questions .

1) for one single objnr there are multiple values in the field WTJHR , based on fields like POSIT and fiscal year .

so how do i get the right value . at the moment all i know is the cost center from vbrp and the assocaited objnr as told by you. then how to get the budget assocaited with that particular item.

2) just to check if i have understood correcly .

i have the cost center from vbrp .

from that i am getting the corresponding objnr for that cost center from table ONRKS . and from there i am going to table BPJA to get the budget for the OBJNR .

is this the right flow ?

Re: table bpja

Former Member — Mon, 28 May 2007 20:44:57 GMT

1) - I think you have to subtract the distributed budget from the total budget to get the distributable budget and then add all of those amounts for the object and year.

2) - I think so, but we use budgets for funds management, not CO, so it could be different.

Rob