topic Re: How to get SD Document Category in Application Development and Automation Discussions

How to get SD Document Category

Former Member — Tue, 24 Nov 2009 15:59:52 GMT

Hello Friends,

I am not a functional guy and so am having problem in knowing how SD Document Category is related to a customer.

I have details like customer, sales organization, distribution channel, division inco terms etc.,

I have to create a quote from a program outside of SAP. I am able to send all the data needed to create a quote except for 'SD Document Category'.

Is there a way to search for this using the info that I have as mentioned above.

I tried tables like VBUK, VBAK, VBKA, BVKD etc., but these are in no way related to customer etc., which I can use as keys to search for the right SD document category.

Any help will be greatly appreciated.

Thanks

Ram

Re: How to get SD Document Category

former_member191735 — Tue, 24 Nov 2009 16:18:10 GMT

SD document category is nothing but what kind of document it is? I mean, is it a quote, order, inquiry, etc....

Yes, you need to pass the document cat for creating any sales document as the SAP system differentiate with this category.

I cannot provide you the document categories but here is how you can find it

Go to table VBAK - Search for VBTYP - Double click on the component type - double click on the domain - go to value range tab.

there is another way of finding this through config and main table but i am sure you will find all active categories here.

Yes, you need to pass this value to your BAPI/RFC (if you are creating from outside of SAP)

Good luck

Re: How to get SD Document Category

Former Member — Tue, 24 Nov 2009 16:19:53 GMT

Hi ,

I am not in front of SAP, still suggestion is to check following tables:

VBAKUK VBAK + VBUK

VBUK Header Status and Administrative Data

VBAK Sales Document u2013 General Header Data

VBKA Sales Activities

VBKD Sales Document - Business Header/Item Data

VBPA Sales Document - Partners Header Data

VBUP Item Status

VBPA Sales Document u2013 Partner Item Data

VBAP Sales Document u2013 General Item Data

FPLA sales Document u2013 Items Conditions data

VBFA Document Flow

VBEP Sales Document Schedule Line

VBBE Sales Requirements: Individual Records

VEDA Sales Contract Data

VBELN Sales and Distribution Document Number

If you know where is doc catagory field , go and press F1 on it and then go in technical settings .

Here you can get table and fields name.

If you get field name , just do where use list of it . you will get the table.

Hope it help you.

Re: How to get SD Document Category

Former Member — Tue, 24 Nov 2009 18:03:11 GMT

Hi Ram,

the document category for Quote is 'B',

here is the sample list:

A Inquiry

B Quotation

C Order

D Item proposal

E Scheduling agreement

F Scheduling agreement with external service agent

G Contract..

Hope this helps,

Cheers,

Srini.

Re: How to get SD Document Category

Former Member — Tue, 24 Nov 2009 18:09:00 GMT

Thanks a lot to everyone for the useful info. Srinivas's suggestion answered my issue.

Re: How to get SD Document Category

former_member228783 — Wed, 25 Jun 2014 10:33:41 GMT

Hi Srinivas,

I can see the same in Domain Values tab but is there any table from where I can get the mapping of AUART and VBTYP?

Your help will be appreciated.

Regards,

BGaurav