topic Re: Report for SD module in Application Development and Automation Discussions

Report for SD module

Former Member — Sat, 14 Jun 2008 16:59:57 GMT

Hi Guys,

I am working on a report in SD module. The Name of my report is "SALES-THIS PERIOD-LAST PERIOD" where I have to calculate the last preriod revenue , total revenue, and % variance of the revenue.

can anybody expalin what are the tables and fields are available for this report.

Re: Report for SD module

ritesh_dugad2 — Sun, 15 Jun 2008 06:47:02 GMT

You have to use tables for Billing VBRK and VBRP along with Sales Order Table VBAK, VBAP, and Document Flow table VBFA.

Re: Report for SD module

Former Member — Sun, 15 Jun 2008 07:04:53 GMT

Hi,

According to your technical spec you have to use the following tables.

konv, likp, lips, vbak, vbap, vbbe, vbbh, vbep, vbfa, vblp, vblk, vbpa, vbrk, vbuk, vbrp, vbup, vekp, vepo, vepeg. All these are SD tables.

Thanks and regards,

Sarada

Re: Report for SD module

Former Member — Sun, 15 Jun 2008 08:01:43 GMT

Hi,

You can ask your functional people what are the required fields to develop a report below are the table.

customer related tables:

KNA1 Customer master General Data

KNB1 Customer Master – Co. Code Data

KNKK Customer Master Credit Control Area Data

KNVV Sales Area Data

KNVI Customer Master Tax Indicator

KNVP Partner Function

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

Sales Documents

VBAK Sales Document - Header Data

VBAP Sales Document - Item Data

VBUK Header Status and Administrative Data

VBKD Sales Document - Business Data

VBUP Item Status

VBPA Partners

VBFA Document Flow

VBEP Sales Document Schedule Line

VBBE Sales Requirements: Individual Records

Delivery Document

LIKP Delivery header table

LIPS Delivery item table

Billing document:

VBRK Billing document header table

VBRP Billing Document Item table

Shipping

VEKP Shipping Header Table

VEPO Shipping Item Table

Thanks

VIkranth