SAP ABAP Table /POSDW/BW_GOODSMOVEMENT (Transfer to BW for Goods Movement Transactions)

Hierarchy

☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     ⤷ /POSDW/OUTPUT_CONVERSION (Package) PIPE Tasks and Output Conversion

Basic Data

Table Category	INTTAB	Structure
Structure	/POSDW/BW_GOODSMOVEMENT	Table Relationship Diagram
Short Description	Transfer to BW for Goods Movement Transactions

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Transaction Header for BW
2	RECORDQUALIFIER	☐	/POSDW/RECORDQUALIFIER	/POSDW/RECORDQUALIFIER	CHAR	4	0	Record Type of Transaction
3	BWTRANSINDEX	☐	/POSDW/BWTRANSINDEX	/POSDW/CHAR10ALPHA	CHAR	10	0	Transaction Index for BW as Character Field
4	.INCLUDE	☐				0	0	Transaction
5	.INCLUDE	☐				0	0	Transaction - Database Fields
6	.INCLUDE	☐				0	0	Transaction - Database Fields (Key Fields)
7	RETAILSTOREID	☐	/POSDW/RETAILSTOREID	/POSDW/RETAILSTOREID	CHAR	10	0	Store
8	BUSINESSDAYDATE	☐	/POSDW/BUSINESSDAYDATE	/POSDW/DATE	DATS	8	0	Posting Date
9	TRANSTYPECODE	☐	/POSDW/TRANSACTIONTYPECODE	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	Transaction Type	/POSDW/TRANTY
10	WORKSTATIONID	☐	/POSDW/WORKSTATIONID	/POSDW/WORKSTATIONID	CHAR	10	0	POS Number
11	TRANSNUMBER	☐	/POSDW/TRANSACTIONSEQUENCENUMB	/POSDW/TRANSACTIONSEQUENCENUMB	CHAR	20	0	Transaction Number
12	BEGINTIMESTAMP	☐	/POSDW/BEGINDATETIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Second in Which Transaction Starts
13	ENDTIMESTAMP	☐	/POSDW/ENDDATETIMESTAMP	/POSDW/TIMESTAMP	CHAR	14	0	Second in Which Transaction Ends
14	DEPARTMENT	☐	/POSDW/DEPARTMENT	/POSDW/CHAR10ALPHA	CHAR	10	0	Department
15	OPERATORQUAL	☐	/POSDW/OPERATORQUALIFIER	/POSDW/OPERATORQUALIFIER	CHAR	1	0	Operator Qualifier
16	OPERATORID	☐	/POSDW/OPERATORID	/POSDW/CHAR30ALPHA	CHAR	30	0	Cashier Number or Name
17	TRANSCURRENCY	☐	/POSDW/TRANSACTIONCURRENCY	WAERS	CUKY	5	0	Transaction Currency	*
18	PARTNERQUALIFIER	☐	/POSDW/PARTNERQUALIFIER	/POSDW/PARTNERQUALIFIER	CHAR	1	0	Qualifier for Partner Number
19	PARTNERID	☐	/POSDW/PARTNERID	/POSDW/CHAR13ALPHA	CHAR	13	0	Partner Number
20	.INCLUDE	☐				0	0	Transaction - Enhanced Fields
21	TRANSINDEX	☐	/POSDW/TRANSINDEX	/POSDW/TRANSINDEX	INT4	10	0	Transaction Index
22	NONCOMPFLAG	☐	/POSDW/NONCOMPFLAG	/POSDW/FLAG	CHAR	1	0	Indicator for Non-Comparable Sales
23	TRANSTYPEGROUP	☐	/POSDW/TRANSACTIONTYPEGROUP	/POSDW/TRANSACTIONTYPEGROUP	CHAR	4	0	Transaction Type Group	/POSDW/TRANTG
24	BUSINESSTYPE	☐	/POSDW/BUSINESSTYPE	/POSDW/BUSINESSTYPE	CHAR	1	0	Business Transaction
25	REVERSALFLAG	☐	/POSDW/REVERSALFLAG	/POSDW/FLAG	CHAR	1	0	Reversal Indicator
26	TRANSDEBITFLAG	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator
27	PLANT	☐	/POSDW/PLANT	CHAR4	CHAR	4	0	Plant
28	STORECURRENCY	☐	/POSDW/STORECURRENCY	WAERS	CUKY	5	0	Local Currency	*
29	PLANTCUSTOMER	☐	/POSDW/PLANTCUSTOMER	/POSDW/CHAR10ALPHA	CHAR	10	0	Customer Number of Plant
30	BUSINESSLOCATION	☐	/POSDW/BUSINESSLOCATION	/POSDW/CHAR10ALPHA	CHAR	10	0	Business Location Identifier (IS-OIL/MRN)
31	TURNOVER	☐	/POSDW/TRANSTURNOVER	/POSDW/CURRENCY	CURR	15	2	Sales Totals Per Transaction
32	INDEXCURRENCY	☐	/POSDW/INDEXCURRENCY	WAERS	CUKY	5	0	Currency for Sales Totals	*
33	VERSION	☐	/POSDW/TRANSACTION_VERSION	/POSDW/TRANSACTION_VERSION	INT1	3	0	Version of POS Transaction
34	.INCLUDE	☐				0	0	Goods Movements
35	.INCLUDE	☐				0	0	Goods Movements - Database Fields
36	.INCLUDE	☐				0	0	Goods Movements - Database Fields (Key Fields)
37	GMNUMBER	☐	/POSDW/GOODSMOVEMENTSEQUENCENU	/POSDW/SEQUENCENUMBER	CHAR	10	0	Goods Movement Item Number
38	GMTYPECODE	☐	/POSDW/GOODSMOVEMENTTYPECODE	/POSDW/GOODSMOVEMENTTYPECODE	CHAR	4	0	Goods Movement Type	*
39	GMREASONCODE	☐	/POSDW/GOODSMOVEMENTREASONCODE	/POSDW/REASONCODE	CHAR	4	0	Goods Movement Reason	*
40	ITEMIDQUALIFIER	☐	/POSDW/ITEMIDQUALIFIER	/POSDW/ITEMIDQUALIFIER	CHAR	1	0	Qualifier for Article Identifier
41	ITEMID	☐	/POSDW/ITEMID	/POSDW/ITEMID	CHAR	18	0	Article Identifier
42	UNITCOUNT	☐	/POSDW/UNITCOUNT	/POSDW/QUANTITY	QUAN	13	3	Goods Movement Quantity in Sales Unit of Measure
43	SALESUOM	☐	/POSDW/SALESUNITOFMEASURE	MEINS	UNIT	3	0	Sales Unit	*
44	SALESAMOUNT	☐	/POSDW/SALESAMOUNT	/POSDW/CURRENCY	CURR	15	2	Actual Retail Value
45	EXTVALUATIONAMT	☐	/POSDW/EXTERNALVALUATIONAMOUNT	/POSDW/CURRENCY	CURR	15	2	External Valuation Price
46	BATCHID	☐	/POSDW/BATCHID	/POSDW/CHAR10ALPHA	CHAR	10	0	Batch
47	SERIALNUMBER	☐	/POSDW/SERIALNUMBER	/POSDW/CHAR25ALPHA	CHAR	25	0	Serial Number
48	ACCOUNT	☐	/POSDW/ACCOUNT	/POSDW/ACCOUNT	CHAR	10	0	Account Number
49	COSTCENTER	☐	/POSDW/COSTCENTER	/POSDW/ACCOUNT	CHAR	10	0	Cost Center
50	TOPARTYID	☐	/POSDW/TOPARTYID	/POSDW/CHAR10ALPHA	CHAR	10	0	Receiving Site
51	LOCATIONID	☐	/POSDW/LOCATIONID	/POSDW/CHAR04ALPHA	CHAR	4	0	Storage Location
52	SUPPLIERID	☐	/POSDW/SUPPLIERID	LIFNR	CHAR	10	0	Vendor Number	*
53	REFDOCQUALIFIER	☐	/POSDW/REFERENCEDOCUMENTQUALIF		CHAR	1	0	Qualifier for Reference Document
54	REFDOCID	☐	/POSDW/REFERENCEDOCUMENTID	CHAR25	CHAR	25	0	Reference document
55	REFDOCNUMBER	☐	/POSDW/REFERENCEDOCUMENTSEQUEN	/POSDW/SEQUENCENUMBER	CHAR	10	0	Item Number in Reference Document
56	UNITSSHIPPEDCNT	☐	/POSDW/UNITSSHIPPEDCOUNT	/POSDW/QUANTITY	QUAN	13	3	Delivery Quantity in Sales Unit
57	DELIVERYCOMPLETE	☐	/POSDW/DELIVERYCOMPLETEFLAG	/POSDW/FLAG	CHAR	1	0	Delivery Completed Indicator
58	SPECIALSTOCKCODE	☐	/POSDW/SPECIALSTOCKCODE		CHAR	1	0	Special Stock Indicator
59	EXPIRATIONDATE	☐	/POSDW/EXPIRATIONDATE	/POSDW/DATE	DATS	8	0	Shelf Life Expiration Date
60	TOFROMLOCATIONID	☐	/POSDW/TOFROMLOCATIONID	/POSDW/CHAR04ALPHA	CHAR	4	0	Receiving/Issuing Storage Location
61	.INCLUDE	☐				0	0	Goods Movements - Enhanced Fields
62	MATERIALNUMBER	☐	/POSDW/MATERIALNUMBER	MATNR	CHAR	18	0	Material Number
63	MERCHANDISECAT	☐	/POSDW/MERCHANDISECATEGORY	MATKL	CHAR	9	0	Material Group	*
64	BASEQUANTITY	☐	/POSDW/BASEQUANTITY	/POSDW/QUANTITY	QUAN	13	3	Quantity in Base Unit of Measure
65	BASEUOM	☐	/POSDW/BASEUNITOFMEASURE	MEINS	UNIT	3	0	Base Unit of Measure	*
66	GMTYPEGROUP	☐	/POSDW/GOODSMOVEMENTTYPEGROUP	/POSDW/GOODSMOVEMENTTYPEGROUP	CHAR	4	0	Goods Movement Type Group	/POSDW/GMTG
67	GMREASONGROUP	☐	/POSDW/GOODSMOVEMENTREASONGRP	/POSDW/REASONGROUP	CHAR	4	0	Group for Reason for Goods Movement	*
68	GMDEBITFLAG	☐	/POSDW/DEBITFLAG	/POSDW/DEBITFLAG	CHAR	1	0	Debit/Credit Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/BW_GOODSMOVEMENT	GMTYPEGROUP	/POSDW/GMTG	GMTYPEGROUP	KEY	1	CN
2	/POSDW/BW_GOODSMOVEMENT	TRANSTYPECODE	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
3	/POSDW/BW_GOODSMOVEMENT	TRANSTYPEGROUP	/POSDW/TRANTG	TRANSTYPEGROUP		1	CN

History

Last changed by/on	SAP	20100820
SAP Release Created in	30B