<?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="CDHDR" alt_name="CDHDR (Change document header)"> <description>Change document header</description> <user_data>TRANSP</user_data> <field name="OBJECTCLAS" primary_key="True" type="String" size="15" precision="3" scale="1"> <description>Object class</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="OBJECTID" primary_key="True" type="String" size="90" precision="3" scale="1"> <description>Object Value</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="CHANGENR" primary_key="True" type="String" size="10" precision="3" scale="1"> <description>Change Number of Document</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="USERNAME" primary_key="True" type="String" size="12" precision="2"> <description>User name of the person responsible in change document</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="UDATE" primary_key="True" type="Date" size="10" precision="2"> <description>Creation date of the change document</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="UTIME" primary_key="True" type="Time" size="8" precision="2"> <description>Time changed</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;TIMS&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="TCODE" primary_key="True" type="String" size="20" precision="2"> <description>Transaction in which a change was made</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="PLANCHNGNR" type="String" size="12"> <description>Planned change 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> <field name="ACT_CHNGNO" type="String" size="10"> <description>Change number of the document created by this change</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="WAS_PLANND" type="String" size="1"> <description>Flag: Change created from planned changes</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="CHANGE_IND" type="String" size="1"> <description>Type of Change to Application 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="LANGU" type="String" size="2"> <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> <field name="VERSION" type="String" size="3"> <description>3-Byte field</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="_DATAAGING" type="Date" size="10"> <description>Data Filter Value for Data Aging</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> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTCLAS" referenced_field="OBJECTCLAS" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTID" referenced_field="OBJECTID" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTCLAS" referenced_field="OBJECTCLAS" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTID" referenced_field="OBJECTID" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTCLAS" referenced_field="OBJECTCLAS" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTID" referenced_field="OBJECTID" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTCLAS" referenced_field="OBJECTCLAS" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDPOS</name> </referenced_object> <referencing_field name="OBJECTID" referenced_field="OBJECTID" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> </table> <table name="CDPOS" alt_name="CDPOS (Change document items)"> <description>Change document items</description> <user_data>TRANSP</user_data> <field name="OBJECTCLAS" primary_key="True" type="String" size="15" precision="3" scale="1"> <description>Object class</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="OBJECTID" primary_key="True" type="String" size="90" precision="3" scale="1"> <description>Object Value</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="CHANGENR" primary_key="True" type="String" size="10" precision="3"> <description>Change Number of Document</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>CDHDR</name> </referenced_object> <referencing_field name="CHANGENR" referenced_field="CHANGENR" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <field name="TABNAME" primary_key="True" type="String" size="30" precision="3" scale="1"> <description>Table Name</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="TABKEY" primary_key="True" type="String" size="70" precision="3" scale="1"> <description>Changed table record key</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="FNAME" primary_key="True" type="String" size="30" precision="3" scale="1"> <description>Field Name</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="CHNGIND" primary_key="True" type="String" size="1" precision="3" scale="1"> <description>Type of Change</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="TEXT_CASE" type="String" size="1"> <description>Flag: X=Text change</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="UNIT_OLD" type="String" size="3"> <description>Change documents, unit referenced</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;UNIT&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="UNIT_NEW" type="String" size="3"> <description>Change documents, unit referenced</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;UNIT&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="CUKY_OLD" type="String" size="5"> <description>Change documents, referenced currency</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CUKY&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="CUKY_NEW" type="String" size="5"> <description>Change documents, referenced currency</description> <user_data>&lt;?xml version="1.0" encoding="utf-16"?&gt;&lt;DataDictInfo&gt;&lt;FieldSapType&gt;CUKY&lt;/FieldSapType&gt;&lt;ParameterType&gt;&lt;/ParameterType&gt;&lt;/DataDictInfo&gt;</user_data> </field> <field name="VALUE_NEW" type="String" size="254"> <description>New contents of changed field</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="VALUE_OLD" type="String" size="254"> <description>Old contents of changed field</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="_DATAAGING" type="Date" size="10"> <description>Data Filter Value for Data Aging</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> <foreignkey> <referenced_object> <name>CDHDR</name> </referenced_object> <referencing_field name="OBJECTCLAS" referenced_field="OBJECTCLAS" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> <foreignkey> <referenced_object> <name>CDHDR</name> </referenced_object> <referencing_field name="OBJECTID" referenced_field="OBJECTID" /> <referencing_cardinality>Many</referencing_cardinality> <referenced_cardinality>One</referenced_cardinality> </foreignkey> </table> </schema> </database> </metadata> CDHDR,CDPOS <ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.CDHDR.UDATE, Winshuttle.WinshuttleDD.CDPOS.VALUE_OLD, Winshuttle.WinshuttleDD.CDPOS.VALUE_NEW, Winshuttle.WinshuttleDD.CDPOS.OBJECTID From Winshuttle.WinshuttleDD.CDHDR Inner Join Winshuttle.WinshuttleDD.CDPOS On Winshuttle.WinshuttleDD.CDPOS.OBJECTCLAS = Winshuttle.WinshuttleDD.CDHDR.OBJECTCLAS And Winshuttle.WinshuttleDD.CDPOS.OBJECTID = Winshuttle.WinshuttleDD.CDHDR.OBJECTID And Winshuttle.WinshuttleDD.CDPOS.CHANGENR = Winshuttle.WinshuttleDD.CDHDR.CHANGENR</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.CDHDR.UDATE, Winshuttle.WinshuttleDD.CDPOS.VALUE_OLD, Winshuttle.WinshuttleDD.CDPOS.VALUE_NEW, Winshuttle.WinshuttleDD.CDPOS.OBJECTID From Winshuttle.WinshuttleDD.CDHDR Inner Join Winshuttle.WinshuttleDD.CDPOS On Winshuttle.WinshuttleDD.CDPOS.OBJECTCLAS = Winshuttle.WinshuttleDD.CDHDR.OBJECTCLAS And Winshuttle.WinshuttleDD.CDPOS.OBJECTID = Winshuttle.WinshuttleDD.CDHDR.OBJECTID And Winshuttle.WinshuttleDD.CDPOS.CHANGENR = Winshuttle.WinshuttleDD.CDHDR.CHANGENR"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.CDHDR" X="20" Y="20" Width="350" Height="400" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.CDPOS" X="412" Y="20" Width="350" Height="400" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
S4Q 010 supersebara EUROPEAN\sebara 2022-09-06T05:20:09.7495871-04:00 PT_EMA and Master Data_KR2 ERP Table
false SELECT CDHDR.UDATE, CDPOS.VALUE_OLD, CDPOS.VALUE_NEW, CDPOS.OBJECTID FROM CDHDR INNER JOIN CDPOS ON (CDPOS.OBJECTCLAS = CDHDR.OBJECTCLAS) AND (CDPOS.OBJECTID = CDHDR.OBJECTID) AND (CDPOS.CHANGENR = CDHDR.CHANGENR) CDHDR,CDPOS 0 false Inner false false false false false true false false true 25000 0 false false true false false false false C:\Users\vkutasi\Desktop\TestKREMAReport.xlsx Sheet1 2 Excel E1 TAB TAB ONPREMISE true true UserDefinedRow CDHDR CDHDR UDATE Creation date of the change document DATS Date 10 false QueryRow false false A 0 false None false false false false false None false Fixed Between false NoPadding StartOfYear Constant Today Constant false true UserDefinedRow CDHDR CDHDR TCODE Transaction in which a change was made CHAR String 20 false QueryRow false false false false false false SapOptional false Fixed = false PrePadWithZeros XD02 UserDefined false true UserDefinedRow CDHDR CDHDR OBJECTCLAS Object class CHAR String 15 true QueryRow false false false false false false SapOptional false Fixed = false PrePadWithZeros DEBI UserDefined false true UserDefinedRow CDPOS CDPOS FNAME Field Name CHAR String 30 true QueryRow false false false false false false SapOptional false Fixed = false PrePadWithZeros ZTERM UserDefined true false UserDefinedRow CDPOS CDPOS VALUE_OLD Old contents of changed field CHAR String 254 false QueryRow false false C 0 false None false true false UserDefinedRow CDPOS CDPOS VALUE_NEW New contents of changed field CHAR String 254 false QueryRow false false D 0 false None false false true UserDefinedRow CDPOS CDPOS CHNGIND Type of Change CHAR String 1 true QueryRow false false false false false false SapOptional false Fixed = false PrePadWithZeros U UserDefined false true UserDefinedRow CDPOS CDPOS TEXT_CASE Flag: X=Text change CHAR String 1 false QueryRow false false false false false false SapOptional false Fixed = false PrePadWithZeros 1 UserDefined true false UserDefinedRow CDPOS CDPOS OBJECTID Object Value CHAR String 90 true QueryRow false false B 0 false None false OBJECTCLAS 15 CDHDR CDHDR.OBJECTCLAS CDPOS.OBJECTCLAS OBJECTCLAS 15 CDPOS Equal Inner OBJECTID 90 CDHDR CDHDR.OBJECTID CDPOS.OBJECTID OBJECTID 90 CDPOS Equal Inner CHANGENR 10 CDHDR CDHDR.CHANGENR CDPOS.CHANGENR CHANGENR 10 CDPOS Equal Inner C:\Users\vkutasi\Desktop\TestKREMAReport.xlsx 2 Sheet1 false Excel 0 false true false 25000 true Table C:\Users\vkutasi\Desktop\TestKREMAReport.xlsx 2 Sheet1 false Excel 0 false true false 25000 true Table C:\Users\vkutasi\Desktop\TestKREMAReport.xlsx 2 Sheet2 false Excel 0 false true false 25000 true Table C:\Users\vkutasi\Desktop\TestKREMAReport.xlsx 2 Sheet3 false Excel 0 false true false 25000 true Table SNlPOIeiIm4BQxnCsjBTTWUhySc=