Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

I want SD fields .

Former Member

‎2007 Sep 13 11:24 AM

0 Likes
1,428

Hi ALL,

I want fields for :

Invoice date

Sales Order date

Gross amount

Net amount.

If anyone knows tell me form which table to take all these fields.

Thanks,

Regards,

Vinod.R.

Hi ALL,

I want fields for :

Invoice date

Sales Order date

Gross amount

Net amount.

If anyone knows tell me form which table to take all these fields.

Thanks,

Regards,

Vinod.R.

Reply
7 REPLIES 7
Read only

Former Member

‎2007 Sep 13 11:25 AM

0 Likes
1,365

Hi

goto VBAK

for invoice no of the order goto VBFA and get the invoice number of the sales order

pass the relevant document for the same

fields are ERDAT, NETPR, and NETWR

regards

Shiva

Read only

Former Member

‎2007 Sep 13 11:27 AM

0 Likes
1,365

goto se80

|

click on repository information system

|

expand ABAP Dictionary

|

expand fields

|

double click on table fields

on the right side of the screen enter the fieldname/description of the field and press execute to find the tables where the field is present. once you get into one table you can know the others by clicking on the where used list.

regards,

srinivas

Read only

RaymondGiuseppi
Active Contributor

‎2007 Sep 13 11:28 AM

0 Likes
1,365

Take a look at <a href="http://www.erpgenie.com/abap/tables_sd.htm">Sales and Distribution Tables</a>

Regards

Read only

Former Member

‎2007 Sep 13 11:49 AM

0 Likes
1,365

Invoice date: VBRK-FKDAT (Billing date for billing index and printout)

Sales Order date: VBAK-ERDAT / AUDAT

Gross amount: VBRP-KZWI1

Net amount. : VBRK-NETWR 9Net value in document currency) or VBRP-NETWR

Read only

Former Member

‎2007 Sep 13 1:03 PM

0 Likes
1,365

Hi,

Check VBAK and VBFA table.

Reward if useful.

Read only

Former Member

‎2007 Sep 13 2:00 PM

0 Likes
1,365

Hi,

VBRK - FKDAT Invoice date

VBAK - ERDAT Sales Order date

VBRK - NETWR Net Amount and

for Gross Amount, u have to get KNUMV field value from VBRK, pass these value to KONV table and get value from field KBETR.

Reward if useful.

Message was edited by:

Sathyaa

Read only

Former Member

‎2007 Sep 13 2:03 PM

0 Likes
1,365

Important Tables for SAP SD

Sales and Distribution:

Table Description

Customers KNA1 General Data

KNB1 Customer Master – Co. Code Data (payment method, reconciliation acct)

KNB4 Customer Payment History

KNB5 Customer Master – Dunning info

KNBK Customer Master Bank Data

KNKA Customer Master Credit Mgmt.

KNKK Customer Master Credit Control Area Data (credit limits)

KNVV Sales Area Data (terms, order probability)

KNVI Customer Master Tax Indicator

KNVP Partner Function key

KNVD Output type

KNVS Customer Master Ship Data

KLPA Customer/Vendor Link

Sales Documents VBAKUK VBAK + VBUK

VBUK Header Status and Administrative Data

VBAK Sales Document - Header Data

VBKD Sales Document - Business Data

VBUP Item Status

VBAP Sales Document - Item Data

VBPA Partners

VBFA Document Flow

VBEP Sales Document Schedule Line

VBBE Sales Requirements: Individual Records

SD Delivery DocumeLIPS Delivery Document item data, includes referencing PO

LIKP Delivery Document Header data

Billing Document VBRK Billing Document Header

VBRP Billing Document Item

SD Shipping Unit VEKP Shipping Unit Item (Content)

VEPO Shipping Unit Header

Cheers

VJ