_SALESQUOTATION
_SALESQUOTATION is an SAP database table in S/4HANA. It contains 90 fields.
Fields (90)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| _BillingCompanyCode | _BillingCompanyCode | 1 | |
| _DownPaymentStatus | _DownPaymentStatus | 1 | |
| _HdrGeneralIncompletionStatus | _HdrGeneralIncompletionStatus | 1 | |
| _HeaderBillgIncompletionStatus | _HeaderBillgIncompletionStatus | 1 | |
| _OverallChmlCmplncStatus | _OverallChmlCmplncStatus | 1 | |
| _OverallDangerousGoodsStatus | _OverallDangerousGoodsStatus | 1 | |
| _OverallPricingIncompletionSts | _OverallPricingIncompletionSts | 1 | |
| _OverallSDDocumentRejectionSts | _OverallSDDocumentRejectionSts | 1 | |
| _OverallSDProcessStatus | _OverallSDProcessStatus | 1 | |
| _OvrlTradeCmplncEmbargoStatus | _OvrlTradeCmplncEmbargoStatus | 1 | |
| _OvTrdCmplncSnctndListChkSts | _OvTrdCmplncSnctndListChkSts | 1 | |
| _SalesDocApprovalStatus | _SalesDocApprovalStatus | 1 | |
| _ShippingType | _ShippingType | 1 | |
| _TotalBlockStatus | _TotalBlockStatus | 1 | |
| AdditionalCustomerGroup1 | AdditionalCustomerGroup1 | 2 | |
| AdditionalCustomerGroup2 | AdditionalCustomerGroup2 | 2 | |
| AdditionalCustomerGroup3 | AdditionalCustomerGroup3 | 2 | |
| AdditionalCustomerGroup4 | AdditionalCustomerGroup4 | 2 | |
| AdditionalCustomerGroup5 | AdditionalCustomerGroup5 | 2 | |
| AdditionalValueDays | AdditionalValueDays | 2 | |
| BillingCompanyCode | BillingCompanyCode | 3 | |
| BillingDocumentDate | BillingDocumentDate | 2 | |
| BindingPeriodValidityEndDate | BindingPeriodValidityEndDate | 1 | |
| BindingPeriodValidityStartDate | BindingPeriodValidityStartDate | 1 | |
| BusinessArea | BusinessArea | 2 | |
| CentralCreditCheckStatus | CentralCreditCheckStatus | 2 | |
| CentralCreditChkTechErrSts | CentralCreditChkTechErrSts | 2 | |
| ControllingArea | ControllingArea | 2 | |
| CostCenter | CostCenter | 3 | |
| CostCenterBusinessArea | CostCenterBusinessArea | 2 | |
| CreatedByUser | CreatedByUser,QuotationCreatedByUser | 3 | |
| CreationDate | CreationDate,QuotationCreationDate | 3 | |
| CreationTime | QuotationCreationTime | 2 | |
| CreditControlArea | CreditControlArea | 3 | |
| CustomerAccountAssignmentGroup | CustomerAccountAssignmentGroup | 2 | |
| CustomerGroup | CustomerGroup | 2 | |
| CustomerPaymentTerms | CustomerPaymentTerms | 2 | |
| CustomerPurchaseOrderDate | CustomerPurchaseOrderDate | 3 | |
| CustomerPurchaseOrderSuplmnt | CustomerPurchaseOrderSuplmnt | 2 | |
| CustomerPurchaseOrderType | CustomerPurchaseOrderType | 2 | |
| CustomerRebateAgreement | CustomerRebateAgreement | 2 | |
| DistributionChannel | DistributionChannel | 15 | |
| ExchangeRateDate | ExchangeRateDate | 2 | |
| ExchangeRateType | ExchangeRateType | 2 | |
| ExprtInsurCreditCheckStatus | ExprtInsurCreditCheckStatus | 2 | |
| FinDocCreditCheckStatus | FinDocCreditCheckStatus | 2 | |
| FiscalPeriod | FiscalPeriod | 2 | |
| FiscalYear | FiscalYear | 2 | |
| FixedValueDate | FixedValueDate | 2 | |
| HdrGeneralIncompletionStatus | HdrGeneralIncompletionStatus | 2 | |
| HdrOrderProbabilityInPercent | HdrOrderProbabilityInPercent | 2 | |
| HeaderBillgIncompletionStatus | HeaderBillgIncompletionStatus | 2 | |
| HeaderBillingBlockReason | HeaderBillingBlockReason | 2 | |
| IncotermsClassification | IncotermsClassification | 2 | |
| IncotermsLocation1 | IncotermsLocation1 | 2 | |
| IncotermsLocation2 | IncotermsLocation2 | 2 | |
| IncotermsTransferLocation | IncotermsTransferLocation | 2 | |
| IncotermsVersion | IncotermsVersion | 2 | |
| LastChangeDate | QuotationLastChangeDate | 2 | |
| LastChangeDateTime | QuotationLastChangeDateTime | 2 | |
| LastChangedByUser | QuotationLastChangedByUser | 2 | |
| MaxDocValueCreditCheckStatus | MaxDocValueCreditCheckStatus | 2 | |
| OrganizationDivision | OrganizationDivision | 15 | |
| OverallBillingBlockStatus | OverallBillingBlockStatus | 2 | |
| OverallPricingIncompletionSts | OverallPricingIncompletionSts | 2 | |
| OverallSDProcessStatus | OverallSDProcessStatus | 1 | |
| OverallTotalSDDocRefStatus | OverallTotalSDDocRefStatus | 1 | |
| OvrlItmBillingIncompletionSts | OvrlItmBillingIncompletionSts | 2 | |
| OvrlItmGeneralIncompletionSts | OvrlItmGeneralIncompletionSts | 2 | |
| PaymentMethod | PaymentMethod | 2 | |
| PaymentTermCreditCheckStatus | PaymentTermCreditCheckStatus | 2 | |
| PaytAuthsnCreditCheckSts | PaytAuthsnCreditCheckSts | 2 | |
| PriceDetnExchangeRate | PriceDetnExchangeRate | 2 | |
| PricingDate | PricingDate | 2 | |
| ProductCatalog | ProductCatalog | 2 | |
| PurchaseOrderByCustomer | PurchaseOrderByCustomer | 3 | |
| RetailPromotion | RetailPromotion | 2 | |
| SalesDistrict | SalesDistrict | 2 | |
| SalesDocApprovalStatus | SalesDocApprovalStatus | 1 | |
| SalesDocumentType | SalesDocumentType | 1 | |
| SalesOrganization | SalesOrganization | 15 | |
| SalesQuotationCondition | SalesQuotationCondition | 2 | |
| SalesQuotationDate | SalesQuotationDate | 2 | |
| SalesQuotationType | SalesQuotationType | 15 | |
| ServicesRenderedDate | ServicesRenderedDate | 2 | |
| ShippingType | SlsOrdShippingType | 1 | |
| TotalBlockStatus | TotalBlockStatus | 3 | |
| TotalCreditCheckStatus | TotalCreditCheckStatus | 2 | |
| TotalNetAmount | TotalNetAmount | 2 | |
| TransactionCurrency | TransactionCurrency | 1 |
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.
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SALESQUOTATION (
_BILLINGCOMPANYCODE,
_DOWNPAYMENTSTATUS,
_HDRGENERALINCOMPLETIONSTATUS,
_HEADERBILLGINCOMPLETIONSTATUS,
_OVERALLCHMLCMPLNCSTATUS,
_OVERALLDANGEROUSGOODSSTATUS,
_OVERALLPRICINGINCOMPLETIONSTS,
_OVERALLSDDOCUMENTREJECTIONSTS,
_OVERALLSDPROCESSSTATUS,
_OVRLTRADECMPLNCEMBARGOSTATUS,
_OVTRDCMPLNCSNCTNDLISTCHKSTS,
_SALESDOCAPPROVALSTATUS,
_SHIPPINGTYPE,
_TOTALBLOCKSTATUS,
ADDITIONALCUSTOMERGROUP1,
ADDITIONALCUSTOMERGROUP2,
ADDITIONALCUSTOMERGROUP3,
ADDITIONALCUSTOMERGROUP4,
ADDITIONALCUSTOMERGROUP5,
ADDITIONALVALUEDAYS,
BILLINGCOMPANYCODE,
BILLINGDOCUMENTDATE,
BINDINGPERIODVALIDITYENDDATE,
BINDINGPERIODVALIDITYSTARTDATE,
BUSINESSAREA,
CENTRALCREDITCHECKSTATUS,
CENTRALCREDITCHKTECHERRSTS,
CONTROLLINGAREA,
COSTCENTER,
COSTCENTERBUSINESSAREA,
CREATEDBYUSER,
CREATIONDATE,
CREATIONTIME,
CREDITCONTROLAREA,
CUSTOMERACCOUNTASSIGNMENTGROUP,
CUSTOMERGROUP,
CUSTOMERPAYMENTTERMS,
CUSTOMERPURCHASEORDERDATE,
CUSTOMERPURCHASEORDERSUPLMNT,
CUSTOMERPURCHASEORDERTYPE,
CUSTOMERREBATEAGREEMENT,
DISTRIBUTIONCHANNEL,
EXCHANGERATEDATE,
EXCHANGERATETYPE,
EXPRTINSURCREDITCHECKSTATUS,
FINDOCCREDITCHECKSTATUS,
FISCALPERIOD,
FISCALYEAR,
FIXEDVALUEDATE,
HDRGENERALINCOMPLETIONSTATUS,
HDRORDERPROBABILITYINPERCENT,
HEADERBILLGINCOMPLETIONSTATUS,
HEADERBILLINGBLOCKREASON,
INCOTERMSCLASSIFICATION,
INCOTERMSLOCATION1,
INCOTERMSLOCATION2,
INCOTERMSTRANSFERLOCATION,
INCOTERMSVERSION,
LASTCHANGEDATE,
LASTCHANGEDATETIME,
LASTCHANGEDBYUSER,
MAXDOCVALUECREDITCHECKSTATUS,
ORGANIZATIONDIVISION,
OVERALLBILLINGBLOCKSTATUS,
OVERALLPRICINGINCOMPLETIONSTS,
OVERALLSDPROCESSSTATUS,
OVERALLTOTALSDDOCREFSTATUS,
OVRLITMBILLINGINCOMPLETIONSTS,
OVRLITMGENERALINCOMPLETIONSTS,
PAYMENTMETHOD,
PAYMENTTERMCREDITCHECKSTATUS,
PAYTAUTHSNCREDITCHECKSTS,
PRICEDETNEXCHANGERATE,
PRICINGDATE,
PRODUCTCATALOG,
PURCHASEORDERBYCUSTOMER,
RETAILPROMOTION,
SALESDISTRICT,
SALESDOCAPPROVALSTATUS,
SALESDOCUMENTTYPE,
SALESORGANIZATION,
SALESQUOTATIONCONDITION,
SALESQUOTATIONDATE,
SALESQUOTATIONTYPE,
SERVICESRENDEREDDATE,
SHIPPINGTYPE,
TOTALBLOCKSTATUS,
TOTALCREDITCHECKSTATUS,
TOTALNETAMOUNT,
TRANSACTIONCURRENCY
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- 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
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA