Skip to Content

Summary


This blog explains about extracting the data with an Open Hub Destination using Logical path.

Creating Open Hub Destination


Go to Transaction RSA1-Open hub destination– Create

https://weblogs.sdn.sap.com/weblogs/images/251925283/image001.png|height=257|alt=image|width=618|src=https://weblogs.sdn.sap.com/weblogs/images/251925283/image001.png|border=0! </p><p> </p><p>!https://weblogs.sdn.sap.com/weblogs/images/251925283/image003.png|height=245|alt=image|width=422|src=https://weblogs.sdn.sap.com/weblogs/images/251925283/image003.png|border=0!</p><p>Logical file should be defined (Customized) in Maintain Client-Independent Names and File Paths </p><p> </p><p>

Creating Logical File


Go to Transaction code : FILE


STEP 1: Select Logical File Path Definition and Click on New Entries

<p>!https://weblogs.sdn.sap.com/weblogs/images/251925283/image005.png|height=201|alt=image|width=369|src=https://weblogs.sdn.sap.com/weblogs/images/251925283/image005.png|border=0!</p><p> </p><p> </p><p>Enter the Logical file path and Name</p><p>

Logical file path: ZOH_TEST_LOGICALPATH_DATAOUT

Name: ZOH_TEST_LOGICALPATH_DATAOUT

!https://weblogs.sdn.sap.com/weblogs/images/251925283/image007.png|height=63|alt=image|width=524|src=https://weblogs.sdn.sap.com/weblogs/images/251925283/image007.png|border=0!

Select the newly created Logical file path and Double click on Assignment of Physical Paths to Logical Path.

image

Click on New Entries

!https://weblogs.sdn.sap.com/weblogs/images/251925283/image011.png|height=217|alt=image|width=632|src=https://weblogs.sdn.sap.com/weblogs/images/251925283/image011.png|border=0!

 

Select the Syntax group as: Windows NT

Physical Path:

debosap74\interfaces\iface\xxx\Physical path in detail

  • debosap74\interfaces\iface\xxx : Application Directory Path (AL11)
  • Daily.csv  : Name of the file name  [This is replaced at runtime by the physical file (or path) name.]
  • <HOUR>.<MINUTE>.<SECOND>_<DAY>-<MONTH>-<YEAR> : Time and Date

Note: These all are the reserved words, which are substituted by the current values at run time. Reason to use TIME and DATE after CSV is to pull the latest file basing on the data and time by the interface.Please use F1 for more information about reserved words in Physical path.


image

Save the Logical file path

STEP 2: Now we need to create Logical File name in Logical File Name Definition-Cross Client

Select the Logical File Name Definition-Cross Client and click on New Entries

image

Logical file      : ZOH_TEST_LOGICALFILE_DATAOUT ( you can define your own)

Name              : ZOH_TEST_LOGICALFILE_DATAOUT  ( you can define your own)

Physical file    : ZOH_TEST  ( you can define your own)

Note: While creating a Logical Path, we should not leave the physical file as blank.

  • Data format: ASC (ASCII format)

  • Application area: BW (Business Information Warehouse)

  • Logical path: ZOH_TEST_LOGICALPATH_DATAOUT

Note: Select the Logical path which was created in Logical File Path Definition from the drop down list

Save the Logical file name Now go back to Open hub destination (ZOH_TEST)

Application Server file name: ZOH_TEST_LOGICALFILE_DATAOUT

image

Save Check and Activate the Open hub (ZOH_TEST).

Create Transformation and DTP

+image

image

Execute the DTP


image

Now Go to AL11 : (Path) –> debosap74\interfaces\iface\xxx\ ( your own path here)


image

The system will generate two File names in AL11


1) S_ZOH_TEST_DAILY.CSV_13.22.20_07-01-2010: This is a Structure which contains information only about the header.


2) ZOH_TEST_DAILY.CSV_13.22.20_07-01-2010    : This is Actual file which contains data

Note: When you create an Open hub destination using Physical file, the file will get created in DIR_HOME directory (by default) in AL11.We will use System command in the process chain which will transfer the file between directories

When you create an Open hub using a Logical file, we do not need a system command in the Process chain. Since we are specifying the directory in which the file should get saved.

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Zeynep Birim
    Hi,
    This blog was very helpful for me, thank you.
    I just wanted to add something, in my case Windows NT syntax group didn’t work and i used UNIX instead of Windows NT,it’s working good right now.

    Regards,
    Zeynep

    (0) 

Leave a Reply