P_DGR_Qrep_FillLDCData

@AbapCatalog.sqlViewName: 'PDGRQREPLDCDATA'
@AbapCatalog.preserveKey: true

//@EndUserText.label: 'QRep LDC Data'


@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_Qrep_FillLDCData
  with parameters
    P_DailyGrainReportDate : cds_dgr_date
  as select from    P_DGR_Qrep_FillEODTimestamp
                 (P_DailyGrainReportDate : :P_DailyGrainReportDate) as QRep
    left outer join I_LoadDataCaptureEventData                      as LDCData on QRep.LoadDataCaptureEventKey = LDCData.LDCEventKey
{
  key QuantityRepositoryUUID,
  key QuantityRepositoryVersion,
  key SourceDocType,
      GovAnalysisCertCategory,
      QRep.LoadDataCaptureEventKey,
      QuantityRepositoryCreatedOn,
      QuantityRepositoryChangedOn,
      LoadDataCaptureObjectID,
      ApplicationDocument,
      SourceDocument,
      SourceDocumentItem,
      QuantitySign,
      TransactionEventType,
      EndOfDayTimestamp,

      //            LDCData.uis_id     as LoadDataCaptureObjectID,

      LDCData.LoadDataCaptureType, -- Outgoing(Sales)/Incoming(Purchase)
      LDCData.LoadDataCaptureEventType, -- Load/Unload
      LDCData.LDCApplInstructionValue -- Application Instruction
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOADDATACAPTUREEVENTDATA",
"P_DGR_QREP_FILLEODTIMESTAMP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/