Standard ERP Semantic Mining fields within remote tables
The standard ERP (Enterprise Resource Planning) remote tables available for use in ERP Semantic Mining contain fields from additional SAP tables.
Important: Starting with the Zurich release, ERP Semantic Mining is being prepared for future deprecation. It will be hidden and no longer activated on new instances but will continue to be supported.
The standard remote tables contain the following additional fields. For details on the standard tables, see Standard remote tables for ERP Semantic Mining.
| 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 |
Parent Topic:ERP Semantic Mining standard tables and fields