CIC_CONDITIONS_PRICES

DDL: CIC_CONDITIONS_PRICES Type: view_entity
7 Fields 1 Data Sources

Proj.on Prices(Industry Cloud Solutions)

CIC_CONDITIONS_PRICES is a CDS View that provides data about "Proj.on Prices(Industry Cloud Solutions)" in SAP S/4HANA. It reads from 1 data source (konp) and exposes 7 fields with key fields ConditionNumber, Sequence.

Data Sources (1)

SourceAliasJoin Type
konp konp from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Proj.on Prices(Industry Cloud Solutions) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ConditionNumber knumh NoCondRec.Batch
KEY Sequence kopos SequNo of Cond.
Application kappl Application
ConditionType kschl Tax Item Type
ConditionRateValue kbetr Tax Rate
Currency konwa Cond. Currency
Deleted loevm_ko Deletion Indic.

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 CIC_CONDITIONS_PRICES.
-- 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.

CREATE VIEW CIC_CONDITIONS_PRICES AS
SELECT
  knumh AS ConditionNumber,
  kopos AS Sequence,
  kappl AS Application,
  kschl AS ConditionType,
  kbetr AS ConditionRateValue,
  konwa AS Currency,
  loevm_ko AS Deleted
FROM konp
;

Learn More