SAP ABAP Table CRMST_QRESHIST_ERPIL (ERP: Query Result Object - Order History)

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_QRESHIST_ERPIL	Table Relationship Diagram
Short Description	ERP: Query Result Object - Order History

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	.INCLUDE	☐				0	0	Query Result Object - Order History - Logical Key
2	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
3	SD_DOC	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number
4	ITM_NUMBER	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
5	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
6	SHORT_TEXT	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
7	DOC_TYPE	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
8	DOC_DATE	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
9	REQ_QTY	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
10	REQ_DATE	☐	WLDAT	DATUM	DATS	8	0	Requested delivery date
11	PURCH_NO	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
12	BATCH	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
13	VALID_FROM	☐	DATAB_VI	DATUM	DATS	8	0	Quotation or contract valid from
14	VALID_TO	☐	DATBI_VI	DATUM	DATS	8	0	Quotation or contract valid to
15	BILL_BLOCK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
16	DLV_BLOCK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
17	SOLD_TO	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
18	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
19	EXCHG_RATE	☐	KURSK_P	PKURS	DEC	9	5	Directly Quoted Exchange Rate for Pricing and Statistics
20	DLV_QTY	☐	LFIMG	MENG13	QUAN	13	3	Actual quantity delivered (in sales units)
21	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
22	NET_PRICE	☐	NETPR	WERTV6	CURR	11	2	Net price
23	COND_P_UNT	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
24	COND_UNIT	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	*
25	NET_VAL_HD	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
26	NET_VALUE	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
27	DIVISION	☐	SPART	SPART	CHAR	2	0	Division
28	DOC_STATUS	☐	STATS	TEXT20	CHAR	20	0	Document status
29	SALES_GRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
30	SALES_OFF	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
31	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
32	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
33	SHIP_POINT	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
34	DISTR_CHAN	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
35	GI_DATE	☐	WADAT	DATUM	DATS	8	0	Goods Issue Date
36	CURRENCY	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
37	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
38	STORE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
39	ORD_REASON	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
40	REASON_REJ	☐	ABGRU	CRMT_ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
41	B_UOM_ISO	☐	MEINS_ISO	ISOCD_UNIT	CHAR	3	0	Base unit of measure in ISO code	*
42	CD_UNT_ISO	☐	KVMEI_ISO	ISOCD_UNIT	CHAR	3	0	Condition Unit in ISO Code	*
43	S_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	*
44	CURR_ISO	☐	WAERS_ISO	ISOCD	CHAR	3	0	ISO code currency
45	PURCH_NO_C	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
46	EXCHG_RATE_V	☐	KURSK_V	PKURS	DEC	9	5	Indirectly Quoted Exchange Rate for Pricing and Statistics
47	MAT_EXT	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
48	MAT_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
49	MAT_VERS	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
50	CREATION_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
51	CREATION_TIME	☐	ERZET	UZEIT	TIMS	6	0	Entry time

History

Last changed by/on	SAP	20110908
SAP Release Created in	500