C_ESJIQuotationQuery

DDL: C_ESJIQUOTATIONQUERY SQL: CESJIQUOTATION Type: view CONSUMPTION

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.

2 data source(s) 88 fields

Data Sources (2)

SourceAliasJoin Type
I_SalesDocument SalesDocument from
I_SDDocStandardPartner StandardPartner left_outer

Parameters (1)

NameTypeDefault
P_Language sylangu

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_ESJIQuotationItemQuery _ESJIQuotationItemQuery $projection.SalesQuotation = _ESJIQuotationItemQuery.SalesQuotation
[0..1] C_ESJIMaxDelivCreationDate _MaxDelivCreationDate $projection.SalesQuotation = _MaxDelivCreationDate.SalesDocument

Annotations (7)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesDocument
ObjectType
SalesQuotationType SalesDocumentType
SalesQuotationTypeName
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
LastChangeDate LastChangeDate
SalesOrganization SalesOrganization
SalesOrganizationName
DistributionChannel DistributionChannel
DistributionChannelName
OrganizationDivision OrganizationDivision
DivisionName
SalesGroup SalesGroup
SalesOffice SalesOffice
SoldToParty I_SalesDocument SoldToParty
SoldToPartyName
SalesQuotationDate SalesDocumentDate
SDDocumentReason SDDocumentReason
PurchaseOrderByCustomer PurchaseOrderByCustomer
CustomerPurchaseOrderDate CustomerPurchaseOrderDate
TotalNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
PricingDate PricingDate
RequestedDeliveryDate RequestedDeliveryDate
DeliveryCreationDate _MaxDelivCreationDate DeliveryCreationDate
ShippingType ShippingType
ShippingCondition ShippingCondition
IncotermsClassification IncotermsClassification
IncotermsClassificationName
IncotermsTransferLocation IncotermsTransferLocation
CompleteDeliveryIsDefined CompleteDeliveryIsDefined
DeliveryBlockReason DeliveryBlockReason
HeaderBillingBlockReason HeaderBillingBlockReason
CustomerPaymentTerms CustomerPaymentTerms
CustomerPaymentTermsName
BusinessArea BusinessArea
ValidityStartDate I_SalesDocument BindingPeriodValidityStartDate
ValidityEndDate I_SalesDocument BindingPeriodValidityEndDate
ShipToParty I_SDDocStandardPartner ShipToParty
ShipToPartyName
ResponsibleEmployee I_SDDocStandardPartner ResponsibleEmployee
ResponsibleEmployeeName
SalesEmployee I_SDDocStandardPartner SalesEmployee
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 
@EndUserText.label: 'Quotation'
@AbapCatalog.sqlViewName: 'CESJIQUOTATION'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view C_ESJIQuotationQuery
  with parameters
    P_Language : sylangu
  as select from    I_SalesDocument        as SalesDocument
    left outer join I_SDDocStandardPartner as StandardPartner on StandardPartner.SDDocument = SalesDocument.SalesDocument
  association [0..*] to C_ESJIQuotationItemQuery   as _ESJIQuotationItemQuery on $projection.SalesQuotation = _ESJIQuotationItemQuery.SalesQuotation
  association [0..1] to C_ESJIMaxDelivCreationDate as _MaxDelivCreationDate   on $projection.SalesQuotation = _MaxDelivCreationDate.SalesDocument
{
      //Key

      key SalesDocument                                                                  as SalesQuotation,

      'BUS2031'                                                                          as ObjectType,

      //Category

      SalesDocumentType                                                                  as SalesQuotationType,
      _SalesDocumentType._Text[1: Language=$parameters.P_Language].SalesDocumentTypeName as SalesQuotationTypeName,

      //Admin

      CreatedByUser,
      @Semantics.date.creationDate
      CreationDate,
      @Semantics.date.creationDate
      CreationTime,
      @Semantics.date.modificationDate
      LastChangeDate,

      //Orgnization

      SalesOrganization,
      _SalesOrganization._Text[1: Language=$parameters.P_Language].SalesOrganizationName,
      DistributionChannel,
      _DistributionChannel._Text[1: Language=$parameters.P_Language].DistributionChannelName,
      OrganizationDivision,
      _OrganizationDivision._Text[1: Language=$parameters.P_Language].DivisionName,
      SalesGroup,
      SalesOffice,

      //Sales

      SalesDocument.SoldToParty,
      SalesDocument._SoldToParty.CustomerName as SoldToPartyName,
      SalesDocumentDate                                                                  as SalesQuotationDate,
      SDDocumentReason,
      PurchaseOrderByCustomer,
      CustomerPurchaseOrderDate,

      //Pricing

      @DefaultAggregation: #SUM
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,
      cast (currency_conversion(
          amount => TotalNetAmount,
          source_currency => TransactionCurrency,
          target_currency => cast ('EUR' as abap.cuky( 5 )),
          exchange_rate_date => CreationDate,
          exchange_rate_type => cast('M' as kurst ),
          error_handling => #CNV_ERROR_HANDLING.SET_TO_NULL,
          round => #CDSBoolean.true,
          decimal_shift => #CDSBoolean.true,
          decimal_shift_back => #CDSBoolean.true
      ) as net_amount_in_dsp_crcy)                                                       as NetAmountInDisplayCurrency,
      @Semantics.currencyCode: true
      TransactionCurrency,
      PricingDate,

      //Shipping

      RequestedDeliveryDate,
      _MaxDelivCreationDate.DeliveryCreationDate,
      ShippingType,
      ShippingCondition,
      IncotermsClassification,
      _IncotermsClassification._Text[1: Language=$parameters.P_Language].IncotermsClassificationName,
      IncotermsTransferLocation,
      CompleteDeliveryIsDefined,
      DeliveryBlockReason,

      //Billing

      HeaderBillingBlockReason,

      //Payment

      CustomerPaymentTerms,
      _CustomerPaymentTerms._Text[1: Language=$parameters.P_Language].CustomerPaymentTermsName,

      BusinessArea,

      SalesDocument.BindingPeriodValidityStartDate                                       as ValidityStartDate,
      SalesDocument.BindingPeriodValidityEndDate                                         as ValidityEndDate,

      StandardPartner.ShipToParty,
      StandardPartner._ShipToParty.CustomerName as ShipToPartyName,

      StandardPartner.ResponsibleEmployee,
      StandardPartner._ResponsibleEmployee.PersonFullName as ResponsibleEmployeeName,
      StandardPartner.SalesEmployee,
      StandardPartner._SalesEmployee.PersonFullName as SalesEmployeeName,

      //Status

      OverallSDProcessStatus,
      _OverallSDProcessStatus._Text[1: Language=$parameters.P_Language].OverallSDProcessStatusDesc,
      OverallSDDocumentRejectionSts,
      _OverallSDDocumentRejectionSts._Text[1: Language=$parameters.P_Language].OvrlSDDocumentRejectionStsDesc,
      TotalBlockStatus,
      _TotalBlockStatus._Text[1: Language=$parameters.P_Language].TotalBlockStatusDesc,
      OverallDelivConfStatus,
      OverallTotalDeliveryStatus,
      _OverallTotalDeliveryStatus._Text[1: Language=$parameters.P_Language].OverallTotalDeliveryStatusDesc,
      OverallDeliveryStatus,
      _OverallDeliveryStatus._Text[1: Language=$parameters.P_Language].OverallDeliveryStatusDesc,
      OverallDeliveryBlockStatus,
      _OverallDeliveryBlockStatus._Text[1: Language=$parameters.P_Language].OverallDelivBlockStatusDesc,
      OverallBillingBlockStatus,
      _OverallBillingBlockStatus._Text[1: Language=$parameters.P_Language].OverallBillingBlockStatusDesc,
      OverallTotalSDDocRefStatus,
      TotalCreditCheckStatus,
      _TotalCreditCheckStatus._Text[1: Language=$parameters.P_Language].TotalCreditCheckStatusDesc,
      //Associations

      _Partner,
      _SalesDocumentType,
      _CreatedByUser,
      _SalesOrganization,
      _DistributionChannel,
      _OrganizationDivision,
      SalesDocument._SoldToParty,
      _SDDocumentReason,
      _TransactionCurrency,
      _ShippingType,
      _ShippingCondition,
      _IncotermsClassification,
      _DeliveryBlockReason,
      _HeaderBillingBlockReason,
      _CustomerPaymentTerms,
      _OverallSDProcessStatus,
      _OverallSDDocumentRejectionSts,
      _TotalBlockStatus,
      _OverallTotalDeliveryStatus,
      _OverallDeliveryStatus,
      _OverallDeliveryBlockStatus,
      _TotalCreditCheckStatus,
      _OverallBillingBlockStatus,
      _ESJIQuotationItemQuery
}                                                                                                        
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_ESJIMAXDELIVCREATIONDATE",
"I_CUSTOMER",
"I_CUSTOMERPAYMENTTERMS",
"I_CUSTOMERPAYMENTTERMSTEXT",
"I_DISTRIBUTIONCHANNEL",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISION",
"I_DIVISIONTEXT",
"I_INCOTERMSCLASSIFICATION",
"I_INCOTERMSCLASSIFICATIONTEXT",
"I_OVERALLBILLINGBLOCKSTATUS",
"I_OVERALLBILLINGBLOCKSTATUST",
"I_OVERALLDELIVERYBLOCKSTATUS",
"I_OVERALLDELIVERYBLOCKSTATUST",
"I_OVERALLDELIVERYSTATUS",
"I_OVERALLDELIVERYSTATUSTEXT",
"I_OVERALLSDDOCUMENTRJCNSTATUS",
"I_OVERALLSDDOCUMENTRJCNSTATUST",
"I_OVERALLSDPROCESSSTATUS",
"I_OVERALLSDPROCESSSTATUSTEXT",
"I_OVERALLTOTALDELIVERYSTATUS",
"I_OVERALLTOTALDELIVERYSTATUST",
"I_PERSONWORKAGREEMENT_1",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTTYPE",
"I_SALESDOCUMENTTYPETEXT",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"I_SDDOCSTANDARDPARTNER",
"I_TOTALBLOCKSTATUS",
"I_TOTALBLOCKSTATUSTEXT",
"I_TOTALCREDITCHECKSTATUS",
"I_TOTALCREDITCHECKSTATUSTEXT"
],
"ASSOCIATED":
[
"C_ESJIMAXDELIVCREATIONDATE",
"C_ESJIQUOTATIONITEMQUERY",
"I_BILLINGBLOCKREASON",
"I_CURRENCY",
"I_CUSTOMER",
"I_CUSTOMERPAYMENTTERMS",
"I_DELIVERYBLOCKREASON",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_INCOTERMSCLASSIFICATION",
"I_OVERALLBILLINGBLOCKSTATUS",
"I_OVERALLDELIVERYBLOCKSTATUS",
"I_OVERALLDELIVERYSTATUS",
"I_OVERALLSDDOCUMENTRJCNSTATUS",
"I_OVERALLSDPROCESSSTATUS",
"I_OVERALLTOTALDELIVERYSTATUS",
"I_SALESDOCUMENTPARTNER",
"I_SALESDOCUMENTTYPE",
"I_SALESORGANIZATION",
"I_SDDOCUMENTREASON",
"I_SHIPPINGCONDITION",
"I_SHIPPINGTYPE",
"I_TOTALBLOCKSTATUS",
"I_TOTALCREDITCHECKSTATUS",
"I_USER"
],
"BASE":
[
"I_SALESDOCUMENT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More