R_SalesQuotationTP

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 R_SalesQuotationTP.
-- 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.

CREATE VIEW R_SalesQuotationTP AS
SELECT
  SalesQuotation.SalesQuotation AS SalesQuotation,
  SalesQuotation.SalesQuotationType AS SalesQuotationType,
  _SoldToParty.FullName AS CustomerName,
  _SoldToParty.AddressID AS SoldToPartyAddressID,
  SalesQuotation.SalesOrganization AS SalesOrganization,
  SalesQuotation.DistributionChannel AS DistributionChannel,
  _SlsOrganizationDistrChnl.ReferenceDistributionChannel AS ReferenceDistributionChannel,
  SalesQuotation.OrganizationDivision AS OrganizationDivision,
  SalesQuotation.SalesOffice AS SalesOffice,
  SalesQuotation.SalesGroup AS SalesGroup,
  SalesQuotation.SoldToParty AS SoldToParty,
  SalesQuotation.SalesDistrict AS SalesDistrict,
  SalesQuotation.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesQuotation.SalesQuotationDate AS SalesQuotationDate,
  SalesQuotation.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SalesQuotation.CustomerGroup AS CustomerGroup,
  SalesQuotation.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SalesQuotation.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SalesQuotation.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SalesQuotation.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SalesQuotation.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SalesQuotation.ControllingArea AS ControllingArea,
  SalesQuotation.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
  SalesQuotation.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
  SalesQuotation.HdrOrderProbabilityInPercent AS HdrOrderProbabilityInPercent,
  SalesQuotation.TotalNetAmount AS TotalNetAmount,
  SalesQuotation.TransactionCurrency AS TransactionCurrency,
  SalesQuotation.PricingDate AS PricingDate,
  SalesQuotation.CustomerPriceGroup AS CustomerPriceGroup,
  SalesQuotation.SDPricingProcedure AS SDPricingProcedure,
  SalesQuotation.CreationDate AS CreationDate,
  SalesQuotation.CreatedByUser AS CreatedByUser,
  SalesQuotation.LastChangedByUser AS LastChangedByUser,
  SalesQuotation.CreationTime AS CreationTime,
  SalesQuotation.RequestedDeliveryDate AS RequestedDeliveryDate,
  SalesQuotation.IncotermsVersion AS IncotermsVersion,
  SalesQuotation.IncotermsClassification AS IncotermsClassification,
  SalesQuotation.IncotermsLocation1 AS IncotermsLocation1,
  SalesQuotation.IncotermsLocation2 AS IncotermsLocation2,
  SalesQuotation.ShippingCondition AS ShippingCondition,
  SalesQuotation.ShippingType AS ShippingType,
  SalesQuotation.BillingDocumentDate AS BillingDocumentDate,
  SalesQuotation.ReferenceSDDocument AS ReferenceSDDocument,
  SalesQuotation.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesQuotation.CustomerCreditAccount AS CustomerCreditAccount,
  SalesQuotation.SDDocumentReason AS SDDocumentReason,
  SalesQuotation.SalesQuotationApprovalReason AS SalesQuotationApprovalReason,
  SalesQuotation.SalesDocApprovalStatus AS SalesDocApprovalStatus,
  SalesQuotation.OverallSDProcessStatus AS OverallSDProcessStatus,
  cast(SalesQuotation.HdrGeneralIncompletionStatus as hdr_general_incompltn_status preserving type ) AS HdrGeneralIncompletionStatus,
  cast(SalesQuotation.OvrlItmGeneralIncompletionSts as itms_ovrl_incompletion_status preserving type ) AS OvrlItmGeneralIncompletionSts,
  SalesQuotation.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
  SalesQuotation.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
  SalesQuotation.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  SalesQuotation.OverallChmlCmplncStatus AS OverallChmlCmplncStatus,
  SalesQuotation.OverallDangerousGoodsStatus AS OverallDangerousGoodsStatus,
  SalesQuotation.OverallSafetyDataSheetStatus AS OverallSafetyDataSheetStatus,
  SalesQuotation.OverallTrdCmplncEmbargoSts AS OverallTrdCmplncEmbargoSts,
  SalesQuotation.PaymentMethod AS PaymentMethod,
  SalesQuotation.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesQuotation.BillingCompanyCode AS BillingCompanyCode,
  SalesQuotation.LastChangeDate AS LastChangeDate,
  OutputRequest.OutputRequestUUID AS OutputRequestUUID,
  SalesQuotation._SalesQuotationType AS _SalesQuotationType,
  SalesQuotation._SalesOrganization AS _SalesOrganization,
  SalesQuotation._DistributionChannel AS _DistributionChannel,
  SalesQuotation._OrganizationDivision AS _OrganizationDivision,
  SalesQuotation._SalesOffice AS _SalesOffice,
  SalesQuotation._SalesGroup AS _SalesGroup,
  SalesQuotation._SalesDistrict AS _SalesDistrict,
  SalesQuotation._ShippingCondition AS _ShippingCondition,
  SalesQuotation._ShippingType AS _ShippingType,
  SalesQuotation._ControllingArea AS _ControllingArea,
  SalesQuotation._IncotermsVersion AS _IncotermsVersion,
  SalesQuotation._IncotermsClassification AS _IncotermsClassification,
  SalesQuotation._SDDocumentReason AS _SDDocumentReason,
  SalesQuotation._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  SalesQuotation._TransactionCurrency AS _TransactionCurrency,
  SalesQuotation._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesQuotation._CustomerGroup AS _CustomerGroup,
  SalesQuotation._CustomerPriceGroup AS _CustomerPriceGroup,
  SalesQuotation._SDPricingProcedure AS _SDPricingProcedure,
  SalesQuotation._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  SalesQuotation._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  SalesQuotation._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  SalesQuotation._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  SalesQuotation._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  SalesQuotation._LastChangedByUser AS _LastChangedByUser,
  SalesQuotation._CreatedByUser AS _CreatedByUser,
  SalesQuotation._CustomerCreditAccount AS _CustomerCreditAccount,
  SalesQuotation._SalesQuotationApprovalReason AS _SalesQuotationApprovalReason,
  SalesQuotation._SalesDocApprovalStatus AS _SalesDocApprovalStatus,
  SalesQuotation._OverallSDProcessStatus AS _OverallSDProcessStatus,
  SalesQuotation._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
  SalesQuotation._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
  SalesQuotation._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
  SalesQuotation._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
  SalesQuotation._TotalCreditCheckStatus AS _TotalCreditCheckStatus,
  SalesQuotation._OverallChmlCmplncStatus AS _OverallChmlCmplncStatus,
  SalesQuotation._OverallDangerousGoodsStatus AS _OverallDangerousGoodsStatus,
  SalesQuotation._OvrlSftyDataSheetSts AS _OvrlSftyDataSheetSts,
  SalesQuotation._OvrlTradeCmplncEmbargoStatus AS _OvrlTradeCmplncEmbargoStatus
FROM I_SalesQuotation AS SalesQuotation
LEFT OUTER JOIN R_OutputRequestTP AS _OutputRequest ON OutputRequestUUID = _OutputRequest.OutputRequestUUID  -- association [0..1]
LEFT OUTER JOIN I_SalesQuotationPartner AS _SoldToParty ON SalesQuotation = _SoldToParty.SalesQuotation AND _SoldToParty.PartnerFunction = 'AG'  -- association [0..1]
LEFT OUTER JOIN I_SlsOrganizationDistrChnl AS _SlsOrganizationDistrChnl ON SalesOrganization = _SlsOrganizationDistrChnl.SalesOrganization AND DistributionChannel = _SlsOrganizationDistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesQuotation = _Extension.SalesDocument  -- association [1]
LEFT OUTER JOIN R_SalesQuotationItemTP AS _Item ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesQuotationPartnerTP AS _Partner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesQuotationTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SlsQuotationPricingElementTP AS _PricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SalesQuotationShipToPartyTP AS _ShipToParty ON /* condition not available in parsed metadata */  -- association [0..1]
;