GLE_MCA_BALANCES - MCA Balances
MCA Balances information is stored in SAP table GLE_MCA_BALANCES.
It is part of development package FAGL_MCA_PER_GEN in software component FI-GL-CU-MCA. This development package consists of objects that can be grouped under "FI: MCA General Functions - Persistency".
It is part of development package FAGL_MCA_PER_GEN in software component FI-GL-CU-MCA. This development package consists of objects that can be grouped under "FI: MCA General Functions - Persistency".
Fields for table GLE_MCA_BALANCES
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 6 | T000 |
ITEM_ID | MCA Delta Item GUID | X | GLE_MCA_DTE_UUID | RAW | 16 | |
RUNID | MCA Run ID | X | GLE_MCA_DTE_RUNID | NUMC | 24 | |
PP_OBJNO | Object Number | X | GLE_MCA_DTE_PP_OBJNO | CHAR | 80 | |
.INCLUDE | BUSKEY | GLE_MCA_STR_BALANCES_BKEY | 0 | |||
TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 8 | ||
PRCCAT | Process Category | GLE_MCA_DTE_PRC_CAT | CHAR | 12 | ||
MCAKEY | MCA Key | GLE_DTE_MCA_MCAKEY | CHAR | 10 | * | |
PRCTYPE | Process Type | GLE_MCA_DTE_PRC_TYPE | CHAR | 20 | ||
POSTYPE | MCA Position Type | GLE_MCA_DTE_POS_TYPE | CHAR | 20 | ||
BUKRS | Company Code | BUKRS | CHAR | 8 | ||
BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
MONAT | Fiscal period | MONAT | NUMC | 4 | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 8 | ||
RLDNR | Ledger in General Ledger Accounting | FINS_LEDGER | CHAR | 4 | * | |
LDGRP | Ledger Group | FAGL_LDGRP | CHAR | 8 | * | |
BELNR | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
AGGVAR_SRC | Aggregation Variant Source | GLE_MCA_DTE_AGG_VARIANT_SRC | CHAR | 8 | * | |
AGGVAR_TGT | Aggregation Variant Target | GLE_MCA_DTE_AGG_VARIANT_TGT | CHAR | 8 | * | |
FIXVALVAR_SRC | Fixed Values Variant | GLE_MCA_DTE_FIXVAL_VARIANT_SRC | CHAR | 8 | ||
FIXVALVAR_TGT | Fixed Values Variant | GLE_MCA_DTE_FIXVAL_VARIANT_TGT | CHAR | 8 | ||
BSTAT | Document Status | BSTAT_D | CHAR | 2 | ||
.INCLUDE | GLE_MCA_STR_BALANCES_ACC | 0 | ||||
BLART | Document Type | BLART | CHAR | 4 | * | |
RASSC | Company ID of Trading Partner | RASSC | CHAR | 12 | * | |
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 20 | * | |
PSEGMENT | Partner Segment for Segmental Reporting | FB_PSEGMENT | CHAR | 20 | * | |
RCNTR | Cost Center | KOSTL | CHAR | 20 | * | |
PRCTR | Profit Center | PRCTR | CHAR | 20 | ||
PPRCTR | Partner Profit Center | PPRCTR | CHAR | 20 | * | |
HKONT | General Ledger Account | HKONT | CHAR | 20 | * | |
RACCT | Account Number | RACCT | CHAR | 20 | * | |
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 20 | ||
DRCRK | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
KOART | Account type | KOART | CHAR | 2 | ||
KUNNR | Customer Number | KUNNR | CHAR | 20 | ||
LIFNR | Account Number of Supplier | LIFNR | CHAR | 20 | ||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 24 | * | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 8 | * | |
SBUSA | Trading partner's business area | PARGB | CHAR | 8 | * | |
RBUSA | Business Area | GSBER | CHAR | 8 | * | |
XOPVW | Indicator: Open Item Management? | XOPVW | CHAR | 2 | ||
.INCLUDE | GLE_MCA_STR_POSTLINE_CURRKEYS | 0 | ||||
RWCUR | Transaction Currency | FINS_CURRW | CUKY | 10 | * | |
RHCUR | Company Code Currency | FINS_CURRH | CUKY | 10 | * | |
RKCUR | Global Currency | FINS_CURRK | CUKY | 10 | * | |
ROCUR | Freely Defined Currency 1 | FINS_CURR1 | CUKY | 10 | * | |
RVCUR | Freely Defined Currency 2 | FINS_CURR2 | CUKY | 10 | * | |
RBCUR | Freely Defined Currency 3 | FINS_CURR3 | CUKY | 10 | * | |
RCCUR | Freely Defined Currency 4 | FINS_CURR4 | CUKY | 10 | * | |
RDCUR | Freely Defined Currency 5 | FINS_CURR5 | CUKY | 10 | * | |
RECUR | Freely Defined Currency 6 | FINS_CURR6 | CUKY | 10 | * | |
RFCUR | Freely Defined Currency 7 | FINS_CURR7 | CUKY | 10 | * | |
RGCUR | Freely Defined Currency 8 | FINS_CURR8 | CUKY | 10 | * | |
RTCUR | Balance Transaction Currency | FINS_CURRT | CUKY | 10 | * | |
MTCUR | Balance Transaction Currency | FINS_CURRT | CUKY | 10 | * | |
.INCLUDE | GLE_MCA_STR_POSTLINE_AMOUNTS | 0 | ||||
TSL | Amount in Transaction Currency | FINS_VWCUR12 | CURR | 12 | ||
WSL | Amount in Transaction Currency | FINS_VWCUR12 | CURR | 12 | ||
HSL | Amount in Company Code Currency | FINS_VHCUR12 | CURR | 12 | ||
KSL | Amount in Global Currency | FINS_VKCUR12 | CURR | 12 | ||
OSL | Amount in Freely Defined Currency 1 | FINS_VOCUR12 | CURR | 12 | ||
VSL | Amount in Freely Defined Currency 2 | FINS_VVCUR12 | CURR | 12 | ||
BSL | Amount in Freely Defined Currency 3 | FINS_VBCUR12 | CURR | 12 | ||
CSL | Amount in Freely Defined Currency 4 | FINS_VCCUR12 | CURR | 12 | ||
DSL | Amount in Freely Defined Currency 5 | FINS_VDCUR12 | CURR | 12 | ||
ESL | Amount in Freely Defined Currency 6 | FINS_VECUR12 | CURR | 12 | ||
FSL | Amount in Freely Defined Currency 7 | FINS_VFCUR12 | CURR | 12 | ||
GSL | Amount in Freely Defined Currency 8 | FINS_VGCUR12 | CURR | 12 | ||
.INCLUDE | CI_COBL | 0 | ||||
.INCLUDE | AFX_STATUS_DATA_EXT | 0 | ||||
ARCHIVE_STATUS | Archiving Status | TYP_ARCHIVE_STATUS | CHAR | 2 | ||
ARCHIVE_FLUD | Resubmission Date | TYP_ARCHIVE_FLUD | DATS | 16 | ||
REJECTION | Rejection Reason | TYP_REJECTION | CHAR | 4 | ||
COUNT_AGG | Accounting Document Line Item Number | POSNR_ACC | NUMC | 20 | ||
BKTXT | Document Header Text | BKTXT | CHAR | 50 | ||
DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | CHAR | 12 | ||
EPRCTR | Partner profit center for elimination of internal business | EPRCTR | CHAR | 20 | ||
FISCYEARPER | Period/Year | JAHRPER | NUMC | 14 | ||
GLACCOUNT_TYPE | Type of a General Ledger Account | GLACCOUNT_TYPE | CHAR | 2 | ||
KOKRS | Controlling Area | KOKRS | CHAR | 8 | ||
KTOP2 | Alternative Chart of Accounts | KTOP2 | CHAR | 8 | ||
KTOPL | Chart of Accounts | KTOPL | CHAR | 8 | ||
LOKKT | Account Number in the Local Chart of Accounts | LOKKT | CHAR | 20 | ||
PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | ||
POPER | Posting period | POPER | NUMC | 6 | ||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 16 | ||
RFAREA | Functional Area | FKBER | CHAR | 32 | ||
RMVCT | Transaction type | RMVCT | CHAR | 6 | ||
SCNTR | Sender cost center | SKOST | CHAR | 20 | ||
SFAREA | Partner Functional Area | SFKBER | CHAR | 32 | ||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 4 | ||
SGTXT | Item Text | SGTXT | CHAR | 100 | ||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 32 | ||
AUFNR | Order Number | AUFNR | CHAR | 24 | ||
AWORG | Reference Organizational Units | AWORG | CHAR | 20 | ||
AWORG_REV | Reversal: Reference Organizations of Document to Be Reversed | AWORG_REV | CHAR | 20 | ||
AWREF | Reference document number | AWREF | CHAR | 20 | ||
AWREF_REV | Reversal: Reference Document No. of Document to Be Reversed | AWREF_REV | CHAR | 20 | ||
WWERT | Translation date | WWERT_D | DATS | 16 | ||
KURSX | Market Data Exchange Rate | GLE_FXR_DTE_RATEX28 | DEC | 15 | ||
KUR2X | Market Data Exchange Rate 2 | GLE_FXR_DTE_RATE2X28 | DEC | 15 | ||
KUR3X | Market Data Exchange Rate 3 | GLE_FXR_DTE_RATE3X28 | DEC | 15 | ||
KURSF | Exchange rate | KURSF | DEC | 5 | ||
KURS2 | Exchange Rate for the Second Local Currency | KURS2 | DEC | 5 | ||
KURS3 | Exchange Rate for the Third Local Currency | KURS3 | DEC | 5 |