CDR_I_PACKAGE_U

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 CDR_I_PACKAGE_U.
-- 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: CDR_IPACK_U

CREATE VIEW CDR_I_PACKAGE_U AS
SELECT
  Package.packid AS packid,
  Package.name AS name,
  Package.status AS status,
  Package.scenario AS scenario,
  Package.crt_user AS crt_user,
  tstmp_to_dats( crt_timestamp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS crt_date,
  tstmp_to_tims( crt_timestamp, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS crt_time,
  Package.file_exist AS file_exist,
  Package.lognumber AS lognumber,
  Package.basepack AS basepack,
  Package.active AS active,
  Package.file_size AS file_size,
  Package.scope_name AS scope_name,
  Package.crt_usalias AS crt_usalias
FROM cdr_pack_r AS Package
LEFT OUTER JOIN CDR_I_DOM_DESCR_U AS _DomainDescr ON _DomainDescr.domname = 'CDR_SCENARIO' AND _DomainDescr.domvalue_l = scenario  -- association [1]
LEFT OUTER JOIN CDR_I_SCOPE_MAIN_U AS _ScopeMain ON _ScopeMain.ScopeName = scope_name  -- association [1]
LEFT OUTER JOIN CDR_I_DETAILS_U AS _PackageDetails ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN CDR_I_PACKAGE_FILES_U AS _PackageFiles ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN CDR_I_FILE_ARC_U AS _PackageArcFiles ON /* condition not available in parsed metadata */  -- association [0..*]
;