Internal Order entries in FAGLL03

[Former Member]

Hello Sapians,

There is an Capital Internal Order created and there are some postings against that Order. The Plant, Cost Center and Profit Center are maintained in the Internal Order Assignment Tab.

Now the issue is user wants to see the Plant and Cost center in the Credit Item of the Internal Order. I understand that we will not be able to see the Cost Center in the Capital Internal Order because the costs are incurred in the Order and settle to AUC at the time of settlement. But I am not sure why I am not able to see the plant in the credit accounting entry (Posting key 50).

The main aim is to be able to see the Plant in the Fagll03 of this GL Account. Is this something to do with New GL? or do I need to do derive the plant to the Accounting view?

Thank you,

-Harter.

[ajaycwa1981]

Hi Harter

Plant is not derived in FI line items many times... It usually flows from the MM/SD postings, that too in some cases...

If you want it, you can use FI substitution exit RGGBS000 and write small ABAP code...

I used BTE 1120 to do the same... however, it can be achieved by RGGBS000 and I would prefer this over BTE

Moreover, you can get Plant in FBL3N reports, not in FAGLL03.. because, Plant field is not available in FAGLFLEXA

If you want you can add it into these tables from the T code FAGL_GINS... Enter the TOTALS table as FAGLFLEXT > Click on the Pencil icon > Then Press F4 in next screen > Choose Additional Fields and Choose ZWERKS

Br, Ajay M

[Former Member]

Hi Ajay,

Thank you for the reply. I will look into the details and get back to you on the steps mentioned above.

Between I saw Satistical Internal Order has the Plant populated in the FI entries. How do I track back to the SD/MM postings in that case?

Another thing is this particular statiscal Internal Order example doesn't have New GL implemented. Is that the reason why I am able to see the Plant in the statistical IO? Confused a bit on this difference between the set up of New GL and Old GL.

Thank you,

-Harter.

[ajaycwa1981]

Hi

In the case of Stat Int Order, the objects that you specify in the Order master like cost center are also posted in the FI line item.. They are designed that way..

Moreover, if New GL is not implemented then FAGLL03 report wont work for you.... New GL has no role to play in the population or otherwise of the Plant...

Check the exit I mentioned.. it would serve your purpose..

Br, Ajay M

[Former Member]

Hi Ajay,

Flaglflext is a Totals table (Summary Table). if you add the field (zwreks) in FLAGLFLEXT how does that update the field in FLAGFLEXA (Line item table)? Usually it should be the otherway round, right?

Also, do I need to update the FLAGLFLEXT with ZWERKS and then use the mentioned FI substitution Exit? What would be the logic that I have to write to bring the Plant field with this Program? Could you please explain in detail.

Thank you,

-Harter.

[ajaycwa1981]

Hi

If you add the field to FAGLFLEXT, I guess it would also be added to FLEXA table.. Both are inter linked...

If New GL is active, then only data updates into these tables..

You need to code the exit RGGBS000 to update the BSEG table with the PLANT... This would also pass the same into FLEXA table...

In this exit, call the Internal Order Master table AUF* and read the Plant from this table... Populate the same in the field BSEG - WERKS... (The table for IO would start with AUF.. You can search for the relevant table.. I guess it would be AUFK)

br, Ajay M

[Former Member]

Hi Ajay,

I started working with Developer on this issue. This subsitution exit has to be used in FI, right?

It might be dumb question but what is the use of updating this field (ZWERKS) in FLAGLFLEXT and FLEXA tables, in order to populate the field in any other reports? What is the exact use of updating in Totals Table?

Thank you,

-Harter.

[ajaycwa1981]

Hi

Yes. This subst needs to be used in FI

When you update the field ZWERKS in FAGL* tables, the Field PLANT gets populated in them.. It can then be used in the reports

br, Ajay M

[Former Member]

Hi Ajay,

I am working with the Developer and here is the small code that we developed.

TABLES: aufk.

• Populate BSEG with plant from AUFK table (Order master data)

SELECT werks

FROM aufk

INTO aufk-werks

WHERE aufnr = bseg-aufnr.

bseg-werks = aufk-werks.

ENDSELECT.

Basically we decided to populate the values on both the accounting entries, but the no luck. We did a test (settled a new Internal Order and generated accouting entries) but did not populate any values in the Plant field.

1. I am using the same FI substitution exit that you mentioned, are we missing anything in the Code?

2. Do I need update the FAGL_GINS T-code also?

Sorry for the late update. Thanks for your help.

-Harter.

[ajaycwa1981]

Hi

Plant field must be added to FAGL_GINS also... Then it gets populated in FLEXA table

Also, as to why the code is not working, its better to put a break point in the code and debug the issue with your ABAPer

br, Ajay M

[Former Member]

Hi Ajay,

I tried adding and activting the plant field in the FAGL_GINS. I activated the FAGL_GINS after I added, I got dump with "DDIC_TYPE_INCONSISTENCY". Also I tried deleting the plant field and it is not letting me to do that.

"Inconsistency in the Dictionary for the structure "FAGLFLEXT""

Did I miss anything?

Thank you,

-Harter.

Edited by: Harter21 on Apr 27, 2011 5:17 PM

[ajaycwa1981]

Hi

Check with your ABAP or BASIS guy.. Even i got this error. They resolved it

br, Ajay M

[Former Member]

Hi Ajay,

Thank you, could you please give me clue what exactly ABAPER or Basis guy has to change?

Do they need to change any structure or run any program or enhance the hot pack?

It would be helpful if you give me in detaila as I need to drive them.

Thank you,

-Harter

[ajaycwa1981]

Hi

I have no idea what they did... I thought it must be their usual skills to handle such errors

br, Ajay M

[Former Member]

Hi Ajay,

I checked with Basis and ABAP, they investigated and said it is out of their scope.I did some research and found couple of reasons which might be causing DDIC inconsistency error.

I have to delete the ZZWERKS field in FAGL_GINS (I took help from ABAPer as I was not able to delete it by myself) as it is giving me dump while creating the Invoice in FB60 (FLAGLFLEXA is not activated).

1. It looks like, I need to add the field WERKS in the OXK13 as expert mode (please see the OSS note 43930) before I add in the FAGL_GINS

But I got confused that this OSS note explains some seven steps to create the field. The question do I have to go through all the 7 steps to create one new field?

2. But the other OSS notes (923687) is released by SAP not to create the ZZfields for Catrgory 2.

I am completly lost at this point and need someone to assist.

Thank you very much for your help.

-Harter.

[ajaycwa1981]

Hi

I guess the Note 923687 says about Customer Fields but wrongly gives ZZMATNR as an example for Category 3....

I really dont know how to resolve the DDIC error because the ABAP consultant did it for me...

Can you raise an OSS msg mentioning the Note 923687 and check with SAP if they really mean that ZZWERKS should not be used??

I myself added ZZAUFNR field and it worked....

br, Ajay M

[Former Member]

Hi Ajay,

I have an interesting question for you. Finally Developer was able to find some OSS note relating to Subsitutions (OSS notes 84231 and 4261) and did the following steps

Now the Plant field appears in the Accounting document (Capital Internal Order Accounting entries) and also in the FAGLL03. Please note that I have not added ZZWERKS in the Coding Block or in the FAGL_GINS (earlier I had it in FAGL_GINS and I deleted the field)

Now,

1. If I do not update the coding block (T-code: OXK3) and FAGLFLEXA table (FAGL_GINS T-code), what are the reports (do you any standard reports) that get affected?

2. If you know any of the Standard reports that gets affected, could you please name them?

3. Plant is already a field in BSEG, not all the fields in BSEG are the fields in FAGLFLEXT and FAGLFLEXA. So what happens if I just leave with out updating the Coding block and FAGL_GINS t-code (because I am getting the plant field in BSEG and FAGLL03 and those are the two things that I want)?

Thank you very much for your time,

-Harter

[ajaycwa1981]

Hi

If you are getting the WERKS in FAGLL03 and the report serves your purpose, then it is fine

However, in future, say if you wanna plan in GP12N based on Plant (new GL Planning).. Then the field might not be available to you... Please check on these aspects... Try to create a new GL planning layout and see if Plant field is available there in

br, Ajay M

[Former Member]

Hi Ajay,

I was going though your messages and found that you had added ZZAUFNR field in FAGLFLEXT table. I need your help regarding the same.

I have inserted the field in FAGLFLEXT through tcode- FAGL_GINS and activated it successfully.

But the data is not getting populated into this field.

Pls suggest any further step to populate the old data & new data into this field.

Thanks in advance for your help.

Thanks

Rajan

[ajaycwa1981]

Hi

Old data cant be populated as far as I know..

For the new data, I guess you need to add field ZZAUFNR to your Leading Ledger 0L in "Assign scenarios and Customer fields to ledgers"

Choose 0L and then Custom Fields.. Here you need to add ZZAUFNR, i guess... I did it long back, so dont recollect now fully

br, Ajay M

[sangharsh_navada]

Hi Ajay,

I followed your suggestions and everything worked great for me. Thanks for your valuable information.

After adding a customized field - ZZAUFNR-Order No. to FAGLFLEXT table, I am unable to find the Order No Data in Tcode: FAGLL03 (G/L line items Report) for the old line items (i.e. The Order No.s are displaying only for the newly created line items post changes to the FAGLFLEXT table). But Tcode: FBL3N is displaying Order No data for all the line items. I have also noticed that, if I remove the ZZAUFNR assignment to 0L-Leading Ledger, then FAGLL03 is displaying the Order No. details for all the line items.

Is there anything which I have missed out in this configuration?

Your inputs will help me to drive this.

Thanks in advance.

Regards,

Sangharsh Navada