POS Analytics: Retail Control 
Technical Name: 0RT_PA_TRAN_CONTROL
Technical Data
Type of DataSource |
Transaction Data (Movement Data) |
Application Component |
0RT_PA |
Available as of OLTP Release |
BW 3.20 |
Available as of Plug-In Release |
As the source system is SAP BW, there is no release or plug-in data for an OLTP system. |
RemoteCube Compatible |
No |
Use
This DataSource provides InfoSource 0RT_PA_TRAN_CONTROL with data.
The PIPE provides the DataSource with data, based on specific receipts. The most important key figures are sales quantities and sales values.
Delta Update
The DataSource contributes to the delta update. The delta procedure used is ADDD (‘ADD’ using the delta queue (Cube-compatible)).
Fields of Origin in the Extract Structure
The fields in the extract structure are provided with data directly from the PIPE. The tables of origin in the PIPE are /posdw/tlogs and /posdw/tlogl.
Field in Extract Structure |
Description of Field in the Extract Structure |
RECORDQUALIFIER |
Record Type of Transaction |
BWTRANSINDEX |
Transaction Index for BW as Char. Field |
RETAILSTOREID |
Store |
BUSINESSDAYDATE |
Posting Date |
TRANSTYPECODE |
Transaction Type |
WORKSTATIONID |
POS Number |
TRANSNUMBER |
Transaction Number |
BEGINTIMESTAMP |
Second in Which the Transaction Begins |
ENDTIMESTAMP |
Second in Which the Transaction Ends |
DEPARTMENT |
Department |
OPERATORQUAL |
Operator Qualifier |
OPERATORID |
Number or Name of Cashier |
TRANSCURRENCY |
Transaction Currency |
PARTNERQUALIFIER |
Qualifier for Partner Number |
PARTNERID |
Partner Number |
TRANSINDEX |
Transaction Index |
NONCOMPFLAG |
Indicator for Non-Comparable Sales |
TRANSTYPEGROUP |
Transaction Type Group |
BUSINESSTYPE |
Business Transaction |
REVERSALFLAG |
Cancellation Indicator |
TRANSDEBITFLAG |
Credit/Debit Indicator |
PLANT |
Location |
STORECURRENCY |
Local Currency |
TRAININGFLAG |
Training Transaction |
KEYEDOFFLINEFLAG |
POS Transaction Without Posting to POS Server |
TRANSREASONCODE |
Reason |
RETAILNUMBER |
Sales Item Number |
RETAILTYPECODE |
Sales Item Type |
RETAILREASONCODE |
Reason |
ITEMIDQUALIFIER |
Qualifier for Article Identifier |
ITEMID |
Article Identifier |
RETAILQUANTITY |
Quantity in Sales Unit |
SALESUOM |
Sales Unit |
SALESAMOUNT |
Actual Sales Value |
NORMALSALESAMT |
Normal Sales Value |
COST |
Cost |
BATCHID |
Batch |
SERIALNUMBER |
Serial Number |
PROMOTIONID |
Promotion Number |
ENTRYMETHODCODE |
Entry Method |
MATERIALNUMBER |
Material Number |
MERCHANDISECAT |
Merchandise Category |
BASEQUANTITY |
Quantity in Base Unit of Measure |
BASEUOM |
Base Unit |
RETAILTYPEGROUP |
Sales Item Type Group |
RETAILDEBITFLAG |
Credit/Debit Indicator |
RETAILREASONGRP |
Reasons Group |
DISTDISC |
Distributed Header Discount |
DISTTAX |
Distributed Header Tax |
DISTTENDER |
Distributed Means of Payment |
DISCNUMBER |
Discount Item Number |
DISCTYPECODE |
Discount Type |
DISCREASONCODE |
Discount Reason |
REDUCTIONAMOUNT |
Discount Value |
DISCACCOUNT |
Account |
DISCID |
Discount Identification |
DISCTYPEGROUP |
Discount Type Group |
DISCREASONGROUP |
Discount Reason Group |
DISCDEBITFLAG |
Credit/Debit Indicator |
TAXNUMBER |
Tax Item Number |
TAXTYPECODE |
Tax Type |
TAXAMOUNT |
Tax Amount |
TAXINCLUDEDFLAG |
Indicator for Taxes Included In Retail Value |
TAXTYPEGROUP |
Tax Type Group |
TAXDEBITFLAG |
Credit/Debit Indicator |
COMMNUMBER |
Commission Item Number |
COMMEMPLOYEEQUAL |
Salesperson Qualifier |
COMMEMPLOYEEID |
Number or Name of Salesperson |
COMMAMOUNT |
Commission Amount |
TENDERNUMBER |
Means of Payment Item Number |
TENDERTYPECODE |
Means of Payment Type |
TENDERAMOUNT |
Tender Value |
TENDERCURRENCY |
Means of Payment Currency |
TENDERID |
Means of Payment Indicator |
ACCOUNTNUMBER |
Cash Account |
REFERENCEID |
Reference Number |
TENDERTYPEGROUP |
Payment Means Group |
TENDERDEBITFLAG |
Credit/Debit Indicator |
PAYMENTCARD |
Credit Card Identification |
CARDNUMBER |
Card Number |
CARDNUMBERSUFFIX |
Suffix |
EXPIRATIONDATE |
Expiration Date |
CARDHOLDERNAME |
Cardholder |
ADJUDICATIONCODE |
Authorization Number |
AUTHTERMID |
Terminal |
AUTHDATETIME |
Authorization Time |
AUTHMETHODCODE |
Authorization Method |
MEDIAISSUERID |
Card Issuer |
REACTIONCODE |
Reaction Code for Authorization |
LIMITAMOUNT |
Indicator for Restricted Amount |
CARDSWIPEDKEYED |
Input Method |
HOSTAUTHORIZED |
Indicator for Completed Settlement |
AUTHCODE |
Reference Number of Clearing House |
PROVIDERID |
Transaction Point of Receipt |
FORCEONLINE |
Indicator for Authorization to be Transferred |
ACCOUNTHOLDER |
Name of Account Holder |
BANKCODE |
Bank Number |
BANKACCOUNT |
Account Number |
Features of the Extractor
The extraction method is F1 and is therefore based on a function module (complete interface). The function module used for the extractor here is /POSDW/BW_UPDATE_ISOURCE.