How to get Order Number (AUFNR) of AUFK/AFIH with any VBAK/VBRK/VBFA tables

[Former Member]

Hi all,

We have a Function Module to get the data from VBAK/VBRK/VBFA tables and we have to enhance it to get additional fields from AUFK (Order Master data) and AFIH (Maintenance order header) Tables and the Order Number (AUFNR) is the KEY in these two tables.

How to link any VBAK or VBRK or VBFA (with Sales Doc No/ Billing Doc No) with AUFK/AFIH tables to get the Order Number and other data?

Thanks in advance.

Regards,

Venkat.

[Former Member]

Hi Venkat,

Please check the table AUFK-KDAUF field is related to VBAK- VBELN. Please check your business scenario.

Thanks,

Chandra

[Former Member]

Hi Chandra,

Thanks for your reply.

Unluckily there is no data in KDAUF (Sales Order No) of AUFK table.

Is there any other way to get the Work Order Number (AUFNR) with SD (VBAK/VBRK/VBFA) tables ?

Thanks,

Venkat.