Hi Fatih,
Please try the following:
Stock/Requirements List IDoc
Definition
IDoc LOISTD01 is used to pass the stock/requirements list at the material-plant level. The external system needs to read through the IDoc and extract the information it needs. One IDoc includes all the information for one material-plant list.
Structure
E1MDSTL Master Material stock (MDSTA)
E1PLSEL Master Material planning segment (MDPS)
E1MDPSL Master Stock Demand List (MDPS)
E1MDSTL
Fields
Format
Length
Description
MATNR
CHAR
18
Material number
WERKS
CHAR
4
Plant
PLSCN
NUMC
3
Planning scenario in long-term planning
EINME
CHAR
15
Restricted-use stock
EISBE
CHAR
14
Safety stock
INSME
CHAR
15
Stock in quality inspection
KEINM
CHAR
15
Restricted-use consignment stock
KINSM
CHAR
15
Consignment stock in quality inspection
KLABS
CHAR
15
Unrestricted use consignment stock
KSPEM
CHAR
15
Blocked consignment stock
LABST
CHAR
15
Valuated stock with unrestricted use
RETME
CHAR
15
Stock returns
SPEME
CHAR
15
Blocked stock
TRAME
CHAR
15
Stock in transit
UMLMC
CHAR
15
Stock in transfer
E1PLSEL
Fields
Format
Length
Description
PLAAB
NUMC
2
Material requirements planning segment
PLANR
CHAR
20
Planning segment number
KDAUF
CHAR
10
Sales order number
KDPOS
NUMC
6
Item number in sales order
LGORT
CHAR
4
Storage location
PSPEL
CHAR
24
Internal project item number
E1MDPSL
Fields
Format
Length
Description
AUFVR
CHAR
10
Source number for order
BAUGR
CHAR
18
Material number of higher-level assembly
BESKZ
CHAR
1
Procurement type
DAT00
DATS
8
Receipt/ Requirements date
DAT01
DATS
8
Delivery/order finish date
DAT02
DATS
8
Start/release date
DEL12
CHAR
12
MRP element number
DELKZ
CHAR
2
MRP element indicator
DELET
NUMC
4
Scheduling number planning element
DELNR
CHAR
10
MRP element number
DELPS
NUMC
6
MRP element item
EINVR
NUMC
4
Source schedule line number
KDAUF
CHAR
10
Sales order number
KDPOS
NUMC
6
Item number in sales order
LGORT
CHAR
4
Storage location
MNG01
CHAR
15
Quantity reserved or quantity required
MNG02
CHAR
15
Quantity in-transit
PLUMI
CHAR
1
Receipt/ issue indicator
POSVR
NUMC
6
Source item number
PSPEL
CHAR
24
Character field length 24
SOBES
CHAR
1
Special procurement type
VERID
CHAR
4
Production version
VRFKZ
CHAR
1
Availability indicator
WEBAZ
CHAR
5
R/2 table
WRK02
CHAR
4
Production plant in planned order
KUNNR
CHAR
10
Customer number
AUART
CHAR
4
Sales document type
FIX01
CHAR
1
Indicator: fixing lot size in planned order
Fields with asterisks are only available in 3.1H. FIX01=u2019Xu2019 when the planned order is firmed.
The most important field is DELKZ, which determines what type of MRP element is being dealt with for internal processing. The external system should use this flag to distinguish between the different MRP elements and extract the ones it needs.
'AR' Dependent reservation
'BA' Purchase requisition
'BB' Provided material requirement
'BE' Schedule order item
'BP' Gross requirements planning
'BR' Process order
'CH' Batch requirements
'FE' Production order
'FH' End of planning time fence
'IM' Actual goods receipt quantity
'KB' Individual customer stock
'KD' Customer independent requirements
'LA' Shipping notification
'LB' Batch/warehouse stock
'LC' Batch/warehouse stock
'LE' Delivery schedule
'MB' Material issues
'MR' Reservation
'NE' Collective order
'PA' Planned order
'PB' Project stock
'PP' Planned independent requirements
'PR' Forecast requirements
'QM' Inspection lot for quality management
'S2' Simulated requirements from availability check
'SA' Simulation order
'SB' Dependent requirements
'SI' Simulation requirements
'SM' Simulation dependent requirements
'TB' Transfer requirements WMS
'U2' Release order for a stock transfer requisition
'U3' Transfer requirements for simulation order
'U4' Release order for stock transport scheduling agreement
'UB' Unplanned requirements
'UL' Reservation in another plant
'UR' Stock transfer reservation
'VA' RFQ
'VB' Quotation
'VC' Order
'VE' Scheduling agreement
'MS' Direct production
'VG' Contract
'VI' Delivery w/o charge
'VJ' Delivery
'VP' Planned independent requirements
'VW' External sales order
'WA' Goods issue
'WB' Plant stock
'WE' Goods receipt
'WH' End replenishment period
'VF' Scheduling agreement
'KK' Consignment stock for customer (availability check)
'VT' Returns (availability check)
'E1' Subcontracting purchasing
'RP' Returns item
When goods are issued at the supplying plant for a stock transport order, the order is termed in-transit until the goods are received at the destination plant. The stock/requirements list at the supplying plant no longer includes this order, but it remains in the stock/requirements list of the destination plant with E1MDPSL-DELKZ = u2018U1u2019. When IDoc LOISTD is created, the in-transit quantity is written into E1MDPSL-MNG02, and quantity listed in MNG01 is the original requested quantity.
There are several date fields in the segment E1MDPSL. DAT01 records the stock available date, which takes the GR processing time into account. DAT02 contains the order finish date for a planned order and delivery date for a requisition. DAT03 contains the production start date for internally-produced material and release date for externally-procured material.
When the aggregation feature of the program RMCPAMRP is selected, sales orders will aggregate per customer per day at material-plant level. Sales order numbers are suppressed.
Hope it helps!
Thanks!
Preethi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.