I_SalesQuotation

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 I_SalesQuotation.
-- 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 I_SalesQuotation AS
SELECT
  cast(SalesDocument as sales_quotation preserving type ) AS SalesQuotation,
  SalesDocumentType AS SalesQuotationType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CreditControlArea,
  CustomerRebateAgreement,
  SalesDocumentDate AS SalesQuotationDate,
  ServicesRenderedDate,
  SDDocumentReason,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderSuplmnt,
  SalesDistrict,
  ProductCatalog,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  HdrOrderProbabilityInPercent,
  TotalNetAmount,
  TransactionCurrency,
  PricingDate,
  RetailPromotion,
  PriceDetnExchangeRate,
  SalesDocumentCondition AS SalesQuotationCondition,
  SDPricingProcedure,
  RequestedDeliveryDate,
  ShippingType,
  ShippingCondition,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  CustomerPriceGroup,
  PriceListType,
  CompleteDeliveryIsDefined,
  DeliveryBlockReason,
  SalesDocApprovalReason AS SalesQuotationApprovalReason,
  BillingDocumentDate,
  BillingCompanyCode,
  HeaderBillingBlockReason,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  AdditionalValueDays,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  FiscalYear,
  FiscalPeriod,
  ExchangeRateDate,
  ExchangeRateType,
  BusinessArea,
  CustomerAccountAssignmentGroup,
  CostCenterBusinessArea,
  CostCenter,
  ControllingArea,
  OrderID,
  CustomerCreditAccount,
  ReferenceSDDocument,
  ReferenceSDDocumentCategory,
  OverallSDProcessStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallBillingBlockStatus,
  OverallTotalSDDocRefStatus,
  OverallSDDocReferenceStatus,
  TotalCreditCheckStatus,
  MaxDocValueCreditCheckStatus,
  PaymentTermCreditCheckStatus,
  FinDocCreditCheckStatus,
  ExprtInsurCreditCheckStatus,
  PaytAuthsnCreditCheckSts,
  CentralCreditCheckStatus,
  CentralCreditChkTechErrSts,
  HdrGeneralIncompletionStatus,
  OverallPricingIncompletionSts,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmBillingIncompletionSts,
  SalesDocApprovalStatus,
  OverallChmlCmplncStatus,
  OverallDangerousGoodsStatus,
  OverallSafetyDataSheetStatus,
  OverallTrdCmplncEmbargoSts
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _CostCenterBusinessAreaText ON CostCenterBusinessArea = _CostCenterBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_CreditControlAreaText AS _CreditControlAreaText ON CreditControlArea = _CreditControlAreaText.CreditControlArea  -- association [0..*]
LEFT OUTER JOIN I_SalesQuotationItem AS _Item ON SalesQuotation = _Item.SalesQuotation  -- association [0..*]
LEFT OUTER JOIN I_SalesQuotationType AS _SalesQuotationType ON SalesQuotationType = _SalesQuotationType.SalesQuotationType  -- association [0..1]
LEFT OUTER JOIN I_SalesQuotationPartner AS _Partner ON SalesQuotation = _Partner.SalesQuotation  -- association [1..*]
LEFT OUTER JOIN I_SalesQuotationPrcgElmnt AS _PricingElement ON SalesQuotation = _PricingElement.SalesQuotation  -- association [0..*]
LEFT OUTER JOIN I_SlsQtanApprovalReason AS _SalesQuotationApprovalReason ON SalesQuotationApprovalReason = _SalesQuotationApprovalReason.SalesQuotationApprovalReason  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;