General Sales Register

[Former Member]

Hi Friends,

Can anyone provide the Tables and fields for general sales register. this report we would like to take from billing document.This regiseter is for material items, not for service items.

It would be more helpful for me if u can provide information about capturing of reversal(Cancellation) documents also

Following are the fields which iam using in the report.

Input

Document Dates

Bill to Party

Material

Output

Doc No

Sr.No (Sr.No with in the document items)

Bill to Party

Sales Type

Sales org

Distri Chl

Division

Delivery Plant

Material

Description

Quantity

Rate (Excl Taxes)

Gross Total (NetTax-DisExp)

Net Amount (Qty X Rate)

Tax Column1

Tax Column2

Tax Column3

Discount

Expenses

Round Off

[Former Member · Accepted solution]

Hi

the values you are required you can get from the following tables

VBRK - Header data for billing documents

VBRP - Item data for billing documents

KONV - Condition types table for billing documents and sales document

you have to take the link between VBRK and KONV tables then you will get all the condition types

Regards

vardhan

[Former Member]

Hi

Just make a query using t.code (sq03, sq02, sq01) using table join option for tables VBRP, VBRK , KNA1. choose the desired fields for screen selection & report

Further for the Rate add local field with formula rate= total amount / total qty

For cancelled billing document check for the VBRK-FKSTO field

Regards

Tejpal

[Former Member]

u can best acheiev it thru SIS thru user defined infostructures.

regards

suresh sangoju

[Lakshmipathi]

Check the Tables VBRK and VBRP where you can find all the required details listed by you.

thanks

G. Lakshmipathi