POS Analytics: Goods Movement

Technical Name: 0RT_PA_TRAN_GDS_MOV

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_GDS_MOV with data.

The PIPE (POS Inbound Processing Engine) supplies the DataSource with goods movement data (POS Analytics: Goods Movements).

Delta Update

The DataSource contributes to the delta update. The delta procedure used is ADDD.

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	Cashier 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
PLANTCUSTOMER	Customer Number of Plant
BUSINESSLOCATION	Location Key (IS-OIL/MRN)
TURNOVER	Sales Total per Transaction
GMNUMBER	Goods Movement Item Number
GMTYPECODE	Goods Movement Category
GMREASONCODE	Goods Movement Reason
ITEMIDQUALIFIER	Qualifier for Article Identifier
ITEMID	Article Identifier
UNITCOUNT	Goods Movement Quantity in Sales Unit
SALESUOM	Sales Unit
SALESAMOUNT	Actual Retail Value
EXTVALUATIONAMT	External Valuation Price
BATCHID	Batch
SERIALNUMBER	Serial Number
ACCOUNT	Account Number
COSTCENTER	Cost Center
TOPARTYID	Receiving Site
LOCATIONID	Storage Location
SUPPLIERID	Vendor Number
REFDOCQUALIFIER	Qualifier for Reference Document
REFDOCID	Reference Document
REFDOCNUMBER	Item Number in Reference Document
UNITSSHIPPEDCNT	Delivery Quantity in Sales Unit
DELIVERYCOMPLETE	Delivery Completed Indicator
SPECIALSTOCKCODE	Special Stock Indicator
EXPIRATIONDATE	Shelf-Life Expiration Date
MATERIALNUMBER	Material Number
MERCHANDISECAT	Merchandise Category
BASEQUANTITY	Quantity in Base Unit of Measure
BASEUOM	Base Unit of Measure
GMTYPEGROUP	Goods Movement Type Group
GMREASONGROUP	Group for Reason for Goods Movement
GMDEBITFLAG	Credit/Debit Indicator

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_SOURCES.