2009 Mar 20 2:02 AM
Dear ABAP experts,
I have a excel file need to upload to the transaction FSP0. However, the field GLACCOUNT_SCREEN_KEY-SAKNR, GLACCOUNT_SCREEN_KEY-KTOPL, and the fields in tab windows u201CType/Descriptionu201D - GLACCOUNT_SCREEN_COA-KTOKS, GLACCOUNT_SCREEN_COA-XPLACCT, GLACCOUNT_SCREEN_COA-XBILK, GLACCOUNT_SCREEN_COA-TXT20_ML, GLACCOUNT_SCREEN_COA-TXT50_ML was successfully imported.
While, the field in the tab windows u201CKey word / transactionu201D - GLACCOUNT_SCREEN_COA-LANGU_TX, GLACCOUNT_SCREEN_COA-TXT20_TX, GLACCOUNT_SCREEN_COA-TXT50_TX is un-successful.
Can anyone please guide me how to do this in detail?
Thanks & Regards,
Jason
2009 Mar 21 4:57 AM
Hi,
could you let me what error mesage you are getting while uploading. As per my understanding first you can validate flat file data. and screen i m not sure unless you are not giving me the error message
Regds,
Rakesh
2009 Mar 23 1:30 AM
The excel file contain 10 attributes - G/L Account, Chart of Account, Account Group, P&L, B/S, GL Account Short Text, GL Account Long Text, Translation Language Key, Translation Short Text and Translation Long Text, Which will upload to the corresponding filed of transaction FSP0 -
GLACCOUNT_SCREEN_KEY-SAKNR, GLACCOUNT_SCREEN_KEY-KTOPL, GLACCOUNT_SCREEN_COA-KTOKS, GLACCOUNT_SCREEN_COA-XPLACCT, GLACCOUNT_SCREEN_COA-XBILK, GLACCOUNT_SCREEN_COA-TXT20_ML, GLACCOUNT_SCREEN_COA-TXT50_ML, GLACCOUNT_SCREEN_COA-LANGU_TX, GLACCOUNT_SCREEN_COA-TXT20_TX, GLACCOUNT_SCREEN_COA-TXT50_TX.
The first 7 attributes is uploads and appears on their fields. While the value of the field GLACCOUNT_SCREEN_COA-LANGU_TX was automatically set to "English", the value appears of GLACCOUNT_SCREEN_COA-TXT20_TX and GLACCOUNT_SCREEN_COA-TXT50_TX is same as the value of GLACCOUNT_SCREEN_COA-TXT20_ML and GLACCOUNT_SCREEN_COA-TXT50_ML respectively.
So, how can I upload my data to such fields or modify the value for these 3 fields? Please help me and guide me to do so!
Thanks & Regards,
Jason