SAP ABAP Table CMDS_EI_SALES (Ext. Interface: Sales Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD-BP-CM (Application Component) Customer Master
     ⤷ CMD_INTERFACE (Package) Customer Interface

Basic Data

Table Category	INTTAB	Structure
Structure	CMDS_EI_SALES	Table Relationship Diagram
Short Description	Ext. Interface: Sales Data

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	TASK	☐	CMD_EI_SALES_TASK	CMD_EI_SALES_TASK	CHAR	1	0	External Interface: Change Indicator Sales Data
2	DATA_KEY	☐	CMDS_EI_SALES_KEY		STRU	0	0
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel
5	SPART	☐	SPART	SPART	CHAR	2	0	Division
6	DATA	☐	CMDS_EI_SALES_DATA		STRU	0	0
7	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
8	LOEVM	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
9	VERSG	☐	STGKU	STGKU	CHAR	1	0	Customer Statistics Group
10	AUFSD	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)
11	KALKS	☐	KALKS	KALKS	CHAR	1	0	Pricing procedure assigned to this customer
12	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group
13	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district
14	KONDA	☐	KONDA	KONDA	CHAR	2	0	Price Group (Customer)
15	PLTYP	☐	PLTYP	PLTYP	CHAR	2	0	Price list type
16	AWAHR	☐	AWAHR	AWAHR	NUMC	3	0	Order probability of the item
17	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)
18	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
19	LIFSD	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)
20	AUTLF	☐	AUTLF	XFELD	CHAR	1	0	Complete delivery defined for each sales order?
21	ANTLF	☐	ANTLF	ANTLF	DEC	1	0	Maximum number of partial deliveries allowed per item
22	KZTLF	☐	KZTLF	KZTLF	CHAR	1	0	Partial delivery at item level
23	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
24	CHSPL	☐	CHSPL	XFELD	CHAR	1	0	Batch split allowed
25	LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority
26	EIKTO	☐	EIKTO	CHAR12	CHAR	12	0	Shipper's (Our) Account Number at the Customer or Vendor
27	VSBED	☐	VSBED	VSBED	CHAR	2	0	Shipping conditions
28	FAKSD	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)
29	MRNKZ	☐	MRNKZ	XFELD	CHAR	1	0	Manual invoice maintenance
30	PERFK	☐	PERFK	WFCID	CHAR	2	0	Invoice dates (calendar identification)
31	PERRL	☐	PERRL	WFCID	CHAR	2	0	Invoice list schedule (calendar identification)
32	WAERS	☐	WAERS_V02D	WAERS	CUKY	5	0	Currency
33	KTGRD	☐	KTGRD	KTGRD	CHAR	2	0	Account assignment group for this customer
34	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
35	VWERK	☐	DWERK_EXT	WERKS	CHAR	4	0	Delivering Plant (Own or External)
36	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group
37	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office
38	VSORT	☐	VSORT	VBELN	CHAR	10	0	Item proposal
39	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1
40	KVGR2	☐	KVGR2	KVGR2	CHAR	3	0	Customer group 2
41	KVGR3	☐	KVGR3	KVGR3	CHAR	3	0	Customer group 3
42	KVGR4	☐	KVGR4	KVGR4	CHAR	3	0	Customer group 4
43	KVGR5	☐	KVGR5	KVGR5	CHAR	3	0	Customer group 5
44	BOKRE	☐	BOKRE	XFELD	CHAR	1	0	ID: Customer is to receive rebates
45	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type
46	PRFRE	☐	PRFRE	XFELD	CHAR	1	0	Relevant for Pricing ID
47	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
48	KABSS	☐	KABSSCH_CM	KABSSCH_CM	CHAR	4	0	Customer payment guarantee procedure
49	KKBER	☐	KKBER	KKBER	CHAR	4	0	Credit control area
50	CASSD	☐	CASSD_V	CASSP	CHAR	2	0	Sales block for customer (sales area)
51	RDOFF	☐	RDOFF	XFELD	CHAR	1	0	Switch off rounding?
52	AGREL	☐	AGREL	XFELD	CHAR	1	0	Indicator: Relevant for agency business
53	MEGRU	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group
54	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
55	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
56	UEBTK	☐	UEBTK_V	XFELD	CHAR	1	0	Unlimited overdelivery allowed
57	PVKSM	☐	PVKSM	PVKSM	CHAR	2	0	Customer procedure for product proposal
58	PODKZ	☐	PODKZ	XFELD	CHAR	1	0	Relevant for POD processing
59	PODTG	☐	PODTG	TSTRDURAG	DEC	11	0	Timeframe for Confirmation of POD
60	BLIND	☐	BLIND_SD	XFELD	CHAR	1	0	Index Structure Active for Subsequent Settlement (in AB)
61	PRAT1	☐	KUAT1	PRATK	CHAR	1	0	ID for product attribute 1
62	PRAT2	☐	KUAT2	PRATK	CHAR	1	0	ID for product attribute 2
63	PRAT3	☐	KUAT3	PRATK	CHAR	1	0	ID for product attribute 3
64	PRAT4	☐	KUAT4	PRATK	CHAR	1	0	ID for product attribute 4
65	PRAT5	☐	KUAT5	PRATK	CHAR	1	0	ID for product attribute 5
66	PRAT6	☐	KUAT6	PRATK	CHAR	1	0	ID for product attribute 6
67	PRAT7	☐	KUAT7	PRATK	CHAR	1	0	ID for product attribute 7
68	PRAT8	☐	KUAT8	PRATK	CHAR	1	0	ID for product attribute 8
69	PRAT9	☐	KUAT9	PRATK	CHAR	1	0	ID for product attribute 9
70	PRATA	☐	KUATA	PRATK	CHAR	1	0	ID for product attribute 10
71	DATAX	☐	CMDS_EI_SALES_DATAX		STRU	0	0
72	BEGRU	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
73	LOEVM	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
74	VERSG	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
75	AUFSD	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
76	KALKS	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
77	KDGRP	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
78	BZIRK	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
79	KONDA	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
80	PLTYP	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
81	AWAHR	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
82	INCO1	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
83	INCO2	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
84	LIFSD	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
85	AUTLF	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
86	ANTLF	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
87	KZTLF	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
88	KZAZU	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
89	CHSPL	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
90	LPRIO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
91	EIKTO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
92	VSBED	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
93	FAKSD	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
94	MRNKZ	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
95	PERFK	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
96	PERRL	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
97	WAERS	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
98	KTGRD	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
99	ZTERM	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
100	VWERK	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
101	VKGRP	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
102	VKBUR	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
103	VSORT	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
104	KVGR1	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
105	KVGR2	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
106	KVGR3	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
107	KVGR4	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
108	KVGR5	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
109	BOKRE	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
110	KURST	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
111	PRFRE	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
112	KLABC	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
113	KABSS	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
114	KKBER	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
115	CASSD	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
116	RDOFF	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
117	AGREL	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
118	MEGRU	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
119	UEBTO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
120	UNTTO	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
121	UEBTK	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
122	PVKSM	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
123	PODKZ	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
124	PODTG	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
125	BLIND	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
126	PRAT1	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
127	PRAT2	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
128	PRAT3	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
129	PRAT4	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
130	PRAT5	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
131	PRAT6	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
132	PRAT7	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
133	PRAT8	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
134	PRAT9	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
135	PRATA	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
136	FUNCTIONS	☐	CMDS_EI_CMD_FUNCTIONS		STRU	0	0
137	CURRENT_STATE	☐	CVI_EI_CURRENT_STATE	XFELD	CHAR	1	0	External Interface: Indicator for Complete Data
138	FUNCTIONS	☐	CMDS_EI_FUNCTIONS_T		TTYP	0	0
139	TEXTS	☐	CVIS_EI_CVIS_TEXT		STRU	0	0
140	CURRENT_STATE	☐	CVI_EI_CURRENT_STATE	XFELD	CHAR	1	0	External Interface: Indicator for Complete Data
141	TEXTS	☐	CVIS_EI_TEXT_T		TTYP	0	0

History

Last changed by/on	SAP	20140121
SAP Release Created in	600