Child pages
  • Example of Barcode Layout for Warehouse Management
Skip to end of metadata
Go to start of metadata

Applies to:

SAP technology / SAP Netweaver / ABAP Development.

Summary


The first solution option is to change the standard print program to allow the output of extra fields from table MARA (Material Master) and MARM (Units of Measure for Material) by copying the main program and making the required changes.  The main program, which is used in SAP, is RLVSDR40.  Care has to be taken when creating the new program, as this is used for all the WM printing in the required warehouse. 

Author(s):  Aveek Ghose

   
Company:    Accenture India 
Created on:    08/07/2009
Author(s) Bio: 

Aveek Ghose has 14.5 years of IT experience and has worked across the globe in SAP Implementations. Aveek has an MS in Information Systems from George Mason University in USA and a MS in Economics, Mathematics, Statistics from Virginia Tech in USA and is currently working for Accenture India.


Table of Contents

Header 1

Notes for Barcode Printing:

 -          Generate SAP script
Each type of pallet label printer has its own control language.  The recommended method for connecting label printers to SAP is to load the SAPScript form with the specific commands needed to output the label, SAP then fills in the variable fields with the required data, GTIN, SSCC, etc. By using a label design package, the code can be created as a print file, and then uploaded to SAP where the sapscript commands can be inserted.  This is known as the "upload method". All the logic for the different fields should be included in the print program, several different forms may be required to select different print program fields depending on the movement being performed.

The first solution option is to change the standard print program to allow the output of extra fields from table MARA (Material Master) and MARM (Units of Measure for Material) by copying the main program and making the required changes.  The main program, which is used in SAP, is RLVSDR40.  Care has to be taken when creating the new program, as this is used for all the WM printing in the required warehouse.   
It should be noted that SAPScript would currently be generated by GLOBE in Barone for R3. It must be decided where this should reside in the future. No other field than the one provided by GLOBE should be added to these SAP Scripts 

Understanding the Layout (Label)


Material Code                                                                                       Nestle Logo
LQUA-MATNR
                                                                                                        
                                                                * Section 1 *

SSCC Number
LQUA-LENUM
                                                                * Section 2 *

CONTENT(GTIN)                                         VARIANT                 QUANTITY             LAYERS
MARM-EAN11                                     MARA-GTIN_VARIENT                LQUA-GESME
         
Material Description (or MIXED PALLETS)
MARA-MAKTX
                                                                 * Section 3 *

BATCH/LOT                                                                      DATE(USE BY or BEST BEFORE)
LQUA-CHARG                                                                     LQUA-VFDAT
                                                                 * Section 4 *

Secondary Bar Code
 Secondary Bar Code Text.
                                                                
  Primary Bar Code
  Primary Bar Code Text.
                                                                 * Section 5 *

Section 1
Contains Nestle Logo and Material Number.
Section 2
Contains SSCC (Storage unit) Number.
Section 3
Contains GTIN (EAN) code, Variant, Quantity, Layers (case unit of measure is in layers) and Material Description (Desc would be "Mixed Pallets" in case of mixed pallets)
Section 4
Contains Batch/Lot Number and the date (USE BY or BEST BEFORE)
The first 4 sections are Human Readable Values and the last is the same values in the barcode format.
 Section 5
Contains the Barcodes.
 The primary barcode is the lower one and according to M188 this should always be only the SSCC number.
The secondary (upper) barcode contains the GTIN, GTIN Variant, SLED, Qty and Batch.  The GTIN level could depend on the certain criteria (look in the detail logic).
   Primary Bar Code: Should be a field having the value = 00 + SSCC Number
   Example: 00350103470000139260
     00 is the A.I code for the SSCC number
Primary Bar Code Text: Should be a field having the value = (00) + SSCC Number. 
   Example: (00)350103470000139260
   Secondary Bar Code: Should be a field having the value  = 02(or 01) + 0 + MARM-EAN11+
    20 + Variant + 17(or 15) + LTAP-VFDAT + 37 + LTAP-NISTA + 10 + LTAP-CHARG.
   Example: 020761010002771020011702073037241020111234XX.
    02 & 01 are the A.I code for the GTIN (EAN) number.
   20 is the A.I code for the Variant.
   17 & 15 are the A.I code for the date.
   37 is the A.I code for the quantity. After this code, the code FNC1 has to figure (code '>8' for Zebra)
   10 is the A.I code for the batch.
 Secondary Bar Code Text: Should be a field having the value = (02)[stage:or (01)] + 0 + MARM-
   EAN11+ (20) + Variant + (17)[stage:or (15)] + LTAP-VFDAT + (37) + LTAP-NISTA + (10)
   + LTAP-CHARG.
 Example: (02)07610100027710(20)01(17+)020730(37)24(10)+20111234XX.
 

Description of Data">Description of Data

Reference

Field
(Business Name)

Business Rules

Comments

Ref1

Material number

Material or Item number

 

Ref2

SSCC Number

Storage Unit number

 

Ref 3

Content (or GTIN)

EAN code against the storage unit type from the material master

 

Ref 4

Variant

Material Varient

 

Ref 5

Count

Quantity of the Item in the Quants

 

Ref 6

Layers

No.of layers if the Quantity is in Layers

 

Ref 7

Batch/Lot

Batch or the lot number

 

Ref 8

Best Before (MM YYYY)

If the Period indicator for SLED (Shelf life expiration date) is 'M' in the material master the date should be ignored.

 

Ref 9

Use by (DD MM YYYY)

If the Period indicator for SLED (Shelf life expiration date) is ' D' in the material master the date should be considered.

 

Ref10

Description

Material Description

 

 

Data Mapping Table">Data Mapping Table

Reference

Field Name

Field Description

Field necessity

Output Length

Output Type

Format

Notes

REF1

LQUA-MATNR

Material number

Y

18

CHAR

N/A

 

REF2

LQUA-LENUM

Storage unit number

Y

18

CHAR

N/A

 

REF3

MARM-EAN11

EAN Code

Y

13

CHAR

N/A

 

REF4

MARA-GTIN_VARIENT

Material Varient

Y

2

CHAR

N/A

 

REF5

LQUA-GESME

Total quantity

Y

Notfixed

NUM

NO Zeros Decimals

 

REF6

LQUA-GESME

Total quantity

Y

Notfixed

NUM

NO Zeros Decimals

 

REF7

LQUA-CHARG 

Batch number

Y

10

CHAR

N/A

 

REF8

LQUA-VFDAT

Shelf Life Expiration Date

Y

6

DATE

MM YYYY

 

REF9

LQUA-VFDAT

Shelf Life Expiration Date

Y

8

DATE

DD MM YYYY

 

REF10

MARA-MAKTX

Material Desc

Y

40

CHAR

N/A

 

 

 

 

 

 

 

 

 


Related Content

Please include at least three references to SDN documents or web pages.
Reference 1
Reference 2
Reference 3

Useful Information

The first solution option is to change the standard print program to allow the output of extra fields from table MARA (Material Master) and MARM (Units of Measure for Material) by copying the main program and making the required changes.  The main program, which is used in SAP, is RLVSDR40.  Care has to be taken when creating the new program, as this is used for all the WM printing in the required warehouse. 

Unknown macro: {gliffy}

1 Comment

  1. Please use proper Templates for all your Wikis. So that i can move it to the appropriate Place.

    Thanks,

    Vijay