I_MaintenancePackageText

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_MaintenancePackageText.
-- 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: IMNTPCKGTXT

CREATE VIEW I_MaintenancePackageText AS
SELECT
  spras AS Language,
  strat AS MaintenanceStrategy,
  paket AS MaintenancePackage,
  ktex1 AS MaintenancePackageText,
  ktxhi AS MaintPackageHierarchyShortText,
  kzyk1 AS MaintenanceCycleShortText,
  koff1 AS StartOffsetShortText
FROM t351x
LEFT OUTER JOIN I_MaintenanceStrategy AS _MaintenanceStrategy ON _MaintenanceStrategy.MaintenanceStrategy = MaintenanceStrategy  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePackage AS _MaintenancePackage ON _MaintenancePackage.MaintenanceStrategy = MaintenanceStrategy AND _MaintenancePackage.MaintenancePackage = MaintenancePackage  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
;