SAP ABAP Table /POSDW/BWR_GOODSMOVEMENT (Structure for Remote Cube for BW_GOODSMOVEMENT)
Hierarchy
☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR-PIP (Application Component) Point of Sales Inbound Processing Engine
     ⤷ /POSDW/BW (Package) POS DW BW
Basic Data
Table Category INTTAB    Structure 
Structure /POSDW/BWR_GOODSMOVEMENT   Table Relationship Diagram
Short Description Structure for Remote Cube for BW_GOODSMOVEMENT    
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   Transfer to BW for Goods Movement Transactions  
2 .INCLUDE       0   0   Transaction Header for BW  
3 RECORDQUALIFIER /POSDW/RECORDQUALIFIER /POSDW/RECORDQUALIFIER CHAR 4   0   Record Type of Transaction  
4 BWTRANSINDEX /POSDW/BWTRANSINDEX /POSDW/CHAR10ALPHA CHAR 10   0   Transaction Index for BW as Character Field  
5 .INCLUDE       0   0   Transaction  
6 .INCLUDE       0   0   Transaction - Database Fields  
7 .INCLUDE       0   0   Transaction - Database Fields (Key Fields)  
8 RETAILSTOREID /POSDW/RETAILSTOREID /POSDW/RETAILSTOREID CHAR 10   0   Store  
9 BUSINESSDAYDATE /POSDW/BUSINESSDAYDATE /POSDW/DATE DATS 8   0   Posting Date  
10 TRANSTYPECODE /POSDW/TRANSACTIONTYPECODE /POSDW/TRANSACTIONTYPECODE CHAR 4   0   Transaction Type /POSDW/TRANTY
11 WORKSTATIONID /POSDW/WORKSTATIONID /POSDW/WORKSTATIONID CHAR 10   0   POS Number  
12 TRANSNUMBER /POSDW/TRANSACTIONSEQUENCENUMB /POSDW/TRANSACTIONSEQUENCENUMB CHAR 20   0   Transaction Number  
13 BEGINTIMESTAMP /POSDW/BEGINDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Starts  
14 ENDTIMESTAMP /POSDW/ENDDATETIMESTAMP /POSDW/TIMESTAMP CHAR 14   0   Second in Which Transaction Ends  
15 DEPARTMENT /POSDW/DEPARTMENT /POSDW/CHAR10ALPHA CHAR 10   0   Department  
16 OPERATORQUAL /POSDW/OPERATORQUALIFIER /POSDW/OPERATORQUALIFIER CHAR 1   0   Operator Qualifier  
17 OPERATORID /POSDW/OPERATORID /POSDW/CHAR30ALPHA CHAR 30   0   Cashier Number or Name  
18 TRANSCURRENCY /POSDW/TRANSACTIONCURRENCY WAERS CUKY 5   0   Transaction Currency *
19 PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER /POSDW/PARTNERQUALIFIER CHAR 1   0   Qualifier for Partner Number  
20 PARTNERID /POSDW/PARTNERID /POSDW/CHAR13ALPHA CHAR 13   0   Partner Number  
21 .INCLUDE       0   0   Transaction - Enhanced Fields  
22 TRANSINDEX /POSDW/TRANSINDEX /POSDW/TRANSINDEX INT4 10   0   Transaction Index  
23 NONCOMPFLAG /POSDW/NONCOMPFLAG /POSDW/FLAG CHAR 1   0   Indicator for Non-Comparable Sales  
24 TRANSTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP /POSDW/TRANSACTIONTYPEGROUP CHAR 4   0   Transaction Type Group /POSDW/TRANTG
25 BUSINESSTYPE /POSDW/BUSINESSTYPE /POSDW/BUSINESSTYPE CHAR 1   0   Business Transaction  
26 REVERSALFLAG /POSDW/REVERSALFLAG /POSDW/FLAG CHAR 1   0   Reversal Indicator  
27 TRANSDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
28 PLANT /POSDW/PLANT CHAR4 CHAR 4   0   Plant  
29 STORECURRENCY /POSDW/STORECURRENCY WAERS CUKY 5   0   Local Currency *
30 PLANTCUSTOMER /POSDW/PLANTCUSTOMER /POSDW/CHAR10ALPHA CHAR 10   0   Customer Number of Plant  
31 BUSINESSLOCATION /POSDW/BUSINESSLOCATION /POSDW/CHAR10ALPHA CHAR 10   0   Business Location Identifier (IS-OIL/MRN)  
32 TURNOVER /POSDW/TRANSTURNOVER /POSDW/CURRENCY CURR 15   2   Sales Totals Per Transaction  
33 INDEXCURRENCY /POSDW/INDEXCURRENCY WAERS CUKY 5   0   Currency for Sales Totals *
34 VERSION /POSDW/TRANSACTION_VERSION /POSDW/TRANSACTION_VERSION INT1 3   0   Version of POS Transaction  
35 .INCLUDE       0   0   Goods Movements  
36 .INCLUDE       0   0   Goods Movements - Database Fields  
37 .INCLUDE       0   0   Goods Movements - Database Fields (Key Fields)  
38 GMNUMBER /POSDW/GOODSMOVEMENTSEQUENCENU /POSDW/SEQUENCENUMBER CHAR 10   0   Goods Movement Item Number  
39 GMTYPECODE /POSDW/GOODSMOVEMENTTYPECODE /POSDW/GOODSMOVEMENTTYPECODE CHAR 4   0   Goods Movement Type *
40 GMREASONCODE /POSDW/GOODSMOVEMENTREASONCODE /POSDW/REASONCODE CHAR 4   0   Goods Movement Reason *
41 ITEMIDQUALIFIER /POSDW/ITEMIDQUALIFIER /POSDW/ITEMIDQUALIFIER CHAR 1   0   Qualifier for Article Identifier  
42 ITEMID /POSDW/ITEMID /POSDW/ITEMID CHAR 18   0   Article Identifier  
43 UNITCOUNT /POSDW/UNITCOUNT /POSDW/QUANTITY QUAN 13   3   Goods Movement Quantity in Sales Unit of Measure  
44 SALESUOM /POSDW/SALESUNITOFMEASURE MEINS UNIT 3   0   Sales Unit *
45 SALESAMOUNT /POSDW/SALESAMOUNT /POSDW/CURRENCY CURR 15   2   Actual Retail Value  
46 EXTVALUATIONAMT /POSDW/EXTERNALVALUATIONAMOUNT /POSDW/CURRENCY CURR 15   2   External Valuation Price  
47 BATCHID /POSDW/BATCHID /POSDW/CHAR10ALPHA CHAR 10   0   Batch  
48 SERIALNUMBER /POSDW/SERIALNUMBER /POSDW/CHAR25ALPHA CHAR 25   0   Serial Number  
49 ACCOUNT /POSDW/ACCOUNT /POSDW/ACCOUNT CHAR 10   0   Account Number  
50 COSTCENTER /POSDW/COSTCENTER /POSDW/ACCOUNT CHAR 10   0   Cost Center  
51 TOPARTYID /POSDW/TOPARTYID /POSDW/CHAR10ALPHA CHAR 10   0   Receiving Site  
52 LOCATIONID /POSDW/LOCATIONID /POSDW/CHAR04ALPHA CHAR 4   0   Storage Location  
53 SUPPLIERID /POSDW/SUPPLIERID LIFNR CHAR 10   0   Vendor Number *
54 REFDOCQUALIFIER /POSDW/REFERENCEDOCUMENTQUALIF   CHAR 1   0   Qualifier for Reference Document  
55 REFDOCID /POSDW/REFERENCEDOCUMENTID CHAR25 CHAR 25   0   Reference document  
56 REFDOCNUMBER /POSDW/REFERENCEDOCUMENTSEQUEN /POSDW/SEQUENCENUMBER CHAR 10   0   Item Number in Reference Document  
57 UNITSSHIPPEDCNT /POSDW/UNITSSHIPPEDCOUNT /POSDW/QUANTITY QUAN 13   3   Delivery Quantity in Sales Unit  
58 DELIVERYCOMPLETE /POSDW/DELIVERYCOMPLETEFLAG /POSDW/FLAG CHAR 1   0   Delivery Completed Indicator  
59 SPECIALSTOCKCODE /POSDW/SPECIALSTOCKCODE   CHAR 1   0   Special Stock Indicator  
60 EXPIRATIONDATE /POSDW/EXPIRATIONDATE /POSDW/DATE DATS 8   0   Shelf Life Expiration Date  
61 TOFROMLOCATIONID /POSDW/TOFROMLOCATIONID /POSDW/CHAR04ALPHA CHAR 4   0   Receiving/Issuing Storage Location  
62 .INCLUDE       0   0   Goods Movements - Enhanced Fields  
63 MATERIALNUMBER /POSDW/MATERIALNUMBER MATNR CHAR 18   0   Material Number  
64 MERCHANDISECAT /POSDW/MERCHANDISECATEGORY MATKL CHAR 9   0   Material Group *
65 BASEQUANTITY /POSDW/BASEQUANTITY /POSDW/QUANTITY QUAN 13   3   Quantity in Base Unit of Measure  
66 BASEUOM /POSDW/BASEUNITOFMEASURE MEINS UNIT 3   0   Base Unit of Measure *
67 GMTYPEGROUP /POSDW/GOODSMOVEMENTTYPEGROUP /POSDW/GOODSMOVEMENTTYPEGROUP CHAR 4   0   Goods Movement Type Group /POSDW/GMTG
68 GMREASONGROUP /POSDW/GOODSMOVEMENTREASONGRP /POSDW/REASONGROUP CHAR 4   0   Group for Reason for Goods Movement *
69 GMDEBITFLAG /POSDW/DEBITFLAG /POSDW/DEBITFLAG CHAR 1   0   Debit/Credit Indicator  
70 .INCLUDE       0   0   Additional Fields for Remote Accesses of BW  
71 TASKSTATUS_BW /POSDW/TASKSTATUS_BW /POSDW/TASKSTATUS CHAR 1   0   Task Status of BW Task  
72 TASKSTATUS_1 /POSDW/TASKSTATUS /POSDW/TASKSTATUS CHAR 1   0   Task Status  
73 TASKSTATUS_2 /POSDW/TASKSTATUS /POSDW/TASKSTATUS CHAR 1   0   Task Status  
74 TASKSTATUS_3 /POSDW/TASKSTATUS /POSDW/TASKSTATUS CHAR 1   0   Task Status  
75 TASKSTATUS_4 /POSDW/TASKSTATUS /POSDW/TASKSTATUS CHAR 1   0   Task Status  
76 TASKSTATUS_5 /POSDW/TASKSTATUS /POSDW/TASKSTATUS CHAR 1   0   Task Status  
77 TRANSSTATUS /POSDW/TR_STATUS /POSDW/TR_STATUS CHAR 1   0   Transaction Status  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 /POSDW/BWR_GOODSMOVEMENT GMTYPEGROUP /POSDW/GMTG GMTYPEGROUP KEY 1 CN
2 /POSDW/BWR_GOODSMOVEMENT TRANSTYPECODE /POSDW/TRANTY TRANSTYPECODE KEY 1 CN
3 /POSDW/BWR_GOODSMOVEMENT TRANSTYPEGROUP /POSDW/TRANTG TRANSTYPEGROUP 1 CN
History
Last changed by/on SAP  20100820 
SAP Release Created in 353