cancel
Showing results for 
Search instead for 
Did you mean: 

Suggest Tables plz

Former Member
0 Kudos

I need to find tables for the following data

Outbound Data (pickup all where the Goods issues are done) -

1.Comp.Code

2.Date (goods issue data)

3.Prod.Hier (F or P)

4.Material#

5.Division

6.Sales Orgn

7.Sales Order#

8.Transfer Order No

9.Shipment#

10.Delivery #

11.Invoice#

12.Route

13. Vol.Iss

14.UOM

15.WT Iss

16.UOM

17.Iss.Qty

18.UOM

20.Iss.Master Cartons (look out for alternative UOM; with MC to base uom), leave it blank if the MC is missing in Alt UOM

21UOM (always MC)

22.Plant

23.SoldTo#

24.ShipTo#

26.Shipto - Country

27.Shipto - State

29.Shipto - Zip

30.Shipto - CCar

31.Shipto - Carrier

32.Shipto - Inco Terms

33.Shipping Condition

34.Route

Please suggest .

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

check these tables

LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)

LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)

(LIPS-VGBEL = VBAP-VBELN, LIPS-VGPOS = VBAP-POSNR)

VTTK: Shipment Table (Header Data)(TKNUM)

VTTP: Shipment Table (Item Data)( TKNUM,TPNUM,VBELN)

(VTTP-VBELN = LIPS-VBELN)

VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)

VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)

(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)

VBPA: Partner functions Data(VBELN,PARVW,KUNNR,LIFNR)

Take the Partner Numbers based on the function

KNA1 and ADRC

for getting the Sold To and Shipto Addresses

EKKO-- Purchase Order Data (Header)(EBELN,BSTYP,BSART)

EKPO-- Purchase Order Data (Item)(EBELN,EBELP,MATNR)

MKPF-- GRN Data (Header) (EBELN,BLDAT,BUDAT,XBLNR,BKTXT)

MSEG-- GRN Data (Item)(MBLNR,BWART,LIFNR,MATNR,EBELN)

Reward points for useful Answers

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Answers (1)

Answers (1)

Former Member
0 Kudos

LIKP,LIPS-- All most all of data in these tables

LTAK-Transfer order using your delivey no

VBPA-For Carrier info

ADRC-For Addres data(get ADRNR FROM VBPA)

For invoice # use (VBFA or VBRP)

Siva