Item details for a given Invoice..????

[Former Member]

How to get item level details for an invoice , when an invoice number is given.

now am searching in VBAP Table for item level details in which iam not able to get the details (like delivery expected date)

could lease suggest any Function Modules which returns the item level details.

[Former Member]

Hi ,

see below tables and relation ships. it may give clear idea about how to connect invoice to order item details.

VBAK: Sales Document (Header Data) (VBELN)

VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)

Enquiry, Quotation, Sales Order are differentiated based on Doc.

Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,

for Quotation 'B' & for Order it is 'C'.)

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

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

Sales orders to Delivery Link

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

VTTK: Shipment Table (Header Data) (TKNUM)

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

Delivery to Shipping Link

(VTTP-VBELN = LIKP-VBELN)

VTFA: Shipping Document Flow(TKNUM,VBELV,VBELN)

VTPA: Shipping Partners data(VBELN,PARVW,KUNNR,PERNR)

VTTS: Stages in Shipment(TKNUM,TSNUM,TSTYP)

VTSP: Transport Stage/Shipment Item Allocation(TKNUM,TSNUM,TPNUM)

VEKP: Handling Unit: Header(Packing)(VENUM,VSTEL)

VEPO: Handling Unit: Item (Packing)(VENUM,VEPOS,VBELN)

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

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

Invoice to Sales order Link

(VBRP-AUBEL = VBAP-VBELN, VBRP-AUPOS = VBAP-POSNR).

Invoice to Delivery Link

(VBRP-VGBEL = LIPS-VBELN, VBRP-VBPOS = LIPS-POSNR)

Regards,

Vishvesh

[venkatasriram_mygapula]

hi

VBRK invoice header data,

VBRP invoice items data,

VBFA document flow data,

LIKP delivery header data,

LIPS delivery items data.

[Former Member]

hi

ru using the standard print program for invoice then u will get all the info in IS_BIL_INVOICE is type LBBIL_INVOICE.

or if u want to get the details form database table then LIKP and LIPS(item) contais deliver related info and

VBRK and VBRP(item) contains INIVOICE details

VBRP-VGBEL = DELIVERY HEADER NUMBER

VBRP-VGPOS = DELIVERY ITEM NUMBER.

if u want get the dilivery details then select the data from lips however u ahve deliver y number

[Former Member]

Hi Naresh,

Do you also know if what transaparent tables are used in transactions va41, va42 and va43?

I need to get the values under the Conditions tab> Pricing elements of the Item specifically the Price Amount with Condition Type YPRO.

Thanks so much!

Regards,

Reymar

[Former Member]

Hi Kalam,

The invoice header details are there in VBRK and corresponding ITEM details U can get from VBRP

regards

Avi....

[Former Member]

Hi,

If you want have delivery details with invoice number. Go with the following links

1: GET VGBEL, VGPOS FROM VBRP BASED ON vbrp-VBELN = INVOICE NUMBER.

2: GET YOUR DELIVERY DETAILS FROM LIPS TABLE BASED ON

VBELN = VBRP-VGBEL

VGPOS = VBRP-VGPOS:

Br,

Laxmi

[Former Member]

Hi!

Use VBRP table instead of VBAP.

Regards

Tamá