I_SALESQUOTATION

CDS View
105 Fields 16 CDS Views

Sales Quotation

I_SALESQUOTATION is a CDS View in S/4HANA. Sales Quotation. It contains 105 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_Customer360SalesQuotation view_entity from CONSUMPTION Sales Quotations for customer 360
C_OpenQuotations_F2200 view from CONSUMPTION Open Sales Quotations
C_QuotationFs view from CONSUMPTION Sales Quotation
C_QuotationWl_F1852 view from CONSUMPTION Sales Quotations
C_RejectedSalesQuotation view from CONSUMPTION Rejected Sales Quotations
C_SalesQuotationWrkflwInbox view from CONSUMPTION Sales Quotation Workflow Inbox
C_SlsQtanForCreateWithRefVH view_entity from CONSUMPTION Sales Quotation for Create Wth Reference
C_SlsQtnWorkflowTaskCard view_entity from CONSUMPTION Sales Quotation Workflow Task Card
ESH_N_SALESQUOTATION view from Anchor view -SALESQUOTATION
I_SalesQuotationEnhanced view from COMPOSITE Sales Quotation Enhanced (API)
I_SalesQuotationImport view_entity from COMPOSITE Header Fields for Sales Quotation Import
I_SalesQuotationPipeline_F2200 view from COMPOSITE Sales Quotation Pipeline
I_SalesQuotationStdVH view from COMPOSITE Sales Quotation
P_Quotationwl_Duedays view from CONSUMPTION Due Days calculation for Sales Quotation
P_SalesQuotationByOpenStatus view from CONSUMPTION Open Sales Quotations Due Days Calc
R_SalesQuotationTP view_entity from TRANSACTIONAL Sales Quotation - TP

Fields (105)

KeyField CDS FieldsUsed in Views
KEY SalesQuotation SalesQuotation 6
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1 1
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2 1
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3 1
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4 1
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5 1
_ControllingArea _ControllingArea 1
_CreatedByUser _CreatedByUser 1
_CustomerCreditAccount _CustomerCreditAccount 1
_CustomerGroup _CustomerGroup 1
_CustomerPaymentTerms _CustomerPaymentTerms 1
_CustomerPriceGroup _CustomerPriceGroup 1
_DistributionChannel _DistributionChannel 1
_HdrGeneralIncompletionStatus _HdrGeneralIncompletionStatus 1
_IncotermsClassification _IncotermsClassification 1
_IncotermsVersion _IncotermsVersion 1
_LastChangedByUser _LastChangedByUser 1
_OrganizationDivision _OrganizationDivision 2
_OverallChmlCmplncStatus _OverallChmlCmplncStatus 1
_OverallDangerousGoodsStatus _OverallDangerousGoodsStatus 1
_OverallSDDocReferenceStatus _OverallSDDocReferenceStatus 2
_OverallSDDocumentRejectionSts _OverallSDDocumentRejectionSts 2
_OverallSDProcessStatus _OverallSDProcessStatus 2
_OvrlItmGeneralIncompletionSts _OvrlItmGeneralIncompletionSts 1
_OvrlSftyDataSheetSts _OvrlSftyDataSheetSts 1
_OvrlTradeCmplncEmbargoStatus _OvrlTradeCmplncEmbargoStatus 1
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory 1
_SalesDistrict _SalesDistrict 1
_SalesDocApprovalStatus _SalesDocApprovalStatus 2
_SalesGroup _SalesGroup 1
_SalesOffice _SalesOffice 1
_SalesOrganization _SalesOrganization 2
_SalesQuotationApprovalReason _SalesQuotationApprovalReason 1
_SalesQuotationType _SalesQuotationType 2
_SDDocumentReason _SDDocumentReason 2
_SDPricingProcedure _SDPricingProcedure 1
_ShippingCondition _ShippingCondition 1
_ShippingType _ShippingType 1
_TotalCreditCheckStatus _TotalCreditCheckStatus 1
_TransactionCurrency _TransactionCurrency 3
AdditionalCustomerGroup1 AdditionalCustomerGroup1 1
AdditionalCustomerGroup2 AdditionalCustomerGroup2 1
AdditionalCustomerGroup3 AdditionalCustomerGroup3 1
AdditionalCustomerGroup4 AdditionalCustomerGroup4 1
AdditionalCustomerGroup5 AdditionalCustomerGroup5 1
BillingCompanyCode BillingCompanyCode 1
BillingDocumentDate BillingDocumentDate 1
BindingPeriodValidityEndDate BindingPeriodValidityEndDate 5
BindingPeriodValidityStartDate BindingPeriodValidityStartDate 5
ControllingArea ControllingArea 1
CreatedByUser CreatedByUser 5
CreationDate CreationDate 3
CreationTime CreationTime 1
CustomerCreditAccount CustomerCreditAccount 1
CustomerGroup CustomerGroup 1
CustomerPaymentTerms CustomerPaymentTerms 1
CustomerPriceGroup CustomerPriceGroup 1
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 2
CustomerTaxClassification1 CustomerTaxClassification1 1
CustomerTaxClassification2 CustomerTaxClassification2 1
CustomerTaxClassification3 CustomerTaxClassification3 1
CustomerTaxClassification4 CustomerTaxClassification4 1
CustomerTaxClassification5 CustomerTaxClassification5 1
CustomerTaxClassification6 CustomerTaxClassification6 1
CustomerTaxClassification7 CustomerTaxClassification7 1
CustomerTaxClassification8 CustomerTaxClassification8 1
CustomerTaxClassification9 CustomerTaxClassification9 1
DistributionChannel DistributionChannel 6
HdrOrderProbabilityInPercent HdrOrderProbabilityInPercent 1
IncotermsClassification IncotermsClassification 1
IncotermsLocation1 IncotermsLocation1 1
IncotermsLocation2 IncotermsLocation2 1
IncotermsVersion IncotermsVersion 1
LastChangeDate LastChangeDate 3
LastChangedByUser LastChangedByUser 5
OrganizationDivision OrganizationDivision 6
OverallChmlCmplncStatus OverallChmlCmplncStatus 1
OverallDangerousGoodsStatus OverallDangerousGoodsStatus 1
OverallSafetyDataSheetStatus OverallSafetyDataSheetStatus 1
OverallSDDocReferenceStatus OverallSDDocReferenceStatus 5
OverallSDDocumentRejectionSts OverallSDDocumentRejectionSts 4
OverallSDProcessStatus OverallSDProcessStatus 5
OverallTrdCmplncEmbargoSts OverallTrdCmplncEmbargoSts 1
PaymentMethod PaymentMethod 1
PricingDate PricingDate 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 6
ReferenceSDDocument ReferenceSDDocument 1
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 1
RequestedDeliveryDate RequestedDeliveryDate 1
SalesDistrict SalesDistrict 1
SalesDocApprovalStatus SalesDocApprovalStatus 4
SalesGroup SalesGroup 4
SalesOffice SalesOffice 4
SalesOrganization SalesOrganization 6
SalesQuotationApprovalReason SalesQuotationApprovalReason 2
SalesQuotationDate SalesQuotationDate 3
SalesQuotationType SalesQuotationType 6
SDDocumentReason SDDocumentReason 3
SDPricingProcedure SDPricingProcedure 1
ShippingCondition ShippingCondition 1
ShippingType ShippingType 1
SoldToParty SoldToParty 4
TotalCreditCheckStatus TotalCreditCheckStatus 1
TotalNetAmount TotalNetAmount 5
TransactionCurrency TransactionCurrency 6

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Quotation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESQUOTATION (
    SALESQUOTATION,
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _CONTROLLINGAREA,
    _CREATEDBYUSER,
    _CUSTOMERCREDITACCOUNT,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _CUSTOMERPRICEGROUP,
    _DISTRIBUTIONCHANNEL,
    _HDRGENERALINCOMPLETIONSTATUS,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _LASTCHANGEDBYUSER,
    _ORGANIZATIONDIVISION,
    _OVERALLCHMLCMPLNCSTATUS,
    _OVERALLDANGEROUSGOODSSTATUS,
    _OVERALLSDDOCREFERENCESTATUS,
    _OVERALLSDDOCUMENTREJECTIONSTS,
    _OVERALLSDPROCESSSTATUS,
    _OVRLITMGENERALINCOMPLETIONSTS,
    _OVRLSFTYDATASHEETSTS,
    _OVRLTRADECMPLNCEMBARGOSTATUS,
    _REFERENCESDDOCUMENTCATEGORY,
    _SALESDISTRICT,
    _SALESDOCAPPROVALSTATUS,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SALESQUOTATIONAPPROVALREASON,
    _SALESQUOTATIONTYPE,
    _SDDOCUMENTREASON,
    _SDPRICINGPROCEDURE,
    _SHIPPINGCONDITION,
    _SHIPPINGTYPE,
    _TOTALCREDITCHECKSTATUS,
    _TRANSACTIONCURRENCY,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    BILLINGCOMPANYCODE,
    BILLINGDOCUMENTDATE,
    BINDINGPERIODVALIDITYENDDATE,
    BINDINGPERIODVALIDITYSTARTDATE,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERCREDITACCOUNT,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPRICEGROUP,
    CUSTOMERPURCHASEORDERDATE,
    CUSTOMERTAXCLASSIFICATION1,
    CUSTOMERTAXCLASSIFICATION2,
    CUSTOMERTAXCLASSIFICATION3,
    CUSTOMERTAXCLASSIFICATION4,
    CUSTOMERTAXCLASSIFICATION5,
    CUSTOMERTAXCLASSIFICATION6,
    CUSTOMERTAXCLASSIFICATION7,
    CUSTOMERTAXCLASSIFICATION8,
    CUSTOMERTAXCLASSIFICATION9,
    DISTRIBUTIONCHANNEL,
    HDRORDERPROBABILITYINPERCENT,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSVERSION,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    ORGANIZATIONDIVISION,
    OVERALLCHMLCMPLNCSTATUS,
    OVERALLDANGEROUSGOODSSTATUS,
    OVERALLSAFETYDATASHEETSTATUS,
    OVERALLSDDOCREFERENCESTATUS,
    OVERALLSDDOCUMENTREJECTIONSTS,
    OVERALLSDPROCESSSTATUS,
    OVERALLTRDCMPLNCEMBARGOSTS,
    PAYMENTMETHOD,
    PRICINGDATE,
    PURCHASEORDERBYCUSTOMER,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTCATEGORY,
    REQUESTEDDELIVERYDATE,
    SALESDISTRICT,
    SALESDOCAPPROVALSTATUS,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SALESQUOTATIONAPPROVALREASON,
    SALESQUOTATIONDATE,
    SALESQUOTATIONTYPE,
    SDDOCUMENTREASON,
    SDPRICINGPROCEDURE,
    SHIPPINGCONDITION,
    SHIPPINGTYPE,
    SOLDTOPARTY,
    TOTALCREDITCHECKSTATUS,
    TOTALNETAMOUNT,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SALESQUOTATION)
);

Learn More