Requisition for Mapping Help on the Below Requirment!!!

[Former Member]

Hello Experts,

     Would request you to kindly help on the below requirment.Here are the below details.

Sender Structure                          

Node A                                                                                    

     X=1234(Field-Material Number)                                                 

Node B                                                                                              

     M = 1100(Field- Sales Organisation)                                                 

     N  = RS(Sales Distribution)                                                                                                                 

Node C                                                                                                                                                                                                             

     P=12341100RS(Document Name)

Node D

Sales text= 999

Node D

Sales text= 1999

Node D

Sales text= 2999

Node B

     M = 1101(Field- Sales Organisation)

     N  = AG(Sales Distribution)

Node D

Sales text= 999

Node D

Sales text= 1999

Node D

Sales text= 2999

Node C

     P=12341101AG(Document Name)

Node B

     M = 1102(Field- Sales Organisation)

     N  =OT(Sales Distribution)

Node D

Sales text= 999

Node D

Sales text= 1999

Node D

Sales text= 2999

Node C

     P=12341102OT(Document Name)

Node B

     M = 1500(Field- Sales Organisation)

     N  = IC(Sales Distribution)

Node D

Sales text= 999

Node D

Sales text= 1999

Node D

Sales text= 2999

     Initially I need to Concat the field X=1234(Material Number) with the fields M(Sales Organisation) and N(Sales Distribution) and then I need to compare with the field P(Document Name). If this case is true then only I have to send Sales Text with Node D to Target with the corresponding field value.

So from the above example, If we compare 12341101AG in Node C is equal to 1234(X)1101(M)AG(N) after concatenation in Node B, Similarly for

12341101RS in Node C is equal to 1234(X)1101(M)RS(N) after concatenation in Node B and 12341101OTin Node C is equal to 1234(X)1101(M)OT(N) after concatenation in Node B. Then I have to send the Sales text values(99,1999 and 2999) for the combination 12341101AG,12341101RS and 12341101OT only but not for the last combination(1500IC) since it does not contain Document Name in Node C.Here is Below Target Structure requried

Target Structure(Required)

SalesDocument(Node)

      SalesView(Node)

                    DocumentName= 12341100RS(Field)

                    Salestext = 99(Field)

       SalesView(Node)

                    DocumentName= 12341100RS(Field)

                    Salestext = 1999(Field) 

          SalesView(Node)

                    DocumentName= 12341100RS(Field)

                    Salestext = 2999(Field) 

          SalesView(Node)

                    DocumentName= 12341101OT(Field)

                    Salestext = 99(Field)

           SalesView(Node)

                    DocumentName= 12341101OT(Field)

                    Salestext = 1999(Field) 

          SalesView(Node)

                    DocumentName= 12341101OT(Field)

                    Salestext = 2999(Field) 

          SalesView(Node)

                    DocumentName= 12341102AG(Field)

                    Salestext = 99(Field)

           SalesView(Node)

                    DocumentName= 12341102AG(Field)

                    Salestext = 1999(Field) 

             SalesView(Node)

                    DocumentName= 12341102AG(Field)

                    Salestext = 2999(Field) 

Would request your response at the earliest.. Kindly do the Needful.

Many Thanks,

Best Regards,

Prashanth Bharadwaj Ch.

[pvishnuvardan_reddy]

Hi Prashanth,

Can you pls share the mapping screen shot for better understanding of the requirement.

Regards

Vishnu

[Former Member]

Hi Vishnu,

     Sorry for the late Reply. Here is the below screen shot.

     So from the above screen shot i need to compare the TDLline with the concatenation outuput of MATNR, VKORG and VTWEG. If the output is correct then I have to form the corresponding salestext nodes under sales View node.

Kindly do the needful. Thanks in advance!

Many Thanks,

Best Regards,

Prashanth Bharadwaj Ch.

[pvishnuvardan_reddy]

Hi prashanth,

Use Concatenate string function and concatenate the required fields-->use String function equals and compare TDLINE and the previous output-->pass this to CreateIf node function-->pass this to the target node.

Accordingly populate the target subfields.

Please check this logic and let me know if any issues.

Regards

vishnu

[sendhil_kumar]

Prashanth,

Can you give your mapping screenshot with these source fields and target fields.

--

Sendhil

[Former Member]

Hi Senthil,

     Sorry for the late Reply. Here is the below screen shot.

     So from the above screen shot i need to compare the TDLline with the concatenation outuput of MATNR, VKORG and VTWEG. If the output is correct then I have to form the corresponding salestext nodes under sales View node.

Kindly do the needful. Thanks in advance!

Many Thanks,

Best Regards,

Prashanth Bharadwaj Ch.