topic Re: Sales data table in Application Development and Automation Discussions

Sales data table

Former Member — Fri, 25 Sep 2009 09:05:21 GMT

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

Re: Sales data table

former_member386202 — Fri, 25 Sep 2009 09:07:06 GMT

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

Re: Sales data table

Former Member — Fri, 25 Sep 2009 09:10:04 GMT

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.

Re: Sales data table

GauthamV — Fri, 25 Sep 2009 09:23:02 GMT

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

Re: Sales data table

Former Member — Thu, 05 Nov 2009 07:19:52 GMT

problem solved