P_MaterialLedgerRDPer
P_MaterialLedgerRDPer is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_ML_Balance) and exposes 92 fields with key fields CompanyCode, Ledger, GLAccount, FiscalYear, AccountingDocument.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_ML_Balance | P_ML_Balance | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_ReportingPeriod | fis_period_select |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PMLRDPER | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view |
Fields (92)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | it | CompanyCode | Receiver Company Code |
| KEY | Ledger | it | Ledger | Ledger |
| KEY | GLAccount | it | GLAccount | General Ledger |
| KEY | FiscalYear | it | FiscalYear | G/L Fiscal Year |
| KEY | AccountingDocument | it | AccountingDocument | Journal Entry |
| KEY | LedgerGLLineItem | it | LedgerGLLineItem | Journal Entry Item |
| KEY | Product | it | Product | Product Sold |
| Material | it | Material | Vehicle Model | |
| CostEstimate | it | CostEstimate | Cost EstimateNo | |
| ChartOfAccounts | it | ChartOfAccounts | Node Class | |
| AccountingDocumentType | it | AccountingDocumentType | Journal Entry Type | |
| ValuationArea | it | ValuationArea | Valuation Area | |
| InventoryValuationType | it | InventoryValuationType | Valuation Type | |
| FiscalPeriod | it | FiscalPeriod | Tax period | |
| LedgerFiscalYear | it | LedgerFiscalYear | ||
| PostingDate | it | PostingDate | Posting Date for GR | |
| MatlDocLatestPostgDate | it | MatlDocLatestPostgDate | ||
| ReferenceDocument | it | ReferenceDocument | Reference Document | |
| BusinessTransactionType | it | BusinessTransactionType | Bus.transaction | |
| DocumentDate | it | DocumentDate | Journal Entry Date | |
| ProfitCenter | it | ProfitCenter | Profit Center | |
| CostCenter | it | CostCenter | Cost Center | |
| Segment | it | Segment | Segment number | |
| AccountingDocCreatedByUser | it | AccountingDocCreatedByUser | User which created overhead document | |
| LastChangeDateTime | it | LastChangeDateTime | Timestamp | |
| FiscalYearPeriod | it | FiscalYearPeriod | Period/Year | |
| FiscalYearVariant | it | FiscalYearVariant | FY Variant | |
| ReferenceDocumentType | it | ReferenceDocumentType | Reference Document Type | |
| PurchasingDocument | it | PurchasingDocument | Purchasing Document | |
| ProductionOrder | it | ProductionOrder | Order | |
| TransactionTypeDetermination | it | TransactionTypeDetermination | Transaction Key | |
| MaterialGroup | it | MaterialGroup | Product Group | |
| ProductGroup | it | ProductGroup | Product Sold Group | |
| MaterialValuationClass | it | MaterialValuationClass | Valuation Class | |
| InventoryValuationCategory | it | InventoryValuationCategory | ||
| ControllingArea | it | ControllingArea | Controlling Area | |
| Plant | it | Plant | Valuation Area | |
| MaterialLedgerProcessType | it | MaterialLedgerProcessType | ||
| MaterialLedgerCategory | it | MaterialLedgerCategory | ||
| IsSupplierStockValuation | it | IsSupplierStockValuation | ||
| InventorySpclStkSalesDocument | it | InventorySpclStkSalesDocument | ||
| InventorySpclStkSalesDocItm | it | InventorySpclStkSalesDocItm | ||
| InvtrySpclStockWBSElmntIntID | it | InvtrySpclStockWBSElmntIntID | ||
| InventorySpecialStockSupplier | it | InventorySpecialStockSupplier | ||
| InventorySpecialStockValnType | it | InventorySpecialStockValnType | Valuation | |
| CompanyCodeCurrencyRole | it | CompanyCodeCurrencyRole | ||
| GlobalCurrencyRole | it | GlobalCurrencyRole | ||
| FreeDefinedCurrency1Role | it | FreeDefinedCurrency1Role | ||
| FreeDefinedCurrency2Role | it | FreeDefinedCurrency2Role | ||
| FreeDefinedCurrency3Role | it | FreeDefinedCurrency3Role | ||
| FreeDefinedCurrency4Role | it | FreeDefinedCurrency4Role | ||
| FreeDefinedCurrency5Role | it | FreeDefinedCurrency5Role | ||
| FreeDefinedCurrency6Role | it | FreeDefinedCurrency6Role | ||
| FreeDefinedCurrency7Role | it | FreeDefinedCurrency7Role | ||
| FreeDefinedCurrency8Role | it | FreeDefinedCurrency8Role | ||
| CurrentFiscalPeriodendasToFiscalPeriod | ||||
| CompanyCodeCurrency | it | CompanyCodeCurrency | Local Currency | |
| AmountInCompanyCodeCurrency | it | AmountInCompanyCodeCurrency | Local Crcy Amt | |
| SlsPriceAmountInCoCodeCrcy | it | SlsPriceAmountInCoCodeCrcy | Sales Price Book Value | |
| GroupCurrency | it | GroupCurrency | Ledger curr. | |
| AmountInGroupCurrency | it | AmountInGroupCurrency | Amnt in GrpCrcy | |
| FreeDefinedCurrency1 | it | FreeDefinedCurrency1 | Freely Defined Currency 1 | |
| AmountInFreeDefinedCurrency1 | it | AmountInFreeDefinedCurrency1 | Amount in Freely Defined Currency 1 | |
| FreeDefinedCurrency2 | it | FreeDefinedCurrency2 | Freely Defined Currency 2 | |
| AmountInFreeDefinedCurrency2 | it | AmountInFreeDefinedCurrency2 | Amount in Freely Defined Currency 2 | |
| FreeDefinedCurrency3 | it | FreeDefinedCurrency3 | Freely Defined Currency 3 | |
| AmountInFreeDefinedCurrency3 | it | AmountInFreeDefinedCurrency3 | Amount in Freely Defined Currency 3 | |
| FreeDefinedCurrency4 | it | FreeDefinedCurrency4 | Freely Defined Currency 4 | |
| AmountInFreeDefinedCurrency4 | it | AmountInFreeDefinedCurrency4 | Amount in Freely Defined Currency 4 | |
| FreeDefinedCurrency5 | it | FreeDefinedCurrency5 | Freely Defined Currency 5 | |
| AmountInFreeDefinedCurrency5 | it | AmountInFreeDefinedCurrency5 | Amount in Freely Defined Currency 5 | |
| FreeDefinedCurrency6 | it | FreeDefinedCurrency6 | Freely Defined Currency 6 | |
| AmountInFreeDefinedCurrency6 | it | AmountInFreeDefinedCurrency6 | Amount in Freely Defined Currency 6 | |
| FreeDefinedCurrency7 | it | FreeDefinedCurrency7 | Freely Defined Currency 7 | |
| AmountInFreeDefinedCurrency7 | it | AmountInFreeDefinedCurrency7 | Amount in Freely Defined Currency 7 | |
| FreeDefinedCurrency8 | it | FreeDefinedCurrency8 | Freely Defined Currency 8 | |
| AmountInFreeDefinedCurrency8 | it | AmountInFreeDefinedCurrency8 | Amount in Freely Defined Currency 8 | |
| BaseUnit | it | BaseUnit | Unit of Measure | |
| CostSourceUnit | it | CostSourceUnit | ||
| InventoryQty | it | InventoryQty | ||
| _GLAccountInChartOfAccounts | it | _GLAccountInChartOfAccounts | ||
| _ChartOfAccounts | it | _ChartOfAccounts | ||
| _Segment | it | _Segment | ||
| _Material | it | _Material | ||
| _Ledger | it | _Ledger | ||
| _CompanyCode | it | _CompanyCode | ||
| _ProfitCenter | it | _ProfitCenter | ||
| _CostCenter | it | _CostCenter | ||
| _CompanyCodeCurrency | it | _CompanyCodeCurrency | ||
| _CostSourceUnit | it | _CostSourceUnit | ||
| _ControllingArea | it | _ControllingArea | ||
| _BusinessTransactionType | it | _BusinessTransactionType |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view P_MaterialLedgerRDPer.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PMLRDPER
-- Parameters: P_ReportingPeriod : fis_period_select
CREATE VIEW P_MaterialLedgerRDPer AS
SELECT
it.CompanyCode AS CompanyCode,
it.Ledger AS Ledger,
it.GLAccount AS GLAccount,
it.FiscalYear AS FiscalYear,
it.AccountingDocument AS AccountingDocument,
it.LedgerGLLineItem AS LedgerGLLineItem,
it.Product AS Product,
it.Material AS Material,
it.CostEstimate AS CostEstimate,
it.ChartOfAccounts AS ChartOfAccounts,
it.AccountingDocumentType AS AccountingDocumentType,
it.ValuationArea AS ValuationArea,
it.InventoryValuationType AS InventoryValuationType,
it.FiscalPeriod AS FiscalPeriod,
it.LedgerFiscalYear AS LedgerFiscalYear,
it.PostingDate AS PostingDate,
it.MatlDocLatestPostgDate AS MatlDocLatestPostgDate,
it.ReferenceDocument AS ReferenceDocument,
it.BusinessTransactionType AS BusinessTransactionType,
it.DocumentDate AS DocumentDate,
it.ProfitCenter AS ProfitCenter,
it.CostCenter AS CostCenter,
it.Segment AS Segment,
it.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
it.LastChangeDateTime AS LastChangeDateTime,
it.FiscalYearPeriod AS FiscalYearPeriod,
it.FiscalYearVariant AS FiscalYearVariant,
it.ReferenceDocumentType AS ReferenceDocumentType,
it.PurchasingDocument AS PurchasingDocument,
it.ProductionOrder AS ProductionOrder,
it.TransactionTypeDetermination AS TransactionTypeDetermination,
it.MaterialGroup AS MaterialGroup,
it.ProductGroup AS ProductGroup,
it.MaterialValuationClass AS MaterialValuationClass,
it.InventoryValuationCategory AS InventoryValuationCategory,
it.ControllingArea AS ControllingArea,
it.Plant AS Plant,
it.MaterialLedgerProcessType AS MaterialLedgerProcessType,
it.MaterialLedgerCategory AS MaterialLedgerCategory,
it.IsSupplierStockValuation AS IsSupplierStockValuation,
it.InventorySpclStkSalesDocument AS InventorySpclStkSalesDocument,
it.InventorySpclStkSalesDocItm AS InventorySpclStkSalesDocItm,
it.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
it.InventorySpecialStockSupplier AS InventorySpecialStockSupplier,
it.InventorySpecialStockValnType AS InventorySpecialStockValnType,
it.CompanyCodeCurrencyRole AS CompanyCodeCurrencyRole,
it.GlobalCurrencyRole AS GlobalCurrencyRole,
it.FreeDefinedCurrency1Role AS FreeDefinedCurrency1Role,
it.FreeDefinedCurrency2Role AS FreeDefinedCurrency2Role,
it.FreeDefinedCurrency3Role AS FreeDefinedCurrency3Role,
it.FreeDefinedCurrency4Role AS FreeDefinedCurrency4Role,
it.FreeDefinedCurrency5Role AS FreeDefinedCurrency5Role,
it.FreeDefinedCurrency6Role AS FreeDefinedCurrency6Role,
it.FreeDefinedCurrency7Role AS FreeDefinedCurrency7Role,
it.FreeDefinedCurrency8Role AS FreeDefinedCurrency8Role,
case $parameters.P_ReportingPeriod when 'P' then marvld.PreviousFiscalPeriod else marvld.CurrentFiscalPeriod end as ToFiscalPeriod AS CurrentFiscalPeriodendasToFiscalPeriod,
it.CompanyCodeCurrency AS CompanyCodeCurrency,
it.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
it.SlsPriceAmountInCoCodeCrcy AS SlsPriceAmountInCoCodeCrcy,
it.GroupCurrency AS GroupCurrency,
it.AmountInGroupCurrency AS AmountInGroupCurrency,
it.FreeDefinedCurrency1 AS FreeDefinedCurrency1,
it.AmountInFreeDefinedCurrency1 AS AmountInFreeDefinedCurrency1,
it.FreeDefinedCurrency2 AS FreeDefinedCurrency2,
it.AmountInFreeDefinedCurrency2 AS AmountInFreeDefinedCurrency2,
it.FreeDefinedCurrency3 AS FreeDefinedCurrency3,
it.AmountInFreeDefinedCurrency3 AS AmountInFreeDefinedCurrency3,
it.FreeDefinedCurrency4 AS FreeDefinedCurrency4,
it.AmountInFreeDefinedCurrency4 AS AmountInFreeDefinedCurrency4,
it.FreeDefinedCurrency5 AS FreeDefinedCurrency5,
it.AmountInFreeDefinedCurrency5 AS AmountInFreeDefinedCurrency5,
it.FreeDefinedCurrency6 AS FreeDefinedCurrency6,
it.AmountInFreeDefinedCurrency6 AS AmountInFreeDefinedCurrency6,
it.FreeDefinedCurrency7 AS FreeDefinedCurrency7,
it.AmountInFreeDefinedCurrency7 AS AmountInFreeDefinedCurrency7,
it.FreeDefinedCurrency8 AS FreeDefinedCurrency8,
it.AmountInFreeDefinedCurrency8 AS AmountInFreeDefinedCurrency8,
it.BaseUnit AS BaseUnit,
it.CostSourceUnit AS CostSourceUnit,
it.InventoryQty AS InventoryQty,
it._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
it._ChartOfAccounts AS _ChartOfAccounts,
it._Segment AS _Segment,
it._Material AS _Material,
it._Ledger AS _Ledger,
it._CompanyCode AS _CompanyCode,
it._ProfitCenter AS _ProfitCenter,
it._CostCenter AS _CostCenter,
it._CompanyCodeCurrency AS _CompanyCodeCurrency,
it._CostSourceUnit AS _CostSourceUnit,
it._ControllingArea AS _ControllingArea,
it._BusinessTransactionType AS _BusinessTransactionType
FROM P_ML_Balance
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA