C_ARunAnlytsSalesReturns

Return Sales Orders | view: CARNANLYTSRETSO | 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
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)
OrderType Sales Document Type AUART
StockSegment Requirement Segment
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
ProductCharacteristic1 Characteristic Value 1
ProductCharacteristic2 Characteristic Value 2
ProductCharacteristic3 Characteristic Value 3
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_ARUNANLYTSSALESRETURNS.BASEUNIT == T006.MSEHI
  • C_ARUNANLYTSSALESRETURNS.MANDT == T006.MANDT
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_ARUNANLYTSSALESRETURNS.MANDT == T001.MANDT
  • C_ARUNANLYTSSALESRETURNS.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_ARUNANLYTSSALESRETURNS.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_ARUNANLYTSSALESRETURNS.MANDT == MARA.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVKOV.VKORG
  • C_ARUNANLYTSSALESRETURNS.MANDT == TVKOV.MANDT
  • C_ARUNANLYTSSALESRETURNS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • C_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVTA.VKORG
  • C_ARUNANLYTSSALESRETURNS.MANDT == TVTA.MANDT
  • C_ARUNANLYTSSALESRETURNS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_ARUNANLYTSSALESRETURNS.DIVISION == TVTA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • C_ARUNANLYTSSALESRETURNS.MANDT == TCURC.MANDT
  • C_ARUNANLYTSSALESRETURNS.DOCUMENTCURRENCY == TCURC.WAERS
Material: order item
  • Material Number
  • Client
  • C_ARUNANLYTSSALESRETURNS.PRODUCT == MARA.MATNR
  • C_ARUNANLYTSSALESRETURNS.MANDT == MARA.MANDT
Fashion Collection
  • Fashion Collection
  • Season Year
  • Client
  • Season
Material Group
  • Material Group
  • Client
  • C_ARUNANLYTSSALESRETURNS.PRODUCTGROUP == T023.MATKL
  • C_ARUNANLYTSSALESRETURNS.MANDT == T023.MANDT
Season
  • Season Year
  • Client
  • Season
  • C_ARUNANLYTSSALESRETURNS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNANLYTSSALESRETURNS.MANDT == FSH_SEASONS.MANDT
  • C_ARUNANLYTSSALESRETURNS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • C_ARUNANLYTSSALESRETURNS.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNANLYTSSALESRETURNS.MANDT == FSH_SEASONS.MANDT
  • C_ARUNANLYTSSALESRETURNS.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Fashion Collection
  • Fashion Theme
  • Season Year
  • Client
  • Season
  • C_ARUNANLYTSSALESRETURNS.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_ARUNANLYTSSALESRETURNS.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • C_ARUNANLYTSSALESRETURNS.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_ARUNANLYTSSALESRETURNS.MANDT == FSH_THEMES.MANDT
  • C_ARUNANLYTSSALESRETURNS.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
Material type
  • Client
  • Material type
  • C_ARUNANLYTSSALESRETURNS.MANDT == T134.MANDT
  • C_ARUNANLYTSSALESRETURNS.PRODUCTTYPE == T134.MTART
Sales District
  • Sales District
  • Client
  • C_ARUNANLYTSSALESRETURNS.SALESDISTRICT == T171.BZIRK
  • C_ARUNANLYTSSALESRETURNS.MANDT == T171.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • C_ARUNANLYTSSALESRETURNS.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • C_ARUNANLYTSSALESRETURNS.MANDT == TVAG.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • C_ARUNANLYTSSALESRETURNS.MANDT == TVBVK.MANDT
  • C_ARUNANLYTSSALESRETURNS.SALESOFFICE == TVBVK.VKBUR
  • C_ARUNANLYTSSALESRETURNS.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • C_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVKO.VKORG
  • C_ARUNANLYTSSALESRETURNS.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_ARUNANLYTSSALESRETURNS.SOLDTOPARTY == KNA1.KUNNR
  • C_ARUNANLYTSSALESRETURNS.MANDT == KNA1.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • Sales office
  • C_ARUNANLYTSSALESRETURNS.SALESORGANIZATION == TVKBZ.VKORG
  • C_ARUNANLYTSSALESRETURNS.MANDT == TVKBZ.MANDT
  • C_ARUNANLYTSSALESRETURNS.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_ARUNANLYTSSALESRETURNS.DIVISION == TVKBZ.SPART
  • C_ARUNANLYTSSALESRETURNS.SALESOFFICE == TVKBZ.VKBUR