SAP ABAP Table /POSDW/BW_FINANCIALMOVEMENT (Transfer to BW for Financial 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_FINANCIALMOVEMENT	Table Relationship Diagram
Short Description	Transfer to BW for Financial 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	Financial Transaction
35	.INCLUDE	☐				0	0	Financial Transaction - Database Fields
36	FINUMBER	☐	/POSDW/FINANCIALSEQUENCENUMBER	/POSDW/SEQUENCENUMBER	CHAR	10	0	Financial Transaction Item Number
37	FITYPECODE	☐	/POSDW/FINANCIALTYPECODE	/POSDW/FINANCIALTYPECODE	CHAR	4	0	Financial Transaction Category	*
38	ACCOUNTID	☐	/POSDW/ACCOUNTID	/POSDW/ACCOUNT	CHAR	10	0	Account Number
39	ACCOUNTASSIGNOBJ	☐	/POSDW/ACCOUNTASSIGNMENTOBJECT	/POSDW/ACCOUNT	CHAR	10	0	Account Assignment Object
40	AMOUNT	☐	/POSDW/AMOUNT	/POSDW/CURRENCY	CURR	15	2	Value
41	FICURRENCY	☐	/POSDW/FINANCIALCURRENCY	WAERS	CUKY	5	0	Currency	*
42	REFERERENCEID	☐	/POSDW/REFERENCEID	/POSDW/REFERENCEID	CHAR	35	0	Reference Number
43	.INCLUDE	☐				0	0	Financial Transaction - Enhanced Field
44	FITYPEGROUP	☐	/POSDW/FINANCIALTYPEGROUP	/POSDW/FINANCIALTYPEGROUP	CHAR	4	0	Financial Transaction Type Group	/POSDW/FITG
45	FIDEBITFLAG	☐	/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_FINANCIALMOVEMENT	FITYPEGROUP	/POSDW/FITG	FITYPEGROUP	KEY	1	CN
2	/POSDW/BW_FINANCIALMOVEMENT	TRANSTYPECODE	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
3	/POSDW/BW_FINANCIALMOVEMENT	TRANSTYPEGROUP	/POSDW/TRANTG	TRANSTYPEGROUP		1	CN

History

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