topic Re: invoice date in Application Development and Automation Discussions

invoice date

Former Member — Wed, 25 Mar 2009 10:30:53 GMT

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.

Re: invoice date

Former Member — Wed, 25 Mar 2009 10:40:27 GMT

hi,

please b specific what u want exactly.

u want invoice date?

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

Re: invoice date

Former Member — Wed, 25 Mar 2009 10:42:53 GMT

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

Re: invoice date

Former Member — Wed, 25 Mar 2009 10:45:25 GMT

u will get the Date From MKPF table field is BUDAT

or also from MSEG .

regds

SACHHi

Re: invoice date

Former Member — Wed, 25 Mar 2009 10:47:16 GMT

in which tab invoice no. is coming? inme23n.

so that i wil help u?

Re: invoice date

Former Member — Wed, 25 Mar 2009 10:51:11 GMT

in purchase order history tab

Re: invoice date

GauthamV — Wed, 25 Mar 2009 10:52:19 GMT

Table : RBKP.

field : BLDAT.

Re: invoice date

Former Member — Wed, 25 Mar 2009 10:57:40 GMT

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

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:01:06 GMT

Hi Gautham,

Thank you.i got the output.

Re: invoice date

GauthamV — Wed, 25 Mar 2009 11:03:02 GMT

But you had assigned points to someone else.

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:24:30 GMT

i have assigned to you only.

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:26:38 GMT

Re: invoice date

GauthamV — Wed, 25 Mar 2009 11:26:52 GMT

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

Plz check once again.

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:27:21 GMT

sorry by tension i have given the point to someone

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:31:22 GMT

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

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:32:50 GMT

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

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:35:43 GMT

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.

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:35:52 GMT

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

Re: invoice date

GauthamV — Wed, 25 Mar 2009 11:36:08 GMT

This message was moderated.

Re: invoice date

Former Member — Wed, 25 Mar 2009 11:54:25 GMT

Hi Sharmila,

U can get it from rbkp ....

Thanks

Karthik