[58600] in SAPr3-news
Using BAPI to extract data from SAP
daemon@ATHENA.MIT.EDU (petru_acsinte@ca.ibm.com)
Thu Dec 14 14:54:27 2006
To: sapr3-news@mit.edu
Date: 14 Dec 2006 19:54:15 GMT
From: petru_acsinte@ca.ibm.com
Message-ID: <4udof6F17emstU1@mid.individual.net>
Hello,
I am trying to extract some document items from the G/L account in
order to identify some expenses. I am using the DataStage pack for SAP
which
calls exposed BAPI methods. I identified the GeneralLedger component which
might give me what I need through the GetDocumentItems method
(BAPI_GLX_GETDOCITEMS).
I am using G_GET_LEDGERS_FOR_COMPANY_CODE function module to
identify
the ledgers for a specific company code. However, most of them fail with
the
message that they don't have the GLFLEXT summary table.
While browsing through the ledgers list in the SAP GUI, I saw that
there are some with the table V_GLFLEXT associated.
However, some of these return no line items and some return:
"Trans.currency not displ. for group valuation or PC valuation of
ledgers"
Does any one know of another way to extract financial data out of
SAP?
I am looking for expenses (budget also) and I thought G/L is a good place
to
start with. But the only exposed BAPI method which can be called from
outside does not work for me.
Can anyone help me?
Much appreciated,
Peter
