P_Vlogp_Dendrun_PositionRep_2
P_Vlogp_Dendrun_PositionRep_2 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (P_Vlogp_PositionRep_2) and exposes 135 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_Vlogp_PositionRep_2 | P_Vlogp_PositionRep_2 | from |
Parameters (6)
| Name | Type | Default |
|---|---|---|
| P_consumption_type | cmm_vlogp_consumptiontype | |
| P_DisplayView | cds_view_uom | |
| P_EndOfDaySnapshotFromDate | cmm_dend_cutdate | |
| P_EndOfDaySnapshotToDate | cmm_dend_cutdate | |
| P_MinEndOfDayFromDateTime | cmm_min_eod_from_datetime | |
| P_MaxEndOfDayToDateTime | cmm_max_eod_to_datetime |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| AbapCatalog.sqlViewName | PVLOGPDENDRUNPO2 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view |
Fields (135)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | PricingKey | vlogp | PricingKey | Pricing Key |
| KEY | Version | vlogp | Version | XML Vers. |
| KEY | PricingDocumentItem | vlogp | PricingDocumentItem | Item |
| KEY | ConditionType | vlogp | ConditionType | Condition type |
| KEY | SubConditionType | vlogp | SubConditionType | |
| EndOfDaySnapshotFromDate | vlogp | EndOfDaySnapshotFromDate | ||
| EndOfDaySnapshotToDate | vlogp | EndOfDaySnapshotToDate | ||
| MTMDataSelectionType | vlogp | MTMDataSelectionType | ||
| ValidityStartDate | vlogp | ValidityStartDate | Validity Start Date | |
| ValidityStartDateTime | vlogp | ValidityStartDateTime | Valid From Timestamp | |
| ValidityEndDate | vlogp | ValidityEndDate | ValidTo | |
| ValidityEndDateTime | vlogp | ValidityEndDateTime | Valid To Timestamp | |
| SourceTransactionEventDateTime | vlogp | SourceTransactionEventDateTime | ||
| SourceTransacEventEndDateTime | vlogp | SourceTransacEventEndDateTime | ||
| EndOfDaySnapshotDateTimeFrom | dendrun | EndOfDaySnapshotDateTime | ||
| EndOfDaySnapshotDateTimeTo | dendrun | EndOfDaySnapshotDateTime | ||
| EndOfDaySnapshotDate | dendrun | EndOfDaySnapshotDate | ||
| EndOfDayBusinessEntityKey | vlogp | EndOfDayBusinessEntityKey | ||
| MaximumVersion | vlogp | MaximumVersion | Highest Version | |
| PreviousVersion | vlogp | PreviousVersion | ||
| CompanyCode | ||||
| SalesOrganization | vlogp | SalesOrganization | Sales Organization | |
| DistributionChannel | vlogp | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | vlogp | Division | Internal Division ID | |
| Creditor | vlogp | Creditor | Supplier | |
| SoldToParty | vlogp | SoldToParty | Sold-to Party | |
| Material | vlogp | Material | Vehicle Model | |
| PhysicalCommodity | vlogp | PhysicalCommodity | ||
| Plant | vlogp | Plant | Valuation Area | |
| StorageLocation | vlogp | StorageLocation | StorageLocation | |
| Batch | vlogp | Batch | Lot No. | |
| IncotermsClassification | vlogp | IncotermsClassification | Incoterms | |
| IncotermsTransferLocation | vlogp | IncotermsTransferLocation | Incoterms 2 | |
| ConditionApplication | vlogp | ConditionApplication | Application | |
| SourceDocumentShortNumber | vlogp | SourceDocumentShortNumber | ||
| SourceDocument | vlogp | SourceDocument | Document | |
| SourceDocumentBusObjType | vlogp | SourceDocumentBusObjType | ||
| OrignRefDocumentShortNumber | vlogp | OrignRefDocumentShortNumber | ||
| OriginReferenceDocument | vlogp | OriginReferenceDocument | Root Document | |
| OriginReferenceDocumentItem | vlogp | OriginReferenceDocumentItem | Root Document Item | |
| OriginReferenceDocBusObjType | vlogp | OriginReferenceDocBusObjType | Root (BOR) Obj. Type | |
| ReferenceDocument | vlogp | ReferenceDocument | Reference Document | |
| ReferenceDocumentItem | vlogp | ReferenceDocumentItem | Reference item | |
| ReferenceDocBusObjType | vlogp | ReferenceDocBusObjType | Pred(BOR) Object Typ | |
| DeliveryDate | vlogp | DeliveryDate | Delivery Date | |
| ExpectedPaymentDate | vlogp | ExpectedPaymentDate | ||
| StatisticsCurrency | vlogp | StatisticsCurrency | ||
| DocumentCurrency | vlogp | DocumentCurrency | Document Currency | |
| ProfitCenter | vlogp | ProfitCenter | Profit Center | |
| BusinessArea | vlogp | BusinessArea | Business Area | |
| PurchasingOrganization | vlogp | PurchasingOrganization | Purchasing Organization | |
| MaterialGroup | vlogp | MaterialGroup | Product Group | |
| IsIntercompanyTransfer | vlogp | IsIntercompanyTransfer | ||
| QuotationPriceType | ||||
| ConditionTermRate | vlogp | ConditionTermRate | ||
| ConditionTermRateCurrency | vlogp | ConditionTermRateCurrency | ||
| ConditionTermRateQuantity | vlogp | ConditionTermRateQuantity | ||
| ConditionTermRateQuantityUnit | vlogp | ConditionTermRateQuantityUnit | ||
| ConditionTermValue | vlogp | ConditionTermValue | ||
| ConditionTermValueCurrency | vlogp | ConditionTermValueCurrency | ||
| ConditionTermRateMktCurrency | vlogp | ConditionTermRateMktCurrency | ||
| ConditionTermName | vlogp | ConditionTermName | ||
| ConditionTermStatus | vlogp | ConditionTermStatus | ||
| RoundingDecimalPlaces | vlogp | RoundingDecimalPlaces | ||
| ConditionTermRateIsRounded | vlogp | ConditionTermRateIsRounded | ||
| ConditionTermRateNmrtr | vlogp | ConditionTermRateNmrtr | ||
| ConditionTermRateDnmntr | vlogp | ConditionTermRateDnmntr | ||
| ConditionTermExtensionUsage | vlogp | ConditionTermExtensionUsage | ||
| CmmdtyForwardIndexTiming | vlogp | CmmdtyForwardIndexTiming | ||
| MaturitySelectionType | vlogp | MaturitySelectionType | ||
| QuotationPeriodReferenceDate | vlogp | QuotationPeriodReferenceDate | ||
| CommodityCurve | vlogp | CommodityCurve | ||
| CmmdtyLtstEvaluationKeyDate | vlogp | CmmdtyLtstEvaluationKeyDate | ||
| QuotationKeyType | ||||
| QuotationDateList | vlogp | QuotationDateList | ||
| QuotationPeriodStartDate | vlogp | QuotationPeriodStartDate | ||
| QuotationPeriodEndDate | vlogp | QuotationPeriodEndDate | ||
| DerivativeContrSpecification | vlogp | DerivativeContrSpecification | DCS ID | |
| MarketIdentifierCode | vlogp | MarketIdentifierCode | MIC | |
| MaturityKeyDate | vlogp | MaturityKeyDate | Maturity Key Date | |
| BasisType | vlogp | BasisType | Basis Type | |
| BasisID | vlogp | BasisID | Basis ID | |
| QuotationGroup | vlogp | QuotationGroup | ||
| QuotationGroupCalculationRule | vlogp | QuotationGroupCalculationRule | ||
| PricingStatus | vlogp | PricingStatus | ||
| ConditionTermRateFixation | vlogp | ConditionTermRateFixation | ||
| CndnTermRateFixationDate | vlogp | CndnTermRateFixationDate | ||
| CndnTermRateFixationTime | vlogp | CndnTermRateFixationTime | ||
| CndnTermExchRateFixationDate | vlogp | CndnTermExchRateFixationDate | ||
| CndnTermExchRateFixationTime | vlogp | CndnTermExchRateFixationTime | ||
| FixedExchRateDate | vlogp | FixedExchRateDate | ||
| MaturitySelectionRoutine | vlogp | MaturitySelectionRoutine | ||
| DCSPeriodType | vlogp | DCSPeriodType | ||
| CommodityQuantity | ||||
| CommodityUnit | vlogp | CommodityUnit | Order Unit | |
| CmmdtyPriceExpsrQtyInMassUnit | vlogp | CmmdtyPriceExpsrQtyInMassUnit | ||
| CmmdtyPriceExpsrMassUnit | vlogp | CmmdtyPriceExpsrMassUnit | ||
| CmmdtyPriceExpsrQtyInVolUnit | vlogp | CmmdtyPriceExpsrQtyInVolUnit | ||
| CmmdtyPriceExpsrVolumeUnit | vlogp | CmmdtyPriceExpsrVolumeUnit | ||
| CommodityQuantityInTermUnit | vlogp | CommodityQuantityInTermUnit | ||
| DCSReportingDate | vlogp | DCSReportingDate | ||
| QuantitySign | vlogp | QuantitySign | Sign of Quantity | |
| MTMConditionGroup | vlogp | MTMConditionGroup | ||
| MTMCalculationGroup | vlogp | MTMCalculationGroup | ||
| MTMAdjustmentType | vlogp | MTMAdjustmentType | ||
| MTMCalcGrpMarketPriceCondition | vlogp | MTMCalcGrpMarketPriceCondition | ||
| ConditionTermRateIsFixed | vlogp | ConditionTermRateIsFixed | ||
| ConditionTermExchRateIsFixed | vlogp | ConditionTermExchRateIsFixed | ||
| DisplayView | ||||
| CommodityExposureQuantity | vlogp | CommodityExposureQuantity | ||
| CommodityExposureUnit | vlogp | CommodityExposureUnit | ||
| MTMConditionGroupCategory | vlogp | MTMConditionGroupCategory | ||
| MTMDataSourceType | vlogp | MTMDataSourceType | Type of Data Record | |
| PriceIsRealized | vlogp | PriceIsRealized | ||
| ContrPriceExposureIsExecuted | vlogp | ContrPriceExposureIsExecuted | ||
| CommodityPriceFixationStatus | vlogp | CommodityPriceFixationStatus | ||
| ImplicitFixationIsRelevant | vlogp | ImplicitFixationIsRelevant | ||
| TimeToMaturity | TimeToMaturity | Time to Maturity | ||
| NumberOfYearsOfTimeToMaturity | NumberOfYearsOfTimeToMaturity | |||
| NumberOfMonthsOfTimeToMaturity | NumberOfMonthsOfTimeToMaturity | |||
| NumberOfDaysOfTimeToMaturity | NumberOfDaysOfTimeToMaturity | |||
| MinimumConditionTermLimitRate | MinimumConditionTermLimitRate | |||
| MaximumConditionTermLimitRate | MaximumConditionTermLimitRate | |||
| ConditionTermLimitRateCurrency | ConditionTermLimitRateCurrency | |||
| ConditionTermLimitRateQuantity | ConditionTermLimitRateQuantity | |||
| CndnTermLimitRateQuantityUnit | CndnTermLimitRateQuantityUnit | |||
| NumberOfDaysInQuotationPeriod | vlogp | NumberOfDaysInQuotationPeriod | ||
| PriceSettingMethod | vlogp | PriceSettingMethod | ||
| PriceSettingMethodStatus | vlogp | PriceSettingMethodStatus | ||
| ValidToDateTime | vlogp | ValidToDateTime | Time Stamp | |
| PricingProcedure | vlogp | PricingProcedure | Procedure | |
| PricingConditionTerm | vlogp | PricingConditionTerm | Term Number | |
| CmmdtyDocumentExternalNumber | vlogp | CmmdtyDocumentExternalNumber | ||
| CmmdtyRootDocExternalNumber | vlogp | CmmdtyRootDocExternalNumber | ||
| ExcludeBasedate | vlogp | ExcludeBasedate |
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 P_Vlogp_Dendrun_PositionRep_2.
-- 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.
-- Parameters: P_consumption_type : cmm_vlogp_consumptiontype, P_DisplayView : cds_view_uom, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime, P_MaxEndOfDayToDateTime : cmm_max_eod_to_datetime
CREATE VIEW P_Vlogp_Dendrun_PositionRep_2 AS
SELECT
vlogp.PricingKey AS PricingKey,
vlogp.Version AS Version,
vlogp.PricingDocumentItem AS PricingDocumentItem,
vlogp.ConditionType AS ConditionType,
vlogp.SubConditionType AS SubConditionType,
vlogp.EndOfDaySnapshotFromDate AS EndOfDaySnapshotFromDate,
vlogp.EndOfDaySnapshotToDate AS EndOfDaySnapshotToDate,
vlogp.MTMDataSelectionType AS MTMDataSelectionType,
vlogp.ValidityStartDate AS ValidityStartDate,
vlogp.ValidityStartDateTime AS ValidityStartDateTime,
vlogp.ValidityEndDate AS ValidityEndDate,
vlogp.ValidityEndDateTime AS ValidityEndDateTime,
vlogp.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
vlogp.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
dendrun.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTimeFrom,
dendrun.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTimeTo,
dendrun.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
vlogp.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
vlogp.MaximumVersion AS MaximumVersion,
vlogp.PreviousVersion AS PreviousVersion,
vlogp.SalesOrganization AS SalesOrganization,
vlogp.DistributionChannel AS DistributionChannel,
vlogp.Division AS Division,
vlogp.Creditor AS Creditor,
vlogp.SoldToParty AS SoldToParty,
vlogp.Material AS Material,
vlogp.PhysicalCommodity AS PhysicalCommodity,
vlogp.Plant AS Plant,
vlogp.StorageLocation AS StorageLocation,
vlogp.Batch AS Batch,
vlogp.IncotermsClassification AS IncotermsClassification,
vlogp.IncotermsTransferLocation AS IncotermsTransferLocation,
vlogp.ConditionApplication AS ConditionApplication,
vlogp.SourceDocumentShortNumber AS SourceDocumentShortNumber,
vlogp.SourceDocument AS SourceDocument,
vlogp.SourceDocumentBusObjType AS SourceDocumentBusObjType,
vlogp.OrignRefDocumentShortNumber AS OrignRefDocumentShortNumber,
vlogp.OriginReferenceDocument AS OriginReferenceDocument,
vlogp.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
vlogp.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
vlogp.ReferenceDocument AS ReferenceDocument,
vlogp.ReferenceDocumentItem AS ReferenceDocumentItem,
vlogp.ReferenceDocBusObjType AS ReferenceDocBusObjType,
vlogp.DeliveryDate AS DeliveryDate,
vlogp.ExpectedPaymentDate AS ExpectedPaymentDate,
vlogp.StatisticsCurrency AS StatisticsCurrency,
vlogp.DocumentCurrency AS DocumentCurrency,
vlogp.ProfitCenter AS ProfitCenter,
vlogp.BusinessArea AS BusinessArea,
vlogp.PurchasingOrganization AS PurchasingOrganization,
vlogp.MaterialGroup AS MaterialGroup,
vlogp.IsIntercompanyTransfer AS IsIntercompanyTransfer,
vlogp.ConditionTermRate AS ConditionTermRate,
vlogp.ConditionTermRateCurrency AS ConditionTermRateCurrency,
vlogp.ConditionTermRateQuantity AS ConditionTermRateQuantity,
vlogp.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
vlogp.ConditionTermValue AS ConditionTermValue,
vlogp.ConditionTermValueCurrency AS ConditionTermValueCurrency,
vlogp.ConditionTermRateMktCurrency AS ConditionTermRateMktCurrency,
vlogp.ConditionTermName AS ConditionTermName,
vlogp.ConditionTermStatus AS ConditionTermStatus,
vlogp.RoundingDecimalPlaces AS RoundingDecimalPlaces,
vlogp.ConditionTermRateIsRounded AS ConditionTermRateIsRounded,
vlogp.ConditionTermRateNmrtr AS ConditionTermRateNmrtr,
vlogp.ConditionTermRateDnmntr AS ConditionTermRateDnmntr,
vlogp.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
vlogp.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
vlogp.MaturitySelectionType AS MaturitySelectionType,
vlogp.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
vlogp.CommodityCurve AS CommodityCurve,
vlogp.CmmdtyLtstEvaluationKeyDate AS CmmdtyLtstEvaluationKeyDate,
vlogp.QuotationDateList AS QuotationDateList,
vlogp.QuotationPeriodStartDate AS QuotationPeriodStartDate,
vlogp.QuotationPeriodEndDate AS QuotationPeriodEndDate,
vlogp.DerivativeContrSpecification AS DerivativeContrSpecification,
vlogp.MarketIdentifierCode AS MarketIdentifierCode,
vlogp.MaturityKeyDate AS MaturityKeyDate,
vlogp.BasisType AS BasisType,
vlogp.BasisID AS BasisID,
vlogp.QuotationGroup AS QuotationGroup,
vlogp.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
vlogp.PricingStatus AS PricingStatus,
vlogp.ConditionTermRateFixation AS ConditionTermRateFixation,
vlogp.CndnTermRateFixationDate AS CndnTermRateFixationDate,
vlogp.CndnTermRateFixationTime AS CndnTermRateFixationTime,
vlogp.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
vlogp.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
vlogp.FixedExchRateDate AS FixedExchRateDate,
vlogp.MaturitySelectionRoutine AS MaturitySelectionRoutine,
vlogp.DCSPeriodType AS DCSPeriodType,
vlogp.CommodityUnit AS CommodityUnit,
vlogp.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
vlogp.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
vlogp.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
vlogp.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
vlogp.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
vlogp.DCSReportingDate AS DCSReportingDate,
vlogp.QuantitySign AS QuantitySign,
vlogp.MTMConditionGroup AS MTMConditionGroup,
vlogp.MTMCalculationGroup AS MTMCalculationGroup,
vlogp.MTMAdjustmentType AS MTMAdjustmentType,
vlogp.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
vlogp.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
vlogp.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
vlogp.CommodityExposureQuantity AS CommodityExposureQuantity,
vlogp.CommodityExposureUnit AS CommodityExposureUnit,
vlogp.MTMConditionGroupCategory AS MTMConditionGroupCategory,
vlogp.MTMDataSourceType AS MTMDataSourceType,
vlogp.PriceIsRealized AS PriceIsRealized,
vlogp.ContrPriceExposureIsExecuted AS ContrPriceExposureIsExecuted,
vlogp.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
vlogp.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant,
TimeToMaturity,
NumberOfYearsOfTimeToMaturity,
NumberOfMonthsOfTimeToMaturity,
NumberOfDaysOfTimeToMaturity,
MinimumConditionTermLimitRate,
MaximumConditionTermLimitRate,
ConditionTermLimitRateCurrency,
ConditionTermLimitRateQuantity,
CndnTermLimitRateQuantityUnit,
vlogp.NumberOfDaysInQuotationPeriod AS NumberOfDaysInQuotationPeriod,
vlogp.PriceSettingMethod AS PriceSettingMethod,
vlogp.PriceSettingMethodStatus AS PriceSettingMethodStatus,
vlogp.ValidToDateTime AS ValidToDateTime,
vlogp.PricingProcedure AS PricingProcedure,
vlogp.PricingConditionTerm AS PricingConditionTerm,
vlogp.CmmdtyDocumentExternalNumber AS CmmdtyDocumentExternalNumber,
vlogp.CmmdtyRootDocExternalNumber AS CmmdtyRootDocExternalNumber,
vlogp.ExcludeBasedate AS ExcludeBasedate
FROM P_Vlogp_PositionRep_2
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA