topic Re: Structure RFPOSXEXT in Application Development and Automation Discussions

Structure RFPOSXEXT

Former Member — Tue, 20 Nov 2012 12:44:03 GMT

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

Re: Structure RFPOSXEXT

ThomasZloch — Tue, 20 Nov 2012 13:38:47 GMT

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

Re: Structure RFPOSXEXT

Former Member — Tue, 20 Nov 2012 14:49:55 GMT

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)

Re: Structure RFPOSXEXT

RaymondGiuseppi — Tue, 20 Nov 2012 14:58:31 GMT

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

Re: Structure RFPOSXEXT

Former Member — Tue, 20 Nov 2012 15:19:51 GMT

But surely these fields have to be derived from somewhere?

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

Many Thanks

Re: Structure RFPOSXEXT

RaymondGiuseppi — Tue, 20 Nov 2012 18:37:58 GMT

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

Re: Structure RFPOSXEXT

Former Member — Wed, 21 Nov 2012 09:10:53 GMT

My apologies, but how can I view the code?

Thanks

Re: Structure RFPOSXEXT

RaymondGiuseppi — Wed, 21 Nov 2012 13:08:51 GMT

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

Regards,

Raymond

Re: Structure RFPOSXEXT

Former Member — Thu, 22 Nov 2012 05:40:57 GMT

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.