XITSAP1 - Export SAP Customer Table to Excel

Business users has different concerns with programmer. Hence XITSAP1 is modified a little bit to be more appealing to business users.

XITSAP1 - Customer

This version of XITSAP1 is dedicated to extract Customer table and displays only a few of selected fields.

Download

Get XITSAP1_v01r_GET_CUSTOMER.xls

Modification

To customize the extraction, on sheet TABLEDEF user can change the "Include Y/N" column. Set it to "Y" if you want to export the field, and then click "Refresh Definition" button. The fields will be refreshed.

Condition and Filter

On this XITSAP1 version, user can define export condition. There are three additional rows on top of result table: Operator, Filter, and Comparison. 

1. Operator can be 'AND' or 'OR'

2. Filter is the value of the field

3. Comparison the the comparison operator, for example 'EQ' for equal, 'GE' for greater than and equal, 'LIKE', etc.

Note the wildcards for LIKE comparison is '%' (not '*' asterisk).