P_DGR_BEGINBOOKBAL_TIMESTAMPS

CDS View

P_DGR_BEGINBOOKBAL_TIMESTAMPS 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_DGR_BeginBookBal_ConvToBase view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PDGRBBB'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #COMPOSITE
@VDM.private: true

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D -- View will be consumed for Analytical Reporting
@ObjectModel.usageType.sizeCategory: #XXL -- No. of Records > 100,000
define view P_DGR_BeginBookBal_TimeStamps
  with parameters
    P_DisplayUnitOfMeasure : cds_dgr_display_uom,
    P_DailyGrainReportType : cds_dgr_report_type,
    P_DailyGrainReportDate : cds_dgr_date
  as select from    P_DGR_BeginBookBal_FillPhysCom
                 ( P_DisplayUnitOfMeasure : :P_DisplayUnitOfMeasure,
                       P_DailyGrainReportType: :P_DailyGrainReportType,
                       P_DailyGrainReportDate: :P_DailyGrainReportDate)         as BBB
    left outer join P_DGR_TF_TimstampsTF
                      (iv_client : $session.client,
                            P_DailyGrainReportType: :P_DailyGrainReportType,
                             P_DailyGrainReportDate: :P_DailyGrainReportDate ,
                             P_SourceDocType : 'BBB'                      ) as DGRTimestamps on  BBB.Plant           = DGRTimestamps.Plant
                                                                                                 and BBB.Material        = DGRTimestamps.Material
                                                                                                 and BBB.StorageLocation = DGRTimestamps.StorageLocation
{
 
  //BBB

  BBB.CompanyCode,
  BBB.Plant,
  BBB.PlantGroup,
  BBB.Material,
  BBB.MaterialBaseUnit,
  BBB.PhysicalCommodity,
  BBB.StorageLocation,
  BBB.BeginingBookBalanceQuantity,
  BBB.BeginingBookBalanceUnit,
  BBB.BeginingBookBalanceDate,

  //  ValidA2Record.QuantityRepositoryUUID,

  //  ValidA2Record.QuantityRepositoryVersion,


  DGRTimestamps.EndOfDayTimestamp,
  DGRTimestamps.PreviousEndOfDayTimestamp,
  DGRTimestamps.BegingingBookBalancetTimestamp,
  DGRTimestamps.EndOfDayBusinessEntityKey,

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

Learn More