Skip to Content
0
Former Member
Jan 04, 2008 at 03:12 AM

Select statement

141 Views

Hi Experts,

plz help me in this select statement.

Select table VEKP and copy all the records for VEKP-VPOBJKEY = delivery number and VEKP-UEVEL = “” (null) into an internal table. Copy only the following fields

Field Name Purpose

VEKP-EXIDV One label to be printed for each Carton ID

VEKP-VENUM For extracting other information

VEKP – ZZUSR07 To get information for the barcode printing

VEKP-ZZPALID One label to be printed for each pallet ID

VEKP – ZZJDATE Julian date For working out the barcode

VEKP - ZZLOTID Lot ID Calculation of barcode

plz help me Experts

correct answers will be rewarded.

thanks & regards

sunita.