In this article, I will try to present a comparison between Value mapping and TPM UDFs for incorporating ISA and GS segment values in outbound EDI interfaces.


Requirement:


–  Populating Sender ID, Sender ID Qualifier, Receiver ID, Receiver ID Qualifier,element separator, sub-element separator and segment separator for different business partners.

–  Usage indicator based on environment (T – Test, P- Production)

/wp-content/uploads/2014/03/value_1_402619.png

Value Mapping Approach:


Example:


/wp-content/uploads/2014/03/value_2_402650.png

Mapping Details:

-Value mapping for vendor number conversion- SAP vendors are converted into Legacy Vendors

-Value mapping for retrieving sender/receiver IDs and qualifiers- The output combination is separated by a delimiter (:) , the values are split and mapped to respective        fields (SplitID UDF)

-Value mapping for retrieving separators- The output combination is separated by a delimiter (:), the values are split using a simple UDF and mapped to respective    separator fields (SpiltSep UDF)   

– fillUpToLengthWithSpace UDF is used to add spaces to the first input to the UDF (spaces equal to second input) 

– Parameter defined for usage indicator- run time T or P is assigned      


/wp-content/uploads/2014/03/value_3_402669.png

ESR mapping


/wp-content/uploads/2014/03/udf_43_402702.png

/wp-content/uploads/2014/03/udf_36_402675.png

Value Maps-

/wp-content/uploads/2014/03/value_4_402694.png

UDFs used-


SplitSep


/wp-content/uploads/2014/03/value_5_402692.png


SplitID


/wp-content/uploads/2014/03/value_6_402693.png

fillUpToLengthWithSpace


/wp-content/uploads/2014/03/value_7_402701.png


NWDS configuration


/wp-content/uploads/2014/03/value_9_402708.png

Mass Export/Import-


/wp-content/uploads/2014/03/value_9_402708.png

Sample csv generated – maps can be added and the file can be imported


/wp-content/uploads/2014/03/udf_39_402712.png

/wp-content/uploads/2014/03/udf_40_402719.png

/wp-content/uploads/2014/03/udf_41_402721.png


ReferenceValue Mapping


Part II- Predefined UDFs – ISA and GS segments mapping – Value mapping v/s Predefined TPM UDFs – II

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply