Sales order item report based on results analysis key and status

[former_member210736]

Hi,

I am trying to find a a report to generate list of sales order items with following selection

-invoicing status -invoiced/not invoices (other status)

-result analysis key assigned to this item (VBAP-ABGRS)

-system status /released/teco

Basically i am CO consultant and not so familiar with the SD statuses. I tried VA05 and V.26 but all required selections are not available in these reports.

If no standard report is available in ERP, i would like to have it in BI. Can some help me with table fields for statuses.

Thanks in advance.

Regards

Raghu

[former_member217082]

Hi Raghu

Go to SE16 and give VBUK table and execute it there you can select the following feilds and then check wheather they are meeting your requirements or not.If they are meeting your requirements then create a new Z report by copying standard VA05 key feilds. and include the other feilds which you need.So you take your ABAP team help

Billing status FKSTK

Posting Status BUCHK

Overall status GBSTK

Document category VBTYP

Regards

Srinath

[jpfriends079]

You can use Table (TCode SE16N)

Table Desc	Table
Header Status	VBUK
Item Status	VBUP

Say, in VBUK - Header you can find following field for your use

Field Desc	Field Name
Sales Document No.	VBELN
Billing status	FKSTK
Bill.stat.order	FKSAK
Posting Status	BUCHK

Regards

JP