Skip to Content
author's profile photo Former Member
Former Member

What tables are involved in packaging?

We have a customer who has been running our add on in SBO 6.5 and recently they decided to upgrade to 2005. 6.5 didn't have the kind of packaging functionality our customers needed so we coded our own packaging solution in our add-on.

SBO 2005 has the packaging worked in so now the customer wants us to integrate the packing info from our 6.5 add-on and the packaging info inherant in SBO 2005.

I've been working on this for a while and I was able to fill in most of their information using these queries which pull info from our old tables and insert it into the relavent SAP tables:

insert into DLN7 (DocEntry, PackageNum, U_TRC_UCC)
select ps.U_DocEntry as DocEntry, ps.U_PckageNm as PackageNum, ps.U_UCCNum as UCCNum
from [@OURPACKAGESTABLE] as ps

insert into DLN8 (DocEntry, PackageNum, ItemCode, Quantity)
select U_DocEntry, U_PckageNm, U_ItemCode, U_Quantity
from [@OUROTHERPACKAGELINESTABLE]

This kind of works, the packages with their UCC-128 numbers are moved over without issue. The only problem now is that the items are not assigned to their respective packages.

There must be a table in SAP I need to fill in that I'm missing, looking throught the documentation the only other table I see is OPKG which stores the Package Type information.

Where should I go with this from here?

Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jan 25, 2007 at 03:10 PM

    You should see related tables to OPKG and to DLN7 DLN8 whatever table by

    using B1 DB Browser. This is part of B1DE that you can freely download from

    SDN, under Business ONE SDK Tools.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.