CDS Views for Inventory Management (MM-IM)

CDS View NameDescriptionSQL View Name
F0_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and Value by Key DateF0MMIM_MATSTVAL
F1_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and Value by Key DateF1MMIM_MATSTVAL
F2_MMIM_BATCHMAT_VHHelp-View for batches with materialF2MMIMBATCHMATVH
F2_MMIM_CUSTOMER_VHHelp-View for customersF2MMIMCUSTOMERVH
F2_MMIM_DELIVERY_VHHelp-View for deliveriesF2MMIMDELIVERYVH
F2_MMIM_IR_PLANT_VHHelp-View for issuing and receiving PlantsF2MMIMIRPLANTVH
F2_MMIM_IR_STOCKTYP_VHHelp-View for issuing and receiving stock typeF2MMIMIRSTOTYPVH
F2_MMIM_IR_STORLOC_VHHelp-View for issuing and receiving storage locationsF2MMIMIRSTORLOVH
F2_MMIM_MATDOC_NR_VHHelp-View for material documentsF2MMIMMATDOCNRVH
F2_MMIM_MATDOC_NR_VH2Help-View for material documentsF2MMIMMATDCNRVH2
F2_MMIM_MATPRODHY_VHHelp-View for product hierarchyF2MMIMMATPROHYVH
F2_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and Value by Key DateF2MMIM_MATSTVAL
F2_MMIM_ORDERITEM_VHValue Help Order ItemsF2MMIMORDITMVH
F2_MMIM_PLANT_VHHelp-View for PlantsF2MMIMPLANTVH
F2_MMIM_PO_VHHelp-View for purchase ordersF2MMIMPOVH
F2_MMIM_REASONCTGoodsmovement Reason Code TextsF2MMIMREASONCT
F2_MMIM_REASONC_VHGoodsmovement Reason CodeF2MMIMREASONCVH
F2_MMIM_SOBKZ_VHHelp View Inventory Special Stock TypeF2MMIMSOBKZVH
F2_MMIM_SORDER_VHHelp-View for sales ordersF2MMIMSORDERVH
F2_MMIM_STORLOC_VHHelp-view for storage locationsF2MMIMSTORLOCVH
F2_MMIM_SUPPLIER_VHHelp-View for suppliersF2MIMSUPPLIERVH
F2_MMIM_UOM_VHHelp-View for unit of measurementsF2MMIMUOMVH
F2_MMIM_USER_VHHelp-View for UsersF2MIMUSERVH
F2_MMIM_WBSELEMENT_VHHelp View for WBSElementsF2MMIMWBSELEMTVH
F2_MMIM_WORKITEM_VHHelp View for Work ItemsF2MMIMWORKITEMVH
F3_MMIM_CUSTOMER_VHHelp-View for Customers (KNA1)F3MMIMCUSTOMERVH
F3_MMIM_DELIVERY_VHHelp-View for delivery (LIKP)F3MMIMDELIVERYVH
F3_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and ValueF3MMIM_MATSTVAL
F3_MMIM_PERS_VHHelp View for Personnel NumberF3MMIMPERSVH
F3_MMIM_PO_VHHelp-View Purchase Orders (EKKO)F3MMIMPOVH
F3_MMIM_REASONCTGoodsmovement Reason Code TextsF3MMIMREASONCT
F3_MMIM_SORDER_VHHelp-View Sales Order (VBAK)F3MMIMSORDERVH
F3_MMIM_SUPPLIER_VHHelp-View Supplier (LFA1)F3MMIMSUPPLIERVH
F51_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and ValueF51MMIM_MATSTVAL
F52_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and ValueF52MMIM_MATSTVAL
F5_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and Value by Key DateF5MMIM_MATSTVAL
FB_MMIM_MATSTOCKQUANVALBYDATEMaterial Stock Quantity and Value by Key DateFBMMIM_MATSTVAL
F_MMIM_ACDOCA_ELERead Universal Journal Entry Line ItemsFMMIMACDOCAELE
F_MMIM_BATCHMAT_VHHelp-View for batches with materialFMMIMBATCHMATVH
F_MMIM_BLARTAccounting Document TypeFMMIMBLART
F_MMIM_BLART_VHHelp-View Accounting Document TypesFMMIMBLARTVH
F_MMIM_BUKRS_PLANTCompany Code for PlantsF_MMIMBUKRSPLANT
F_MMIM_CALCCHTYPTCalculated Change TypeFMMIMCALCHTYPT
F_MMIM_CALCSELTYPTCalculated Change Selection TypeFMMIMCALCSELTYPT
F_MMIM_CHGCONHelp-View for Stock Change ContextFMMIMCHGCON
F_MMIM_CHGCONTHelp-View for Stock Change ContextFMMIMCHGCONT
F_MMIM_CHGTYPEHelp-View for Stock Change TypeFMMIMSTCHGTYPE
F_MMIM_CHGTYPETHelp-View for Stock Change TypeFMMIMSTCHGTYPET
F_MMIM_CUSTOMER_VHHelp-View for customersFMMIMCUSTOMERVH
F_MMIM_DELIVERY_VHHelp-View for deliveriesFMMIMDELIVERYVH
F_MMIM_FINDMATDOCRead Material DocumentsFMMIMFINDMATDOC
F_MMIM_FINDMATDOCHRead Material DocumentsFMMIMFINDMATDOCH
F_MMIM_GMTYPE_VH2Help-View for goods movement typesFMMIMGMTYPEVH2
F_MMIM_GR4PO_VALGR_STOCKValuated blocked stock for purchase orderFMMIMVALBLSTOCK
F_MMIM_IR_PLANT_VH2Help-View for Issuing and Receiving PlantsFMMIMIRPLANTVH2
F_MMIM_IR_STOCKTYP_VH2Help-View for issuing and receiving stock typeFMMIMIRSTOTYPVH2
F_MMIM_IR_STORLOC_VHHelp-View for issuing and receiving storage locationsFMMIMIRSTORLOCVH
F_MMIM_I_MATERIAL_VHHelp-View for Material (MATDOC based)FMMIMIMATERIALVH
F_MMIM_MARC_DVALHelp View Null Values for Stock (Material,Plant)F_MMIMMARCDVAL
F_MMIM_MARD_DVALHelp View Null Values for StockF_MMIMMARDDVAL
F_MMIM_MATDESC_VH2help-View Material Number/Material DescriptionFMMIMMATDESCVH2
F_MMIM_MATDOCHelp-View for material documentsFMMIMMATDOC
F_MMIM_MATDOC_ITEMMatdoc ItemsFMMIMATDOCITEM
F_MMIM_MATDOC_ITEM_ACCOUNTAccounting information Material DocumentFMMIMMATDITMACC
F_MMIM_MATDOC_ITEM_COUNTCounter for Material Document ItemsFMMIMMDOCITCOUNT
F_MMIM_MATDOC_ITEM_HMatdoc ItemsFMMIMMATDOCITEMH
F_MMIM_MATDOC_ITEM_H2Matdoc ItemsFMMIMMATDITEMH2
F_MMIM_MATDOC_ITEM_HAMatdoc ItemsFMMIMMATDOCITMHA
F_MMIM_MATDOC_ITEM_HMMatdoc Items Multi AccountingFMMIMMATDOCITMHM
F_MMIM_MATDOC_NR_VHHelp-View for material document numberFMMIMMATDOCNRVH
F_MMIM_MATDOC_NR_VH2Help-View for material document numberFMMIMMATDOCNRVH2
F_MMIM_MATDOC_SUPPLIERHelp-View for Supplier from MATDOCFMATDOCSUB
F_MMIM_MATDOC_UNIONRead Material Documents depending on selection typeFMMIMMATDOCUNION
F_MMIM_MATDOC_YEAR_VHHelp-View for material document yearFMMIMMDOCYEARVH
F_MMIM_MATELEMENTHelp-View MaterialFMMIMMATELMENT
F_MMIM_MATGRP_ELERead Material Groups from Material DocumentsFMMIMMATGRPELE
F_MMIM_MATGRP_VHHelp-View Material by material groupFMMIMMATGRPVH
F_MMIM_MATGRP_VH2Help-View Material GroupsFMMIMMATGRPVH2
F_MMIM_MATHLP_VHHelp-View for materialFMMIMMATHLPVH
F_MMIM_MATPLDESC_VH2Help-View Plant Material by DescriptionFMMIMPLDESCVH2
F_MMIM_MATPRODHY_VHHelp-View Material by product hierarchyFMMIMMATPRODHYVH
F_MMIM_MATPRODHY_VH2Help-View Material by Product HierarchyFMMIMMATPRDHYVH2
F_MMIM_MATTYP_ELERead Material Types from Material DocumentsFMMIMMATTYPELE
F_MMIM_MATTYP_VHHelp-View Material by material TypeFMMIMMATTYPVH
F_MMIM_MATTYP_VH2Help-View Material by Material TypeFMMIMMATTYPVH2
F_MMIM_MAT_VHHelp-View for material generalFMMIMMATVH
F_MMIM_MBEW_PLANTInventory Valuation Type from MBEWF_MMIMMBEWPLANT
F_MMIM_MCHA_DVALHelp View Null Values for Stock (Material,Batch, Plant)F_MMIMMCHADVAL
F_MMIM_MCHB_DVALHelp View Null Values for StockF_MMIMMCHBDVAL
F_MMIM_MDOC_IT_COUNTERMaterial Documents Item CounterFMMIMMDOCITCT
F_MMIM_MDOC_REVSTATMaterial Documents Reversed StatusFMMIMMREVSTAT
F_MMIM_MDOC_REV_IT_COUNTCounter for reversed Material Document ItemsFMMIMMDOCREVITCT
F_MMIM_MVKE_SALES_VHHelp-View sales data for materialFMMIMMVKESALESVH
F_MMIM_ORDERITEM_VHValue Help Order ItemsFMMIMORDITMVH
F_MMIM_PERS_VHHelp View for Personnel NumberFMMIMPERSVH
F_MMIM_PLANT_VH2Help-View for PlantsFMMIMPLANTVH2
F_MMIM_PO_VHHelp-View for purchase ordersFMMIMPOVH
F_MMIM_REASONC_VHGoodsmovement Reason CodeFMMIMREASONCVH
F_MMIM_SOBKZ_VHValue Help Inventory Special Stock TypeFMMIMSOBKZVH
F_MMIM_SORDER_UNIONHelp-View for Sales Order UnionFMMIMSORDERUN
F_MMIM_SORDER_VHHelp-View for sales ordersFMMIMSORDERVH
F_MMIM_STOCKTYPE_VH2Help-View for Stock TypesFMMIMSTOCKTYPVH2
F_MMIM_STOCK_CHG_TYPE_VHHelp-View for Stock Change TypeFMMIMSTCHGTYPEVH
F_MMIM_STORLOC_VHHelp-View for storage locationsFMMIMSTORLOCVH
F_MMIM_SUPPLIER_UNIONHelp-View for Supplier UnionFMIMSUPPLIERUN
F_MMIM_SUPPLIER_VHHelp-View for suppliersFMMIMSUPPLIERVH
F_MMIM_T001L_AUTHStorage Location AuthorityFMMIMT001LAUTH
F_MMIM_T156TGoods Movement Type Long TextFMMIMT156T
F_MMIM_UOM_VHHelp-View for unit of measurementsFMMIMUOMVH
F_MMIM_UOM_VH2Help-View for unit of measurementFMMIMUOMVH2
F_MMIM_USER_VHHelp-View for usersFMMIMUSERVH
F_MMIM_WBSELEMENT_UNIONHelp-View for WBS Element UnionFMMIMWBSELEMTUN
F_MMIM_WBSELEMENT_VHValue Help for WBS ElementsFMMIMWBSELEMTVH
F_MMIM_WORKITEM_VHHelp View for WorkitemsFMMIMWORKITEMVH
F_MMIM_YES_NOYes and No selectionFMMIMYESNO
F_MMIM_YES_NO_TEXTYes and No selection textFMMMIMYESNOTEXT
F_MMM_DOCFLOWMaterial Documents Reference DocumentsFMMIMDOCFLOW
F_MMM_DOCFLOW_LNKMaterial Documents Reference DocumentsFMMIMDOCFLOWLNK
I_CYCLECOUNTINGSETTINGSCycle Counting Settings exposedICYCCOUNTSET
I_INVENTORYCNSMPNGROUPDESCVHValue Help Text for Inventory Consumption GroupsIINVTCONSGRPDESC
I_INVENTORYCNSMPNGROUPVHValue Help for Inventory Consumption GroupsIINVTCONSGRPVH
MMIMBATCHESVHValue Help for BatchesMMIMBATCHVH
MMIMINVENTSPECIALSTOCKTYPEVHValue Help for Inventory Special Stock TypeMMIMINVSPECSTTVH
MMIMPRODUCTIONORDERVHValue Help for Production PlantsMMIMPRODORDVH
MMIMSALESORDERVHValue Help for Sales OrdersMMIMSALESORDVH
MMIMSUPPLIERGENERALVHValue Help for Supplier generalMMIMSUPPLGENVH
MMIMSUPPLIERMATERIALVHValue Help for Supplier by MaterialMMIMSUPPLMATLVH
MMIMWBSELEMENTVHValue Help for WBS ElementMMIMWBSELEMVH
MMIM_INBOUND_DELIVERY_ITEMSHelp-View for Inbound Delivery ItemsMMIMINBDELITEMS
MMIM_INBOUND_DELIVERY_VHHelp-View for Inbound DeliveryMMIMINBDELIVVH
MMIM_PURCHASE_DOCUMENT_UNIONHelp-View for Union of Purchase DocumentsMMIMUNIONPURDOC
MMIM_PURCHASE_DOCUMENT_VHHelp-View for Purchase DocumentsMMIMPURDOCVH
MMIM_PURCHASE_ORDER_ITEMSHelp-View for Items of Purchaset OrderMMIMPURORDITEMS
MMIM_PURCHASING_DOCUMENT_TYPESHelp-View for Purchasing Document TypesMMIMPURDOCTYPES
MMIM_SEARCH_PURCHASE_DOCUMENTHelp-View for Search of Purchase DocumentMMIMSEARCHPURDOC
MMIM_STANDARD_PURCHASE_ORD_VHHelp-View for Items of Standard Purchaset OrderMMIMSTANDPOVH
MMIM_SUPPLIER_NAMEGet Supplier NameMMIMSUPLDATA
MMIM_TRANSPORT_ORDER_VHHelp-View for Transport OrderMMIMTRANSORDVH
NSDM_DDL_CHK_MAT_MASTERCheck for missing material master data vs. MATDOC_EXTRACTNSDM_V_CHK_MD_MM
P_MATLDOCPLNTAUTHZNRead Plants for F4 HelpPMDPLNTAUTHZN
P_MMIM_PLANT_M_BEST_WRK_01Plants with authority M_BEST_WRK activity 01PPLANTBESTWRK01
P_MMIM_PLANT_M_MSEG_WWA_01Plants with authority M_MSEG_WWA activity 01PPLANTMSEGWWA01
P_MMIM_PURDOCTY_M_BEST_BSA_01Purchasing Doc. T. /w auth. M_BEST_BSA activity 01 or 09PPURDMBESTBSA01
P_MMIM_PURGRP_M_BEST_EKG_01Purchasing Grp. with authority M_BEST_EKG activity 01 or 09PPURGMBESTEKG01
P_MMIM_PURORG_M_BEST_EKO_01Purchasing Org. with authority M_BEST_EKO activity 01 or 09PPUROMBESTEKO01
P_MMIM_STOLOC_M_MSEG_LGO_01Storage locations with authority M_MSEG_LGO activity 01PSTOLOMSEGLGO01
P_MMIM_VALUATIONTYPEVHValue Help for Valuation Types in Material DocumentsPMMIMVALTYP_VH
P_MMIM_WBSELEMENTVALUEHELPValue Help for WBS ElementsPMMIMWBSELEM_VH
SHSM_RESBCDS View replacing RESB in search helpSHSMRESB
V_MMIM_DDL_OBD_POHISTShow Outbound Deliveries from PO historyV_OBD_POHIST
V_MMIM_DDL_SIT_PO_IVSShow issuing valuated stock in transit for a POV_PO_SIT_IVS