Extract VBAK-AUART available entries?

Logistics : SD and its sub-modules (Inquires, Quotes, Order Entry, SIS, Sales Contacts, Dist. & Billing)

Moderators: Snowy, thx4allthefish, mike_ac, Lost Identity

Post Reply
lalondemt
Posts: 3
Joined: Tue Sep 23, 2014 11:18 am

Extract VBAK-AUART available entries?

Post by lalondemt » Fri Oct 03, 2014 5:15 pm

SAPFans,
Is there a way to extract all the possible entries for a specific field?
In our case, the list of Sales Order Types?
Basically, how do we pull the data below to a spreadsheet, etc. :oops: (I'll assume it's simple, and we just can't see it)
Image

Thanks,
Mark

thiswayup
Posts: 29
Joined: Thu May 03, 2012 7:21 pm

Re: Extract VBAK-AUART available entries?

Post by thiswayup » Mon Oct 06, 2014 8:06 am

Fields with a look-up list like this are generally from another table - for document types a customising table.
To find the table:
== use SE11 on your data table (in this case VBAK)
== in SE11, press the "Entry/Help Check" tab
== scroll to your field (AUART); there should be an entry in the "Check Table" field - in this case, TVAK

This table gives the list of Sales Document Types.

Frank Lai
Posts: 1720
Joined: Mon Oct 21, 2002 8:03 am
Location: Canada

Re: Extract VBAK-AUART available entries?

Post by Frank Lai » Wed Oct 15, 2014 6:36 am

Hi

Further to last post, tvak will list all SD doc types. If you want a list of only sales orders, you need to specify in you select criteria for tvak where document category (VBTYP) = 'C'. That will get you a list of configured sales orders. Now if you want to further restrict this list to the sales orders that your are actually using to create transactions, also check document block field (SPERR) = ' '.

Frank

Post Reply