F_Mmim_Findmatdoch

Read Material Documents | view: FMMIMFINDMATDOCH | Extraction: Not supported | Component: Inventory Management
Tables used: MATDOCMARAPRPS
Column Name Description
MaterialDocument Number of Material Document
MaterialDocumentYear Material Document Year
MaterialDocumentItem Item in Material Document
StockChangeType Stock change type Show values
StockChangeContext Stock change context Show values
Column Name Description
Column Name Description
📏 Unit of entry (EntryUnit):
QuantityInEntryUnit Quantity in unit of entry
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
CreationTime Time of Entry
Column Name Description
StockChangeType Stock change type Show values
StockChangeContext Stock change context Show values
IsCancelled Item has been Cancelled Show values
IsAutomaticallyCreated Item automatically created Show values
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated Show values
IssuingOrReceivingStockType Receiving/Issuing Stock Type of Goods Movement Show values
DebitCreditCode Debit/Credit Indicator Show values
ConsumptionPosting Consumption posting Show values
GoodsMovementRefDocType Movement Indicator Show values
GoodsReceiptType Receipt Indicator Show values
Column Name Description Domain name
StockChangeSelectionType null
CalculatedStockChangeTypeName Short Text for Fixed Values DDTEXT
CalculatedStockChangeType null
DocumentTitle null
Material Material in Respect of Which Stock is Managed MATNR
Plant Plant WERKS
Batch Batch Number of Warehouse Stock (Stock Identifier) CHARG
StorageLocation Storage location LGORT
Supplier Supplier to be Supplied/Who is to Receive Delivery LIFNR
SalesOrder Sales Order Number VBELN
SalesOrderItem Description for Sales Order Item MMIM_SALES_ORDER_ITEM
WBSElementInternalID Work Breakdown Structure Element (WBS Element) PS_POSNR
WBSElement Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
Customer Account number of customer KUNNR
GoodsMovementType Movement type (inventory management) BWART
InventorySpecialStockType Special Stock Indicator SOBKZ
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
PersonnelNumber Description for Personnel Number MMIM_PERSONNEL_NUMBER
DocumentItemText Item Text TEXT50
GoodsMovementReasonCode Reason for Movement CHAR04
CreatedByUser User Name XUBNAME
AccountingDocumentType Document Type BLART
InventoryTransactionType Transaction/Event Type VGART
DocumentReferenceId Reference Document Number XBLNR1
BillOfLading Number of Bill of Lading at Time of Goods Receipt XBLNR1
MaterialDocumentHeaderText Document Header Text TEXT25
AcctAssignmentCategory Account Assignment Category KNTTP
GLAccount G/L Account Number SAKNR
HasMultipleAccountAssignment null
MasterFixedAsset Main Asset Number ANLN1
FixedAsset Asset Subnumber ANLN2
CompanyCode Company Code BUKRS
FunctionalArea Functional Area FKBER
ProfitCenter Profit Center PRCTR
PurchaseOrder Purchasing Document EBELN
PurchaseOrderItem Description for Purchase Order Item MMIM_PURCHASE_ORDER_ITEM
DeliveryDocument Delivery VBELN
DeliveryDocumentItem Description for Delivery Item MMIM_DELIVERY_ITEM
CostCenter Cost Center KOSTL
ControllingArea Controlling Area CACCD
OrderID Order Number AUFNR
IssuingOrReceivingMaterial Receiving/Issuing Material MATNR
IssuingOrReceivingPlant Receiving plant/issuing plant WERKS
IssuingOrReceivingStorageLoc Receiving/issuing storage location LGORT
WhseGoodsMovementDocument Warehouse Document for Goods Movement /SCWM/TANUM
Warehouse Warehouse Number/Warehouse Complex /SCWM/LGNUM
StockSegment Stock Segment SGT_SRCA
ProductSeasonYear Season Year FSH_CJAHR
ProductSeason Season RFM_SAISO
ProductCollection Fashion Collection FSH_COLLECTION
ProductTheme Fashion Theme FSH_THEME
ProductCharacteristic1 Characteristic Value for Colors of Variants WRF_ATWRT
ProductCharacteristic2 Characteristic Value for Main Sizes of Variants WRF_ATWRT
ProductCharacteristic3 Characteristic Value for Second Size for Variants WRF_ATWRT
ProdCharc1InternalNumber Internal Charactieristic Number for Color Characteristics ATINN
ProdCharc2InternalNumber Internal Char. Number for Characteristics for Main Sizes ATINN
ProdCharc3InternalNumber Internal Char. Number for Characteristics for Second Sizes ATINN
Master Data Relations Join Conditions
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • F_MMIM_FINDMATDOCH.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • F_MMIM_FINDMATDOCH.MANDT == MARA.MANDT