---
sourceDocument: Brazil Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Standard fields in remote tables

# Standard Zero Copy Connector for ERP fields in remote tables {#ariaid-title1}

Release version: Brazil  
Updated October 22, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 5 minutes to read  
The standard ERP (Enterprise Resource Planning) remote tables available in Zero Copy Connector for ERP contain fields from additional SAP tables.
For details about the standard tables, see [Standard remote tables for Zero Copy Connector for ERP](https://www.servicenow.com/docs/a_P88ubj8NCkOHRj__HRxQ "Zero Copy Connector for ERP (Enterprise Resource Planning) accesses several standard remote tables for ERP models."). The standard remote tables contain the following additional fields:  
{#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 Zero Copy Connector for ERP and ERP Semantic Mining tables within remote tables]

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