CDR_I_DETAILS_U

DDL: CDR_I_DETAILS_U SQL: CDR_IDETAILS_U Type: view_entity COMPOSITE Package: S_APS_CDR_MODEL
5 Fields

CDS View for Package Details

CDR_I_DETAILS_U is a Composite CDS View that provides data about "CDS View for Package Details" in SAP S/4HANA. Part of development package S_APS_CDR_MODEL.

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS View for Package Details view
Metadata.allowExtensions true view
VDM.viewType #COMPOSITE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY packid packid Package
KEY ps_posid scope ps_posid WBS Element
scenario _Package scenario VAT Scenario
Descriptionelseendasname
_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_DETAILS_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_IDETAILS_U

CREATE VIEW CDR_I_DETAILS_U AS
SELECT
  packid,
  scope.ps_posid AS ps_posid,
  _Package.scenario AS scenario,
  case _Package.scenario when 'BUS' then _ObjectDescription[ObjectType='APPLCOMP'].Description when 'ARC' then _ObjectDescription[ObjectType='ARC'].Description else '' end as name AS Descriptionelseendasname
;

Learn More