Skip to Content

BW4HANA AMDP transformation forecast new records for FISCPER

Hi,

We have a requirement where in AMDP transformation in BW4HANA where we have to forecast 24 new records out of a single record based on fiscal period in internal table. In BW4HANA we dont have insert/update or creating of an temporary table working.Could anyone suggest how to insert new records for each Fiscal period. Any suggestion is highly appreciated.

Thanks,

Manisha

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Nov 06, 2019 at 08:54 PM

    Hi Manisha,

    The details of AMDP are explained in this blog,

    https://blogs.sap.com/2019/03/19/sap-hana-based-transformations-processing-transformations-in-hana-aka-abap-based-database-procedure-amdp/

    As you can see in the below code, i think you do not need to use insert to add the records into the outTab. I do not have the direct solution, but just wanted to mention the point about insert.

    outTab =
       select   "/BIC/ZFIELD1",
                ' ' "RECORDMODE",
                "/BIC/ZFIELD2",
                "/BIC/ZFIELD3",
                ' ' "/BIC/ZFLAGDEL",
                ' ' "RECORD",
                ' ' "SQL__PROCEDURE__SOURCE__RECORD"
    
                from :intab;
    
    
    Regards, Raja.
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 07, 2019 at 05:40 AM

    Hi Raja,

    Thanks for the reply. I have checked the blogs but our concern here is that we need to derive 24 new records in an internal table out each single records. We could't find anything related to that.

    Like in HANA here insert or update or creating temporary table worked in AMDP TRFN in BW4HANA.

    Regards,

    Manisha

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.