I_ARunAnlytsSalesReturns

Return Sales Order | view: IARNANLYTSRETSO | 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
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
TotalQuantity Overall confirmed sales order schedule lines: quantity
OpenSupplyQuantity null
RequestedRqmtQtyInBaseUnit Requested Order Quantity in Base Unit
Column Name Description
SupplyDeliveryDate Requested Delivery Date
ProductAvailabilityDate Requested Delivery Date
RequestedDeliveryDate Requested Delivery Date
FashionCancelDate Cancellation Date
Column Name Description
Column Name Description Domain name
SupplyScheduleLine Schedule Line Number ETENR
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
RequirementSegment Requirement Segment SGT_SRCA
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_ARUNANLYTSSALESRETURNS.MANDT == T006.MANDT
  • I_ARUNANLYTSSALESRETURNS.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • I_ARUNANLYTSSALESRETURNS.MANDT == T001.MANDT
  • I_ARUNANLYTSSALESRETURNS.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_ARUNANLYTSSALESRETURNS.MANDT == MARA.MANDT
  • I_ARUNANLYTSSALESRETURNS.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_ARUNANLYTSSALESRETURNS.MANDT == TVKOV.MANDT
  • I_ARUNANLYTSSALESRETURNS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • I_ARUNANLYTSSALESRETURNS.MANDT == TVTA.MANDT
  • I_ARUNANLYTSSALESRETURNS.DIVISION == TVTA.SPART
  • I_ARUNANLYTSSALESRETURNS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVTA.VKORG
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNANLYTSSALESRETURNS.MANDT == TCURC.MANDT
  • I_ARUNANLYTSSALESRETURNS.DOCUMENTCURRENCY == TCURC.WAERS
Material: order item
  • Client
  • Material Number
  • I_ARUNANLYTSSALESRETURNS.MANDT == MARA.MANDT
  • I_ARUNANLYTSSALESRETURNS.PRODUCT == MARA.MATNR
Fashion Collection
  • Fashion Collection
  • Season
  • Season Year
  • Client
Material Group
  • Client
  • Material Group
  • I_ARUNANLYTSSALESRETURNS.MANDT == T023.MANDT
  • I_ARUNANLYTSSALESRETURNS.PRODUCTGROUP == T023.MATKL
Season
  • Season
  • Season Year
  • Client
  • I_ARUNANLYTSSALESRETURNS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNANLYTSSALESRETURNS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNANLYTSSALESRETURNS.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • I_ARUNANLYTSSALESRETURNS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNANLYTSSALESRETURNS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNANLYTSSALESRETURNS.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Fashion Collection
  • Season
  • Season Year
  • Fashion Theme
  • Client
  • I_ARUNANLYTSSALESRETURNS.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNANLYTSSALESRETURNS.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ARUNANLYTSSALESRETURNS.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ARUNANLYTSSALESRETURNS.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_ARUNANLYTSSALESRETURNS.MANDT == FSH_THEMES.MANDT
Material type
  • Client
  • Material type
  • I_ARUNANLYTSSALESRETURNS.MANDT == T134.MANDT
  • I_ARUNANLYTSSALESRETURNS.PRODUCTTYPE == T134.MTART
Sales District
  • Client
  • Sales District
  • I_ARUNANLYTSSALESRETURNS.MANDT == T171.MANDT
  • I_ARUNANLYTSSALESRETURNS.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_ARUNANLYTSSALESRETURNS.MANDT == TVAG.MANDT
  • I_ARUNANLYTSSALESRETURNS.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales group
  • Client
  • Sales group
  • Sales office
  • I_ARUNANLYTSSALESRETURNS.MANDT == TVBVK.MANDT
  • I_ARUNANLYTSSALESRETURNS.SALESGROUP == TVBVK.VKGRP
  • I_ARUNANLYTSSALESRETURNS.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • I_ARUNANLYTSSALESRETURNS.MANDT == TVKO.MANDT
  • I_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVKO.VKORG
Sold-to Party
  • Sold-to Party
  • Client
  • I_ARUNANLYTSSALESRETURNS.SOLDTOPARTY == KNA1.KUNNR
  • I_ARUNANLYTSSALESRETURNS.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Distribution Channel
  • Sales office
  • Sales Organization
  • I_ARUNANLYTSSALESRETURNS.MANDT == TVKBZ.MANDT
  • I_ARUNANLYTSSALESRETURNS.DIVISION == TVKBZ.SPART
  • I_ARUNANLYTSSALESRETURNS.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_ARUNANLYTSSALESRETURNS.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVKBZ.VKORG