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_DGR_KF_PrepareData.
-- 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.
-- SQL view name: PDGRKFPREPDATA
-- Parameters: P_CompanyCode : bukrs, P_DisplayUnitOfMeasure : cds_dgr_display_uom, P_DailyGrainReportType : cds_dgr_report_type, P_DailyGrainReportDate : cds_dgr_date
CREATE VIEW P_DGR_KF_PrepareData AS
SELECT
DGRKF.PricingKey AS PricingKey,
DGRKF.PricingDocumentItem AS PricingDocumentItem,
DGRKF.ConditionType AS ConditionType,
DGRKF.SubConditionType AS SubConditionType,
DGRKF.VersStockRecordUUID AS VersStockRecordUUID,
DGRKF.SourceDocument AS SourceDocument,
DGRKF.SourceDocumentItem AS SourceDocumentItem,
DGRKF.QuantityHistorySequenceNumber AS QuantityHistorySequenceNumber,
HandleLossRsrvId,
HandleLossRsrvItem,
DGRKF.HandleLossRsrvVersion AS HandleLossRsrvVersion,
DGRDataSourceType,
DGRQuantiyType,
DGRKF.CompanyCode AS CompanyCode,
DGRKF.Plant AS Plant,
DGRKF.StorageLocation AS StorageLocation,
DGRKF.SourceDocumentBusObjType AS SourceDocumentBusObjType,
DGRKF.Material AS Material,
DGRKF.PhysicalCommodity AS PhysicalCommodity,
DGRKF.MTMDataSourceType AS MTMDataSourceType,
DGRKF.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
DGRKF.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
DGRKF.CommodityExposureQuantity AS CommodityExposureQuantity,
DGRKF.CommodityExposureUnit AS CommodityExposureUnit,
DGRKF.QuantitySign AS QuantitySign,
DGRKF.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
DGRKF.LoadDataCaptureEventType AS LoadDataCaptureEventType,
DGRKF.QuantityRepositoryUUID AS QuantityRepositoryUUID,
DGRKF.QuantityRepositoryVersion AS QuantityRepositoryVersion,
DGRKF.DiscPremQtyScheduleUniqueID AS DiscPremQtyScheduleUniqueID,
DiscPremQtySchedValdtyVersion,
DGRKF.DiscPremQtyScheduleVersion AS DiscPremQtyScheduleVersion,
DGRKF.DiscPremQtyScheduleType AS DiscPremQtyScheduleType,
DGRKF.EndOfDayTimestamp AS EndOfDayTimestamp,
DGRKF.PreviousEndOfDayTimestamp AS PreviousEndOfDayTimestamp,
DGRKF.BegingingBookBalancetTimestamp AS BegingingBookBalancetTimestamp,
DGRKF.DailyGrainReportDisplayUnit AS DailyGrainReportDisplayUnit,
DGRKF.DailyGrainReportType AS DailyGrainReportType,
DGRKF.DailyGrainReportDate AS DailyGrainReportDate,
LDCData.LDCIsMultipleBuySellRelevant AS LDCIsMultipleBuySellRelevant,
case when DGRKF.MTMDataSourceType = 'N2' AS LicenseStatusendasLicenseStatus,
DGRKF.PlantGroup AS PlantGroup,
ApplicationStatus,
WarehouseReceiptType,
WarehouseReceiptNo,
ObligationType,
OblgType.WrhsReceiptObligationTypeGroup AS WrhsReceiptObligationTypeGroup,
StorageAgreement,
StorageAgreementItem,
IsHandleLossRsrvRecieptFwd,
IsHandleLossRsrvCancellFwd,
Supplier,
SubstitutedMaterial,
SubstitutedPlant,
IsSubstitutedRecord,
SttlInvoicePaymentDateTime,
BusinessPartnerClassification,
LicenseDataforMeasureUp.LicenseQuantity AS LicenseExposureQuantity,
case when DGRKF.MTMDataSourceType = 'N2' AS quan173endasLicenseExposureQty,
cast(BeginBookBalOverrideAdjQty as abap.quan( 17, 3)) AS BeginBookBalOverrideAdjQty,
cast(OverrideAdjustmentQty as abap.quan( 17, 3)) AS OverrideAdjustmentQty,
cast(CurrentBookBalanceQuantity as abap.quan( 17, 3) ) AS CurrentBookBalanceQuantity,
cast(StorageQtyHistoryQuantity as abap.quan( 17, 3) ) AS StorageQtyHistoryQuantity,
cast(HLRForwardQuantity as abap.quan( 17, 3) ) AS HLRForwardQuantity,
case when DGRKF.LoadDataCaptureEventType = '20' and MTMDataSourceType = '02' then cast((BegingingBookBalEventsQuantity * DGRKF.QuantitySign) as abap.quan( 17, 3)) else cast(0 as abap.quan( 17, 3) ) end as BeginBookBalProdnSrvcGMQty AS quan173endasBeginBookBalProdnSrvcGMQty,
case when DGRKF.LoadDataCaptureEventType = '22' and DGRKF.LoadDataCaptureObjectID is initial and MTMDataSourceType = '02' then cast((BegingingBookBalEventsQuantity * DGRKF.QuantitySign) as abap.quan( 17, 3)) else cast(0 as abap.quan( 17, 3) ) end as BeginBookBalManualQty AS quan173endasBeginBookBalManualQty,
case when DGRKF.LoadDataCaptureEventType = '16' and DGRKF.LoadDataCaptureObjectID is initial and PreviousEndOfDayTimestamp between SourceTransactionEventDateTime and SourceTransacEventEndDateTime and MTMDataSourceType = 'N2' then cast((BegingingBookBalEventsQuantity * DGRKF.QuantitySign) * -1 as abap.quan( 17, 3)) else cast(0 as abap.quan( 17, 3) ) end as BeginBookBalMeasureUpQty AS quan173endasBeginBookBalMeasureUpQty,
case when DGRKF.LoadDataCaptureEventType is initial or DGRKF.LoadDataCaptureEventType is null and MTMDataSourceType = '02' then cast((BegingingBookBalEventsQuantity * DGRKF.QuantitySign) as abap.quan( 17, 3)) else cast(0 as abap.quan( 17, 3) ) end as BeginBookBalOtherQuantity AS quan173endasBeginBookBalOtherQuantity,
cast(case when DGRKF.MTMDataSourceType = '02' and (DGRKF.LoadDataCaptureEventType = '01' or DGRKF.LoadDataCaptureEventType = '02' or DGRKF.LoadDataCaptureEventType = '03' or DGRKF.LoadDataCaptureEventType = '04' or DGRKF.LoadDataCaptureEventType = '05' or DGRKF.LoadDataCaptureEventType = '06' or DGRKF.LoadDataCaptureEventType = '07' or DGRKF.LoadDataCaptureEventType = '08' or DGRKF.LoadDataCaptureEventType = '09' or DGRKF.LoadDataCaptureEventType = '10' or DGRKF.LoadDataCaptureEventType = '11' or DGRKF.LoadDataCaptureEventType = '12' or DGRKF.LoadDataCaptureEventType = '13' or DGRKF.LoadDataCaptureEventType = '14' or DGRKF.LoadDataCaptureEventType = '15' or DGRKF.LoadDataCaptureEventType = '17' or DGRKF.LoadDataCaptureEventType = '23' ) and DGRKF.LoadDataCaptureEventType <> '16' and DGRKF.LoadDataCaptureObjectID is not initial then CurrentBookBalanceQuantity * DGRKF.QuantitySign else 0 end as abap.quan( 17, 3)) as LDCLoadUnloadQty AS quan173asLDCLoadUnloadQty,
cast(case when DGRKF.LoadDataCaptureEventType = '19' and MTMDataSourceType = '02' then CurrentBookBalanceQuantity * DGRKF.QuantitySign else 0 end as abap.quan( 17, 3)) as LDCUnloadLossQty AS quan173asLDCUnloadLossQty,
cast(case when DGRKF.LoadDataCaptureEventType = '20' and MTMDataSourceType = '02' then CurrentBookBalanceQuantity * DGRKF.QuantitySign else 0 end as abap.quan( 17, 3)) as ProdnSrvcGoodsMovementQty AS quan173asProdnSrvcGoodsMovementQty,
cast(case when DGRKF.LoadDataCaptureEventType = '22' and DGRKF.LoadDataCaptureObjectID is initial and MTMDataSourceType = '02' then CurrentBookBalanceQuantity * DGRKF.QuantitySign else 0 end as abap.quan( 17, 3)) as ManualQty AS quan173asManualQty,
cast(case when DGRKF.LoadDataCaptureEventType = '16' and DGRKF.LoadDataCaptureObjectID is initial and EndOfDayTimestamp between SourceTransactionEventDateTime and SourceTransacEventEndDateTime and MTMDataSourceType = 'N2' then CurrentBookBalanceQuantity * DGRKF.QuantitySign * -1 else 0 end as abap.quan( 17, 3)) as MeasureUpQty AS quan173asMeasureUpQty,
case when DGRKF.MTMDataSourceType = 'E2' and SourceTransactionEventDateTime between PreviousEndOfDayTimestamp and EndOfDayTimestamp AS quan173endasLoadvsUnloadQty,
case when DGRKF.MTMDataSourceType = 'E2' and SourceTransacEventEndDateTime between PreviousEndOfDayTimestamp and EndOfDayTimestamp AS quan173endasTodayClearedLoadvsUnloadQty,
DailyGrainRptCushionMaxQty,
DailyGrainRptCushionPercentage,
DailyGrainRptCushionUnit,
TradingContract,
TradingContractItem,
TradingContractStatus,
ApplicationDocType,
ApplicationGuid,
ApplicationVersion,
ApplicationDocCreationDate,
ApplicationDocAppliedDate,
ApplicationDocSettlementDate,
ContractIsConfirmed,
UnappliedQuantity,
AppliedQuantity,
UnassignedQuantity,
DailyGrainRptOpenStorage,
LoadDataCaptureApplInstr AS LoadDataCaptureApplInstruction,
case when ApplicationDocType = 'IAP' or ApplicationDocType = 'ICP' or ApplicationDocType = 'PAD' or ApplicationDocType = 'RSD' then UnappliedQuantity else cast(0 as abap.quan( 17, 3 )) end as UnappliedUnloadsQuantity AS quan173endasUnappliedUnloadsQuantity,
case when ApplicationDocType = 'IAS' or ApplicationDocType = 'ICS' or ApplicationDocType = 'SAD' or ApplicationDocType = 'RPD' then UnappliedQuantity else cast(0 as abap.quan( 17, 3 )) end as UnappliedLoadsQuantity AS quan173endasUnappliedLoadsQuantity,
case when ApplicationDocType = 'CAD' or ApplicationDocType = 'IAP' or ApplicationDocType = 'ICP' or ApplicationDocType = 'PAD' or ApplicationDocType = 'RSD' then AppliedQuantity else cast(0 as abap.quan( 17, 3 )) end as AppliedUnloadsQuantity AS quan173endasAppliedUnloadsQuantity,
case when ApplicationDocType = 'IAS' or ApplicationDocType = 'ICS' or ApplicationDocType = 'SAD' or ApplicationDocType = 'RPD' then AppliedQuantity else cast(0 as abap.quan( 17, 3 )) end as AppliedLoadsQuantity AS quan173endasAppliedLoadsQuantity
FROM P_DGR_KF_SegregateQuanty
LEFT OUTER JOIN I_WrhsReceiptObligationType AS OblgType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_DGR_License_DataRecord ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AutoShipStorage AS AutoShippable ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LoadDataCaptureHdr AS LDCData ON /* join condition not captured in parsed metadata */
;