Skip to Content

CAN U HELP WITH THIS SPEC

hi guys,

CAN U HELP ME OUT WITH THIS SPEC BY A PROGRAM.

1.1.1 FCR Report

FCR report is the listing to give the goods receipt summary for particular selection. It can be used to view goods receipt of SE material for a specific date, vendor, PO or FCR number.

1.1.1.1 Selection Screen

Report selection screen includes following fields:

1. Post Date

2. Document Date

3. Vendor

4. FCR number

5. PO number

6. Plant

7. Storage location

All the above fields should have from and to selection.

Add a Selection Storage location break down

1.1.1.2 Report Logic

1. Based on the selection, select the material document header (MKPF) and details (MSEG)

2. Bases on the purchase order (MSEG-EBELP), search High-level item (EKPO-ZZUEPOS) in EKPO. Based on the High-level item, determine the SE material by looking at PO number and PO item where item is equal to High-level item. If for one material document number, the High-level item is reference more than once, only count once.

3. To determine the GR qty, group the field by Post date (MKPF-BUDAT), vendor (MSEG-LIFNR), FCR (MKPF-XBLNR), PO (MSEG-EBELN), PO item (EKPO-EBELP), Plant (MSEG-WERKS). Group also the storage location (MSEG-LGORT) if storage location breakdown is selected.

1.1.1.3 Report Output

Following fields need to display in the report:

1. GR Date (MKPF-BUDAT)

2. Vendor (MSEG-LIFNR)

3. Vendor name (LFA1- NAME1)

4. FCR (MKPF-XBLNR)

5. PO (MSEG-EBELN)

6. PO item (EKPO-EBELP)

7. SE material (EKPO-MATNR)

8. Material Description (MAKT-MAKTX)

9. Receipt Qty – consolidated GR qty

10. Unit of Measure (EKPO-MEINS)

11. Plant (MSEG-WERKS)

12. Storage location (MSEG-LGORT) if storage location breakdown is selected.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 12:18 PM

    Hi Naveen,

    good script.

    Now you can use ABAPDOCU and http://help.sap.com and DWDM etc.

    Regards, Dieter

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 12:20 PM

    hi,

    First you search all the fileds in table given in your space and declare internal table with the repective table to retrive data. One final internal table included only fields which you have to display as output. first write the code for selection screen as per spec. First you start with the help of any report.or table a help of TCODE ABAPDOCU.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 12:25 PM

    Hi!

    Check out this program for basics in transaction SE38: DEMO_SELECT_INTO_TABLE.

    Regards

    Tamá

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Naveen George

      Hi!

      Try like this.

      REFRESH gt_main.

      LOOP AT gt_mseg INTO wa_mseg.

      CLEAR wa_main.

      READ TABLE gt_mkpf INTO wa_mkpf

      WITH KEY mblnr = wa_mseg-mblnr.

      MOVE-CORRESPONDING wa_mseg TO wa_main.

      MOVE wa_mkpf-budat TO wa_main-budat.

      APPEND wa_main TO gt_main.

      ENDLOOP.

      Reward if you find the post useful.

      Regards

      Tamá

  • author's profile photo
    Former Member
    Posted on Aug 23, 2007 at 01:22 PM

    common field is MBLNR.......

    Add comment
    10|10000 characters needed characters exceeded