_SALESQUOTATION

_SALESQUOTATION is an SAP database table in S/4HANA. It contains 90 fields.

Fields (90)

KeyField CDS FieldsUsed 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
);