FAC_AUDIT_Z3_MATERIAL_ITEM

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 FAC_AUDIT_Z3_MATERIAL_ITEM.
-- 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: FAC_AUDMATITM
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_AUDIT_Z3_MATERIAL_ITEM AS
SELECT
  SourceLedger,
  FAC_AUDIT_Z3_MATERIAL_ITEM_B.CompanyCode AS CompanyCode,
  FAC_AUDIT_Z3_MATERIAL_ITEM_B.Ledger AS Ledger,
  GLAccount,
  FiscalYear,
  AccountingDocument,
  LedgerGLLineItem,
  Material,
  MaterialDocument,
  MaterialDocumentYear,
  _MaterialDocumentHeader.InventoryTransactionType AS InventoryTransactionType,
  FiscalPeriod,
  AccountingDocumentType,
  _mkpf.blaum AS DocumentTypeofRevaluationDoc,
  PostingDate,
  DocumentDate,
  _bkpf.bktxt AS AccountingDocumentHeaderText,
  ReferenceDocument,
  _bkpf.waers AS Currency,
  _bkpf.frath AS UnplannedDeliveryCosts,
  _bkpf.awsys AS LogicalSystem,
  _bkpf.awkey AS ObjectKey,
  _bkpf.cpudt AS AccountingDocumentCreationDate,
  ReferenceDocumentType,
  _mkpf.exnum AS ForeignTradeNumber,
  AccountingDocCreatedByUser,
  _mseg.zeile AS zeile,
  _mseg.bwart AS bwart,
  _GoodsMovementTypeT.GoodsMovementTypeName AS GoodsMovementTypeName,
  _mseg.werks AS werks,
  _mseg.lgort AS lgort,
  _mseg.charg AS charg,
  _mseg.ebeln AS ebeln,
  _mseg.ebelp AS ebelp,
  _mseg.shkzg AS shkzg,
  _mseg.dmbtr AS dmbtr,
  _mseg.meins AS meins,
  _mseg.menge AS menge,
  _mseg.bwtar AS bwtar,
  _mseg.sakto AS sakto,
  _mseg.lifnr AS lifnr,
  _mseg.kunnr AS kunnr,
  _mseg.gsber AS gsber,
  _mseg.anln1 AS anln1,
  _mseg.anln2 AS anln2,
  _mseg.aufnr AS aufnr,
  _mseg.emlif AS emlif,
  _mseg.fkber AS fkber,
  _mseg.grund AS grund,
  _mseg.kdauf AS kdauf,
  _mseg.kdein AS kdein,
  _mseg.kdpos AS kdpos,
  _mseg.kokrs AS kokrs,
  _mseg.kostl AS kostl,
  _mseg.kzbew AS kzbew,
  _mseg.nplnr AS nplnr,
  _mseg.parbu AS parbu,
  _mseg.pargb AS pargb,
  _mseg.pprctr AS pprctr,
  _mseg.prctr AS prctr,
  _mseg.projn AS projn,
  _mseg.ps_psp_pnr AS ps_psp_pnr,
  _mseg.sgtxt AS sgtxt,
  _mseg.shkum AS shkum,
  _mseg.sobkz AS sobkz,
  _mseg.ummat AS ummat,
  _mseg.umwrk AS umwrk,
  _mseg.vptnr AS vptnr,
  _mseg.waers AS waers,
  _mseg.weunb AS weunb,
  _mseg.xruej AS xruej,
  _mseg.xruem AS xruem,
  _mseg.bnbtr AS bnbtr,
  _mseg.dmbum AS dmbum,
  _mseg.lbkum AS lbkum,
  _mseg.salk3 AS salk3,
  _mseg.kzzug AS kzzug,
  _mseg.kzvbr AS kzvbr,
  _mseg.erfmg AS erfmg,
  _mseg.erfme AS erfme,
  _ekko.bsart AS bsart,
  _ekko.ekgrp AS ekgrp,
  _ekko.ekorg AS ekorg,
  _ekko.bedat AS bedat,
  _ekko.inco1 AS inco1,
  _ekko.inco2 AS inco2,
  _ekko.reswk AS reswk,
  _ekko.lblif AS lblif,
  _ekko.lifre AS lifre,
  _ekko.konnr AS konnr,
  _ekko.logsy AS logsy,
  _ekko.kalsm AS kalsm,
  _ekko.aedat AS aedat,
  _ekko.ernam AS ernam,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  ValuationArea,
  _mseg.vprsv AS vprsv,
  _text.ddtext AS vprsvText
FROM FAC_AUDIT_Z3_MATERIAL_ITEM_B
INNER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN nsdm_e_MKPF AS _mkpf ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN nsdm_e_mseg AS _mseg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ekko AS _ekko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_GoodsMovementTypeT AS _GoodsMovementTypeT ON _GoodsMovementTypeT.GoodsMovementType = _mseg.bwart AND _GoodsMovementTypeT.Language = $parameters.P_Language  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN dd07t AS _text ON _text.domname = _mseg.vprsv AND _text.as4local = 'A' AND _text.ddlanguage = $parameters.P_Language  -- association [0..1]
;