CDR_C_PACKAGE_U

DDL: CDR_C_PACKAGE_U Type: view_entity

CDS Projection view for Package entity

CDR_C_PACKAGE_U is a CDS View that provides data about "CDS Projection view for Package entity" in SAP S/4HANA. It reads from 1 data source (CDR_I_PACKAGE_U) and exposes 20 fields with key field PackageID.

Data Sources (1)

SourceAliasJoin Type
CDR_I_PACKAGE_U CDR_I_PACKAGE_U projection

Annotations (4)

NameValueLevelField
EndUserText.label CDS Projection view for Package entity view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
Search.searchable true view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PackageID packid Package
PackageName name Zone name
PackageScenario scenario VAT Scenario
PackageType scenario_text
RetentionDays retention_days Retention Days
Active active Usage Active
filesize file_size Size/dim.
char15
char15
int1
char5
CreatedUser crt_usalias
CreationDate crt_date
CreationTime crt_time
RetentionDate retention_date Retention Date
char15
int1
char5
virtualVisibleboolean
ScopeName scope_name Scope Name

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

CREATE VIEW CDR_C_PACKAGE_U AS
SELECT
  packid AS PackageID,
  name AS PackageName,
  scenario AS PackageScenario,
  scenario_text AS PackageType,
  retention_days AS RetentionDays,
  Active,
  file_size AS filesize,
  virtual PackageStatus : abap.char(15) AS char15,
  virtual FprepCriticality : abap.int1 AS int1,
  virtual FprepProgress : abap.char(5) AS char5,
  crt_usalias AS CreatedUser,
  crt_date AS CreationDate,
  crt_time AS CreationTime,
  retention_date AS RetentionDate,
  virtual Visible : boolean AS virtualVisibleboolean,
  scope_name AS ScopeName
FROM CDR_I_PACKAGE_U
;