I_SlsOrdDelivPerfAnlytsCube

Delivery Performance - Cube | view: ISDSLSORDDLVPRFC | TRAN | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, SCAL_TT_DATE, SCAL_TT_YEAR, LIKP, LIPS, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAK, VBAP, VBKD, VEDA, VBEP, /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
Column Name Description
SalesOrder FK Sales Order
SalesOrderItem Sales Order Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of Sales Order in Transaction 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
IncomingSalesOrdersNetAmount Incoming Sales Orders Net Value in Transaction Currency
DlvrdAsReqdSlsDocItmNetAmt Items Delivered as Requested Value in Transaction Currency
ShpdAsPlndSlsDocItmNetAmt Items Shipped as Planned Value in Transaction Currency
DlvrdAsCmtdSlsDocItmNetAmt Items Delivered as Committed Value in Transaction Currency
💲 Display Currency (DisplayCurrency):
NetAmountInDisplayCurrency Net Value in Display Currency
IncomingSalesOrdersNetAmtInDC Incoming Sales Orders Net Value In Display Currency
DlvrdAsReqdSlsDocItmNetAmtInDC Items Delivered as Requested Value in Display Currency
ShpdAsPlndSlsDocItmNetAmtInDC Items Shipped as Planned Value in Display Currency
DlvrdAsCmtdSlsDocItmNetAmtInDC Items Delivered as Committed Value in Display Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
CommittedDelivQtyInOrdQtyUnit Committed Delivery Quantity in Order Quantity Unit
TargetDelivQtyInOrderQtyUnit Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
DeliveredQuantityInSalesUnit Actual Delivered Quantity in Sales Unit of Measure
📏 Base Unit of Measure (BaseUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
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
CommittedDeliveryDate Delivery Date that the Supplier has Committed to
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
EarliestReqdDelivDate Requested Delivery Date of Earliest Scheduled Delivery
EarliestPlndGIDate Planned Goods Issue Date of Earliest Scheduled Delivery
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesOrderItemType Sales Order Item Type Show values
IsReturnsItem Returns Item Show values
QuantityIsFixed Quantity is fixed 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
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
SlsDocItmDelivFlfmtSts Processing Status of Sales Order Item Delivery Fulfillment 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
ReqdDelivDateYear Year of Requested Delivery Date NUM4
ReqdDelivDateYearQuarter Quarter of Requested Delivery Date NUM5
ReqdDelivDateYearMonth Month of Requested Delivery Date NUM6
ReqdDelivDateYearWeek Week of Requested Delivery Date NUM6
CmtdDelivDateYear Year of Committed Delivery Date NUM4
CmtdDelivDateYearQuarter Quarter of Committed Delivery Date NUM5
CmtdDelivDateYearMonth Month of Committed Delivery Date NUM6
CmtdDelivDateYearWeek Week of Committed Delivery Date NUM6
PlndGIDateYear Year of Planned Goods Issue Date NUM4
PlndGIDateYearQuarter Quarter of Planned Goods Issue Date NUM5
PlndGIDateYearMonth Month of Planned Goods Issue Date NUM6
PlndGIDateYearWeek Week of Planned Goods Issue Date 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
Plant Plant (Own or External) WERKS
ProductionPlantName Plant Name TEXT30
StorageLocationName Storage Location Name TEXT16
ProductConfiguration Product Configuration CUOBJ
MRPArea MRP Area BERID
SoldToParty Sold-to Party KUNNR
SoldToPartyName Name of Sold-to Party TEXT80
ShipToParty Ship-to Party KUNNR
ShipToPartyName Name of Ship-to Party TEXT80
PayerParty Payer KUNNR
PayerPartyName Payer Name TEXT80
BillToParty Bill-to Party KUNNR
BillToPartyName Name of Bill-to Party TEXT80
ResponsibleEmployee Employee Responsible PERNR
ResponsibleEmployeeName Name of Employee Responsible TEXT80
SalesEmployee Sales Employee PERNR
SalesEmployeeName Name of Sales Employee TEXT80
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
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
TargetToBaseQuantityDnmntr Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
TargetToBaseQuantityNmrtr Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
SalesDealDescription Sales Deal Description TEXT40
SalesOrderCondition Sales Order Condition KNUMV
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
NetPriceQuantity Condition Pricing Unit KPEIN
ShippingCondition Shipping Conditions VSBED
MaxNmbrOfPartialDelivery Number of Allowed Partial Deliveries ANTLF
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance Limit in Percent PRZ21
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
CostCenter Cost Center KOSTL
ControllingAreaName Controlling Area Name TEXT25
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating SD Document 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
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
NumberOfIncomingSlsOrderItems Number of Incoming Sales Order Items
NmbrOfDlvrdAsReqdSlsDocItems Number of Sales Order Items Delivered as Requested
NmbrOfShippedAsPlndSlsDocItems Number of Sales Order Items Shipped as Planned
DelivToReqdDelivDelayInDays Delay of Delivery Compared to Requested Deliv. Date (Days)
MaxDelivToReqdDelivDelayInDays Max. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
TotDelivToReqdDelivDelayInDays Tot. Delay of Deliv. Compared to the Reqd Deliv. Date (Days)
GIToPlndGIDelayInDays Delay of Goods Issue Compared to the Planned GI Date (Days)
MaxGIToPlndGIDelayInDays Max. Delay of GI Compared to the Planned GI Date (Days)
TotGIToPlndGIDelayInDays Tot. Delay of GI Compared to the Planned GI Date (Days)
NrOfDelivCmtdSlsDocItems Number of Sales Order Items Committed for Delivery
NrOfDlvrdAsCmtdSlsDocItems Number of Sales Order Items Delivered as Committed
DelivToCmtdDelivDelayInDays Delay of Delivery Compared to Committed Deliv. Date (Days)
MaxDelivToCmtdDelivDelayInDays Max. Delay of Deliv. Compared to the Cmtd Deliv. Date (Days)
TotDelivToCmtdDelivDelayInDays Tot. Delay of Deliv. Compared to the Cmtd Deliv. Date (Days)
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVM1.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVM2.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Material Group 3
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVM3.MANDT
Material Group 4
  • Client
  • Material Group 4
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVM4.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVM5.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.BASEUNIT == T006.MSEHI
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T006.MANDT
Batch Number
  • Material Number
  • Product Number
  • Batch Number
  • Client
  • Plant (Own or External)
  • I_SLSORDDELIVPERFANLYTSCUBE.MATERIAL == MCHA.MATNR
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODUCT == MCHA.MATNR
  • I_SLSORDDELIVPERFANLYTSCUBE.BATCH == MCHA.CHARG
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == MCHA.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.PLANT == MCHA.WERKS
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.BILLINGCOMPANYCODE == T001.BUKRS
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.BUSINESSAREA == TGSB.GSBER
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.CONTROLLINGAREA == TKA01.KOKRS
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TKA01.MANDT
Business Area from Cost Center
  • Business Area from Cost Center
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.COSTCENTERBUSINESSAREA == TGSB.GSBER
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TGSB.MANDT
Credit control area
  • Credit control area
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.CREDITCONTROLAREA == T014.KKBER
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T014.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.CUSTOMERGROUP == T151.KDGRP
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T151.MANDT
Customer Purchase Order Type
  • Customer Purchase Order Type
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T176.MANDT
Customer Rebate Agreement
  • Customer Rebate Agreement
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.CUSTOMERREBATEAGREEMENT == KONA.KNUMA
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == KONA.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TPRIO.MANDT
Division
  • Division
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.DIVISION == TSPA.SPART
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TSPA.MANDT
Exchange Rate Type
  • Exchange Rate Type
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.EXCHANGERATETYPE == TCURV.KURST
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TCURV.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.INCOTERMSVERSION == TINCV.INCOV
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TINCV.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T148.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Billing Block Reason for Item
  • Billing Block Reason for Item
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVFS.MANDT
Volume unit
  • Volume unit
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ITEMVOLUMEUNIT == T006.MSEHI
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ITEMWEIGHTUNIT == T006.MSEHI
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T006.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.MATERIAL == MARA.MATNR
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODUCT == MARA.MATNR
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Product Group
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.MATERIALGROUP == T023.MATKL
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODUCTGROUP == T023.MATKL
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T023.MANDT
Reason for material substitution
  • Reason for material substitution
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVSU.MANDT
Condition Unit
  • Condition Unit
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.NETPRICEQUANTITYUNIT == T006.MSEHI
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T006.MANDT
Order Number
  • Order Number
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ORDERID == AUFK.AUFNR
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == AUFK.MANDT
Sales unit
  • Sales unit
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ORDERQUANTITYUNIT == T006.MSEHI
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T006.MANDT
Material Entered
  • Material Entered
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == MARA.MANDT
Payment Method
  • ?
  • Client
  • Payment Method
  • I_SLSORDDELIVPERFANLYTSCUBE.[column in domain "LAND1"] == T042Z.LAND1
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T042Z.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.PAYMENTMETHOD == T042Z.ZLSCH
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODAVAILABILITYCHECKGROUP == TMVF.MTVFP
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TMVF.MANDT
Material: order item
  • Material Number
  • Product Number
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.MATERIAL == MARA.MATNR
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODUCT == MARA.MATNR
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == MARA.MANDT
Product Catalog
  • Product Catalog Number
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODUCTCATALOG == WWMI.WMINR
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == WWMI.MANDT
Product Group
  • Material Group
  • Product Group
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.MATERIALGROUP == T023.MATKL
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODUCTGROUP == T023.MATKL
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T023.MANDT
Product hierarchy: order item
  • Client
  • Product hierarchy
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T179.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.PRODUCTHIERARCHYNODE == T179.PRODH
Retail promotion
  • Client
  • Retail Promotion
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == WAKH.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.RETAILPROMOTION == WAKH.AKTNR
Route
  • Route
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.ROUTE == TVRO.ROUTE
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVRO.MANDT
Sales Deal
  • Sales Deal
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SALESDEAL == KONA.KNUMA
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == KONA.MANDT
Sales District
  • Sales District
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SALESDISTRICT == T171.BZIRK
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T171.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVAG.MANDT
Sales Order Item Category
  • Sales Order Item Category
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SALESORDERITEMCATEGORY == TVPT.PSTYV
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVPT.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SALESPROMOTION == KONA.KNUMA
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == KONA.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SHIPPINGPOINT == TVST.VSTEL
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TVST.MANDT
Shipping Type
  • Shipping Type
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SHIPPINGTYPE == T173.VSART
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T173.MANDT
Customer Classification
  • Customer Classification
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.SOLDTOPARTYCLASSIFICATION == TKUKL.KUKLA
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TKUKL.MANDT
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • I_SLSORDDELIVPERFANLYTSCUBE.STORAGELOCATION == T001L.LGORT
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T001L.MANDT
  • I_SLSORDDELIVPERFANLYTSCUBE.PLANT == T001L.WERKS
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.TARGETQUANTITYUNIT == T006.MSEHI
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == T006.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_SLSORDDELIVPERFANLYTSCUBE.TRANSACTIONCURRENCY == TCURC.WAERS
  • I_SLSORDDELIVPERFANLYTSCUBE.MANDT == TCURC.MANDT