BW4HANA AMDP transformation forecast new records for FISCPER

[former_member346622]

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

[former_member346622]

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

[former_member199573]

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-a...

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.