Standard ERP-CM fields within remote tables
The standard ERP (Enterprise Resource Planning) remote tables available for use in ERP Customization Mining (ERP-CM) 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-CM.
| 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 Organisation | TVKO | VKORG | sales_organization |
| SAP Sales Organisation | TVKO | EKORG | purchase_organization |
| SAP Sales Organisation | 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 Organisation | T024E | EKORG | purchase_organization |
| SAP Purchasing Organisation | T024E | EKOTX | name |
| SAP Purchasing Organisation | 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 |