P_VlogpKonvd_PrepData

DDL: P_VLOGPKONVD_PREPDATA Type: view COMPOSITE
26 Fields 2 Data Sources

P_VlogpKonvd_PrepData is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_Vlogpkonvd, I_VersionedLogisticDocument) and exposes 26 fields with key fields PricingKey, PricingDocumentItem, ConditionType, SubConditionType, VersStockRecordUUID.

Data Sources (2)

SourceAliasJoin Type
I_Vlogpkonvd Konvd from
I_VersionedLogisticDocument vlogp left_outer

Parameters (4)

NameTypeDefault
P_MTMDataSelectionType cmm_vlogp_consumptiontype
P_Displayview cds_view_uom
P_EndOfDaySnapshotFromDate cmm_dend_cutdate
P_EndOfDaySnapshotToDate cmm_dend_cutdate

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PVLOGPKONVDPD 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 (26)

KeyFieldSource TableSource FieldDescription
KEY PricingKey I_Vlogpkonvd PricingKey Pricing Key
KEY PricingDocumentItem I_Vlogpkonvd PricingDocumentItem Item
KEY ConditionType I_Vlogpkonvd ConditionType Condition type
KEY SubConditionType I_Vlogpkonvd SubConditionType Subkey
KEY VersStockRecordUUID VersStockRecordUUID GUID VlogP Stock
MTMDataSourceType I_Vlogpkonvd MTMDataSourceType Type of Data Record
SourceTransactionEventDateTime I_Vlogpkonvd SourceTransactionEventDateTime Valid-From Tstmp
SourceTransacEventEndDateTime I_Vlogpkonvd SourceTransacEventEndDateTime Valid-To Tstmp
EndOfDaySnapshotFromDate
EndOfDaySnapshotToDate
DisplayView
CommodityQuantityInBaseUnit CommodityQuantityInBaseUnit Qty Base UoM
MaterialBaseUnit MaterialBaseUnit Valuation Unit
CmmdtyPriceExpsrQtyInMassUnit I_Vlogpkonvd CmmdtyPriceExpsrQtyInMassUnit Quantity in Mass UoM
CmmdtyPriceExpsrQtyInVolUnit I_Vlogpkonvd CmmdtyPriceExpsrQtyInVolUnit Quantity in Vol UoM
CommodityQuantity I_Vlogpkonvd CommodityQuantity Commodity Quantity
CommodityUnit I_Vlogpkonvd CommodityUnit Order Unit
CmmdtyPriceExpsrMassUnit I_Vlogpkonvd CmmdtyPriceExpsrMassUnit Mass UoM
CmmdtyPriceExpsrVolumeUnit I_Vlogpkonvd CmmdtyPriceExpsrVolumeUnit Volume UoM
QuantitySign I_Vlogpkonvd QuantitySign Sign of Quantity
SourceDocument I_Vlogpkonvd SourceDocument Document
SourceDocumentItem I_Vlogpkonvd SourceDocumentItem Source document item
SourceDocumentBusObjType I_Vlogpkonvd SourceDocumentBusObjType Unit
MTMConditionGroupCategory I_Vlogpkonvd MTMConditionGroupCategory Category
GoodsMovementType GoodsMovementType Movement Type
EndOfDayBusinessEntityKey I_VersionedLogisticDocument EndOfDayBusinessEntityKey Node Key

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_VlogpKonvd_PrepData.
-- 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_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_Displayview : cds_view_uom, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate

CREATE VIEW P_VlogpKonvd_PrepData AS
SELECT
  Konvd.PricingKey AS PricingKey,
  Konvd.PricingDocumentItem AS PricingDocumentItem,
  Konvd.ConditionType AS ConditionType,
  Konvd.SubConditionType AS SubConditionType,
  VersStockRecordUUID,
  Konvd.MTMDataSourceType AS MTMDataSourceType,
  Konvd.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  Konvd.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  cast(:P_EndOfDaySnapshotFromDate as cds_evaluation_date) AS EndOfDaySnapshotFromDate,
  cast(:P_EndOfDaySnapshotToDate as cds_evaluation_date_comp) AS EndOfDaySnapshotToDate,
  cast(:P_Displayview as cds_view_uom) AS DisplayView,
  CommodityQuantityInBaseUnit,
  MaterialBaseUnit,
  Konvd.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  Konvd.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  Konvd.CommodityQuantity AS CommodityQuantity,
  Konvd.CommodityUnit AS CommodityUnit,
  Konvd.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  Konvd.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  Konvd.QuantitySign AS QuantitySign,
  Konvd.SourceDocument AS SourceDocument,
  Konvd.SourceDocumentItem AS SourceDocumentItem,
  Konvd.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  Konvd.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  GoodsMovementType,
  vlogp.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey
FROM I_Vlogpkonvd AS Konvd
LEFT OUTER JOIN I_VersionedLogisticDocument AS vlogp ON /* join condition not captured in parsed metadata */
;

Learn More