SAP ABAP Table /RTF/_S_SOURCE_FIELDS_DS (Gen. Interface in Class /RTF/CL_KYF_TRANSFORM for Datasource)

Hierarchy

☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-ISR (Application Component) Retail and Consumer Goods
     ⤷ /RTF/P01 (Package) BW: Content Retail Foundation

Basic Data

Table Category	INTTAB	Structure
Structure	/RTF/_S_SOURCE_FIELDS_DS	Table Relationship Diagram
Short Description	Gen. Interface in Class /RTF/CL_KYF_TRANSFORM for Datasource

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	BWVORG	☐	/RTF/DE_PROCESS_KEY	/RTF/DO_PROCESS_KEY	NUMC	3	0	Process Key	*
2	MATNR	☐	/RTF/DE_MATERIAL	MATNR	CHAR	18	0	Product	*
3	AKTNR	☐	/RTF/DE_PROMO	CHAR10	CHAR	10	0	Action
4	PROMOTIONID	☐	/RTF/DE_PROMO	CHAR10	CHAR	10	0	Action
5	BSTTYP	☐	/RTF/DE_STOCKCAT	CHAR1	CHAR	1	0	Stock Category
6	BWBREL	☐	/RTF/DE_STOCKRELEV	CHAR1	CHAR	1	0	Stock Is Relevant
7	BWART	☐	/RTF/DE_MOVETYPE	CHAR3	CHAR	3	0	Movement Type
8	GRUND	☐	/RTF/DE_MATMREA	NUMC4	NUMC	4	0	Reason for Goods Movement
9	RECORDQUALIFIER	☐	/RTF/DE_RQU	CHAR4	CHAR	4	0	Record Type of Transaction
10	BUSINESSTYPE	☐	/RTF/DE_BTY	CHAR1	CHAR	1	0	Business Transaction
11	ENDTIMESTAMP	☐	CHAR14	CHAR14	CHAR	14	0	Text field length 14
12	TAXAMOUNT	☐	/RTF/DE_TAM	RSKYFAMO	CURR	17	2	Tax Amount
13	TAXINCLUDEDFLAG	☐	/RTF/DE_TIF	CHAR1	CHAR	1	0	Indicates Whether Taxes Are Included in Sales Value
14	BWMNG	☐	/RTF/DE_QUABU	RSKYFQUA	QUAN	17	3	Quantity in Base Unit of Measure
15	BWGEO	☐	/RTF/DE_PVLC	RSKYFAMO	CURR	17	2	Purchase Value in Local Currency
16	BWGVO	☐	/RTF/DE_SVLC	RSKYFAMO	CURR	17	2	Sales Value in Local Currency Without Tax
17	BWGVP	☐	/RTF/DE_STLC	RSKYFAMO	CURR	17	2	Sales Value in Local Currency with Tax
18	NOPOS	☐	/RTF/DE_NOITEMS	INT4	INT4	10	0	Number of Transactions
19	REDUCTIONAMOUNT	☐	/RTF/DE_REA	RSKYFAMO	CURR	17	2	Discount Value
20	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
21	HWAER	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
22	STORECURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
23	TRANSCURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
24	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
25	LMEIN	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
26	SALESAMOUNT	☐	/RTF/DE_SAT	RSKYFAMO	CURR	17	2	Sales in Sales Value
27	DISTDISC	☐	/RTF/DE_DDI	RSKYFAMO	CURR	17	2	Conditions for Document Header
28	RETAILQUANTITY	☐	/RTF/DE_RLQ	RSKYFQUA	QUAN	17	3	Sales Quantity in Sales Unit
29	COST	☐	/RTF/DE_CST	RSKYFAMO	CURR	17	2	Sales at Cost Value
30	TENDERAMOUNT	☐	/RTF/DE_TAT	RSKYFAMO	CURR	17	2	Tender Value
31	NORMALSALESAMT	☐	/RTF/DE_NSA	RSKYFAMO	CURR	17	2	Normal Sales Value
32	BASEQUANTITY	☐	/RTF/DE_BASE_QTY	RSKYFQUA	QUAN	17	3	Baseline Sales Quantity in Base Unit of Measure
33	COMMAMOUNT	☐	/RTF/DE_CAM	RSKYFAMO	CURR	17	2	Commission Amount
34	DISTTAX	☐	/RTF/DE_DTA	RSKYFAMO	CURR	17	2	Distributed Header Tax
35	DISTTENDER	☐	/RTF/DE_DTE	RSKYFAMO	CURR	17	2	Means of Payment (Header)
36	TOTALSALESAMOUNT	☐	/RTF/DE_TSA	RSKYFAMO	CURR	17	2	Gross Value of Transaction
37	TURNOVER	☐	/RTF/DE_TRNOV	RSKYFAMO	CURR	17	2	Total Turnover per Transaction (Receipt) in Doc. Currency
38	LINEITEMCOUNT	☐	/RTF/DE_LNECNT	RSKYFNUM	DEC	17	3	Number of Sales Items
39	ACTUALAMOUNT	☐	/RTF/DE_ACA	RSKYFAMO	CURR	17	2	Actual Amount (Cash Desk)
40	SHORTAMOUNT	☐	/RTF/DE_SAM	RSKYFAMO	CURR	17	2	Negative Cash Desk Difference
41	OVERAMOUNT	☐	/RTF/DE_OAM	RSKYFAMO	CURR	17	2	Positive Cash Desk Difference
42	REMOVALAMOUNT	☐	/RTF/DE_RAM	RSKYFAMO	CURR	17	2	Value Removed
43	REMOVALCOUNT	☐	/RTF/DE_RCN	RSKYFNUM	DEC	17	3	Number of Cash Removals
44	BANKAMOUNT	☐	/RTF/DE_BAM	RSKYFAMO	CURR	17	2	Amount Transferred to Bank
45	TRANSCNT	☐	/RTF/DE_TCN	RSKYFNUM	DEC	17	3	Number of Transactions
46	NOSALETRANSCNT	☐	/RTF/DE_NST	RSKYFNUM	DEC	17	3	Number of Void Receipts
47	IMMEDIATEVOIDCNT	☐	/RTF/DE_VCN	RSKYFNUM	DEC	17	3	Number of Immediate Cancellations
48	IMMEDIATEVOIDAMT	☐	/RTF/DE_VAM	RSKYFAMO	CURR	17	2	Value of Immediate Cancellations
49	LINEITEMVOIDCNT	☐	/RTF/DE_LVC	RSKYFNUM	DEC	17	3	Number of Line Cancellations
50	LINEITEMVOIDAMT	☐	/RTF/DE_LVA	RSKYFAMO	CURR	17	2	Value of Line Cancellations
51	POSTVOIDCNT	☐	/RTF/DE_PVC	RSKYFNUM	DEC	17	3	Number of Transaction Cancellations
52	POSTVOIDAMT	☐	/RTF/DE_PVA	RSKYFAMO	CURR	17	2	Value of Transaction Cancellations
53	TERMINATIONCNT	☐	/RTF/DE_TCO	RSKYFNUM	DEC	17	3	Number of Terminations
54	TERMINATIONAMT	☐	/RTF/DE_TEA	RSKYFAMO	CURR	17	2	Value of Terminations
55	REPORTCNT	☐	/RTF/DE_RCT	RSKYFNUM	DEC	17	3	Number of Reports
56	FAILEDLOGONCNT	☐	/RTF/DE_FLC	RSKYFNUM	DEC	17	3	Number of Failed Logons
57	SCANNEDITEMCNT	☐	/RTF/DE_SIC	RSKYFNUM	DEC	17	3	Number of Scanned Items
58	SCANNEDITEMAMT	☐	/RTF/DE_SIA	RSKYFAMO	CURR	17	2	Value of Scanned Items
59	OPENDEPARTMNTCNT	☐	/RTF/DE_ODC	RSKYFNUM	DEC	17	3	Number of Material Group Sales
60	OPENDEPARTMNTAMT	☐	/RTF/DE_ODA	RSKYFAMO	CURR	17	2	Value of Material Group Sales
61	CHECKSOVERCNT	☐	/RTF/DE_CLC	RSKYFNUM	DEC	17	3	Number of Checks Over Limit
62	CHECKSOVERAMT	☐	/RTF/DE_CLA	RSKYFAMO	CURR	17	2	Value of Checks Over Limit
63	DISCCOUNT	☐	/RTF/DE_CCO	RSKYFNUM	DEC	17	3	Number of Discount Items
64	LOCKTIME	☐	/RTF/DE_LOT	RSKYFNUM	DEC	17	3	Time Cash Desk Is Locked
65	IDLETIME	☐	/RTF/DE_IDT	RSKYFNUM	DEC	17	3	Non-Sales Time
66	LOGONTIME	☐	/RTF/DE_LTI	RSKYFNUM	DEC	17	3	Logon Time
67	RINGTIME	☐	/RTF/DE_RTI	RSKYFNUM	DEC	17	3	Cashier Time
68	TAXCOUNT	☐	/RTF/DE_TCT	RSKYFNUM	DEC	17	3	Number of Tax Items
69	TENDERCOUNT	☐	/RTF/DE_TEC	RSKYFNUM	DEC	17	3	Number of Tender Type Items
70	AMOUNT	☐	/RTF/DE_AMT	RSKYFAMO	CURR	17	2	Value
71	UNITCOUNT	☐	/RTF/DE_UCT	RSKYFQUA	QUAN	17	3	Goods Movement Quantity in Sales Unit
72	EXTVALUATIONAMT	☐	/RTF/DE_EVA	RSKYFAMO	CURR	17	2	External Valuation Price
73	UNITSSHIPPEDCNT	☐	/RTF/DE_UST	RSKYFQUA	QUAN	17	3	Delivery Quantity in Sales Unit
74	REVERSALFLAG	☐	/RTF/DE_RFL	CHAR1	CHAR	1	0	Reversal (Reversal from PIPE)
75	RETL_ITEM_CAT	☐	/RTF/DE_RETL_ITEM_CAT	CHAR1	CHAR	1	0	Category
76	RETL_ITEM_SCAT	☐	/RTF/DE_RETL_ITEM_SCAT	CHAR1	CHAR	1	0	Subcategory
77	FKIMG	☐	/RTF/DE_INV_QTY	RSKYFQUA	QUAN	17	3	Billing Quantity in Sales Units
78	WAVWR	☐	/RTF/DE_COST	RSKYFAMO	CURR	17	2	Allocation Value in Document Currency
79	NETWR	☐	/RTF/DE_NETVAL_INV	RSKYFAMO	CURR	17	2	Net Value of Billing Item in Document Currency
80	BRTWR	☐	/RTF/DE_GROSS_VAL	RSKYFAMO	CURR	17	2	Gross Value in Sales Document Currency
81	MWSBP	☐	/RTF/DE_TAX_AMOUNT	RSKYFAMO	CURR	17	2	Tax Amount in Document Currency
82	ANZFKPOS	☐	/RTF/DE_NO_INV_IT	RSKYFNUM	DEC	17	3	Number of Billing Items
83	VRKME	☐	/RTF/DE_SALES_UNIT	MEINS	UNIT	3	0	Sales Unit	*
84	UMVKZ	☐	/RTF/DE_NUMERATOR	RSKYFNUM	DEC	17	3	Factor for Converting Sales Quantity to SKU
85	UMREZ	☐	/RTF/DE_NUMERATOR	RSKYFNUM	DEC	17	3	Factor for Converting Sales Quantity to SKU
86	UMVKN	☐	/RTF/DE_DENOMINTR	RSKYFNUM	DEC	17	3	Divisor for Conversion of Sales Quantity to SKU
87	UMREN	☐	/RTF/DE_DENOMINTR	RSKYFNUM	DEC	17	3	Divisor for Conversion of Sales Quantity to SKU
88	KURSK_DAT	☐	DATUM	DATUM	DATS	8	0	Date
89	KURSK	☐	/RTF/DE_EXCHG_RATE	RSKYFFLO	FLTP	16	16	Exchange Rate for Pricing and Statistics
90	WKURS	☐	/RTF/DE_EXCHG_RATE	RSKYFFLO	FLTP	16	16	Exchange Rate for Pricing and Statistics
91	WAERK	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
92	DBWGEO	☐	/RTF/DE_DEOGPVOC	RSKYFAMO	CURR	17	2	Delta Order/Goods Receipt PPw/oVAT
93	DBWMNG	☐	/RTF/DE_DEOGQUOU	RSKYFQUA	QUAN	17	3	Delta Order/Goods Receipt Order Quantity
94	BWGEOO	☐	/RTF/DE_PVOC	RSKYFAMO	CURR	17	2	Purchase Value in Order Currency
95	DATS	☐	DATUM	DATUM	DATS	8	0	Date
96	NOSCL	☐	/RTF/DE_NO_SCL	RSKYFNUM	DEC	17	3	Counter for Scheduling Agreement Schedule Lines
97	BUDAT	☐	DATUM	DATUM	DATS	8	0	Date
98	REDUCTIONAMOUNTN	☐	/RTF/DE_REANT	RSKYFAMO	CURR	17	2	Discount Value Without Value-Added Tax (Document Currency)
99	REDUCTIONAMOUNTG	☐	/RTF/DE_REAWT	RSKYFAMO	CURR	17	2	Discount Value with Value-Added Tax (Document Currency)

History

Last changed by/on	SAP	20141031
SAP Release Created in	712