Find out if the Sale is invoiced or not

[Former Member]

Hi Gurus,

I have been working on a Sales Reporting project where I am using 2_LIS11, 2LIS_12 and 2_LIS13 datasources to extract data from SD to BW.

I need to find a way to distinguish sales if it is an invoiced sales or not.

Do you now if there is an indication field that can help me to clarify if the sale is invoiced or not?

What could be another way to clarify this point?

Thanks.

[Former Member · Accepted solution]

Hello,

One way could be checking the Billing extractor and see if which billing document has got the sales dcument field populated and the SD document category for those documents is of type sales document.

There are various indicators like Billing status FKSTA and GKSTA...and it depends on the scneraion like if you are looking for the documents which are invoiced and are not pending from customer or if invoiced to customer and are pending.

Thanks

Ajeet

[Former Member · Accepted solution]

I am looking for the sales that has no invoice.

The scenarios you mentioned:

the documents which are invoiced and are not pending from customer

or

if invoiced to customer and are pending.

The scenario I am in need:

the documents which are not invoiced

Thanks

[Former Member · Accepted solution]

Enhance the billing header extractor 2LIS_13_VCHDR ( already have sales document number) by

MCVBUK-FKSTK from the right hand side

Check the extractor 2LIS_11_VASTH and it has a billing status VBUK_FKSTK

[Former Member]

Hi,

We have found out the non-invoiced sales by comparing biling and order data tables (RS100 and RS200).

Thanks for your helpful answers.