Hi Gurus,
I am using Function Module 'KBPP_EXTERN_UPDATE_CO' to update Original Budget(CJ30).
Below are the WBS Elements' hierarchy:
LEVEL WBS AMOUNT
1 TST.z13 200000
2 TST.z13.HOTEL 100000
3 TST.z13.100 40000
3 TST.z13.200 40000
3 TST.z13.300 20000
2 TST.z13.CLUB 100000
3 TST.z13.C10 50000
3 TST.z13.C20 50000
4 TST.z13.C21 50000
3 TST.z13.C30
2 TST.z13.TECH
2 TST.z13.I10
I need to overwrite the budget amount in SAP with the value uploaded from flat file as shown
above.
The logic:
1.Post the budget amount with zero value.
Arrangement of WBS in table it_bpak by descending hierarchy level.
E_OBJNR E_GES WERT TWAER
-
PR00108277(TST.z13.C21) X 0 USD
PR00108278(TST.z13.C30) X 0 USD
PR00108276(TST.z13.C20) X 0 USD
PR00108275(TST.z13.C10) X 0 USD
PR00108273(TST.z13.300) X 0 USD
PR00108272(TST.z13.200) X 0 USD
PR00108271(TST.z13.100) X 0 USD
PR00108274(TST.z13.CLUB) X 0 USD
PR00108270(TST.z13.HOTEL) X 0 USD
PR00108279(TST.z13.TECH) X 0 USD
PR00108281(TST.z13.I10) X 0 USD
PR00108269(TST.z13) X 0 USD
PR00108280(TST.z13.IT) X 0 USD
Although I have sort the data records according to descending project hierarchy, but I have
found that the below code inside FM 'KBPP_EXTERN_UPDATE_CO' sort my it_bpak table by e_ges.
-
* sort: overall and positive be have to be processed first
describe table it_bpak lines l_lines.
+ if l_lines > 0.+
* positive values exits
+ sort it_bpak by e_ges descending.+
+ endif.+
-
Hence the it_bpak become:
E_OBJNR E_GES WERT TWAER
-
PR00108280(TST.z13.IT) X 0 USD
PR00108269(TST.z13) X 0 USD
PR00108281(TST.z13.I10) X 0 USD
PR00108279(TST.z13.TECH) X 0 USD
PR00108270(TST.z13.HOTEL) X 0 USD
PR00108274(TST.z13.CLUB) X 0 USD
PR00108271(TST.z13.100) X 0 USD
PR00108272(TST.z13.200) X 0 USD
PR00108273(TST.z13.300) X 0 USD
PR00108275(TST.z13.C10) X 0 USD
PR00108276(TST.z13.C20) X 0 USD
PR00108278(TST.z13.C30) X 0 USD
PR00108277(TST.z13.C21) X 0 USD
I get the below error message:
- TST.Z13.C20: 0.00 < 50,000.00 (USD)
Overall budget less than distributed budget
TST.Z13.C20 :
- TST.Z13.CLUB: 0.00 < 100,000.00 (USD)
Overall budget less than distributed budget
TST.Z13.CLUB :
- TST.Z13.HOTEL: 0.00 < 100,000.00 (USD)
Overall budget less than distributed budget
TST.Z13.HOTEL :
- TST.Z13: 0.00 < 200,000.00 (USD)
Overall budget less than distributed budget
TST.Z13 :
Is anybody who has successfully updated the Original Budget using this function module?
Any idea on how to fill in the it_bpak?
Thanks in advance.
Best Regards,
Fung