I_ARunAnlytsSlsOrdRetCube

Sales Order Returns - Cube | view: IARNALYSSORETC | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, KNA1, MARA, MARC
Column Name Description
RequirementDocumentNumber FK Sales Document
RequirementDocumentItem Sales Document Item
SupplyScheduleLine Schedule Line Number
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
💲 Display Currency (DisplayCurrency):
NetAmount Net Value in Display Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
TotalQuantity Overall confirmed sales order schedule lines: quantity
OpenSupplyQuantity null
Column Name Description
SupplyDeliveryDate Requested Delivery Date
ProductAvailabilityDate Requested Delivery Date
RequestedDeliveryDate Requested Delivery Date
Column Name Description
Column Name Description Domain name
AssignedSupplyType null
SupAssgmtSource null
Plant Plant (Own or External) WERKS
OrderType Sales Document Type AUART
StockSegment Requirement Segment SGT_SRCA
PurchasingOrganization Purchasing organization EKORG
PurchasingGroup Purchasing Group EKGRP
Batch Batch Number CHARG
StorageLocation Storage location LGORT
Customer null
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
NmbrOfItemsInOrder Item Issues in Order ITEM_ISSUES
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_ARUNANLYTSSLSORDRETCUBE.BASEUNIT == T006.MSEHI
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == T006.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_ARUNANLYTSSLSORDRETCUBE.COMPANYCODE == T001.BUKRS
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_ARUNANLYTSSLSORDRETCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == MARA.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_ARUNANLYTSSLSORDRETCUBE.SALESORGANIZATION == TVKOV.VKORG
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == TVKOV.MANDT
  • I_ARUNANLYTSSLSORDRETCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • I_ARUNANLYTSSLSORDRETCUBE.DIVISION == TVTA.SPART
  • I_ARUNANLYTSSLSORDRETCUBE.SALESORGANIZATION == TVTA.VKORG
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == TVTA.MANDT
  • I_ARUNANLYTSSLSORDRETCUBE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == TCURC.MANDT
  • I_ARUNANLYTSSLSORDRETCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Material: order item
  • Material Number
  • Client
  • I_ARUNANLYTSSLSORDRETCUBE.PRODUCT == MARA.MATNR
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_ARUNANLYTSSLSORDRETCUBE.PRODUCTGROUP == T023.MATKL
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • I_ARUNANLYTSSLSORDRETCUBE.PRODUCTTYPE == T134.MTART
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == T134.MANDT
Sales District
  • Client
  • Sales District
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == T171.MANDT
  • I_ARUNANLYTSSLSORDRETCUBE.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == TVAG.MANDT
  • I_ARUNANLYTSSLSORDRETCUBE.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales organization in order header
  • Sales Organization
  • Client
  • I_ARUNANLYTSSLSORDRETCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_ARUNANLYTSSLSORDRETCUBE.MANDT == TVKO.MANDT