I_FldLogsStockItems

Field Logistics : Stock Items | view: IFLSTKITMS | TRAN | Extraction: Not supported | Component: Goods Receipt
Tables used: LIKP, LIPS, MATDOC, EKKO, EKPO, EKET, MCH1, MCHA, FLOG_INSPCODE, MARC, TCUCH, FLOG_PLANT
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
DeliveryDocument null
DeliveryDocumentItem null
MaterialDocument Number of Material Document
MaterialDocumentItem Material Document Item
MaterialDocumentYear Material Document Year
Column Name Description
💲 Currency Key (DocumentCurrency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
OpenQtyInPurchaseOrderUnit null
GoodsReceiptQuantity Purchase Order Quantity
FldLogsDelivQty null
FldLogsGRQty Quantity
ActualDeliveryQuantity Actual quantity delivered (in sales units)
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
FldLogsBlockedQty Purchase Order Quantity
FldLogsTotalReceivedQty Purchase Order Quantity
FldLogsPOTotalQty Purchase Order Quantity
Column Name Description
DeliveryDate null
PostingDate Posting Date in the Document
DocumentDate Document Date in Document
ManufactureDate Date of Manufacture
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
Column Name Description
QltyMgmtInProcmtIsActive Boolean Variable (X = True, - = False, Space = Unknown) Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
StockType Stock Type Show values
FldLogsProcRecRcvgStatus Process Receipts - Receving status Show values
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
FldLogsSuplrItemVislInspCode Supplier Item Visual Inspection Code Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
GoodsMovementStatus Goods Movement Status (Item) Show values
FldLogsStatus Field Logistics Indicator Show values
DistrStatusByDecentralizedWrhs Distribution Status (Decentralized Warehouse Processing) Show values
Column Name Description Domain name
PurchaseRequisition Purchase Requisition Number BANFN
FldLogsPurOrdItem null
FldLogsDelivDocItem null
StorageLocation null
DocumentReferenceID Reference Document Number XBLNR1
InventoryStockTypeName Stock Type Name DDTEXT
GoodsMovementType Movement type (inventory management) BWART
InventoryValuationType Valuation Type BWTAR
ReversedMaterialDocument null
FldLogsMsgTxt Message Text TEXT100
Batch Batch Number CHARG
CreatedByUser User Name XUBNAME
MaterialDocumentHeaderText Document Header Text TEXT25
DeliveryDocumentBySupplier External Identification of Delivery Note TEXT35
UnloadingPointName Unloading Point TEXT25
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • I_FLDLOGSSTOCKITEMS.MANDT == TCURC.MANDT
  • I_FLDLOGSSTOCKITEMS.DOCUMENTCURRENCY == TCURC.WAERS
Loading Point
  • Client
  • Loading Point
  • ?
  • I_FLDLOGSSTOCKITEMS.MANDT == TVLA.MANDT
  • I_FLDLOGSSTOCKITEMS.LOADINGPOINT == TVLA.LSTEL
  • I_FLDLOGSSTOCKITEMS.[column in domain "VSTEL"] == TVLA.VSTEL
Material Number
  • Client
  • Material Number
  • I_FLDLOGSSTOCKITEMS.MANDT == MARA.MANDT
  • I_FLDLOGSSTOCKITEMS.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_FLDLOGSSTOCKITEMS.MANDT == T023.MANDT
  • I_FLDLOGSSTOCKITEMS.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • I_FLDLOGSSTOCKITEMS.MANDT == T006.MANDT
  • I_FLDLOGSSTOCKITEMS.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • I_FLDLOGSSTOCKITEMS.MANDT == T001W.MANDT
  • I_FLDLOGSSTOCKITEMS.PLANT == T001W.WERKS
Supplier
  • Supplier
  • Client
  • I_FLDLOGSSTOCKITEMS.SUPPLIER == LFA1.LIFNR
  • I_FLDLOGSSTOCKITEMS.MANDT == LFA1.MANDT