P_Materialledger_CurTP

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_CurTP.
-- 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: PMATLEDGERCURTP

CREATE VIEW P_Materialledger_CurTP 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,
  it.werks AS werks,
  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.bstat AS bstat,
  it.rhcur AS rhcur,
  it.hsl AS hsl,
  it.rkcur AS rkcur,
  case Curtpk when ' ' then cast(0 as fins_vkcur12) else it.ksl end as ksl AS kslendasksl,
  it.rocur AS rocur,
  case Curtpo when ' ' then cast(0 as fins_vocur12) else it.osl end as osl AS oslendasosl,
  it.rvcur AS rvcur,
  case Curtpv when ' ' then cast(0 as fins_vocur12) else it.vsl end as vsl AS vslendasvsl,
  it.rvunit AS rvunit,
  it.vmsl AS vmsl,
  _curtp.Curtph AS CurtpH,
  _curtp.rldnrh AS rldnrh,
  _curtp.ext_CurtpH AS ext_CurtpH,
  _curtp.Curtpk AS CurtpK,
  _curtp.rldnrk AS rldnrk,
  _curtp.ext_CurtpK AS ext_CurtpK,
  _curtp.Curtpo AS CurtpO,
  _curtp.rldnro AS rldnro,
  _curtp.ext_CurtpO AS ext_CurtpO,
  _curtp.Curtpv AS CurtpV,
  _curtp.rldnrv AS rldnrv,
  _curtp.ext_Curtpv AS ext_CurtpV,
  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_Materialledger_Relvt_Curtp AS _curtp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialValuation AS _MaterialValuation ON it.kalnr = _MaterialValuation.CostEstimate  -- association [0..1]
LEFT OUTER JOIN I_BusinessTransactionType AS _BusinessTransactionType ON it.bttype = _BusinessTransactionType.BusinessTransactionType  -- association [0..1]
;