Skip to Content
0

custom general ledger

Nov 10, 2016 at 06:16 AM

107

avatar image
Former Member

Dear All master,

could please tell me the initial table for general ledger ? i would like to make report custom of it include balance in it .

Thx b4 all.

Best regards,

Harry

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

avatar image
Former Member Nov 10, 2016 at 06:26 AM
0

Hi Harry,

There are a lot of tables relating to General Ledger. Prominent among them are GLT0, BSEG, BKPF, BSIS, BSAK, BSAD, etc. You can do a search in se16 with BS* to get the required tables. If you are on New GL, then the additional tables that you need to look into are FAGLFLEXA and FAGLFLEXT tables.

If you elaborate your requirement, then may be we can answer which tables would be relevant for you.

Regards

Vivek

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 10, 2016 at 08:40 AM
0

Hi Vivek Mohapatra,

I mean ,i would like to know and show for cumulative balance in Foreign currency. the format coloumn like following :

Posting date | due date | Trans | Details | debit | credit | balance |

that format will be appear base on filter of date and account.

Thx b4.

Share
10 |10000 characters needed characters left characters exceeded
AndakondaRamudu A Nov 10, 2016 at 09:22 AM
0

Hi please check bellow Query

SELECT T1.[AcctCode],T1.[AcctName],(sum(T0.[Debit])-sum(T0.[Credit])) "Cumulative Balances",T0.[Project] FROM JDT1 T0 INNER JOIN OACT T1 ON T0.Account = T1.AcctCode WHERE T1.[AcctCode] =[%0] AND T0.[refdate] >='20160901' AND T0.[refdate] <='20161031' GROUP BY T0.[Project],T1.[AcctName],T1.[AcctCode],T1.[AcctName]

--Ramudu

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi AndaKondaRamudu,

Thank lots for your respond.

--H2c

0
Gonzalo Gomez Nov 10, 2016 at 09:31 AM
0

the tables of the journal entries are: JDT1, OJDT

the tables of th accouns: OACT

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 11, 2016 at 12:22 AM
0

Dear All Master,

I'd ;like to get query to generate foreign balance like following picture :

.

thx


gl-example.png (17.6 kB)
Share
10 |10000 characters needed characters left characters exceeded
Gonzalo Gomez Nov 11, 2016 at 08:25 AM
0

all the fields and tables are:

JDT1-lines of journal entries

OJDT-heads of journal entries

OACT-accounts master data

Share
10 |10000 characters needed characters left characters exceeded