P_STOCKMTM_BASE_DATA

CDS View

P_STOCKMTM_BASE_DATA is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_StockMTM_Delta_Data view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PSTKMTMBASEDATA'
@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_Base_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_Vlogp_Dendrun_MtM( P_consumption_type  : :P_MTMDataSelectionType,     -- analytic consumption type
                                      P_valuation_date0   : :P_EvaluationDate,           -- valuation key date
                                      P_valuation_date1   : :P_EvaluationDate,           -- valuation key date
                                      P_FX_valuation_date : :P_ExchRateEvaluationDate,   -- FX valuation date
                                      P_snapshot_date0    : :P_EndOfDaySnapshotFromDate, -- date of snapshot to be selected
                                      P_snapshot_date1    : :P_EndOfDaySnapshotToDate ) as vlogp
{

  key  vlogp.PricingKey,
  key  vlogp.Version,
  key  vlogp.PricingDocumentItem,
  key  vlogp.ConditionType,
  key  vlogp.SubConditionType,
  key  vlogp.valuationDate,
  key  vlogp.FXvaluationDate,
  key  vlogp.FXvaluationDateDocToStstc,
       vlogp.DataSelectionType,
       vlogp.MTMDataSourceType,
       vlogp.MTMConditionGroupCategory,
       vlogp.MTMCalculationGroup,
       vlogp.CompanyCode,
       vlogp.Material,
       vlogp.PhysicalCommodity,
       vlogp.Plant,
       vlogp.StorageLocation,
       vlogp.EndOfDayTimestampFrom,
       vlogp.EndOfDayTimestampTo,
       vlogp.OriginReferenceDocument,
       vlogp.OriginReferenceDocBusObjType,
       vlogp.OriginReferenceDocumentItem,
       vlogp.ReferenceDocument,
       vlogp.ReferenceDocumentItem,
       vlogp.ReferenceDocBusObjType,
       vlogp.CommodityQuantityInTermUnit
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_VLOGP_DENDRUN_MTM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More