1. Home
  2. Resources
  3. SAP Tables
  4. CMDS_EI_SALES - Ext. Interface: Sales Data

SAP Table CMDS_EI_SALES

Ext. Interface: Sales Data

CMDS_EI_SALES (Ext. Interface: Sales Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CMDS_EI_SALES to other SAP tables.

CMDS_EI_SALES table fields

Field Data element Checktable Datatype Length Decimals
TASK External Interface: Change Indicator Sales Data CMD_EI_SALES_TASK CHAR 1 0
I Create
U Change
M Create/Change
DATA_KEY CMDS_EI_SALES_KEY STRU 0 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
SPART Division SPART CHAR 2 0
DATA CMDS_EI_SALES_DATA STRU 0 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion flag for customer (sales level) LOEVM_V CHAR 1 0
X Update for the field
NULL No update for the field
VERSG Customer Statistics Group STGKU CHAR 1 0
AUFSD Customer order block (sales area) AUFSD_V CHAR 2 0
KALKS Pricing procedure assigned to this customer KALKS CHAR 1 0
KDGRP Customer group KDGRP CHAR 2 0
BZIRK Sales district BZIRK CHAR 6 0
KONDA Price group (customer) KONDA CHAR 2 0
PLTYP Price list type PLTYP CHAR 2 0
AWAHR Order probability of the item AWAHR NUMC 3 0
X Update for the field
NULL No update for the field
INCO1 Incoterms (Part 1) INCO1 CHAR 3 0
INCO2 Incoterms (Part 2) INCO2 CHAR 28 0
LIFSD Customer delivery block (sales area) LIFSD_V CHAR 2 0
AUTLF Complete delivery defined for each sales order? AUTLF CHAR 1 0
X Update for the field
NULL No update for the field
ANTLF Maximum Number of Partial Deliveries Allowed Per Item ANTLF DEC 1 0
KZTLF Partial delivery at item level KZTLF CHAR 1 0
X Update for the field
NULL No update for the field
KZAZU Order Combination Indicator KZAZU_D CHAR 1 0
X Update for the field
NULL No update for the field
CHSPL Batch split allowed CHSPL CHAR 1 0
X Update for the field
NULL No update for the field
LPRIO Delivery Priority LPRIO NUMC 2 0
EIKTO Shipper's (Our) Account Number at the Customer or Vendor EIKTO CHAR 12 0
VSBED Shipping Conditions VSBED CHAR 2 0
FAKSD Billing block for customer (sales and distribution) FAKSD_V CHAR 2 0
MRNKZ Manual invoice maintenance MRNKZ CHAR 1 0
X Update for the field
NULL No update for the field
PERFK Invoice dates (calendar identification) PERFK CHAR 2 0
PERRL Invoice list schedule (calendar identification) PERRL CHAR 2 0
WAERS Currency WAERS_V02D CUKY 5 0
KTGRD Account assignment group for this customer KTGRD CHAR 2 0
ZTERM Terms of Payment Key DZTERM CHAR 4 0
VWERK Delivering Plant (Own or External) DWERK_EXT CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
VKBUR Sales Office VKBUR CHAR 4 0
VSORT Item proposal VSORT CHAR 10 0
KVGR1 Customer group 1 KVGR1 CHAR 3 0
KVGR2 Customer group 2 KVGR2 CHAR 3 0
KVGR3 Customer group 3 KVGR3 CHAR 3 0
KVGR4 Customer group 4 KVGR4 CHAR 3 0
KVGR5 Customer group 5 KVGR5 CHAR 3 0
BOKRE Indicator: Customer Is Rebate-Relevant BOKRE CHAR 1 0
X Update for the field
NULL No update for the field
KURST Exchange Rate Type KURST CHAR 4 0
PRFRE Relevant for price determination ID PRFRE CHAR 1 0
X Update for the field
NULL No update for the field
KLABC Customer classification (ABC analysis) KLABC CHAR 2 0
KABSS Customer payment guarantee procedure KABSSCH_CM CHAR 4 0
KKBER Credit control area KKBER CHAR 4 0
CASSD Sales block for customer (sales area) CASSD_V CHAR 2 0
RDOFF Switch off rounding? RDOFF CHAR 1 0
X Update for the field
NULL No update for the field
AGREL Indicator: Relevant for agency business AGREL CHAR 1 0
X Update for the field
NULL No update for the field
MEGRU Unit of Measure Group MEGRU CHAR 4 0
UEBTO Overdelivery Tolerance Limit UEBTO DEC 3 1
UNTTO Underdelivery Tolerance Limit UNTTO DEC 3 1
UEBTK Unlimited overdelivery allowed UEBTK_V CHAR 1 0
X Update for the field
NULL No update for the field
PVKSM Customer procedure for product proposal PVKSM CHAR 2 0
PODKZ Relevant for POD processing PODKZ CHAR 1 0
X Update for the field
NULL No update for the field
PODTG Timeframe for Confirmation of POD PODTG DEC 11 0
BLIND Index Structure Active for Subsequent Settlement (in AB) BLIND_SD CHAR 1 0
X Update for the field
NULL No update for the field
PRAT1 ID for product attribute 1 KUAT1 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT2 ID for product attribute 2 KUAT2 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT3 ID for product attribute 3 KUAT3 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT4 ID for product attribute 4 KUAT4 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT5 ID for product attribute 5 KUAT5 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT6 ID for product attribute 6 KUAT6 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT7 ID for product attribute 7 KUAT7 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT8 ID for product attribute 8 KUAT8 CHAR 1 0
X Update for the field
NULL No update for the field
PRAT9 ID for product attribute 9 KUAT9 CHAR 1 0
X Update for the field
NULL No update for the field
PRATA ID for product attribute 10 KUATA CHAR 1 0
X Update for the field
NULL No update for the field
DATAX CMDS_EI_SALES_DATAX STRU 0 0
BEGRU Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
LOEVM Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VERSG Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
AUFSD Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KALKS Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KDGRP Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
BZIRK Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KONDA Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PLTYP Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
AWAHR Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
INCO1 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
INCO2 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
LIFSD Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
AUTLF Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
ANTLF Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KZTLF Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KZAZU Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
CHSPL Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
LPRIO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
EIKTO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VSBED Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
FAKSD Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
MRNKZ Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PERFK Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PERRL Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
WAERS Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KTGRD Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
ZTERM Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VWERK Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VKGRP Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VKBUR Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
VSORT Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KVGR1 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KVGR2 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KVGR3 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KVGR4 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KVGR5 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
BOKRE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KURST Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRFRE Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KLABC Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KABSS Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
KKBER Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
CASSD Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
RDOFF Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
AGREL Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
MEGRU Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
UEBTO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
UNTTO Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
UEBTK Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PVKSM Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PODKZ Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PODTG Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
BLIND Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT1 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT2 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT3 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT4 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT5 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT6 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT7 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT8 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRAT9 Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
PRATA Updated information in related user data field BAPIUPDATE CHAR 1 0
X Update for the field
NULL No update for the field
FUNCTIONS CMDS_EI_CMD_FUNCTIONS STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data CVI_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
FUNCTIONS CMDS_EI_FUNCTIONS_T TTYP 0 0
TEXTS CVIS_EI_CVIS_TEXT STRU 0 0
CURRENT_STATE External Interface: Indicator for Complete Data CVI_EI_CURRENT_STATE CHAR 1 0
X Yes
NULL No
TEXTS CVIS_EI_TEXT_T TTYP 0 0