File Adapter EDI File ISSUE

[Former Member]

Hi Gurus

I am working on File Adapter and i am struck in my development due to the following reason: I am getting an EDI File and in that file there are lots of NTE segements scrabbled acroos the file, as soon as the file is reached into PI i need to automatically remove all the NTE Segements and with the remeining data i need to send or trigger the file.

Please help me in this regard.

The EDI File is as follows

ISA*00*          *00*          *09*005070479DV    *ZZ*J3358F0        *110630*1656*U*00200*000000174*0*P*

GS*PO*DV*J3358F0*110630*1656*9*X*002003

ST*850*000000019

BEG*00*RL*5500020156**110616

FOB*DF***01*FCA

ITD*08*3*0*110630********CPPI ONLY Net due 30 days

N1*BY*Caterpillar Inc.*92*DV

N3*100 NE Adams St.N4*Peoria*IL*61629*US

PER*BD*Micah Roeschley*TE*309-675-2035.N1*PN*High Performance Molded Produc*92*DV

N1*ST*CATERPILLAR  INC.*92*52365

N2*High Performance Molded Products (

N3*2416 MID-AMERICA INDUSTRIAL DR

N4*Boonville*MO*652332635*US

PER*RD*RUBBER PROC EXT*TE*660 882 1145

N1*SU*EVONIK CARBON BLACK, LLC*92*J3358F0

N1*BT*Caterpillar Inc. Accounts Payable*92*2V

N3*PO Box 1407.N4*PEORIA*IL*616551407*US

NTE*GEN*DO NOT INVOICE WITH "ADVISE" PRICE WITHOUTCONTACTING YOUR

NTE*GEN*BUYER. FAILURE TO DO SO MAY RESULT IN DELAY OF

NTE*GEN*PAYMENT.                                             TO

NTE*GEN*INSURE MORE TIMELY INVOICE PAYMENTS, IT ISIMPERATIVE THAT

NTE*GEN*THE FOLLOWING INFORMATION BEINCLUDED ON YOUR PACKING

NTE*GEN*LIST/INVOICE: 1. CORRECT PURCHASE ORDER NUMBER 2. SUPPLIER

NTE*GEN*CODE 3. SHIP DATE AND UNIQUE SHIP REFERENCE NO. 4.

NTE*GEN*IDENTIFICATION NUMBER/PART NUMBER AS LISTED ON PURCHASE

NTE*GEN*ORDER 5. ITEM DESCRIPTION & QUANTITY REFER TO ITEM NUMBERS

NTE*GEN*AS SHOWN ON PURCHASE ORDER; (I.E.: ITEM 1, ITEM 2, ITEM 3

NTE*GEN*)6. SHIPMENTS WITH MULTIPLE P.O. NUMBERS MUST BE IDENTIFIED

NTE*GEN*ON PACKING LIST, INVOICE AND OUTSIDE OF PACKAGE.7. INVOICES

NTE*GEN*MUST BE SUBMITTED PRIOR TO BECOMING PAST DUE.FAILURE TO

NTE*GEN*COMPLY WITH THE ABOVE REQUIREMENTSMAY RESULT IN A DEBIT TO

NTE*GEN*YOUR COMPANY FORINTERNAL GRIEF CAUSED BY YOUR NON

NTE*GEN*COMPLIANCE

NTE*PUR*01-089011-07(0200)

NTE*PUR*Please enter our order for the above,subject to the terms,

NTE*PUR*conditions and instructions stated herein, -IMPORTANT- This

NTE*PUR*order expressly limits acceptance to the terms and

NTE*PUR*conditions stated herein including those on Caterpillar

NTE*PUR*Inc.Form No. 01-089011-07 (0200) or other form of terms and

NTE*PUR*conditions attached hereto.Any additional or different

NTE*PUR*terms heretofore or or hereafter proposed by the Seller are

NTE*PUR*rejected unless expressly assented to by us in writing

PO1*1*0*LB*716.7*PE*BP*1984308629*PD*CARBON BLACK N660*EC*00

CUR*BY*USD

ITA*C*AX*PC*06**22.5*******Packaging

ITA*C*AX*SC*06**.1*******Surcharge

NTE*GEN*N660 CARBON BLACKMATL SPEC 1E1308 CHG.LEVEL 03

NTE*GEN*Resale

NTE*GEN*Missouri Registration Number 12708496

CTT*1

SE*52*000000019

GE*1*9

IEA*1*000000174

please help me ,thanx in advance

[rajasekhar_reddy14]

writing a file content conversion for EDI files always challenging, i dont think you can configure standard file adpater to read EDI file.

write adpater module to handle this requirement and write a mapping logic to supress NTE segments.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/20ed5d5b-b188-2c10-76a2-997a616e4...