I_UsageDecisionCode

DDL: I_USAGEDECISIONCODE SQL: IUSGDECCODE Type: view BASIC
9 Fields 1 Data Sources 2 Associations

Usage Decision Code

I_UsageDecisionCode (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_UsageDecisionCode is a Basic CDS View (Dimension) that provides data about "Usage Decision Code" in SAP S/4HANA. It reads from 1 data source (qpcd) and exposes 9 fields with key fields UsageDecisionCodeGroup, UsageDecisionCode. It has 2 associations to related views.

SAP API Hub

StateC1
Line of BusinessManufacturing
Application ComponentQM-IM
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageManufacturing for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides access to the usage decision codes (catalog 3).</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
qpcd qpcd from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UsageDecisionCodeGroup _UsageDecisionCodeGroup $projection.UsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup
[0..*] I_UsageDecisionCodeText _Text $projection.UsageDecisionCodeGroup = _Text.UsageDecisionCodeGroup and $projection.UsageDecisionCode = _Text.UsageDecisionCode

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IUSGDECCODE view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Usage Decision Code view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey UsageDecisionCode view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
Metadata.ignorePropagatedAnnotations true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY UsageDecisionCodeGroup qpcd codegruppe Code Group
KEY UsageDecisionCode qpcd code Water Hazard Cl.
UsageDecisionCodeText Text for Code
UsgeDcsnCodeCreatedBy qpcd ersteller Name of User Who Created the Data Record
UsgeDcsnCodeCreatedOn qpcd e_datum System Date on Which Data Record Was Created
UsgeDcsnCodeLastChangedBy qpcd aenderer Name of User Who Last Changed Data Record
UsgeDcsnCodeLastChangedOn qpcd a_datum System Date on Which Data Record Was Changed
_UsageDecisionCodeGroup _UsageDecisionCodeGroup
_Text _Text

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_UsageDecisionCode.
-- 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: IUSGDECCODE

CREATE VIEW I_UsageDecisionCode AS
SELECT
  qpcd.codegruppe AS UsageDecisionCodeGroup,
  qpcd.code AS UsageDecisionCode,
  _Text[1:Language = $session.system_language].UsageDecisionCodeText AS UsageDecisionCodeText,
  qpcd.ersteller AS UsgeDcsnCodeCreatedBy,
  qpcd.e_datum AS UsgeDcsnCodeCreatedOn,
  qpcd.aenderer AS UsgeDcsnCodeLastChangedBy,
  qpcd.a_datum AS UsgeDcsnCodeLastChangedOn
FROM qpcd
LEFT OUTER JOIN I_UsageDecisionCodeGroup AS _UsageDecisionCodeGroup ON UsageDecisionCodeGroup = _UsageDecisionCodeGroup.UsageDecisionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_UsageDecisionCodeText AS _Text ON UsageDecisionCodeGroup = _Text.UsageDecisionCodeGroup AND UsageDecisionCode = _Text.UsageDecisionCode  -- association [0..*]
;

Learn More