Sort Variant - Vendor Number & Purchase Order number in AR01 Report

[Former Member]

Hi All,

In Sort Variant, Vendor Number & Purcahse Order Number has to come in report AR01.

I have checked in OAVI where I found below tables, but purchase order number field is not there. Please any one suggest on this.

.

ANLAV

ANLAV_ADDR

ANLB

ANLCV

ANLP

ANLU

ANLV

ANLZ

[narasimhulu_konnipati · Accepted solution]

Can you try adding the new tables in OAVI?

ANEK is the table

EBELN                           Purchasing document

EBELP                           Item

Click on New entries and add the table ANEK and the above fields. Then see if you get any error in it.

Thanks

[Former Member · Accepted solution]

Hi,

As per your suggestion, I have added table ANEK in t-code OAVI, On execution of AR01 report i am getting error message "Table ANEK is not supported in the requested report" (Message no. AB066).

Please let me know if any suggestion.

Regards

Sridhar

[narasimhulu_konnipati · Accepted solution]

I just found a SAP note on sort version. As per this note, it is not possible to include table ANEK.

21719 -
Sort versions: Which tables can you use?

You may have to go for a Z development.

[former_member205041]

Hi,

Note 335065 describes how you can add additional fields .

Tis note is for all ALV Reports expect of  RASIMU* and RAKOPL* and for

fields from the structure ANLAV.

ANLAV-BSTDT

ANLAV-LIFNR

Please have a lalso ook at report RAHERK01 (S_ALR_87012930)

This report lists the origin of transactions that affect acquisition value in a fiscal year.

For each line item, the report lists:

a settlement of an order or project
a settlement of an asset under construction
a purchase acquisition (with vendor)
a transfer from one asset to another
a balance forward posting following line item settlement (only for assets under construction)
an acquisition against a clearing account (G/L account)
a goods receipt or
a transaction that only affects assets (such as an acquisition in the cost-accounting area only).

For line items from the settlement of an asset under construction, it is also possible to identify the origin of the line item amount.  You can see what amounts of which settled line items of the asset under construction make up the line item amount.

best regards

Bernhard

[Former Member]

Hi Bernhard,

Thank you for your reply,

My Client want Purchase Order Number to come in AR01 report.

Please let me if it possible through userfields in any one of the tables?