topic Re: I want SD fields . in Application Development and Automation Discussions

I want SD fields .

Former Member — Thu, 13 Sep 2007 10:24:07 GMT

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.

Re: I want SD fields .

Former Member — Thu, 13 Sep 2007 10:25:19 GMT

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

Re: I want SD fields .

Former Member — Thu, 13 Sep 2007 10:27:23 GMT

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

Re: I want SD fields .

RaymondGiuseppi — Thu, 13 Sep 2007 10:28:22 GMT

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

Regards

Re: I want SD fields .

Former Member — Thu, 13 Sep 2007 10:49:50 GMT

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

Re: I want SD fields .

Former Member — Thu, 13 Sep 2007 12:03:22 GMT

Hi,

Check VBAK and VBFA table.

Reward if useful.

Re: I want SD fields .

Former Member — Thu, 13 Sep 2007 13:00:15 GMT

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

Re: I want SD fields .

Former Member — Thu, 13 Sep 2007 13:03:54 GMT

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