Info on downloadig transactional dta of GL account

[Former Member]

hi all,

We have a req of downloading GL a/c transactional data .Can anyone please provide any reports being used for the same.

Thanks in anticipation.

Regards,

Rajashree

[Former Member]

check FBL3N tcode.

Regards

Prabhu

[Former Member]

Hi Prabhu,

Thnak you for the reply it really helped us,the problem we are facing now is for upload currently we are using report 'RFBISA00' for downloading the g/l accounts but since it is for master we are unable to use it for uploading the data downloaded to another system.

Any inputs for uploading data(transactional data ) is highly appreciable.

Regards,

Rajashree.

[raymond_giuseppi]

Try these transactions :

FBL3N - Display/Change Line Items

or

For Line items : S_ALR_87012282 - G/L Line Items, List for Printing

For Statement : S_ALR_87012332 - G/L Account Statements,

For Journal : S_ALR_87012287 - Document Journal, S_ALR_87012291 - Line Item Journal

For your own reports look at tables BSIS, BSAS (Accounting: Secondary Index for G/L Accounts)

Regards

[Former Member]

hi all,

Sorry for the earlier post.Actual req is we need all details of a posting.

Any pointers is highly appreciated.

Regards,

Rajashree

[Former Member]

All the details of the Posting -

---

>

Raj ,

as u know Accouting Document Consists of Debit /Credit entries , that may be Customer/vendor/G/L data, in that case u have to get complete data.So U can get complete data from table BSEG .

process will be like this.

first u have to get open/closed Items of the G/Ls from BSIS, BSAS.

after that u can get complete data from BSEG table

BSEG-BELNR = BSAS/BSIS-BELNR and year also u have to check.

coming to IMP pont , accessing BSEG table may lead/give poor performace keep in mind.

Regards

Prabhu

[Former Member]

Hi Prabhu,

Any pointers for porgrams or tcode used for downloading and uploadig all details....

Rgds,

Rajahsree