<?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="ZTKNMT_LOG" alt_name="ZTKNMT_LOG (Southwire Customer-Material Info Record Create/Change/Delete)">
<description>Southwire Customer-Material Info Record Create/Change/Delete</description>
<user_data>TRANSP</user_data>
<field name="VKORG" primary_key="True" type="String" size="4" precision="3">
<description>Sales Organization</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TVKO</name>
</referenced_object>
<referencing_field name="VKORG" referenced_field="VKORG" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="VTWEG" primary_key="True" type="String" size="2" precision="3">
<description>Distribution Channel</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TVTW</name>
</referenced_object>
<referencing_field name="VTWEG" referenced_field="VTWEG" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="KUNNR" primary_key="True" type="String" size="10" precision="3">
<description>Customer 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>KNA1</name>
</referenced_object>
<referencing_field name="KUNNR" referenced_field="KUNNR" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="MATNR" primary_key="True" type="String" size="18" 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="KDMAT" primary_key="True" type="String" size="35" precision="3" scale="1">
<description>Material Number Used by Customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MSGFN" type="String" size="3">
<description>Function</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZZCMIR_KEY" type="String" size="10">
<description>Southwire Customer Material Info Record Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
</table>
<table name="ZTKNMT" alt_name="ZTKNMT (Southwire Customer-Material Info Record Data Table)">
<description>Southwire Customer-Material Info Record Data Table</description>
<user_data>TRANSP</user_data>
<field name="VKORG" primary_key="True" type="String" size="4" precision="3">
<description>Sales Organization</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TVKO</name>
</referenced_object>
<referencing_field name="VKORG" referenced_field="VKORG" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="VTWEG" primary_key="True" type="String" size="2" precision="3">
<description>Distribution Channel</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<foreignkey>
<referenced_object>
<name>TVTW</name>
</referenced_object>
<referencing_field name="VTWEG" referenced_field="VTWEG" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="KUNNR" primary_key="True" type="String" size="10" precision="3">
<description>Customer 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>KNA1</name>
</referenced_object>
<referencing_field name="KUNNR" referenced_field="KUNNR" />
<referencing_cardinality>Many</referencing_cardinality>
<referenced_cardinality>One</referenced_cardinality>
</foreignkey>
<field name="MATNR" primary_key="True" type="String" size="18" 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="ZZCMIR_KEY" primary_key="True" type="String" size="10" precision="3" scale="1">
<description>Southwire Customer Material Info Record Key</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KDMAT" primary_key="True" type="String" size="35" precision="2">
<description>Material Number Used by Customer</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LVORM" type="String" size="1">
<description>Deletion Indicator</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</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="ERDAT" type="Date" size="10">
<description>Date on Which Record Was Created</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="SORTL" type="String" size="10">
<description>Sort field</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="POSTX" type="String" size="40">
<description>Customer description of material</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="LPRIO" type="String" size="2">
<description>Delivery Priority</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>NUMC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MINLF" type="Decimal" size="17">
<description>Minimum delivery quantity in delivery note processing</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>QUAN</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MEINS" type="String" size="3">
<description>Base Unit of Measure</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>UNIT</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CHSPL" type="String" size="1">
<description>Batch split allowed</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="KZTLF" type="String" size="1">
<description>Partial Delivery at Item Level</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ANTLF" type="Decimal" size="1">
<description>Maximum Number of Partial Deliveries Allowed Per Item</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UNTTO" type="Decimal" size="4">
<description>Underdelivery Tolerance Limit</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UEBTO" type="Decimal" size="4">
<description>Overdelivery Tolerance Limit</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UEBTK" type="String" size="1">
<description>Unlimited overdelivery allowed</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 (Own or External)</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="RDPRF" type="String" size="4">
<description>Rounding Profile</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="MEGRU" type="String" size="4">
<description>Unit of Measure Group</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="J_1BTXSDC" type="String" size="2">
<description>SD tax code</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VWPOS" type="String" size="4">
<description>Item usage</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="VRKME_T" type="String" size="3">
<description>Sales Unit</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>UNIT</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UMVKN_T" type="Decimal" size="6">
<description>Denominator (Divisor) for Conversion of Sales Qty into SKU</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="UMVKZ_T" type="Decimal" size="6">
<description>Numerator (factor) for conversion of sales quantity into SKU</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DEC</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="TXTKZ" type="String" size="1">
<description>Indicator: long text exists</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZZCSPEC_NO" type="String" size="30">
<description>Customer Spec Number/Title</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="ZZCSR_DAT" type="Date" size="10">
<description>Customer Spec Revision Date</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CRDAT" type="Date" size="10">
<description>Creation date</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CRTIM" type="Time" size="8">
<description>Created At</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>TIMS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="CRNAM" type="String" size="12">
<description>Created By</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="AEDAT" 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="AETIM" type="Time" size="8">
<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="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="DELETE_DATE" type="Date" size="10">
<description>Deletion date</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>DATS</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
<field name="DELETE_BY" type="String" size="12">
<description>Deleted By</description>
<user_data><?xml version="1.0" encoding="utf-16"?><DataDictInfo><FieldSapType>CHAR</FieldSapType><ParameterType></ParameterType></DataDictInfo></user_data>
</field>
</table>
</schema>
</database>
</metadata>
ZTKNMT_LOG,ZTKNMT
<ActiveQueryBuilderLayout><SQL>Select Winshuttle.WinshuttleDD.ZTKNMT.CRNAM, Winshuttle.WinshuttleDD.ZTKNMT.AETIM, Winshuttle.WinshuttleDD.ZTKNMT.AENAM, Winshuttle.WinshuttleDD.ZTKNMT.CRTIM From Winshuttle.WinshuttleDD.ZTKNMT_LOG Inner Join Winshuttle.WinshuttleDD.ZTKNMT On Winshuttle.WinshuttleDD.ZTKNMT_LOG.VKORG = Winshuttle.WinshuttleDD.ZTKNMT.VKORG And Winshuttle.WinshuttleDD.ZTKNMT_LOG.VTWEG = Winshuttle.WinshuttleDD.ZTKNMT.VTWEG And Winshuttle.WinshuttleDD.ZTKNMT_LOG.KUNNR = Winshuttle.WinshuttleDD.ZTKNMT.KUNNR And Winshuttle.WinshuttleDD.ZTKNMT_LOG.MATNR = Winshuttle.WinshuttleDD.ZTKNMT.MATNR</SQL><SubQueries><SubQuery SQL="Select Winshuttle.WinshuttleDD.ZTKNMT.CRNAM, Winshuttle.WinshuttleDD.ZTKNMT.AETIM, Winshuttle.WinshuttleDD.ZTKNMT.AENAM, Winshuttle.WinshuttleDD.ZTKNMT.CRTIM From Winshuttle.WinshuttleDD.ZTKNMT_LOG Inner Join Winshuttle.WinshuttleDD.ZTKNMT On Winshuttle.WinshuttleDD.ZTKNMT_LOG.VKORG = Winshuttle.WinshuttleDD.ZTKNMT.VKORG And Winshuttle.WinshuttleDD.ZTKNMT_LOG.VTWEG = Winshuttle.WinshuttleDD.ZTKNMT.VTWEG And Winshuttle.WinshuttleDD.ZTKNMT_LOG.KUNNR = Winshuttle.WinshuttleDD.ZTKNMT.KUNNR And Winshuttle.WinshuttleDD.ZTKNMT_LOG.MATNR = Winshuttle.WinshuttleDD.ZTKNMT.MATNR"><UnionSubQuery><DataSource SQL="Winshuttle.WinshuttleDD.ZTKNMT_LOG" X="20" Y="20" Width="350" Height="400" Collapsed="False" /><DataSource SQL="Winshuttle.WinshuttleDD.ZTKNMT" X="390" Y="20" Width="729" Height="475" Collapsed="False" /></UnionSubQuery></SubQuery></SubQueries></ActiveQueryBuilderLayout>
PSE
100
velezc
carlos.velez@southwire.com
2024-04-08T16:36:29.9909576-04:00
ZD51
IDOC Failure Rewport for Payton Seagle
ERP
Table
false
SELECT ZTKNMT.CRNAM,
ZTKNMT.AETIM,
ZTKNMT.AENAM,
ZTKNMT.CRTIM
FROM ZTKNMT_LOG
INNER JOIN ZTKNMT ON (ZTKNMT_LOG.VKORG = ZTKNMT.VKORG) AND (ZTKNMT_LOG.VTWEG =
ZTKNMT.VTWEG) AND (ZTKNMT_LOG.KUNNR = ZTKNMT.KUNNR) AND (ZTKNMT_LOG.MATNR =
ZTKNMT.MATNR)
ZTKNMT_LOG,ZTKNMT
0
false
Inner
false
false
false
false
false
true
false
false
true
25000
0
false
false
true
false
false
false
false
C:\Users\velezc\Documents\Winshuttle\Studio\Data\ZD51 IDOC Failure Report.xlsx
Sheet1
2
Excel
A1
TAB
TAB
ONPREMISE
false
UserDefinedRow
ZTKNMT
ZTKNMT
CRNAM
Created By
CHAR
String
12
false
QueryRow
false
false
C
0
false
None
false
false
UserDefinedRow
ZTKNMT
ZTKNMT
AETIM
Time changed
TIMS
Time
8
false
QueryRow
false
false
D
0
false
None
false
false
UserDefinedRow
ZTKNMT
ZTKNMT
AENAM
Name of person who changed object
CHAR
String
12
false
QueryRow
false
false
E
0
false
None
false
false
UserDefinedRow
ZTKNMT
ZTKNMT
CRTIM
Created At
TIMS
Time
8
false
QueryRow
false
false
B
0
false
None
false
true
UserDefinedRow
ZTKNMT
ZTKNMT
VKORG
Sales Organization
CHAR
String
4
true
QueryRow
false
false
false
false
false
false
SapOptional
false
Fixed
=
false
PrePadWithZeros
1000
UserDefined
true
UserDefinedRow
ZTKNMT
ZTKNMT
VTWEG
Distribution Channel
CHAR
String
2
true
QueryRow
false
false
false
false
false
false
SapOptional
false
Fixed
=
false
PrePadWithZeros
10
UserDefined
true
UserDefinedRow
ZTKNMT
ZTKNMT
KUNNR
Customer number
CHAR
String
10
true
QueryRow
false
false
false
false
false
false
SapOptional
false
RunTime
=
false
Or
NoPadding
UserDefined
SapOptional
false
RunTime
=
false
NoPadding
UserDefined
true
UserDefinedRow
ZTKNMT
ZTKNMT
KDMAT
Material Number Used by Customer
CHAR
String
35
false
QueryRow
false
false
false
false
false
false
None
false
RunTime
In
false
NoPadding
UserDefined
VKORG
4
ZTKNMT_LOG
ZTKNMT_LOG.VKORG
ZTKNMT.VKORG
VKORG
4
ZTKNMT
Equal
Inner
VTWEG
2
ZTKNMT_LOG
ZTKNMT_LOG.VTWEG
ZTKNMT.VTWEG
VTWEG
2
ZTKNMT
Equal
Inner
KUNNR
10
ZTKNMT_LOG
ZTKNMT_LOG.KUNNR
ZTKNMT.KUNNR
KUNNR
10
ZTKNMT
Equal
Inner
MATNR
18
ZTKNMT_LOG
ZTKNMT_LOG.MATNR
ZTKNMT.MATNR
MATNR
18
ZTKNMT
Equal
Inner
EsXxbKhFmOvCGdLWI4gH2ZU6jME=