I_SalesQuotationEnhanced

DDL: I_SALESQUOTATIONENHANCED SQL: ISQENHANCED Type: view COMPOSITE
57 Fields 1 Data Sources 1 Associations

Sales Quotation Enhanced (API)

I_SalesQuotationEnhanced is a Composite CDS View that provides data about "Sales Quotation Enhanced (API)" in SAP S/4HANA. It reads from 1 data source (I_SalesQuotation) and exposes 57 fields with key field SalesQuotation. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesQuotation SalesQuotation from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ExpectedOrderNetAmount _ExpectOrdNetAmount $projection.SalesQuotation = _ExpectOrdNetAmount.SalesDocument

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISQENHANCED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Quotation Enhanced (API) view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesQuotation
SalesQuotationType SalesQuotationType Sales Doc. Type
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SalesDistrict SalesDistrict Sales District
SoldToParty SoldToParty Sold-to Party
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderType CustomerPurchaseOrderType
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
SalesQuotationDate SalesQuotationDate Document Date
TotalNetAmount TotalNetAmount Total Net Amount
TransactionCurrency TransactionCurrency Transaction Currency
SDDocumentReason SDDocumentReason Order Reason
PricingDate PricingDate Pricing Date
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
ShippingCondition ShippingCondition Shipping Conditions
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
ShippingType ShippingType Shipping Type
HeaderBillingBlockReason HeaderBillingBlockReason Billing Block
SalesQuotationApprovalReason SalesQuotationApprovalReason
DeliveryBlockReason DeliveryBlockReason Delivery Block
BindingPeriodValidityStartDate BindingPeriodValidityStartDate
BindingPeriodValidityEndDate BindingPeriodValidityEndDate Binding Period
HdrOrderProbabilityInPercent HdrOrderProbabilityInPercent
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentCategory ReferenceSDDocumentCategory Prec.Doc.Categ.
ExpectedOrderNetAmount _ExpectOrdNetAmount ExpectedOrderNetAmount
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IncotermsVersion IncotermsVersion Inco. Version
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
CustomerPriceGroup CustomerPriceGroup CustPrice Group
PriceListType PriceListType Price List Tp.
PaymentMethod PaymentMethod Pymt Meth.
CustomerTaxClassification1 I_SalesQuotation CustomerTaxClassification1
CustomerTaxClassification2 I_SalesQuotation CustomerTaxClassification2
CustomerTaxClassification3 I_SalesQuotation CustomerTaxClassification3
CustomerTaxClassification4 I_SalesQuotation CustomerTaxClassification4
CustomerTaxClassification5 I_SalesQuotation CustomerTaxClassification5
CustomerTaxClassification6 I_SalesQuotation CustomerTaxClassification6
CustomerTaxClassification7 I_SalesQuotation CustomerTaxClassification7
CustomerTaxClassification8 I_SalesQuotation CustomerTaxClassification8
CustomerTaxClassification9 I_SalesQuotation CustomerTaxClassification9
OverallSDProcessStatus OverallSDProcessStatus
TotalCreditCheckStatus TotalCreditCheckStatus
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts
SalesDocApprovalStatus SalesDocApprovalStatus

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_SalesQuotationEnhanced.
-- 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: ISQENHANCED

CREATE VIEW I_SalesQuotationEnhanced AS
SELECT
  SalesQuotation,
  SalesQuotationType,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SalesDistrict,
  SoldToParty,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  LastChangeDateTime,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderType,
  CustomerPurchaseOrderDate,
  SalesQuotationDate,
  TotalNetAmount,
  TransactionCurrency,
  SDDocumentReason,
  PricingDate,
  RequestedDeliveryDate,
  ShippingCondition,
  CompleteDeliveryIsDefined,
  ShippingType,
  HeaderBillingBlockReason,
  SalesQuotationApprovalReason,
  DeliveryBlockReason,
  BindingPeriodValidityStartDate,
  BindingPeriodValidityEndDate,
  HdrOrderProbabilityInPercent,
  ReferenceSDDocument,
  ReferenceSDDocumentCategory,
  _ExpectOrdNetAmount.ExpectedOrderNetAmount AS ExpectedOrderNetAmount,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  CustomerPaymentTerms,
  CustomerPriceGroup,
  PriceListType,
  PaymentMethod,
  SalesQuotation.CustomerTaxClassification1 AS CustomerTaxClassification1,
  SalesQuotation.CustomerTaxClassification2 AS CustomerTaxClassification2,
  SalesQuotation.CustomerTaxClassification3 AS CustomerTaxClassification3,
  SalesQuotation.CustomerTaxClassification4 AS CustomerTaxClassification4,
  SalesQuotation.CustomerTaxClassification5 AS CustomerTaxClassification5,
  SalesQuotation.CustomerTaxClassification6 AS CustomerTaxClassification6,
  SalesQuotation.CustomerTaxClassification7 AS CustomerTaxClassification7,
  SalesQuotation.CustomerTaxClassification8 AS CustomerTaxClassification8,
  SalesQuotation.CustomerTaxClassification9 AS CustomerTaxClassification9,
  OverallSDProcessStatus,
  TotalCreditCheckStatus,
  OverallSDDocumentRejectionSts,
  SalesDocApprovalStatus
FROM I_SalesQuotation AS SalesQuotation
LEFT OUTER JOIN I_ExpectedOrderNetAmount AS _ExpectOrdNetAmount ON SalesQuotation = _ExpectOrdNetAmount.SalesDocument  -- association [0..1]
;

Learn More