---
sourceDocument: Yokohama Build or modify applications
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/application-development

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Standard ERP Canvas fields within remote tables

# Standard ERP Canvas fields within remote tables {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 4 minutes to read

The standard ERP (Enterprise Resource Planning) remote tables available for use in ERP Canvas 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 Canvas](https://servicenow-prod.fluidtopics.net/KZVpgNmyjdZi5r4oisv4mg "ERP Canvas accesses several standard remote tables for ERP (Enterprise Resource Planning) models.").  
{#erpi-standard-tables-within-tables__table_iwq_dhj_wwb__entry__4}

| 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 |
[Table 1. Standard ERP Canvas and ERP-CM tables within remote tables]

{#erpi-standard-tables-within-tables__table_iwq_dhj_wwb}