P_Materialledger_Cube_Lit

DDL: P_MATERIALLEDGER_CUBE_LIT Type: view_entity COMPOSITE Package: FINS_ML_VDM
89 Fields 1 Data Sources

Material Ledger Cube for line Items

P_Materialledger_Cube_Lit is a Composite CDS View that provides data about "Material Ledger Cube for line Items" in SAP S/4HANA. It reads from 1 data source (I_Materialledger_Lit) and exposes 89 fields with key fields SourceLedger, CompanyCode, Ledger, GLAccount, FiscalYear. Part of development package FINS_ML_VDM.

Data Sources (1)

SourceAliasJoin Type
I_Materialledger_Lit I_Materialledger_Lit from

Annotations (3)

NameValueLevelField
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (89)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger SourceLedger Source Ledger
KEY CompanyCode CompanyCode Receiver Company Code
KEY Ledger Ledger Ledger
KEY GLAccount GLAccount General Ledger
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY AccountingDocument AccountingDocument Journal Entry
KEY LedgerGLLineItem LedgerGLLineItem Journal Entry Item
KEY Material Material Vehicle Model
KEY CostEstimate CostEstimate Cost EstimateNo
ChartOfAccounts ChartOfAccounts Node Class
AccountingDocumentType AccountingDocumentType Journal Entry Type
ValuationArea ValuationArea Valuation Area
InventoryValuationType InventoryValuationType Valuation Type
FiscalPeriod FiscalPeriod Tax period
LedgerFiscalYear LedgerFiscalYear Ref. Year1
PostingDate PostingDate Posting Date for GR
MatlDocLatestPostgDate MatlDocLatestPostgDate Posting Date
ReferenceDocument ReferenceDocument Reference Document
BusinessTransactionType BusinessTransactionType Bus.transaction
DocumentDate DocumentDate Journal Entry Date
ProfitCenter ProfitCenter Profit Center
CostCenter CostCenter Cost Center
Segment Segment Segment number
AccountingDocCreatedByUser AccountingDocCreatedByUser User which created overhead document
LastChangeDateTime LastChangeDateTime Timestamp
FiscalYearPeriod FiscalYearPeriod Period/Year
ReferenceDocumentType ReferenceDocumentType Reference Document Type
PurchasingDocument PurchasingDocument Purchasing Document
ProductionOrder ProductionOrder Order
TransactionTypeDetermination TransactionTypeDetermination Transaction Key
MaterialGroup
MaterialValuationClass
InventoryValuationCategory
ControllingArea ControllingArea Controlling Area
Plant Plant Valuation Area
MaterialLedgerProcessType MaterialLedgerProcessType Orig. proc.cat.
MaterialLedgerCategory MaterialLedgerCategory Category
IsSupplierStockValuation IsSupplierStockValuation Vendor stk val.
InventorySpecialStockValnType InventorySpecialStockValnType Valuation
InventorySpclStkSalesDocument InventorySpclStkSalesDocument SD Doc of Inv.
InventorySpclStkSalesDocItm InventorySpclStkSalesDocItm SD Item of Inv.
WBSElementInternalID WBSElementInternalID WBS Internal ID
InventorySpecialStockSupplier InventorySpecialStockSupplier Vendor of Inv.
CompanyCodeCurrencyRole CompanyCodeCurrencyRole Field Name
CurrencyRole CurrencyRole Curr./Val. Type
FreeDefinedCurrency1Role FreeDefinedCurrency1Role FreeDef Crcy 1
FreeDefinedCurrency2Role FreeDefinedCurrency2Role FreeDef Crcy 2
FreeDefinedCurrency3Role FreeDefinedCurrency3Role FreeDef Crcy 3
FreeDefinedCurrency4Role FreeDefinedCurrency4Role FreeDef Crcy 4
FreeDefinedCurrency5Role FreeDefinedCurrency5Role FreeDef Crcy 5
FreeDefinedCurrency6Role FreeDefinedCurrency6Role FreeDef Crcy 6
FreeDefinedCurrency7Role FreeDefinedCurrency7Role FreeDef Crcy 7
FreeDefinedCurrency8Role FreeDefinedCurrency8Role FreeDef Crcy 8
CompanyCodeCurrency CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
SlsPriceAmountInCoCodeCrcy SlsPriceAmountInCoCodeCrcy Sales Price Book Value
GroupCurrency GroupCurrency Ledger curr.
AmountInGroupCurrency AmountInGroupCurrency Amnt in GrpCrcy
FreeDefinedCurrency1 FreeDefinedCurrency1 Freely Defined Currency 1
AmountInFreeDefinedCurrency1 AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
FreeDefinedCurrency2 FreeDefinedCurrency2 Freely Defined Currency 2
AmountInFreeDefinedCurrency2 AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
FreeDefinedCurrency3 FreeDefinedCurrency3 Freely Defined Currency 3
AmountInFreeDefinedCurrency3 AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
FreeDefinedCurrency4 FreeDefinedCurrency4 Freely Defined Currency 4
AmountInFreeDefinedCurrency4 AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
FreeDefinedCurrency5 FreeDefinedCurrency5 Freely Defined Currency 5
AmountInFreeDefinedCurrency5 AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
FreeDefinedCurrency6 FreeDefinedCurrency6 Freely Defined Currency 6
AmountInFreeDefinedCurrency6 AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
FreeDefinedCurrency7 FreeDefinedCurrency7 Freely Defined Currency 7
AmountInFreeDefinedCurrency7 AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
FreeDefinedCurrency8 FreeDefinedCurrency8 Freely Defined Currency 8
AmountInFreeDefinedCurrency8 AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
BaseUnit BaseUnit Unit of Measure
InventoryQty InventoryQty
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ChartOfAccounts _ChartOfAccounts
_Segment _Segment
_Material _Material
_CompanyCode _CompanyCode
_Ledger _Ledger
_ProfitCenter _ProfitCenter
_CostCenter _CostCenter
_CompanyCodeCurrency _CompanyCodeCurrency
_CostSourceUnit _CostSourceUnit
_ControllingArea _ControllingArea
_BusinessTransactionType _BusinessTransactionType
_Plant _Plant

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_Materialledger_Cube_Lit.
-- 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.

CREATE VIEW P_Materialledger_Cube_Lit AS
SELECT
  SourceLedger,
  CompanyCode,
  Ledger,
  GLAccount,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Material,
  CostEstimate,
  ChartOfAccounts,
  AccountingDocumentType,
  ValuationArea,
  InventoryValuationType,
  FiscalPeriod,
  LedgerFiscalYear,
  PostingDate,
  MatlDocLatestPostgDate,
  ReferenceDocument,
  BusinessTransactionType,
  DocumentDate,
  ProfitCenter,
  CostCenter,
  Segment,
  AccountingDocCreatedByUser,
  LastChangeDateTime,
  FiscalYearPeriod,
  ReferenceDocumentType,
  PurchasingDocument,
  ProductionOrder,
  TransactionTypeDetermination,
  I_Materialledger_Lit._Material.MaterialGroup AS MaterialGroup,
  I_Materialledger_Lit._MaterialValuation.MaterialValuationClass AS MaterialValuationClass,
  I_Materialledger_Lit._MaterialValuation.InventoryValuationCategory AS InventoryValuationCategory,
  ControllingArea,
  Plant,
  MaterialLedgerProcessType,
  MaterialLedgerCategory,
  IsSupplierStockValuation,
  InventorySpecialStockValnType,
  InventorySpclStkSalesDocument,
  InventorySpclStkSalesDocItm,
  WBSElementInternalID,
  InventorySpecialStockSupplier,
  CompanyCodeCurrencyRole,
  CurrencyRole,
  FreeDefinedCurrency1Role,
  FreeDefinedCurrency2Role,
  FreeDefinedCurrency3Role,
  FreeDefinedCurrency4Role,
  FreeDefinedCurrency5Role,
  FreeDefinedCurrency6Role,
  FreeDefinedCurrency7Role,
  FreeDefinedCurrency8Role,
  CompanyCodeCurrency,
  AmountInCompanyCodeCurrency,
  SlsPriceAmountInCoCodeCrcy,
  GroupCurrency,
  AmountInGroupCurrency,
  FreeDefinedCurrency1,
  AmountInFreeDefinedCurrency1,
  FreeDefinedCurrency2,
  AmountInFreeDefinedCurrency2,
  FreeDefinedCurrency3,
  AmountInFreeDefinedCurrency3,
  FreeDefinedCurrency4,
  AmountInFreeDefinedCurrency4,
  FreeDefinedCurrency5,
  AmountInFreeDefinedCurrency5,
  FreeDefinedCurrency6,
  AmountInFreeDefinedCurrency6,
  FreeDefinedCurrency7,
  AmountInFreeDefinedCurrency7,
  FreeDefinedCurrency8,
  AmountInFreeDefinedCurrency8,
  BaseUnit,
  InventoryQty
FROM I_Materialledger_Lit
;

Learn More