invoice date

[Former Member]

hi,

i want to get the invoice date.but i got the invoice number and invoice quantity from RSEG table.

the following is my coding.

DATA BKTXT(12).

SELECT * FROM ZGATEP INTO CORRESPONDING FIELDS OF TABLE ITAB2

WHERE ZDATE IN ZDATE

AND WERKS IN WERKS

AND GTEN IN GTEN.

LOOP AT ITAB2.

CLEAR BKTXT.

MOVE ITAB2-GTEN TO BKTXT.

SHIFT BKTXT LEFT DELETING LEADING '0'.

SELECT * FROM MKPF WHERE BKTXT = BKTXT.

• AND BUDAT = ITAB1-DDATE.

IF SY-SUBRC EQ '0'.

SELECT * FROM MSEG WHERE WERKS IN WERKS

AND MBLNR = MKPF-MBLNR

AND MJAHR = MKPF-MJAHR

AND LIFNR = ITAB2-LIFNR

AND SHKZG = 'S'

AND BWART = '101'.

SELECT SINGLE * FROM RSEG WHERE EBELN = ITAB2-EBELN.

• SELECT SINGLE BLDAT FROM BKPF INTO ITAB2-BLDAT WHERE

• GJAHR = ITAB2-GJAHR.

IF SY-SUBRC EQ '0'.

MOVE MKPF-MBLNR TO ITAB2-MBLNR.

MOVE MKPF-MJAHR TO ITAB2-MJAHR.

MOVE MKPF-XBLNR TO ITAB2-XBLNR.

MOVE RSEG-BELNR TO ITAB2-BELNR.

MOVE RSEG-BPMNG TO ITAB2-BPMNG.

• MOVE BKPF-BLDAT TO ITAB2-BLDAT.

ITAB2-BUKRS = MSEG-BUKRS.

ITAB2-WERKS = MSEG-WERKS.

ITAB2-BSTMG = MSEG-BSTMG.

ITAB2-MEINS = MSEG-MEINS.

ITAB2-EBELN = MSEG-EBELN.

MODIFY ITAB2.

MOVE-CORRESPONDING ITAB2 TO ITAB.

MOVE ITAB2-GTEN TO ITAB3-GTEN.

APPEND ITAB.

APPEND ITAB3.

CLEAR ITAB.

ENDIF.

ENDSELECT.

ENDIF.

• ENDIF.

ENDSELECT.

• ENDSELECT.

ENDLOOP.

[Former Member]

hi,

please b specific what u want exactly.

u want invoice date?

u wil get all invoicing data from vbrk, vbrp .........

[Former Member]

i need invoice date based on the invoice document number that is from ME23N

[Former Member]

in which tab invoice no. is coming? inme23n.

so that i wil help u?

[Former Member]

in purchase order history tab

[GauthamV]

Table : RBKP.

field : BLDAT.

[Former Member]

u r talking about reference no. indat tab.

if s then goto LIKP.

there pass that ref no. and get erdat.

U mean to say Delivery No. ?

coz LIKP = SD Document: Delivery Header Data

[Former Member]

Hi Gautham,

Thank you.i got the output.

[GauthamV]

But you had assigned points to someone else.

[Former Member]

i have assigned to you only.

[Former Member]

.

[GauthamV]

You have the option to change it even after once you assign.

Plz check once again.

[Former Member]

sorry by tension i have given the point to someone

[Former Member]

u can change ur opinion again. dnt worry. means assigned him some other marks and 10 marks to correct answer

[Former Member]

if u know,tell me the option.so that i can change

[Former Member]

u can change the before answered option to very helpful or helpful option and make the Gautham reply Correct.

u can give 6 marks to two persons , 10 marks to only one and 2 marks to all. just click ont corresponding radio button.

[Former Member]

if u know,tell me the option.so that i can change

[GauthamV]

This message was moderated.

[Former Member]

Hi

u will get the Date From MKPF table field is BUDAT

or also from MSEG .

regds

SACHHi

[Former Member]

Hi Sharmila,

U can get it from rbkp ....

Thanks

Karthik