CDR_I_PACKAGE_FILES_U

DDL: CDR_I_PACKAGE_FILES_U SQL: CDR_IPACKFILES_U Type: view_entity COMPOSITE
15 Fields 1 Data Sources

files information for package level

CDR_I_PACKAGE_FILES_U is a Composite CDS View that provides data about "files information for package level" in SAP S/4HANA. It reads from 1 data source (cdr_file) and exposes 15 fields with key fields packid, appl_comp, tabname, file_seqno.

Data Sources (1)

SourceAliasJoin Type
cdr_file cdr_file from

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label files information for package level view
Metadata.allowExtensions true view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY packid packid Package
KEY appl_comp appl_comp Application Comp.
KEY tabname tabname Table/Constant Value
KEY file_seqno file_seqno File Sequence
filename filename URL or Filenam Path
failed failed Failed
in_process in_process Boolean Variable (X = True, - = False, Space = Unknown)
dwn_finish dwn_finish Boolean Variable (X = True, - = False, Space = Unknown)
del_finish del_finish Boolean Variable (X = True, - = False, Space = Unknown)
dwn_user dwn_user User Name
dwn_end_date
dwn_end_time
del_user del_user User Name
lognumber lognumber UUID
_Package _Package

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_FILES_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_IPACKFILES_U

CREATE VIEW CDR_I_PACKAGE_FILES_U AS
SELECT
  packid,
  appl_comp,
  tabname,
  file_seqno,
  filename,
  failed,
  in_process,
  dwn_finish,
  del_finish,
  dwn_user,
  tstmp_to_dats( dwn_tmstmp_end, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS dwn_end_date,
  tstmp_to_dats( dwn_tmstmp_end, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) AS dwn_end_time,
  del_user,
  lognumber
FROM cdr_file
;

Learn More