I_MLBasic_Bal

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_MLBasic_Bal.
-- 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: IMLBASICBLA

CREATE VIEW I_MLBasic_Bal AS
SELECT
  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.bttype AS BusinessTransactionType,
  _BusinessTransactionType._Text[1:Language = $session.system_language].BusinessTransactionTypeName AS BusinessTransactionTypeName,
  it.bldat AS DocumentDate,
  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,
  _Material._MaterialGroup.MaterialGroup AS MaterialGroup,
  _MaterialValuation.MaterialValuationClass AS MaterialValuationClass,
  _MaterialValuation.InventoryValuationCategory AS InventoryValuationCategory,
  it.hsl AS AmountInCompanyCodeCurrency,
  it.hvkwrt AS SlsPriceAmountInCoCodeCrcy,
  it.rkcur AS GroupCurrency,
  it.ksl AS AmountInGroupCurrency,
  it.rocur AS FreeDefinedCurrency1,
  cast(it.osl as fis_osl) AS AmountInFreeDefinedCurrency1,
  it.rvcur AS FreeDefinedCurrency2,
  cast( it.vsl as fis_vsl) AS AmountInFreeDefinedCurrency2,
  it.rbcur AS FreeDefinedCurrency3,
  cast( it.bsl as fis_bsl) AS AmountInFreeDefinedCurrency3,
  it.rccur AS FreeDefinedCurrency4,
  cast( it.csl as fis_csl) AS AmountInFreeDefinedCurrency4,
  it.rdcur AS FreeDefinedCurrency5,
  cast( it.dsl as fis_dsl) AS AmountInFreeDefinedCurrency5,
  it.recur AS FreeDefinedCurrency6,
  cast( it.esl as fis_esl) AS AmountInFreeDefinedCurrency6,
  it.rfcur AS FreeDefinedCurrency7,
  cast( it.fsl as fis_fsl) AS AmountInFreeDefinedCurrency7,
  it.rgcur AS FreeDefinedCurrency8,
  cast( it.gsl as fis_gsl) AS AmountInFreeDefinedCurrency8,
  it.rvunit AS BaseUnit,
  cast(it.vmsl as fcml_lbkum) 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_Materialledgercurtp_Bal AS it
;