C_PurgMasterConditionTypeVH

DDL: C_PURGMASTERCONDITIONTYPEVH SQL: CNDTYPEVH Type: view CONSUMPTION Package: ODATA_MM_OA_MAINTAIN
9 Fields 1 Data Sources

Value Help for Condition Types

C_PurgMasterConditionTypeVH is a Consumption CDS View that provides data about "Value Help for Condition Types" in SAP S/4HANA. It reads from 1 data source (I_PricingConditionType) and exposes 9 fields with key fields ConditionApplication, ConditionType. Part of development package ODATA_MM_OA_MAINTAIN.

Data Sources (1)

SourceAliasJoin Type
I_PricingConditionType PricingConditionType from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CNDTYPEVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
ObjectModel.semanticKey ConditionType view
ObjectModel.representativeKey ConditionType view
EndUserText.label Value Help for Condition Types view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConditionApplication I_PricingConditionType ConditionApplication Application
KEY ConditionType I_PricingConditionType ConditionType Condition type
ConditionTypeName
_ConditionApplication I_PricingConditionType _ConditionApplication
PurchasingOrganization
Supplier
PurchasingDocumentType
SuperordinateDocumentItem
PurchasingDocument

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_PurgMasterConditionTypeVH.
-- 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: CNDTYPEVH

CREATE VIEW C_PurgMasterConditionTypeVH AS
SELECT
  PricingConditionType.ConditionApplication AS ConditionApplication,
  PricingConditionType.ConditionType AS ConditionType,
  PricingConditionType._Text[ 1: Language = $session.system_language ].ConditionTypeName AS ConditionTypeName,
  PricingConditionType._ConditionApplication AS _ConditionApplication,
  cast('' as ekorg ) AS PurchasingOrganization,
  cast('' as lifnr ) AS Supplier,
  cast('' as bsart ) AS PurchasingDocumentType,
  cast('' as abap.char ( 70 )) AS SuperordinateDocumentItem,
  cast('' as abap.char ( 10 )) AS PurchasingDocument
FROM I_PricingConditionType AS PricingConditionType
;

Learn More