reg:tables

[Former Member]

Hi,

Please help me. I am an mm guy. I need to develop a report. In that i need some tables.

1. table which contain " open sales order number "

2. table which contain material and customer number .

3. delivery date

4. quantity.

Please help me .

Regards,

Usha.

[Former Member · Accepted solution]

Hi

Tcode VA05 gives list of open sales order or to check the open sales order number.. pls go to document flow tabel VBFA here you will the document status from there you put condition (VKORG, document type etc) and retrive the sales document number.

For Materila VBAP and customer VBAK

And Delivery date and Quantity VBEP.

If possible rewards

BR

Lee

[aramsum]

Hi Usha rani,

Customer Material Info record table- KNMT

Open sales order number-- You can fetch the data from VBUK Table

Delivery date-- VBAK(REQUESTED DELIVERY DATE)

RV45A-ETDAT(SCHEDULE LINE DATE) .Please note that this is a structure(RV45A)

Qunatity-VBAP

Regards

Ram Pedarla

Edited by: RamPedarla on Aug 26, 2009 4:12 PM

[former_member188076]

Hi

For checking the status of any SD document go to Table VBUK

For Material Code and Name check the table VBAP

For Customer Code and Name VBAK

If you want actual Post Goods Issue date then go to LIKP, else you can check it through VBAP only.

Regards

Amitesh