I_ContrVersionedLogPrcDoc

DDL: I_CONTRVERSIONEDLOGPRCDOC SQL: ICONVERLOGPRCDOC Type: view BASIC
17 Fields 1 Data Sources

ACM Versioned Log Pricing Documents

I_ContrVersionedLogPrcDoc (Basic)

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

Sales

I_ContrVersionedLogPrcDoc is a Basic CDS View that provides data about "ACM Versioned Log Pricing Documents" in SAP S/4HANA. It reads from 1 data source (cmm_vlogp) and exposes 17 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AGR-CM
CapabilitiesData Source in SQL Select
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
cmm_vlogp cmm_vlogp from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICONVERLOGPRCDOC view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
EndUserText.label ACM Versioned Log Pricing Documents view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.supportedCapabilities #SQL_DATA_SOURCE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PricingKey pricing_key A key required to access versioned pricing data
KEY Version version Version of an MtM Valuation Record
KEY PricingDocumentItem kposn Condition item number
KEY ConditionType kschl Condition Type
KEY SubConditionType kschl_subkey The key of a sub-condition type
PriceSettingMethod psmethod Price Setting Method
PriceSettingMethodStatus psmstatus Price Setting Method Status
SourceTransacEventEndDateTime valid_to_tst Valid-To Timestamp
ConditionApplication kappl Application
PricingProcedure kalsm Procedure (Pricing, Output Control, Acct. Det., Costing,...)
ConditionTermName termno CPE Term - Number in Formula
DerivativeContractMaturityCode contract_code Contract Maturity Code
CompanyCode bukrs Company Code
Plant werks Receiving Plant
StorageLocation lgort Storage Location
PhysicalCommodity commodity Pricing Commodity
Material matnr Material Number

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_ContrVersionedLogPrcDoc.
-- 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: ICONVERLOGPRCDOC

CREATE VIEW I_ContrVersionedLogPrcDoc AS
SELECT
  pricing_key AS PricingKey,
  Version,
  kposn AS PricingDocumentItem,
  kschl AS ConditionType,
  kschl_subkey AS SubConditionType,
  psmethod AS PriceSettingMethod,
  psmstatus AS PriceSettingMethodStatus,
  valid_to_tst AS SourceTransacEventEndDateTime,
  kappl AS ConditionApplication,
  kalsm AS PricingProcedure,
  termno AS ConditionTermName,
  contract_code AS DerivativeContractMaturityCode,
  bukrs AS CompanyCode,
  werks AS Plant,
  lgort AS StorageLocation,
  commodity AS PhysicalCommodity,
  matnr AS Material
FROM cmm_vlogp
;

Learn More