I_VersionedLogcDocument

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_VersionedLogcDocument.
-- 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: IVERSLOGDOC

CREATE VIEW I_VersionedLogcDocument AS
SELECT
  pricing_key AS PricingKey,
  Version,
  kposn AS PricingDocumentItem,
  kschl AS ConditionType,
  kschl_subkey AS SubConditionType,
  record_type AS MTMDataSourceType,
  valid_from_date AS ValidityStartDate,
  valid_to_date AS ValidityEndDate,
  valid_from_time AS ValidityStartTime,
  valid_to_time AS ValidityEndTime,
  valid_from_tst AS SourceTransactionEventDateTime,
  valid_to_tst AS SourceTransacEventEndDateTime,
  entity_key AS EndOfDayBusinessEntityKey,
  entity_key_mkt AS MarketNormBusinessEntityKey,
  period_start_mkt AS DeliveryPeriodStartDate,
  period_end_mkt AS DeliveryPeriodEndDate,
  entity_key_sprd AS SpreadBusinessEntityKey,
  version_max AS MaximumVersion,
  previous_version AS PreviousVersion,
  previous_subkey AS PrevVersionSubConditionType,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  lifnr AS Creditor,
  kunnr AS SoldToParty,
  matnr AS Material,
  commodity AS PhysicalCommodity,
  werks AS Plant,
  lgort AS StorageLocation,
  charg AS Batch,
  inco1 AS IncotermsClassification,
  inco2 AS IncotermsTransferLocation,
  kappl AS ConditionApplication,
  document_char10 AS SourceDocumentShortNumber,
  document AS SourceDocument,
  document_type AS SourceDocumentBusObjType,
  root_doc_char10 AS OrignRefDocumentShortNumber,
  root_doc AS OriginReferenceDocument,
  root_doc_itm AS OriginReferenceDocumentItem,
  root_doc_type AS OriginReferenceDocBusObjType,
  predecessor_doc AS ReferenceDocument,
  predecessor_doc_itm AS ReferenceDocumentItem,
  predecessor_doc_type AS ReferenceDocBusObjType,
  document_item AS SourceDocumentItem,
  date_delivery AS DeliveryDate,
  date_pymnt AS ExpectedPaymentDate,
  stwae AS StatisticsCurrency,
  waerk AS DocumentCurrency,
  prctr AS ProfitCenter,
  gsber AS BusinessArea,
  ekorg AS PurchasingOrganization,
  matkl AS MaterialGroup,
  inter_company AS IsIntercompanyTransfer,
  kbetr AS ConditionRateAmount,
  waers AS ConditionCurrency,
  kpein AS ConditionQuantity,
  kmein AS ConditionQuantityUnit,
  termrate AS ConditionTermRate,
  termcurr AS ConditionTermRateCurrency,
  termval AS ConditionTermValue,
  termcurr AS ConditionTermValueCurrency,
  termcurr_m AS ConditionTermRateMktCurrency,
  termtext AS ConditionTermName,
  termstatus AS ConditionTermStatus,
  numdec_rate AS RoundingDecimalPlaces,
  round_rate AS ConditionTermRateIsRounded,
  factor_num AS ConditionTermRateNmrtr,
  factor_denom AS ConditionTermRateDnmntr,
  term_extension_usage AS ConditionTermExtensionUsage,
  timing AS CmmdtyForwardIndexTiming,
  dcs_selection_type AS MaturitySelectionType,
  date_reference AS QuotationPeriodReferenceDate,
  curve AS CommodityCurve,
  latest_evaluation_date AS CmmdtyLtstEvaluationKeyDate,
  quot_timeseries_key AS QuotationDateList,
  futures_ref_timeseries AS FutureRefQuotationDateList,
  quotperiod_end AS QuotationPeriodEndDate,
  MIC etc. dcsid as DerivativeContrSpecification AS dcsidasDerivativeContrSpecification,
  mic AS MarketIdentifierCode,
  futures_ref_mic AS FutureRefMarketIdentifierCode,
  keydate AS MaturityKeyDate,
  contract_code AS DerivativeContractMaturityCode,
  basis_id AS BasisID,
  basis_type AS BasisType,
  quotgroup AS QuotationGroup,
  quotgroup_op AS QuotationGroupCalculationRule,
  fixation_id AS ConditionTermRateFixation,
  fixgroup_status AS PricingStatus,
  rate_fix_date AS CndnTermRateFixationDate,
  rate_fix_time AS CndnTermRateFixationTime,
  fx_fix_date AS CndnTermExchRateFixationDate,
  fx_fix_time AS CndnTermExchRateFixationTime,
  date_fwd_fx_freeze AS FixedExchRateDate,
  fx_exch_rate_maturity_date AS ExchRateMaturityDate,
  instrument AS MarketDataAccessKey,
  calcmin AS MinimumConditionTermLimitRate,
  calcmax AS MaximumConditionTermLimitRate,
  calcmmcurr AS ConditionTermLimitRateCurrency,
  calcmmprun AS ConditionTermLimitRateQuantity,
  calcmmuom AS CndnTermLimitRateQuantityUnit,
  commodity_uom AS CommodityUnit,
  signage_qty AS QuantitySign,
  cgroup_cat AS MTMConditionGroupCategory,
  cgroup AS MTMConditionGroup,
  calc_group AS MTMCalculationGroup,
  adjustment_type AS MTMAdjustmentType,
  kschl_m AS MTMCalcGrpMarketPriceCondition,
  fixed AS ConditionTermRateIsFixed,
  fixed_fx AS ConditionTermExchRateIsFixed,
  realized AS PriceIsRealized,
  bp_eval_period AS PnLEvaluationPeriod,
  previous_fixed AS PrevVersCndnTermRateIsFixed,
  previous_fixed_fx AS PrevVersCndnTrmExchRateIsFixed,
  previous_commodity_adj AS PrevVersionCommodityQuantity,
  previous_signage_qty AS PreviousVersionQuantitySign,
  previous_termrate AS PrevVersionConditionTermRate,
  previous_termcurr AS PrevVersCndnTermRateCurrency,
  previous_waerk AS PrevVersionDocumentCurrency,
  previous_md_factor_from AS PrevVersMktToDocSrceCnvrsnFctr,
  previous_md_factor_to AS PrevVersMktDocTgtCnvrsnFctr,
  previous_ds_factor_from AS PrevVersDocStstcSrceCnvrsnFctr,
  previous_ds_factor_to AS PrevVersDocStstcTgtCnvrsnFctr,
  previous_termval AS PrevVersionConditionTermValue,
  previous_comm_adj_in_termuom AS ComparativeCmmdtyQtyInTermUnit,
  previous_fixgroup_status AS ComparativePricingStatus,
  sfhaart AS FinancialInstrTransactionType,
  kontrh AS BusinessPartner,
  ranl AS SecurityClass,
  astueck AS NumberOfCommodityContracts,
  posacc AS TreasuryPositionAccount,
  rantyp AS TreasuryContractType,
  sshlng AS TreasuryPositionLongShortCode,
  bp_eval_prd_start AS ReferenceEvaluationKeyDate,
  keydate_selection_rout AS MaturitySelectionRoutine,
  fixgroup_status AS CommodityPriceFixationStatus,
  tenor AS TimeToMaturity,
  executed AS ContrPriceExposureIsExecuted,
  dcs_reporting_date AS DCSReportingDate,
  implicit_fixation_rel AS ImplicitFixationIsRelevant,
  risk_mass_uom AS CmmdtyPriceExpsrMassUnit,
  commodity_volume_adj AS CmmdtyPriceExpsrQtyInVolUnit,
  risk_volume_uom AS CmmdtyPriceExpsrVolumeUnit,
  termfactor_combrout_num AS ConditionTermFactorNumerator,
  termfactor_combrout_deno AS ConditionTermFactorDenominator,
  quotation_uom AS QuotationUnitOfMeasure,
  fx_fix_calctype_term_to_doc AS FixedCalculationType,
  previous_md_factor_from AS TermToDocFixedFactorFrom,
  previous_md_factor_to AS TermToDocFixedFactorTo,
  fx_mrkt_to_term_fx_ratetype AS MarketToTermExchangeRateType,
  fx_cond_to_doc_fxratetype AS ConditionToDocExchangeRateType,
  fx_doc_to_stat_fxratetype AS DocToStstcExchangeRateType,
  fx_cond_to_stat_fxratetype AS CndnToStstcExchangeRateType,
  stwae_kurst AS ExchangeRateType,
  quotation_crcy AS QuotationCurrency,
  skip_reporting AS SkipReportingIndicatorIsSet,
  uom_quot_to_term_factor_from AS OldScore,
  psmethod AS PriceSettingMethod,
  psmstatus AS PriceSettingMethodStatus,
  valid_to_tst AS ValidToDateTime,
  kalsm AS PricingProcedure,
  termno AS PricingConditionTerm,
  ext_number AS CmmdtyDocumentExternalNumber,
  root_ext_number AS CmmdtyRootDocExternalNumber,
  uom_comm_to_term_factor_num AS CndnCmmdtyToTrmFctrNumerator,
  uom_comm_to_term_factor_den AS CndnCmmdtyToTrmFctrDenominator,
  exclude_basedate AS ExcludeBasedate,
  formcombrout AS PrcgCndnFmlaCombinationRoutine,
  commodity AS PricingCommodity,
  market_curve_key AS MarketCurveAccess,
  spread_rates_key AS SpreadRateAccess,
  cmmdtydealdeteffectivefromdate AS DealEffectiveFromDate,
  cmmdtydealdeteffectivetodate AS DealEffectiveToDate,
  CommodityDealClass,
  CommodityDealLocationID,
  CmmdtyNominationKey,
  CmmdtyNominationItem,
  CmmdtyNominationNumber,
  gasshipper AS NominationShipper,
  NominationCarrier,
  nominationmodeoftransport AS ModeOfTransport,
  PostingDate,
  NominationTicketKey,
  CommodityNominationClass,
  /accgo/val_point AS ValuationPoint,
  /accgo/ldc_id AS LoadDataCaptureObjectID,
  /accgo/vehicle_id AS VehicleId,
  /accgo/delivery_from AS DeliveryValidStartDate,
  /accgo/delivery_to AS DeliveryValidEndDate,
  ref_doc AS VersionedRefDocument,
  ref_doc_itm AS VersionedRefDocumentItem,
  ref_doc_year AS RefDocumentYear,
  contract_plant AS ContractPlant,
  contract_price AS TradingContractConditionRate,
  reporting_version AS ReportingVersion,
  update_timestamp AS UpdatedOnDateTime,
  market_product_value AS MarketProduct,
  market_product_source AS MarketProductSourceType,
  market_location_value AS MarketLocation,
  market_location_source AS MarketLocationSourceType,
  risk_domain_value AS RiskDomain,
  risk_domain_source AS RiskDomainSourceType,
  fx_exposure_uuid AS CmmdtyFXIntegExposureUUID,
  fx_exposure_processing_type AS CmmdtyFXIntegExpsrProcgType,
  document_type_sot AS SourceDocumentSONTInUprcs,
  root_doc_type_sot AS OriginRefDocumentSONTInUprcs,
  predecessor_doc_type_sot AS ReferenceDocumentSONTInUprcs,
  ref_doc_type_sot AS VersRefDocumentSONTInUprcs
FROM cmm_vlogp
;