New Report for MB5T.

[Former Member]

Dear All,

The new report program needs to be copied from the program RM07MTRB. In addition to the standard fields given in MB5T report we need to include few more new fields. They are Merchandise Category, Delivery document number, Date, Goods Issue Document number and Date.

The following are the logic for reading values for the new fields:

1. Merchandise Category (MATKL): Pass the value of EKBE-EBELN & EKBE-EBELN to EKPO-EBELN & EKPO-EBELN and read EKPO-MATKL. Then, Pass the values of EKPO-MATKL to T023T and read T023T-WGBEZ and populate the value to the field.

2. Delivery Document Number (BELNR): Pass the EKBE-EBELN & EKBE-EBELN to EKBE table and read EKBE-BELNR where EKBE-BEWTP = L. Pass EKBE-BELNR values to the field.

3. Delivery Document Date (BUDAT): Pass the EKBE-EBELN & EKBE-EBELN to EKBE table and read EKBE-BUDAT where EKBE-BEWTP = L. Pass EKBE-BELNR to the field.

4. Goods Issue Document Number (BELNR): EKBE-EBELN & EKBE-EBELN to EKBE table and read EKBE-BELNR where EKBE-BEWTP = U. Pass EKBE-BELNR values to the field.

5. Goods Issue Document Date (BUDAT): Pass the EKBE-EBELN & EKBE-EBELN to EKBE table and read EKBE-BUDAT where EKBE-BEWTP = L. Pass EKBE-BELNR to the field.

All others fields given in the standard report of MB5T need to be available in the new report.

Please Tell me how to start it ?

*****Point is Assured **********

[krishnendu_laha]

Hi Jim,

for the new Z program from RM07MTRB with this new fields on selection-screen.

in the <b>start-of-selection event</b> a subroutine there...in that there is a function module MB_ADD_TRANSFER_QUANTITY, this FM actually get stock data.

so make <b>Z copy ofthis function module</b>. change the selection condition from ekpo with passes extra parameter that you are giving on selection-screen

and for the extar parameter that will check data from EKBE, select data from EKBE and filter it.

Hope it will solve ur problem.

Regards,

Krishnendu

[Former Member]

thanks Krishnadu,

point has been given.