P_Materialledger_Curtp_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 P_Materialledger_Curtp_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.
-- SQL view name: PMALCURTPLIT

CREATE VIEW P_Materialledger_Curtp_Lit AS
SELECT
  it.rldnr_pers AS SourceLedger,
  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.aworg AS aworg,
  it.awsys AS awsys,
  it.awtyp AS awtyp,
  it.drcrk AS drcrk,
  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.vprsv AS MaterialPriceControl,
  it.rhcur AS rhcur,
  case _curtp.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 _curtp.GlobalCurrencyRole when ' ' then cast(0 as fins_vkcur12) else it.ksl end as ksl AS kslendasksl,
  it.rocur AS rocur,
  case _curtp.FreeDefinedCurrency1Role when ' ' then cast(0 as fins_vocur12) else it.osl end as osl AS oslendasosl,
  it.rvcur AS rvcur,
  case _curtp.FreeDefinedCurrency2Role when ' ' then cast(0 as fins_vvcur12) else it.vsl end as vsl AS vslendasvsl,
  it.rbcur AS rbcur,
  case _curtp.FreeDefinedCurrency3Role when ' ' then cast(0 as fins_vbcur12) else it.bsl end as bsl AS bslendasbsl,
  it.rccur AS rccur,
  case _curtp.FreeDefinedCurrency4Role when ' ' then cast(0 as fins_vccur12) else it.csl end as csl AS cslendascsl,
  it.rdcur AS rdcur,
  case _curtp.FreeDefinedCurrency5Role when ' ' then cast(0 as fins_vdcur12) else it.dsl end as dsl AS dslendasdsl,
  it.recur AS recur,
  case _curtp.FreeDefinedCurrency6Role when ' ' then cast(0 as fins_vecur12) else it.esl end as esl AS eslendasesl,
  it.rfcur AS rfcur,
  case _curtp.FreeDefinedCurrency7Role when ' ' then cast(0 as fins_vfcur12) else it.fsl end as fsl AS fslendasfsl,
  it.rgcur AS rgcur,
  case _curtp.FreeDefinedCurrency8Role when ' ' then cast(0 as fins_vgcur12) else it.gsl end as gsl AS gslendasgsl,
  it.runit AS runit,
  it.msl AS msl,
  it.mfsl AS mfsl,
  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,
  it._GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts,
  it._ChartOfAccounts AS _ChartOfAccounts,
  it._Segment AS _Segment,
  it._Material AS _Material,
  it._CompanyCode AS _CompanyCode,
  it._ProfitCenter AS _ProfitCenter,
  it._CostCenter AS _CostCenter,
  it._CompanyCodeCurrency AS _CompanyCodeCurrency,
  it._GlobalCurrency AS _GlobalCurrency,
  it._FreeDefinedCurrency1 AS _FreeDefinedCurrency1,
  it._FreeDefinedCurrency2 AS _FreeDefinedCurrency2,
  it._CostSourceUnit AS _CostSourceUnit,
  it._ControllingArea AS _ControllingArea,
  it._Ledger AS _Ledger,
  it._FiscalYear AS _FiscalYear,
  it._FiscalYearVariant AS _FiscalYearVariant,
  it._JournalEntry AS _JournalEntry,
  it._Plant AS _Plant
FROM P_AcdocAUnionD_Cube AS it
INNER JOIN P_MatlLedgerValnCrcyRole 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]
;