<?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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="OBJECTID" primary_key="True" type="String" size="90" precision="3" scale="1">
<description>Object Value</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UTIME" primary_key="True" type="Time" size="8" precision="2">
<description>Time changed</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>TIMS</FieldSapType><ParameterType></ParameterType></DataDictInfo></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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="PLANCHNGNR" type="String" size="12">
<description>Planned change number</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ACT_CHNGNO" type="String" size="10">
<description>Change number of the document created by this change</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="WAS_PLANND" type="String" size="1">
<description>Flag: Change created from planned changes</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CHANGE_IND" type="String" size="1">
<description>Type of Change to Application Object</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LANGU" type="String" size="2">
<description>Language Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>LANG</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VERSION" type="String" size="3">
<description>3-Byte field</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</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>
<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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="OBJECTID" primary_key="True" type="String" size="90" precision="3" scale="1">
<description>Object Value</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CHANGENR" primary_key="True" type="String" size="10" precision="3">
<description>Change Number of Document</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></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><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="FNAME" primary_key="True" type="String" size="30" precision="3" scale="1">
<description>Field Name</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CHNGIND" primary_key="True" type="String" size="1" precision="3" scale="1">
<description>Type of Change</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TEXT_CASE" type="String" size="1">
<description>Flag: X=Text change</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UNIT_OLD" type="String" size="3">
<description>Change documents, unit referenced</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>UNIT</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UNIT_NEW" type="String" size="3">
<description>Change documents, unit referenced</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>UNIT</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CUKY_OLD" type="String" size="5">
<description>Change documents, referenced currency</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CUKY</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CUKY_NEW" type="String" size="5">
<description>Change documents, referenced currency</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CUKY</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VALUE_NEW" type="String" size="254">
<description>New contents of changed field</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VALUE_OLD" type="String" size="254">
<description>Old contents of changed field</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</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>
<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
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
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
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
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
false
UserDefinedRow
CDPOS
CDPOS
VALUE_OLD
Old contents of changed field
CHAR
String
254
false
QueryRow
false
false
C
0
false
None
false
false
UserDefinedRow
CDPOS
CDPOS
VALUE_NEW
New contents of changed field
CHAR
String
254
false
QueryRow
false
false
D
0
false
None
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
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
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=