Functional Module for Defects from Serial Number for Production Order

[VigneshV]

Hi,

As searched ahead on subjected posting here.

Would like to know or get Functional module that can be used to extract the defect entries + Notification data made for the Serial number mapped against a Production order.

Regards,

Vignesh V

[peter_atkin]

Vignesh V,

First you will need to determine the equipment for each serial number (table V_EQUI), then find the notifications for the equipment (table VIQMEL).

Then you can use BAPI_ALM_NOTIF_GET_DETAIL to get the details for each notification.

PeteA

[VigneshV]

Hi peter.atkin

Thanks for reply.

When passing the notification in mentioned FM I am getting below message.

"Transaction not allowed for notification type F3"

Regards,

Vignesh V

[peter_atkin]

Thats because BAPI_ALM_NOTIF_GET_DETAIL is for PM notification types, and F3 is a quality notification type..

Try BAPI_QUALNOT_GETDETAIL.

PeteA

[VigneshV]

Hi peter.atkin

Thank you for details.

Major challenge I am facing is fetching the Serial number against Production Order and getting defects from the notification that is the created during the defect entry.

Vignesh V

[peter_atkin]

Try table SER05 via SE16/SE16N/SE16H (or other SER* tables)

PeteA

[VigneshV]

Hi peter.atkin

Thanks for reply.

Explored some areas in which based in below URL checked SFW5 also mentioned BAPI is activated in current system but not shown in SE37.

https://blogs.sap.com/2015/03/25/faq-assigned-objects-in-quality-notification/

Vignesh V

[VigneshV]

Hi peter.atkin .

Thrown some insights and tried to map this requirement with below FMs.

PRODUCTION ORDER

Use FM – BAPI_PRODORD_GET_LIST for mentioned date range.

INSPECTION LOT for PRODUCTION ORDER

Use FM – BAPI_INSPLOT_GETLIST for getting the Inspection lot from Production Order

Pass the Production Order into ORDER tab to get INSPLOT[Inspection lot]

INSPECTION LOT to No of Operations [Only validation]

Use FM – BAPI_INSPLOT_GETOPERATIONS for getting all the operations for the lot.

SERIAL NUMBER LOGIC

à Use FM - GET_SERNOS_OF_DOCUMENTà Inspection Lot : KEYDATA-TASER = 'SER04' à KEYDATA-PRUEFLOS - Inspection Lot

Or

Use FM - GET_SERNOS_OF_DOCUMENT to get serial number for the Production order à

KEYDATA-TASER = 'SER05'

KEYDATA-PPAUFNR - Production order.

Pass the Inspection Lot number to QMEL table -field [PRUEFLOS] – to get Notification number – QMNUM.

NOTIFICATION + DEFECT LOGIC

Use FM – BAPI_QUALNOT_GETDETAIL for Notification & defect closure details.

Open defects without Task closure[TSCO status] will be used for the calculation part.

Vignesh V