P_DGR_KF_BPClassification

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_BPClassification.
-- 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: PDGRKFBPCLASS
-- 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_BPClassification AS
SELECT
  Data.PricingKey AS PricingKey,
  Data.PricingDocumentItem AS PricingDocumentItem,
  Data.ConditionType AS ConditionType,
  Data.SubConditionType AS SubConditionType,
  Data.VersStockRecordUUID AS VersStockRecordUUID,
  Data.SourceDocument AS SourceDocument,
  Data.SourceDocumentItem AS SourceDocumentItem,
  Data.QuantityHistorySequenceNumber AS QuantityHistorySequenceNumber,
  Data.HandleLossRsrvId AS HandleLossRsrvId,
  Data.HandleLossRsrvItem AS HandleLossRsrvItem,
  Data.HandleLossRsrvVersion AS HandleLossRsrvVersion,
  Data.DGRDataSourceType AS DGRDataSourceType,
  Data.DGRQuantiyType AS DGRQuantiyType,
  Data.CompanyCode AS CompanyCode,
  Data.Plant AS Plant,
  Data.StorageLocation AS StorageLocation,
  Data.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  Data.Material AS Material,
  Data.PhysicalCommodity AS PhysicalCommodity,
  Data.MTMDataSourceType AS MTMDataSourceType,
  Data.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  Data.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  cast(round(Data.CommodityExposureQuantity, 3) as abap.quan( 17, 3) ) AS CommodityExposureQuantity,
  Data.CommodityExposureUnit AS CommodityExposureUnit,
  Data.QuantitySign AS QuantitySign,
  Data.LoadDataCaptureObjectID AS LoadDataCaptureObjectID,
  Data.LoadDataCaptureEventType AS LoadDataCaptureEventType,
  Data.QuantityRepositoryUUID AS QuantityRepositoryUUID,
  Data.QuantityRepositoryVersion AS QuantityRepositoryVersion,
  Data.DiscPremQtyScheduleUniqueID AS DiscPremQtyScheduleUniqueID,
  Data.DiscPremQtySchedValdtyVersion AS DiscPremQtySchedValdtyVersion,
  Data.DiscPremQtyScheduleVersion AS DiscPremQtyScheduleVersion,
  Data.DiscPremQtyScheduleType AS DiscPremQtyScheduleType,
  Data.EndOfDayTimestamp AS EndOfDayTimestamp,
  Data.PreviousEndOfDayTimestamp AS PreviousEndOfDayTimestamp,
  Data.BegingingBookBalancetTimestamp AS BegingingBookBalancetTimestamp,
  Data.LicenseStatus AS LicenseStatus,
  Data.PlantGroup AS PlantGroup,
  Data.ApplicationStatus AS ApplicationStatus,
  Data.WarehouseReceiptType AS WarehouseReceiptType,
  Data.WarehouseReceiptNo AS WarehouseReceiptNo,
  Data.ObligationType AS ObligationType,
  Data.StorageAgreement AS StorageAgreement,
  Data.StorageAgreementItem AS StorageAgreementItem,
  BPClassificationData.BusinessPartnerClassification AS VendorClassification,
  Data.IsHandleLossRsrvRecieptFwd AS IsHandleLossRsrvRecieptFwd,
  Data.IsHandleLossRsrvCancellFwd AS IsHandleLossRsrvCancellFwd,
  Data.DailyGrainRptCushionPercentage AS DailyGrainRptCushionPercentage,
  Data.TradingContract AS TradingContract,
  Data.TradingContractItem AS TradingContractItem,
  Data.TradingContractStatus AS TradingContractStatus,
  Data.ApplicationDocType AS ApplicationDocType,
  Data.LoadDataCaptureApplInstr AS LoadDataCaptureApplInstr,
  Data.ApplicationGuid AS ApplicationGuid,
  Data.ApplicationVersion AS ApplicationVersion,
  Data.ApplicationDocCreationDate AS ApplicationDocCreationDate,
  Data.ApplicationDocAppliedDate AS ApplicationDocAppliedDate,
  Data.ApplicationDocSettlementDate AS ApplicationDocSettlementDate,
  Data.ContractIsConfirmed AS ContractIsConfirmed,
  Data.Supplier AS Supplier,
  Data.SubstitutedMaterial AS SubstitutedMaterial,
  Data.SubstitutedPlant AS SubstitutedPlant,
  Data.IsSubstitutedRecord AS IsSubstitutedRecord,
  Data.SttlInvoicePaymentDateTime AS SttlInvoicePaymentDateTime,
  DailyGrainReportDisplayUnit,
  DailyGrainReportType,
  DailyGrainReportDate,
  BPGuidData.PartnerUUID AS partner_guid,
  BPData.BusinessPartnerNumber AS BusinessPartnerNumber,
  BPClassificationData.BusinessPartnerClassification AS BusinessPartnerClassification,
  cast(Data.SourceDocumentItem as abap.char( 6 )) AS SourceDocumentItemChar,
  Data.A2CommodityQuantityInBaseUnit AS A2CommodityQuantityInBaseUnit,
  Data.A2NetPriceExpsrQtyInBaseUnit AS A2NetPriceExpsrQtyInBaseUnit,
  Data.GrossQuantity AS GrossQuantity
FROM P_DGR_KF_UpdateExposureQty
LEFT OUTER JOIN I_VendAssgToBP AS BPGuidData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ACMBusPartData AS BPData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BPCounterPartyType AS BPClassificationData ON /* join condition not captured in parsed metadata */
;