SAP ABAP Table RSBCT_RPA_TRAN_GDS_MOV (PIPE Extraction: POS Transaction - Financial Transactions)

Hierarchy

☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR (Application Component) Retail and Consumer Goods
     ⤷ RS_BCT_RETAIL_POSDW (Package) BW: Content POS Analytics

Basic Data

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

History

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