Material Document number using invoice document number

[Former Member]

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

[former_member181995]

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.

[Former Member]

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.

[Former Member]

Hi

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

Regrads

Hitesh

[former_member184657]

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.

pk

[Former Member]

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 ?

[Former Member]

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

[Former Member]

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)

[former_member184657]

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

pk