<?xml version="1.0" encoding="utf-8"?>
<metadata xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.activequerybuilder.com/schemas/metadata2.xsd">
<database name="Winshuttle">
<schema name="WinshuttleDD">
<table name="JEST" alt_name="JEST (Individual Object Status)">
<description>Individual Object Status</description>
<user_data>TRANSP</user_data>
<field name="OBJNR" primary_key="True" type="String" size="22" precision="3">
<description>Object number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>ONR00</name>
</referenced_object>
<referencing_field name="OBJNR" referenced_field="OBJNR" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="STAT" primary_key="True" type="String" size="5" precision="3" scale="1">
<description>Object status</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="INACT" primary_key="True" type="String" size="1" precision="2">
<description>Indicator: Status Is Inactive</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CHGNR" type="String" size="3">
<description>Change number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="_DATAAGING" type="Date" size="10">
<description>Data Filter Value for Data Aging</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
</table>
<table name="TJ02T" alt_name="TJ02T (System status texts)">
<description>System status texts</description>
<user_data>TRANSP</user_data>
<field name="ISTAT" primary_key="True" type="String" size="5" precision="3">
<description>System status</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TJ02</name>
</referenced_object>
<referencing_field name="ISTAT" referenced_field="ISTAT" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="SPRAS" primary_key="True" type="String" size="2" precision="3">
<description>Language Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>LANG</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>T002</name>
</referenced_object>
<referencing_field name="SPRAS" referenced_field="SPRAS" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="TXT04" primary_key="True" type="String" size="4" precision="2">
<description>Individual status of an object (short form)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TXT30" type="String" size="30">
<description>Object status</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
</table>
</schema>
</database>
</metadata>
JEST,TJ02T
<ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.JEST.OBJNR, Winshuttle.WinshuttleDD.TJ02T.TXT04, Winshuttle.WinshuttleDD.TJ02T.TXT30 From Winshuttle.WinshuttleDD.JEST Inner Join Winshuttle.WinshuttleDD.TJ02T On Winshuttle.WinshuttleDD.JEST.STAT = Winshuttle.WinshuttleDD.TJ02T.ISTAT</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.JEST.OBJNR, Winshuttle.WinshuttleDD.TJ02T.TXT04, Winshuttle.WinshuttleDD.TJ02T.TXT30 From Winshuttle.WinshuttleDD.JEST Inner Join Winshuttle.WinshuttleDD.TJ02T On Winshuttle.WinshuttleDD.JEST.STAT = Winshuttle.WinshuttleDD.TJ02T.ISTAT"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.JEST" X="20" Y="20" Width="724" Height="400" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.TJ02T" X="764" Y="20" Width="350" Height="400" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
EPA
150
bkielas
ben.kielas@generac.com
2023-03-15T10:52:31.1783618-05:00
Table
ERP
Table
false
SELECT JEST.OBJNR,
TJ02T.TXT04,
TJ02T.TXT30
FROM JEST
INNER JOIN TJ02T ON JEST.STAT = TJ02T.ISTAT
JEST,TJ02T
0
false
Inner
false
false
false
true
false
true
false
false
true
25000
0
false
false
true
false
false
false
false
T:\Application Systems\Winshuttle\Studio\Data\SR-553597 UPDATE ORDER DATES.xlsx
STEP 2
2
Excel
D1
TAB
TAB
ONPREMISE
true
UserDefinedRow
JEST
JEST
OBJNR
Object number
CHAR
String
22
true
QueryRow
false
J_OBJNR
false
A
0
=TRIM(A2)
=TRIM(A2)
AA2
false
None
true
false
false
false
false
None
false
RunTime
In
false
PrePadWithZeros
FileValue
Excel
STEP 1
A
2
0
true
true
true
true
UserDefinedRow
JEST
JEST
INACT
Indicator: Status Is Inactive
CHAR
String
1
false
QueryRow
false
false
false
false
false
false
None
false
Fixed
Is Null
false
PrePadWithZeros
UserDefined
true
UserDefinedRow
TJ02T
TJ02T
TXT04
Individual status of an object (short form)
CHAR
String
4
false
QueryRow
false
TEXT4
false
B
0
false
None
false
false
false
false
false
SapOptional
false
RunTime
=
false
Or
PrePadWithZeros
REL
UserDefined
SapOptional
false
RunTime
=
false
And
PrePadWithZeros
CRTD
UserDefined
SapOptional
false
RunTime
=
true
PrePadWithZeros
DLV
UserDefined
true
UserDefinedRow
TJ02T
TJ02T
SPRAS
Language Key
LANG
String
2
true
QueryRow
false
SPRAS
false
false
false
false
false
SapOptional
false
RunTime
=
false
PrePadWithZeros
E
UserDefined
false
UserDefinedRow
TJ02T
TJ02T
TXT30
Object status
CHAR
String
30
false
QueryRow
false
TEXT30
false
C
0
false
None
false
STAT
5
JEST
JEST.STAT
TJ02T.ISTAT
ISTAT
5
TJ02T
Equal
Inner
2EtImU3RexxFEunijraaZld09mk=