Reconciliation extract program references
Reconciliation Extract Mapped from SAP
Below table shows the mapping from SAP to ONESOURCE Indirect Tax Reconciliation Extract Output.
Output field name | SAP field name | Table-fieldname |
|---|---|---|
External Company ID | SAP company code | BKPF-BUKRS |
Host System | SAP system name (e.g. CO3) | SY-SYSID |
Calling System | SAP client number | SY-MANDT |
Company Role | Buyer (B) / Seller (S) | |
ERP Transaction ID | Reference key of SAP Accounting document | BKPF-AWKEY |
Document Number | Accounting document number | FI: BKPF-BELNR LIV: RBKP-BELNR SD: VBRK-VBELN |
Document Type | Accounting document type | BKPF-BLART |
Document Description | Accounting document header text | BKPF-BKTXT |
Document partner number | Customer number (AR transactions) / | BSEG-KUNNR / BSEG-LIFNR |
Vendor number (AP transactions) | BSEG-KUNNR / | KNA1-NAME1 / LFA1- NAME1 |
ERP Period | Fiscal Period | BKPF-MONAT |
Document Date | Document date in format : DD-MON-YYYY, E.g. 12-Aug-2012 | BKPF-BLDAT |
Fiscal Date | Posting Date Date Format : DD-MON-YYYY | BKPF-BUDAT |
Gross Amount | Tax Base Amount in Local (Company code) Currency | BSET-HWBAS |
Tax Amount | Tax Amount in Local (Company code) Currency | BSET-HWSTE |
Document currency | Document currency key | BKPF-WAERS |
Optional UDF 1 | Custom field based on custom BAPI implementation | |
Optional UDF 2 | Custom field based on custom BAPI implementation | |
Optional UDF 3 | Custom field based on custom BAPI implementation | |
Optional UDF 4 | Custom field based on custom BAPI implementation | |
Optional UDF 5 | Custom field based on custom BAPI implementation |
Extract Selection Screen Field Definition
The table below shows in detail each of the selection screens available at runtime of the Reconciliation Extract:
Description | Field Name | Type | Optional / Required | Default value |
|---|---|---|---|---|
Company Code | BKPF-BUKRS | Parameter | R | |
Fiscal Year | BKPF-GJAHR | Parameter | R | |
Posting Date | BKPF-BUDAT | Select options | O | |
Posting Period | BKPF-MONAT | Select options | O | |
Tax Code | BSEG-MWSKZ | Select options | O | |
Select Zero/Exempt tax records | Check Box | O | X | |
Application / Local server path | Radio Buttons | O | Application server | |
Application Server | RLGRAP-FILENAME | Parameter | O | TVARV variable value |
Presentation Server | RLGRAP-FILENAME | Parameter | O | User parameter value |
Company Code Prepend | Parameter | O | ||
Package Size | Parameter | R | 10000 |
ONESOURCE Indirect Tax Transport Objects
This section lists the technical objects delivered with the Reconciliation Extract Report transport provided:
Object Name | Object Type | Description of Object |
|---|---|---|
/IDT/ | Name space | Container for all objects delivered by Thomson Reuters |
/IDT/RECON_EXTRACT | Package | Package containing all report development objects |
/IDT/RECEXT | Transaction code | Transaction code to run the Reconciliation extract report |
/IDT/RECON_EXTRACT | Report program | Main program |
/IDT/RECON_EXTRACT_TOP | Include | Include contains global types and data declaration |
/IDT/RECON_EXTRACT_SEL | Include | Selection screen is defined under this include |
/IDT/RECON_EXTRACT_FORM | Include | Include contains form routines |
/IDT/BADIRECON_EXTRACT | BADI definition | BADI definition to add logic for 5 user defined fields |
/IDT/EXTRACT_OUTPUT | Structure | Output file structure |
/IDT/INT_RECON_EXTRACT | Interface | BADI Interface |
/IDT/CL_RECON_EXTRACT | Class | Class implementing the BADI interface |
/ IDT/EXTRACT_UDF | Structure | BADI return data structure |
/ IDT/APP_SERVER_PATH | TVARV global variable | Variable in TVARV table to maintain Application server path |
/IDT/LCLFILEPATH | Parameter ID | User parameter to maintain default Presentation server path |
Enabling Custom Fields
The file format of the Reconciliation Report allows for five (5) user defined fields (UDF) as pass through elements. Companies wishing to use these fields can use custom code to set a value from SAP and extract it into one of the UDF’s. These values then will be imported into the Reporting reconciliation tables and show in the Reconciliation Report process.
A BADI
/IDT/BADIRECON_EXTRACT
has been provided as part of the SAP Reconciliation Report which can be implemented by the customers. The BADI method returns the 5 UDF’s in the structure /IST/EXTRACT_UDF.