mass display of label data generation variants

[former_member434175]

Hi Experts,

can someone kindly tell me if it's possible to display a list of SKU's with their respective label data generation variant?

The field I'm looking to see is LDEPID

I need to update a big list of SKU's but I need to identify all the Generation variants first for a list of SKU's.

maybe a SE16 table?

any help would be very much appreciated.

[christian_hund · Accepted solution]

Hi Laurens,

basically table CCGLT_MTLS is what you need.

But be careful!

It is possible to configure direct and dynamic links of a material to a label.

GLM uses a so called "label determination" to find suitable labels for a material used in a specific process.

There can be a 1:1 association of material (MATNR) to generation variant (LDEPID) in the table.

But there are also indirect 1:n references like: MATNR -> CCGLC-LSIZE (label size) -> label size in label stock (CCGLT_LSHD) -> label size associated to a generation variant

There are some more possibilities ...

Also there can be filters applied saying use this label only for region/country XY or use it only for UOM (unit of measure) XY ...

[Mark-Pfister]

Hi Laurens,

Im not quite sure what you are looking for....

If you want to access the data from the label view of the material master (what kind of labels can be used for a certain SKU / materials) please have a look at CCGLT_MTLS. It contains the MATRN and LEDPID.

If you want to see what labels / reports have been actually created you would need to join a couple of tables:

ESTMJ and ESTRH - To see what material belongs to which Substance

ESTRH and ESTDH - to see what labels / reports have been created for certain GenVars.

Hope this helps

Mark

[former_member434175]

Hi Mark,

that actually did it!

many thanks! problem solved!

[christoph_bergemann]

Dear Laurens

what is "SKU"??

You have generation variant, you have WWI template and you have reports (e.g.released).

For Reports ESTDH is the table. ESTLP is table for generation variant

C.B:

[former_member434175]

hi Christoph,

many thanks for your reply!

an SKU means a Stock Keeping Unit. basically a material but on plant level.

so I want to see the generation variants per material on a plant level. is that possible?

with the tables you have provided, I can get the reports and the GV's, but I can't seem to find the materials.

many thanks again!