CMDS_EI_EXTRACT SAP (Complex Internal Structure for Customers) Structure details
Description: Complex Internal Structure for Customers
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 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
LAND1 | Country Key | LAND1_GP | CHAR | 3 | LAND1 | C_LAND1 | |||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
ADRNR | Address | ADRNR | CHAR | 10 | Assigned to domain | ALPHA | ADRNR | ||
MCOD1 | Search term for matchcode search | MCDD1 | CHAR | 25 | CHAR25 | ||||
MCOD2 | Search Term for Matchcode Search | MCDD2 | CHAR | 25 | CHAR25 | ||||
MCOD3 | Search term for matchcode search | MCDD3 | CHAR | 25 | CHAR25 | ||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
AUFSD | Central order block for customer | AUFSD_X | CHAR | 2 | Assigned to domain | KAUFS | |||
BAHNE | Express train station | BAHNE | CHAR | 25 | BAHNH | ||||
BAHNS | Train station | BAHNS | CHAR | 25 | BAHNH | ||||
BBBNR | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
BRSCH | Industry key | BRSCH | CHAR | 4 | Assigned to domain | BRSCH | |||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
EXABL | Indicator: Unloading points exist | EXABL | CHAR | 1 | XFELD | ||||
FAKSD | Central billing block for customer | FAKSD_X | CHAR | 2 | Assigned to domain | FAKSP | |||
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KNAZK | Working Time Calendar | KNAZK | CHAR | 2 | Assigned to domain | WFCID | |||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
KTOKD | Customer Account Group | KTOKD | CHAR | 4 | Assigned to domain | KTOKD | KGD | ||
KUKLA | Customer classification | KUKLA | CHAR | 2 | Assigned to domain | KUKLA | |||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
LIFSD | Central delivery block for the customer | LIFSD_X | CHAR | 2 | Assigned to domain | LIFSP | |||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
NIELS | Nielsen ID | NIELS | CHAR | 2 | Assigned to domain | NIELS | |||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
COUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | Assigned to domain | CITYC | |||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | Assigned to domain | ZONE | |||
XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
DEAR1 | Indicator: Competitor | DEAR1 | CHAR | 1 | XFELD | ||||
DEAR2 | Indicator: Sales partner | DEAR2 | CHAR | 1 | XFELD | ||||
DEAR3 | Indicator: Sales prospect | DEAR3 | CHAR | 1 | DEAR3 | ||||
DEAR4 | Indicator for customer type 4 | DEAR4 | CHAR | 1 | XFELD | ||||
DEAR5 | ID for default sold-to party | DEAR5 | CHAR | 1 | XFELD | ||||
GFORM | Legal status | GFORM | CHAR | 2 | Assigned to domain | GFORM | |||
BRAN1 | Industry Code 1 | BRAN1_D | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN2 | Industry code 2 | BRAN2 | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN3 | Industry code 3 | BRAN3 | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN4 | Industry code 4 | BRAN4 | CHAR | 10 | Assigned to domain | BRACO | |||
BRAN5 | Industry code 5 | BRAN5 | CHAR | 10 | Assigned to domain | BRACO | |||
EKONT | Initial contact | EKONT | CHAR | 10 | Assigned to domain | ALPHA | VBELN | ||
UMSAT | Annual sales | UMSAT | CURR | 8(2) | UMSAT | ||||
UMJAH | Year For Which Sales are Given | UMJAH | NUMC | 4 | JAHR | ||||
UWAER | Currency of sales figure | UWAER | CUKY | 5 | Assigned to domain | WAERS | |||
JMZAH | Yearly number of employees | JMZAH | NUMC | 6 | JMZAH | ||||
JMJAH | Year for which the number of employees is given | JMJAH | NUMC | 4 | JAHR | ||||
KATR1 | Attribute 1 | KATR1 | CHAR | 2 | Assigned to domain | ATTR1 | |||
KATR2 | Attribute - 2 | KATR2 | CHAR | 2 | Assigned to domain | ATTR2 | |||
KATR3 | Attribute 3 | KATR3 | CHAR | 2 | Assigned to domain | ATTR3 | |||
KATR4 | Attribute 4 | KATR4 | CHAR | 2 | Assigned to domain | ATTR4 | |||
KATR5 | Attribute 5 | KATR5 | CHAR | 2 | Assigned to domain | ATTR5 | |||
KATR6 | Attribute 6 | KATR6 | CHAR | 3 | Assigned to domain | ATTR6 | |||
KATR7 | Attribute 7 | KATR7 | CHAR | 3 | Assigned to domain | ATTR7 | |||
KATR8 | Attribute 8 | KATR8 | CHAR | 3 | Assigned to domain | ATTR8 | |||
KATR9 | Attribute 9 | KATR9 | CHAR | 3 | Assigned to domain | ATTR9 | |||
KATR10 | Attribute 10 | KATR10 | CHAR | 3 | Assigned to domain | ATTR10 | |||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
UMSA1 | Annual sales | UMSA1 | CURR | 15(2) | UMSA1 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | Assigned to domain | ABRVW | |||
INSPBYDEBI | Inspection Carried Out By Customer (No Inspection Lot) | QINSPBYDEB | CHAR | 1 | QKZ | ||||
INSPATDEBI | Inspection for a Delivery Note After Outbound Delivery | QINSPATDEB | CHAR | 1 | QKZ | ||||
KTOCD | Reference Account Group for One-Time Account (Customer) | KTOCD | CHAR | 4 | Assigned to domain | KTOKD | |||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | Assigned to domain | DTAWS | |||
DUEFL | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR | 1 | DUEFL_BKPF | ||||
HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | HZUOR | ||||
SPERZ | Payment Block | SPERZ | CHAR | 1 | XFELD | ||||
ETIKG | IS-R Labeling: customer/plant group | ETIKG | CHAR | 10 | Assigned to domain | ETIKG | |||
CIVVE | ID for mainly non-military use | CIVVE | CHAR | 1 | XFELD | ||||
MILVE | ID for mainly military use | MILVE | CHAR | 1 | XFELD | ||||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | Assigned to domain | KDKGR | |||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | Assigned to domain | KDKGR | |||
XKNZA | Indicator: Alternative payer using account number | XKNZA | CHAR | 1 | XFELD | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | Assigned to domain | J_1AFITP | |||
STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | Assigned to domain | J_1ATOID | |||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | CHAR18 | ||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | CHAR18 | ||||
STCD5 | Tax Number 5 | STCD5 | CHAR | 60 | CHAR60 | ||||
XICMS | Customer is ICMS-exempt | J_1BTCICMS | CHAR | 1 | XFELD | ||||
XXIPI | Customer is IPI-exempt | J_1BTCIPI | CHAR | 1 | XFELD | ||||
XSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST | CHAR | 3 | Assigned to domain | J_1BTCST1 | |||
CFOPC | Customer's CFOP category | J_1BINDUS1 | CHAR | 2 | ALPHA | J_1BINDUS1 | |||
TXLW1 | Tax law: ICMS | J_1BTAXLW1 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW1 | ||
TXLW2 | Tax law: IPI | J_1BTAXLW2 | CHAR | 3 | Assigned to domain | ALPHA | J_1BTAXLW2 | ||
CCC01 | Indicator for biochemical warfare for legal control | CCC01 | CHAR | 1 | XFELD | ||||
CCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | CHAR | 1 | XFELD | ||||
CCC03 | Indicator for national security for legal control | CCC03 | CHAR | 1 | XFELD | ||||
CCC04 | Indicator for missile technology for legal control | CCC04 | CHAR | 1 | XFELD | ||||
CASSD | Central sales block for customer | CASSD_X | CHAR | 2 | CASSP | ||||
KNURL | Uniform Resource Locator | URL | CHAR | 132 | TEXT132 | ||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | Assigned to domain | GESTYP | |||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | Assigned to domain | INDTYP | |||
CONFS | Status of Change Authorization (Central) | CONFS_X | CHAR | 1 | CHAR1 | ||||
UPDAT | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS | 8 | DATUM | ||||
UPTIM | Time of Last Change Confirmation | UPTIM_RF | TIMS | 6 | AS4TIME | ||||
NODEL | Central deletion block for master record | NODEL_X | CHAR | 1 | XFELD | ||||
DEAR6 | Indicator: Consumer | DEAR6 | CHAR | 1 | XFELD | ||||
SUFRAMA | Suframa Code | J_1BSUFRAMA | CHAR | 9 | J_1BSUFRAMA | ||||
RG | RG Number | J_1BRG | CHAR | 11 | J_1BRG | ||||
EXP | Issued by | J_1BEXP | CHAR | 3 | J_1BEXP | ||||
UF | State | J_1BUF | CHAR | 2 | J_1BUF | ||||
RGDATE | RG Issue Date | J_1BRGDATE | DATS | 8 | DATUM | ||||
RIC | RIC Number | J_1BRIC | NUMC | 11 | J_1BRIC | ||||
RNE | Foreign National Registration | J_1BRNE | CHAR | 10 | J_1BRNE | ||||
RNEDATE | RNE Issue Date | J_1BRNEDATE | DATS | 8 | DATUM | ||||
CNAE | CNAE | J_1BCNAE | CHAR | 7 | Assigned to domain | J_1BCNAE | |||
LEGALNAT | Legal Nature | J_1BLEGALNAT | NUMC | 4 | Assigned to domain | J_1BLEGALNAT | |||
CRTN | CRT Number | J_1BCRTN | CHAR | 1 | J_1BCRTN | ||||
ICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY | CHAR | 2 | Assigned to domain | J_1BICMSTAXPAY | |||
INDTYP | Industry Main Type | J_1BINDTYP | CHAR | 2 | Assigned to domain | J_1BINDTYP | |||
TDT | Tax Declaration Type | J_1BTDT | CHAR | 2 | Assigned to domain | J_1BTDT | |||
COMSIZE | Company Size | J_1BCOMSIZE | CHAR | 2 | Assigned to domain | J_1BCOMSIZE | |||
DECREGPC | Declaration Regimen for PIS/COFINS | J_1BDECREGPC | CHAR | 2 | Assigned to domain | J_1BDECREGPC | |||
.INCLU--AP | 0 | ||||||||
/VSO/R_PALHGT | Maximum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_BIN_HGT | QUAN | 13(3) | MENG13 | ||||
/VSO/R_PAL_UL | Unit of Length for Packaging Material (VSO) | /VSO/R_PAL_UNIT_L | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
/VSO/R_PK_MAT | Customer-Related Packing for Each Packaging Material (VSO) | /VSO/M_PACK_BY_MAT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_MATPAL | Packaging Material of the Customer in VSO | /VSO/M_MATNR_PAL | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
/VSO/R_I_NO_LYR | Number Layers Under an Inter-Pallet (VSO) | /VSO/M_IPAL_NO_LYR | NUMC | 2 | /VSO/M_IPAL_NO_LYR | ||||
/VSO/R_ONE_MAT | Packing Material-Specific for Each Packaging Material | /VSO/M_ONE_MAT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_ONE_SORT | Pack Only One Package Type for Each PKM (VSO) | /VSO/M_ONE_SORT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_ULD_SIDE | Side Preference of Loading/Unloading (VSO) | /VSO/M_UNLOAD_SIDE_PREF | NUMC | 1 | /VSO/M_SIDE_PREF | ||||
/VSO/R_LOAD_PREF | Front/Back Preference of Loading/Unloading (VSO) | /VSO/M_LOAD_PREF | NUMC | 1 | /VSO/M_LOAD_PREF | ||||
/VSO/R_DPOINT | Collective Unloading Point for VSO | /VSO/R_DELIVERYPOINT | CHAR | 10 | /VSO/R_DELIVERYPOINT | /VSO/R_SH_DPOINT | |||
.INCLU--AP | 0 | ||||||||
/XLSO/CUSTOMER | Data element to differentiate customer | /XLSO/E_CUSTOMER | CHAR | 1 | /XLSO/D_CUSTOMER | ||||
/XLSO/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
/XLSO/CLIENT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
/XLSO/PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
/XLSO/PREF_PAY | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
.INCLU--AP | 0 | ||||||||
ALC | Agency Location Code | FMFG_ALC | CHAR | 8 | Assigned to domain | FMFG_ALC | FMFG_ALC | ||
PMT_OFFICE | Payment Office | FMFG_PMT_OFF | CHAR | 5 | Assigned to domain | FMFG_PMT_OFF | FMFG_PMT_OFFICE | ||
FEE_SCHEDULE | Fee schedule | FM_FEE_SCHED | CHAR | 4 | FM_FEE_SCHED | FM_FEE_SCHEDULE | |||
DUNS | DUNS Number | FMCCRDUNS | CHAR | 9 | |||||
DUNS4 | DUNS+4 | FMCCRDUNS4 | CHAR | 4 | |||||
.INCLU--AP | 0 | ||||||||
PSOFG | Processor group | PSOFG | CHAR | 10 | Assigned to domain | PSOFG | |||
PSOIS | Subledger acct preprocessing procedure | PSOIS | CHAR | 20 | CHAR20 | ||||
PSON1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
PSON2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
PSON3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
PSOVN | First Name | PSOVN | CHAR | 35 | NAME | ||||
PSOTL | Title | PSOTL | CHAR | 20 | FMPSOTL | ||||
PSOHS | House number: is no longer used from Release 4.6B | PSOHS | CHAR | 6 | CHAR06 | ||||
PSOST | Street: No longer used from Release 4.6B | PSOST | CHAR | 28 | PSOST | ||||
PSOO1 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO2 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO3 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO4 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO5 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
.INCLU--AP | 0 | ||||||||
J_3GETYP | Recipient Type | J_3GETYP | CHAR | 2 | Assigned to domain | J_3GETYP | |||
J_3GREFTYP | Reference Type for Recipient | J_3GREFTYP | CHAR | 2 | J_3GREFTYP | ||||
PSPNR | WBS Element | PS_POSNR | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
COAUFNR | Order Number | AUFNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | ANR | |
J_3GAGEXT | External Sold-to Party | J_3GAGEXT | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
J_3GAGINT | Customer Internal Settlement | J_3GAGINT | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
J_3GAGDUMI | Dummy Recipient | J_3GDEMPST | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
J_3GAGSTDI | Standard Recipient | J_3GAGSTDI | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | Assigned to domain | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
J_3GABGLG | Retirement Date Counts for Performance-Based Equipment | J_3GABGLG | CHAR | 1 | X | ||||
J_3GABGVG | Retirement Date Counts for Time-Based Equipment | J_3GABGVG | CHAR | 1 | X | ||||
J_3GABRART | Settlement Type | J_3GABRART | CHAR | 1 | J_3GABRART | ||||
J_3GSTDMON | Hours per Month | J_3GSTDMON | DEC | 5(2) | DEC03_2 | ||||
J_3GSTDTAG | Hours per Day | J_3GSTDTAG | DEC | 5(2) | DEC03_2 | ||||
J_3GTAGMON | Number of Days/Month | J_3GTAGMON | DEC | 5(2) | DEC3_2 | ||||
J_3GZUGTAG | Function for Settlement on Acquisition Date/PBE | J_3GZUGTAG | CHAR | 1 | X | ||||
J_3GMASCHB | 'Fill PBE Documents' Indicator | J_3GMASCHB | CHAR | 1 | J_3GMASCHB | ||||
J_3GMEINSA | Indicator: Take Multiple Usage Periods into Account | J_3GMEINSA | CHAR | 1 | X | ||||
J_3GKEINSA | Indicator - Relevant to Short Operation Periods | J_3GKEINSA | CHAR | 1 | X | ||||
J_3GBLSPER | Blocking Indicator for Document Entry | J_3GBLSPER | CHAR | 1 | X | ||||
J_3GKLEIVO | Indicator: Calculate PBE as TBE | J_3GKLEIVO | CHAR | 1 | X | ||||
J_3GCALID | Calendar ID | J_3GCALID | CHAR | 2 | Assigned to domain | WFCID | |||
J_3GVMONAT | Indicator for Complete Month | J_3GVMONAT | NUMC | 1 | J_3GVMONAT | ||||
J_3GABRKEN | Settlement Indicator | J_3GABRKEN | CHAR | 1 | J_3GABRKEN | ||||
J_3GLABRECH | Date of Last Settlement | J_3GLABRECH | DATS | 8 | DATUM | ||||
J_3GAABRECH | Date of Current Settlement | J_3GAABRECH | DATS | 8 | DATUM | ||||
J_3GZUTVHLG | Ind.: Acquisition Date Counts (as Daily Settlement for PBE) | J_3GZUTVHLG | CHAR | 1 | X | ||||
J_3GNEGMEN | Negative Quantities Allowed Even for Chronolog. Inv. Mgmt | J_3GNEGMEN | CHAR | 1 | X | ||||
J_3GFRISTLO | Indicator: Deadline Logic | J_3GFRISTLO | CHAR | 1 | X | ||||
J_3GEMINBE | Minimum Usage Period for Restricted Usage (Days) | J_3GEMINBE | NUMC | 5 | NUMC | ||||
J_3GFMGUE | Release Notification Allowance for Unrestricted Usage (Days) | J_3GFMGUE | NUMC | 5 | NUMC | ||||
J_3GZUSCHUE | Surcharge for Unrestricted Usage (Days) | J_3GZUSCHUE | NUMC | 5 | NUMC | ||||
J_3GSCHPRS | Indicator: Shift Price | J_3GSCHPRS | CHAR | 1 | X | ||||
J_3GINVSTA | Status of Construction Site Inventory | J_3GINVSTA | CHAR | 1 | J_3GINVSTA | ||||
/SAPCEM/DBER | Planning Area | /SAPCEM/DBER | CHAR | 8 | Assigned to domain | /SAPCEM/DBER | |||
/SAPCEM/KVMEQ | Indicator: Settlement Qty Relevant to Equipment | /SAPCEM/KVMEQ | CHAR | 1 | /SAPCEM/KVMEQ | ||||
.INCLU--AP | 0 | ||||||||
OIDRC | Differential Reference Code (DRC) | OIC_DRC | CHAR | 5 | Assigned to domain | NUMCV | OIC_DRC | ||
.INCLU--AP | 0 | ||||||||
OID_POREQD | Purchase order required: X = Yes, Blank = No | OID_POREQD | CHAR | 1 | OI0_XFELD | ||||
.INCLU--AP | 0 | ||||||||
OIPBL | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | ALPHA | OIF_PBLNR | OI0 | OIFB | |
.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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects