SAP tables for non-batch stock

[former_member804727]

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.

[Abinathsiva]

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.

[former_member804727]

Thanks abishankar,

Can you tell me which parameter input the material type or material group in table EKBE ？

[Abinathsiva]

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