Flat File Preparation in BPC

[former_member640745]

Hi Guys,

I am new to BPC.

I wanted to understand the process of Creation of a Flat File, what are the steps involved in it. Please find below the file that I need to create.

1.

/ERP/ENTITY, /ERP/GL_ACCT, /ERP/PENTITY, 0FISCPER, /ERP/RTC_AMO, /ERP/RTCCURR, /ERP/PROFTCTR, /ERP/FUNCAREA, /ERP/COSTCNTR, /ERP/CO_AREA, 0FISCVARNT, /ERP/CATEGORY, /ERP/RTCDIM, /ERP/CHRTACCT

Now after creating the above Flat File, I will have to extract the data from the above file to the below format to "Run Flexi Upload" in Fiori. I know how to create the file mentioned below. (GUI T-Code: RTCFU)

Requesting you guys to kindly assist me in creating the File, ie. from where to take the data i.e. which table and how to proceed.

Thanks in Advance.