CMDS_EI_EXTRACT SAP (Complex Internal Structure for Customers) Structure details

Dictionary Type: Structure
Description: Complex Internal Structure for Customers




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




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

CMDS_EI_EXTRACT 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 "Complex Internal Structure for Customers" 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_EXTRACT TYPE CMDS_EI_EXTRACT.

The CMDS_EI_EXTRACT table consists of various fields, each holding specific information or linking keys about Complex Internal Structure for Customers data available in SAP. These include KNA1 (), MANDT (Client), KUNNR (Customer Numbers), LAND1 (Country Key).. 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_EXTRACT 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
KNA1 0
MANDTClient MANDTCLNT3Assigned to domainMANDT
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
LAND1Country Key LAND1_GPCHAR3LAND1C_LAND1
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
PSTLZPostal Code PSTLZCHAR10PSTLZ
REGIOSTATE (State, Province, County) REGIOCHAR3Assigned to domainREGIO
SORTLSort field SORTLCHAR10CHAR10
STRASHouse number and street STRAS_GPCHAR35TEXT35
TELF1First telephone number TELF1CHAR16TEXT16
TELFXFax Number TELFXCHAR31TEXT31
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
ADRNRAddress ADRNRCHAR10Assigned to domainALPHAADRNR
MCOD1Search term for matchcode search MCDD1CHAR25CHAR25
MCOD2Search Term for Matchcode Search MCDD2CHAR25CHAR25
MCOD3Search term for matchcode search MCDD3CHAR25CHAR25
ANREDTitle ANREDCHAR15TEXT15
AUFSDCentral order block for customer AUFSD_XCHAR2Assigned to domainKAUFS
BAHNEExpress train station BAHNECHAR25BAHNH
BAHNSTrain station BAHNSCHAR25BAHNH
BBBNRInternational location number (part 1) BBBNRNUMC7NUM07
BBSNRInternational location number (Part 2) BBSNRNUMC5NUM05
BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
BRSCHIndustry key BRSCHCHAR4Assigned to domainBRSCH
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
DATLTData communication line no. DATLTCHAR14TEXT14
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
EXABLIndicator: Unloading points exist EXABLCHAR1XFELD
FAKSDCentral billing block for customer FAKSD_XCHAR2Assigned to domainFAKSP
FISKNAccount number of the master record with the fiscal address FISKN_DCHAR10Assigned to domainALPHAKUNNR
KNAZKWorking Time Calendar KNAZKCHAR2Assigned to domainWFCID
KNRZAAccount number of an alternative payer KNRZACHAR10Assigned to domainALPHAKUNNR
KONZSGroup key KONZSCHAR10KONZS
KTOKDCustomer Account Group KTOKDCHAR4Assigned to domainKTOKDKGD
KUKLACustomer classification KUKLACHAR2Assigned to domainKUKLA
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
LIFSDCentral delivery block for the customer LIFSD_XCHAR2Assigned to domainLIFSP
LOCCOCity Coordinates LOCCOCHAR10LOCCO
LOEVMCentral Deletion Flag for Master Record LOEVM_XCHAR1XFELD
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
NIELSNielsen ID NIELSCHAR2Assigned to domainNIELS
ORT02District ORT02_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
COUNCCounty Code COUNCCHAR3Assigned to domainCOUNC
CITYCCity Code CITYCCHAR4Assigned to domainCITYC
RPMKRRegional Market RPMKRCHAR5RPMKR
SPERRCentral posting block SPERB_XCHAR1XFELD
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
STKZULiable for VAT STKZUCHAR1XFELD
TELBXTelebox number TELBXCHAR15TEXT15
TELF2Second telephone number TELF2CHAR16TEXT16
TELTXTeletex number TELTXCHAR30TEXT30
TELX1Telex number TELX1CHAR30TEXT30
LZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
XZEMPIndicator: Is an alternative payer allowed in document? XREGUCHAR1XFELD
VBUNDCompany ID of trading partner RASSCCHAR6Assigned to domainALPHARCOMPPGS
STCEGVAT Registration Number STCEGCHAR20STCEG
DEAR1Indicator: Competitor DEAR1CHAR1XFELD
DEAR2Indicator: Sales partner DEAR2CHAR1XFELD
DEAR3Indicator: Sales prospect DEAR3CHAR1DEAR3
DEAR4Indicator for customer type 4 DEAR4CHAR1XFELD
DEAR5ID for default sold-to party DEAR5CHAR1XFELD
GFORMLegal status GFORMCHAR2Assigned to domainGFORM
BRAN1Industry Code 1 BRAN1_DCHAR10Assigned to domainBRACO
BRAN2Industry code 2 BRAN2CHAR10Assigned to domainBRACO
BRAN3Industry code 3 BRAN3CHAR10Assigned to domainBRACO
BRAN4Industry code 4 BRAN4CHAR10Assigned to domainBRACO
BRAN5Industry code 5 BRAN5CHAR10Assigned to domainBRACO
EKONTInitial contact EKONTCHAR10Assigned to domainALPHAVBELN
UMSATAnnual sales UMSATCURR8(2) UMSAT
UMJAHYear For Which Sales are Given UMJAHNUMC4JAHR
UWAERCurrency of sales figure UWAERCUKY5Assigned to domainWAERS
JMZAHYearly number of employees JMZAHNUMC6JMZAH
JMJAHYear for which the number of employees is given JMJAHNUMC4JAHR
KATR1Attribute 1 KATR1CHAR2Assigned to domainATTR1
KATR2Attribute - 2 KATR2CHAR2Assigned to domainATTR2
KATR3Attribute 3 KATR3CHAR2Assigned to domainATTR3
KATR4Attribute 4 KATR4CHAR2Assigned to domainATTR4
KATR5Attribute 5 KATR5CHAR2Assigned to domainATTR5
KATR6Attribute 6 KATR6CHAR3Assigned to domainATTR6
KATR7Attribute 7 KATR7CHAR3Assigned to domainATTR7
KATR8Attribute 8 KATR8CHAR3Assigned to domainATTR8
KATR9Attribute 9 KATR9CHAR3Assigned to domainATTR9
KATR10Attribute 10 KATR10CHAR3Assigned to domainATTR10
STKZNNatural Person STKZNCHAR1STKZN
UMSA1Annual sales UMSA1CURR15(2) UMSA1
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
ABRVWUsage Indicator ABRVWCHAR3Assigned to domainABRVW
INSPBYDEBIInspection Carried Out By Customer (No Inspection Lot) QINSPBYDEBCHAR1QKZ
INSPATDEBIInspection for a Delivery Note After Outbound Delivery QINSPATDEBCHAR1QKZ
KTOCDReference Account Group for One-Time Account (Customer) KTOCDCHAR4Assigned to domainKTOKD
PFORTPO Box city PFORT_GPCHAR35TEXT35
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
DTAWSInstruction key for data medium exchange DTAWSCHAR2Assigned to domainDTAWS
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
HZUORAssignment to Hierarchy HZUORNUMC2HZUOR
SPERZPayment Block SPERZCHAR1XFELD
ETIKGIS-R Labeling: customer/plant group ETIKGCHAR10Assigned to domainETIKG
CIVVEID for mainly non-military use CIVVECHAR1XFELD
MILVEID for mainly military use MILVECHAR1XFELD
KDKG1Customer condition group 1 KDKG1CHAR2Assigned to domainKDKGR
KDKG2Customer condition group 2 KDKG2CHAR2Assigned to domainKDKGR
KDKG3Customer condition group 3 KDKG3CHAR2Assigned to domainKDKGR
KDKG4Customer condition group 4 KDKG4CHAR2Assigned to domainKDKGR
KDKG5Customer condition group 5 KDKG5CHAR2Assigned to domainKDKGR
XKNZAIndicator: Alternative payer using account number XKNZACHAR1XFELD
FITYPTax type J_1AFITP_DCHAR2Assigned to domainJ_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2Assigned to domainJ_1ATOID
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
STCD5Tax Number 5 STCD5CHAR60CHAR60
XICMSCustomer is ICMS-exempt J_1BTCICMSCHAR1XFELD
XXIPICustomer is IPI-exempt J_1BTCIPICHAR1XFELD
XSUBTCustomer group for Substituiçao Tributária calculation J_1BTCSTCHAR3Assigned to domainJ_1BTCST1
CFOPCCustomer's CFOP category J_1BINDUS1CHAR2ALPHAJ_1BINDUS1
TXLW1Tax law: ICMS J_1BTAXLW1CHAR3Assigned to domainALPHAJ_1BTAXLW1
TXLW2Tax law: IPI J_1BTAXLW2CHAR3Assigned to domainALPHAJ_1BTAXLW2
CCC01Indicator for biochemical warfare for legal control CCC01CHAR1XFELD
CCC02Indicator for nuclear nonproliferation for legal control CCC02CHAR1XFELD
CCC03Indicator for national security for legal control CCC03CHAR1XFELD
CCC04Indicator for missile technology for legal control CCC04CHAR1XFELD
CASSDCentral sales block for customer CASSD_XCHAR2CASSP
KNURLUniform Resource Locator URLCHAR132TEXT132
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30Assigned to domainGESTYP
J_1KFTINDType of Industry INDTYPCHAR30Assigned to domainINDTYP
CONFSStatus of Change Authorization (Central) CONFS_XCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELCentral deletion block for master record NODEL_XCHAR1XFELD
DEAR6Indicator: Consumer DEAR6CHAR1XFELD
SUFRAMASuframa Code J_1BSUFRAMACHAR9J_1BSUFRAMA
RGRG Number J_1BRGCHAR11J_1BRG
EXPIssued by J_1BEXPCHAR3J_1BEXP
UFState J_1BUFCHAR2J_1BUF
RGDATERG Issue Date J_1BRGDATEDATS8DATUM
RICRIC Number J_1BRICNUMC11J_1BRIC
RNEForeign National Registration J_1BRNECHAR10J_1BRNE
RNEDATERNE Issue Date J_1BRNEDATEDATS8DATUM
CNAECNAE J_1BCNAECHAR7Assigned to domainJ_1BCNAE
LEGALNATLegal Nature J_1BLEGALNATNUMC4Assigned to domainJ_1BLEGALNAT
CRTNCRT Number J_1BCRTNCHAR1J_1BCRTN
ICMSTAXPAYICMS Taxpayer J_1BICMSTAXPAYCHAR2Assigned to domainJ_1BICMSTAXPAY
INDTYPIndustry Main Type J_1BINDTYPCHAR2Assigned to domainJ_1BINDTYP
TDTTax Declaration Type J_1BTDTCHAR2Assigned to domainJ_1BTDT
COMSIZECompany Size J_1BCOMSIZECHAR2Assigned to domainJ_1BCOMSIZE
DECREGPCDeclaration Regimen for PIS/COFINS J_1BDECREGPCCHAR2Assigned to domainJ_1BDECREGPC
.INCLU--AP 0
/VSO/R_PALHGTMaximum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_BIN_HGTQUAN13(3) MENG13
/VSO/R_PAL_ULUnit of Length for Packaging Material (VSO) /VSO/R_PAL_UNIT_LUNIT3Assigned to domainCUNITMEINS
/VSO/R_PK_MATCustomer-Related Packing for Each Packaging Material (VSO) /VSO/M_PACK_BY_MATCHAR1/VSO/M_XFIELD
/VSO/R_MATPALPackaging Material of the Customer in VSO /VSO/M_MATNR_PALCHAR18Assigned to domainMATN1MATNR
/VSO/R_I_NO_LYRNumber Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYRNUMC2/VSO/M_IPAL_NO_LYR
/VSO/R_ONE_MATPacking Material-Specific for Each Packaging Material /VSO/M_ONE_MATCHAR1/VSO/M_XFIELD
/VSO/R_ONE_SORTPack Only One Package Type for Each PKM (VSO) /VSO/M_ONE_SORTCHAR1/VSO/M_XFIELD
/VSO/R_ULD_SIDESide Preference of Loading/Unloading (VSO) /VSO/M_UNLOAD_SIDE_PREFNUMC1/VSO/M_SIDE_PREF
/VSO/R_LOAD_PREFFront/Back Preference of Loading/Unloading (VSO) /VSO/M_LOAD_PREFNUMC1/VSO/M_LOAD_PREF
/VSO/R_DPOINTCollective Unloading Point for VSO /VSO/R_DELIVERYPOINTCHAR10/VSO/R_DELIVERYPOINT/VSO/R_SH_DPOINT
.INCLU--AP 0
/XLSO/CUSTOMERData element to differentiate customer /XLSO/E_CUSTOMERCHAR1/XLSO/D_CUSTOMER
/XLSO/SYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
/XLSO/CLIENTClient MANDTCLNT3Assigned to domainMANDT
/XLSO/PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
/XLSO/PREF_PAYVersion Number Component CHAR2CHAR2CHAR2
.INCLU--AP 0
ALCAgency Location Code FMFG_ALCCHAR8Assigned to domainFMFG_ALCFMFG_ALC
PMT_OFFICEPayment Office FMFG_PMT_OFFCHAR5Assigned to domainFMFG_PMT_OFFFMFG_PMT_OFFICE
FEE_SCHEDULEFee schedule FM_FEE_SCHEDCHAR4FM_FEE_SCHEDFM_FEE_SCHEDULE
DUNSDUNS Number FMCCRDUNSCHAR9
DUNS4DUNS+4 FMCCRDUNS4CHAR4
.INCLU--AP 0
PSOFGProcessor group PSOFGCHAR10Assigned to domainPSOFG
PSOISSubledger acct preprocessing procedure PSOISCHAR20CHAR20
PSON1Name 1 NAME1_GPCHAR35NAME
PSON2Name 2 NAME2_GPCHAR35NAME
PSON3Name 3 NAME3_GPCHAR35NAME
PSOVNFirst Name PSOVNCHAR35NAME
PSOTLTitle PSOTLCHAR20FMPSOTL
PSOHSHouse number: is no longer used from Release 4.6B PSOHSCHAR6CHAR06
PSOSTStreet: No longer used from Release 4.6B PSOSTCHAR28PSOST
PSOO1Description PSOO1CHAR50TEXT50
PSOO2Description PSOO1CHAR50TEXT50
PSOO3Description PSOO1CHAR50TEXT50
PSOO4Description PSOO1CHAR50TEXT50
PSOO5Description PSOO1CHAR50TEXT50
.INCLU--AP 0
J_3GETYPRecipient Type J_3GETYPCHAR2Assigned to domainJ_3GETYP
J_3GREFTYPReference Type for Recipient J_3GREFTYPCHAR2J_3GREFTYP
PSPNRWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
COAUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
J_3GAGEXTExternal Sold-to Party J_3GAGEXTCHAR10Assigned to domainALPHAKUNNR
J_3GAGINTCustomer Internal Settlement J_3GAGINTCHAR10Assigned to domainALPHAKUNNR
J_3GAGDUMIDummy Recipient J_3GDEMPSTCHAR10Assigned to domainALPHAKUNNR
J_3GAGSTDIStandard Recipient J_3GAGSTDICHAR10Assigned to domainALPHAKUNNR
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
J_3GABGLGRetirement Date Counts for Performance-Based Equipment J_3GABGLGCHAR1X
J_3GABGVGRetirement Date Counts for Time-Based Equipment J_3GABGVGCHAR1X
J_3GABRARTSettlement Type J_3GABRARTCHAR1J_3GABRART
J_3GSTDMONHours per Month J_3GSTDMONDEC5(2) DEC03_2
J_3GSTDTAGHours per Day J_3GSTDTAGDEC5(2) DEC03_2
J_3GTAGMONNumber of Days/Month J_3GTAGMONDEC5(2) DEC3_2
J_3GZUGTAGFunction for Settlement on Acquisition Date/PBE J_3GZUGTAGCHAR1X
J_3GMASCHB'Fill PBE Documents' Indicator J_3GMASCHBCHAR1J_3GMASCHB
J_3GMEINSAIndicator: Take Multiple Usage Periods into Account J_3GMEINSACHAR1X
J_3GKEINSAIndicator - Relevant to Short Operation Periods J_3GKEINSACHAR1X
J_3GBLSPERBlocking Indicator for Document Entry J_3GBLSPERCHAR1X
J_3GKLEIVOIndicator: Calculate PBE as TBE J_3GKLEIVOCHAR1X
J_3GCALIDCalendar ID J_3GCALIDCHAR2Assigned to domainWFCID
J_3GVMONATIndicator for Complete Month J_3GVMONATNUMC1J_3GVMONAT
J_3GABRKENSettlement Indicator J_3GABRKENCHAR1J_3GABRKEN
J_3GLABRECHDate of Last Settlement J_3GLABRECHDATS8DATUM
J_3GAABRECHDate of Current Settlement J_3GAABRECHDATS8DATUM
J_3GZUTVHLGInd.: Acquisition Date Counts (as Daily Settlement for PBE) J_3GZUTVHLGCHAR1X
J_3GNEGMENNegative Quantities Allowed Even for Chronolog. Inv. Mgmt J_3GNEGMENCHAR1X
J_3GFRISTLOIndicator: Deadline Logic J_3GFRISTLOCHAR1X
J_3GEMINBEMinimum Usage Period for Restricted Usage (Days) J_3GEMINBENUMC5NUMC
J_3GFMGUERelease Notification Allowance for Unrestricted Usage (Days) J_3GFMGUENUMC5NUMC
J_3GZUSCHUESurcharge for Unrestricted Usage (Days) J_3GZUSCHUENUMC5NUMC
J_3GSCHPRSIndicator: Shift Price J_3GSCHPRSCHAR1X
J_3GINVSTAStatus of Construction Site Inventory J_3GINVSTACHAR1J_3GINVSTA
/SAPCEM/DBERPlanning Area /SAPCEM/DBERCHAR8Assigned to domain/SAPCEM/DBER
/SAPCEM/KVMEQIndicator: Settlement Qty Relevant to Equipment /SAPCEM/KVMEQCHAR1/SAPCEM/KVMEQ
.INCLU--AP 0
OIDRCDifferential Reference Code (DRC) OIC_DRCCHAR5Assigned to domainNUMCVOIC_DRC
.INCLU--AP 0
OID_POREQDPurchase order required: X = Yes, Blank = No OID_POREQDCHAR1OI0_XFELD
.INCLU--AP 0
OIPBLBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10ALPHAOIF_PBLNROI0OIFB
.INCLU--AP 0
KNAS 0
KNAT 0
KNVI 0
KNEX 0
KNVA 0
KNVK 0
VCNUM 0
VCKUN 0
KNBK 0
KNA1_TEXT 0
KNVK_TEXT 0
IBAN 0
KNB1 0
KNB5 0
KNBW 0
KNB1_TEXT 0
KNVV 0
KNVP 0
KNVV_TEXT 0
T_UPD_TXT 0
T1_ADRC 0
T1_ADR2 0
T1_ADR3 0
T1_ADR4 0
T1_ADR5 0
T1_ADR6 0
T1_ADR7 0
T1_ADR8 0
T1_ADR9 0
T1_ADR10 0
T1_ADR11 0
T1_ADR12 0
T1_ADR13 0
T1_ADRCT 0
T1_ADRT 0
T2_ADRC 0
T2_ADRP 0
T2_ADR2 0
T2_ADR3 0
T2_ADR4 0
T2_ADR5 0
T2_ADR6 0
T2_ADR7 0
T2_ADR8 0
T2_ADR9 0
T2_ADR10 0
T2_ADR11 0
T2_ADR12 0
T2_ADR13 0
T2_ADRCT 0
T2_ADRT 0
T3_ADCP 0
T3_ADRP 0
T3_ADRC 0
T3_ADR2 0
T3_ADR3 0
T3_ADR4 0
T3_ADR5 0
T3_ADR6 0
T3_ADR7 0
T3_ADR8 0
T3_ADR9 0
T3_ADR10 0
T3_ADR11 0
T3_ADR12 0
T3_ADR13 0
T3_ADRT 0

Key field Non-key field



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

As CMDS_EI_EXTRACT 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_EXTRACT as there is no data to select.

How to access SAP table CMDS_EI_EXTRACT

Within an ECC or HANA version of SAP you can also view further information about CMDS_EI_EXTRACT 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!