C_ESJIQuotationQuery
Quotation
C_ESJIQuotationQuery is a Consumption CDS View that provides data about "Quotation" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocument, I_SDDocStandardPartner) and exposes 88 fields with key field SalesQuotation. It has 2 associations to related views.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesDocument | SalesDocument | from |
| I_SDDocStandardPartner | StandardPartner | left_outer |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_Language | sylangu |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | C_ESJIQuotationItemQuery | _ESJIQuotationItemQuery | $projection.SalesQuotation = _ESJIQuotationItemQuery.SalesQuotation |
| [0..1] | C_ESJIMaxDelivCreationDate | _MaxDelivCreationDate | $projection.SalesQuotation = _MaxDelivCreationDate.SalesDocument |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Quotation | view | |
| AbapCatalog.sqlViewName | CESJIQUOTATION | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view |
Fields (88)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesQuotation | SalesDocument | SD Document | |
| ObjectType | ||||
| SalesQuotationType | SalesDocumentType | Sales Doc. Type | ||
| SalesQuotationTypeName | ||||
| CreatedByUser | CreatedByUser | User Name | ||
| CreationDate | CreationDate | Time Stamp | ||
| CreationTime | CreationTime | Time of Change | ||
| LastChangeDate | LastChangeDate | Time Stamp | ||
| SalesOrganization | SalesOrganization | Sales Organization | ||
| SalesOrganizationName | ||||
| DistributionChannel | DistributionChannel | RefDistCh-Cust/Mat. | ||
| DistributionChannelName | ||||
| OrganizationDivision | OrganizationDivision | Org. Division | ||
| DivisionName | ||||
| SalesGroup | SalesGroup | Sales Group | ||
| SalesOffice | SalesOffice | Sales Office | ||
| SoldToParty | I_SalesDocument | SoldToParty | Sold-to Party | |
| SoldToPartyName | ||||
| SalesQuotationDate | SalesDocumentDate | Document Date | ||
| SDDocumentReason | SDDocumentReason | Order Reason | ||
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | Purchase Order Number | ||
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | Purchase Order Date | ||
| TotalNetAmount | TotalNetAmount | Total Net Amount | ||
| TransactionCurrency | TransactionCurrency | Transaction Currency | ||
| PricingDate | PricingDate | Pricing Date | ||
| RequestedDeliveryDate | RequestedDeliveryDate | Requested Delivery Date | ||
| DeliveryCreationDate | _MaxDelivCreationDate | DeliveryCreationDate | Delivery Date | |
| ShippingType | ShippingType | Shipping Type | ||
| ShippingCondition | ShippingCondition | Shipping Conditions | ||
| IncotermsClassification | IncotermsClassification | Incoterms | ||
| IncotermsClassificationName | ||||
| IncotermsTransferLocation | IncotermsTransferLocation | Incoterms 2 | ||
| CompleteDeliveryIsDefined | CompleteDeliveryIsDefined | Complete Dlv. | ||
| DeliveryBlockReason | DeliveryBlockReason | Delivery Block | ||
| HeaderBillingBlockReason | HeaderBillingBlockReason | Billing Block | ||
| CustomerPaymentTerms | CustomerPaymentTerms | Pyt Terms | ||
| CustomerPaymentTermsName | ||||
| BusinessArea | BusinessArea | Business Area | ||
| ValidityStartDate | I_SalesDocument | BindingPeriodValidityStartDate | ||
| ValidityEndDate | I_SalesDocument | BindingPeriodValidityEndDate | Binding Period | |
| ShipToParty | I_SDDocStandardPartner | ShipToParty | Ship-To Party (obsolete) | |
| ShipToPartyName | ||||
| ResponsibleEmployee | I_SDDocStandardPartner | ResponsibleEmployee | Employee Resp. | |
| ResponsibleEmployeeName | ||||
| SalesEmployee | I_SDDocStandardPartner | SalesEmployee | Sales Employee | |
| SalesEmployeeName | ||||
| OverallSDProcessStatus | OverallSDProcessStatus | |||
| OverallSDProcessStatusDesc | ||||
| OverallSDDocumentRejectionSts | OverallSDDocumentRejectionSts | |||
| OvrlSDDocumentRejectionStsDesc | ||||
| TotalBlockStatus | TotalBlockStatus | |||
| TotalBlockStatusDesc | ||||
| OverallDelivConfStatus | OverallDelivConfStatus | |||
| OverallTotalDeliveryStatus | OverallTotalDeliveryStatus | |||
| OverallTotalDeliveryStatusDesc | ||||
| OverallDeliveryStatus | OverallDeliveryStatus | |||
| OverallDeliveryStatusDesc | ||||
| OverallDeliveryBlockStatus | OverallDeliveryBlockStatus | |||
| OverallDelivBlockStatusDesc | ||||
| OverallBillingBlockStatus | OverallBillingBlockStatus | |||
| OverallBillingBlockStatusDesc | ||||
| OverallTotalSDDocRefStatus | OverallTotalSDDocRefStatus | |||
| TotalCreditCheckStatus | TotalCreditCheckStatus | |||
| TotalCreditCheckStatusDesc | ||||
| _Partner | _Partner | |||
| _SalesDocumentType | _SalesDocumentType | |||
| _CreatedByUser | _CreatedByUser | |||
| _SalesOrganization | _SalesOrganization | |||
| _DistributionChannel | _DistributionChannel | |||
| _OrganizationDivision | _OrganizationDivision | |||
| _SoldToParty | I_SalesDocument | _SoldToParty | ||
| _SDDocumentReason | _SDDocumentReason | |||
| _TransactionCurrency | _TransactionCurrency | |||
| _ShippingType | _ShippingType | |||
| _ShippingCondition | _ShippingCondition | |||
| _IncotermsClassification | _IncotermsClassification | |||
| _DeliveryBlockReason | _DeliveryBlockReason | |||
| _HeaderBillingBlockReason | _HeaderBillingBlockReason | |||
| _CustomerPaymentTerms | _CustomerPaymentTerms | |||
| _OverallSDProcessStatus | _OverallSDProcessStatus | |||
| _OverallSDDocumentRejectionSts | _OverallSDDocumentRejectionSts | |||
| _TotalBlockStatus | _TotalBlockStatus | |||
| _OverallTotalDeliveryStatus | _OverallTotalDeliveryStatus | |||
| _OverallDeliveryStatus | _OverallDeliveryStatus | |||
| _OverallDeliveryBlockStatus | _OverallDeliveryBlockStatus | |||
| _TotalCreditCheckStatus | _TotalCreditCheckStatus | |||
| _OverallBillingBlockStatus | _OverallBillingBlockStatus | |||
| _ESJIQuotationItemQuery | _ESJIQuotationItemQuery |
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 C_ESJIQuotationQuery.
-- 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: CESJIQUOTATION
-- Parameters: P_Language : sylangu
CREATE VIEW C_ESJIQuotationQuery AS
SELECT
SalesDocument AS SalesQuotation,
'BUS2031' AS ObjectType,
SalesDocumentType AS SalesQuotationType,
_SalesDocumentType._Text[1: Language=$parameters.P_Language].SalesDocumentTypeName AS SalesQuotationTypeName,
CreatedByUser,
CreationDate,
CreationTime,
LastChangeDate,
SalesOrganization,
_SalesOrganization._Text[1: Language=$parameters.P_Language].SalesOrganizationName AS SalesOrganizationName,
DistributionChannel,
_DistributionChannel._Text[1: Language=$parameters.P_Language].DistributionChannelName AS DistributionChannelName,
OrganizationDivision,
_OrganizationDivision._Text[1: Language=$parameters.P_Language].DivisionName AS DivisionName,
SalesGroup,
SalesOffice,
SalesDocument.SoldToParty AS SoldToParty,
SalesDocument._SoldToParty.CustomerName AS SoldToPartyName,
SalesDocumentDate AS SalesQuotationDate,
SDDocumentReason,
PurchaseOrderByCustomer,
CustomerPurchaseOrderDate,
TotalNetAmount,
TransactionCurrency,
PricingDate,
RequestedDeliveryDate,
_MaxDelivCreationDate.DeliveryCreationDate AS DeliveryCreationDate,
ShippingType,
ShippingCondition,
IncotermsClassification,
_IncotermsClassification._Text[1: Language=$parameters.P_Language].IncotermsClassificationName AS IncotermsClassificationName,
IncotermsTransferLocation,
CompleteDeliveryIsDefined,
DeliveryBlockReason,
HeaderBillingBlockReason,
CustomerPaymentTerms,
_CustomerPaymentTerms._Text[1: Language=$parameters.P_Language].CustomerPaymentTermsName AS CustomerPaymentTermsName,
BusinessArea,
SalesDocument.BindingPeriodValidityStartDate AS ValidityStartDate,
SalesDocument.BindingPeriodValidityEndDate AS ValidityEndDate,
StandardPartner.ShipToParty AS ShipToParty,
StandardPartner._ShipToParty.CustomerName AS ShipToPartyName,
StandardPartner.ResponsibleEmployee AS ResponsibleEmployee,
StandardPartner._ResponsibleEmployee.PersonFullName AS ResponsibleEmployeeName,
StandardPartner.SalesEmployee AS SalesEmployee,
StandardPartner._SalesEmployee.PersonFullName AS SalesEmployeeName,
OverallSDProcessStatus,
_OverallSDProcessStatus._Text[1: Language=$parameters.P_Language].OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
OverallSDDocumentRejectionSts,
_OverallSDDocumentRejectionSts._Text[1: Language=$parameters.P_Language].OvrlSDDocumentRejectionStsDesc AS OvrlSDDocumentRejectionStsDesc,
TotalBlockStatus,
_TotalBlockStatus._Text[1: Language=$parameters.P_Language].TotalBlockStatusDesc AS TotalBlockStatusDesc,
OverallDelivConfStatus,
OverallTotalDeliveryStatus,
_OverallTotalDeliveryStatus._Text[1: Language=$parameters.P_Language].OverallTotalDeliveryStatusDesc AS OverallTotalDeliveryStatusDesc,
OverallDeliveryStatus,
_OverallDeliveryStatus._Text[1: Language=$parameters.P_Language].OverallDeliveryStatusDesc AS OverallDeliveryStatusDesc,
OverallDeliveryBlockStatus,
_OverallDeliveryBlockStatus._Text[1: Language=$parameters.P_Language].OverallDelivBlockStatusDesc AS OverallDelivBlockStatusDesc,
OverallBillingBlockStatus,
_OverallBillingBlockStatus._Text[1: Language=$parameters.P_Language].OverallBillingBlockStatusDesc AS OverallBillingBlockStatusDesc,
OverallTotalSDDocRefStatus,
TotalCreditCheckStatus,
_TotalCreditCheckStatus._Text[1: Language=$parameters.P_Language].TotalCreditCheckStatusDesc AS TotalCreditCheckStatusDesc,
SalesDocument._SoldToParty AS _SoldToParty
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_SDDocStandardPartner AS StandardPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_ESJIQuotationItemQuery AS _ESJIQuotationItemQuery ON SalesQuotation = _ESJIQuotationItemQuery.SalesQuotation -- association [0..*]
LEFT OUTER JOIN C_ESJIMaxDelivCreationDate AS _MaxDelivCreationDate ON SalesQuotation = _MaxDelivCreationDate.SalesDocument -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA