Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Appropriate Datasource or the extractor for the respective fields

Hi All,

We need to do KPI reporting for accounts payable data.The report layout includes invoice header data and invoice lineitem data.Could somebody help me in finding the datasource to accomplish the same.I have checked the datasource 0FI_AP_04 and 0FI_GL_04.The report layout includes the following fields:

invoice header data:

location ID

vendor #

invoice #

invoice date

operator ID (who entered the invoice)

invoice entry date

days to enter (entry date - invoice date)

days to process (balanced date - entry date)

invoice due date

total invoice amount

invoice freight amount

invoice tax amount

cash discount available

invoice entry batch number

invoice balanced date

PO # reference

date posted to ledger

payment date

paid amount

cash discount taken

payment method

payment terms code

forecast payment days

actual payment days

actual - forecast days

cash discount lost

invoice line data:

location ID

vendor #

invoice #

invoice date

PO # reference

GL company #

GL account #

GL cost center #

invoice line amount



Former Member
Not what you were looking for? View more on this topic or Ask a question