<?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="MSTA" alt_name="MSTA (Material Master Status)">
<description>Material Master Status</description>
<user_data>TRANSP</user_data>
<field name="MATNR" primary_key="True" type="String" size="40" precision="3">
<description>Material 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>MARA</name>
</referenced_object>
<referencing_field name="MATNR" referenced_field="MATNR" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="STATM" primary_key="True" type="String" size="1" precision="3">
<description>Maintenance Status of Material Master Record</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>T132</name>
</referenced_object>
<referencing_field name="STATM" referenced_field="STATM" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="ZHLER" primary_key="True" type="String" size="5" precision="3" scale="1">
<description>Counter</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ERSDA" type="Date" size="10">
<description>Created On</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ERNAM" type="String" size="12">
<description>Name of Person who Created the Object</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LAEDA" type="Date" size="10">
<description>Date of Last Change</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="AENAM" type="String" size="12">
<description>Name of person who changed object</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="WERKS" type="String" size="4">
<description>Plant</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LGORT" type="String" size="4">
<description>Storage location</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LGNUM" type="String" size="3">
<description>Warehouse Number / Warehouse Complex</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LGTYP" type="String" size="3">
<description>Storage Type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VKORG" type="String" size="4">
<description>Sales Organization</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VTWEG" type="String" size="2">
<description>Distribution Channel</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BWKEY" type="String" size="4">
<description>Valuation area</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="BWTAR" type="String" size="10">
<description>Valuation Type</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
</table>
<table name="T132T" alt_name="T132T (Definition of Valid Statuses)">
<description>Definition of Valid Statuses</description>
<user_data>TRANSP</user_data>
<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="STATM" primary_key="True" type="String" size="1" precision="3">
<description>Maintenance Status of Material Master Record</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>T132</name>
</referenced_object>
<referencing_field name="STATM" referenced_field="STATM" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="STTXT" type="String" size="40">
<description>Description of maintenance 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>
MSTA,T132T
<ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.MSTA.MATNR, Winshuttle.WinshuttleDD.MSTA.STATM, Winshuttle.WinshuttleDD.MSTA.ZHLER, Winshuttle.WinshuttleDD.MSTA.ERSDA, Winshuttle.WinshuttleDD.MSTA.ERNAM, Winshuttle.WinshuttleDD.MSTA.LAEDA, Winshuttle.WinshuttleDD.MSTA.AENAM, Winshuttle.WinshuttleDD.MSTA.WERKS, Winshuttle.WinshuttleDD.MSTA.LGORT, Winshuttle.WinshuttleDD.MSTA.LGNUM, Winshuttle.WinshuttleDD.MSTA.LGTYP, Winshuttle.WinshuttleDD.MSTA.VKORG, Winshuttle.WinshuttleDD.MSTA.VTWEG, Winshuttle.WinshuttleDD.MSTA.BWKEY, Winshuttle.WinshuttleDD.MSTA.BWTAR, Winshuttle.WinshuttleDD.T132T.STTXT From Winshuttle.WinshuttleDD.MSTA Inner Join Winshuttle.WinshuttleDD.T132T On Winshuttle.WinshuttleDD.MSTA.STATM = Winshuttle.WinshuttleDD.T132T.STATM</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.MSTA.MATNR, Winshuttle.WinshuttleDD.MSTA.STATM, Winshuttle.WinshuttleDD.MSTA.ZHLER, Winshuttle.WinshuttleDD.MSTA.ERSDA, Winshuttle.WinshuttleDD.MSTA.ERNAM, Winshuttle.WinshuttleDD.MSTA.LAEDA, Winshuttle.WinshuttleDD.MSTA.AENAM, Winshuttle.WinshuttleDD.MSTA.WERKS, Winshuttle.WinshuttleDD.MSTA.LGORT, Winshuttle.WinshuttleDD.MSTA.LGNUM, Winshuttle.WinshuttleDD.MSTA.LGTYP, Winshuttle.WinshuttleDD.MSTA.VKORG, Winshuttle.WinshuttleDD.MSTA.VTWEG, Winshuttle.WinshuttleDD.MSTA.BWKEY, Winshuttle.WinshuttleDD.MSTA.BWTAR, Winshuttle.WinshuttleDD.T132T.STTXT From Winshuttle.WinshuttleDD.MSTA Inner Join Winshuttle.WinshuttleDD.T132T On Winshuttle.WinshuttleDD.MSTA.STATM = Winshuttle.WinshuttleDD.T132T.STATM"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.MSTA" X="20" Y="20" Width="350" Height="400" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.T132T" X="504" Y="16" Width="350" Height="400" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
HF7
000
sigridk
syncdi1\Sigrid.Kok
2024-04-16T14:10:32.5456504-07:00
Table
Table
true
false
SELECT MSTA.MATNR,
MSTA.STATM,
MSTA.ZHLER,
MSTA.ERSDA,
MSTA.ERNAM,
MSTA.LAEDA,
MSTA.AENAM,
MSTA.WERKS,
MSTA.LGORT,
MSTA.LGNUM,
MSTA.LGTYP,
MSTA.VKORG,
MSTA.VTWEG,
MSTA.BWKEY,
MSTA.BWTAR,
T132T.STTXT
FROM MSTA
INNER JOIN T132T ON MSTA.STATM = T132T.STATM
MSTA,T132T
0
false
Inner
false
false
false
false
false
true
false
false
true
0
0
false
false
true
false
false
false
false
C:\Files\Winshuttle\Query\Demos\MM Statuses\MM Statuses.xlsx
Sheet1
2
Excel
T1
TAB
TAB
ONPREMISE
true
UserDefinedRow
MSTA
MSTA
MATNR
Material Number
CHAR
String
40
true
QueryRow
false
MATNR
false
A
0
false
None
false
false
false
false
false
SapOptional
false
RunTime
=
false
Or
PrePadWithZeros
SK-2000
UserDefined
SapOptional
false
RunTime
Between
false
PrePadWithZeros
UserDefined
UserDefined
true
UserDefinedRow
MSTA
MSTA
STATM
Maintenance Status of Material Master Record
CHAR
String
1
true
QueryRow
false
STATM
false
B
0
false
None
false
false
false
false
false
SapOptional
false
RunTime
Between
false
Or
PrePadWithZeros
UserDefined
UserDefined
SapOptional
false
RunTime
=
false
PrePadWithZeros
UserDefined
false
UserDefinedRow
MSTA
MSTA
ZHLER
Counter
CHAR
String
5
true
QueryRow
false
CHAR5
false
D
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
ERSDA
Created On
DATS
Date
10
false
QueryRow
false
DATUM
false
E
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
ERNAM
Name of Person who Created the Object
CHAR
String
12
false
QueryRow
false
USNAM
false
F
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
LAEDA
Date of Last Change
DATS
Date
10
false
QueryRow
false
DATUM
false
G
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
AENAM
Name of person who changed object
CHAR
String
12
false
QueryRow
false
USNAM
false
H
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
WERKS
Plant
CHAR
String
4
false
QueryRow
false
WERKS
false
I
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
LGORT
Storage location
CHAR
String
4
false
QueryRow
false
LGORT
false
J
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
LGNUM
Warehouse Number / Warehouse Complex
CHAR
String
3
false
QueryRow
false
LGNUM
false
K
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
LGTYP
Storage Type
CHAR
String
3
false
QueryRow
false
LGTYP
false
L
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
VKORG
Sales Organization
CHAR
String
4
false
QueryRow
false
VKORG
false
M
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
VTWEG
Distribution Channel
CHAR
String
2
false
QueryRow
false
VTWEG
false
N
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
BWKEY
Valuation area
CHAR
String
4
false
QueryRow
false
BWKEY
false
O
0
false
None
false
false
UserDefinedRow
MSTA
MSTA
BWTAR
Valuation Type
CHAR
String
10
false
QueryRow
false
BWTAR
false
P
0
false
None
false
true
UserDefinedRow
T132T
T132T
SPRAS
Language Key
LANG
String
2
true
QueryRow
false
SPRAS
false
false
false
false
false
SapOptional
false
RunTime
=
false
PrePadWithZeros
EN
UserDefined
false
UserDefinedRow
T132T
T132T
STTXT
Description of maintenance status
CHAR
String
40
false
QueryRow
false
TEXT40
false
C
0
false
None
false
STATM
1
MSTA
MSTA.STATM
T132T.STATM
STATM
1
T132T
Equal
Inner
sBTtHzRb+Pe1Wcvk7e0xbyv2Cvw=