SAP ABAP Table CRMST_ERP_ATTRS_FOR_CFG (Attributes necessary for configuration)

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_ERP_ATTRS_FOR_CFG	Table Relationship Diagram
Short Description	Attributes necessary for configuration

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	HEADER_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
2	HEADER	☐	CRMST_ADMINH_ERPIL		STRU	0	0
3	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type
4	AUART_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
5	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
6	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
7	SPART	☐	SPART	SPART	CHAR	2	0	Division
8	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
9	VKBUR_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
10	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group
11	VKGRP_T	☐	BEZEI20	TEXT20	CHAR	20	0	Description
12	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document
13	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party
14	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party
15	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
16	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
17	KPRGBZ	☐	KPRGBZ	PRGBZ	CHAR	1	0	Date type of the requested delivery date
18	KETDAT	☐	KETDAT	ETDAT	CHAR	10	0	Requested delivery date of the document
19	DWERK	☐	DWERK_ERP	WERKS	CHAR	4	0	Delivering Plant (Own or External)
20	VTBER_T	☐	TXT_VTRBER	TXT_VTRBER	CHAR	64	0	Sales area
21	KUNAG_T	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
22	KUNWE_T	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
23	DWERK_T	☐	NAME1	TEXT30	CHAR	30	0	Name
24	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
25	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit
26	BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
27	VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
28	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)
29	LIFSK	☐	LIFSK	LIFSP	CHAR	2	0	Delivery block (document header)
30	FAKSK	☐	FAKSK	FAKSP	CHAR	2	0	Billing block in SD document
31	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
32	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency
33	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
34	INCO1	☐	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)
35	INCO2	☐	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
36	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
37	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
38	ZTERM_T	☐	DZTERM_BEZ	TEXT30	CHAR	30	0	Description of terms of payment
39	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
40	ENDBK	☐	ENDBK	WERTV8	CURR	15	2	Total amount of document
41	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
42	AUDAT	☐	AUDAT	DATUM	DATS	8	0	Document Date (Date Received/Sent)
43	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
44	BNDDT	☐	BNDDT_LORD	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
45	GUEBG	☐	GUEBG	DATUM	DATS	8	0	Valid-from date (outline agreements, product proposals)
46	GUEEN	☐	GUEEN	DATUM	DATS	8	0	Valid-to date (outline agreements, product proposals)
47	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions
48	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method
49	ZLSCH_T	☐	CRMT_ZLSCH_T_ERPIL	TEXT30	CHAR	30	0	Description for Payment Method
50	CPD_NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
51	CPD_STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
52	CPD_HNUM	☐	HSNMR	NUMC6	NUMC	6	0	House Number
53	CPD_PCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
54	CPD_CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
55	CPD_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key
56	CPD_LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key
57	TRVOG	☐	TRVOG	TRVOG	CHAR	1	0	Transaction group
58	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
59	VBEGDAT	☐	VBDAT_VEDA	DATUM	DATS	8	0	Contract start date
60	VENDDAT	☐	VNDAT_VEDA	DATUM	DATS	8	0	Contract End Date
61	VBEGREG	☐	VBREG_VEDA	VDREG_VEDA	CHAR	2	0	Rule for calculating contract start date
62	VENDREG	☐	RGVTE	VDREG_VEDA	CHAR	2	0	Rule for contract end date
63	KALSM_R	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing
64	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group
65	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)
66	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type
67	KURST_R	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type
68	UPD_TMSTMP_R	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
69	VDATU	☐	EDATU_VBAK	DATUM	DATS	8	0	Requested delivery date
70	.INCLUDE	☐				0	0	EEW Include for changeable ERP Header Fields
71	ERP_ADMINH_V_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
72	.INCLUDE	☐				0	0	EEW Include for read-only ERP Header Fields
73	ERP_ADMINH_R_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
74	.INCLUDE	☐				0	0	EEW Include for changeable ERP Header and Item Fields
75	ERP_ADMINHI_V_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
76	.INCLUDE	☐				0	0	EEW Include for read-only ERP Header and Item Fields
77	ERP_ADMINHI_R_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
78	TAXK1	☐	TAXK1_AK	TAXKD	CHAR	1	0	Alternative tax classification
79	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1
80	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2
81	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3
82	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4
83	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5
84	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1
85	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2
86	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3
87	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4
88	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5
89	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district
90	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type
91	VSBED_T	☐	VSBED_BEZ	TEXT20	CHAR	20	0	Description of the shipping conditions
92	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
93	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
94	SEPON	☐	CRMT_SEPA_ON	CRM_SEPA_ON	CHAR	1	0	Indicator for SEPA-Relevant Transactions
95	KDGRP_T	☐	VTXTK	TEXT20	CHAR	20	0	Name
96	ITEM	☐	CRMST_ADMINI_ERPIL		STRU	0	0
97	HANDLE	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
98	SELKZ	☐	SELKZ	SELKZ	CHAR	1	0	Selection flag
99	POSNR	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item
100	UEPOS	☐	UEPOS	POSNR	NUMC	6	0	Higher-level item in bill of material structures
101	MABNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
102	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
103	ARKTX	☐	ARKTX	TEXT40	CHAR	40	0	Short text for sales order item
104	PSTYV	☐	PSTYV	PSTYV	CHAR	4	0	Sales document item category
105	KDMAT	☐	MATNR_KU	CRM_R3_VEND_MAT	CHAR	35	0	Customer Material Number
106	KWMENG	☐	KWMENG	MENG15	QUAN	15	3	Cumulative order quantity in sales units
107	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit
108	WERKS	☐	DWERK_ERP	WERKS	CHAR	4	0	Delivering Plant (Own or External)
109	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
110	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point
111	ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route
112	POSEX	☐	POSEX	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
113	FAKSP	☐	FAKSP_AP	FAKSP	CHAR	2	0	Billing block for item
114	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
115	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
116	ETDAT	☐	ETDAT_ERP	ETDAT	CHAR	10	0	Schedule line date
117	PRGBZ	☐	PRGBZ_ERP	PRGBZ	CHAR	1	0	External date type
118	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
119	PRSDT	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
120	KURSK	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
121	FKDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
122	INCO1	☐	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)
123	INCO2	☐	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
124	ABGRU	☐	ABGRU_VA	ABGRU_VA	CHAR	2	0	Reason for rejection of quotations and sales orders
125	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority
126	BRGEW	☐	BRGEW_AP	MENG15	QUAN	15	3	Gross weight of item
127	NTGEW	☐	NTGEW_AP	MENG15	QUAN	15	3	Net weight of item
128	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit
129	VOLUM	☐	VOLUM_AP	MENG15	QUAN	15	3	Volume of the item
130	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit
131	SPART	☐	SPART	SPART	CHAR	2	0	Division
132	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency
133	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
134	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
135	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type
136	KOEIN	☐	KOEIN	KOEIN	CUKY	5	0	Rate unit (currency, sales unit, or %)
137	KBETR	☐	KBETR	WERTV6	CURR	11	2	Rate (condition amount or percentage)
138	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
139	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit
140	KSTBS	☐	KSTBM	MENG15	QUAN	15	3	Condition scale quantity
141	MATWA	☐	MATWA	MATNR	CHAR	18	0	Material entered
142	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
143	T_PSP_PNR	☐	PS_POSID	PS_POSID	CHAR	24	0	Work Breakdown Structure Element (WBS Element)
144	MWSBP	☐	MWSBP	WERTV7	CURR	13	2	Tax amount in document currency
145	ZMENG	☐	DZMENG	MENG13	QUAN	13	3	Target quantity in sales units
146	ZIEME	☐	DZIEME	MEINS	UNIT	3	0	Target quantity UoM
147	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
148	FIXMG	☐	FIXMG	XFELD	CHAR	1	0	Delivery date and quantity fixed
149	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method
150	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
151	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
152	GRKOR	☐	GRKOR	GRKOR	NUMC	3	0	Delivery group (items are delivered together)
153	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
154	DELCO	☐	DELCO	DELCO	CHAR	3	0	Agreed delivery time
155	ERDAT_R	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
156	CUOBJ_R	☐	CUOBJ_VA	CUOBJ	NUMC	18	0	Configuration
157	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure
158	KONDM	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group
159	MVGR1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1
160	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2
161	MVGR3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3
162	MVGR4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4
163	MVGR5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5
164	PRODH	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy
165	PMATN_R	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material
166	VRKME_INT_R	☐	VRKME	MEINS	UNIT	3	0	Sales unit
167	SHKZG_R	☐	SHKZG_VA	XFELD	CHAR	1	0	Returns Item
168	STDPD_R	☐	STDPD	MATNR	CHAR	18	0	Configurable material
169	KBMENG_R	☐	KBMENG	MENG15	QUAN	15	3	Cumulative confirmed quantity in sales unit
170	EDATU_LAST	☐	EDATU	DATUM	DATS	8	0	Schedule line date
171	VBELN_REF	☐	VGBEL	VBELN	CHAR	10	0	Document number of the reference document
172	POSNR_REF	☐	VGPOS	POSNR	NUMC	6	0	Item number of the reference item
173	.INCLUDE	☐				0	0	EEW Include for changeable ERP Item Fields
174	ERP_ADMINI_V_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
175	.INCLUDE	☐				0	0	EEW Include for read-only ERP Item Fields
176	ERP_ADMINI_R_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
177	.INCLUDE	☐				0	0	EEW Include for changeable ERP Header and Item Fields
178	ERP_ADMINHI_V_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
179	.INCLUDE	☐				0	0	EEW Include for read-only ERP Header and Item Fields
180	ERP_ADMINHI_R_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
181	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
182	BSARK	☐	BSARK	BSARK	CHAR	4	0	Customer Order Type
183	GRPOS	☐	GRPOS	GRPOS	NUMC	6	0	Item for which this item is an alternative
184	VSMNG_R	☐	CRMT_VSMNG_ERPIL	MENG13	QUAN	13	3	Delivered quantity in sales units
185	EDATU	☐	EDATU	DATUM	DATS	8	0	Schedule line date
186	MNDID	☐	SEPA_MNDID	ID035	CHAR	35	0	Unique Referene to Mandate per Payment Recipient
187	PAY_TYPE	☐	SEPA_PAY_TYPE	SEPA_PAY_TYPE	CHAR	1	0	SEPA: Payment Type
188	SEPON	☐	CRMT_SEPA_ON	CRM_SEPA_ON	CHAR	1	0	Indicator for SEPA-Relevant Transactions
189	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date

History

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