Structure RFPOSXEXT

[Former Member]

Hi,

Im using an external connector in an attmpt to pull a field from this report - BELNR (Accounting Document Number)

However the connector can only extract information from tables, as opposed to structures...

Where is this information gathered to create the report/structure?

Many Thanks

[ThomasZloch]

This structure is used in FI line item reports, so maybe table BSEG is your best bet. Beware of long runtimes, this table can be very huge.

Thomas

[Former Member]

Thanks for the help.

Im also trying to find this field - DMSHB (Amount in Local Currency with +/- Signs)

But cant seem to find it anywhere - its located on the in the same structure/report (RFPOSXEXT)

[RaymondGiuseppi]

Those data do not exist in database, they are built by FM like ITEM_DERIVE_FIELDS before call of FI_ITEMS_DISPLAY (FBLxN).

Regards,

Raymond

[Former Member]

But surely these fields have to be derived from somewhere?

How can I find out how the Function Modules get the fields?

Many Thanks

[RaymondGiuseppi]

Just read the code, it is easy to understand, most data come from BSEG, BKPF and also from T001 and Customizing.

e.g. DMSHB comes from BSEG-DMBTR depending on BSEG-SHKZG value (S/H, Soll-/Haben, Debit/Credit).

Regards,

Raymond

[Former Member]

My apologies, but how can I view the code?

Thanks

[RaymondGiuseppi]

Connect to SAP and use SE37, give function name ITEM_DERIVE_FIELDS and press display ?

Regards,

Raymond

[Former Member]

Hi Brian Murphy,

                        you can use this Structure RFPOS and if you want to BELNR u have to use BTE.

BTE name 00001650(LINE ITEM DISPLAY).

1- How to activate the BTE 00001650 via the transaction FIBF. 

The BTE means Business Transactions Events: they are user-exits are triggered in certain strategic point in the business flow.

The trx FIBF is trx to manage this kind of exit but what u need to do is assign the fm has to be called for a certain event/process.

The event  00001650 is a point of the code triggered before showing the accounting item, so u can insert your code here in order to show your own z-fields.

After running trx FIBF go to:

- Setting->P/S Function Modules->of an SAP appl. (or trx BF31):

this is a SM30 view where u assign the fm to be called for a certain event.

If you go to:

Enviroment->Info System P/S (or Trx BERE)

u can find a list of all BTE available and a little help

2- How i must proceed for do that? I understand that i will create, with SE37, a MF for example ZSAMPLE_INTERFACE_00001650 copy of SAMPLE_INTERFACE_00001650 and after that activate it through the transaction FIBF? That is?

For every event there's a sample function module, u need to copy it for creating a your own fm and assign it just as I wrote above.