Enhancements to POS Data Transfer and Audit

With these enhancements, the POS inbound interfaces and Transaction Log (TLOG) data model have been enhanced to include a number of new, optional, fields. The new fields can simplify the transfer of common transaction data artifacts from POS systems to SAP Customer Activity Repository.

Technical Details

Product feature is	New
Country Dependency	Valid for all countries
Software Component Version	RTLPOSDM 300
Application Component	CA-RT-CAR-PIP
Availability	SAP Customer Activity Repository 2.0

Existing Data

For POS transactions that have been previously received by SAP Customer Activity Repository 1.0, and which are already stored in your /POSDW/TLOGF table, the newly added fields will remain empty and do not need to be populated if not necessary to support your business scenario.

Similarly, for POS transaction data migrated to SAP Customer Activity Repository 2.0 from an existing SAP POS DM installation, the newly added fields will remain empty and do not need to be populated if not necessary to support your business scenario.

Data Transfer

For any POS transactions received by the repository after the installation or upgrade to SAP Customer Activity Repository 2.0, the newly added fields will be populated, provided that the data to populate these fields is transferred by the connected POS system.

To accommodate the addition of these fields, the following key structures, interfaces, and web services have been modified:

Interfaces

/POSDW/BAPI_POSTR_CREATE
IDoc structures have been updated to include new fields
Enterprise service Create Point Of Sale Transaction as Bulk (PointOfSaleTransactionERPBulkCreateRequest_In). Please note that if you are using standard SAP NetWeaver Process Integration (SAP NetWeaver PI) Content for SAP Customer Activity Repository, you must upgrade to software component version XI CONTENT RTLPOSDM 300, which contains the PI Content required to receive the data into the added fields.

Structures

New fields have been added to:

/POSDW/TRANSACTION_INT structure
/POSDW/TLOGF table

Furthermore, archiving object /POSDW/TLF has been adjusted to enable the archiving of the added fields.

Segment	/POSDW/BAPI_POSTR_CREATE and IDoc Structure Field Name	/POSDW/TLOGF Field Name	Description
TRANSACTION	ACTIVITYTIME	ACTIVITYTIME	Activity Time
	REGISTERTIME	REGISTERTIME	Register Time
	TENDERTIME	TENDERTIME	Tender Time
	PAUSETIME	PAUSETIME	Pause Time
	TRAININGTIME	TRAININGTIME	Training Time
	CUSTOMERIDPOS	CUSTOMERIDPOS	Customer ID sent from POS
	CUSTOMERAGE	CUSTOMERAGE	Customer Age
	CUSTOMERENTRYMETHOD	CUSTOMERENTRYMETHOD	Customer Identifier Entry Method
	TILLID	TILLID	Drawer ID used at POS Client
	ORIGSTOREID	ORIGSTOREID	Reference to Original Receipt for Retail Store ID
	ORIGBUSINESSDATE	ORIGBUSINESSDATE	Reference to Original Receipt for Posting Date
	ORIGWORKSTATIONID	ORIGWRKSTID	Reference to Original receipt for Workstation ID
	ORIGTRANSNUMBER	ORIGTRANSNUMBER	Reference to Original Receipt for Transaction Number
	ORIGBEGINTIMESTAMP	ORIGBEGINTIMESTAMP	Reference to Original Receipt for Start Timestamp
	ORIGREASONCODE	ORIGREASONCODE	Reason
	ORIGLINEITEMNUMBER	ORIGLINEITEMNUMBER	Reference to Original Receipt for Line Item Number
RETAILLINEITEM	NONEXISTENTARTICLEID	NONEXISTENTARTICLEID	Nonexistent Article Identifier
	NONEXISTENTEAN	NONEXISTENTEAN	Nonexistent EAN/GTIN
	ENTEREDEAN	ENTEREDEAN	Entered international article identifier (EAN/GTIN)
	ORIGSTOREID	ORIGSTOREID	Reference to Original Receipt for Retail Store ID
	ORIGBUSINESSDATE	ORIGBUSINESSDATE	Reference to Original Receipt for Posting Date
	ORIGWORKSTATIONID	ORIGWRKSTID	Reference to Original receipt for Workstation ID
	ORIGTRANSNUMBER	ORIGTRANSNUMBER	Reference to Original Receipt for Transaction Number
	ORIGBEGINTIMESTAMP	ORIGBEGINTIMESTAMP	Reference to Original Receipt for Start Timestamp
	ORIGREASONCODE	ORIGREASONCODE	Reason
	ORIGLINEITEMNUMBER	ORIGLINEITEMNUMBER	Reference to Original Receipt for Line Item Number
COUPON (New)	COUPONIDQUALIFIER	COUPONIDQUALIFIER	Qualifier for Coupon Identifier
	COUPONID	COUPONID	Coupon Identifier
	COUPONQUANTITY	COUPONQUANTITY	Number of coupons
	COUPONAMOUNT	COUPONAMOUNT	Coupon Amount
COUPONREFITEM (New)	COUPONREFITEMNUMBER	COUPONREFITEMNUMBER	Coupon Reference Item Number
	COUPONREFITEMREBATEAMT	COUPONREFITEMREBATEAMT	Coupon Reference Item Rebate Amount in Transaction Currency
	COUPONREFITEMQUANTITY	COUPONREFITEMQUANTITY	Coupon Reference Item Quantity in Sales Unit
LINEITEMLOYALTY	REBATEMETHOD	REBATEMETHOD	Rebate method for calculation of loyalty promotion
	PROMOTIONID	INTERNALPROMOTIONID	Promotion Number
	EXTERNALPROMOTIONID	EXTERNALPROMOTIONID	External Promotion Identifier
TRANSACTIONLOYALTY	REBATEMETHOD	REBATEMETHOD	Rebate method for calculation of loyalty promotion
	PROMOTIONID	INTERNALPROMOTIONID	Promotion Number
	EXTERNALPROMOTIONID	EXTERNALPROMOTIONID	External Promotion Identifier
POSTVOIDDETAILS	VOIDEDBEGINTIMESTAMP	VOIDEDBEGINTIMESTAMP	Referenced Transaction Start

The following database fields that already exist in the Retail Line Item segment of the /POSDW/TLOGF table are also used for the Coupon Reference Item Number segment as follows:

/POSDW/BAPI_POSTR_CREATE and IDoc Structure Field Name	Description
ITEMIDQUALIFIER	Qualifier for Article Identifier
ITEMID	Article Identifier

The values are determined during PIPE inbound processing using the Coupon Reference Item Number field and then stored in the /POSDW/TLOGF table. Otherwise, the values are not present in the inbound interfaces or in the POS workbench.

Structures

The PointOfSaleTransactionERPBulkCreateRequest_In web service has been enhanced with the following new and updated data types:

Data Type	New / Updated	Field Name	Data Type Name
PtOfSlTransacERPCrteReqProcgTmes	New	ActivityTimeQuantity	LARGE_Quantity
		RegisterTimeQuantity	LARGE_Quantity
		TenderTimeQuantity	LARGE_Quantity
		PauseTimeQuantity	LARGE_Quantity
		TrainingTimeQuantity	LARGE_Quantity
PtOfSlTransacERPCrteReqCust	New	PartyInternalID	NOSC_PartyInternalID
		AgeMeasure	UNITYEAR_SMALLNONNEGATIVEINTEGER_Measure
		PartyOriginTypeCode	NOSC_PartyOriginTypeCode
PtOfSlTransacERPCrteReqRtlTransacItmCom	Updated	NonExistentProductInternalID	NOSC_ProductInternalID
		NonExistentProductStandardID	NOSC_ProductStandardID
		EnteredProductStandardID	NOSC_ProductStandardID
PtOfSlTransacERPCrteReqRtlTransacItmComTransacLnk	Updated	PointOfSaleTransactionLinkReasonTypeCode	NOSC_PointOfSaleTransactionLinkReasonTypeCode
PtOfSlTransacERPCrteReqRtlTransacItmComLoyltyProgMbrshpLoyltyRwrdPromo	New	RebateMethodCode	NOSC_LoyaltyRewardPromotionRebateMethodCode
		PromotionID	NOSC_PromotionID
		PromotionInternalID	NOSC_PromotionID
PtOfSlTransacERPCrteReqRtlTransacLoyltyProgMbrshpTotLoyltyRwrdPromo	New	RebateMethodCode	NOSC_LoyaltyRewardPromotionRebateMethodCode
		PromotionID	NOSC_PromotionID
		PromotionInternalID	NOSC_PromotionID
PtOfSlTransacERPCrteReqRtlTransacTransacLnk	Updated	PointOfSaleTransactionLinkReasonTypeCode	NOSC_PointOfSaleTransactionLinkReasonTypeCode
PtOfSlTransacERPCrteReqRtlTransacTndrCpn	New	CouponStandardID	NOSC_CouponStandardID
		CouponInternalID	NOSC_CouponInternalID
		Amount	Amount
		Quantity	Quantity
		ItemLink	PtOfSlTransacERPCrteReqRtlTransacTndrCpnItmLnk
PtOfSlTransacERPCrteReqRtlTransacTndrCpnItmLnk	New	PointOfSaleTransactionItemID	PointOfSaleTransactionItemID
		Amount	Amount
		Quantity	Quantity
PtOfSlTransacERPCrteReqPtOfSlTransac	Updated
PtOfSlTransacERPCrteReqRtlTransacItmComLoyltyProgMbrshpLoyltyRwrd	Updated
PtOfSlTransacERPCrteReqRtlTransacLoyltyProgMbrshpTotLoyltyRwrd	Updated
PtOfSlTransacERPCrteReqRtlTransacTndr	Updated