topic Re: vbuk table use in Application Development and Automation Discussions

vbuk table use

Former Member — Tue, 27 May 2008 15:04:20 GMT

hello experts,

kindly tell me what is the use of the table vbuk and vbup and nast table with a very clear example.

Re: vbuk table use

Former Member — Tue, 27 May 2008 15:06:48 GMT

VBUK (Header Level)Table is used for Status of the Document.

VBUP(ItemLevel)Table is used for Status of the Document.

NAST is used for the medums of the Output avialble

Re: vbuk table use

Former Member — Tue, 27 May 2008 19:21:52 GMT

hi shiva,

**VBUK** : Sales Document: Header Status and Administrative Data.

It contains the fields like vbeln which is sales and distribution document number and

RFSTK: Refernace document header status,

VBTYP: Sales document category

the data in that table is displayed as the name impllies it contains all the header data.

VBUP: Sales Document: Item Status.

It contains all the item details.

NAST: it contains the messsage status.

All the nmessages are stored in this table.

reward points if usefull,

Thanks,

Kalyan.

Re: vbuk table use

Former Member — Wed, 28 May 2008 16:36:03 GMT

I am unable to understand , please kindly explain me with an example.

Re: vbuk table use

Former Member — Wed, 28 May 2008 17:18:54 GMT

Hi Shiva,

Generally these tables deals with Sales and Distribution module. In a transaction we will be having header data and item data. It means header data is where you have all the main elements i.e., sales document number and so on. Similarly item data is where for header you will be having more number of items. So, for obtaining these status we use these tables.

VBUK, Sales Document: Header Status and Administrative Data.

VBUP, Sales Document: Item Status.

If you want to find status of any sales order line item then you can find from following method from VBUP table.

In VBUP table there is a field FKSTK.By this filed status we can find billing status of particular sale order and this field has four possible values and these are

field value field value meaning

if this value is space then order is not Not Relevant for billing

if this value is 'A' then order is Not yet processed

if this value is 'B' then order is Partially processed

if this value is 'C' then order Completely processed

You need to do for open billing items then make use of this sequence give the input of sales orders in table VBUK at header level join of VBAK and VBUK

and check the fields GBSTK ne "C" and FKSTK ne "C" implies open .

FKSTK is for billing status..

All the open orders with open billing status can be fetched. Taking these Open Orders now fetch the entries at item level.

Now for these do the same at item level from VBAP and VBUP .

In order to check the open items in schedule line fetch from VBEP for the same line items

You can determine whether an order is open order through VBUK table.

NAST Table:

This is for defining the out put types for a program...if the output had many options like this..

1.email

2.fax

3.printer....

this will be done by the nast table ..or through the nace tcode

Reward points if useful.

Thanks,

Swamy Kunche