SAP ABAP Table FCBW_S_RP_DTL (Detail structure for hierarchical reporting)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ EC-CS (Application Component) Consolidation
     ⤷ FCBW_UC (Package) SEM-BCS: Integration to BW

Basic Data

Table Category	INTTAB	Structure
Structure	FCBW_S_RP_DTL	Table Relationship Diagram
Short Description	Detail structure for hierarchical reporting

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	RFCDEST	☐	RFCDEST	RFCDEST	CHAR	32	0	Logical Destination (Specified in Function Call)	*
2	INFOCUBE	☐	RSINFOCUBE	RSINFOCUBE	CHAR	30	0	InfoCube
3	ID	☐			INT4	10	0
4	SYS_R3	☐			CHAR	2	0
5	SYS_BW	☐			CHAR	2	0
6	BW_HSL	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
7	BW_KSL	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
8	BW_TSL	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
9	BW_MSL	☐	MSLXX9	MENGV9	QUAN	17	3	Total of the transactions of period in units of measure
10	BW_YTD_LC	☐	FCBW_YTD_LC	WERTV9	CURR	17	2	Cumulative balance in local currency
11	BW_YTD_GC	☐	FCBW_YTD_GC	WERTV9	CURR	17	2	Cumulative balance in group currency
12	BW_YTD_TC	☐	FCBW_YTD_TC	WERTV9	CURR	17	2	Cumulative balance in transaction currency
13	BW_YTD_QTY	☐	FCBW_YTD_QTY	MENGV9	QUAN	17	3	Cumulative balance in units of quantity
14	.INCLUDE	☐				0	0	Extraction structure for Real Time Update SEM to BW
15	HSL	☐	HSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in local currency
16	KSL	☐	KSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in group currency
17	TSL	☐	TSLXX9	WERTV9	CURR	17	2	Total of transactions of the period in transaction currency
18	MSL	☐	MSLXX9	MENGV9	QUAN	17	3	Total of the transactions of period in units of measure
19	YTD_LC	☐	FCBW_YTD_LC	WERTV9	CURR	17	2	Cumulative balance in local currency
20	YTD_GC	☐	FCBW_YTD_GC	WERTV9	CURR	17	2	Cumulative balance in group currency
21	YTD_TC	☐	FCBW_YTD_TC	WERTV9	CURR	17	2	Cumulative balance in transaction currency
22	YTD_QTY	☐	FCBW_YTD_QTY	MENGV9	QUAN	17	3	Cumulative balance in units of quantity
23	RLCUR	☐	FCBW_LCUR	WAERS	CUKY	5	0	Currency key for local currency	*
24	RGCUR	☐	FCBW_GCUR	WAERS	CUKY	5	0	Currency key for group currency	*
25	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
26	RUNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
27	RDIMEN	☐	FC_DIMEN	FC_DIMEN	CHAR	2	0	Dimension	*
28	RVERS	☐	FC_RVERS	FC_RVERS	CHAR	3	0	Consolidation (end-result) version	*
29	FISCVARNT	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
30	RYEAR	☐	FC_RYEAR	GJAHR	NUMC	4	0	Fiscal year
31	POPER	☐	POPER	POPER	NUMC	3	0	Posting period
32	RCONGR	☐	FC_CONGR	FC_CONGR	CHAR	18	0	Consolidation group	*
33	RBUNIT	☐	FC_BUNIT	FC_BUNIT	CHAR	18	0	Consolidation unit	*
34	RITCLG	☐	FC_ITCLG	FC_ITCLG	CHAR	2	0	Consolidation chart of accounts	*
35	RITEM	☐	FC_ITEM	FC_ITEM	CHAR	10	0	Financial statement item	*
36	SITYP	☐	FC_SITYP	FC_SITYP	CHAR	3	0	Subitem category	*
37	SUBIT	☐	FC_SITEM	FC_SITEM	CHAR	10	0	Subitem	*
38	COICU	☐	FC_COICU	FC_BUNIT	CHAR	18	0	Investee unit	*
39	YRACQ	☐	FC_RYACQ	GJAHR	NUMC	4	0	Year of acquisition
40	PRACQ	☐	RPACQ	NUM03	NUMC	3	0	Period of Acquisition
41	RBUPTR	☐	FC_BUPTR	FC_BUNIT	CHAR	18	0	Partner unit	*
42	PLEVL	☐	FC_PLEVL	FC_PLEVL	CHAR	2	0	Posting level
43	DOCTY	☐	FC_DOCTY	FC_DOCTY	CHAR	2	0	Document type	*
44	HDATEFROM	☐	FCBW_HDATFR	DATS	DATS	8	0	Source hierarchy
45	HDATETO	☐	FCBW_HDATTO	DATS	DATS	8	0	Target hierarchy
46	RLDNR	☐	FC_RLDNR	RLDNR	CHAR	2	0	Ledger	*
47	FSCAT	☐	FC_FSCAT	FC_FSCAT	CHAR	1	0	Consolidation frequency	*
48	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
49	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
50	RCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	*
51	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
52	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
53	SCOMP	☐	RCOMP_D	RCOMP	CHAR	6	0	Company	*
54	SBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
55	SPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
56	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
57	SGSBER	☐	SGSBER	CHAR4	CHAR	4	0	Sender business area
58	DUMMY	☐	FC_DUMMY	FC_DUMMY	CHAR	36	0	User-defined field for use in upload methods
59	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20130529
SAP Release Created in