11-20-2012 12:44 PM
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
11-20-2012 1:38 PM
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
11-20-2012 1:38 PM
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
11-20-2012 2:49 PM
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)
11-20-2012 2:58 PM
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
11-20-2012 3:19 PM
But surely these fields have to be derived from somewhere?
How can I find out how the Function Modules get the fields?
Many Thanks
11-20-2012 6:37 PM
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
11-21-2012 9:10 AM
11-21-2012 1:08 PM
Connect to SAP and use SE37, give function name ITEM_DERIVE_FIELDS and press display ?
Regards,
Raymond
11-22-2012 5:40 AM
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.