-
Notifications
You must be signed in to change notification settings - Fork 0
/
MII_MM_XML_to_C4J_XML_AUTO_MOVE.xsl
141 lines (115 loc) · 7.18 KB
/
MII_MM_XML_to_C4J_XML_AUTO_MOVE.xsl
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:c4j="http://www.commander4j.com"
xmlns:c4j_XSLT_Ext="http://com.commander4j.Transformation"
exclude-result-prefixes="xs c4j c4j_XSLT_Ext" version="2.0">
<xsl:output encoding="UTF-8" indent='yes' method="xml" />
<xsl:strip-space elements="*"/>
<!--
MARA - General Material Data (Material) E1MARAM E2MARMM002GRP E2MARAM005GRP
MAKT - Material Descriptions. (Material - Language)
MARC - Plant Data (Material - Plant) E1MARCM
MARD - Storage Location Data (Material - Plant - Storage Location)
MARM - Units of Measure (Material - Unit of Measure)
MEAN - EAN's (Material - Unit of Measure - Sequence No)
MLGN - Warehouse Data (Material - Warehouse) E2MLGNM001GRP
MARA E1MARAM - Master material general data
MARC E1MARCM - Master material C segment
MLGN E1MLGNM - Master material material data per warehouse number
-->
<!-- CONFIG DATA -->
<xsl:variable name="HOSTREF" select="string(c4j:getConfigItem('config','HostRef'))"/>
<xsl:variable name="PLANT" select="string(c4j:getConfigItem('config','Plant_Central'))"/>
<xsl:variable name="WAREHOUSE" select="string(c4j:getConfigItem('config','Warehouse'))"/>
<xsl:variable name="LOCATION_LOC" select="string(c4j:getConfigItem('config','Location'))"/>
<xsl:variable name="LOCATION_CTR" select="string(c4j:getConfigItem('config','Location_Central'))"/>
<xsl:variable name="PROCUREMENT_IND" select="string(c4j:getConfigItem('config','Procurement_Ind'))"/>
<!-- Local Variables -->
<xsl:variable name="MATERIAL" select="string(c4j_XSLT_Ext:removeLeadingZeros(string(/ZMATMAS03/IDOC/E1MARAM/MATNR)))"/>
<xsl:variable name="MTYPE" select="string(/ZMATMAS03/IDOC/E1MARAM/MTART)"/>
<xsl:variable name="USE_PLANT" select="string(/ZMATMAS03/IDOC/E1MARAM/_-NESGLB_-DISTR000/WERKS[.=$PLANT]/../AD_PLANT_DATA)"/>
<xsl:variable name="FOUND_PLANT" select="string(/ZMATMAS03/IDOC/E1MARAM/E1MARCM/WERKS[.=$PLANT])"/>
<xsl:variable name="FOUND_WAREHOUSE" select="string(/ZMATMAS03/IDOC/E1MARAM/E1MLGNM/LGNUM[.=$WAREHOUSE])" />
<xsl:variable name="PROCUREMENT_FOUND" select="string(/ZMATMAS03/IDOC/E1MARAM/E1MARCM/WERKS[.=$PLANT]/../SOBSL)" />
<xsl:variable name="PROCUREMENT_COUNT" select="count(/ZMATMAS03/IDOC/E1MARAM/E1MARCM/WERKS[.=$PLANT]/../SOBSL)"/>
<xsl:template match="/ZMATMAS03">
<message>
<xsl:text>
</xsl:text>
<xsl:comment>>USE PLANT = [<xsl:value-of select="$USE_PLANT"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:comment>>FOUND PLANT = [<xsl:value-of select="$FOUND_PLANT"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:comment>>FOUND WAREHOUSE = [<xsl:value-of select="$WAREHOUSE"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:comment>>LOCATION_LOC = [<xsl:value-of select="$LOCATION_LOC"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:comment>>LOCATION_CTR = [<xsl:value-of select="$LOCATION_CTR"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:comment>>PROCUREMENT_IND = [<xsl:value-of select="$PROCUREMENT_IND"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:comment>>PROCUREMENT_FOUND = [<xsl:value-of select="$PROCUREMENT_FOUND"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:comment>>PROCUREMENT_COUNT = [<xsl:value-of select="$PROCUREMENT_COUNT"/>]</xsl:comment>
<xsl:text>
</xsl:text>
<xsl:apply-templates select="IDOC"/>
</message>
</xsl:template>
<xsl:template match="IDOC">
<xsl:apply-templates select="EDI_DC40"/>
<messageData>
<materialAutoMove>
<xsl:apply-templates select="E1MARAM"/>
</materialAutoMove>
</messageData>
</xsl:template>
<xsl:template match="EDI_DC40">
<plant><xsl:value-of select="$PLANT"/></plant>
<warehouse><xsl:value-of select="$WAREHOUSE"/></warehouse>
<hostRef><xsl:value-of select="$HOSTREF"/></hostRef>
<interfaceType>Material Auto Move</interfaceType>
<interfaceDirection>Input</interfaceDirection>
<xsl:variable name="SAPDOCNUM_LONG" select="string(DOCNUM)" />
<xsl:variable name="SAPDOCNUM_SHORT" select="c4j_XSLT_Ext:removeLeadingZeros($SAPDOCNUM_LONG)" />
<messageRef>DOCNUM <xsl:value-of select="$SAPDOCNUM_SHORT"/></messageRef>
<messageInformation>Material=<xsl:value-of select="$MATERIAL"/>/<xsl:value-of select="$MTYPE"/></messageInformation>
<xsl:variable name="CREATE_DATE" select="c4j_XSLT_Ext:trim(string(CREDAT))" />
<xsl:variable name="CREATE_TIME" select="c4j_XSLT_Ext:trim(string(CRETIM))" />
<xsl:variable name="CREATE_DATETIME" select="c4j_XSLT_Ext:concat($CREATE_DATE,$CREATE_TIME)" />
<messageDate><xsl:value-of select="c4j_XSLT_Ext:formatDate($CREATE_DATETIME, 'yyyyMMddHHmmss', 'yyyy-MM-dd''T''HH:mm:ss')"/></messageDate>
</xsl:template>
<xsl:template match="E1MARAM">
<xsl:if test="$PLANT = $FOUND_PLANT">
<xsl:if test="$PROCUREMENT_COUNT = 1">
<xsl:if test="$PROCUREMENT_FOUND = $PROCUREMENT_IND">
<material><xsl:value-of select="$MATERIAL"/></material>
<moveAfterMake>Y</moveAfterMake>
<moveLocationID><xsl:value-of select="$LOCATION_CTR"/></moveLocationID>
</xsl:if>
<xsl:if test="$PROCUREMENT_FOUND != $PROCUREMENT_IND">
<material><xsl:value-of select="$MATERIAL"/></material>
<moveAfterMake>N</moveAfterMake>
<moveLocationID><xsl:value-of select="$LOCATION_LOC"/></moveLocationID>
</xsl:if>
</xsl:if>
</xsl:if>
</xsl:template>
<!-- ================
FUNCTION get config data
================ -->
<xsl:function name="c4j:getConfigItem">
<xsl:param name="type"/>
<xsl:param name="string1"/>
<xsl:variable name="item_info" select="document('configData.xml')/lookup"/>
<xsl:value-of select="$item_info/item[@type=$type][@id=$string1]/value"/>
</xsl:function>
<!-- ================
FUNCTION get reference data
================ -->
<xsl:function name="c4j:getReferenceItem">
<xsl:param name="type"/>
<xsl:param name="string1"/>
<xsl:variable name="item_info" select="document('referenceData.xml')/lookup"/>
<xsl:value-of select="$item_info/item[@type=$type][@id=$string1]/value"/>
</xsl:function>
</xsl:stylesheet>