P_Materialledgercurtp_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 P_Materialledgercurtp_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: PMLCUTPBA

CREATE VIEW P_Materialledgercurtp_Bal AS
SELECT
  it.rbukrs AS rbukrs,
  it.rldnr AS rldnr,
  it.racct AS racct,
  it.gjahr AS gjahr,
  it.belnr AS belnr,
  it.docln AS docln,
  it.matnr AS matnr,
  it.ktopl AS ktopl,
  it.blart AS blart,
  it.bwkey AS bwkey,
  it.bwtar AS bwtar,
  it.poper AS poper,
  it.ryear AS ryear,
  it.budat AS budat,
  it.awref AS awref,
  it.awtyp AS awtyp,
  it.bldat AS bldat,
  it.bttype AS bttype,
  it.prctr AS prctr,
  it.rcntr AS rcntr,
  it.segment AS segment,
  it.usnam AS usnam,
  it.timestamp AS timestamp,
  it.fiscyearper AS fiscyearper,
  it.ebeln AS ebeln,
  it.aufnr AS aufnr,
  it.ktosl AS ktosl,
  _TCURM.bwkrs_cus AS bwkrs_cus,
  it.kokrs AS kokrs,
  it.kalnr AS kalnr,
  it.sobkz AS sobkz,
  it.periv AS periv,
  it.mlptyp AS mlptyp,
  it.mlcateg AS mlcateg,
  it.rhcur AS rhcur,
  case CompanyCodeCurrencyRole when ' ' then cast(0 as fins_vhcur12) else it.hsl end as hsl AS hslendashsl,
  it.hvkwrt AS hvkwrt,
  it.rkcur AS rkcur,
  case GlobalCurrencyRole when ' ' then cast(0 as fins_vkcur12) else it.ksl end as ksl AS kslendasksl,
  it.rocur AS rocur,
  case FreeDefinedCurrency1Role when ' ' then cast(0 as fins_vocur12) else it.osl end as osl AS oslendasosl,
  it.rvcur AS rvcur,
  case FreeDefinedCurrency2Role when ' ' then cast(0 as fins_vvcur12) else it.vsl end as vsl AS vslendasvsl,
  it.rbcur AS rbcur,
  case FreeDefinedCurrency3Role when ' ' then cast(0 as fins_vbcur12) else it.bsl end as bsl AS bslendasbsl,
  it.rccur AS rccur,
  case FreeDefinedCurrency4Role when ' ' then cast(0 as fins_vccur12) else it.csl end as csl AS cslendascsl,
  it.rdcur AS rdcur,
  case FreeDefinedCurrency5Role when ' ' then cast(0 as fins_vdcur12) else it.dsl end as dsl AS dslendasdsl,
  it.recur AS recur,
  case FreeDefinedCurrency6Role when ' ' then cast(0 as fins_vecur12) else it.esl end as esl AS eslendasesl,
  it.rfcur AS rfcur,
  case FreeDefinedCurrency7Role when ' ' then cast(0 as fins_vfcur12) else it.fsl end as fsl AS fslendasfsl,
  it.rgcur AS rgcur,
  case FreeDefinedCurrency8Role when ' ' then cast(0 as fins_vgcur12) else it.gsl end as gsl AS gslendasgsl,
  it.rvunit AS rvunit,
  it.vmsl AS vmsl,
  _curtp.CompanyCodeCurrencyRole AS CurtpH,
  _curtp.GlobalCurrencyRole AS CurtpK,
  _curtp.FreeDefinedCurrency1Role AS CurtpO,
  _curtp.FreeDefinedCurrency2Role AS CurtpV,
  _curtp.FreeDefinedCurrency3Role AS CurtpB,
  _curtp.FreeDefinedCurrency4Role AS CurtpC,
  _curtp.FreeDefinedCurrency5Role AS CurtpD,
  _curtp.FreeDefinedCurrency6Role AS CurtpE,
  _curtp.FreeDefinedCurrency7Role AS CurtpF,
  _curtp.FreeDefinedCurrency8Role AS CurtpG,
  it.xobew AS xobew,
  it.kzbws AS kzbws,
  it.mat_kdauf AS mat_kdauf,
  it.mat_kdpos AS mat_kdpos,
  it.mat_pspnr AS mat_pspnr,
  it.mat_lifnr AS mat_lifnr
FROM P_Acdoca_Cube AS it
INNER JOIN P_MatlLedgerValnCrcyRole AS _curtp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_TCURM AS _TCURM ON _TCURM.bwkrs_cus = '1'  -- association [0..1]
LEFT OUTER JOIN I_MaterialValuation AS _MaterialValuation ON _MaterialValuation.CostEstimate = it.kalnr AND _MaterialValuation.Material = it.matnr AND _MaterialValuation.ValuationArea = it.bwkey  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON it.bttype = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON periv = _FiscalYearVariant.FiscalYearVariant  -- association [1]
;