C_SlsOrdConfAnlytsQry

Confirmation of Sales Orders - Query | view: CSDSLSORDCONFAQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, TKA01, KNA1, CVI_CUST_LINK, T001W, KONA, TVKO, T000, T001L, CVI_VEND_LINK, T006, T006A, USR21, PROJ
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Net Value in Display Currency
SlsDocItmSchdLnConfdAmtInDC Overall confirmed SO schedule lines: amt in display curr.
SlsDocItmSchdLnDlydAmtInDC Overall delayed SO sched. lines: amt in disp.curr.
SlsDocItmSchdLnUnconfdAmtInDC Overall unconfirmed SO schedule lines: amt in display curr.
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
SlsDocItmSchdLnConfdQty Overall confirmed sales order schedule lines: quantity
SlsDocItmSchdLnDlydQty Overall delayed sales order schedule lines: qty
SlsDocItmSchdLnUnconfdQty Overall unconfirmed sales order schedule lines: quantity
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
SalesOrderDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
Column Name Description
SDDocumentCategory SD Document Category Show values
IsReturnsItem Returns Item Show values
ItemOrderProbabilityInPercent Order Probability of the Item Show values
StatisticalValueControl Statistical Values Show values
CompleteDeliveryIsDefined Complete Delivery Defined for Each Sales Order? Show values
DeliveryDateQuantityIsFixed Fixed Delivery Date and Quantity Show values
PartialDeliveryIsAllowed Partial Delivery at Item Level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
OpenDeliveryLeadingUnitCode ID: Leading unit of measure for completing a transaction Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallPurchaseConfStatus Purchasing Confirmation Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) 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
TotalCreditCheckStatus Overall Status of Credit Checks Show values
PaymentTermCreditCheckStatus Status of Credit Check Against Terms of Payment Show values
PaytAuthsnCreditCheckSts Status of Credit Check Against Payment Card Authorization 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 (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
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
SlsDocItmReqdDelivConfSts Sales Order Item Confirmation Status Show values
Column Name Description Domain name
SalesOrderType Sales Document Type AUART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CreatedByUserName User Description SUIDTECHDESC
CreationDateYear Year of Creation NUM4
CreationDateYearQuarter Year/Quarter of Creation NUM5
CreationDateYearMonth Year/Month of Creation NUM6
SalesOrderDateYear Year of Order NUM4
SalesOrderDateYearQuarter Quarter of Order NUM5
SalesOrderDateYearMonth Month of Order NUM6
SalesOrderDateYearWeek Week of Order NUM6
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesGroup Sales group VKGRP
SalesOffice Sales office VKBUR
MaterialByCustomer Material Number Used by Customer IDNEX
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ProductionPlant Plant (Own or External) WERKS
ProductConfiguration Product Configuration CUOBJ
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
PayerParty Payer KUNNR
BillToParty Bill-to Party KUNNR
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
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
SDDocumentCollectiveNumber Collective Number (SD) CHAR10
CustomerPurchaseOrderSuplmnt Purchase order number supplement BSTZD
SalesOrderItemText Short Text for Sales Order Item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
UnderlyingPurchaseOrderItem Item Number of the Underlying Purchase Order POSEX
SalesDealDescription Sales Deal Description TEXT40
SalesOrderCondition Sales Order Condition KNUMV
ShippingCondition Shipping Conditions VSBED
MaxNmbrOfPartialDelivery Number of Allowed Partial Deliveries ANTLF
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalValueDays Additional Value Days TAGE2
CustomerProject Commercial Project ID /CPD/MP_ID
EngagementProjectName Customer Project Name /CPD/SHORT_TEXT
CostCenter Cost Center KOSTL
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
OriginSDDocument Originating Document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
TotDelayOfSchdLnConfdToReqdDte Total delay of requested delivery date in days
MaxDelayOfSchdLnConfdToReqdDte Maximum delay of requested delivery date in days
MinDelayOfSchdLnConfdToReqdDte Minimum delay of requested delivery date in days
NmbrOfSlsDocItemsConfdAsReqd Number of confirmed sales order items as requested MCZAEHLER
NmbrOfSlsDocItemsConfdDlyd Number of delayed sales order items as requested MCZAEHLER
NmbrOfSlsDocItemsConfdPrtly Number of partially confirmed sales order items as requested MCZAEHLER
NmbrOfSlsDocItemsUnconfd Number of unconfirmed sales order items as requested MCZAEHLER
SlsDocItemsConfdAsReqdRatio Ratio of Confirmed Sales Order Items as Requested
SlsDocItemsConfdDlydRatio Ratio of Delayed Sales Order Items as Requested
SlsDocItemsConfdPrtlyRatio Ratio of Partially Confirmed Sales Order Items as Requested
SlsDocItemsUnconfdRatio Ratio of Unconfirmed Sales Order Items as Requested
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • C_SLSORDCONFANLYTSQRY.MANDT == TVM1.MANDT
  • C_SLSORDCONFANLYTSQRY.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • C_SLSORDCONFANLYTSQRY.MANDT == TVM2.MANDT
  • C_SLSORDCONFANLYTSQRY.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_SLSORDCONFANLYTSQRY.MANDT == TVM3.MANDT
  • C_SLSORDCONFANLYTSQRY.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_SLSORDCONFANLYTSQRY.MANDT == TVM4.MANDT
  • C_SLSORDCONFANLYTSQRY.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • C_SLSORDCONFANLYTSQRY.MANDT == TVM5.MANDT
  • C_SLSORDCONFANLYTSQRY.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SLSORDCONFANLYTSQRY.MANDT == T006.MANDT
  • C_SLSORDCONFANLYTSQRY.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Product Number
  • Plant (Own or External)
  • C_SLSORDCONFANLYTSQRY.MANDT == MCHA.MANDT
  • C_SLSORDCONFANLYTSQRY.BATCH == MCHA.CHARG
  • C_SLSORDCONFANLYTSQRY.MATERIAL == MCHA.MATNR
  • C_SLSORDCONFANLYTSQRY.PRODUCT == MCHA.MATNR
  • C_SLSORDCONFANLYTSQRY.PRODUCTIONPLANT == MCHA.WERKS
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_SLSORDCONFANLYTSQRY.BILLINGCOMPANYCODE == T001.BUKRS
  • C_SLSORDCONFANLYTSQRY.MANDT == T001.MANDT
Business Area
  • Client
  • Business Area
  • C_SLSORDCONFANLYTSQRY.MANDT == TGSB.MANDT
  • C_SLSORDCONFANLYTSQRY.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • C_SLSORDCONFANLYTSQRY.MANDT == TKA01.MANDT
  • C_SLSORDCONFANLYTSQRY.CONTROLLINGAREA == TKA01.KOKRS
Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • C_SLSORDCONFANLYTSQRY.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • C_SLSORDCONFANLYTSQRY.MANDT == TGSB.MANDT
Credit control area
  • Client
  • Credit control area
  • C_SLSORDCONFANLYTSQRY.MANDT == T014.MANDT
  • C_SLSORDCONFANLYTSQRY.CREDITCONTROLAREA == T014.KKBER
Account Assignment Group for this Customer
  • Client
  • Account Assignment Group for this Customer
  • C_SLSORDCONFANLYTSQRY.MANDT == TVKT.MANDT
  • C_SLSORDCONFANLYTSQRY.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
Customer Group
  • Client
  • Customer Group
  • C_SLSORDCONFANLYTSQRY.MANDT == T151.MANDT
  • C_SLSORDCONFANLYTSQRY.CUSTOMERGROUP == T151.KDGRP
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • C_SLSORDCONFANLYTSQRY.MANDT == T176.MANDT
  • C_SLSORDCONFANLYTSQRY.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Customer Rebate Agreement
  • Customer Rebate Agreement
  • Client
  • C_SLSORDCONFANLYTSQRY.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
  • C_SLSORDCONFANLYTSQRY.MANDT == KONA.MANDT
Schedule Line Blocked for Delivery
  • Client
  • Schedule Line Blocked for Delivery
  • C_SLSORDCONFANLYTSQRY.MANDT == TVLS.MANDT
  • C_SLSORDCONFANLYTSQRY.DELIVBLOCKREASONFORSCHEDLINE == TVLS.LIFSP
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SLSORDCONFANLYTSQRY.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SLSORDCONFANLYTSQRY.MANDT == TVLS.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • C_SLSORDCONFANLYTSQRY.MANDT == TPRIO.MANDT
  • C_SLSORDCONFANLYTSQRY.DELIVERYPRIORITY == TPRIO.LPRIO
Division
  • Client
  • Division
  • C_SLSORDCONFANLYTSQRY.MANDT == TSPA.MANDT
  • C_SLSORDCONFANLYTSQRY.DIVISION == TSPA.SPART
Exchange Rate Type
  • Client
  • Exchange Rate Type
  • C_SLSORDCONFANLYTSQRY.MANDT == TCURV.MANDT
  • C_SLSORDCONFANLYTSQRY.EXCHANGERATETYPE == TCURV.KURST
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • C_SLSORDCONFANLYTSQRY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SLSORDCONFANLYTSQRY.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_SLSORDCONFANLYTSQRY.MANDT == TINC.MANDT
  • C_SLSORDCONFANLYTSQRY.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • C_SLSORDCONFANLYTSQRY.INCOTERMSVERSION == TINCV.INCOV
  • C_SLSORDCONFANLYTSQRY.MANDT == TINCV.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • C_SLSORDCONFANLYTSQRY.MANDT == T148.MANDT
  • C_SLSORDCONFANLYTSQRY.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Billing Block Reason for Item
  • Client
  • Billing Block Reason for Item
  • C_SLSORDCONFANLYTSQRY.MANDT == TVFS.MANDT
  • C_SLSORDCONFANLYTSQRY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Client
  • Material Number
  • Product Number
  • C_SLSORDCONFANLYTSQRY.MANDT == MARA.MANDT
  • C_SLSORDCONFANLYTSQRY.MATERIAL == MARA.MATNR
  • C_SLSORDCONFANLYTSQRY.PRODUCT == MARA.MATNR
Material Group
  • Client
  • Product Group
  • Material Group
  • C_SLSORDCONFANLYTSQRY.MANDT == T023.MANDT
  • C_SLSORDCONFANLYTSQRY.PRODUCTGROUP == T023.MATKL
  • C_SLSORDCONFANLYTSQRY.MATERIALGROUP == T023.MATKL
Reason for material substitution
  • Client
  • Reason for material substitution
  • C_SLSORDCONFANLYTSQRY.MANDT == TVSU.MANDT
  • C_SLSORDCONFANLYTSQRY.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
Order Number
  • Order Number
  • Client
  • C_SLSORDCONFANLYTSQRY.ORDERID == AUFK.AUFNR
  • C_SLSORDCONFANLYTSQRY.MANDT == AUFK.MANDT
Sales unit
  • Client
  • Sales unit
  • C_SLSORDCONFANLYTSQRY.MANDT == T006.MANDT
  • C_SLSORDCONFANLYTSQRY.ORDERQUANTITYUNIT == T006.MSEHI
Material Entered
  • Client
  • Material Entered
  • C_SLSORDCONFANLYTSQRY.MANDT == MARA.MANDT
  • C_SLSORDCONFANLYTSQRY.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Payment Method
  • Client
  • ?
  • Payment Method
  • C_SLSORDCONFANLYTSQRY.MANDT == T042Z.MANDT
  • C_SLSORDCONFANLYTSQRY.[column in domain "LAND1"] == T042Z.LAND1
  • C_SLSORDCONFANLYTSQRY.PAYMENTMETHOD == T042Z.ZLSCH
Material: order item
  • Client
  • Material Number
  • Product Number
  • C_SLSORDCONFANLYTSQRY.MANDT == MARA.MANDT
  • C_SLSORDCONFANLYTSQRY.MATERIAL == MARA.MATNR
  • C_SLSORDCONFANLYTSQRY.PRODUCT == MARA.MATNR
Product Catalog
  • Client
  • Product Catalog Number
  • C_SLSORDCONFANLYTSQRY.MANDT == WWMI.MANDT
  • C_SLSORDCONFANLYTSQRY.PRODUCTCATALOG == WWMI.WMINR
Product Group
  • Client
  • Product Group
  • Material Group
  • C_SLSORDCONFANLYTSQRY.MANDT == T023.MANDT
  • C_SLSORDCONFANLYTSQRY.PRODUCTGROUP == T023.MATKL
  • C_SLSORDCONFANLYTSQRY.MATERIALGROUP == T023.MATKL
Product hierarchy: order item
  • Client
  • Product hierarchy
  • C_SLSORDCONFANLYTSQRY.MANDT == T179.MANDT
  • C_SLSORDCONFANLYTSQRY.PRODUCTHIERARCHYNODE == T179.PRODH
Retail promotion
  • Client
  • Retail Promotion
  • C_SLSORDCONFANLYTSQRY.MANDT == WAKH.MANDT
  • C_SLSORDCONFANLYTSQRY.RETAILPROMOTION == WAKH.AKTNR
Route
  • Client
  • Route
  • C_SLSORDCONFANLYTSQRY.MANDT == TVRO.MANDT
  • C_SLSORDCONFANLYTSQRY.ROUTE == TVRO.ROUTE
Sales Deal
  • Client
  • Sales Deal
  • C_SLSORDCONFANLYTSQRY.MANDT == KONA.MANDT
  • C_SLSORDCONFANLYTSQRY.SALESDEAL == KONA.KNUMA
Sales District
  • Client
  • Sales District
  • C_SLSORDCONFANLYTSQRY.MANDT == T171.MANDT
  • C_SLSORDCONFANLYTSQRY.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • C_SLSORDCONFANLYTSQRY.MANDT == TVAG.MANDT
  • C_SLSORDCONFANLYTSQRY.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales Order Item Category
  • Client
  • Sales Order Item Category
  • C_SLSORDCONFANLYTSQRY.MANDT == TVPT.MANDT
  • C_SLSORDCONFANLYTSQRY.SALESORDERITEMCATEGORY == TVPT.PSTYV
Sales Promotion
  • Client
  • Sales Promotion
  • C_SLSORDCONFANLYTSQRY.MANDT == KONA.MANDT
  • C_SLSORDCONFANLYTSQRY.SALESPROMOTION == KONA.KNUMA
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_SLSORDCONFANLYTSQRY.MANDT == TVST.MANDT
  • C_SLSORDCONFANLYTSQRY.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • C_SLSORDCONFANLYTSQRY.MANDT == T173.MANDT
  • C_SLSORDCONFANLYTSQRY.SHIPPINGTYPE == T173.VSART
Customer Classification
  • Customer Classification
  • Client
  • C_SLSORDCONFANLYTSQRY.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
  • C_SLSORDCONFANLYTSQRY.MANDT == TKUKL.MANDT
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • C_SLSORDCONFANLYTSQRY.STORAGELOCATION == T001L.LGORT
  • C_SLSORDCONFANLYTSQRY.MANDT == T001L.MANDT
  • C_SLSORDCONFANLYTSQRY.PRODUCTIONPLANT == T001L.WERKS