Application Development 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
Showing results for 
Search instead for 
Did you mean: 

fields w.r.t tables

Former Member
0 Kudos

Hi Experts,

im kalyan. i want the fields w.r.t. the tables . i can post my fields . This is related to SD .

main criteria of this object is to generate the UNINVOICED SHIPMENT LIST

1 Sold to Party : Sold to Party -

2 Name : Ship to Party Name-

3 Sales Order : Sales Order Number

4 Material :Material code

5 Description :Material description

6 SO Date :Sales order Date

7 Qty : Undelivered Quantity

8 SSID : Sales man ID

9 Bill to Party :

10 Delivery Order :

11 Line : Sales Order line

12 Unit Price :

13 Gross Amt :

14 Net Value :

15 Delivery Date :

THANKS &REGARDS,

KALYAN.

[

3 REPLIES 3

Former Member
0 Kudos

all the fields are available in header details are available in vbak

item details are availble in vbap....

reward points if helpful...

thanks,

velu....

Former Member
0 Kudos

VBAK_KUNNR

KNA1-NAME1 relate the same with VBAK-KUNNR = KNA1-KUNNR

VBAK-VBELN

VBAP-MATNR

MAKT-MAKTX RELATE VBAP-MATNR = MAKT-MATNR

VBAK-BUDAT

FOR THE REST CHECK WITH THE NAME

VBAK/ VBAP SALES TABLES

LIKP/LIPS DELIVERY TABLES

VBRK/VBRP BILLING TABLES

Get Back in case of query

reward if useful.

Amit Singla

Former Member
0 Kudos

sold to party : : KUAGV-KUNNR

Ship to party : :KUWEV-KUNNR

SALES ORDER NO.SALES ORDER NUMBER:VBAP-AUFNR

MATERIAL CODE : :RV45A-MABNR

MATERIAL DESCRIPTION : :VBAP-ARKTX

QTY : DELIVERED QTY :RV45A-VSMNG

BILL TO PARTY : :KURGV-KUNNR

UNIT PRICE : :VBAP-NETPR

GROSS AMT : :VBAP-BRGEW

NET VALUE : :VBAP-NETWR

DELIVERY DATE : :RV45A-ETDAT

Hope this will meet your requirement.