C_UsgeDescCodeVH

DDL: C_USGEDESCCODEVH SQL: CUSGEDESCCODEVH Type: view CONSUMPTION Package: ODATA_QM_INSPLOT
9 Fields

Usage Decision Code Value Help

C_UsgeDescCodeVH is a Consumption CDS View that provides data about "Usage Decision Code Value Help" in SAP S/4HANA. Part of development package ODATA_QM_INSPLOT.

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CUSGEDESCCODEVH view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Usage Decision Code Value Help view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
Search.searchable true view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspLotUsgeDcsnCodes InspectionLot Inspection Lot
KEY UsageDecisionCode I_InspLotUsgeDcsnCodes UsageDecisionCode
KEY UsageDecisionCodeGroup I_InspLotUsgeDcsnCodes UsageDecisionCodeGroup
KEY SelectedCodeSet I_InspLotUsgeDcsnCodes SelectedCodeSet CodeGrp/SelSet
KEY SelectedCodeSetPlant I_InspLotUsgeDcsnCodes SelectedCodeSetPlant
UsageDecisionCodeText _UsageDecisionCode UsageDecisionCodeText
Plant I_InspLotUsgeDcsnCodes Plant Valuation Area
InspectionLotType I_InspLotUsgeDcsnCodes InspectionLotType Inspection Type
MatlQualityAuthorizationGroup I_InspLotUsgeDcsnCodes MatlQualityAuthorizationGroup QM Matl Auth.

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 C_UsgeDescCodeVH.
-- 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: CUSGEDESCCODEVH

CREATE VIEW C_UsgeDescCodeVH AS
SELECT
  I_InspLotUsgeDcsnCodes.InspectionLot AS InspectionLot,
  I_InspLotUsgeDcsnCodes.UsageDecisionCode AS UsageDecisionCode,
  I_InspLotUsgeDcsnCodes.UsageDecisionCodeGroup AS UsageDecisionCodeGroup,
  I_InspLotUsgeDcsnCodes.SelectedCodeSet AS SelectedCodeSet,
  I_InspLotUsgeDcsnCodes.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _UsageDecisionCode.UsageDecisionCodeText AS UsageDecisionCodeText,
  I_InspLotUsgeDcsnCodes.Plant AS Plant,
  I_InspLotUsgeDcsnCodes.InspectionLotType AS InspectionLotType,
  I_InspLotUsgeDcsnCodes.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup
;

Learn More