In SAP, the standard report exists for the selection of handling units (HUMO). The requirement is that in addition to standard output the report should also display for KMAT materials the serial number associated with the respective HU, catalog number and special stock category.
-Depending upon the selection criterion, the HU assigned with the material will be identified for the materials.
-The HU contains the catalog number in the contents field of status tab and will be displayed in output.
-The serial number assigned with the HU will be picked up from the HU and will be displyed in the output.
1. The program will first find out the HUs for the material. From the HU, catalog number and serial number will be traced.
2.The output should be in ALV format.
3.The output will display HU number, KMAT number, catalog number, serial number, quantity, special stock indicator, plant, Storage location, Warehouse number, and bin-location.
Can Any body tell me what are the table involved in this ALV report to display HU number, KMAT number, Special Stock Indicator, Warehoure Number and Bin Location.
For Handling unit tables are VEKP,VEPO also use object LE_HU in transaction SARA .
For Warehouse number check out table t300,t320 or view v_T320
For Bin location table T303,T303T or view V_T303
For special stock determination T434P
FOR KMAT - table MAST ,STKO ,STPO.
Please reward if useful.