I_Materialledger_Lit

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 I_Materialledger_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 I_Materialledger_Lit AS
SELECT
  SourceLedger,
  it.rbukrs AS CompanyCode,
  it.rldnr AS Ledger,
  it.racct AS GLAccount,
  it.gjahr AS FiscalYear,
  it.belnr AS AccountingDocument,
  it.docln AS LedgerGLLineItem,
  it.matnr AS Material,
  it.ktopl AS ChartOfAccounts,
  it.blart AS AccountingDocumentType,
  it.bwkey AS ValuationArea,
  it.bwtar AS InventoryValuationType,
  it.poper AS FiscalPeriod,
  it.ryear AS LedgerFiscalYear,
  it.budat AS PostingDate,
  it.budat AS MatlDocLatestPostgDate,
  it.awref AS ReferenceDocument,
  it.awtyp AS ReferenceDocumentType,
  it.bldat AS DocumentDate,
  it.bttype AS BusinessTransactionType,
  it.prctr AS ProfitCenter,
  it.rcntr AS CostCenter,
  it.segment AS Segment,
  it.usnam AS AccountingDocCreatedByUser,
  it.timestamp AS LastChangeDateTime,
  it.fiscyearper AS FiscalYearPeriod,
  it.ebeln AS PurchasingDocument,
  it.aufnr AS ProductionOrder,
  it.ktosl AS TransactionTypeDetermination,
  it.werks AS Plant,
  it.kokrs AS ControllingArea,
  it.kalnr AS CostEstimate,
  it.sobkz AS InvtryValnSpecialStockType,
  it.mlptyp AS MaterialLedgerProcessType,
  it.mlcateg AS MaterialLedgerCategory,
  periv AS FiscalYearVariant,
  it.rhcur AS CompanyCodeCurrency,
  it.hsl AS AmountInCompanyCodeCurrency,
  it.hvkwrt AS SlsPriceAmountInCoCodeCrcy,
  it.rkcur AS GroupCurrency,
  it.ksl AS AmountInGroupCurrency,
  it.rocur AS FreeDefinedCurrency1,
  it.osl AS AmountInFreeDefinedCurrency1,
  it.rvcur AS FreeDefinedCurrency2,
  it.vsl AS AmountInFreeDefinedCurrency2,
  it.rbcur AS FreeDefinedCurrency3,
  it.bsl AS AmountInFreeDefinedCurrency3,
  it.rccur AS FreeDefinedCurrency4,
  it.csl AS AmountInFreeDefinedCurrency4,
  it.rdcur AS FreeDefinedCurrency5,
  it.dsl AS AmountInFreeDefinedCurrency5,
  it.recur AS FreeDefinedCurrency6,
  it.esl AS AmountInFreeDefinedCurrency6,
  it.rfcur AS FreeDefinedCurrency7,
  it.fsl AS AmountInFreeDefinedCurrency7,
  it.rgcur AS FreeDefinedCurrency8,
  it.gsl AS AmountInFreeDefinedCurrency8,
  it.rvunit AS BaseUnit,
  cast(it.vmsl as fcml_lbkum preserving type ) AS InventoryQty,
  it.CurtpH AS CompanyCodeCurrencyRole,
  it.CurtpK AS CurrencyRole,
  it.CurtpO AS FreeDefinedCurrency1Role,
  it.CurtpV AS FreeDefinedCurrency2Role,
  it.CurtpB AS FreeDefinedCurrency3Role,
  it.CurtpC AS FreeDefinedCurrency4Role,
  it.CurtpD AS FreeDefinedCurrency5Role,
  it.CurtpE AS FreeDefinedCurrency6Role,
  it.CurtpF AS FreeDefinedCurrency7Role,
  it.CurtpG AS FreeDefinedCurrency8Role,
  it.xobew AS IsSupplierStockValuation,
  it.kzbws AS InventorySpecialStockValnType,
  it.mat_kdauf AS InventorySpclStkSalesDocument,
  it.mat_kdpos AS InventorySpclStkSalesDocItm,
  it.mat_pspnr AS WBSElementInternalID,
  it.mat_lifnr AS InventorySpecialStockSupplier
FROM P_Materialledger_Curtp_Lit AS it
;