P_SLSQTANPRDTVBSCDATA

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_SLSQTANPRDTVBSCDATA.
-- 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: PSDSLSQPBD

CREATE VIEW P_SLSQTANPRDTVBSCDATA AS
SELECT
  cast(SDI.SalesDocument as sales_quotation ) AS SalesQuotation,
  cast(SDI.SalesDocumentItem as sales_quotation_item ) AS SalesQuotationItem,
  SDI.CreatedByUser AS ItemCreatedByUser,
  SDI._CreatedByUser AS _CreatedByUser,
  SDI.CreationDate AS ItemCreationDate,
  cast(SDI.CreationTime as creation_time) AS ItemCreationTime,
  SDI.LastChangeDate AS ItemLastChangeDate,
  cast(CalendarDate.CalendarYear as creation_date_year) AS ItemCreationDateYear,
  cast(CalendarDate.YearQuarter as creation_date_year_quarter) AS ItemCreationDateYearQuarter,
  cast(CalendarDate.YearMonth as creation_date_year_month) AS ItemCreationDateYearMonth,
  CalendarDate.CalendarQuarter AS ItemCreationCalendarQuarter,
  CalendarDate.CalendarMonth AS ItemCreationCalendarMonth,
  CalendarDate.CalendarWeek AS ItemCreationCalendarWeek,
  CalendarDate.CalendarDay AS ItemCreationCalendarDay,
  SDI.SalesDocumentType AS SalesQuotationType,
  SDI.SalesDocumentItemType AS SalesQuotationItemType,
  SDI.SalesDocumentItemCategory AS SalesQuotationItemCategory,
  SDI._ItemCategory AS _ItemCategory,
  SDI.SalesOrganization AS SalesOrganization,
  SDI._SalesOrganization AS _SalesOrganization,
  SDI.DistributionChannel AS DistributionChannel,
  SDI._DistributionChannel AS _DistributionChannel,
  cast(SDI.OrganizationDivision as organization_division preserving type ) AS OrganizationDivision,
  SDI._OrganizationDivision AS _OrganizationDivision,
  SDI.SalesOffice AS SalesOffice,
  SDI._SalesOffice AS _SalesOffice,
  SDI.SalesGroup AS SalesGroup,
  SDI._SalesGroup AS _SalesGroup,
  SDI.Division AS Division,
  SDI._Division AS _Division,
  SDI.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  PeriodStartCalendarDate.CalendarYear AS BindingPerdValdtyStartYear,
  PeriodStartCalendarDate.CalendarQuarter AS BindingPerdValdtyStartQuarter,
  PeriodStartCalendarDate.CalendarMonth AS BindingPerdValdtyStartMonth,
  PeriodStartCalendarDate.CalendarWeek AS BindingPerdValdtyStartWeek,
  PeriodStartCalendarDate.CalendarDay AS BindingPerdValdtyStartDay,
  SDI.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  PeriodEndCalendarDate.CalendarYear AS BindingPerdValdtyEndYear,
  PeriodEndCalendarDate.CalendarQuarter AS BindingPerdValdtyEndQuarter,
  PeriodEndCalendarDate.CalendarMonth AS BindingPerdValdtyEndMonth,
  PeriodEndCalendarDate.CalendarWeek AS BindingPerdValdtyEndWeek,
  PeriodEndCalendarDate.CalendarDay AS BindingPerdValdtyEndDay,
  SDI._SalesDocument.HdrOrderProbabilityInPercent AS HdrOrderProbabilityInPercent,
  SDI.OutlineAgreementTargetAmount AS OutlineAgreementTargetAmount,
  SDI._SalesDocument.TransactionCurrency AS TransactionCurrency,
  SDI.InventorySpecialStockType AS InventorySpecialStockType,
  SDI.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  SDI.ProfitCenter AS ProfitCenter,
  SDI.WBSElement AS WBSElement,
  SDI.ControllingObject AS ControllingObject,
  SDI.ProfitabilitySegment AS ProfitabilitySegment,
  SDI.OriginSDDocument AS OriginSDDocument,
  SDI.OriginSDDocumentItem AS OriginSDDocumentItem,
  SDI._SalesDocument.ReferenceSDDocument AS SalesInquiry,
  SDI._SalesDocument.ReferenceSDDocumentCategory AS QuotationRefSDDocumentCategory,
  SDI.ReferenceSDDocumentItem AS SalesInquiryItem,
  SDI.ReferenceSDDocumentCategory AS ItemRefSDDocumentCategory,
  SDI.HigherLevelItem AS HigherLevelItem,
  SDI.SoldToParty AS SoldToParty,
  SDI._SoldToParty AS _SoldToParty,
  SDI.ResponsibleEmployee AS ResponsibleEmployeePersonnelID,
  SDI.SalesEmployee AS SalesEmployeePersonnelID,
  SDI.BillToParty AS BillToParty,
  SDI.PayerParty AS PayerParty,
  SDI.ShipToParty AS ShipToParty,
  SDI.Material AS Material,
  SDI._Material AS _Material,
  SDI.MaterialGroup AS MaterialGroup,
  SDI._MaterialGroup AS _MaterialGroup,
  SDI.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SDI._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  SDI.SDDocumentReason AS SDDocumentReason,
  SDI._SDDocumentReason AS _SDDocumentReason,
  SDI.SalesDocumentItemText AS SalesQuotationItemText,
  SDI.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SDI._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SDI.ItemWeightUnit AS ItemWeightUnit,
  SDI._ItemWeightUnit AS _ItemWeightUnit,
  SDI.ItemGrossWeight AS ItemGrossWeight,
  SDI.ItemNetWeight AS ItemNetWeight,
  SDI.ItemVolumeUnit AS ItemVolumeUnit,
  SDI._ItemVolumeUnit AS _ItemVolumeUnit,
  SDI.ItemVolume AS ItemVolume,
  SDI.NetAmount AS NetAmount,
  SDI.NetPriceAmount AS NetPriceAmount,
  SDI.NetPriceQuantity AS NetPriceQuantity,
  SDI.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SDI._NetPriceQuantityUnit AS _NetPriceQuantityUnit,
  SDI.StatisticalValueControl AS StatisticalValueControl,
  SDI._StatisticalValueControl AS _StatisticalValueControl,
  SDI.TaxAmount AS TaxAmount,
  SDI.CostAmount AS CostAmount,
  SDI.Subtotal1Amount AS Subtotal1Amount,
  SDI.Subtotal2Amount AS Subtotal2Amount,
  SDI.Subtotal3Amount AS Subtotal3Amount,
  SDI.Subtotal4Amount AS Subtotal4Amount,
  SDI.Subtotal5Amount AS Subtotal5Amount,
  SDI.Subtotal6Amount AS Subtotal6Amount,
  SDI.BaseUnit AS BaseUnit,
  SDI._BaseUnit AS _BaseUnit,
  SDI.TransactionCurrency AS ItemTransactionCurrency,
  SDI._TransactionCurrency AS _TransactionCurrency,
  cast(SDI.SDProcessStatus as sd_doc_process_status preserving type) AS SDProcessStatus,
  SDI._SDProcessStatus AS _SDProcessStatus,
  cast(SDI.DeliveryConfirmationStatus as delivery_confirmation_status preserving type) AS DeliveryConfirmationStatus,
  SDI._DeliveryConfirmationStatus AS _DeliveryConfirmationStatus,
  cast(SDI.PurchaseConfirmationStatus as purchase_confirmation_status preserving type) AS PurchaseConfirmationStatus,
  SDI._PurchaseConfirmationStatus AS _PurchaseConfirmationStatus,
  SDI.TotalDeliveryStatus AS TotalDeliveryStatus,
  SDI._TotalDeliveryStatus AS _TotalDeliveryStatus,
  SDI.DeliveryStatus AS DeliveryStatus,
  SDI._DeliveryStatus AS _DeliveryStatus,
  SDI.DeliveryBlockStatus AS DeliveryBlockStatus,
  SDI._DeliveryBlockStatus AS _DeliveryBlockStatus,
  SDI.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  SDI._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
  SDI.BillingBlockStatus AS BillingBlockStatus,
  SDI._BillingBlockStatus AS _BillingBlockStatus,
  cast(SDI.ItemGeneralIncompletionStatus as item_general_incompletion_sts preserving type) AS ItemGeneralIncompletionStatus,
  SDI._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  cast(SDI.ItemBillingIncompletionStatus as itms_incompltn_sts_billg preserving type) AS ItemBillingIncompletionStatus,
  SDI._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  cast(SDI.PricingIncompletionStatus as pricing_incompletion_status preserving type) AS PricingIncompletionStatus,
  SDI._PricingIncompletionStatus AS _PricingIncompletionStatus,
  cast(SDI.ItemDeliveryIncompletionStatus as itm_deliv_incompletion_status preserving type) AS ItemDeliveryIncompletionStatus,
  SDI._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  SDI.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  SDI._TotalSDDocReferenceStatus AS _TotalSDDocReferenceStatus,
  cast(SDI.OverallSDProcessStatus as overall_sd_process_status preserving type) AS OverallSDProcessStatus,
  SDI._OverallSDProcessStatus AS _OverallSDProcessStatus,
  cast(SDI.OverallSDDocumentRejectionSts as ovrl_sd_doc_rejection_status preserving type) AS OverallSDDocumentRejectionSts,
  SDI._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  cast(SDI.OverallSDDocReferenceStatus as ovrl_sd_doc_reference_status preserving type) AS OverallSDDocReferenceStatus,
  SDI._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  SDI.SalesQuotationQuantity AS SalesQuotationQuantity,
  SDI.SalesQuotationNetAmount AS SalesQuotationNetAmount,
  SDI.SlsQtanToOrdProbltyInPercent AS SlsQtanToOrdProbltyInPercent,
  SDI.CnvrtdSalesQuotationQuantity AS CnvrtdSalesQuotationQuantity,
  SDI.CnvrtdSalesQuotationNetAmount AS CnvrtdSalesQuotationNetAmount
FROM P_SLSDOCITMBSCDATA AS SDI
LEFT OUTER JOIN I_SalesQuotation AS _SalesQuotation ON SalesQuotation = _SalesQuotation.SalesQuotation  -- association [1..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployee ON ResponsibleEmployeePersonnelID = _ResponsibleEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _SalesEmployee ON SalesEmployeePersonnelID = _SalesEmployee.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON Material = _MaterialPlant.Material  -- association [0..*]
LEFT OUTER JOIN I_SalesInquiry AS _SalesInquiry ON SalesInquiry = _SalesInquiry.SalesInquiry AND ItemRefSDDocumentCategory = 'A'  -- association [0..1]
LEFT OUTER JOIN I_SalesInquiryItem AS _SalesInquiryItem ON SalesInquiryItem = _SalesInquiryItem.SalesInquiryItem AND SalesInquiry = _SalesInquiryItem.SalesInquiry AND ItemRefSDDocumentCategory = 'A'  -- association [0..1]
;