Skip to Content
0
Former Member
Sep 05, 2007 at 01:02 PM

New Report for MB5T.

774 Views

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 **********