- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
C_SalesQuotationItemQry
Sales Quotation Item - Query
| view: CSDSLSQTANITMQRY
| Extraction:
Not supported
| Component: Sales Analytics
- 🔑 Keys (2)
- 💰 Amounts (6)
- ∑ Quantities (1)
- 📅 Dates (10)
- ☰ Categorical (32)
- Other (40)
- 🔗 Relations (29)
| Column Name | Description | |
|---|---|---|
| SalesQuotation FK | Sales Quotation | |
| SalesQuotationItem | Sales Quotation Item |
| Column Name | Description | |
|---|---|---|
| 💲 Display Currency (DisplayCurrency): | ||
| SalesQuotationNetAmtInDspCrcy | Net Amount of Sales Quotation Items in Display Currency | |
| CnvrtdSalesQtanNetAmtInDspCrcy | Converted Sales Quoation Net Amount in Display Currency | |
| SlsQuotationOpenNetAmtInDC | Net Value of Open Sales Quotations in Display Currency | |
| SlsQuotationExpiredNetAmtInDC | Net Value of Expired Sales Quotations in Display Currency | |
| SlsQuotationExpiringNetAmtInDC | Net Value of Expiring Sales Quotations in Display Currency | |
| SlsQtanRejectedNetAmountInDC | Net Value of Rejected Quotation Items in Display Currency | |
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (BaseUnit): | ||
| SalesQuotationQuantity | Quantity of Sales Quotation Items | |
| Column Name | Description | |
|---|---|---|
| CreationDate | Date on which the record was created | |
| CreationTime | Time at Which Record Was Created | |
| LastChangeDate | Last Changed On | |
| SalesQuotationDate | Document Date (Date Received/Sent) | |
| BindingPeriodValidityStartDate | Quotation/Inquiry is Valid From | |
| BindingPeriodValidityEndDate | Date Until Which Bid/Quotation is Binding (Valid-To Date) | |
| CustomerPurchaseOrderDate | Customer Reference Date | |
| RequestedDeliveryDate | Requested Delivery Date | |
| PricingDate | Date for Pricing and Exchange Rate | |
| BillingDocumentDate | Billing Date |
| Column Name | Description | |
|---|---|---|
| SalesQuotationItemType | Item Type | Show values |
| CompleteDeliveryIsDefined | Complete Delivery Defined for Each Sales Order? | Show values |
| ReferenceSDDocumentCategory | Document Category of Preceding SD Document | Show values |
| OverallSDProcessStatus | Overall Processing Status (Header/All Items) | Show values |
| OverallSDDocumentRejectionSts | Rejection Status (All Items) | Show values |
| TotalBlockStatus | Overall Block Status (Header) | Show values |
| OverallDelivConfStatus | Delivery Confirmation Status (All Items) | Show values |
| OverallTotalDeliveryStatus | Overall Delivery Status (All Items) | Show values |
| OverallDeliveryStatus | Delivery Status (All Items) | Show values |
| OverallDeliveryBlockStatus | Overall Delivery Block Status (All Items) | Show values |
| OverallOrdReltdBillgStatus | Order-Related Billing Status (All Items) | Show values |
| OverallBillingBlockStatus | Billing Block Status (All Items) | Show values |
| OverallTotalSDDocRefStatus | Overall Reference Status (All Items) | Show values |
| OverallSDDocReferenceStatus | Reference Status (All Items) | Show values |
| HdrGeneralIncompletionStatus | Incompletion Status (Header) | Show values |
| HeaderDelivIncompletionStatus | Delivery Incompletion Status (Header) | Show values |
| HeaderBillgIncompletionStatus | Billing Incompletion Status (Header) | Show values |
| OvrlItmGeneralIncompletionSts | Incompletion Status (All Items) | Show values |
| OvrlItmBillingIncompletionSts | Billing Incompletion Status (All Items) | Show values |
| OvrlItmDelivIncompletionSts | Delivery Incompletion Status (All Items) | Show values |
| SDProcessStatus | Overall Processing Status (Item) | Show values |
| DeliveryConfirmationStatus | Delivery Confirmation Status (Item) | Show values |
| TotalDeliveryStatus | Overall Delivery Status (Item) | Show values |
| DeliveryStatus | Delivery Status (Item) | Show values |
| DeliveryBlockStatus | Delivery Block Status (Item) | Show values |
| OrderRelatedBillingStatus | Order-Related Billing Status (Item) | Show values |
| BillingBlockStatus | Billing Block Status (Item) | Show values |
| ItemGeneralIncompletionStatus | Incompletion Status (Item) | Show values |
| ItemBillingIncompletionStatus | Billing Incompletion Status (Item) | Show values |
| ItemDeliveryIncompletionStatus | Delivery Incompletion Status (Item) | Show values |
| SDDocumentRejectionStatus | Rejection Status (Item) | Show values |
| TotalSDDocReferenceStatus | Overall Reference Status (Item) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| SalesQuotationType | Sales Document Type | AUART | |
| CreatedByUser | Name of Person Responsible for Creating the Object | USNAM | |
| CreationDateYear | Year of Creation | NUM4 | |
| CreationDateYearQuarter | Year/Quarter of Creation | NUM5 | |
| CreationDateYearMonth | Year/Month of Creation | NUM6 | |
| SalesQuotationDateYear | Year of Quotation | NUM4 | |
| SalesQuotationDateYearQuarter | Quarter of Quotation | NUM5 | |
| SalesQuotationDateYearMonth | Month of Quotation | NUM6 | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| OrganizationDivision | Organization Division | SPART | |
| SalesOffice | Sales office | VKBUR | |
| SalesGroup | Sales group | VKGRP | |
| SoldToParty | Sold-to Party | KUNNR | |
| AdditionalCustomerGroup1 | Customer Group 1 | KVGR1 | |
| AdditionalCustomerGroup2 | Customer Group 2 | KVGR2 | |
| AdditionalCustomerGroup3 | Customer Group 3 | KVGR3 | |
| AdditionalCustomerGroup4 | Customer Group 4 | KVGR4 | |
| AdditionalCustomerGroup5 | Customer Group 5 | KVGR5 | |
| SDDocumentReason | Order Reason (Reason for the Business Transaction) | AUGRU | |
| PurchaseOrderByCustomer | Customer Reference | BSTKD | |
| SalesQuotationItemText | Short text for sales order item | TEXT40 | |
| ShipToParty | Ship-to Party | KUNNR | |
| ShippingCondition | Shipping Conditions | VSBED | |
| MaterialByCustomer | Material Number Used by Customer | IDNEX | |
| Plant | Plant (Own or External) | WERKS | |
| IncotermsTransferLocation | Incoterms (Part 2) | INCO2 | |
| IncotermsLocation1 | Incoterms Location 1 | INCO_L | |
| IncotermsLocation2 | Incoterms Location 2 | INCO_L | |
| CustomerPaymentTerms | Terms of payment key | ZTERM | |
| FiscalYear | Fiscal Year | GJAHR | |
| FiscalPeriod | Posting period | POPER | |
| ProfitCenter | Profit Center | PRCTR | |
| ReferenceSDDocument | Document number of the reference document | VBELN | |
| ReferenceSDDocumentItem | Item number of the reference item | POSNR | |
| SalesQuotationConversionRate | Sales Quotation Conversion Rate | ||
| NmbrOfOpenSlsQuotationItems | Number of Open Sales Quotation Items | ||
| NmbrOfExpiredSlsQuotationItems | Number of Items in Expired Sales Quotations | ||
| NmbrOfExprgSlsQuotationItems | Number of Items in Expiring Sales Quotations | ||
| NmbrOfRejectedSlsQtanItems | Number of Rejected Sales Quotation Items |
| Master Data Relations | Join Conditions |
|---|---|
Material Group 1
| |
Material Group 2
| |
Material Group 3
| |
Material Group 4
| |
Material Group 5
| |
Base Unit of Measure
| |
Company Code to Be Billed
| |
Business Area
| |
Account Assignment Group for this Customer
| |
Customer Group
| |
Customer Purchase Order Type
| |
Delivery Block (Document Header)
| |
Delivery Priority
| |
Division
| |
Incoterms (Part 1)
| |
Incoterms Version
| |
Material Entered
| |
Payment Method
| |
Material: order item
| |
Product Group
| |
Route
| |
Sales District
| |
Reason for Rejection of Sales Documents
| |
Sales document item category
| |
Shipping Point / Receiving Point
| |
Shipping Type
| |
Storage location
| |
SD Document Currency
|