SAP ABAP Table GLE_MCA_STR_FX_TRN (MCA: Output structure report Check Parallel Currency(Rep 2))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL-CU-MCA (Application Component) Multi Currency Accounting
     ⤷ FAGL_MCA_AL_RP (Package) FI: MCA Reporting

Basic Data

Table Category	INTTAB	Structure
Structure	GLE_MCA_STR_FX_TRN	Table Relationship Diagram
Short Description	MCA: Output structure report Check Parallel Currency(Rep 2)

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	STATUS	☐	CHAR01	CHAR1	CHAR	1	0	Character Field Length 1
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
4	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
5	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
6	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
7	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
8	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
9	CPUDT	☐	CPUDT	DATUM	DATS	8	0	Accounting document entry date
10	CPUTM	☐	CPUTM	UZEIT	TIMS	6	0	Time of data entry
11	USNAM	☐	USNAM	XUBNAME	CHAR	12	0	User name	*
12	TCODE	☐	TCODE	TCODE	CHAR	20	0	Transaction Code	*
13	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
14	BKTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
15	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
16	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
17	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
18	.INCLUDE	☐				0	0	MCA document line (reduced number of fields)
19	NEWBK	☐	NEWBK	BUKRS	CHAR	4	0	Company Code for the Next Line Item	T001
20	BUZID	☐	BUZID	CHAR1	CHAR	1	0	Identification of the Line Item
21	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
22	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
23	KOART	☐	KOART	KOART	CHAR	1	0	Account type
24	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
25	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
26	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	TGSB
27	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
28	DMBTR	☐	GLE_MCA_DTE_DMBTR	WERTV12	CURR	23	2	Amount Local Currency
29	WRBTR	☐	GLE_MCA_DTE_WRBTR	WERTV12	CURR	23	2	Amount in Document Currency
30	MWSTS	☐	MWSTS	WERT7	CURR	13	2	Tax Amount in Local Currency
31	WMWST	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
32	FWBAS	☐	FWBAS	WERT7	CURR	13	2	Tax Base Amount in Document Currency
33	QSSHB	☐	QSSHB	WERT7	CURR	13	2	Withholding Tax Base Amount
34	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
35	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
36	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
37	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
38	BEWAR	☐	RMVCT	RMVCT	CHAR	3	0	Transaction type	T856
39	ALTKT	☐	BILKT_SKA1	SAKNR	CHAR	10	0	Group Account Number	*
40	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
41	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
42	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
43	POSN2	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
44	ETEN2	☐	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
45	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
46	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
47	ANBWA	☐	ANBWA	BWASL	CHAR	3	0	Asset Transaction Type	TABW
48	BZDAT	☐	BZDAT	DATUM	DATS	8	0	Asset Value Date
49	XUMSW	☐	XUMSW	XFELD	CHAR	1	0	Indicator: Sales-Related Item ?
50	XKRES	☐	XKRES	XFELD	CHAR	1	0	Indicator: Can Line Items Be Displayed by Account?
51	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
52	XSKRL	☐	XSKRL	XFELD	CHAR	1	0	Indicator: Line item not liable to cash discount?
53	XNCOP	☐	XNCOP	XFELD	CHAR	1	0	Indicator: Items Cannot Be Copied?
54	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
55	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
56	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
57	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
58	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
59	XBILK	☐	XBILK	XFELD	CHAR	1	0	Indicator: Account is a balance sheet account?
60	GVTYP	☐	GVTYP	CHAR2	CHAR	2	0	P&L statement account type
61	SKFBT	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
62	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
63	LZBKZ	☐	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator	*
64	LANDL	☐	LANDL	LAND1	CHAR	3	0	Supplying Country	*
65	QSFBT	☐	QSFBT	WERT7	CURR	13	2	Withholding Tax-Exempt Amount (in Document Currency)
66	BUALT	☐	BUALT	WERTV7	CURR	13	2	Amount posted in alternative price control
67	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
68	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
69	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
70	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
71	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
72	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
73	DMBE2	☐	GLE_MCA_DTE_DMBE2	WERTV12	CURR	23	2	Amount in Second Local Currency
74	DMBE3	☐	GLE_MCA_DTE_DMBE3	WERTV12	CURR	23	2	Amount in Third Local Currency
75	LOKKT	☐	ALTKT_SKB1	SAKNR	CHAR	10	0	Alternative Account Number in Company Code	*
76	PPRCT	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
77	FKBER	☐	FKBER_SHORT	FKBER_SHORT	CHAR	4	0	Functional Area
78	FKBER_LONG	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
79	AUGGJ	☐	AUGGJ	GJAHR	NUMC	4	0	Fiscal Year of Clearing Document
80	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	TCURC
81	PSWBT	☐	GLE_MCA_DTE_PSWBT	WERTV12	CURR	23	2	Amount for Updating in General Ledger
82	XAUTO	☐	XAUTO	XFELD	CHAR	1	0	Indicator: Line item automatically created
83	.INCLUDE	☐				0	0
84	.INCLUDE	☐				0	0
85	.INCLUDE	☐				0	0	MCA: Structure for exchange rate differences
86	TC_CURKY	☐	GLE_MCA_DTE_FXR_TRNS_CURRENCY	WAERS	CUKY	5	0	Transaction Currency	*
87	TC_AMOUNT	☐	GLE_MCA_DTE_TRANSACTION_AMOUNT	WERT7	CURR	13	2	Transaction Amount
88	FCUR	☐	GLE_MCA_DTE_FCUR	WAERS	CUKY	5	0	Functional Currency	*
89	FCUR_AMT	☐	GLE_MCA_DTE_AMOUNT_FC	WERT7	CURR	13	2	Amount in Functional Currency
90	FCUR_AMT_CALC	☐	GLE_MCA_DTE_AMOUNT_CALC	WERT7	CURR	13	2	Calculated Amount in Functional Currency
91	FCUR_AMT_DIFF	☐	GLE_MCA_DTE_AMOUNT_DIFF	WERT7	CURR	13	2	Amount Difference
92	RATE_TYPE	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	*
93	RATE_ORIG	☐	GLE_MCA_DTE_RATE_ORIG	GLE_FXR_RATEX28	DEC	28	14	Original Exchange Rate
94	RATE_CALC	☐	GLE_MCA_DTE_N_ERATE	GLE_FXR_RATEX28	DEC	28	14	Exchange Rate
95	RATE_DIFF	☐	GLE_MCA_DTE_RATE_DIFF	GLE_FXR_RATEX28	DEC	28	14	Difference btw. Exchange Rate and Original Exchange Rate
96	RATE_DIV	☐	GLE_MCA_DTE_RATE_DIV	GLE_FXR_RATEDIF	DEC	31	2	Deviation in % btw. Exchange Rate and Original Exchange Rate

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	GLE_MCA_STR_FX_TRN	ANBWA	TABW	BWASL
2	GLE_MCA_STR_FX_TRN	ANLN1	ANLH	ANLN1
3	GLE_MCA_STR_FX_TRN	ANLN2	ANLA	ANLN2
4	GLE_MCA_STR_FX_TRN	AUFNR	AUFK	AUFNR
5	GLE_MCA_STR_FX_TRN	BEWAR	T856	TRTYP
6	GLE_MCA_STR_FX_TRN	BSCHL	TBSL	BSCHL
7	GLE_MCA_STR_FX_TRN	ETEN2	VBEP	ETENR
8	GLE_MCA_STR_FX_TRN	GSBER	TGSB	GSBER
9	GLE_MCA_STR_FX_TRN	KOSTL	CSKS	KOSTL
10	GLE_MCA_STR_FX_TRN	KUNNR	KNA1	KUNNR
11	GLE_MCA_STR_FX_TRN	LIFNR	LFA1	LIFNR
12	GLE_MCA_STR_FX_TRN	MWSKZ	T007A	MWSKZ
13	GLE_MCA_STR_FX_TRN	NEWBK	T001	BUKRS
14	GLE_MCA_STR_FX_TRN	PARGB	TGSB	GSBER
15	GLE_MCA_STR_FX_TRN	POSN2	VBUP	POSNR
16	GLE_MCA_STR_FX_TRN	PSWSL	TCURC	WAERS		C	CN
17	GLE_MCA_STR_FX_TRN	VBEL2	VBUK	VBELN
18	GLE_MCA_STR_FX_TRN	VBUND	T880	RCOMP

History

Last changed by/on	SAP	20130529
SAP Release Created in	600