Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

ONESOURCE table configuration for SAP

List of Bases

Bases represent a source or target in the field mapping of a tax request and response. They either represent an entity in SAP or a Determination XML structure such as Batch, Invoice, Line, or Tax. Some complex XML structures like User Attributes, Quantities, Registrations, Currency Conversions, etc. require special processing described at the end of this section. Not all of the sources are available for all Journeys.
Source Bases
Base
Description
Journey supported
SAP_HEADER
Fields from the following SAP document header tables:
BKPF, EKKO,ESSR, KNA1, LFA1, T001, T001Z, T180, TVAK, TVAP, TVFK, TVKO, TVTA, VBAK, VBKD, VBUK, VBRK, KOMK, CALC_HDR*,J_1BBRANCH, J_1IMOVEND, J_1IMOCUST, J_1IMOCOMP, MKPF, MSEG, T156, DM07M, VM07M
/IDT/JOURNEY_HEADER_REQUEST
/IDT/JOURNEY_HEADER_REQ_BR_GM
/IDT/JOURNEY_FB05_COMPANY_ROLE
BKPF (FI/LIV)
VBRK (SD)
T001 for both processes
/IDT/JOURNEY_AUDIT_UPD_DB_GL
/IDT/JOURNEY_AUDIT_UPD_DB_BILL
/IDT/JOURNEY_AUDIT_UPD_DB_SETL
MKPF, BKPF, KOMK, KOMP, MSEG, EKKO, LFA1, CALC_HDR
/IDT/JOURNEY_HEADER_REQ_BR_GM
SAP_ITEM
Fields from the following SAP document
item
 tables:
BSEG, CSKS, DRSEG, EINA, EINE, EKKNU, EKPO, KOMP, KOMV_INDEX, MAKT, MARA, MARC, MARD, MBEW, MT06E, MVKE, PRICE_COND, T001W, T001Z ,TVAP, VBAP, VBAPF, VBRP, VBUP, CALC_ITEM*,J_1BBRANCH, J_1IMOVEND, J_1IMOCUST, J_1IMOCOMP, MKPF, MSEG, T156, DM07M, VM07M
Header fields
:
Any field listed in the SAP_HEADER section above, use prefix HDR-> when mapping a header table at line level
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
/IDT/JOURNEY_ITEM_REQ_BR_GM
/IDT/JOURNEY_NG_ITEM_DOWN_PAYM
/IDT/JOURNEY_NG_ITEM_FB05
/IDT/JOURNEY_NG_ITEM_SERV_ENTR
BSEG (FI/LIV)
VBRP (SD)
WBRP (SD, MM)
/IDT/JOURNEY_AUDIT_UPD_DB_GL
/IDT/JOURNEY_AUDIT_UPD_DB_BILL
/IDT/JOURNEY_AUDIT_UPD_DB_SETL
MKPF, MSEG, EKPO, KOMP, LFA1, MBEW, J_1BBRANCH, LIKP
/IDT/JOURNEY_ITEM_REQ_BR_GM
SAP_FIELD
SYST
GC_XS_FALSE – translates an SAP check box value to a XSD true/false value
GC_VERSION – represents the XSD
All
DET_TAX
All fields in the Tax level of the Determination response (OUTDATA) message
/IDT/JOURNEY_STANDARD_RESPONSE
/IDT/JOURNEY_TAX_TAB_RESPONSE
CONSTANT
Any constant value
All
Target Bases
Base
Description
Journey supported
DET_BATCH
All fields in Batch level of Determination request (INDATA) message
/IDT/JOURNEY_HEADER_REQUEST
/IDT/JOURNEY_FB05_COMPANY_ROLE
/IDT/JOURNEY_HEADER_REQ_BR_GM
DET_INVOICE
All fields in Invoice level of Determination request (INDATA) message
/IDT/JOURNEY_HEADER_REQUEST
/IDT/JOURNEY_FB05_COMPANY_ROLE
/IDT/JOURNEY_HEADER_REQ_BR_GM
/IDT/JOURNEY_AUDIT_UPD_DB_BILL
/IDT/JOURNEY_AUDIT_UPD_DB_GL
DET_LINE
All fields in the Item level of the Determination request (INDATA) message
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
/IDT/JOURNEY_ITEM_REQ_BR_GM
/IDT/JOURNEY_NG_ITEM_DOW N_PAYM
/IDT/JOURNEY_NG_ITEM_FB05
/IDT/JOURNEY_NG_ITEM_SERV_ENTR
SAP_TAX_LINE
All fields in table /IDT/D_TAX_DATA, including custom appended fields
/IDT/JOURNEY_TAX_TAB_RESPONSE
/IDT/JOURNEY_FB05_RESPONSE
All fields of the SAP pricing lines as defined in structure KOMV_INDEX
NOTE: used for backwards compatibility only
/IDT/JOURNEY_STANDARD_RESPONSE
Special Purpose Operands
Operand
Description
Journey supported
CALC_HDR
ROLE, EXTERNAL_COMPANY_ID, UNIQUE_INVOICE_NUMBER, TAX_CATEGORY
/IDT/JOURNEY_HEADER_REQUEST
CALC_ITEM
DET_TAX_CODE, IS_EXEMPT, AMOUNT, QUANTITY, IS_CREDIT
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
PARTNER_TAB
Used to reference a partner address in field mappings. Can be used in combination with partner function type.
/IDT/JOURNEY_HEADER_REQUEST
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
HDR->
Pointer use in Item level request mapping to indicate that the field used is at header level, i.e. HDR->T001W-WERKS would indicate the plant from the header table to be mapped at the item level.
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
/IDT/JOURNEY_FB05_RESPONSE
ANCESTOR->
Pointer used in response mapping to indicate that the field used is at a higher level in the structure, i.e. ANCESTOR->ANCESTOR->CALLING_SYSTEM_NUMBER would be used to map from Invoice level field in the tax data level.
NOTE: At this time we don’t support mapping from the BATCH level of the Determination XML, all fields are available on the INVOICE level too.
/IDT/JOURNEY_TAX_TAB_RESPONSE
/IDT/JOURNEY_STANDARD_RESPONSE
/IDT/JOURNEY_FB05_RESPONSE
ITEMS->
Pointer used to determine at the header level a field that is stored at the line-item level in order to pass that to the request.
/IDT/JOURNEY_HEADER_REQUEST
XSD Tables
Table
Description
Journey supported
USER_ELEMENT
A custom field in the XSD comprised of the XML element USER_ELEMENT and field ATTRIBUTE#, where # is any number between 1-40 at Invoice or Item level.
NOTE: Attributes 41-50 are reserved by Thomson Reuters.
/IDT/JOURNEY_HEADER_REQUEST
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
/IDT/JOURNEY_STANDARD_RESPONSE
/IDT/JOURNEY_TAX_TAB_RESPONSE
REGISTRATIONS
A structure of registration numbers for different roles; SELLER_ROLE, BUYER_ROLE, MIDDLEMAN_ROLE.
/IDT/JOURNEY_HEADER_REQUEST
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
QUANTITIES
A complex structure to represent a list of quantities and unit of measures.
/IDT/JOURNEY_ITEM_REQUEST
/IDT/JOURNEY_NG_ITEM_REQUEST
CURRENCY_CONVERSION
Represents a result set of one or two currency conversion steps in the TAX block of the tax response.
/IDT/JOURNEY_STANDARD_RESPONSE
/IDT/JOURNEY_TAX_TAB_RESPONSE
Special Purpose Operands in Tables
Operand
Description
NAME
A field value within a table like NAME=ATTRIBUTE1
ROW
A field value to point to a specific place in a table i.e. ROW=3 would point to the third row
ADD
An action, i.e. to add a row to the table
CREATE_IF_NOT_EXIST
A control flag to only add the mapping if none already exists

This article applies to:

  • Product: ONESOURCE Indirect Tax
  • Sub Product: SAP