webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

EDI document Mapping with SAP IDOC

webMethods Community Member

webMethods Community MemberTue July 20, 2004 08:46 PM

webMethods Community Member

webMethods Community MemberTue October 19, 2004 03:29 PM

  • 1.  EDI document Mapping with SAP IDOC

    Posted Fri June 25, 2004 04:12 PM

    Hello Everybody,
    We are running SAP Enterprise server connected to SAP Business Connector(WM Integration Server). I have imported the EDI Module also. I am passing SAP IDoc document to SAP BC and routed to flow Service but from there i am not able to proceed to convert into EDIFACT ORDERS Format which is completly different to SAP IDOC.
    Pls help me to proceed further .
    Regards
    Ajay


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 2.  RE: EDI document Mapping with SAP IDOC

    Posted Fri June 25, 2004 04:38 PM

    Once you have the IDOC in the routed flowservice pipeline then parse the IDOC (transformFlatToHierarchy)gives output IDOC structure then map the data to EDIFACT ORDERS individual Segments (UNH child segments)based on the mapping specifications and create UNH structure.

    Finally invoke WmEDI services (convertToString)pass the input FFSChema (EDIFACT ORDERS schema)this will create EDI String.Final steps will be invoking (wm.b2b.edi.util:addICEnvelopeEDIFACT)and pass the above created EDI String to (parameter “documents”)along with other inputs this will adds EDIFACT Envelope segments(UNB/UNG/UNZ).Bottom line is these steps will accomplish to EDIFACT ORDERS format.

    For validating the ORDERS envelope (UNB)segments you can use the envelopeProcess service before routing to external world.

    If you feel this not elaborate info,regarding mapping EDI segments
    please look into WmEDISamples package sample flows to get an overview.

    check this site www.unedifact.org for understanding EDIFACT ORDERS segments.

    HTH,


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: EDI document Mapping with SAP IDOC

    Posted Sat June 26, 2004 12:41 PM

    Hi ,
    Thanks for your reply. I tried to understand the process you mentioned.
    I need some more information on mapping SAP IDoc to EDIFACT ORDERS individual segments. Becos SAP EDI IDOC_DATA & IDOC_CONTROL cannot be directly mapped to individual segment of EDIFACT. Do i have to create a Idoc record type for mapping or write a java program to mapping.
    Thanks for your advice.
    Ajay


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 4.  RE: EDI document Mapping with SAP IDOC

    Posted Sat June 26, 2004 02:59 PM

    yes,you have to parse the IDOC to make recordstructure (for this create a IDOC recordtype based on the SAP provided Schema) and then use
    (transformFlatToHierrarchy)service output of this service map to a recordReference (IDOC doctype)then you will see IDOC_DATA_40 & IDOC_CONTROL_40 structures.Then start mapping the IDOC segments to the corresponding EDIFACT ORDERS segments based on the mapping specifications you got from your functional team.

    And rest follow the above procedure to make EDIFACT document.

    HTH,


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 5.  RE: EDI document Mapping with SAP IDOC

    Posted Mon June 28, 2004 04:03 PM

    I have created recordstructure and tried to map to IDOC coming from SAP but at the time of mapping i am not able to C how to map fields from SAP IDOc to Record Structure IDOc. Can U pls elaborate it more.
    I was also looking at EDISamples it is very difficult to understand it.
    Pls look into attachment what i did.
    Thank for you help
    Ajay


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 6.  RE: EDI document Mapping with SAP IDOC

    Posted Mon June 28, 2004 04:32 PM

    Ajay,

    I am not able to see the attachment properly.

    Are you using transformFlatToHierarchy SAP Adapter service?

    If so may the output of this service will be the IDOC recordStructure that you have created above,do a recordReference(IDOC structure) in the pipelineout and map it to this reference.next Add a map step and step thru the flow you will see the control and data record segments with the data.So there is no need to map manually to this IDOC structure and follow on with IDOc to EDI mapping which i mentioned above.

    Sorry if my comments confuses…


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 7.  RE: EDI document Mapping with SAP IDOC

    Posted Wed June 30, 2004 08:31 PM

    Hi,
    Now i have created the IDoc recordStructure and also the EDI Record Structure.
    I am building Services for example IDocToBGM, IDocTODTM etc.
    Exactly how the EDISamples given.
    Just for a trail purpose i called service convertToEDI . I could able to get the data but not in the format i want ie

    DTM+4:20040422:122’
    but in
    DTM+4+20040422+4’
    Service is not differentiating Subfield_separator.
    Am I doing any thing wrong in this service.
    I am considering WMEDISamples for desiging this flow services.

    Regards
    Ajay


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 8.  RE: EDI document Mapping with SAP IDOC

    Posted Wed June 30, 2004 10:19 PM

    If you are specifying the Subfield_separator( in convertToString service then for the EDIFACT document it should show correctly.

    I dont know what might be the reason that why it is not giving the ouput as expected for segments if they DTM/DTM01/Code1 and DTM/DTM01/Code2 like that…


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 9.  RE: EDI document Mapping with SAP IDOC

    Posted Thu July 01, 2004 12:16 AM

    Ajay,

    If I remember correctly you need a fix for this if you’re using 6.0.1.
    I ran into this issue last summer at a client.
    There are quite a few EDI Fixes in 6.0.1 surrounding convertToString and convertToValues. If you experience problems check advantage for possible fixes. It’ll save you alot of time.


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 10.  RE: EDI document Mapping with SAP IDOC

    Posted Thu July 01, 2004 02:43 PM

    Chris,

    I think Ajay is using SAP BC,so i think this fix may not apply for him which i noticed this in his initial posting.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 11.  RE: EDI document Mapping with SAP IDOC

    Posted Thu July 01, 2004 04:22 PM

    Thats true i am using SAP Business Connector 46 but from SAP download site i could able to see some Fix.zip file which i implemented already.


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 12.  RE: EDI document Mapping with SAP IDOC

    Posted Fri July 02, 2004 03:36 PM

    Hi,

    I am getting following error when i call the Service EDI:ConvertToString

    2004-07-02 15:59:46 GMT+02:00 java.lang.ClassCastException: com.wm.lang.ns.NSSchema.

    I have given NSRecord which is created from Schema downloaded from EDI Module.
    Regards
    Ajay


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 13.  RE: EDI document Mapping with SAP IDOC

    Posted Fri July 02, 2004 04:51 PM

    Are you passing the fully qualified EDIFACT ORDERS recordName (folder.subfolder:recordname) in that parameter (NSRecord)?Dont pass the schema name in that param instead use the record name.
    please make sure the syntax is correct.


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 14.  RE: EDI document Mapping with SAP IDOC

    Posted Fri July 02, 2004 06:36 PM

    Thanks alot I have now cracked the format. I can proceed with it now.
    Thanks once again for your kind help.
    Regards
    Ajay


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 15.  RE: EDI document Mapping with SAP IDOC

    Posted Mon July 05, 2004 01:17 PM

    I am able to create a EDIFACT structure. But SAP IDOc field values are not coming in the EDIFACT format though i did the mapping.
    I have download the record structures which is mapped to EDIFACT record structure. Values are present in the pipeline.

    Ajay


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 16.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 07, 2004 05:44 PM

    Ajay,

    Sorry for the delay,

    Can you please elaborate on the steps converting the EDIFACT document using convertToString service.looks like you might be missing some thing in the flow.
    And also you have to EDIFACT envelope after the convertToStrin step using (addICEnvelopeEDIFACT) WmEDI service.

    And pls try to post your questions in one thread instead of creating new ones.

    Thanks,


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 17.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 07, 2004 06:11 PM

    Hi,

    Sorry for posting it in a new thread. I thought this thread is closed.
    Coming to EDI Mapping
    I use the following Services

    1. transformFlatToHierarchy Service
    2. Map ORDERS05(SAP IDoc) to ORDERS97A(EDIFACT). Here in this step i map individual fields from ORDERS05 to OREDRS97A.
    3. ConvertToString

    Input : ORDERS97A mapped to Values
    nsRecord(EDIFACTRDER97A)
    Segment_termintor( ')
    Field_separator (+)
    Subfield_separtor (

    output String

    1. addICEnvelopeEDIFACT

    Input :
    String to documents and filled are fixed coded.

    Here is the example file
    UNB+UNOA:2+5106575900:01+9610774161:12+040705:0939+040513+1445+00000000001697’
    UNH+16975900+16970001RDERS:S:97A++CT:A97’
    BGM+271:SOP:9’
    DTM+242:102’
    PAI+1’
    RFF+ON:0000000036’
    NAD+BT+’
    CUX+7:EUR’
    TOD+++5’
    UNZ+1+040513’
    what to send SOP+BELNR(SAP Field ) to EDIFACT.

    Regards

    Ajay


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 18.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 07, 2004 09:08 PM

    Your flow is correct but i dont understand where you got stuck and about this statement "what to send SOP+BELNR(SAP Field ) to EDIFACT. "

    please let me know.


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 19.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 07, 2004 09:48 PM

    I am trying to map BELNR field of IDOC record structure to EDIFACT ORDERS For example
    BGM+271:BELNR(ex: 928373):9’
    928373 will be coming from SAP IDOc Orders.
    Finally segment should like this.

    BGM+271:928373:9’

    but i am getting BGM+271::9’
    It is the case for all the fields mapped from SAP IDoc to
    EDIFACT ORDERS

    Regards
    Ajay


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 20.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 07, 2004 10:08 PM

    If this is the case then the problem might be in the mapping part itself.
    So debug the mapping and step thru the flow and check the pipeline whether the BGM segment fields populating the values as expected and same applies for all the rest of the segments mapping issues you had.
    I know this is the hard way but this happens when ever we do complex mapping like EDI,IDOC…structures…

    Thanks,


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 21.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 07, 2004 10:18 PM

    Thanks for your reply.
    How can I debug the mapping step. Bcos i send the IDoc directly from SAP . I tried to keep break point at this point. But it doesnot stop .
    Can U help me with this.
    Ajay


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 22.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 07, 2004 10:29 PM

    In the flow service starting from these step there should be a Trace,Step incons under the Test menu option or it should be near the break point icon.But i have no idea about SAP BC tool.

    Once you got the idoc from SAP save it using savePipelineToFile and later restore it and step thru the flow as i mentioned above.So that you will have the IDOC structure and data in the pipeline.

    1.transformFlatToHierarchy Service
    2. Map ORDERS05(SAP IDoc) to ORDERS97A(EDIFACT). Here in this step i map individual fields from ORDERS05 to OREDRS97A.
    3. ConvertToString

    HTH,


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 23.  RE: EDI document Mapping with SAP IDOC

    Posted Thu July 08, 2004 05:13 PM

    Thanks for the reply. I tried the same and found out an interesting thing. I tried to loop our the record which has internally has several records.
    For example :
    ORDERS05
    —> IDOC(Record)
    ------IDOC[0]
    |–> EDI_DC04 (Record)
    |–> E1EDK01---->E1EDK01[0]

    i can map values from EDI_DC04 but not from E1EDK01 i dont understand i am still trying it.
    I need to pull the values from E1EDK01[0]-BELNR and so on
    Its the same case with other segments too.
    Presently i am loop over /ORDERS05/ORDERS05/IDOC

    Regards
    Ajay


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 24.  RE: EDI document Mapping with SAP IDOC

    Posted Thu July 08, 2004 05:31 PM

    In the /ORDERS05/ORDERS05/IDOC loop,create another sub-loop over E1EDK01---->E1EDK01[0] then map to corresponding EDIFACT segment, similarly same for others…

    I know this is complex,just make sure the loops are done correctly.

    HTH,


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 25.  RE: EDI document Mapping with SAP IDOC

    Posted Mon July 19, 2004 07:26 PM

    Hi OUTBOUND ORDERs works now.
    I am trying to get inbound DESADV into SAP System.
    As mentioned in the document i have created flow Service which has envelopeProcess, getEDIstring & convertToValues. But i am not getting Values out.

    Regards
    Ajay


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 26.  RE: EDI document Mapping with SAP IDOC

    Posted Mon July 19, 2004 09:10 PM

    Ajay,

    Nice to know Outbound mapping worked.

    If you want to parse the EDIFACT DESADV envelope data use the envelopeProcess (input edidata,validate=true,complianceCheck=true gives the Values .
    and for parsing transaction (UNH) data use the converToValues (input the edidata string,EDIFFSchema)gives the EDIValues.

    May be the mapping flow is messing up.Step thru the flow and check in the pipeline at what point it is breaking.

    HTH,


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 27.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 09:15 AM

    I checked it . Problem is coming from convertToValues in EnvelopeProcess. It is not generating Values document out.
    Service trying to loop over /values/UNB
    I am sending the file
    What I did is just copied the information using ctrl C and the pasted into input parameter edidata is it write what i did ??

    Regards
    Ajay

    UNB+UNOA:2+5106575900:01+9610774161:12+040507:1705+0405071705’
    UNH+3052+DESADV:S:97A:UN’
    BGM+351+MR14256+9’
    TM+11:200405071300:203’
    MEA+WT+AAB+KG:0’
    MOA+39:0:USD’
    MOA+124:0:USD’
    RFF+BM:’
    RFF+FO:0’
    RFF+IV:0’
    RFF+PK:MR14256’
    RFF+AAM:1Z1V05276642184304’
    NAD+WH+++MUNI’
    TDT+25++0’
    CPS+1’
    LIN+5++58500012:MF’
    IMD+F+8+:161::’
    MEA+CT+SQ+PK:5’
    QTY+21:5:PK’
    RFF+ON::5’
    RFF+CO:11:5’
    LIN+3++58500002:MF’
    IMD+F+8+:161::’
    MEA+CT+SQ+PK:2’
    QTY+21:3:PK’
    RFF+ON::3’
    RFF+CO:11:3’
    LIN+1++10800027:MF’
    IMD+F+8+:161::’
    MEA+CT+SQ+PK:2’
    QTY+21:2:PK’RFF+ON::1’
    RFF+CO:11:1’
    LIN+2++17000423:MF’
    IMD+F+8+:161::’
    MEA+CT+SQ+LB:0’
    QTY+21:1:LB’
    RFF+ON::2’
    RFF+CO:11:2’
    CNT+2:4’
    UNT+40+3052’
    UNZ+1+0405071705’


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 28.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 01:29 PM

    Ajay,

    The process is wm.b2b.edi:envelopeProcess
    Then wm.b2b.edi.util:getEDIstring
    Then wm.b2b.edi:convertToValues.

    See the WmEDISamples:sampleServices:UNEDIFACTtoValues example


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 29.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 01:39 PM

    Hi,
    I am using the same process .
    But i am not able to get Values out of envelopeProcess.
    I did the same thing what mentioned in the UNEDIFACTtoValues. No error no values out.

    Regards
    Ajay


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 30.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 02:48 PM

    Ajay,

    Check this out for testing.

    Disable the convertToValues and other services and just use the envelopeProcess service and pass the edidata.

    let see what happens.

    Thanks,


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 31.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 03:01 PM

    Ajay,

    I took your DESADV data and successful in parsing of UNB and UNH data and checked the pipeline Values/UNB and EDIValues/UNH loops are populating

    used these 2 steps for testing…

    envelopeProcess (edidata,validate=false)
    convertToValues (edidata,EDIFFSchema(DESADV 97A)

    But in the envelopeProcess if i set validate =true there are few nested errors which you may have to solve those erros and move further…i think the envelope data having some compliance errors.

    HTH,


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 32.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 04:11 PM

    Hi HTH,

    Thanks for your reply. I am getting Input template object in service
    wm.b2b.edi:convertToValues is null [EDICOR.000010.000822].
    Do i have to call the getTemplate first before convertToValues.

    Regards
    Ajay


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 33.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 04:16 PM

    Hi,

    Now i am getting wm.b2b.edi.EDIin: field stk not found

    in convertToValues Sevice
    Regards
    Ajay


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 34.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 04:25 PM

    Hi Ajay,

    Just for your info my name is RMG not HTH.(HTH=Hope this helps).

    well i am not seeing the above mentioned error here.

    Are you using SAP BC tool or IntegrationServer6.0/Developer/EDIModule?

    If you are using IS6.0 version then upload any sample package and just include your flow.I will check it here.

    Also lets try to minimise these threads here,debug the flow and make understanding if any thing is missed or messing the flow.

    HTH,
    RMG


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 35.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 05:10 PM

    Hi RMG,

    Sorry for that.
    I am using SAP BC 46 Version.

    Here is the Package which i am trying here

    DESADV
    TestPackages.zip (14.2 k)


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 36.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 05:17 PM

    Hi,
    Can U send me the Package where U developed inbound DESADV.
    It will help me too.

    Regards
    Ajay


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 37.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 05:53 PM

    Ajay,

    I am using IS6.01 but not SAP BC server.

    And i loaded your TestPackages and checked your service.similarly i created another _new service and attached the package.
    This service is working fine and make your flow the same way.

    Starting from IS/WmEDI6.01 we use EDIFFSchema instead of Templates.For SAP BC server/EDI i think it is still template mechanism.

    In the convertToValues service no need to pass the input delimiters.

    HTH,

    Load this Package
    TestPackages.zip (18.1 k)


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 38.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 06:16 PM

    Hey RMG [aka HTH ;-)]
    whats your call name?

    • Saurabh.

    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 39.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 06:41 PM

    Hi RMG,

    Your right SAP BC doesnot support FFSSchema but it works with Templates.
    I have redesigned the flow Service . But i am getting the following error.
    java.lang.reflect.InvocationTargetException: wm.b2b.edi.EDIin: field stk not found

    When i map edidata to edidata object in Service convertToValues.I thing is interesting when i map to ediObject i dont get the error.But EDIValues is NULL.

    In the Packages i have imported Templates for 97A. Pls check it once It will help me alot .

    Regards
    Ajay

    DESADV
    TestPackages.zip (23.9 k)


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 40.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 07:22 PM

    Ajay,

    I have loaded this package again here in IS6.0 server.

    And i noticed that you have made changes in the OutBound:UNEDIFACTtoValuesDesadv_new service (you added the getTemplate service).

    Here the getTemplate service output is giving(templateObject/templateObject/templateName=EDIFFSchema.UNEDIFACT.V97A:TDESADV) and i mapped this templateName to converToValues(EDIFFSchema) and output showing EDIValues(UNH segmets) as expected.

    So may be SAP BC tool users can help you and debug the flow and clear that error.

    Sorry for this…

    Regards,


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 41.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 07:25 PM

    Saurabh,

    Here the thread issue is different.Anyway call name is RMG.This is better.Any problem?


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 42.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 07:44 PM

    Hi RMG,

    After installing the SP WMEDI_4-6_SP.ZIP error has vanished .
    It is fixed now. I can C the EDIValues.

    Thanks for your Help

    Regards

    Ajay


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 43.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 20, 2004 08:46 PM


  • 44.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 21, 2004 03:35 PM

    Hi ,
    Presently i am trying to send the Data to SAP system i am using outboundProcess Flow service. But in IDOC_DATA_REC_40 record i am getting NULL.
    I mapped the EDIValues to DESADV(EDI) the I mapped DESADV to SAP IDOc Structure . This SAP IDoc structure i created from Schema which i got it from ifr.sap.com. As anything missing here.

    Regards
    Ajay


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 45.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 21, 2004 06:59 PM

    Ajay,

    Are you using transformHierarchyToFlat service?

    This service creates IDOC string based on the SAP schema)service is creating the problem.

    Make sure the necessary inputs are provided to this service,and check in the pipeline whether mapped IDOC document is creating properly.

    HTH,


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 46.  RE: EDI document Mapping with SAP IDOC

    Posted Thu August 12, 2004 03:24 PM

    I have a problem for DESADV document converting into IDOC.
    I am not able to fetch the values from LIN Segment in EDIFACT.
    It is inside /DESADV/UNH/CPS/LIN. I tried to loop over the segment and tried to map to SAP IDOc Segment. But values are not transfered into segment.
    Pls help me
    Ajay


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 47.  RE: EDI document Mapping with SAP IDOC

    Posted Thu August 12, 2004 04:53 PM

    Ajay,

    If you are looping on the In-Array (DESADV/UNH/CPS/LIN),so what is the structure of your IDOC segment that you are trying to map.

    and also if CPS is also a document list then you have to keep loops
    Loop In-Array /DESADV/UNH/CPS
    —/DESADV/UNH/CPS/LIN,
    ------------------Map here to target IDOC segment

    If the target segment is also a documentList then its better to create a temp document(IDOC Segment) and map the LIN fields to this temp document and finally inside the loop itself do appendToRecordList.

    If you are not comfortable doing this way try Out-Array with that particular IDOC segment.

    HTH,


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 48.  RE: EDI document Mapping with SAP IDOC

    Posted Tue August 17, 2004 11:53 AM

    Hi ,
    Looping as you said works without any problem.
    But appendToRecordList appends only one time.
    For example RECORD
    —RECORD[0]
    ------ MATNR = 12344

    IF i have two values MATNR 3445, MATNR 12344

    It appends only once .
    I am trying to get it in this fasion RECORD
    — RECORD[0]
    ---- MATNR = 3445
    — RECORD[1]
    ----- MATNR = 12344

    Pls help me out
    Regards
    Ajay


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 49.  RE: EDI document Mapping with SAP IDOC

    Posted Tue August 17, 2004 03:03 PM

    This shows that you are not dropping the fromItem of appendToRecordList so you are seeing the last RECORD[0]/MATNR = 12344 and it is overwriting all the records.

    So when you are mapping to appendToRecordList service what ever you map for fromItem drop that temporary record element,so that in runtime loop will append onebyone to the final recordList.

    Remember this appendToRecordlist should be inside the loop as a last step once you map the MTNR element using temporary record.

    HTH,
    RMG


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 50.  RE: EDI document Mapping with SAP IDOC

    Posted Fri August 20, 2004 01:22 PM

    Hi,
    My trading Partner recieved the EDIFACT document,
    He cannot process the document as UNA:+.? segment doesnot exist in my file.
    my file starts from
    UNB which is generated from addICEnvelopeEDIFACT
    ends with UNZ
    I dont know how to add UNA:+.? segment

    Regards
    Ajay


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 51.  RE: EDI document Mapping with SAP IDOC

    Posted Fri August 20, 2004 01:37 PM

    Ajay,

    I think the addICEnvelopeEDIFACT contains an argument called UNARequired or something similar which you can set to true. Specifying this should create the UNA segment.

    -Jordy


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 52.  RE: EDI document Mapping with SAP IDOC

    Posted Fri August 20, 2004 01:55 PM

    Hi Jordy,
    I am using SAP BC which has following parameters

    documents
    syntaxId
    syntaxVersion
    senderId
    senderQual
    reverseRoute
    receiverId
    receiverQual
    routingAddress
    ICreference
    password
    passwordQual
    applReference
    priority
    ackRequested
    agreementId
    testIndicator
    delimiters
    but not UNARequired.

    Regards
    Ajay


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 53.  RE: EDI document Mapping with SAP IDOC

    Posted Fri August 20, 2004 02:50 PM

    Ajay,

    In the addICEnvelopeEDIFACT service you should see the input element called UNARequired.since this param is almost widely used when processing EDIFACT documents.

    Since your above list doesnt show this param,so check in the Advantage site whether any fix is released for this problem.

    HTH,
    RMG


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 54.  RE: EDI document Mapping with SAP IDOC

    Posted Fri August 20, 2004 07:50 PM

    RMG,

    I tried to get the bug fix for EDIFACT. Unfortunatly i didnot get any fix for that .
    I tried also from SAP site to get bug fix implemented it didnot change in the service.
    Is it possible to get this class from any where else.
    Regards
    Ajay


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 55.  RE: EDI document Mapping with SAP IDOC

    Posted Fri August 20, 2004 08:33 PM

    As of now i dont have any other clues to resolve this issue unless if WM has released some fix.

    Other solution might be you have to some how set the UNA element in the EDIFACt data before routing it to the target system.Test this change.

    HTH,


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 56.  RE: EDI document Mapping with SAP IDOC

    Posted Mon October 04, 2004 06:19 PM

    I am trying to get multiple DESADV document in one envelope.
    Is it possible to multiple EDIFACt document which has one envelope.
    How can i proceed with it
    Ajay


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 57.  RE: EDI document Mapping with SAP IDOC

    Posted Mon October 04, 2004 07:32 PM

    yes you can have multiple DESADV documents in one envelope,so you have to loop thru UNB/UNH and extract the data and map it to target.

    HTH,
    RMg


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 58.  RE: EDI document Mapping with SAP IDOC

    Posted Thu October 14, 2004 04:00 PM

    Ajay,

    If the LIN segment is not an array then why you want to use Loop step for this,just extract the UNH/LIN segment data directly.


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 59.  RE: EDI document Mapping with SAP IDOC

    Posted Thu October 14, 2004 04:28 PM

    Ajay,

    I think the LIN segment should be a an array at the detail level of the document. If it’s not may be your schema is in correct. What version of wm and EDIFACT are you working with?
    Verfiy what you did but you may want to investigate if there’s a fix for this. It may not be you at fault here. I’m assuming you’re using 4.6 and I know I ran into similar issues.
    Just a thought.
    Good Luck!


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 60.  RE: EDI document Mapping with SAP IDOC

    Posted Fri October 15, 2004 05:37 PM

    Thanks for your comment .
    I found where the problem is when i send one DESADV in envelope
    i get UNH. On which i cannot loop.If i send more than one desadv in envelope i get UNH-- >UNH[0]
    UNH[1] as array.

    Logic works when 2 documents in one envelope but 1 document in 1 envelope doesnot work.
    Can U help me out here
    Ajay


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 61.  RE: EDI document Mapping with SAP IDOC

    Posted Fri October 15, 2004 06:52 PM

    Ajay,

    Basically if you receive DESADV that contains One Envelope UNB and one document (UNHwhich is an array then when you parse using convertToValues (based on the Template/Schema)you should see the UNHarray.If not so then there might be something wrong in the template that you are using or check if there any fix available for SAP BC/IS/EDI module to resolve the issue.

    This could be template problem or your convertToValues output is not behaving correctly when edidata has 1envelope UNB[0]/UNH[0]

    HTH,
    RMG.


    #Integration-Server-and-ESB
    #edi
    #webMethods


  • 62.  RE: EDI document Mapping with SAP IDOC

    Posted Fri October 15, 2004 11:02 PM

    This could be DESADV template related issue see if any fix available for SAP BC.
    So in the getTemplate service make sure u see the UNHin the output.

    HTH,
    RMG


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 63.  RE: EDI document Mapping with SAP IDOC

    Posted Sat October 16, 2004 04:30 AM

    Ajay,

    templateObject looks fine for UNH.
    But is the template object is showing UNHas a recordlist in the results tab?


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 64.  RE: EDI document Mapping with SAP IDOC

    Posted Tue October 19, 2004 03:26 PM

    RMG,

    I solved it based on values in UNZ->UNZ01 when 1 i dont loop over Values/UNB/UNH when more than 1 i loop over it.
    I confirmed with Trading Partner, they send always the correct problem.
    Ajay


    #webMethods
    #Integration-Server-and-ESB
    #edi


  • 65.  RE: EDI document Mapping with SAP IDOC

    Posted Tue October 19, 2004 03:29 PM

    Glad it resolved.

    goodluck,


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 66.  RE: EDI document Mapping with SAP IDOC

    Posted Fri October 29, 2004 09:11 PM

    Hi

    I am trying map XML to SAP IDOC. I created the XML Structure from the sample XML file and Created IDOC structure from SAP IDOC Schema. For Reference I attached both. I am using SAP Business Connector 4.6

    Can Some body let me know what is the wrong I am doing. It’s not going into loop.

    I appreciate your early resonse.


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 67.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 26, 2005 10:04 AM

    Hai

    HTH
    RMG

    I want Answers for the following questions?
    1.How to convert EDI X12 to IDOC.?
    2.procedure to send those convrted IDOC to SAPserver?
    3.How to get the IDOC of SAPserver to our IS?
    4.How to MAP EDI to IDOC?
    5.what are RFC,BAPI,ALE for what purpose they are used?

    I am learning sapadapter i am new to this so i don’t no how IS convert
    documents of clients in the form of XML,EDI ANSI X12 with sapsystem with
    SAPAdapter

    Thanks for u r reply ASAP

    Regards
    Rajesh


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 68.  RE: EDI document Mapping with SAP IDOC

    Posted Tue July 26, 2005 03:00 PM

    Rajesh,

    Do a search in this site,you will see may results on this basic procedure and process…

    Also read related tutorials,download it from Adavante.webmethods.com also look in the WM installed standard sample packages comes with EDIModule(Adapter),SAPAdapter…

    HTH,
    RMG


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 69.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 27, 2005 07:02 AM

    Hai

    HTH
    RMG

    Hai i read those wmEDI module and SAP adapter but i can’t get clear idea
    for the above Questions. so please give me answers for those each question
    some elaborate manner.I don’t need answer for those in one day.send me
    one Question answer per day

    Regards
    rajesh


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 70.  RE: EDI document Mapping with SAP IDOC

    Posted Wed July 27, 2005 02:59 PM

    Rajesh,

    Please search this entire site for your queries,i am sure there are related threads and look in the WMEDISamples package for more information on EDI.

    HTH,
    RMG


    #edi
    #Integration-Server-and-ESB
    #webMethods