cancel
Showing results for 
Search instead for 
Did you mean: 

SAP tables for non-batch stock

0 Kudos
773

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Abinathsiva
Active Contributor
0 Kudos

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.

0 Kudos

Thanks abishankar,

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

Abinathsiva
Active Contributor
0 Kudos

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