Results 1 to 2 of 2

Thread: SQL Serve Management Studio - SDROUT

  1. #1

    SQL Serve Management Studio - SDROUT

    Hello,
    I am using SQL Developer to extract the data from JDE, but I installed the SQL Server Management Studio recently in my PC, as it faster and allow me to connect to excel

    I tried to use the same query from the SQL Developer in SQL Server Management Studio, however the code SDROUT doesn't exit in SQL Server

    The code which I am using

    select SDROUT, SDKCOO, SDSRP2,SDDOCO, SDDCTO,SDDOC,SDDCT,SDAN8,SDECST/100,SDAEXP/100,SDLITM,SDPQOR,SDADDJ,SDMCU,SDPQOR,SDPQOR, ABAC16,ABAC15, sdnxtr,sdcrcd,sdcrr,imbuyr
    FROM stage.dbo.F4211
    JOIN stage.dbo.f0101 on sdan8=aban8 JOIN stage.dbo.F4101 on sditm=imitm


    Does someone knows which field would represent SDROUT in SQL Server?



    regards,

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Location
    Spokane, WA, USA
    Posts
    3,149
    I suspect its not SDROUT that's missing but rather the table location is incorrect (or if not incorrect its not standard).

    Normally the table would be referenced as stage.f4211 - not stage.dbo.f4211 (assuming stage is a real data source in your environment).
    So try changing the table schema references to remove dbo and possibly also correct stage to CRPDTA or ...
    Larry Jones
    E1 9.1 - TR 9.1.5 on Win 2012 R2. Oracle DB 11.2.04
    Wintel, BI Publisher

    Migrating to JDE 9.2 and SQL Server 2016

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.