SO & PO in same table

[Former Member]

hi friends ,

can i get VBELN (SO) and EBELN (PO) in same ddic table.

thanks .

BHUPI

[former_member181995]

In normal senerio of SAP perhaps NO.

[Former Member]

Hi ,

As of my knowledge , both filed swont be avialble in same table.

But by linking tables VBAK and EKKO with filed : IHREZ you can get both fileds.

Regards,

Madhu.

[Former Member]

As far i know there is no table for this, where VBELN and EBELN are together in a table.

With luck,

Pritam.

[former_member387317]

Hi bhupi kaler,

Have a look on EKKN table...

Also see other EK* tables... and VB* tables...

Also look in to VBKD-BSTKD and VBKD-VBELN

Plese elaborate on ur req...

Or just you need to join tables or use for all entries to get the required result...

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

[Former Member]

hi,

no both the fields are not available in the same table but u can creat an internal table in which u can get both the fields into a single internal table.

[Former Member]

hello,

in the table VBAK.

VBELN - Sales document number.

BSTNK - Customer purchase order number.

BSARK - Customer purchase order type.

Thanks,

Manjunath MS

[Former Member]

Hi,

Check BSEG table

regards

padma

[Former Member]

You can use VBAK-BSTNK to refer to Purchasing Order Number.

You Can use Fm BS01_SALESORDER_GETDETAIL to get all the details.

[Former Member]

HI bhupi,

Table BSEG have both the fields in the same tble.Check if this fulfills your requirement.

Best of luck,

Bhumika

[Former Member]

hi,

Table VBAK has the fields VBELN(Sales order no) and BSTNK(Customer purchase order no).

Another option is that join tables VBAK-vbeln and EKKO-ebeln.

Regards,

Darpana.