CMS_STR_INV_MAP_GET_MLT SAP (MAPI: GET: Structure for Inventory details) Structure details

Dictionary Type: Structure
Description: MAPI: GET: Structure for Inventory details




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




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

CMS_STR_INV_MAP_GET_MLT 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 "MAPI: GET: Structure for Inventory details" 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_CMS_STR_INV_MAP_GET_MLT TYPE CMS_STR_INV_MAP_GET_MLT.

The CMS_STR_INV_MAP_GET_MLT table consists of various fields, each holding specific information or linking keys about MAPI: GET: Structure for Inventory details data available in SAP. These include MOV_GUID (GUID for CMS_MOVABLES), MOV_CATEGORY (Object Category), MOV_TYP (Movable types), MOV_ID (Identification Number).. 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: Not classified


SAP CMS_STR_INV_MAP_GET_MLT 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
MOV_GUIDGUID for CMS_MOVABLES CMS_DTE_MOV_GUIDRAW16SYSUUIDCMS_MOV_OBJ_GUID
MOV_CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6TCMS_MOV_TYPCMS_OBJ_CAT
MOV_TYPMovable types CMS_DTE_MOV_TYPCHAR6TCMS_MOV_TYPCMS_MOV_TYP
MOV_IDIdentification Number CMS_DTE_MOV_IDCHAR40ALPHACMS_MOV_IDCMS_SRCH_ACR
MOV_CAT_NAMEObject Category Name CMS_DTE_OMS_CAT_NAMECHAR40CMS_OMS_CAT_NAME
MOV_TYP_NAMEName in a specified language CMS_DTE_MOV_TYP_NAMECHAR40CMS_MOV_NAME
MOV_DESCDescription of the object CMS_DTE_MOV_DESCCHAR30CMS_MOV_DESC
MOV_IDT_ACCIdentification accessories CMS_DTE_MOV_IDT_ACCCHAR1CMS_MOV_IDT_ACC
MOV_MODEL_NAMTechnical Category/Category term/Description CMS_DTE_MOV_MODEL_NAMCHAR30CMS_MOV_MODEL_NAM
MOV_MANUFACTURERObject Manufacturer Builder CMS_DTE_MOV_MANUFACTURERCHAR30CMS_MOV_MANUFACTURER
MOV_MANU_DAT Date of the Manufacture/Purchase CMS_DTE_MOV_MANU_DATDATS8CMS_MOV_MANU_DAT
ADDR_IDLocation / Address CMS_DTE_MOV_LOCATIONCHAR10Assigned to domainALPHAAD_ADDRNUMADMC
MOV_LOC_DESCLocation Description CMS_DTE_MOV_LOC_DESCCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
MOV_LOC_DE_RMRKRemark Field for Location Description CMS_DTE_MOV_LOC_DESC_RMRKCHAR30CMS_MOV_LOC_DESC_RMRK
MOV_IDEN_TYPType of identification / Marking of the collateral material CMS_DTE_MOV_TYPE_IDENTCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
MOV_DESC_COL_MATBank's Own Identifcation CMS_DTE_OMS_DESC_IDENT_COL_MATCHAR30CMS_OMS_DESC_COL_MAT
MOV_DOPDate of Purchase CMS_DTE_MOV_DOPDATS8CMS_MOV_DOP
MOV_IDENTCommercial usage CMS_DTE_MOV_IDENTCHAR2CMS_MOV_IDENT
MOV_UOBUse of the object CMS_DTE_MOV_UOBCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
MOV_MANU_CNTRYManufacturing Country CMS_DTE_MOV_MANU_CNTRYCHAR3T005LAND1
MOV_TYPE_FEATClassification CMS_DTE_MOV_TYPE_FEATCHAR6TCMS_OMS_FEATCMS_MOV_TYPE_FEAT
EXT_ITM_NOExt. Item no / Number for identification of the objects CMS_DTE_OMS_EXT_ITM_NOCHAR40ALPHACMS_OMS_ID
EXT_REFERENCEReference number for the legacy system CMS_DTE_OMS_REF_IDCHAR32CMS_OMS_REFID
IS_TEMPLATEType to be used as template CMS_DTE_MOV_FLG_TEMPLATECHAR1CMS_MOV_FLG
TEMPLATE_IDTemplate ID CMS_DTE_MOV_TEMPLATE_IDRAW16SYSUUID
CATEGORYObject Category CMS_DTE_OMS_OBJ_CATCHAR6Assigned to domainCMS_OBJ_CAT
CATEGORY_NAMEObject Category Name CMS_DTE_OMS_CAT_NAMECHAR40CMS_OMS_CAT_NAME
TYPEMovable types CMS_DTE_MOV_TYPCHAR6Assigned to domainCMS_MOV_TYP
TYPE_NAMEName in a specified language CMS_DTE_MOV_TYP_NAMECHAR40CMS_MOV_NAME
IDENTIFICATIONIdentification Number CMS_DTE_MOV_IDCHAR40ALPHACMS_MOV_IDCMS_SRCH_ACR
MOV_DESCRIPTIONDescription of the object CMS_DTE_MOV_DESCCHAR30CMS_MOV_DESC
DESCRIPTIONDescription CMS_DTE_AST_DESCCHAR30CMS_DSC
OBJECT_REF_IDReference ID for the object CMS_DTE_OBJ_REFIDCHAR40CMS_OBJ_REFID
OBJECT_TYPNot used CMS_DTE_OBJ_TYPCHAR32CMS_OBJ_TYP
COUNTRY_KEYIdentification Key for Country CMS_DTE_AST_COUNTRY_KEYCHAR3Assigned to domainLAND1
RISK_CODERisk Code CMS_DTE_RISK_CODECHAR6Assigned to domainCMS_RISK_CODE
SFTY_INDIndicates if the Asset has a Default Safety Discount CMS_DTE_IND_SFTY_DISCCHAR2CMS_IND_SFTY
SFTY_DSCNTPercentage of Safety Discount CMS_DTE_SAFETY_DSCNTDEC10(6) CMS_SFTY_PCT
SFTY_AMOUNTAmount of Safety Discount CMS_DTE_SAFETY_AMTCURR17(2) CMS_AMOUNT
SFTY_AMT_CURRCurrency of the Safety Discount Amount CMS_DTE_SAFETY_AMT_CURRCUKY5TCURCWAERS
OBJSYSIDObject System Reference ID CMS_DTE_OBJ_SYSIDCHAR6CMS_SYSCMS_OBJSYSTEMIDCMS_OBJ_SYS
VALUATION_TYPType of Valuation Check performed on Collateral Object CMS_DTE_IND_VALN_TYPCHAR2CMS_VALN_TYP
UNIT_VALN_FREQIndicator: Units of time for revaluation of an asset CMS_DTE_IND_AST_VALN_FREQ_UNITCHAR2CMS_IND_AST_VALN_FREQ_UNIT
PERIOD_VALN_FREQRevaluation Period for an Asset CMS_DTE_AST_VALN_FREQ_PERIODNUMC4CMS_AST_VALN_FREQ_PERIOD
PAST_VALUED_DATELast Date on which the Asset was Valued CMS_DTE_VALN_DATEDATS8CMS_DATE
START_DATEDate on which the First Valuation is Performed on the Asset CMS_DTE_START_DATEDATS8CMS_DATE
END_DATEDate on which the Last Valuation is Performed on the Asset CMS_DTE_END_DATEDATS8CMS_DATE
LENDING_RATE_INDIndicator to specify if Asset has a Default Lending Rate CMS_DTE_IND_LND_RTECHAR2CMS_IND_LRTE
LENDING_RATE1Lending Rate 1 CMS_DTE_LRTE_PCT1DEC10(6) CMS_PCT
LENDING_RATE2Lending Rate 2 CMS_DTE_LRTE_PCT2DEC10(6) CMS_PCT
LENDING_RATE3Lending Rate 3 CMS_DTE_LRTE_PCT3DEC10(6) CMS_PCT
LENDING_RATE4Lending Rate 4 CMS_DTE_LRTE_PCT4DEC10(6) CMS_PCT
LENDING_RATE5Lending Rate 5 CMS_DTE_LRTE_PCT5DEC10(6) CMS_PCT
LIQD_TYPLiquidation Type CMS_DTE_LIQD_TYPCHAR6CMS_TYPCMS_AST_LIQTYP
LIQD_REASONLiquidation Reason CMS_DTE_ATT_ID_TY_AST004CHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
LIQD_DATEDate on which the Collateral was Liquidated CMS_DTE_LIQD_DATEDATS8CMS_DATE
LIQD_AMTReturns from the Liquidation of Collateral CMS_DTE_LIQD_VALUECURR17(2) CMS_AMOUNT
LIQD_CURRCurrency of Liquidation Value CMS_DTE_LIQD_CURRCUKY5TCURCWAERS
EXP_PRCD_AMNTExpected Proceed Amount CMS_DTE_LIQ_EXP_PRCD_AMOUNTCURR17(2) CMS_AMOUNT
EXP_PRCD_CURRCurrency: Expected Proceed CMS_DTE_LIQ_EXP_PRCD_CURRCUKY5TCURCWAERS
EXP_ACC_DATEExpected accrual date CMS_DTE_LIQ_EXP_ACCRUAL_DATEDATS8CMS_DATE
ACC_NUMBER_LIQAccount number for liquidation proceeds CMS_DTE_LIQ_ACC_NUMBERCHAR35BANKN35
BANK_CNTRY_LIQBank country key CMS_DTE_LIQ_BNK_CTRY_KYCHAR3T005LAND1
BANK_KEY_LIQBank Key CMS_DTE_LIQ_BNK_KEYCHAR15BANKKBNK
BANK_CTRLKEY_LIQBank Control Key BKONTCHAR2BKONT
UNIT_VERF_FREQIndicator: Units of time for verification of an asset CMS_DTE_IND_AST_VERF_FREQ_UNITCHAR2CMS_IND_AST_VERF_FREQ_UNIT
PERIOD_VERF_FREQStatement Period for an Asset CMS_DTE_AST_VERF_FREQ_PERIODNUMC4CMS_AST_VERF_FREQ_PERIOD
LAST_VERF_DATELast Verification Date CMS_DTE_AST_VERF_DATEDATS8CMS_DATE
AST_GUIDGUID for Table CMS_AST CMS_DTE_AST_GUIDRAW16SYSUUID
AST_TYPAsset Type CMS_DTE_AST_TYPCHAR6Assigned to domainCMS_AST_TYPCMS_AST_TYPCMS_AST_TYP
PARENT_GUIDAsset Guid as a parent GUID for a sub-asset CMS_DTE_SAS_PAR_GUIDRAW16SYSUUID
NOM_VALUENominal Value of the Asset CMS_DTE_AST_NOMINAL_VALUECURR17(2) CMS_AMOUNT
NOM_VALUE_CURRCurrency of Nominal value CMS_DTE_AST_NOMINAL_VALUE_CURRCUKY5TCURCWAERS
AST_VALUEFinal Asset Value CMS_DTE_AST_VALUECURR17(2) CMS_AMOUNT
AST_VALUE_CURRCurrency of the Final Asset Value CMS_DTE_AST_VALUE_CURRCUKY5TCURCWAERS
QUANTITYQuantity CMS_DTE_QTYQUAN13(3) CMS_QTY
UNIT_OF_MEASUREUnit of Measure of Quantity CMS_DTE_UNITUNIT3T006CUNITMEINS
REC_ATAsset Value Recording Timestamp CMS_DTE_REC_ATDEC15TZNTSTMPS
PUR_PRICEPurchase Price of the Asset CMS_DTE_AST_PURCHASE_PRICECURR17(2) CMS_AMOUNT
PUR_PRICE_CURRCurrency of Purchase Price CMS_DTE_AST_PUR_PRICE_CURRCUKY5TCURCWAERS
PUR_DATEDate of Purchase CMS_DTE_AST_PUR_PRICE_DATEDATS8CMS_DATE
ADMIN_ORG_UNITAdministration Organizational Unit CMS_DTE_ADMINORGCHAR12TEXT12CMS_ADMINORG
BANKAREABank Area in Collateral Management CMS_DTE_BANKAREACHAR4Assigned to domainCMS_BANKAREACMS_BANKAREA
ORG_UNIT1Organizational Unit 1 CMS_DTE_ORG_UNIT1CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT2Organizational Unit 2 CMS_DTE_ORG_UNIT2CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT3Organizational Unit 3 CMS_DTE_ORG_UNIT3CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT4Organizational Unit 4 CMS_DTE_ORG_UNIT4CHAR10Assigned to domainCMS_ORG_UNIT
ORG_UNIT5Organizational Unit 5 CMS_DTE_ORG_UNIT5CHAR10Assigned to domainCMS_ORG_UNIT
IDEN_ACC Identification land accessories CMS_DTE_INV_IDEN_ACCCHAR1ALPHACMS_SEC_FLG
BILL_NOBill number of the inventory CMS_DTE_INV_BILL_NOCHAR20CMS_INV_BILL_NO
UNIT_PRICEUnit Price CMS_DTE_INV_UNIT_PRICECURR17(2) CMS_AMOUNT
UNIT_PRICE_CURRCurrency for unit price CMS_DTE_INV_UNIT_CURRCUKY5TCURCWAERS
TYPE_STK_EXCHType of stock exchange CMS_DTE_INV_TYPE_STK_EXCHCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
STK_EXCH_IDPlace of stock exchange CMS_DTE_INV_STK_EXCH_IDCHAR6TCMS_ATT_ID_TYCMS_ATT_ID_TYP
RATE_FIX_DATDate of previous quotation CMS_DTE_INV_RATE_FIX_DATDATS8DATUM
DET_PRICEDetermined price CMS_DTE_INV_DET_PRICECURR17(2) CMS_AMOUNT
DET_CURRCurrency for determined price CMS_DTE_INV_DET_CURRCUKY5TCURCWAERS
STOCK_QUANTITYQuantity of inventory CMS_DTE_INV_QTYQUAN13(3) CMS_QTY
STOCK_UOMUnit of Measure of Quantity CMS_DTE_UNITUNIT3T006CUNITMEINS
CREATED_BYLogin ID of the User who created the Record CMS_DTE_USERCHAR12CMS_USER
CREATED_ATCreation Timestamp CMS_DTE_CREATED_ATDEC15TZNTSTMPS
CHANGED_BYLast Changed By CMS_DTE_LAST_CHNG_USERCHAR12CMS_USER
CHANGED_ATChange Timestamp CMS_DTE_CHANGED_ATDEC15TZNTSTMPS
SOURCEOFENTRYSource of Entry CMS_DTE_SOURCE_OF_ENTRYCHAR32CMS_SOURCE

Key field Non-key field



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

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

How to access SAP table CMS_STR_INV_MAP_GET_MLT

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