C_ESJIQuotationItemQuery

DDL: C_ESJIQUOTATIONITEMQUERY SQL: CESJIQUOTITEMQ Type: view CONSUMPTION

Quotation Item

C_ESJIQuotationItemQuery is a Consumption CDS View that provides data about "Quotation Item" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 59 fields with key fields SalesQuotation, SalesQuotationItem.

1 data source(s) 59 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItem SalesDocumentItem from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (6)

NameValueLevelField
EndUserText.label Quotation Item view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CESJIQUOTITEMQ view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesDocument
KEY SalesQuotationItem SalesDocumentItem
ObjectType
SalesQuotationType
SalesQuotationItemCategory SalesDocumentItemCategory
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
Material Material
ProductionPlant Plant
SalesQuotationItemText SalesDocumentItemText
OrderQuantity OrderQuantity
ConfdDelivQtyInOrderQtyUnit ConfdDelivQtyInOrderQtyUnit
OrderQuantityUnit OrderQuantityUnit
BaseUnit BaseUnit
OrderToBaseQuantityDnmntr OrderToBaseQuantityDnmntr
OrderToBaseQuantityNmrtr OrderToBaseQuantityNmrtr
SalesDocumentRjcnReason SalesDocumentRjcnReason
SalesDocumentRjcnReasonName
NetAmount NetAmount
PricingDate PricingDate
NetPriceAmount NetPriceAmount
NetPriceQuantity NetPriceQuantity
NetPriceQuantityUnit NetPriceQuantityUnit
TaxAmount TaxAmount
TransactionCurrency TransactionCurrency
ShippingPoint ShippingPoint
ShippingType ShippingType
DeliveryPriority DeliveryPriority
PartialDeliveryIsAllowed PartialDeliveryIsAllowed
IncotermsClassification IncotermsClassification
IncotermsTransferLocation IncotermsTransferLocation
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct
BillingDocumentDate BillingDocumentDate
ItemBillingBlockReason ItemBillingBlockReason
ItemIsBillingRelevant ItemIsBillingRelevant
CustomerPaymentTerms CustomerPaymentTerms
BusinessArea BusinessArea
WBSElement WBSElement
DeliveryStatus DeliveryStatus
SDDocumentRejectionStatus SDDocumentRejectionStatus
RequestedDeliveryDate _SOItemDeliveryDate RequestedDeliveryDate
_Partner _Partner
_CreatedByUser _CreatedByUser
_Material _Material
_OrderQuantityUnit _OrderQuantityUnit
_BaseUnit _BaseUnit
_NetPriceQuantityUnit _NetPriceQuantityUnit
_TransactionCurrency _TransactionCurrency
_ShippingType _ShippingType
_IncotermsClassification _IncotermsClassification
_ItemBillingBlockReason _ItemBillingBlockReason
_CustomerPaymentTerms _CustomerPaymentTerms
_DeliveryStatus _DeliveryStatus
_SDDocumentRejectionStatus _SDDocumentRejectionStatus
DeliveryStatusDescription
SDDocumentRejectionStatusDesc 
@EndUserText.label: 'Quotation Item'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CESJIQUOTITEMQ'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
define view C_ESJIQuotationItemQuery
with parameters
    P_Language : sylangu
as select from 
I_SalesDocumentItem as SalesDocumentItem

association[0..1] to C_ESJISOScheduleLineDelivDate as _SOItemDeliveryDate    on $projection.SalesQuotation = _SOItemDeliveryDate.SalesOrder and $projection.SalesQuotationItem = _SOItemDeliveryDate.SalesOrderItem

{
    // Key

    key SalesDocument as SalesQuotation,
    key SalesDocumentItem as SalesQuotationItem,

    'BUS2031' as ObjectType,
    SalesDocumentItem._SalesDocument.SalesDocumentType as SalesQuotationType,

    // Category

    SalesDocumentItemCategory as SalesQuotationItemCategory,

    // Admin

    CreatedByUser,
    @Semantics.businessDate.createdAt: true
    CreationDate,
    CreationTime,
    @Semantics.businessDate.lastChangedAt: true
    LastChangeDate,

    // Product

    Material,
    Plant    as  ProductionPlant,

    // Sales

    SalesDocumentItemText as SalesQuotationItemText,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
    OrderQuantity,
    @DefaultAggregation: #SUM
    @Semantics.quantity.unitOfMeasure: 'OrderQuantityUnit'
    ConfdDelivQtyInOrderQtyUnit,
    @Semantics.unitOfMeasure: true
    OrderQuantityUnit,
    @Semantics.unitOfMeasure: true
    BaseUnit,
    OrderToBaseQuantityDnmntr,
    OrderToBaseQuantityNmrtr,
    SalesDocumentRjcnReason,
    _SalesDocumentRjcnReason._Text[1: Language=$parameters.P_Language].SalesDocumentRjcnReasonName,

//    _SalesDocumentData.vkorg as SalesOrganization,

//    _SalesDocumentData.vtweg as DistributionChannel,

//    _SalesDocumentData.spart as OrganizationDivision,


    // Pricing

    @DefaultAggregation: #SUM
    @Semantics.amount.currencyCode: 'TransactionCurrency'
    NetAmount,
    PricingDate,
    @DefaultAggregation: #NONE
    @Semantics.amount.currencyCode: 'TransactionCurrency'
    NetPriceAmount,
    @DefaultAggregation: #NONE
    @Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
    NetPriceQuantity,
    @Semantics.unitOfMeasure: true
    NetPriceQuantityUnit,
    @DefaultAggregation: #SUM
    @Semantics.amount.currencyCode: 'TransactionCurrency'
    TaxAmount,
    @Semantics.currencyCode: true
    TransactionCurrency,

    //Shipping

    ShippingPoint,
    ShippingType,
    DeliveryPriority,
    PartialDeliveryIsAllowed,
    IncotermsClassification,
    IncotermsTransferLocation,
    UnderdelivTolrtdLmtRatioInPct,
    OverdelivTolrtdLmtRatioInPct,

    //Billing

    BillingDocumentDate,
    ItemBillingBlockReason,
    ItemIsBillingRelevant,

    //Payment

    CustomerPaymentTerms,
    BusinessArea,
    WBSElement,

    //Status

    DeliveryStatus,
    SDDocumentRejectionStatus,

    _SOItemDeliveryDate.RequestedDeliveryDate,

    _Partner,
    _CreatedByUser,
    _Material,
    _OrderQuantityUnit,
    _BaseUnit,
    _NetPriceQuantityUnit,
    _TransactionCurrency,
    _ShippingType,
    _IncotermsClassification,
    _ItemBillingBlockReason,
    _CustomerPaymentTerms,

    _DeliveryStatus,
    _SDDocumentRejectionStatus,

    _DeliveryStatus._Text[1: Language=$parameters.P_Language].DeliveryStatusDescription as DeliveryStatusDescription,
    _SDDocumentRejectionStatus._Text[1: Language=$parameters.P_Language].SDDocumentRejectionStatusDesc as SDDocumentRejectionStatusDesc
}
where SalesDocumentItem._SalesDocument.SDDocumentCategory = 'B';
                                                                       
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_ESJISOSCHEDULELINEDELIVDATE",
"I_DELIVERYSTATUS",
"I_DELIVERYSTATUSTEXT",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTRJCNREASON",
"I_SALESDOCUMENTRJCNREASONTEXT",
"I_SDDOCUMENTREJECTIONSTATUS",
"I_SDDOCUMENTREJECTIONSTATUST"
],
"ASSOCIATED":
[
"C_ESJISOSCHEDULELINEDELIVDATE",
"I_BILLINGBLOCKREASON",
"I_CURRENCY",
"I_CUSTOMERPAYMENTTERMS",
"I_DELIVERYSTATUS",
"I_INCOTERMSCLASSIFICATION",
"I_MATERIAL",
"I_SALESDOCUMENTITEMPARTNER",
"I_SDDOCUMENTREJECTIONSTATUS",
"I_SHIPPINGTYPE",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_SALESDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More