INVOICE SKRIPT

[Former Member]

Hi Gurus

Can U please give me querry based on my declarations urjent

Answers can be rewarded

DATA: BEGIN OF ITAB OCCURS 0,

CPER LIKE KNA1-NAME1,

ORDNO LIKE VBRK-VBELN,

ORDDAT LIKE VBRK-FKDAT,

INV LIKE VBAK-VBELN,

SLN TYPE N VALUE 1,

DESC(20),

QTY LIKE VBRP-FKIMG,

UNIT LIKE VBRP-VRKME,

AMNT LIKE VBRP-NETWR,

TAMNT LIKE VBRP-NETWR,

TAX LIKE VBRK-MWSBK,

TAXTYPE LIKE VBRK-J_1AFITP,

DISC LIKE KOMV-KBETR,

WRD(30),

TOT LIKE VBRP-NETWR,

PAYMT LIKE VBKD-ZTERM,

REM LIKE VBAK-AUGRU,

IMATNR LIKE VBRP-MATNR,

SORDNO LIKE VBKD-BSTKD,

KNUMV LIKE VBAK-KNUMV,

CESS LIKE KONV-KWERT,

SORDDAT LIKE VBKD-BSTDK,

IKUNNR LIKE KNA1-KUNNR,

IKWART LIKE KONV-KAWRT,

IKWERT LIKE KONV-KWERT,

IKWERT1 LIKE KONV-KWERT,

IKWERT2 LIKE KONV-KWERT,

IHREZ LIKE VBKD-IHREZ,

END OF ITAB.

DATA TAMNT TYPE P DECIMALS 2.

DATA: BEGIN OF IT_ADD OCCURS 0,

KUNNR LIKE KNA1-KUNNR,

NAME1 LIKE KNA1-NAME1,

NAME2 LIKE KNA1-NAME2,

ADD LIKE KNA1-STRAS,

CITY LIKE KNA1-ORT01,

POC LIKE KNA1-PSTLZ,

NAME3 LIKE vbak-bname,

START-OF-SELECTION.

SELECTION-SCREEN : BEGIN OF BLOCK BLK1 WITH FRAME TITLE TEXT-001.

PARAMETERS : P_VBELN LIKE VBRK-VBELN OBLIGATORY MATCHCODE

OBJECT VMCF.

SELECTION-SCREEN : END OF BLOCK BLK1.

[Former Member]

You have not given the selection screen .

But I assume you can start selecting the data from VBRK & VBRP .. and based on the previous document field [Reference doc. (VGBEL)] ... then based on the sales document select the customer details from kna1 or knvv table .

Hope this helps.

assign points if it helps.

-Gaurang

Message was edited by:

gaurang kotecha

[Former Member]

Hi,

yesterday this query was answered by different people.

Don't repeat the same questions.

and at the same time, without proper complete requirement, how do you expect the people to give you word by word/line by line code

refer to the sample code provided yesterday and write the query..

regards,

ANJI