Table Item type & Billing status

[annabelle_roux]

Hello,

Is there a table which displays both the delivery item type (PSTYV) and the billing status (FKSTK)?

Thanks,

Annabelle R.

[Former Member · Accepted solution]

First of all Item category is at item level and the Billng status field you mentioned is the Header level Billing status field. The item level Billing status is FKSTA

Pls create a simple query using SQVI and with an inner join on the tables LIPS and VBUP so that you get the delivery and item number from LIPS and then pass to VBUP to get the billing status FKSTA

[annabelle_roux · Accepted solution]

Hello,

I have not been able to create the query yet, however thanks for your help.

Sincerely, Annabelle

[Shiva_Ram]

Hi,

There is no single table to hold both the values.

You need to use two tables, for example LIPS and VBUP to find item status and item category type.

Regards