<?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>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</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>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</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>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="ERSDA" type="Date" size="10"> <description>Created On</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;DATS&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="ERNAM" type="String" size="12"> <description>Name of Person who Created the Object</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="LAEDA" type="Date" size="10"> <description>Date of Last Change</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;DATS&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="AENAM" type="String" size="12"> <description>Name of person who changed object</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="WERKS" type="String" size="4"> <description>Plant</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="LGORT" type="String" size="4"> <description>Storage location</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="LGNUM" type="String" size="3"> <description>Warehouse Number / Warehouse Complex</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="LGTYP" type="String" size="3"> <description>Storage Type</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="VKORG" type="String" size="4"> <description>Sales Organization</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="VTWEG" type="String" size="2"> <description>Distribution Channel</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="BWKEY" type="String" size="4"> <description>Valuation area</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="BWTAR" type="String" size="10"> <description>Valuation Type</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</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>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;LANG&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</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>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</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>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CHAR&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</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 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 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 true false UserDefinedRow MSTA MSTA ZHLER Counter CHAR String 5 true QueryRow false CHAR5 false D 0 false None false true false UserDefinedRow MSTA MSTA ERSDA Created On DATS Date 10 false QueryRow false DATUM false E 0 false None false true 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 true false UserDefinedRow MSTA MSTA LAEDA Date of Last Change DATS Date 10 false QueryRow false DATUM false G 0 false None false true false UserDefinedRow MSTA MSTA AENAM Name of person who changed object CHAR String 12 false QueryRow false USNAM false H 0 false None false true false UserDefinedRow MSTA MSTA WERKS Plant CHAR String 4 false QueryRow false WERKS false I 0 false None false true false UserDefinedRow MSTA MSTA LGORT Storage location CHAR String 4 false QueryRow false LGORT false J 0 false None false true false UserDefinedRow MSTA MSTA LGNUM Warehouse Number / Warehouse Complex CHAR String 3 false QueryRow false LGNUM false K 0 false None false true false UserDefinedRow MSTA MSTA LGTYP Storage Type CHAR String 3 false QueryRow false LGTYP false L 0 false None false true false UserDefinedRow MSTA MSTA VKORG Sales Organization CHAR String 4 false QueryRow false VKORG false M 0 false None false true false UserDefinedRow MSTA MSTA VTWEG Distribution Channel CHAR String 2 false QueryRow false VTWEG false N 0 false None false true false UserDefinedRow MSTA MSTA BWKEY Valuation area CHAR String 4 false QueryRow false BWKEY false O 0 false None false true false UserDefinedRow MSTA MSTA BWTAR Valuation Type CHAR String 10 false QueryRow false BWTAR false P 0 false None false 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 true 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=