09-19-2007 7:52 AM
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 ®ARDS,
KALYAN.
[
09-19-2007 7:55 AM
all the fields are available in header details are available in vbak
item details are availble in vbap....
reward points if helpful...
thanks,
velu....
09-19-2007 8:33 AM
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
09-19-2007 11:25 AM
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.