SAP ABAP Table CRMST_QUERY_RESULT_ERPIL (CRMST_QUERY_RESULT_ERPIL)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ERP (Application Component) BSP for ERP Sales Order
     ⤷ CRM_ERP_IL (Package) ERP Sales Order: GENIL Implementation

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_RESULT_ERPIL	Table Relationship Diagram
Short Description	CRMST_QUERY_RESULT_ERPIL

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
2	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
3	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
4	AUARTT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
5	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
6	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
7	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
8	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
9	ZPAVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	*
10	ZPERS	☐	CRMT_DZPERS	PERNR	NUMC	8	0	Person responsible
11	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
12	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
13	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
14	SPART	☐	SPART	SPART	CHAR	2	0	Division
15	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
16	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
17	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
18	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
19	AWAHR	☐	AWAHR_AK	AWAHR	NUMC	3	0	Sales Probability
20	DATAB	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
21	DATBI	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
22	NAME_ZPERS	☐	CRMT_NAME1_VP	NAME	CHAR	35	0	Name 1 of a partner
23	KUNAG_T	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
24	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
25	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
26	INCO1	☐	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)	*
27	INCO2	☐	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
28	.INCLUDE	☐				0	0	Include for Extensions of ERP Order Search Result List
29	ERP_ORDER_SRCHRES_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
30	KETDAT	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date

History

Last changed by/on	SAP	20130604
SAP Release Created in	700