Sales data table

[Former Member]

Hello Experts,

I have requirement where in selection screen i have to give input like sales org, distrubution channel, division,sales office, sales group, material no range and customer number range. so based on the input it should take all the material for particular material in that sales org. which sales table i have to use for data retrival.

Regards,

Siri

[former_member386202]

Hi,

Check following tables

TABLES : vbak, "Sales Document: Header Data

vbrk, "Billing: Header Data

vbrp, "Billing: Item Data

vbpa, "Sales Document: Partner

lips, "SD doc: Delivery: Item data

mkpf, "Header: Material Document

mseg, "Document Segment: Material

konv. "Conditions (Trans Data)

Regards,

Prashant

[Former Member]

the header table is VBAK,

so you will get sales org, customer kind of things from VBAK.

and the line item table is VBAP

here you will get materials per line item. as each line can get different materials

open these tables in SE11 and search your fields..

you can refer to all VB* tables.

[GauthamV]

Plz SEARCH in SCN before posting, you will get lot of posts on VBAK,VBAP tables.

[Former Member]

problem solved