Skip to Content
author's profile photo Former Member
Former Member

Type of DTP

Hi All

What r the types of dtp and what r the use of each one?

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2008 at 05:51 AM

    Hi Amnindher,

    Please check : [Data Transfer Process |http://help.sap.com/saphelp_nw04s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm]

    Hope it Helps

    Srini

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2008 at 05:52 AM

    Hi,

    There are 4 types of DTP's in BI 7.0, which are

    1. Standard DTP

    2. DTP for Realtime data acquisition

    You use the data transfer process (DTP) for real-time data acquisition to transfer data to the DataStore object from the PSA. In the DataStore object, the data is available for use in reporting

    http://help.sap.com/saphelp_nw04s/helpdata/en/42/f80a3f6a983ee4e10000000a1553f7/content.htm

    3. DTP for Direct data access

    You can only use the type DTP for Direct Access as the target of the data transfer process for a VirtualProvider.

    http://help.sap.com/saphelp_nw04s/helpdata/en/42/fb8ed8481e1a61e10000000a422035/content.htm

    4. Error DTP

    For a data transfer process (DTP), you can specify how you want the system to respond when data records contain errors. If you activate error handling, the records with errors are written to a request-based database table (PSA table). This is the error stack. You can use a special data transfer process, the error DTP, to update the records to the target.

    http://help.sap.com/saphelp_nw04s/helpdata/en/42/fbd598481e1a61e10000000a422035/content.htm

    Regards

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 14, 2008 at 05:56 AM

    You want distinction on the basis on what ???

    You can say there are two DTPs :

    1) Normal DTP : Nornal Loading.

    2) Error DTP : Loading errored records

    Or

    On the basis of type of load :

    1) Full

    2) Delta

    Or

    DTP for Direct Access :

    You can only use the type DTP for Direct Access as the target of the data transfer process for a VirtualProvider. More information.

    data transfer processes for real-time data acquisition :

    If you use the data transfer process in a process chain, you can only use the standard data transfer as the target of the data transfer process for a DataStore object. More information about data transfer processes for real-time data acquisition:

    Source :

    http://help.sap.com/saphelp_nw04s/helpdata/en/42/fa50e40f501a77e10000000a422035/content.htm

    Hope this helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2008 at 05:56 AM

    Thanks !!

    I am closing this thread

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2008 at 06:01 AM

    Hi.......

    Check this :

    SAP NetWeaver 7.0 BI: Data Transfer Process (DTP) / Blog Series

    Regards,

    Debjani.....

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 11:50 AM

    heh guys,

    I am facing an issue , The DTPs are being duplicated for one particular Data source .

    Can some one help plz

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      During the transformation, the data record for request 109882 is duplicated to multiple data records. If, for example, there is no SID for the characteristic value calendar day 07-03-2005, the record is interpreted as erroneous. The duplicated records are not updated to the target. The data record that formed the duplicate records is written to the error stack. In the error stack, the record is listed as containing an error every time it duplicates data records with errors.

      Req no Data record Order no cal day

      109882 01 1000 07.01.2005

      109882 02 1000 07.03.2005----


      this record written to error stack

      109882 03 1000 07.02.2005

      Regards,

      Vamsi Krishna Chandolu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.