create table am_art_basic(BANNER_CODE varchar2(100),DIV_CODE varchar2(100),LEG_MATNR varchar2(100),SAP_MATNR varchar2(100),MAKTX varchar2(100), 
LEG_MATKL varchar2(100),SAP_MATKL varchar2(100),LEG_WHERL varchar2(100),SAP_WHERL varchar2(100))

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('SE', '6', '276019', '276019', 'GMS SHIN MIN 1COPY',  
    '15040101', '60507006', 'SG', 'SG')

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('SE', '1', '212615', '212615', 'MYOJO BOWL NDLE THAI TOM YAM 105G',  
    '11060104', '10103001', 'SG', 'SG')

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('CS', '1', '010137', '58351', 'BAKE KING CHOCOLATE RICE 160G',  
    '000384', '10203004', '34', 'SG')

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('CS', '1', '036762', '212615', 'MYOJO BOWL NDLE THAI TOM YAM 105G',  
    '000499', '10103001', '34', 'SG')

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('CS', '6', '056256', '276019', 'GMS SHIN MIN 1COPY',  
    '001862', '60507006', '34', 'SG')

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('GH', '6', '027112', '110005765', 'KOMAX BIOKIPS FOOD CONTAINER 3.1L',  
    '002108', '60207005', '17', 'CN')

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('GH', '6', '056256', '276019', 'GMS SHIN MIN 1COPY',  
    '001862', '60507006', '34', 'SG')

Insert into AM_ART_BASIC 
   (BANNER_CODE, DIV_CODE, LEG_MATNR, SAP_MATNR, MAKTX,  
    LEG_MATKL, SAP_MATKL, LEG_WHERL, SAP_WHERL) 
 Values 
   ('GH', '1', '036762', '212615', 'MYOJO BOWL NDLE THAI TOM YAM 105G',  
    '000499', '10103001', '34', 'SG')

COMMIT