SAP ABAP Table CRMT_BSP_ERP_SO_SRCH_RES_OCI (The OIC structure for ERP Sales document search results)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ CRM_BSP_MODEL_IL_ERP_ORDER (Package) Model Access class for ERP order in BSP

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_ERP_SO_SRCH_RES_OCI	Table Relationship Diagram
Short Description	The OIC structure for ERP Sales document search results

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	The structure for search ERP sales documents
2	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
3	TRANSACTION_TYPE	☐	CRMT_BSP_ERP_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	The Process Type for ERP Sales Document	*
4	TRANSACTION_GROUP	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
5	TX_CATEGORY	☐	CRMT_BSP_ERP_R3_TXCATEGORY	CRMT_R3_TRANSACTION_CATEGORY	CHAR	1	0	R3 Leading transaction category
6	OBJECT_ID	☐	CRMT_BSP_ERP_DOC_ID	CRM_OBJECT_ID	CHAR	10	0	Data element for R3 sales document number
7	DESCRIPTION	☐	BEZEI20	TEXT20	CHAR	20	0	Description
8	SALES_ORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
9	PARTNER	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
10	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
11	PO_NUMBER	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
12	SOLD_TO_PARTY	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
13	DOC_FROM	☐	CRMT_BSP_ERP_DATE_FROM	DATUM	DATS	8	0	Date from
14	DOC_TO	☐	CRMT_BSP_ERP_DATE_TO	DATUM	DATS	8	0	Date to
15	RESP_PARTNER	☐	CRMT_BSP_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Usage Within BSP
16	RESP_PERSSONEL	☐	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
17	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
18	PRODUCT_ID	☐	MATNR	MATNR	CHAR	18	0	Material Number
19	VALID_FROM	☐	CRMT_BSP_VALID_FROM	DATUM	DATS	8	0	"Valid From" Date
20	VALID_TO	☐	CRMT_BSP_VALID_TO	DATUM	DATS	8	0	"Valid To" Date
21	MY_DOCS	☐	CRMT_BSP_ERP_MY_DOCS	CRM_BOOLEAN	CHAR	1	0	My sales documents
22	SEARCH_CRITERIA	☐	CRMT_ERP_SALESDOC_SELECTION	CRM_ERP_SALESDOC_SELECTION	CHAR	2	0	Search criteria
23	STATUS	☐	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
24	REASON	☐	CRMT_BSP_STATUS_REASON	TEXT7	CHAR	7	0	Reason for Statuses like Billing Block, Delivery Block,etc
25	DELIVERY_DOC_ID	☐	CRMT_BSP_ERP_DELIVERY_DOC_ID	CRM_OBJECT_ID	CHAR	10	0	R/3 Delivery document number
26	BILLING_DOC_ID	☐	CRMT_BSP_ERP_BILLING_DOC_ID	CRM_OBJECT_ID	CHAR	10	0	R/3 Billing document number
27	NET_VALUE	☐	CRMT_NET_VALUE_CUM	WERTV8	CURR	15	2	Total Net Value of Document in Document Currency
28	GROSS_VALUE	☐	ENDBK	WERTV8	CURR	15	2	Total amount of document
29	CURRENCY	☐	CRMT_CURRENCY	WAERS	CUKY	5	0	Currency	*
30	EXTERNAL_REF	☐	CRMT_PO_NUMBER_SOLD	TEXT35	CHAR	35	0	Sold-To Party's External Reference Number
31	POSTING_DATE	☐	DATS	DATS	DATS	8	0	Field of type DATS
32	.INCLUDE	☐				0	0	Additional fields on header level
33	AUART_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
34	VKBUR_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
35	VKGRP_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
36	VTBER_T	☐	TXT_VTRBER	TXT_VTRBER	CHAR	64	0	Sales area
37	DIS_CHANNEL	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
38	DIVISION	☐	SPART	SPART	CHAR	2	0	Division
39	SALES_OFFICE	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
40	SALES_GROUP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
41	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
42	KPRGBZ	☐	KPRGBZ	PRGBZ	CHAR	1	0	Date type of the requested delivery date	*
43	KETDAT	☐	KETDAT	ETDAT	CHAR	10	0	Requested delivery date of the document
44	KUNAG_T	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
45	KUNWE_T	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
46	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
47	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
48	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
49	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
50	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	*
51	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)	*
52	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document	*
53	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
54	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
55	INCO1	☐	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)	*
56	INCO2	☐	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
57	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
58	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
59	ZTERM_T	☐	DZTERM_BEZ	TEXT30	CHAR	30	0	Description of terms of payment
60	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
61	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
62	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions	*
63	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	*
64	ZLSCH_T	☐	CRMT_ERP_PAYMENT_FORM_TEXT	TEXT30	CHAR	30	0	Name of the payment method in the language of the country
65	CPD_NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
66	CPD_STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
67	CPD_HNUM	☐	HSNMR	NUMC6	NUMC	6	0	House Number
68	CPD_PCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
69	CPD_CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
70	CPD_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
71	CPD_LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
72	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time

History

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