C_CmmdtyOrdReqDocTypeVH

DDL: C_CMMDTYORDREQDOCTYPEVH SQL: CCMMDTYDOCTYPVH Type: view CONSUMPTION Package: FS_CMM_CDOTE_ORDER_REQUEST
6 Fields 1 Data Sources

Cmmdty Drvtv Document Type

C_CmmdtyOrdReqDocTypeVH is a Consumption CDS View that provides data about "Cmmdty Drvtv Document Type" in SAP S/4HANA. It reads from 1 data source (I_CmmdtyOrdReqDocTypeText) and exposes 6 fields with key fields CmmdtyOrdReqDocApplication, CmmdtyOrdRequestDocumentType. Part of development package FS_CMM_CDOTE_ORDER_REQUEST.

Data Sources (1)

SourceAliasJoin Type
I_CmmdtyOrdReqDocTypeText I_CmmdtyOrdReqDocTypeText from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CCMMDTYDOCTYPVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CmmdtyOrdRequestDocumentType view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Cmmdty Drvtv Document Type view
Search.searchable true view
Consumption.ranked true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CmmdtyOrdReqDocApplication CmmdtyOrdReqDocApplication App System ID
KEY CmmdtyOrdRequestDocumentType CmmdtyOrdRequestDocumentType Document Type
CmmdtyOrdReqDocApplicationText CmmdtyOrdReqDocApplicationText
CmmdtyOrdReqDocumentTypeText CmmdtyOrdReqDocumentTypeText
SemanticObject SemanticObject Semantic Object
SemanticObjectAction SemanticObjectAction Semantic Object Actn

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_CmmdtyOrdReqDocTypeVH.
-- 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: CCMMDTYDOCTYPVH

CREATE VIEW C_CmmdtyOrdReqDocTypeVH AS
SELECT
  CmmdtyOrdReqDocApplication,
  CmmdtyOrdRequestDocumentType,
  CmmdtyOrdReqDocApplicationText,
  CmmdtyOrdReqDocumentTypeText,
  SemanticObject,
  SemanticObjectAction
FROM I_CmmdtyOrdReqDocTypeText
;

Learn More