Standard ERP Data Hub fields within remote tables
The standard ERP (Enterprise Resource Planning) remote tables available for use in ERP Data Hub contain fields from additional SAP tables.
The standard remote tables contain the following additional fields. For details on the standard tables, see Standard remote tables for ERP Data Hub.
| Remote table | Source table | ERP field name | Mapped field name |
|---|---|---|---|
| SAP Sales Document | VBAK | VBELN | document_number |
| SAP Sales Document | VBAK | ERDAT | date_of_document |
| SAP Sales Document | VBAK | ERZET | time_of_document |
| SAP Sales Document | VBAK | VKORG | sales_organization |
| SAP Sales Document | VBAK | VBTYP | document_category |
| SAP Sales Document | VBAK | AUART | document_type |
| SAP Sales Document | VBAK | AUGRU | order_reason |
| SAP Sales Document | VBAK | LIFSK | delivery_block |
| SAP Sales Document | VBAK | FAKSK | billing_block |
| SAP Sales Document | VBAK | KUNNR | customer_number |
| SAP Sales Document | VBAK | AUFNR | order_number |
| SAP Sales Document | VBAK | NETWR | document_value |
| SAP Sales Document | VBAK | WAERK | currency_code |
| SAP Sales Document | VBUK | LFGSK | delivery_status |
| SAP Sales Document | VBAP | MATNR | material_number |
| SAP Sales Document | VBAP | ARKTX | material_description |
| SAP Sales Document | VBAP | KWMENG | ordered_quantity |
| SAP Sales Document | VBAP | KLMENG | confirmed_quantity |
| SAP Sales Document | VBAP | NETWR | item_value |
| SAP Sales Document | VBAP | VRKME | sales_unit |
| SAP Sales Document | VBAP | ROUTE | delivery_route |
| SAP Sales Document | MARA | MTART | material_type |
| SAP Sales Document | VBUP | GBSTA | overall_item_status |
| SAP Sales Customer | KNA1 | KUNNR | customer_number |
| SAP Sales Customer | KNA1 | LAND1 | country_code |
| SAP Sales Customer | KNA1 | NAME1 | name |
| SAP Sales Customer | KNA1 | ORT01 | city |
| SAP Sales Customer | KNA1 | PSTLZ | postal_code |
| SAP Sales Customer | KNA1 | STRAS | street |
| SAP Sales Customer | KNA1 | STKZU | vat_liable |
| SAP Sales Customer | KNA1 | STCEG | vat_reg_number |
| SAP Sales Customer | KNVV | VKORG | sales_organization |
| SAP Sales Customer | KNVV | VTWEG | distribution_channel |
| SAP Sales Customer | KNVV | SPART | division |
| SAP Sales Customer | KNVV | INCO1 | inco_terms |
| SAP Customer Invoice | VBRK | VBELN | document_number |
| SAP Customer Invoice | VBRK | FKART | billing_type |
| SAP Customer Invoice | VBRK | WAERK | currency_code |
| SAP Customer Invoice | VBRK | ZTERM | payment_terms |
| SAP Customer Invoice | VBRK | NETWR | document_value |
| SAP Customer Invoice | VBRK | KUNRG | payer |
| SAP Customer Invoice | VBUK | GBSTK | overall_document_status |
| SAP Customer Invoice | VBRP | MATNR | material_number |
| SAP Customer Invoice | VBRP | ARKTX | material_description |
| SAP Customer Invoice | VBRP | NETWR | item_value |
| SAP Customer Invoice | VBRP | FKLMG | billing_quantity |
| SAP Customer Invoice | VBRP | VRKME | sales_unit |
| SAP Customer Invoice | VBRP | SHKZG | is_returns_item |
| SAP Customer Invoice | VBUP | GBSTA | overall_item_status |
| SAP Sales Organization | TVKO | VKORG | sales_organization |
| SAP Sales Organization | TVKO | EKORG | purchase_organization |
| SAP Sales Organization | TVKO | BUKRS | company_code |
| SAP Purchase Document | EKKO | EBELN | document_number |
| SAP Purchase Document | EKKO | BUKRS | company_code |
| SAP Purchase Document | EKKO | BSTYP | document_category |
| SAP Purchase Document | EKKO | LIFNR | vendor_number |
| SAP Purchase Document | EKKO | ZTERM | payment_terms |
| SAP Purchase Document | EKKO | EKORG | purchase_organization |
| SAP Purchase Document | EKKO | WAERS | currency_code |
| SAP Purchase Document | EKKO | IHREZ | ext_reference |
| SAP Purchase Document | EKKO | RESWK | supplying_plant |
| SAP Purchase Document | EKKO | BEDAT | date_of_document |
| SAP Purchase Document | EKPO | MATNR | material_number |
| SAP Purchase Document | EKPO | EMATN | supplier_material_number |
| SAP Purchase Document | EKPO | MENGE | ordered_quantity |
| SAP Purchase Document | EKPO | MEINS | order_unit |
| SAP Purchase Document | EKPO | NETPR | item_value |
| SAP Purchase Document | EKPO | MWSKZ | vat_applicable |
| SAP Purchase Document | EKPO | ELIKZ | fully_delivered |
| SAP Purchase Document | EKPO | REPOS | fully_invoiced |
| SAP Material Stock | MARA | MATNR | material_number |
| SAP Material Stock | MARA | MTART | material_type |
| SAP Material Stock | MARA | MATKL | material_class |
| SAP Material Stock | MARA | NTGEW | net_weight |
| SAP Material Stock | MARA | EANNR | ean_number |
| SAP Material Stock | MARA | EAN11 | ean11_number |
| SAP Material Stock | MARA | MSTAE | material_status |
| SAP Material Stock | MAKT | MAKTX | material_description |
| SAP Material Stock | MARD | WERKS | plant |
| SAP Material Stock | MARD | LGORT | storage_location |
| SAP Material Stock | MARD | LABST | quantity |
| SAP Material Stock | MARD | DLINL | date_of_count |
| SAP Vendor Invoice | RSEG | BELNR | document_number |
| SAP Vendor Invoice | RSEG | GJAHR | document_year |
| SAP Vendor Invoice | RSEG | EBELN | purchase_document_number |
| SAP Vendor Invoice | RSEG | EBELP | purchase_document_item |
| SAP Vendor Invoice | RSEG | MATNR | material_number |
| SAP Vendor Invoice | RSEG | BUKRS | company_code |
| SAP Vendor Invoice | RSEG | WERKS | plant |
| SAP Vendor Invoice | RSEG | WRBTR | amount |
| SAP Vendor Invoice | RSEG | SHKZG | credit_debit_indicator |
| SAP Vendor Invoice | RSEG | MWSKZ | vat_applicable |
| SAP Vendor Invoice | RSEG | MENGE | quantity |
| SAP Purchasing Organization | T024E | EKORG | purchase_organization |
| SAP Purchasing Organization | T024E | EKOTX | name |
| SAP Purchasing Organization | T024E | BUKRS | company_code |
| SAP Sales Delivery | LIKP | VBELN | document_number |
| SAP Sales Delivery | LIKP | KUNNR | customer_number |
| SAP Sales Delivery | LIKP | ERDAT | date_of_document |
| SAP Sales Delivery | LIKP | ERZET | time_of_document |
| SAP Sales Delivery | LIKP | VKORG | sales_organization |
| SAP Sales Delivery | LIKP | LFART | delivery_type |
| SAP Sales Delivery | LIKP | ROUTE | delivery_route |
| SAP Sales Delivery | VBUK | GBSTK | overall_document_status |
| SAP Sales Delivery | LIPS | MATNR | material_number |
| SAP Sales Delivery | LIPS | CHARG | batch_number |
| SAP Sales Delivery | LIPS | WERKS | plant |
| SAP Sales Delivery | LIPS | LFIMG | quantity |
| SAP Sales Delivery | LIPS | NTGEW | net_weight |
| SAP Sales Delivery | LIPS | GEWEI | delivery_unit |
| SAP Sales Delivery | LIPS | VOLUM | volume |
| SAP Sales Delivery | LIPS | VOLEH | volume_unit |
| SAP Sales Delivery | LIPS | ARKTX | material_description |
| SAP Vendor | LFA1 | LIFNR | vendor_number |
| SAP Vendor | LFA1 | NAME1 | name |
| SAP Vendor | LFA1 | ORT01 | city |
| SAP Vendor | LFA1 | PSTLZ | postal_code |
| SAP Vendor | LFA1 | STRAS | street |
| SAP Vendor | LFA1 | STCEG | vat_reg_number |
| SAP Vendor | LFA1 | WERKS | plant |
| SAP Vendor | LFM1 | EKORG | purchase_organization |
| SAP Vendor | LFM1 | WEBRE | gr_invoice_indicator |
| SAP Sales Revenue Recognition | VBREVK | VBELN | document_number |
| SAP Sales Revenue Recognition | VBREVK | POSNR | document_item |
| SAP Sales Revenue Recognition | VBREVK | SAKRR | accr_val_clearing_account_number |
| SAP Sales Revenue Recognition | VBREVK | SAKRRK | offset_clearing_account_number |
| SAP Sales Revenue Recognition | VBREVK | ACC_VALUE | total_accrued_value |
| SAP Sales Revenue Recognition | VBREVK | WRBTR | amount |
| SAP Sales Revenue Recognition | VBREVK | RVAMT | revenue_amount |
| SAP Sales Revenue Recognition | VBREVK | WAERK | currency_code |
| SAP Country | T005 | LAND1 | country_code |
| SAP Country | T002 | SPRAS | language_code |
| SAP Country | T002 | LAISO | language_iso_code |
| SAP Country | T005T | LANDX | description |
| SAP Language | T002 | SPRAS | language_code |
| SAP Language | T002 | LAISO | language_iso_code |
| SAP Currency | TCURC | WAERS | currency_code |
| SAP Currency | TCURC | ISOCD | currency_iso_code |
| SAP Currency | TCURT | LTEXT | description |
| SAP Distribution Channel | TVTW | VTWEG | distribution_channel |
| SAP Distribution Channel | TVTWT | VTEXT | description |
| SAP Division | TSPA | SPART | division |
| SAP Division | TSPAT | VTEXT | description |
| SAP Company Code | T001 | BUKRS | company_code |
| SAP Company Code | T001 | BUTXT | description |
| SAP Company Code | T001 | LAND1 | country_code |
| SAP Company Code | T001 | WAERS | currency_code |
| SAP Company Code | T001 | SPRAS | language_code |
| SAP Transport | E071 | AS4DATE | date_of_transport |
| SAP Transport | E071 | AS4TIME | time_of_transport |
| SAP Transport | E071 | AS4USER | user |
| SAP Transport | E071 | TRFUNCTION | type |
| SAP Transport | E071 | TRKORR | number |
| SAP Transport | E071 | TRSTATUS | status |
| SAP Transport | E071 | OBJECT | object_type |
| SAP Transport | E071 | OBJ_NAME | object_name |
| SAP Transport | E071 | PGMID | program_id |