CMDS_EI_SALES SAP (Ext. Interface: Sales Data) Structure details

Dictionary Type: Structure
Description: Ext. Interface: Sales Data




ABAP Code to SELECT data from CMDS_EI_SALES
Related tables to CMDS_EI_SALES
Access table CMDS_EI_SALES




Structure field list including key, data, relationships and ABAP select examples

CMDS_EI_SALES is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Ext. Interface: Sales Data" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_CMDS_EI_SALES TYPE CMDS_EI_SALES.

The CMDS_EI_SALES table consists of various fields, each holding specific information or linking keys about Ext. Interface: Sales Data data available in SAP. These include DATA_KEY (), VKORG (Sales Organization), VTWEG (Distribution Channel), SPART (Division).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP CMDS_EI_SALES structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
TASKExternal Interface: Change Indicator Sales Data CMD_EI_SALES_TASKCHAR1CMD_EI_SALES_TASK
DATA_KEY 0
VKORGSales Organization VKORGCHAR4VKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2VTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2SPARTSPAC_SPART
DATA 0
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion flag for customer (sales level) LOEVM_VCHAR1XFELD
VERSGCustomer Statistics Group STGKUCHAR1STGKU
AUFSDCustomer order block (sales area) AUFSD_VCHAR2KAUFS
KALKSPricing procedure assigned to this customer KALKSCHAR1KALKS
KDGRPCustomer group KDGRPCHAR2KDGRPVKD
BZIRKSales district BZIRKCHAR6BZIRKBZI
KONDAPrice group (customer) KONDACHAR2KONDAVKA
PLTYPPrice list type PLTYPCHAR2PLTYPVPL
AWAHROrder probability of the item AWAHRNUMC3AWAHR
INCO1Incoterms (Part 1) INCO1CHAR3INCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
LIFSDCustomer delivery block (sales area) LIFSD_VCHAR2LIFSP
AUTLFComplete delivery defined for each sales order? AUTLFCHAR1XFELD
ANTLFMaximum Number of Partial Deliveries Allowed Per Item ANTLFDEC1ANTLF
KZTLFPartial delivery at item level KZTLFCHAR1KZTLF
KZAZUOrder Combination Indicator KZAZU_DCHAR1XFELD
CHSPLBatch split allowed CHSPLCHAR1XFELD
LPRIODelivery Priority LPRIONUMC2LPRIO
EIKTOShipper's (Our) Account Number at the Customer or Vendor EIKTOCHAR12CHAR12
VSBEDShipping Conditions VSBEDCHAR2VSBED
FAKSDBilling block for customer (sales and distribution) FAKSD_VCHAR2FAKSP
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
PERFKInvoice dates (calendar identification) PERFKCHAR2WFCID
PERRLInvoice list schedule (calendar identification) PERRLCHAR2WFCID
WAERSCurrency WAERS_V02DCUKY5WAERS
KTGRDAccount assignment group for this customer KTGRDCHAR2KTGRD
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
VWERKDelivering Plant (Own or External) DWERK_EXTCHAR4WERKSSH_DWERK_EXTS
VKGRPSales Group VKGRPCHAR3VKGRPVKG
VKBURSales Office VKBURCHAR4VKBURVKB
VSORTItem proposal VSORTCHAR10ALPHAVBELN
KVGR1Customer group 1 KVGR1CHAR3KVGR1
KVGR2Customer group 2 KVGR2CHAR3KVGR2
KVGR3Customer group 3 KVGR3CHAR3KVGR3
KVGR4Customer group 4 KVGR4CHAR3KVGR4
KVGR5Customer group 5 KVGR5CHAR3KVGR5
BOKREIndicator: Customer Is Rebate-Relevant BOKRECHAR1XFELD
KURSTExchange Rate Type KURSTCHAR4KURSTKUT
PRFRERelevant for price determination ID PRFRECHAR1XFELD
KLABCCustomer classification (ABC analysis) KLABCCHAR2KLABC
KABSSCustomer payment guarantee procedure KABSSCH_CMCHAR4KABSSCH_CM
KKBERCredit control area KKBERCHAR4KKBERKKB
CASSDSales block for customer (sales area) CASSD_VCHAR2CASSP
RDOFFSwitch off rounding? RDOFFCHAR1XFELD
AGRELIndicator: Relevant for agency business AGRELCHAR1XFELD
MEGRUUnit of Measure Group MEGRUCHAR4MEGRU
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
UEBTKUnlimited overdelivery allowed UEBTK_VCHAR1XFELD
PVKSMCustomer procedure for product proposal PVKSMCHAR2PVKSM
PODKZRelevant for POD processing PODKZCHAR1XFELD
PODTGTimeframe for Confirmation of POD PODTGDEC11TSTRGTSTRDURAG
BLINDIndex Structure Active for Subsequent Settlement (in AB) BLIND_SDCHAR1XFELD
PRAT1ID for product attribute 1 KUAT1CHAR1PRATK
PRAT2ID for product attribute 2 KUAT2CHAR1PRATK
PRAT3ID for product attribute 3 KUAT3CHAR1PRATK
PRAT4ID for product attribute 4 KUAT4CHAR1PRATK
PRAT5ID for product attribute 5 KUAT5CHAR1PRATK
PRAT6ID for product attribute 6 KUAT6CHAR1PRATK
PRAT7ID for product attribute 7 KUAT7CHAR1PRATK
PRAT8ID for product attribute 8 KUAT8CHAR1PRATK
PRAT9ID for product attribute 9 KUAT9CHAR1PRATK
PRATAID for product attribute 10 KUATACHAR1PRATK
DATAX 0
BEGRUUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LOEVMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VERSGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
AUFSDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KALKSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KDGRPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BZIRKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KONDAUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PLTYPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
AWAHRUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INCO1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
INCO2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LIFSDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
AUTLFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ANTLFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KZTLFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KZAZUUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CHSPLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
LPRIOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
EIKTOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VSBEDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FAKSDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MRNKZUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PERFKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PERRLUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
WAERSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KTGRDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
ZTERMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VWERKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VKGRPUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VKBURUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
VSORTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KVGR1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KVGR2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KVGR3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KVGR4Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KVGR5Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BOKREUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KURSTUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRFREUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KLABCUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KABSSUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
KKBERUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
CASSDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
RDOFFUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
AGRELUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
MEGRUUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UEBTOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UNTTOUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
UEBTKUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PVKSMUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PODKZUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PODTGUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
BLINDUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT1Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT2Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT3Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT4Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT5Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT6Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT7Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT8Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRAT9Updated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
PRATAUpdated information in related user data field BAPIUPDATECHAR1BAPIUPDATE
FUNCTIONS 0
CURRENT_STATEExternal Interface: Indicator for Complete Data CVI_EI_CURRENT_STATECHAR1XFELD
FUNCTIONS 0
TEXTS 0
CURRENT_STATEExternal Interface: Indicator for Complete Data CVI_EI_CURRENT_STATECHAR1XFELD
TEXTS 0

Key field Non-key field



How do I retrieve data from SAP structure CMDS_EI_SALES using ABAP code?

As CMDS_EI_SALES is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CMDS_EI_SALES as there is no data to select.

How to access SAP table CMDS_EI_SALES

Within an ECC or HANA version of SAP you can also view further information about CMDS_EI_SALES and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!