P_VlogpKonvd_PrepData_2

DDL: P_VLOGPKONVD_PREPDATA_2 Type: view COMPOSITE
27 Fields 1 Data Sources

Konvd join with Dendrun

P_VlogpKonvd_PrepData_2 is a Composite CDS View that provides data about "Konvd join with Dendrun" in SAP S/4HANA. It reads from 1 data source (I_Vlogpkonvd) and exposes 27 fields with key fields PricingKey, PricingDocumentItem, ConditionType, SubConditionType, VersStockRecordUUID.

Data Sources (1)

SourceAliasJoin Type
I_Vlogpkonvd Konvd from

Parameters (4)

NameTypeDefault
P_MTMDataSelectionType cmm_vlogp_consumptiontype
P_Displayview cds_view_uom
P_EndOfDaySnapshotFromDate cmm_dend_cutdate
P_EndOfDaySnapshotToDate cmm_dend_cutdate

Annotations (11)

NameValueLevelField
EndUserText.label Konvd join with Dendrun view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PVLOGPKONVDPD2 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (27)

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 Cmdty UoM
CmmdtyPriceExpsrVolumeUnit I_Vlogpkonvd CmmdtyPriceExpsrVolumeUnit Cmdty UoM
QuantitySign I_Vlogpkonvd QuantitySign Sign of Quantity
SourceDocumentShortNumber I_Vlogpkonvd SourceDocumentShortNumber Document
SourceDocument I_Vlogpkonvd SourceDocument Document
SourceDocumentItem I_Vlogpkonvd SourceDocumentItem Source document item
SourceDocumentBusObjType I_Vlogpkonvd SourceDocumentBusObjType Source Doc. Type
MTMConditionGroupCategory I_Vlogpkonvd MTMConditionGroupCategory Category
GoodsMovementType GoodsMovementType Movement Type
EndOfDayBusinessEntityKey vlogp EndOfDayBusinessEntityKey

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

CREATE VIEW P_VlogpKonvd_PrepData_2 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.SourceDocumentShortNumber AS SourceDocumentShortNumber,
  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
;

Learn More