- 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)
P_SLSDOCITMBSCDATA
Sales Document Item Analytics
| view: PSLSDOCITMBSC
| Extraction:
Not supported
| Component: Sales Analytics
- 🔑 Keys (2)
- 💰 Amounts (13)
- ∑ Quantities (5)
- 📅 Dates (6)
- ☰ Categorical (49)
- Other (23)
- 🔗 Relations (17)
| Column Name | Description | |
|---|---|---|
| SalesDocument FK | Sales Document | |
| SalesDocumentItem | Sales Document Item |
| Column Name | Description | |
|---|---|---|
| 💲 SD Document Currency (TransactionCurrency): | ||
| OutlineAgreementTargetAmount | Target Value for Outline Agreement in Document Currency | |
| NetAmount | Net Value of Sales Order Item in Transaction Currency | |
| NetPriceAmount | Net Price | |
| TaxAmount | Tax Amount in Document Currency | |
| CostAmount | Cost in Document Currency | |
| Subtotal1Amount | Subtotal 1 from Pricing Procedure for Price Element | |
| Subtotal2Amount | Subtotal 2 from Pricing Procedure for Price Element | |
| Subtotal3Amount | Subtotal 3 from Pricing Procedure for Price Element | |
| Subtotal4Amount | Subtotal 4 from Pricing Procedure for Price Element | |
| Subtotal5Amount | Subtotal 5 from Pricing Procedure for Price Element | |
| Subtotal6Amount | Subtotal 6 from Pricing Procedure for Price Element | |
| SalesQuotationNetAmount | Net Value of the Order Item in Document Currency | |
| CnvrtdSalesQuotationNetAmount | Converted Sales Quotation Net Amount | |
| Column Name | Description | |
|---|---|---|
| 📏 Weight Unit (ItemWeightUnit): | ||
| ItemGrossWeight | Gross Weight of the Item | |
| ItemNetWeight | Net Weight of the Item | |
| 📏 Volume unit (ItemVolumeUnit): | ||
| ItemVolume | Volume of the item | |
| 📏 Base Unit of Measure (BaseUnit): | ||
| SalesQuotationQuantity | Quantity of Sales Quotation Items | |
| CnvrtdSalesQuotationQuantity | Converted Sales Quotation Quantity | |
| Column Name | Description | |
|---|---|---|
| CreationDate | Date on which the record was created | |
| CreationTime | Time at Which Record Was Created | |
| LastChangeDate | Last Changed On | |
| SalesDocumentDate | Document Date (Date Received/Sent) | |
| BindingPeriodValidityStartDate | Quotation/Inquiry is Valid From | |
| BindingPeriodValidityEndDate | Date Until Which Bid/Quotation is Binding (Valid-To Date) |
| Column Name | Description | |
|---|---|---|
| SDDocumentCategory | SD Document Category | Show values |
| SalesDocumentItemType | Item Type | Show values |
| QuantityIsFixed | Quantity is fixed | Show values |
| StatisticalValueControl | Statistical Values | Show values |
| DeliveryDateQuantityIsFixed | Delivery Date and Quantity Fixed | Show values |
| ReferenceSDDocumentCategory | Document Category of Preceding SD Document | Show values |
| OverallSDProcessStatus | Overall Processing Status (Header/All Items) | Show values |
| OverallPurchaseConfStatus | Purchasing Confirmation Status | Show values |
| OverallSDDocumentRejectionSts | Rejection Status (All Items) | Show values |
| OverallSDDocReferenceStatus | Reference 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 |
| TotalCreditCheckStatus | Overall Status of Credit Checks | Show values |
| MaxDocValueCreditCheckStatus | Status of Credit Check Against Maximum Document Value | Show values |
| PaymentTermCreditCheckStatus | Status of Credit Check Against Terms of Payment | Show values |
| FinDocCreditCheckStatus | Status of Credit Check Against Financial Document | Show values |
| ExprtInsurCreditCheckStatus | Status of Credit Check Against Export Credit Insurance | Show values |
| PaytAuthsnCreditCheckSts | Status of Credit Check Against Payment Card Authorization | Show values |
| CentralCreditCheckStatus | Status of Credit Check SAP Credit Management | Show values |
| CentralCreditChkTechErrSts | Status of Technical Error SAP Credit Management | Show values |
| HdrGeneralIncompletionStatus | Incompletion Status (Header) | Show values |
| OverallPricingIncompletionSts | Pricing Incompletion Status (All Items) | 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 |
| PurchaseConfirmationStatus | Purchasing Confirmation Status | 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 |
| PricingIncompletionStatus | Pricing 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 |
| SDDocReferenceStatus | Reference Status (Item) | Show values |
| SlsQtanToOrdProbltyInPercent | Sales Quotation to Order Probability | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| SoldToParty | Sold-to Party | KUNNR | |
| ShipToParty | Ship-to Party | KUNNR | |
| PayerParty | Payer | KUNNR | |
| BillToParty | Bill-to Party | KUNNR | |
| SalesEmployee | Sales Employee | PERNR | |
| ResponsibleEmployee | Employee Responsible | PERNR | |
| SalesDocumentType | Sales Document Type | AUART | |
| CreatedByUser | Name of Person Responsible for Creating the Object | USNAM | |
| SalesOrganization | Sales Organization | VKORG | |
| DistributionChannel | Distribution Channel | VTWEG | |
| OrganizationDivision | Division | SPART | |
| SalesOffice | Sales office | VKBUR | |
| SalesGroup | Sales group | VKGRP | |
| SDDocumentReason | Order Reason (Reason for the Business Transaction) | AUGRU | |
| SalesDocumentItemText | Short text for sales order item | TEXT40 | |
| NetPriceQuantity | Condition Pricing Unit | KPEIN | |
| ProfitCenter | Profit Center | PRCTR | |
| ProfitabilitySegment | Deprecated: Profitability Segment | RKEOBJNR_NUMC | |
| OriginSDDocument | Originating Document | VBELN | |
| OriginSDDocumentItem | Originating Item | POSNR | |
| ReferenceSDDocument | Document number of the reference document | VBELN | |
| ReferenceSDDocumentItem | Item number of the reference item | POSNR | |
| HigherLevelItem | Higher-Level Item in Bill of Material Structures | POSNR |
| Master Data Relations | Join Conditions |
|---|---|
Base Unit of Measure
| |
Division
| |
Special Stock Indicator
| |
Volume unit
| |
Weight Unit
| |
Material: order item
| |
Material Group
| |
Condition Unit
| |
Sales unit
| |
Material Entered
| |
Sales District
| |
Sales document item category
| |
Reason for Rejection of Sales Documents
| |
SD Document Currency
|