GLE_MCA_STR_FX_TRN SAP (MCA: Output structure report Check Parallel Currency(Rep 2)) Structure details
Description: MCA: Output structure report Check Parallel Currency(Rep 2)
Related tables to GLE_MCA_STR_FX_TRN
Access table GLE_MCA_STR_FX_TRN
Structure field list including key, data, relationships and ABAP select examples
GLE_MCA_STR_FX_TRN is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "MCA: Output structure report Check Parallel Currency(Rep 2)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_GLE_MCA_STR_FX_TRN TYPE GLE_MCA_STR_FX_TRN.
The GLE_MCA_STR_FX_TRN table consists of various fields, each holding specific information or linking keys about MCA: Output structure report Check Parallel Currency(Rep 2) data available in SAP. These include BUKRS (Company Code), BUDAT (Posting Date in the Document), BELNR (Accounting Document Number), GJAHR (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP GLE_MCA_STR_FX_TRN structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
STATUS | Character Field Length 1 | CHAR01 | CHAR | 1 | CHAR1 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
BKTXT | Document Header Text | BKTXT | CHAR | 25 | TEXT25 | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | Assigned to domain | WAERS | |||
HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | Assigned to domain | WAERS | |||
NEWBK | Company Code for the Next Line Item | NEWBK | CHAR | 4 | T001 | BUKRS | |||
BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PARGB | Trading partner's business area | PARGB | CHAR | 4 | TGSB | GSBER | GSB | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
DMBTR | Amount Local Currency | GLE_MCA_DTE_DMBTR | CURR | 23(2) | WERTV12 | ||||
WRBTR | Amount in Document Currency | GLE_MCA_DTE_WRBTR | CURR | 23(2) | WERTV12 | ||||
MWSTS | Tax Amount in Local Currency | MWSTS | CURR | 13(2) | WERT7 | ||||
WMWST | Tax amount in document currency | WMWST | CURR | 13(2) | WERT7 | ||||
FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 13(2) | WERT7 | ||||
QSSHB | Withholding Tax Base Amount | QSSHB | CURR | 13(2) | WERT7 | ||||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
BEWAR | Transaction Type | RMVCT | CHAR | 3 | T856 | RMVCT | |||
ALTKT | Group account number | BILKT_SKA1 | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | VBEP | ETENR | |||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
ANBWA | Asset Transaction Type | ANBWA | CHAR | 3 | TABW | BWASL | |||
BZDAT | Asset value date | BZDAT | DATS | 8 | DATUM | ||||
XUMSW | Indicator: Sales-related item ? | XUMSW | CHAR | 1 | XFELD | ||||
XKRES | Indicator: Can Line Items Be Displayed by Account? | XKRES | CHAR | 1 | XFELD | ||||
XOPVW | Indicator: Open item management? | XOPVW | CHAR | 1 | XFELD | ||||
XSKRL | Indicator: Line item not liable to cash discount? | XSKRL | CHAR | 1 | XFELD | ||||
XNCOP | Indicator: Items cannot be copied? | XNCOP | CHAR | 1 | XFELD | ||||
XZAHL | Indicator: Is the posting key used in a payment transaction? | XZAHL | CHAR | 1 | XFELD | ||||
SAKNR | G/L Account Number | SAKNR | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | SAK | C_SAKNR |
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
XBILK | Indicator: Account is a balance sheet account? | XBILK | CHAR | 1 | XFELD | ||||
GVTYP | P&L statement account type | GVTYP | CHAR | 2 | CHAR2 | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT | CURR | 13(2) | WERT7 | ||||
WSKTO | Cash discount amount in document currency | WSKTO | CURR | 13(2) | WERT7 | ||||
LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | Assigned to domain | LZBKZ | |||
LANDL | Supplying Country | LANDL | CHAR | 3 | Assigned to domain | LAND1 | |||
QSFBT | Withholding Tax-Exempt Amount (in Document Currency) | QSFBT | CURR | 13(2) | WERT7 | ||||
BUALT | Amount posted in alternative price control | BUALT | CURR | 13(2) | WERTV7 | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | Assigned to domain | ALPHA | JV_NAME | JVV | |
EGRUP | Equity group | JV_EGROUP | CHAR | 3 | Assigned to domain | ALPHA | JV_EGROUP | GJE | |
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
PROJK | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | Assigned to domain | KONPR | PS_POSNR | ||
DMBE2 | Amount in Second Local Currency | GLE_MCA_DTE_DMBE2 | CURR | 23(2) | WERTV12 | ||||
DMBE3 | Amount in Third Local Currency | GLE_MCA_DTE_DMBE3 | CURR | 23(2) | WERTV12 | ||||
LOKKT | Alternative account number in company code | ALTKT_SKB1 | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
PPRCT | Partner Profit Center | PPRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PPC | |
FKBER | Functional Area | FKBER_SHORT | CHAR | 4 | FKBER_SHORT | FBE | |||
FKBER_LONG | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
AUGGJ | Fiscal Year of Clearing Document | AUGGJ | NUMC | 4 | GJAHR | GJAHR | |||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | TCURC | WAERS | |||
PSWBT | Amount for Updating in General Ledger | GLE_MCA_DTE_PSWBT | CURR | 23(2) | WERTV12 | ||||
XAUTO | Indicator: Line item automatically created | XAUTO | CHAR | 1 | XFELD | ||||
TC_CURKY | Transaction Currency | GLE_MCA_DTE_FXR_TRNS_CURRENCY | CUKY | 5 | Assigned to domain | WAERS | |||
TC_AMOUNT | Transaction Amount | GLE_MCA_DTE_TRANSACTION_AMOUNT | CURR | 13(2) | WERT7 | ||||
FCUR | Functional Currency | GLE_MCA_DTE_FCUR | CUKY | 5 | Assigned to domain | WAERS | |||
FCUR_AMT | Amount in Functional Currency | GLE_MCA_DTE_AMOUNT_FC | CURR | 13(2) | WERT7 | ||||
FCUR_AMT_CALC | Calculated Amount in Functional Currency | GLE_MCA_DTE_AMOUNT_CALC | CURR | 13(2) | WERT7 | ||||
FCUR_AMT_DIFF | Amount Difference | GLE_MCA_DTE_AMOUNT_DIFF | CURR | 13(2) | WERT7 | ||||
RATE_TYPE | Exchange Rate Type | KURST | CHAR | 4 | Assigned to domain | KURST | KUT | ||
RATE_ORIG | Original Exchange Rate | GLE_MCA_DTE_RATE_ORIG | DEC | 28(14) | EXCRX | GLE_FXR_RATEX28 | |||
RATE_CALC | Exchange Rate | GLE_MCA_DTE_N_ERATE | DEC | 28(14) | EXCRX | GLE_FXR_RATEX28 | |||
RATE_DIFF | Difference btw. Exchange Rate and Original Exchange Rate | GLE_MCA_DTE_RATE_DIFF | DEC | 28(14) | EXCRX | GLE_FXR_RATEX28 | |||
RATE_DIV | Deviation in % btw. Exchange Rate and Original Exchange Rate | GLE_MCA_DTE_RATE_DIV | DEC | 31(2) | GLE_FXR_RATEDIF |
Key field | Non-key field |
How do I retrieve data from SAP structure GLE_MCA_STR_FX_TRN using ABAP code?
As GLE_MCA_STR_FX_TRN is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on GLE_MCA_STR_FX_TRN as there is no data to select.How to access SAP table GLE_MCA_STR_FX_TRN
Within an ECC or HANA version of SAP you can also view further information about GLE_MCA_STR_FX_TRN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects