This SAP function executes a select statement on a standard SAP table assuming that the user has the necessary permissions.

This function is used as follows:

• Validate Currency against SAP.

  • Table: TCURC

  • Query for: WAERS

  • Requested fields: No data from the result is used. The query is executed only to check if a result exists

• Validate Company Code against SAP.

  • Table: T001

  • Query for: BUKRS

  • Requested fields: No data from the result is used. The query is executed only to check if a result exists.

• Read plant data from SAP.

  • Table: T001W

  • Query for: WERKS

  • Requested fields: LAND1, REGIO, TXJDC

• Retrieve the purchase order line conditions and their respective vendors for posting miscellaneous charges and handling third-party freight invoices.

  • Table: KONV

  • Query for: KNUMV

  • Requested fields: KPOSN, KSCHL, STUNR, ZAEHK, LIFNR, and KWERT

  and

  • Table: EKBZ

  • Query for: EBELN

  • Requested fields: EBELP, STUNR, ZAEHK, VGABE, SHKZG, MENGE, DMBTR, and WRBTR

• Converting quantities from SAP during line pairing (only if enabled in Settings > Invoice Processing > Capture Profiles > Line Pairing Settings).

  • Table: MARM

  • Query for: MATNR and MEINH

  • Requested fields: UMREZ and UMREN

• Converting WBS elements (only if enabled in Settings > Invoice Processing > Capture Profiles > SAP Configuration).

  • Table: PRPS

  • Query for: POSID

  • Requested fields: PSPNR

• Check for Downpayment (only if the "Park MM If Downpayment" setting is selected in Settings > Invoice Processing > Capture Profiles > SAP Configuration).

  • Table: PRPS

  • Query for: LIFNR, BUKRS, and SHBKZ

  • Requested fields: SALDV, SOLLL, HABNL, and GJAHR