cancel
Showing results for 
Search instead for 
Did you mean: 

lsmw for Master GL Accounts

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

resolved

former_member181995
Active Contributor
0 Kudos

Good idea would be for GL master data upload using program RFBISA00 with LSMW.

Former Member
0 Kudos

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

0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

hi vvr

You mean different recordings for each of these fields. I am using short code only for account group

thanks

Ramki

Former Member
0 Kudos

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

Former Member
0 Kudos

Ramu

Yes, Seperate recording for B/S and P&L at COA Level.

AND

You can do only one recording at CC Level.

I gave the P&L account upload in my previous reply....and also the coding....after source field....while mapping you can do the auto field mapping...system takes care about the mapping.

VVR

Former Member
0 Kudos

Hi VVR

thank you for your inputs. Let me try per your advise. Points are sure but let me redo the things. I spent nearly 20 hrs on this issue and will come back once I finish the task

Regards

Ramki

Former Member
0 Kudos

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