Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

transfer from periodic application to YTD application

Hi,

Can anyone help me with the following:

A transfer of a budgetversion from the budgetapplication (periodic) to the finance (YTD) application

so it is for example:

from Budgetapp Category = BudgetV4

To finance app Category = Budget

Any help is welcome

Former Member
replied

Hi Benjanmin,

Below some example logic that does the trick.

*SELECT(%accountlist%, "[ID]", "ACCECOFYS","[link_to_consol_ic] <> 'Y'")

*xdim_memberset accecofys=%accountlist%
*xdim_memberset costcenter=<all>
*xdim_memberset datasrcS=<all>
*xdim_memberset PersEcofys=<all>
*xdim_memberset RGEcofys=<all>
*xdim_memberset groups=LC
*calculate_difference

*DESTINATION_APP =CONSOL
*SKIP_DIM = datasrcS
*SKIP_DIM = PersEcofys
*SKIP_DIM = RGEcofys

*RENAME_DIM AccEcofys = Account
*ADD_DIM Datasrc = dUpload
*ADD_DIM Intco = iNone
*ADD_DIM Finspec = sClosing

*when actbudfor 
*is "BUDGET"
    *WHEN accecofys.link_to_consol
    *IS <> ""
        *when time.monthnum
        *is "1"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(5))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(6))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(7))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(8))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(9))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(10))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(11))
        *is "2"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(5))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(6))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(7))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(8))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(9))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(10))
        *is "3"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(5))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(6))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(7))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(8))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(9))
        *is "4"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(5))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(6))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(7))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(8))
        *is "5"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(5))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(6))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(7))
        *is "6"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(5))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(6))
        *is "7"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(5))
        *is "8"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(4))
         *is "9"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(3))
        *is "10"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(2))
        *is "11"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
           *REC(AccEcofys=AccEcofys.Link_TO_Consol,time=next(1))
        *is "12"
           *REC(AccEcofys=AccEcofys.Link_TO_Consol)
        *endwhen
    *endwhen
*endwhen

*COMMIT

hope this helps,

Alwin

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question