on 10-10-2008 12:43 PM
Hi All
I am trying to upload GL accounts from an external .txt file containing 16 fields through LSMW. I have created recording using Tcode Fs00 and also I find that the field mappings etc are correct. I have followed all steps sequentially in LSMW but While ececuting the project error related to Account group and also maintanance of screen fields is cropping up.
After recording the fields are shown in six screens and also the fields account group appers in three screens, PL account(Xplacct) and Balance sheet A/C (Xbilk) are showing up in two screens.
Can some one help me guiding gl upload through LSMW.
Ramki
resolved
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Good idea would be for GL master data upload using program RFBISA00 with LSMW.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Amit
I am trying both the scenarios proposed by you and VVR
with rsbisa00 i am getting following error
Trans.1: transaction fs00 not supported (I assigned FS00 t0 Tcode.
bsk00-stype 5
bsk00-tcode fs00
bsk00-saknr 10100000
bsk00-bukrs ABCL
bsk00--ref_saknr /
bsk00-ref_bukrs /
.......editing was terminated
can you tell me where is the mistake ??
Regards
Ramki
Hi Rama Krishna,
I am Getting Same error.. Can you please let me know how you resolved abobe query.
Trans.1: transaction fs00 not supported (I assigned FS00 t0 Tcode.
bsk00-stype 5
bsk00-tcode fs00
bsk00-saknr 10100000
bsk00-bukrs ABCL
bsk00--ref_saknr /
bsk00-ref_bukrs /
.......editing was terminated
Thanks in Advance
Hi
Upload in the following procedure:
1) Upload only COA - B/S : FSP0
2) Upload only COA - P&L : FSP0
3) Upload CC - for all CC' / seperately for each CC : FSS0
AND
In case of the account group, use the Short field and not the description (like FXAT - Fixed Asset , take FXAT and not the Fixed Asset)
VVR
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
After recording you can see the coding given by the system as below:
FSP0 G/L acct master record in chrt/accts
SAPLGL_ACCOUNT_MASTER_MAINTAIN 2001
BDC_CURSOR GLACCOUNT_SCREEN_KEY-SAKNR
BDC_OKCODE =ACC_CRE
GLACCOUNT_SCREEN_KEY-SAKNR S001100199 SAKNR G/L account number
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
GLACCOUNT_SCREEN_KEY-KTOPL CAGM KTOPL Chart of accounts
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
SAPLGL_ACCOUNT_MASTER_MAINTAIN 2001
BDC_OKCODE =2102_GROUP
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_CURSOR GLACCOUNT_SCREEN_COA-KTOKS
GLACCOUNT_SCREEN_COA-KTOKS GL KTOKS G/L account group
GLACCOUNT_SCREEN_COA-XPLACCT X XPLACCT P&L statement account
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
SAPLGL_ACCOUNT_MASTER_MAINTAIN 2001
BDC_OKCODE =SAVE
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
GLACCOUNT_SCREEN_COA-KTOKS GL KTOKS G/L account group
GLACCOUNT_SCREEN_COA-XPLACCT X XPLACCT P&L statement account
GLACCOUNT_SCREEN_COA-GVTYP Y GVTYP P&L statement account type
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_CURSOR GLACCOUNT_SCREEN_COA-TXT50_ML
GLACCOUNT_SCREEN_COA-TXT20_ML Salaries - DELP TXT20_ML G/L account short text
GLACCOUNT_SCREEN_COA-TXT50_ML Salary for DELPHI TXT50_ML G/L account long text
BDC_SUBSCR SAPLGL_ACCOUNT_MASTE
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
BDC_SUBSCR SAPLATAB
**********************************************************************************************************************************************************
Source field mapping:
SAKNR C(010) G/L account no.
KTOPL C(004) Chart of accounts
KTOKS C(004) Account group
XPLACCT C(001) P&L statement acct
GVTYP C(002) P&L statmt acct type
TXT20_ML C(020) TXT20_ML
TXT50_ML C(050) TXT50_ML
************************************************************************************************************************************************************
VVR
Hi VVR
I recorded the coa entries using tcode fsp0. Thgere is a slight difference between the output you have shown and what i am getting here.
1. The first line of the screen (Cursor) is missing and it starts from OK code.
2.Where from the field GVTYP is being picked up (GL ACCT TYPE). I don't see any such field in the screen.
Regards
Ramki
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.