Skip to Content
avatar image
Former Member

Hi

Please help me out  in SAP BusinessOne, what are the tables to select for generating crystal report,

The pick list and the packing slip will be combined into one layout, but it will be divide in 2 parts.

1. Pick List (to collect the items from the warehouse)

The pick list will be grouped by item and a summary by quantity in order that the worker will just see that he have to bring to the packing area an x amount of an item, and the pick list will not have any order detail.

2. Packing Slip (to put in the box)

The packing slip will be a separate page for each order, and it with have all the order details.

Now when the warehouse manager will produce and print a pick list the pick list and the packing slip will be combined into one report.

The report should have 2 parts the main report and a sub report.

The main report will contain the pick list and the sub report will contain the packing slip, or vice versa

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Dec 23, 2014 at 09:31 AM

    Hi,

    The easiest way to know the tables involved will be through the SBO Client.

    Under the View Menu, Check the 'System Information' menu.

    or Short cut is Ctrl+Shift+I.

    Then open your Pick List form, now if you hover to any of the item in the header you will find something like

    at the status bar below you will see the table name OPKL.

    following SAP naming conventions, the child tables will be PKL1 and PKL2.

    Regards
    Edy


    PickList.jpg (113.0 kB)
    Add comment
    10|10000 characters needed characters exceeded