R_DngrsGdsLogsPackgInstrnTP

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 R_DngrsGdsLogsPackgInstrnTP.
-- 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.

CREATE VIEW R_DngrsGdsLogsPackgInstrnTP AS
SELECT
  DngrsGdsLogsPackgInstrnUUID,
  ChmlCmplncInfoUUID,
  ChmlCmplncInfoType,
  PackingInstructionSystemUUID,
  PackingInstructionItemSystUUID,
  Product,
  LoadCarrier,
  cast( _ChmlCmplncInfo.Specification as ehfnd_vdm_cci_internal_nr preserving type ) AS ChemicalComplianceInfo,
  cast( _ChmlCmplncInfo.Specification as ehfnd_vdm_cci_internal_nr preserving type ) AS UnpckgdChemicalComplianceInfo,
  cast ( _PackingInstructionHeader.PackingInstructionNumber as pl_piid preserving type ) AS PackingInstructionNumber,
  _ChmlCmplncInfo.ChmlCmplncInternalName AS ChmlCmplncInternalName,
  _ChmlCmplncInfo.DngrsGdsRespUnit AS DngrsGdsRespUnit,
  CreationUTCDateTime,
  CreatedByUser,
  LastChangeUTCDateTime,
  LastChangedByUser
FROM I_DngrsGdsLogsPackgInstrn
LEFT OUTER JOIN I_OTRText AS _OnlineTextRep ON _OnlineTextRep.OnlnTxtRpstryConceptID = '005056AB02261ED28EC06CFA8B8A15FF' AND _OnlineTextRep.Language = $session.system_language  -- association [0..1]
;