Skip to Content

Why Actual Transaction number is not updated in PoSDM targets but instead Transaction Index

Hi

Why Actual Transaction number is not updated in PoSDM targets but instead Transaction Index is updated in all the targets. Transaction number is not even available as an info object in any of the PoSDM targets.

Regards

Reshoi R

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Sep 24, 2014 at 02:27 PM

    Hi Reshoi R,

    Transaction Number is available in 0RT_PA_TRAN_CONTROL and it is available till PSA of BI structure.

    0RPA_TNR is standard Transaction Number Info object, It will be not part of Standard cube like

    0RPA_C01(Store/Article/Day),0RPA_C03(Store/Article/Week) and it will be in 0RPA_C06 (Transaction Count).

    There is no standard transformation mapping between them because if there is huge transaction flow to avoid the performance aspects in BI POS Analytics cube.

    To Overcome above you can opt for LSA architecture with customized cubes.

    Thanks and Regards,

    Ramesh D

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2014 at 06:10 PM

    Hi,

    Data source 0RT_PA_TRAN_CONTROL contains a field TRANSNUMBER which holds transaction number.

    Please check you mapping from this field to your target.

    Cube 0RPM_VP07 is just used to count the no of transactions in all the reports so transaction number is not required and hence transaction index is used everywhere.

    Usually reports are never taken at transaction number level in BW/POSDM.

    Thanks,

    Vikrant.

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Reshoi,

      Transaction index is an internally generated number within POSDM which is an equivalent of transaction number.

      For example,

      On a particular day lets say there are 100 transactions occurred in one store out of which 50 are sales movements,30 are control tranactions and another 20 are financial transactions.

      Transaction index numbers will be from 1 to 100.

      for the first 20 sales transactions in sequence , Trn.index will be from 1 to 20 and then 21st transaction can be a financial transaction in which case the transaction index will be 21.and 22nd transaction can be a control transaction and the tr.index will be 22.

      Sales movements - Transaction numbers 510 to 530 and Trn.index will be 1 to 20

      Control transactions - Transaction numbers 531 trn.index will be 21

      FI transaction - Trn no 532 . trn.index will be 22

      Sales movements - transaction numbers 533 to 545 - trn.index will be 23 to 35

      and goes on based on which transaction occurs at what time interval...Tr.index will be more based on FIFO depending on the time it occurred.

      Also you may consider using Multiprovider 0RPA_MBON.

      Please see the link below for more details

      POS Receipt Index - Trade Foundation - SAP Library

      Hope it helps.

  • Posted on Aug 19, 2014 at 01:50 PM

    Hi Aram,

    Thanks for the inputs, worthy to add the points.

    Thanks and Regards,

    Ramesh D

    Add a comment
    10|10000 characters needed characters exceeded

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.