Skip to Content
author's profile photo Former Member
Former Member

Report for SD module

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jun 15, 2008 at 06:47 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2008 at 07:04 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2008 at 08:01 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.