P_StockMTM_Delta_Data

DDL: P_STOCKMTM_DELTA_DATA SQL: PSTKMTMDELTADATA Type: view COMPOSITE

P_StockMTM_Delta_Data is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_StockMTM_Base_Data, P_Konvd_NetDry_SelectData_TF) and exposes 60 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.

2 data source(s) 60 fields

Data Sources (2)

SourceAliasJoin Type
P_StockMTM_Base_Data P_StockMTM_Base_Data from
P_Konvd_NetDry_SelectData_TF vlogp_konvd inner

Parameters (5)

NameTypeDefault
P_EvaluationDate cmm_eval_keydate
P_ExchRateEvaluationDate cmm_eval_keydate
P_EndOfDaySnapshotFromDate cmm_eval_keydate
P_EndOfDaySnapshotToDate cmm_eval_keydate
P_MTMDataSelectionType cmm_vlogp_consumptiontype

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSTKMTMDELTADATA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (60)

KeyFieldSource TableSource FieldDescription
KEY PricingKey mtmdata PricingKey
KEY Version mtmdata Version
KEY PricingDocumentItem mtmdata PricingDocumentItem
KEY ConditionType mtmdata ConditionType
KEY SubConditionType mtmdata SubConditionType
VersStockRecordUUID VersStockRecordUUID
DataSelectionType mtmdata DataSelectionType
MTMDataSourceType mtmdata MTMDataSourceType
CompanyCode mtmdata CompanyCode
Material mtmdata Material
PhysicalCommodity mtmdata PhysicalCommodity
Plant mtmdata Plant
StorageLocation mtmdata StorageLocation
MTMConditionGroupCategory mtmdata MTMConditionGroupCategory
MTMCalculationGroup mtmdata MTMCalculationGroup
GoodsMovementType GoodsMovementType
SourceDocument SourceDocument
SourceDocumentItem SourceDocumentItem
SourceDocumentBusObjType SourceDocumentBusObjType
OriginReferenceDocument mtmdata OriginReferenceDocument
OriginReferenceDocBusObjType mtmdata OriginReferenceDocBusObjType
OriginReferenceDocumentItem mtmdata OriginReferenceDocumentItem
ReferenceDocument mtmdata ReferenceDocument
ReferenceDocumentItem mtmdata ReferenceDocumentItem
ReferenceDocBusObjType mtmdata ReferenceDocBusObjType
Commodityquantity
CommodityQuantityInBaseUnit CommodityQuantityInBaseUnit
CommodityQuantityInTermUnit mtmdata CommodityQuantityInTermUnit
CommodityUnit CommodityUnit
MaterialBaseUnit MaterialBaseUnit
CmmdtyPriceExpsrMassUnit CmmdtyPriceExpsrMassUnit
CmmdtyPriceExpsrQtyInMassUnit CmmdtyPriceExpsrQtyInMassUnit
CmmdtyPriceExpsrVolumeUnit CmmdtyPriceExpsrVolumeUnit
CmmdtyPriceExpsrQtyInVolUnit CmmdtyPriceExpsrQtyInVolUnit
SourceTransactionEventDateTime SourceTransactionEventDateTime
SourceTransacEventEndDateTime SourceTransacEventEndDateTime
CommodityReferenceUnit CommodityReferenceUnit
SourceDocumentYear SourceDocumentYear
QuantitySign QuantitySign
StockRefDocument StockRefDocument
StockRefDocumentItem StockRefDocumentItem
StockRefDocType StockRefDocType
RefDocumentYear RefDocumentYear
SplitItemLineNumber SplitItemLineNumber
LoadDataCaptureObjectID LoadDataCaptureObjectID
LoadDataCaptureEventType LoadDataCaptureEventType
QuantityRepositoryUUID QuantityRepositoryUUID
QuantityRepositoryVersion QuantityRepositoryVersion
NetPriceExpsrQtyInBaseUnit NetPriceExpsrQtyInBaseUnit
NetPriceExpsrQuantity NetPriceExpsrQuantity
NetPriceExpsrQtyInMassUnit NetPriceExpsrQtyInMassUnit
NetPriceExpsrQtyInVolumeUnit NetPriceExpsrQtyInVolumeUnit
StorageGrossQtyInCmmdtyUnit StorageGrossQtyInCmmdtyUnit
DiscPremQtyScheduleUniqueID DiscPremQtyScheduleUniqueID
DiscPremQtyScheduleVersion DiscPremQtyScheduleVersion
DiscPremVolSchedEvalIsRqd DiscPremVolSchedEvalIsRqd
DiscPremQtyScheduleType DiscPremQtyScheduleType
RecordIsLogicallyDeleted RecordIsLogicallyDeleted
NetDryErrorCode NetDryErrorCode
DiscPremQtyScheduleuuid DiscPremQtyScheduleuuid 
@AbapCatalog.sqlViewName: 'PSTKMTMDELTADATA'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view P_StockMTM_Delta_Data
  with parameters
    P_EvaluationDate           : cmm_eval_keydate,
    P_ExchRateEvaluationDate   : cmm_eval_keydate,
    P_EndOfDaySnapshotFromDate : cmm_eval_keydate,
    P_EndOfDaySnapshotToDate   : cmm_eval_keydate,
    P_MTMDataSelectionType     : cmm_vlogp_consumptiontype

  as select from P_StockMTM_Base_Data( P_EvaluationDate           : :P_EvaluationDate,
                                       P_ExchRateEvaluationDate   : :P_ExchRateEvaluationDate,
                                       P_EndOfDaySnapshotFromDate : :P_EndOfDaySnapshotFromDate,
                                       P_EndOfDaySnapshotToDate   : :P_EndOfDaySnapshotToDate,
                                       P_MTMDataSelectionType     : :P_MTMDataSelectionType) as mtmdata
  //    inner join   cmm_vlogp_konvd                                                             as vlogp_konvd on  mtmdata.PricingKey            =  vlogp_konvd.pricing_key

  //                                                                                                            and mtmdata.PricingDocumentItem   =  vlogp_konvd.kposn

  //                                                                                                            and mtmdata.ConditionType         =  vlogp_konvd.kschl

  //                                                                                                            and mtmdata.SubConditionType      =  vlogp_konvd.kschl_subkey

  //                                                                                                            and mtmdata.EndOfDayTimestampFrom >= vlogp_konvd.valid_from_timestamp

  //                                                                                                            and mtmdata.EndOfDayTimestampTo   <= vlogp_konvd.valid_to_timestamp


    inner join   P_Konvd_NetDry_SelectData_TF                                                as vlogp_konvd on  mtmdata.PricingKey            =  vlogp_konvd.PricingKey
                                                                                                            and mtmdata.PricingDocumentItem   =  vlogp_konvd.PricingDocumentItem
                                                                                                            and mtmdata.ConditionType         =  vlogp_konvd.ConditionType
                                                                                                            and mtmdata.SubConditionType      =  vlogp_konvd.SubConditionType
                                                                                                            and mtmdata.EndOfDayTimestampFrom >= vlogp_konvd.SourceTransactionEventDateTime
                                                                                                            and mtmdata.EndOfDayTimestampTo   <= vlogp_konvd.SourceTransacEventEndDateTime
{
  key mtmdata.PricingKey,
  key mtmdata.Version,
  key mtmdata.PricingDocumentItem,
  key mtmdata.ConditionType,
  key mtmdata.SubConditionType,
      VersStockRecordUUID,
      mtmdata.DataSelectionType,
      mtmdata.MTMDataSourceType,
      mtmdata.CompanyCode,
      mtmdata.Material,
      mtmdata.PhysicalCommodity,
      mtmdata.Plant,
      mtmdata.StorageLocation,
      mtmdata.MTMConditionGroupCategory,
      mtmdata.MTMCalculationGroup,
      GoodsMovementType,
      SourceDocument,
      SourceDocumentItem,
      SourceDocumentBusObjType,
      mtmdata.OriginReferenceDocument,
      mtmdata.OriginReferenceDocBusObjType,
      mtmdata.OriginReferenceDocumentItem,
      mtmdata.ReferenceDocument,
      mtmdata.ReferenceDocumentItem,
      mtmdata.ReferenceDocBusObjType,
      @Semantics.quantity.unitOfMeasure: 'COMMODITYUNIT'
      CommodityQuantity * QuantitySign as Commodityquantity,
      @Semantics.quantity.unitOfMeasure: 'MATERIALBASEUNIT'
      CommodityQuantityInBaseUnit,
      mtmdata.CommodityQuantityInTermUnit,
      @Semantics.unitOfMeasure: true
      CommodityUnit,
      @Semantics.unitOfMeasure: true
      MaterialBaseUnit,
      @Semantics.unitOfMeasure: true
      CmmdtyPriceExpsrMassUnit,
      @Semantics.quantity.unitOfMeasure: 'CMMDTYPRICEEXPSRMASSUNIT'
      CmmdtyPriceExpsrQtyInMassUnit,
      @Semantics.unitOfMeasure: true
      CmmdtyPriceExpsrVolumeUnit,
      @Semantics.quantity.unitOfMeasure: 'CMMDTYPRICEEXPSRVOLUMEUNIT'
      CmmdtyPriceExpsrQtyInVolUnit,
      SourceTransactionEventDateTime,
      SourceTransacEventEndDateTime,
      CommodityReferenceUnit,
      SourceDocumentYear,
      QuantitySign,
      StockRefDocument,
      StockRefDocumentItem,
      StockRefDocType,
      RefDocumentYear,
      SplitItemLineNumber,
      LoadDataCaptureObjectID,
      LoadDataCaptureEventType,
      QuantityRepositoryUUID,
      QuantityRepositoryVersion,
      @Semantics.quantity.unitOfMeasure: 'MATERIALBASEUNIT'
      NetPriceExpsrQtyInBaseUnit,
      @Semantics.quantity.unitOfMeasure: 'COMMODITYUNIT'
      NetPriceExpsrQuantity,
      @Semantics.quantity.unitOfMeasure: 'CMMDTYPRICEEXPSRMASSUNIT'
      NetPriceExpsrQtyInMassUnit,
      @Semantics.quantity.unitOfMeasure: 'CMMDTYPRICEEXPSRVOLUMEUNIT'
      NetPriceExpsrQtyInVolumeUnit,
      @Semantics.quantity.unitOfMeasure: 'COMMODITYUNIT'
      StorageGrossQtyInCmmdtyUnit,
      DiscPremQtyScheduleUniqueID,
      DiscPremQtyScheduleVersion,
      DiscPremVolSchedEvalIsRqd,
      DiscPremQtyScheduleType,
      RecordIsLogicallyDeleted,
      NetDryErrorCode,
      DiscPremQtyScheduleuuid

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_STOCKMTM_BASE_DATA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More