Skip to Content
avatar image
Former Member

BW, PIPE and POS DM

Hi,

The retail/POS data load--> to POS DM ---> to BW cubes.

POS DM is part of the BI Content. So you'll have to import BI Content 3.5.3 to get POS DM functionality. Core transactions are /POSDW/MON0 for the POS Workbench and /POSDW/IMG for customizing. You can use the standard POS Inbound IDOCs (WPUUMS, WPUTAB, WPUBON, WPUWBW, WPUFIB) or (and that's the recommended way) BAPI /POSDW/BAPI_POSTR_CREATE.

After you put the data into the PIPE (pos inbound processing engine) via BAPI (XI), there is nothing else like customizing to distribute these to either the infocubes or something else.So I will give you a basic idea of the steps needed to transfer the data into the cubes.

Go to TN /POSDW/IMG (/n/POSDW/IMG).

There you build your own customizing profil, potentially Z001.

Then you go to the "POS Transactions" and lateron onto "Type Group for POS Transactions". Copy any type you need from the standard profil of the sap.

The same thing you do with the "Category for POS Transactions". Take care of the entry "Incl./Excl. Task Grp", this is where you link your specific data to a taskgroup. There are tasks linked to any taskgroup, for instance the one you need to feed the cubes. ("Supply BW Immediately, Non-Aggre., w. Distribution")

Naturally you have to customize the taskgroup and the tasks as well as the transaction categories and lateron the connection between the tasks and the taskgroup in "Tasks for Taskgroup". (should be copy action too)

If you set up the "Type of Task" to "Immediate Processing", then the data will be processed into the deltasource in the moment there are reaching the pipe.

All you have to do then is to connect the deltasource to the cubes in TN RSA1.

There is a Blogg with regard to this inquiry in which way sap pos dm is provided with data.

/people/uwe.beister/blog/2006/05/02/sap-pos-dm-which-type-of-idoc-should-be-used-in-pos-dm-inbound

Find POS related help at the below links

http://help.sap.com/saphelp_erp2005vp/helpdata/en/12/084110470311d1894a0000e8323352/frameset.htm

http://help.sap.com/saphelp_erp2005vp/helpdata/en/0f/7af634b576bc4ee10000009b38f83b/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/0d/e4813e77d46245e10000000a114084/frameset.htm

For training : SAP IS Retail:

http://www12.sap.com/services/education/catalog/industry/retail.epx

https://websmp202.sap-ag.de/~sapidp/011000358700000541792007E

I can't able to open the above links. So can anyone share the documents which is present in the above links.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 27, 2015 at 05:33 AM

    Hi,

    It has complete Document...Kindly look into

    Use of IDocs - SAP POS Data Management - SAP Library

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 27, 2015 at 08:22 AM

    Rajesh,

    I have given to relevant Document links..

    Kindly Read it Fully and Understand the concept

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 26, 2015 at 02:34 PM

    Hi Rajesh,

    take help of POSDM consultant to do the initial configuration, because there are lot many things(tender types, financial type, GL account mapping etc etc) need to customize as per business requirement.

    you can go to "retail" space for more information on PODSM. when you start pulling the sales /TRN files to BW, and if you are stuck at some point, then you can seek help here .

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Jyothi,

      Thanks for your valuable reply.

      Actually I am new to this POSDM concept and I am just started learning this from past 2 weeks.

      I have analysed a lot and I have some basic idea of the data flow from POS system to POSDM and then to SAP BI.

      So if you have some documents or procedures of the data flow from SAP PI to SAP POSDM kindly share with me.

      1. What are all the standard IDOC's for POSDM?

      2. How IDOC's are connected with PIPE Tlog tables?

      3. How to send data from Tlog tables to the standard data sources like 0RT_PA_TRAN_TOTAL etc.

      4. As of now I know that data will be stored in Tlog, then what is the PIPE structure shown below is related with Data Source.

      Kindly help me out as soon as possible.

      Thanks in advance.

  • avatar image
    Former Member
    Oct 27, 2015 at 05:25 AM

    Actually I am new to this POSDM concept and I am just started learning this from past 2 weeks.

    I have analysed a lot and I have some basic idea of the data flow from POS system to POSDM and then to SAP BI.

    So if you have some documents or procedures of the data flow from SAP PI to SAP POSDM kindly share with me.

    1. What are all the standard IDOC's for POSDM?

    2. How IDOC's are connected with PIPE Tlog tables?

    3. How to send data from Tlog tables to the standard data sources like 0RT_PA_TRAN_TOTAL etc.

    4. As of now I know that data will be stored in Tlog, then what is the PIPE structure shown below is related with Data Source.

    Kindly help me out as soon as possible.

    Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded