I_ACMVersionedLogisticDocument

DDL: I_ACMVERSIONEDLOGISTICDOCUMENT SQL: IACMVLOGP Type: view BASIC
41 Fields 1 Data Sources

Versioned pricing data of logistic docs

I_ACMVersionedLogisticDocument is a Basic CDS View that provides data about "Versioned pricing data of logistic docs" in SAP S/4HANA. It reads from 1 data source (cmm_vlogp) and exposes 41 fields with key fields PricingKey, ACMPricingVersion, PricingDocumentItem, ConditionType, SubConditionType.

Data Sources (1)

SourceAliasJoin Type
cmm_vlogp cmm_vlogp from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IACMVLOGP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Versioned pricing data of logistic docs view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY PricingKey pricing_key Pricing Key
KEY ACMPricingVersion version XML Vers.
KEY PricingDocumentItem kposn Number
KEY ConditionType kschl Tax Item Type
KEY SubConditionType kschl_subkey Subkey
MTMDataSourceType record_type Type of Data Record
SourceDocument document Sales Document
DocumentCurrency waerk Doc. Currency
Material matnr Vehicle Model
StorageLocation lgort Sublocation
OriginReferenceDocument root_doc Root Document
OriginReferenceDocumentItem root_doc_itm Root Document Item
DeliveryPeriodStartDate period_start_mkt Delivery Per. Start
DeliveryPeriodEndDate period_end_mkt Delivery Period End
ConditionTermRate termrate Term Rate
ConditionTermRateCurrency termcurr Term Currency
MaturityKeyDate keydate Maturity Key Date
QuotationKeyType quotkey Quotation Key
BasisType basis_type Basis Type
ConditionTermRateFixation fixation_id Term Number
ConditionTermRateIsFixed fixed Single-Character Flag
MTMConditionGroupCategory cgroup_cat Category
PricingStatus fixgroup_status Price Fix. Status
ImplicitFixationIsRelevant implicit_fixation_rel Imp Fix Relevant
CommodityUnit commodity_uom Unit of Measure
CmmdtyPriceExpsrQtyInMassUnit commodity_mass_adj Quantity in Mass UoM
CmmdtyPriceExpsrMassUnit risk_mass_uom Mass UoM
CmmdtyPriceExpsrQtyInVolUnit commodity_volume_adj Quantity in Vol UoM
CmmdtyPriceExpsrVolumeUnit risk_volume_uom Volume UoM
ACMConditionTermNumber termno_l Term Number
MTMAdjustmentType adjustment_type Adjustment Type
ConditionTermRateNmrtr factor_num Rate factor num
ConditionTermRateDnmntr factor_denom Rate factor denom
ConditionTermFactorNumerator termfactor_combrout_num Term factor num
ConditionTermFactorDenominator termfactor_combrout_deno Term factor deno
TargetConversionFactor fx_fix_factor_to_term_to_doc Fxd Term To-Fct Conv
SourceConversionFactor fx_fix_factor_from_term_to_doc Fixed Frm-Fctr Conv.
ConditionTermExtensionUsage term_extension_usage Extension Usage
CalculationGroup calc_group Calc.Group
ValidFromDateTime valid_from_tst Valid-From Tstmp
ValidToDateTime valid_to_tst Valid-To Tstmp

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_ACMVersionedLogisticDocument.
-- 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: IACMVLOGP

CREATE VIEW I_ACMVersionedLogisticDocument AS
SELECT
  pricing_key AS PricingKey,
  version AS ACMPricingVersion,
  kposn AS PricingDocumentItem,
  kschl AS ConditionType,
  kschl_subkey AS SubConditionType,
  record_type AS MTMDataSourceType,
  document AS SourceDocument,
  waerk AS DocumentCurrency,
  matnr AS Material,
  lgort AS StorageLocation,
  root_doc AS OriginReferenceDocument,
  root_doc_itm AS OriginReferenceDocumentItem,
  period_start_mkt AS DeliveryPeriodStartDate,
  period_end_mkt AS DeliveryPeriodEndDate,
  termrate AS ConditionTermRate,
  termcurr AS ConditionTermRateCurrency,
  keydate AS MaturityKeyDate,
  quotkey AS QuotationKeyType,
  basis_type AS BasisType,
  fixation_id AS ConditionTermRateFixation,
  fixed AS ConditionTermRateIsFixed,
  cgroup_cat AS MTMConditionGroupCategory,
  fixgroup_status AS PricingStatus,
  implicit_fixation_rel AS ImplicitFixationIsRelevant,
  commodity_uom AS CommodityUnit,
  commodity_mass_adj AS CmmdtyPriceExpsrQtyInMassUnit,
  risk_mass_uom AS CmmdtyPriceExpsrMassUnit,
  commodity_volume_adj AS CmmdtyPriceExpsrQtyInVolUnit,
  risk_volume_uom AS CmmdtyPriceExpsrVolumeUnit,
  termno_l AS ACMConditionTermNumber,
  adjustment_type AS MTMAdjustmentType,
  factor_num AS ConditionTermRateNmrtr,
  factor_denom AS ConditionTermRateDnmntr,
  termfactor_combrout_num AS ConditionTermFactorNumerator,
  termfactor_combrout_deno AS ConditionTermFactorDenominator,
  fx_fix_factor_to_term_to_doc AS TargetConversionFactor,
  fx_fix_factor_from_term_to_doc AS SourceConversionFactor,
  term_extension_usage AS ConditionTermExtensionUsage,
  calc_group AS CalculationGroup,
  valid_from_tst AS ValidFromDateTime,
  valid_to_tst AS ValidToDateTime
FROM cmm_vlogp
;

Learn More