on 2023 Jul 20 4:24 AM
Hi guys,
I have a requirement to get agingg days for all materials from sap,I can look up batch stock from table MCHB and last receipt date from MCHA.
But How can I get non-batch stock and last receipt date.
Can anybody tell me the exact table?
Thanks.
Hi Ivan,
Based on material type/material group of non batch materials, read EKBE with VGABE parameter and movement type 101 is the way to fetch Purchased materials, for Production order based material inward Date range MSEG movement type 101 to be considered.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
VGABE = '1' - since it's goods receipt.
1 Goods Receipt
2 Invoice Receipt
3 Subseq. Debit/Credit
4 Down Payment
5 Payment
6 Goods Issue for Stock Transfer
7 Consumption (Subcontracting)
8 Delivery (Stock Transfer)
9 Service Entry Sheet
A Down Payment Request
C Down Payment Clearing
Q Comparison for Internally Posted Material (Only IS-OIL)
R Return Delivery via Delivery Note
P Invoice Parking
V Down Payment Request Clearing
S Service Entry Sheet in SAP S/4HANA
User | Count |
---|---|
100 | |
10 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.