DSP Expert

1. Community
2. Data Questions & Discussion
3. Can someone help me read the status for fields whose MODIF in TMODU is greater than 100?

AGarcia: Here is an example for FIELD status group = '3000'. Yours could be different: SELECT dbo.TMODU.TABNM, dbo.TMODU.FELDN, dbo.T004F.FSTAG, dbo.T004F.BUKRS, dbo.TMODU.MODIF, dbo.T004F.FAUS1, d...

• View comment
• DSP Expert
• February 21, 2017 06:15
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do I determine in-transit inventory?

SUddin: The system runs an availability check in the supplying plant (issuing plant) for stock transport orders. The checking rules that you define in Customizing determine which stocks (for exampl...

• View comment
• DSP Expert
• February 08, 2017 16:00
• 1 vote

1. Community
2. Data Questions & Discussion
3. Can anyone advise how to override the default code page when retrieving data from Oracle?

MUpton:  Navigate to Assemble > Configuration > Connection Types. Find the row “SQL” and the column “Code Page.” Change the value from 2 to 1. Navigate to the Vertical View of the Assemble package...

• View comment
• DSP Expert
• February 03, 2017 15:18
• 1 vote

1. Community
2. Data Questions & Discussion
3. How do I automate the movement of files using a custom application?

MBohne: This can also be accomplished using a DOS Batch file and either running it via Powershell, scheduled task, etc. The NET USE command can be fed login information to map a drive to a remote ...

• View comment
• DSP Expert
• June 18, 2018 08:37
• 0 votes

1. Community
2. Data Questions & Discussion
3. Can users work in the DSP while a CTS archive is being installed?

PTowe: Andy, having used CTS on a live system I can tell you how it appears to behave. As no-one else has replied, maybe this is better than no answer? My comments are based on CTS in ADM 6.5. Firs...

• View comment
• DSP Expert
• June 15, 2018 11:31
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

VGazquez: Hi Syed, In addition to the previous answers, please check this post in Data Insiders, which details how to merge tables in Collect: https://support.syniti.com/hc/en-us/community/posts/36...

• View comment
• DSP Expert
• May 29, 2018 09:29
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

ASliney: What version of DSP are you on? You're running the package directly from Assemble, correct? Did you try putting in a dummy Where clause for the delete e.g., MATNR = '0'? I tested this on a...

• View comment
• DSP Expert
• May 28, 2018 13:53
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

PCardoso: My approach to enable this through a robust Collect process is to create a replica of the table in question with a different name (e.g. TABLE_Delta) and build the Collect Process using th...

• View comment
• DSP Expert
• May 28, 2018 15:02
• 0 votes

1. Community
2. Data Questions & Discussion
3. How do you load batch data into the ‘sdb’ database through ADM/DSP without deleting the existing data from the table?

ASliney: The truncate step is built into Collect (but not Assemble) and is not skippable. On the vertical view of the Assemble package, on the Advanced Properties tab, turn off Target Delete Record...

• View comment
• DSP Expert
• May 28, 2018 13:34
• 0 votes

1. Community
2. Data Questions & Discussion
3. Has anyone updated a custom WebApp built for Outlook 2003 to be compatible with Outlook 2010?

PWadekar: Recompile and minor re-structuring worked for outlook integration with DSP.

• View comment
• DSP Expert
• May 23, 2018 12:02
• 0 votes