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

History

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