GLE_MCA_STR_FX_TRN SAP (MCA: Output structure report Check Parallel Currency(Rep 2)) Structure details

Dictionary Type: Structure
Description: MCA: Output structure report Check Parallel Currency(Rep 2)




ABAP Code to SELECT data from GLE_MCA_STR_FX_TRN
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
STATUSCharacter Field Length 1 CHAR01CHAR1CHAR1
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUDATPosting Date in the Document BUDATDATS8DATUM
BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BLDATDocument Date in Document BLDATDATS8DATUM
CPUDTDay On Which Accounting Document Was Entered CPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
TCODETransaction Code TCODECHAR20Assigned to domainTCODETCD
XBLNRReference Document Number XBLNR1CHAR16XBLNR1
BKTXTDocument Header Text BKTXTCHAR25TEXT25
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
HWAE2Currency Key of Second Local Currency HWAE2CUKY5Assigned to domainWAERS
HWAE3Currency Key of Third Local Currency HWAE3CUKY5Assigned to domainWAERS
NEWBKCompany Code for the Next Line Item NEWBKCHAR4T001BUKRS
BUZIDIdentification of the Line Item BUZIDCHAR1CHAR1
AUGBLDocument Number of the Clearing Document AUGBLCHAR10ALPHABELNR
BSCHLPosting Key BSCHLCHAR2TBSLBSCHL
KOARTAccount Type KOARTCHAR1KOART
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
PARGBTrading partner's business area PARGBCHAR4TGSBGSBERGSB
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ
DMBTRAmount Local Currency GLE_MCA_DTE_DMBTRCURR23(2) WERTV12
WRBTRAmount in Document Currency GLE_MCA_DTE_WRBTRCURR23(2) WERTV12
MWSTSTax Amount in Local Currency MWSTSCURR13(2) WERT7
WMWSTTax amount in document currency WMWSTCURR13(2) WERT7
FWBASTax Base Amount in Document Currency FWBASCURR13(2) WERT7
QSSHBWithholding Tax Base Amount QSSHBCURR13(2) WERT7
VALUTValue date VALUTDATS8DATUM
ZUONRAssignment Number DZUONRCHAR18ZUONR
SGTXTItem Text SGTXTCHAR50TEXT50
VBUNDCompany ID of trading partner RASSCCHAR6T880ALPHARCOMPPGS
BEWARTransaction Type RMVCTCHAR3T856RMVCT
ALTKTGroup account number BILKT_SKA1CHAR10Assigned to domainALPHASAKNR
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
VBEL2Sales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
POSN2Sales Document Item POSNR_VANUMC6VBUPPOSNRAPO
ETEN2Delivery Schedule Line Number ETENRNUMC4VBEPETENR
ANLN1Main Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
ANBWAAsset Transaction Type ANBWACHAR3TABWBWASL
BZDATAsset value date BZDATDATS8DATUM
XUMSWIndicator: Sales-related item ? XUMSWCHAR1XFELD
XKRESIndicator: Can Line Items Be Displayed by Account? XKRESCHAR1XFELD
XOPVWIndicator: Open item management? XOPVWCHAR1XFELD
XSKRLIndicator: Line item not liable to cash discount? XSKRLCHAR1XFELD
XNCOPIndicator: Items cannot be copied? XNCOPCHAR1XFELD
XZAHLIndicator: Is the posting key used in a payment transaction? XZAHLCHAR1XFELD
SAKNRG/L Account Number SAKNRCHAR10Assigned to domainALPHASAKNRSAKC_SAKNR
HKONTGeneral Ledger Account HKONTCHAR10Assigned to domainALPHASAKNR
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
XBILKIndicator: Account is a balance sheet account? XBILKCHAR1XFELD
GVTYPP&L statement account type GVTYPCHAR2CHAR2
SKFBTAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
WSKTOCash discount amount in document currency WSKTOCURR13(2) WERT7
LZBKZState Central Bank Indicator LZBKZCHAR3Assigned to domainLZBKZ
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
QSFBTWithholding Tax-Exempt Amount (in Document Currency) QSFBTCURR13(2) WERT7
BUALTAmount posted in alternative price control BUALTCURR13(2) WERTV7
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
VNAMEJoint Venture JV_NAMECHAR6Assigned to domainALPHAJV_NAMEJVV
EGRUPEquity group JV_EGROUPCHAR3Assigned to domainALPHAJV_EGROUPGJE
VERTTContract Type RANTYPCHAR1RANTYP
VERTNContract Number RANLCHAR13ALPHARANLRAN
PROJKWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
DMBE2Amount in Second Local Currency GLE_MCA_DTE_DMBE2CURR23(2) WERTV12
DMBE3Amount in Third Local Currency GLE_MCA_DTE_DMBE3CURR23(2) WERTV12
LOKKTAlternative account number in company code ALTKT_SKB1CHAR10Assigned to domainALPHASAKNR
PPRCTPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
FKBERFunctional Area FKBER_SHORTCHAR4FKBER_SHORTFBE
FKBER_LONGFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
AUGGJFiscal Year of Clearing Document AUGGJNUMC4GJAHRGJAHR
PSWSLUpdate Currency for General Ledger Transaction Figures PSWSLCUKY5TCURCWAERS
PSWBTAmount for Updating in General Ledger GLE_MCA_DTE_PSWBTCURR23(2) WERTV12
XAUTOIndicator: Line item automatically created XAUTOCHAR1XFELD
TC_CURKYTransaction Currency GLE_MCA_DTE_FXR_TRNS_CURRENCYCUKY5Assigned to domainWAERS
TC_AMOUNTTransaction Amount GLE_MCA_DTE_TRANSACTION_AMOUNTCURR13(2) WERT7
FCURFunctional Currency GLE_MCA_DTE_FCURCUKY5Assigned to domainWAERS
FCUR_AMTAmount in Functional Currency GLE_MCA_DTE_AMOUNT_FCCURR13(2) WERT7
FCUR_AMT_CALCCalculated Amount in Functional Currency GLE_MCA_DTE_AMOUNT_CALCCURR13(2) WERT7
FCUR_AMT_DIFFAmount Difference GLE_MCA_DTE_AMOUNT_DIFFCURR13(2) WERT7
RATE_TYPEExchange Rate Type KURSTCHAR4Assigned to domainKURSTKUT
RATE_ORIGOriginal Exchange Rate GLE_MCA_DTE_RATE_ORIGDEC28(14) EXCRXGLE_FXR_RATEX28
RATE_CALCExchange Rate GLE_MCA_DTE_N_ERATEDEC28(14) EXCRXGLE_FXR_RATEX28
RATE_DIFFDifference btw. Exchange Rate and Original Exchange Rate GLE_MCA_DTE_RATE_DIFFDEC28(14) EXCRXGLE_FXR_RATEX28
RATE_DIVDeviation in % btw. Exchange Rate and Original Exchange Rate GLE_MCA_DTE_RATE_DIVDEC31(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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!