C_ARunAnlytsSalesReturnsQry

Return Sales Orders | view: CARNANLYTSRETSOQ | Extraction: Not supported | Component: Order Allocation Run

Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, KNA1, MARA, MARC

🔑 Keys (3)
💰 Amounts (2)
∑ Quantities (2)
📅 Dates (3)
☰ Categorical
Other (12)
🔗 Relations (13)

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)
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
NmbrOfItemsInOrder	Item Issues in Order

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == T006.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.BASEUNIT == T006.MSEHI`
Company Code to Be Billed Client Company Code to Be Billed	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == T001.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.COMPANYCODE == T001.BUKRS`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == MARA.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Distribution channel in order header Client Distribution Channel Sales Organization	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == TVKOV.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG` `C_ARUNANLYTSSALESRETURNSQRY.SALESORGANIZATION == TVKOV.VKORG`
Division in order header Client Distribution Channel Division Sales Organization	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == TVTA.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.DISTRIBUTIONCHANNEL == TVTA.VTWEG` `C_ARUNANLYTSSALESRETURNSQRY.DIVISION == TVTA.SPART` `C_ARUNANLYTSSALESRETURNSQRY.SALESORGANIZATION == TVTA.VKORG`
SD Document Currency Client SD Document Currency	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == TCURC.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.DOCUMENTCURRENCY == TCURC.WAERS`
Material: order item Client Material Number	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == MARA.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.PRODUCT == MARA.MATNR`
Material Group Client Material Group	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == T023.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.PRODUCTGROUP == T023.MATKL`
Material type Client Material type	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == T134.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.PRODUCTTYPE == T134.MTART`
Sales District Client Sales District	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == T171.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.SALESDISTRICT == T171.BZIRK`
Reason for Rejection of Sales Documents Client Reason for Rejection of Sales Documents	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == TVAG.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.SALESDOCUMENTRJCNREASON == TVAG.ABGRU`
Sales organization in order header Client Sales Organization	`C_ARUNANLYTSSALESRETURNSQRY.MANDT == TVKO.MANDT` `C_ARUNANLYTSSALESRETURNSQRY.SALESORGANIZATION == TVKO.VKORG`