ISA and GS segment values – Value mapping v/s Predefined TPM UDFs – I
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)
Value Mapping Approach:
Example:
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
ESR mapping
Value Maps-
UDFs used-
SplitSep
SplitID
fillUpToLengthWithSpace
NWDS configuration
Mass Export/Import-
Sample csv generated – maps can be added and the file can be imported
Reference – Value Mapping
Part II- Predefined UDFs – ISA and GS segments mapping – Value mapping v/s Predefined TPM UDFs – II
Well explained !
Good representation
Excellent job Pooja !!