1. Localizations for European Reporting and SEPA Processing Implementation Guide
  2. Understanding Data Extraction

Understanding Data Extraction

You run the Data Extractions for ESL program to populate the Data extraction ESL table (F740018D) that the system reads when you generate the final EU sales list report. The program obtains the data for the F740018D table from these tables:

  • F0018 (Taxes)

  • F0101 (Address Book Master)

  • F0116 (Address By Date)

  • F03B11 (Customer Ledger)

  • F4201 (Sales Order Header File)

  • F4211 (Sales Order Detail File)

The Data Extractions for ESL program writes data to these tables:

  • Data Extraction ESL (F740018D)

  • Original Transaction Detail for Data Extraction (F740018O)

    If the data that the program extracts includes credit memos or other adjustments to sales transactions, the system extracts and stores information about the original sales transaction in the F740018O table.

    See Credit Memos and Adjustments

The Data Extractions for ESL program selects records with a document type of RI (invoice) and RM (credit memo) from the F0018 table, then accesses the address book, accounts receivable, and sales order management tables to obtain the additional information needed for the EU sales list report. You can modify the data selection to select records with different document types.

The Data Extractions for ESL program generates a report that states that the data extraction was generated, and includes error messages for any errors that occurred. The report does not list the details of the extracted data.