Default barcode indicator

[abasilis]

Hi everyone!

I have a crystal reports I created to print only the default barcode in a catalog, and I know the default barcode is in the OITM label.

The situation is this:

My main vendor changed all their products with a new barcode which I already put to all items. I am able to receive and sell the same item scanned, and that's not a problem. Since I have the same item with two barcodes, the new one is marked as default and I have a "Label" in the "Free Text" field (which is the BcdName in the OBCD table). But there is no indicator in this table that tells me which is the default barcode (or at least I have not seen it since I have selected some items and I see no similarity on any field).

If there is another table or indicator for the default barcode that lets me select the BcdName I need, please let me know, I really appreciate it.

I cannot remove the old barcode because I may receive returns for a while.

In resume, I want to be able to pull the BcdName of the default barcode.

Thank you very much!

[mgregur]

Hi,

you have the information for each unit of measure which is the default barcode for that unit. It is stored in ITM12 table (BcdEntDft).

BR,

Matija

[abasilis]

Thank you for your answer, but the ITM12 table is empty. And when I hover the mouse over the fields in the BarCode window (with the View->System Information checked) it does not show table/fields in the details, only in the heather over the Item No. or Item Description it shows the OITM table.

[mgregur]

Hi,

what you're saying is that you do not use separate units of measure for these items? You only have a single barcode that you use (better to say, one is used, and another one is the "old" one)?

If that is the case, why is the information from OITM.CodeBars not enough?

BR,

Matija

[abasilis]

Yes, we only have one UofM since everything is handled in Cases, we do not sell or receive units. My goal is to get the information in the "Free Text" of the default Barcode (which in fact, like you say is in the OITM table). When the report is generated I will able to know if the barcode is the "New one" based on the description I put in the Free Text field, and if there is a mistake by the person who creates the items I can correct it.

Thanks!

[mgregur]

Hi Silvio,

but as you said, you already have all the information, maybe you just don't realise this yet.

To clarify - each barcode must be unique. SAP B1 has a control code which checks this, and you cannot have a duplicate barcode. So, by having the information OITM.ItemCode and OITM.BodeBars, this is enough to get the information from OBCD table. Granted, it is not exactly the way SAP intended to join these tables (as join over ItemCode and BcdCode are meant to include also UomEntry), but the select for your required data would be:

SELECT "BcdName"
FROM OBCD T0
INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode" AND T0."BcdCode" = T1."CodeBars"

BR,

Matija

[abasilis]

Hi Matija,

At the end that's what I did (since the same barcode cannot exist for more than one item, it's the way it must be, like you said), I joined the barcode fileds for both tables OITM and the OBCD (which is not right), but doing so, I could get the BcdName.

I was trying to not to do so, because is not right to join table of fields that are not unique or non-indexed.

Anyway, because in this community I've been helped a lot with people who really know SAP I can get a better answer. But it looks like there is not an indicator or Boolean that can tell if the barcode is the default one.