Add FI fields to KOB1

[former_member481263]

Hi,

I am trying to add fields augbl and augdt to report KOB1.

I followed the steps in detail in SAP note 325546, with the exception of adding any selection dependencies.

Problem: When KOB1 is executed, and there is data, the additional fields do not appear and when there is no data the fields appear (with no data)

Here is the code for the modification:

IF i_rep_object = 'OR'.
  SELECT SINGLE  augdt augbl FROM bseg
    INTO (cs_record-zzaugdt,cs_record-zzaugbl)
    WHERE bukrs = cs_record-bukrs
          AND belnr = cs_record-refbn
          AND gjahr  = cs_record-gjahr

          AND buzei  = '001'.
           
ENDIF.

Any assistance would be appreciated.

Thanks!

[iklovski · Accepted solution]

Hi,

Did you enhance field catalogue in view V_TKALV?

Also, check info in note 359691 - CO line item reports: Missing fields

Regards,

Eli

P.S. You should do it in EXIT_SAPLKAEP_001 (actuals). Is it the case?

[former_member481263 · Accepted solution]

Hi Eli,

Thanks for the quick response!

I'll give you my steps:

1. Added additional fields to structure CI_RKPOS; activated.

2. Modified EXIT_SAPLKAEP_001 with the code above.

3. Activated enhancement COOMEP01 in SMOD

4. Created (and activated) a Z{MyProjectName} in CMOD and assigned COOMEP01 enhancement to it.

5. Updated V_TKALV via sm34 and included the 2 additional fields in the field catalog for KAEP_COAC; K (for custom field).

Note that I did not create any selection dependencies in the last step. Am I supposed to do that as well and if yes, can you guide me?

This request really has me in a bit of a pickle....when I put a breakpoint in the exit, it goes through the enhancement code with values for cs_record.

Any further assistance is appreciated...

Thanks again Eli.

[iklovski · Accepted solution]

So, it comes through user-exit and fills cs_record, you just don't see it in the output, am I right?

And two new fields are present in the layout?

[former_member481263 · Accepted solution]

Yes, it fills cs_record with no output.

The layout situation is weird, when there is no data for an order, the fields appear in the layout. But when there is data, the fields are not shown in the layout.

I am thinking that it has to do with the fact that both augbl and augdt have no data for the internal orders that I am testing. But it's hard for me to know which internal orders have been cleared (paid) as I cannot find any clear link between the 2. Like I can get cleared documents but to see if those were related to an internal order payment I am not sure how I can tell; even trough bseg.

Thanks.

[iklovski · Accepted solution]

Try and execute BALVBUFDEL (via SE38); sometimes buffer has to be refreshed and it might solve the problem for layout.

However, for the algorithm itself, i have the following doubt. You are reading CO data on internal orders. Which means that the G/L account behind the record is defined as cost element (P&L account). But, clearing data (AUGBL, AUGBT) could correspond only to B/S accounts, on which you wouldn't have CO line in COEP table, from where the data is read. So, in all cases, reading BUZEI from COEP to access to BSEG would not be correct

[former_member481263 · Accepted solution]

Tried BALVBUFDEL with no luck....still the same problem.

What do you mean by B/S accounts? Removed the buzei condition and it still does not work.

Given that clearing data can only be accessed from those accounts, is there any other way to meet my requirement to have that data in KOB1?

Thanks again....

[iklovski · Accepted solution]

B/S - balance sheet account.

It depends what you are trying to achieve... As I said, having clearing date on the same line where you have internal order as CO object does not seem to be logical. Give an example of a FI document and we'll see what can be done. Also, I wonder why you focus on KOB1 (CO lines) and not on FI, where you also have information about internal order.

[former_member481263 · Accepted solution]

Cool, understood.

Yes perhaps I should have explained the user requirement. They want to see all vendors and vendor payments related to an internal order; including which items have been paid or not.

Initially I thought of FBL1N, but that could not work because you have to enter each vendor one at a time.

Then I thought of them using S_ALR_87013611 but then they would not see the payment data unless they drill down.

My last hope was KOB1; perhaps you can advise otherwise....

Thanks!

[iklovski · Accepted solution]

Hi,

From FBL1N you won't be able to trace internal order either. I can suggest using FBL3N after adding to this report counterpart account (vendor). This way you would be able to see I/O and vendor. The only drawback, that you wouldn't know if vendor is cleared or not. For this part, I'm afraid, you would need to develop ABAP report or try and fetch it to FBL3N via BTE 00001650: this is theoretically possible.

Regards,

Eli

[former_member481263 · Accepted solution]

Thanks Eli,

I did a previous BTE for 1650 recently, so I'll use that suggestion first to get cleared data.

If not, I'll develop the code....

Thanks again for your patience and assistance....

[former_member481263]

i modified the code a bit, but it's still not working:

*&  Include           ZXKAEPU01

*&---------------------------------------------------------------------*

IF i_rep_object = 'OR'.

   SELECT SINGLE  augdt augbl FROM bseg

     INTO (cs_record-zzaugdt,cs_record-zzaugbl)

     WHERE     bukrs = cs_record-refbk

           AND belnr = cs_record-refbn

           AND gjahr = cs_record-refgj

           AND buzei = cs_record-refbz.

ENDIF.