Mmim_MatDocFlowIssuingStatus

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 Mmim_MatDocFlowIssuingStatus.
-- 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: MMIMMDOCFLWSTAIP

CREATE VIEW Mmim_MatDocFlowIssuingStatus AS
SELECT
  concat(MaterialDocument,cast(cast(MaterialDocumentItem as abap.int2) as char10 ) ) AS MaterialDocument,
  MaterialDocumentYear,
  MaterialDocumentItem,
  cast('01' as char4) AS Status,
  case when DebitCreditCode = 'S' then concat_with_space(_IssuingOrReceivingPlant.PlantName, IssuingOrReceivingPlant, 1) else concat_with_space(_Plant.PlantName, Plant, 1) end as Plant AS PlantNamePlant1endasPlant
FROM I_MaterialDocumentRecord
;