SAP – Getting Item Category Type From Delivery Number

The delivery details are stored in the tables LIKP and LIPS.

LIKP – Delivery Header Data

LIPS – Delivery item data

The sales order details are stored in the tables VBAK and VBAP.

VBAK – Sales Header Data

VBAP – Sales item data

Link between LIPS and VBAK is as follows:

VBAK-VBELN = LIPS-VGBEL

Link between LIPS and VBAP is as follows:

VBAP-VBELN = LIPS-VGBEL

VBAP-POSNR = LIPS-VGPOS

The ITEM CATEGORY TYPE is stored in the line item table VBAP.

The field for item category type is PSTYV, the key field in table VBAP is VBELN and POSNR

So for getting item category type use the below query:

SELECT PSTYV from VBAP into lv_pstyv WHERE VBELN = lips-vgbel AND posnr = lips-vgpos.

 

0 Comments

Leave A Reply