ZEN CONSULTING : SAP

Mostrando entradas con la etiqueta SAP. Mostrar todas las entradas

lunes, 29 de diciembre de 2014

SAP

viernes, 18 de abril de 2014

traslate EDI gentran format to SAP ERP format

En la carpeta

/export/home/evikcc/mediaGentran/IBM_GEN_Multiplatform

Hay un zip llamado

CIOJDEN cliente.zip

Este es el cliente.

Una vez que lo bajes lo descompilas y me avisas para poderte ayudar con la configuración.

entrada EDI

Actual PO(850) data from CVS.

ISA*00* *00* *ZZ*CVS *01*055826309 *121001*113

9*U*00400*000003429*0*P*^

GS*PO*CVS*055826309*20121001*1139*1378*X*004010

ST*850*2216

BEG*00*SA*0076423**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2986

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*Y101

N3*ONE CVS DRIVE

N4*WAVERLY*NY*14892

PO1**17*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2986*ZZ

PO4*6

CTT*1*17

SE*18*2216

ST*850*2217

BEG*00*SA*1265472**20121001

REF*VR*12925

PER*BD*MICHELLE MARTINEAU

SAC*A*F050*ZZ*ZZ**1*1*****02***OTHER

ITD*01*15*2**30**31***100

DTM*002*20121022

AMT*BAP*2459

N9*L1*PO COMMENTS

MSG*THIS PO SUBJECT TO THE TERMS AND CONDITIONS FOUND ON CVS SUPPLIERS WEBSITE

N1*ST**54*W101

N3*400 FOUNDERS DRIVE

N4*WOONSOCKET*RI*02895

PO1**14*CA*175.62**UI*03288417688*UA*003288416790*PI*855752

PAM*01*2459*ZZ

PO4*6

CTT*1*14

SE*18*2217

GE*2*1378

IEA*1*000003429

salida

Application file created using selected map from PO’s received.

ENV|0076423-20121001145006|CVS|0076423||X12|850S|SA00||20121001|1139

HDR|0076423-20121001145006|CVS|0076423||20121001|20121001|20121015|20121022||007

6423|||PP|055826309|||0076423|||||||||||||1|||ZZZ|||||30|31|2|01|02|||||||||||15

HAD|0076423-20121001145006|CVS|0076423|DEL|Y101

HTX|0076423-20121001145006|CVS|0076423|ARRIVAL DATE 2012/10/22

REF|0076423-20121001145006|CVS|0076423|VR|12925

LIN|0076423-20121001145006|CVS|0076423|1|6||UI|03288417688||||102|20121001|20121

015|102|EA|175.62|CA||||||||||||UI|03288417688|UA|003288416790|PI|855752||||||||

20121015

ENV|1265472-20121001145006|CVS|1265472||X12|850S|SA00||20121001|1139

HDR|1265472-20121001145006|CVS|1265472||20121001|20121001|20121015|20121022||126

5472|||PP|055826309|||1265472|||||||||||||1|||ZZZ|||||30|31|2|01|02|||||||||||15

HAD|1265472-20121001145006|CVS|1265472|DEL|W101

HTX|1265472-20121001145006|CVS|1265472|ARRIVAL DATE 2012/10/22

REF|1265472-20121001145006|CVS|1265472|VR|12925

LIN|1265472-20121001145006|CVS|1265472|1|6||UI|03288417688||||84|20121001|201210

15|84|EA|175.62|CA||||||||||||UI|03288417688|UA|003288416790|PI|855752||||||||20

121015

Crontab for AS2 data to schedule transfer of data for each customer both in and out.

# Monitor AS2 for error files

00 * * * * /opt/admin/scripts/monitoras2.ksh

#Process AS2 inbound

00 3,15,22 * * 1-6 /opt/admin/scripts/processexpeditors.ksh > /dev/null

45 9,21 * * 1-6 /opt/admin/scripts/processnyklogistics.ksh > /dev/null

05 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processkinray.ksh > /dev/null

07 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processmol.ksh > /dev/null

10 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processstaterbros.ksh > /dev/null

15 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processmeijer.ksh > /dev/null

20 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processlowes.ksh > /dev/null

23 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbabyage.ksh > /dev/null

24 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processfreshandeasy.ksh > /dev/null

#25 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processamazon.ksh > /dev/null

25 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processamazonas2.ksh > /dev/null

26 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processvcprod.ksh > /dev/null

27 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processowens.ksh > /dev/null

28 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcsn.ksh > /dev/null

29 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcardinalmps.ksh > /dev/null

30 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processacosta.ksh > /dev/null

31 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processetoys.ksh > /dev/null

32 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processcommercehub.ksh > /dev/null

33 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processwalmart.ksh > /dev/null

34 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbcf.ksh > /dev/null

35 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processtoys.ksh > /dev/null

36 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processoverstock.ksh > /dev/null

37 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processbbb.ksh > /dev/null

#38 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processojc.ksh > /dev/null

39 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processraleysprod.ksh > /dev/null

40 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processsearsca.ksh > /dev/null

45 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processsterling.ksh > /dev/null

50 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processtarget.ksh > /dev/null

52 2,6,10,14,18,22 * * 1-6 /opt/admin/scripts/processweber.ksh > /dev/null

#Process AS2 outbound

00,30,45 * * * 1-6 /opt/admin/scripts/outboundsterling.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundlowes.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundmeijer.ksh > /dev/null

#00,30,45 * * * 1-6 /opt/admin/scripts/outboundamazon.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundamazonas2.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundowens.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcardinalmps.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundstaterbros.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundsearsca.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundtoys.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundetoys.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundwalmart.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundtarget.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundkinray.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundraleysprod.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbabyage.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundvcprod.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcsn.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbcf.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundfreshandeasy.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundoverstock.ksh > /dev/null

#00,30,45 * * * 1-6 /opt/admin/scripts/outboundojc.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundbbb.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundacosta.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundcommercehub.ksh > /dev/null

00,30,45 * * * 1-6 /opt/admin/scripts/outboundweber.ksh > /dev/null

05,20,35,50 * * * 1-6 /opt/admin/scripts/outboundexpeditors.ksh > /dev/null

05,20,35,50 * * * 1-6 /opt/admin/scripts/outboundmol.ksh > /dev/null

05,30 * * * 1-6 /opt/admin/scripts/outboundnyklogistics.ksh > /dev/null

Crontab for scheduling translation and backup of AS2 data. Also schedules all other EDI jobs non-baan.

#####

#######

#### crontab for ediprod on ap01

###

######## Transfer US CANADA translated data to Baan

#10 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfer2b.cr > /edi/gentran/61/

usr_bin/xfer2b.err 2>&1

###

######## Transfer US translated data to Baan

10 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xferus.cr > /edi/gentran/61/u

sr_bin/xfer2b.err 2>&1

###

######## Transfer CANADA translated data to Baan

12 3,11,15,19 * * 1-6 /edi/gentran/61/usr_bin/xferca.cr > /edi/gentran/61/usr_bi

n/xfer2b.err 2>&1

###

######## Transfer MX translated data to Baan

11 3,7,11,13,15,18,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfermx.cr > /edi/gentra

n/61/usr_bin/xfer2b.err 2>&1

###

######## Transfer WEBER 945 translated data to Baan

13 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/xfer945W.cr > /edi/gentran/61

/usr_bin/xfer2b.err 2>&1

###

######## Transfer EXPEDITOR 945 translated data to Baan

25 03,15,22 * * 1-6 /edi/gentran/61/usr_bin/xfer945E.cr > /edi/gentran/61/usr_bi

n/xfer2b.err 2>&1

###

######## Transfer NYKL 945 translated data to Baan

55 9,21 * * 1-6 /edi/gentran/61/usr_bin/xfer945N.cr > /edi/gentran/61/usr_bin/xf

er2b.err 2>&1

###

######## EDI housekeeping

###

####### CHECK TRANSLATIONS FOR ZERO QTYS #####

05 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/qtychk0|mailx -s "Translation

QTY Check Report" uomrcps

###

#53 22 * * 0 /edi/gentran/61/usr_bin/qtychk0|mailx -s "Translation QTY Check Rep

ort" uomrcps

####### RUN PRODUCT ACTIVITY DATA (852) TO ORACLE #####

30 14 * * 1-5 /edi/gentran/61/usr_bin/pad2db0.pl -o mail -L 2> /edi/gentran/61/u

sr_bin/pad2db.err

####### RUN PRODUCT ACTIVITY REPORT (852) #####

##46 13 * * 1-5 /edi/gentran/61/usr_bin/padrpt9 > /edi/gentran/61/usr_bin/padrpt

9.err

####### RUN PLANNING SCHEDULE REPORT (830) #####

20 14 * * 1-5 /edi/gentran/61/usr_bin/psrrpt > /edi/gentran/61/usr_bin/psrrpt.er

####### RUN Organizational Relationships (816) #####

01 23 * * 1-5 /edi/gentran/61/usr_bin/816_email > /dev/null 2>&1

###

####### RUN Payment Order / Remittance Advise (820) #####

02 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/820_email > /dev/null 2>&1

###

####### RUN Application Advise (824) #####

03 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/824_email > /dev/null 2>&1

###

####### RUN Purchase Order Change Request (860) #####

04 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/860_email > /dev/null 2>&1

###

####### RUN Text Message (864) #####

05 7,11,15 * * 1-5 /edi/gentran/61/usr_bin/864_email > /dev/null 2>&1

###

####### RUN Order Status Inquiry (869) #####

07 23 * * 1-5 /edi/gentran/61/usr_bin/869_email > /dev/null 2>&1

###

####### RUN CREDIT DEBIT ADJUSTMENT REPORT (812) #####

39 2,6,10,14,18,22 * * 1-6 /edi/gentran/61/usr_bin/cdarpt > /edi/gentran/61/usr_

bin/cdarpt.err

###

06 3,7,11,15,19,23 * * 1-6 /edi/gentran/61/usr_bin/cdarpt > /edi/gentran/61/usr_

bin/cdarpt.err

####### RUN XLLD REJECT UPDATE ################

30 2,6,10,18,22 * * 1-6 /edi/gentran/61/usr_bin/reprocess_xlld.sh > /edi/gentran

/61/usr_bin/reprocess_xlld.err

###

##### Process Kinray #####

10 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_kinray.ksh

##### Process MOL #####

12 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_mol.ksh

##### Process Stater Bros #####

15 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_staterbros.ksh

##### Process Meijer #####

20 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_meijer.ksh

##### Process Lowes #####

25 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_lowes.ksh

##### Process BABYAGE #####

28 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_babyage.ksh

##### Process FREASHANDEASY #####

29 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_freshandeasy.ksh

##### Process Amazon #####

#30 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_amazon.ksh

30 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_amazonas2.ksh

##### Process BJS #####

31 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_vcprod.ksh

##### Process Owens #####

32 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_owens.ksh

##### Process CSN #####

33 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_csn.ksh

##### Process Cardinal #####

34 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_cardinal.ksh

##### Process Acosta #####

35 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processacosta.ksh

##### Process etoys #####

36 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_etoys.ksh

##### Process CommerceHub #####

37 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processcommercehub.ksh

##### Process AS2 Wal-Mart data #####

38 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/processas2.ksh

##### Process AS2 Burlington data #####

39 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_bcf.ksh

##### Process AS2 TOYS R US data #####

40 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_tru.ksh

##### Process AS2 OVERSTOCK data #####

41 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_overstock.ksh

##### Process AS2 BBB data #####

42 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_bbb.ksh

##### Process AS2 OJCOMMERCE data #####

#43 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_ojc.ksh

##### Process AS2 RALEYS data #####

44 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_raleys.ksh

##### Process Sears Canada #####

45 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_searsca.ksh

##### Process GARCES EDI DATA ######

46 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx3.ksh

##### Process GARCIA EDI DATA ######

47 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx2.ksh

##### Process NADRO EDI DATA ######

48 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx1.ksh

##### Process COMERSA EDI DATA ######

49 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx.ksh

##### Process Sterling AS2 Data #####

50 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_sterling.ksh

##### Process MARZAM EDI DATA ######

51 02,06,10,12,14,17,18,22 * * 1-5 /opt/admin/scripts/processmx4.ksh

##### Process Gigante EDI Data #####

52 02,06,10,12,14,17,18,22 * * 1-6 /opt/admin/scripts/process_gigante.ksh

##### Process network6 EDI Data #####

53 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network6.ksh

##### Process network3 EDI Data #####

54 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network3.ksh

##### Process Target #####

55 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_target.ksh

##### Process Weber #####

57 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_weber.ksh

##### Process Walgreen vendor split #####

56 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_walgreensplit.ksh

##### Process network2 EDI Data #####

57 02,06,10,14,18,22 * * 1-6 /opt/admin/scripts/process_network2.ksh

##### Process Expeditors 945 #####

05 03,15,22 * * 1-6 /opt/admin/scripts/process_expeditors.ksh

##### Process NYKL 945 #####

50 09,21 * * 1-6 /opt/admin/scripts/process_nykl.ksh