I_IN_MatlDocList

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_IN_MatlDocList.
-- 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: INMATLDOCLIST

CREATE VIEW I_IN_MatlDocList AS
SELECT
  cast(mjahr as nsdm_mjahr preserving type) AS MaterialDocumentYear,
  mblnr AS MaterialDocument,
  cast(zeile as nsdm_mblpo preserving type) AS MaterialDocumentItem,
  werks AS Plant,
  matnr AS Material,
  lgort AS StorageLocation,
  lifnr AS Supplier,
  bwart AS GoodsMovementType,
  erfmg AS QuantityInEntryUnit,
  erfme AS EntryUnit,
  cast(sjahr as nsdm_sjahr preserving type) AS ReversedMaterialDocumentYear,
  cast(smbln as nsdm_smbln preserving type) AS ReversedMaterialDocument,
  cast(smblp as nsdm_smblp preserving type) AS ReversedMaterialDocumentItem,
  xwsbr AS RvslOfGoodsReceiptIsAllowed,
  cast(reversal_movement as nsdm_xstbw preserving type) AS IsReversalMovementType,
  cancelled AS GoodsMovementIsCancelled,
  cancellation_type AS GoodsMovementCancellationType,
  wempf AS GoodsRecipientName,
  ablad AS UnloadingPointName,
  kostl AS CostCenter,
  sakto AS GLAccount,
  kstrg AS CostObject,
  cast(paobjnr as nsdm_rkeobjnr) AS ProfitabilitySegment,
  prctr AS ProfitCenter,
  kalnr AS CostEstimate,
  xblnr AS ReferenceDocument,
  ServicePerformer,
  pernr AS EmploymentInternalID,
  cast(knttp_gr as nsdm_knttp preserving type) AS AccountAssignmentCategory,
  work_item_id AS WorkItem,
  fbuda AS ServicesRenderedDate,
  bukrs AS CompanyCode,
  gsber AS BusinessArea,
  budat AS PostingDate,
  dmbtr AS TotalGoodsMvtAmtInCCCrcy,
  dmbtr_stock AS GoodsMovementStkAmtInCCCrcy,
  dmbtr_cons AS GoodsMvtCnsmpnAmtInCCCrcy,
  cast(waers as nsdm_comp_code_currency preserving type) AS CompanyCodeCurrency,
  cast(xauto as nsdm_xauto preserving type) AS IsAutomaticallyCreated,
  usnam AS UserName
FROM matdoc
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
;