cancel
Showing results for 
Search instead for 
Did you mean: 

Reg : New GL Line Items

Former Member
0 Kudos

Hi,

We are implementing new GL and I did find out some information on the new GL Vs Classical GL.

New GL :

Total table : FAGLFLEXT

Line Item table : FAGLFLEXA

Clasical GL :

Total Table : GLT0

Lie Item Table : BSEG

I have a question based on the above information.For new GL, SAP Has given 0FI_GL_10 datasource for getting Totals table ie FAGLFLEXT but no data source for line items.

But we have a datasource for Classical GL Line items ie 0FI_GL_4.My question is , having implemented new GL, can I use 0FI_GL_10 for getting the totals data and 0FI_GL_4 for line items ?

Will the line items data coming from 0FI_GL_4 be the same as the line item data in FAGLFLEXA ?

Instead of creating a generic datasource based on FAGLFLEXA,what if I use 0FI_GL_4 for line items ?

Will there be any issues in the future ? Anyone,went thru the above assumption.if so, Please explain the Pros & Cons ...

Regards,

Kumar

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You should ask your Finance Folks what table are they using for Line Items...if they are going with the latest/preferred which is FAGLFLEXA then you have to create a Generic Dataource.

Look at <a href="https://www.sdn.sap.com/irj/sdn/thread?threadID=426302&tstart=0">this</a> !!

Former Member
0 Kudos

Hi Roberto,

I spoke with functional folks in my project and i got the following information.

1.As per the talk, line item details are coming to both FAGLFLEXA and BSEG.

2.There are couple of fields like XREF1,XREF2,XREF3,ZUONR, ACTIVITY TYPE etc fields are populated only in BSEG not in FAGLFLEXA.They also say, BSEG has all the entries that are posted in FAGLFLEXA.

As per the discussion, functional folks prefer BSEG than FAGLFLEXA. I am assuming 0FI_GL_4 would pick up all the line item data from BSEG and I am not sure if there are any problems while reconciling with the totals table FAGLFLEXT to that of BSEG (using 0FI_GL_4) ?

Regards,

Kumar

Former Member
0 Kudos

You can goahead with 0FI_GL_4, we are on the same boat using 0FI_GL_10 & 0FI_GL_4.

We haven't done any reconciling so far so I cannot guess how things will turn out...hopefully it all works as expected.

Former Member
0 Kudos

take a look at another table BSEG_ADD to check if u r missing anything from BSEG. We enhanced our std 0FI_GL_4 to read BSEG_ADD for the new GL. we dont extract totals - so never reconcile the totals vs lines. But the users dont complain - so I assume the numbers shoudl be good.

Former Member
0 Kudos

Thanks Roberto & Voodi for your responses.

Coming to BSEG_ADD table, I think this gets filled only when we have document splitting implemented.As we do not have document splitting,We are not extracting any data from this table.

I verified BSEG_ADD and it doesn't have any records(entries) in it.So , I feel we do not need to get the data from the same.

Regards,

Kumar

Former Member
0 Kudos

Hi Roberto/Voodi,

I have another question,

We added like 6 more fileds to the new GL and the datasource 0FI_GL_10 will pick up those six fields automatically if i add them as append fields for the extract structure.

If I go ahead with 0FI_GL_4 for the line items and If I add those six fields as appeneded to the 0fi_gl_4 extract structure, will I get those six fields without writing the code ?

Regards,

Kumar

Former Member
0 Kudos

<i>We added like 6 more fileds to the new GL and the datasource 0FI_GL_10 will pick up those six fields automatically if i add them as append fields for the extract structure.</i>

6 fields from which table ?

Even if they reside in FAGFLEXT you have do some coding to append this fields to the datasource to my knwldge.

<i>

If I go ahead with 0FI_GL_4 for the line items and If I add those six fields as appeneded to the 0fi_gl_4 extract structure, will I get those six fields without writing the code ?</i>

Coding will be required.

Are you planning to add same 6 fields to both the datasources ?

What are they ? from which table ?

Former Member
0 Kudos

Hi Roberto,

We have already appended those six fields to extract structure FAGL_EXTSTRUCT_LEAD and I do not need to code to get the data for these six fields for the DS 0FI_GL_10.

As for as 0FI_GL_4 is concerned, I am just thinking the same without writing the code ? Am I correct ? if not, I think, I need to enhance the DS and get the data for those fields.

Regards,

Kumar

Former Member
0 Kudos

Hi Roberto,

I am sorry, I did not mention the tables you asked for,

Those six fields are coming from FAGLFLEXT for Totals reocrds and

BSEG for line items...

Regards,

Kumar

Former Member
0 Kudos

Hi Kumar,

Its better to create a generic datasource based on the view created on

FAGLFLEXT and FAGLFLEXA which suits the requirement for inplementing new GL. 0FI_GL_4 is to implement classic GL.I am not sure weather it helps to your requirement.

Regards

Karthik