topic Re: Material Document number using invoice document number in Application Development and Automation Discussions

Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 07:27:01 GMT

The work item will provide to my program the material document number if the document has been created in Material document OR the invoice document number in the other cases.

My program has to identify which number has been provided and if it is the Material document it will find out the invoice Number. if it is invoice number it will set the Material document number field as blank.

how can i identify whether it is Material Document number or FI Document number

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 07:28:44 GMT

how can i identify whether it is Material Document number or FI Document number

if it is an Material Document number than it should be in MKPF or MSEG.and if FI Document number than it should be in BSEG.

check this.

Amit.

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 07:38:55 GMT

Is there any standard Function Module to find out FI Document number using Material Document number?

let me know is there any Function module available to identify these Material Document number or FI Document number?

Is there any standard Function Module to find out all the details ( such as Invoice date, vendor, amout, tax amount , payment due date, payment terms , approver) using invoice document number.

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 07:56:33 GMT

please use this Fm BAPI_INCOMINGINVOICE_GETLIST to get detail list of Invoice .

Regrads

Hitesh

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 07:57:45 GMT

check out field bkpf-awkey.

its a concatenation of material doc num and fiscal year and its found in bkpf (FI-related table) .

that will help u lot.

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 08:09:54 GMT

I wanted to find out invoice document number(BKPF-BELNR) using invoice logistic number( RBKP-BELNR)

Let me know is there any standard function module ?

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 08:21:48 GMT

Hi,

Concatinate RBKP-BELNR AND RBKP-GJAHR

and pass this concatinated value to BKPF-AWKEY

Then you will get the BKPF-BELNR

<removed by moderator>

Edited by: Mike Pokraka on Aug 4, 2008 9:38 AM

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 08:35:09 GMT

Thank you.

Now my question is

I am receiving one document number from work item to my program.

Is there any process to identify whether is it invoice document number from BKP or is it from invoce logistic number ( RBKP)

Re: Material Document number using invoice document number

Former Member — Mon, 04 Aug 2008 08:51:58 GMT

check the number series. the doc number series will be different for those from BKPF and those from RBKP.