R_MANAGEJOURNALENTRYLEDGERVIEW
Journal Entry Ledger View
R_MANAGEJOURNALENTRYLEDGERVIEW is a CDS View in S/4HANA. Journal Entry Ledger View. It contains 13 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ManageJournalEntryLedgerView | view_entity | from | CONSUMPTION | Journal Entry Item with Ledger |
| C_MngJournalEntryTotalAmount | view_entity | from | CONSUMPTION | Journal Entry Total Amount |
| C_MngJrnlEntrPrdtnLedgerView | view_entity | from | CONSUMPTION | Predictive Journal Entry Item |
| C_MngJrnlEntrSpcfcLedgerView | view_entity | from | CONSUMPTION | Journal Entry Specific Document Item |
| C_SmltdJrnlEntrLedgerView | view_entity | from | CONSUMPTION | Simulated Journal Entry GL Item |
Fields (13)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| AmountInBalanceTransacCrcy | AmountInBalanceTransacCrcy | 4 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 4 | |
| AmountInFreeDefinedCurrency1 | AmountInFreeDefinedCurrency1 | 4 | |
| AmountInFreeDefinedCurrency2 | AmountInFreeDefinedCurrency2 | 4 | |
| AmountInFreeDefinedCurrency3 | AmountInFreeDefinedCurrency3 | 4 | |
| AmountInFreeDefinedCurrency4 | AmountInFreeDefinedCurrency4 | 4 | |
| AmountInFreeDefinedCurrency5 | AmountInFreeDefinedCurrency5 | 4 | |
| AmountInFreeDefinedCurrency6 | AmountInFreeDefinedCurrency6 | 4 | |
| AmountInFreeDefinedCurrency7 | AmountInFreeDefinedCurrency7 | 4 | |
| AmountInFreeDefinedCurrency8 | AmountInFreeDefinedCurrency8 | 4 | |
| AmountInFunctionalCurrency | AmountInFunctionalCurrency | 4 | |
| AmountInGlobalCurrency | AmountInGlobalCurrency | 4 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 4 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Journal Entry Ledger View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_MANAGEJOURNALENTRYLEDGERVIEW (
AMOUNTINBALANCETRANSACCRCY,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINFREEDEFINEDCURRENCY1,
AMOUNTINFREEDEFINEDCURRENCY2,
AMOUNTINFREEDEFINEDCURRENCY3,
AMOUNTINFREEDEFINEDCURRENCY4,
AMOUNTINFREEDEFINEDCURRENCY5,
AMOUNTINFREEDEFINEDCURRENCY6,
AMOUNTINFREEDEFINEDCURRENCY7,
AMOUNTINFREEDEFINEDCURRENCY8,
AMOUNTINFUNCTIONALCURRENCY,
AMOUNTINGLOBALCURRENCY,
AMOUNTINTRANSACTIONCURRENCY
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA