C_SalesOrderItemQry

Sales Order Item - Query | view: CSDSLSORDERITEMQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, VBKD, VEDA, VBAK, FPLT, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP, /CPD/D_MP_HDR, /CPD/D_MP_ITEM, BUT000, TKA01, KNA1, T001W, KONA, TVKO, T000, T001L, T006, T006A, USR21
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Net Value in Display Currency
IncomingSalesOrdersNetAmtInDC Incoming Sales Orders Net Value In Display Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
IncomingSalesOrdersQuantity Incoming Sales Orders Quantity
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
CustomerPurchaseOrderDate Customer Reference Date
SalesOrderDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
Column Name Description
SalesOrderItemType Sales Order Item Type Show values
IsReturnsItem Returns Item Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
ItemIsBillingRelevant Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document 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
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
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 Central Credit Check Status 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 (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
Column Name Description Domain name
SalesOrderType Sales Document Type AUART
NumberOfIncomingSlsOrderItems Number of Incoming Sales Order Items
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
SalesOrderDateYear Year of Order NUM4
SalesOrderDateYearQuarter Quarter of Order NUM5
SalesOrderDateYearMonth Month of Order 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
ShipToParty Ship-to Party KUNNR
BillToParty Bill-to Party KUNNR
PayerParty Payer KUNNR
SalesEmployee Sales Employee PERNR
ResponsibleEmployee Employee Responsible PERNR
PurchaseOrderByCustomer Customer Reference BSTKD
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
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
SalesOrderItemText Short Text for Sales Order Item TEXT40
MaterialByCustomer Material Number Used by Customer IDNEX
SalesOrderCondition Sales Order Condition KNUMV
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
Plant Plant (Own or External) WERKS
CustomerPaymentTerms Terms of payment key ZTERM
CustomerProject Commercial Project ID /CPD/MP_ID
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
AdditionalValueDays Additional Value Days TAGE2
CostCenter Cost Center KOSTL
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • C_SALESORDERITEMQRY.MANDT == TVM1.MANDT
  • C_SALESORDERITEMQRY.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Material Group 2
  • Client
  • C_SALESORDERITEMQRY.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
  • C_SALESORDERITEMQRY.MANDT == TVM2.MANDT
Material Group 3
  • Material Group 3
  • Client
  • C_SALESORDERITEMQRY.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • C_SALESORDERITEMQRY.MANDT == TVM3.MANDT
Material Group 4
  • Material Group 4
  • Client
  • C_SALESORDERITEMQRY.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • C_SALESORDERITEMQRY.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • C_SALESORDERITEMQRY.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • C_SALESORDERITEMQRY.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SALESORDERITEMQRY.BASEUNIT == T006.MSEHI
  • C_SALESORDERITEMQRY.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Product Number
  • Material Number
  • Plant (Own or External)
  • Client
  • C_SALESORDERITEMQRY.BATCH == MCHA.CHARG
  • C_SALESORDERITEMQRY.PRODUCT == MCHA.MATNR
  • C_SALESORDERITEMQRY.MATERIAL == MCHA.MATNR
  • C_SALESORDERITEMQRY.PLANT == MCHA.WERKS
  • C_SALESORDERITEMQRY.MANDT == MCHA.MANDT
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_SALESORDERITEMQRY.MANDT == T001.MANDT
  • C_SALESORDERITEMQRY.BILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Business Area
  • Client
  • C_SALESORDERITEMQRY.BUSINESSAREA == TGSB.GSBER
  • C_SALESORDERITEMQRY.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_SALESORDERITEMQRY.CONTROLLINGAREA == TKA01.KOKRS
  • C_SALESORDERITEMQRY.MANDT == TKA01.MANDT
Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • C_SALESORDERITEMQRY.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • C_SALESORDERITEMQRY.MANDT == TGSB.MANDT
Credit control area
  • Credit control area
  • Client
  • C_SALESORDERITEMQRY.CREDITCONTROLAREA == T014.KKBER
  • C_SALESORDERITEMQRY.MANDT == T014.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • C_SALESORDERITEMQRY.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • C_SALESORDERITEMQRY.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • C_SALESORDERITEMQRY.CUSTOMERGROUP == T151.KDGRP
  • C_SALESORDERITEMQRY.MANDT == T151.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • C_SALESORDERITEMQRY.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • C_SALESORDERITEMQRY.MANDT == T176.MANDT
Customer Rebate Agreement
  • Customer Rebate Agreement
  • Client
  • C_SALESORDERITEMQRY.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
  • C_SALESORDERITEMQRY.MANDT == KONA.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_SALESORDERITEMQRY.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_SALESORDERITEMQRY.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_SALESORDERITEMQRY.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_SALESORDERITEMQRY.MANDT == TPRIO.MANDT
Division
  • Division
  • Client
  • C_SALESORDERITEMQRY.DIVISION == TSPA.SPART
  • C_SALESORDERITEMQRY.MANDT == TSPA.MANDT
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • C_SALESORDERITEMQRY.MANDT == TVFS.MANDT
  • C_SALESORDERITEMQRY.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_SALESORDERITEMQRY.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_SALESORDERITEMQRY.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_SALESORDERITEMQRY.INCOTERMSVERSION == TINCV.INCOV
  • C_SALESORDERITEMQRY.MANDT == TINCV.MANDT
Billing Block Reason for Item
  • Billing Block Reason for Item
  • Client
  • C_SALESORDERITEMQRY.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • C_SALESORDERITEMQRY.MANDT == TVFS.MANDT
Material: order item
  • Product Number
  • Material Number
  • Client
  • C_SALESORDERITEMQRY.PRODUCT == MARA.MATNR
  • C_SALESORDERITEMQRY.MATERIAL == MARA.MATNR
  • C_SALESORDERITEMQRY.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • Product Group
  • C_SALESORDERITEMQRY.MANDT == T023.MANDT
  • C_SALESORDERITEMQRY.MATERIALGROUP == T023.MATKL
  • C_SALESORDERITEMQRY.PRODUCTGROUP == T023.MATKL
Order Number
  • Order Number
  • Client
  • C_SALESORDERITEMQRY.ORDERID == AUFK.AUFNR
  • C_SALESORDERITEMQRY.MANDT == AUFK.MANDT
Payment Method
  • ?
  • Payment Method
  • Client
  • C_SALESORDERITEMQRY.[column in domain "LAND1"] == T042Z.LAND1
  • C_SALESORDERITEMQRY.PAYMENTMETHOD == T042Z.ZLSCH
  • C_SALESORDERITEMQRY.MANDT == T042Z.MANDT
Material: order item
  • Product Number
  • Material Number
  • Client
  • C_SALESORDERITEMQRY.PRODUCT == MARA.MATNR
  • C_SALESORDERITEMQRY.MATERIAL == MARA.MATNR
  • C_SALESORDERITEMQRY.MANDT == MARA.MANDT
Product Group
  • Client
  • Material Group
  • Product Group
  • C_SALESORDERITEMQRY.MANDT == T023.MANDT
  • C_SALESORDERITEMQRY.MATERIALGROUP == T023.MATKL
  • C_SALESORDERITEMQRY.PRODUCTGROUP == T023.MATKL
Retail promotion
  • Retail Promotion
  • Client
  • C_SALESORDERITEMQRY.RETAILPROMOTION == WAKH.AKTNR
  • C_SALESORDERITEMQRY.MANDT == WAKH.MANDT
Route
  • Client
  • Route
  • C_SALESORDERITEMQRY.MANDT == TVRO.MANDT
  • C_SALESORDERITEMQRY.ROUTE == TVRO.ROUTE
Sales Deal
  • Sales Deal
  • Client
  • C_SALESORDERITEMQRY.SALESDEAL == KONA.KNUMA
  • C_SALESORDERITEMQRY.MANDT == KONA.MANDT
Sales District
  • Sales District
  • Client
  • C_SALESORDERITEMQRY.SALESDISTRICT == T171.BZIRK
  • C_SALESORDERITEMQRY.MANDT == T171.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_SALESORDERITEMQRY.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_SALESORDERITEMQRY.MANDT == TVAG.MANDT
Sales Order Item Category
  • Sales Order Item Category
  • Client
  • C_SALESORDERITEMQRY.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • C_SALESORDERITEMQRY.MANDT == TVPT.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • C_SALESORDERITEMQRY.SALESPROMOTION == KONA.KNUMA
  • C_SALESORDERITEMQRY.MANDT == KONA.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • C_SALESORDERITEMQRY.SHIPPINGPOINT == TVST.VSTEL
  • C_SALESORDERITEMQRY.MANDT == TVST.MANDT
Shipping Type
  • Shipping Type
  • Client
  • C_SALESORDERITEMQRY.SHIPPINGTYPE == T173.VSART
  • C_SALESORDERITEMQRY.MANDT == T173.MANDT
Storage location
  • Plant (Own or External)
  • Storage location
  • Client
  • C_SALESORDERITEMQRY.PLANT == T001L.WERKS
  • C_SALESORDERITEMQRY.STORAGELOCATION == T001L.LGORT
  • C_SALESORDERITEMQRY.MANDT == T001L.MANDT