Report for SD module

[Former Member]

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.

[ritesh_dugad2]

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

[Former Member]

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

[Former Member]

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