SAP for Retail Discussions
Join conversations about personalization, omnichannel strategies, and operational excellence in retail using SAP for Retail software.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

6 REPLIES 6

vikrant_mohite
Active Contributor
0 Kudos

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.

0 Kudos

Hi

The different Cubes used are 0RPA* series. Out of this 0RPA_BONI is used for receipt analysis. Reports are taken at transaction level to find the spend analytics , Customer Classification , Receipt Analytics etc.

If they can use the transaction Index in the cube . Why cant Transaction Number is my doubt?

Regards

0 Kudos

Hi,

You may get duplicate transaction if you use transaction number but that won't happen with transaction index if you want to analyse it at transaction level. I don't know about the reports you mentioned. But I think this would be the reason for it.

Eg.

DateStorePOS IDTransaction NoTransaction IndexSales Totals
02.05.2014M001112341100
02.05.2014M001212342200

Thanks,

Vikrant.

0 Kudos

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.

ramesh_duraisamy
Active Participant
0 Kudos

Hi Aram,

Thanks for the inputs, worthy to add the points.

Thanks and Regards,

Ramesh D

ramesh_duraisamy
Active Participant
0 Kudos

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