P_ARunDmnd

Supply Assignment Run Demand Order Details | view: PARUNDMND | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, VBPA, VBPA, KNA1, KNA1, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, T161T, TVAKT, MARA, MARC, KNVV, CVI_VEND_LINK
Column Name Description
RequirementDocumentNumber FK Sales Document
RequirementDocumentItem Sales Document Item
RequirementType null
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
Column Name Description
Column Name Description
FashionCancelDate Cancellation Date
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
RequirementTypeName Short Text for Fixed Values DDTEXT
SoldToParty Sold-to Party KUNNR
ShipToParty Customer Number KUNNR
CustomerReferenceNumber Customer Reference BSTNK
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
ProfitCenter Profit Center PRCTR
Plant Plant (Own or External) WERKS
NetPriceQuantity Condition Pricing Unit KPEIN
RequirementSegment Requirement Segment SGT_SRCA
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
PaymentTerms Terms of payment key ZTERM
SupAssgmtOrdStatus null
RetailArticleColor Characteristic Value for Colors of Variants WRF_ATWRT
RetailArticleMainSize Characteristic Value for Main Sizes of Variants WRF_ATWRT
RetailArticleSecondSize Characteristic Value for Second Size for Variants WRF_ATWRT
OrderTypeName Sales Document Type Description TEXT20
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • P_ARUNDMND.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • P_ARUNDMND.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • P_ARUNDMND.MANDT == TVV2.MANDT
  • P_ARUNDMND.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • P_ARUNDMND.MANDT == TVV3.MANDT
  • P_ARUNDMND.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Client
  • Customer Group 4
  • P_ARUNDMND.MANDT == TVV4.MANDT
  • P_ARUNDMND.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • P_ARUNDMND.MANDT == TVV5.MANDT
  • P_ARUNDMND.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Release Rule
  • Client
  • Release Rule
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • P_ARUNDMND.MANDT == T006.MANDT
  • P_ARUNDMND.BASEUNIT == T006.MSEHI
Business Area
  • Client
  • Business Area
  • P_ARUNDMND.MANDT == TGSB.MANDT
  • P_ARUNDMND.BUSINESSAREA == TGSB.GSBER
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • P_ARUNDMND.MANDT == T001.MANDT
  • P_ARUNDMND.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • P_ARUNDMND.MANDT == MARA.MANDT
  • P_ARUNDMND.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • P_ARUNDMND.CUSTOMERGROUP == T151.KDGRP
  • P_ARUNDMND.MANDT == T151.MANDT
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • P_ARUNDMND.MANDT == TVLS.MANDT
  • P_ARUNDMND.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Priority
  • Client
  • Delivery Priority
  • P_ARUNDMND.MANDT == TPRIO.MANDT
  • P_ARUNDMND.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • P_ARUNDMND.MANDT == TVKOV.MANDT
  • P_ARUNDMND.SALESORGANIZATION == TVKOV.VKORG
  • P_ARUNDMND.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • Division
  • P_ARUNDMND.MANDT == TSPA.MANDT
  • P_ARUNDMND.DIVISION == TSPA.SPART
  • P_ARUNDMND.ORGANIZATIONDIVISION == TSPA.SPART
SD Document Currency
  • SD Document Currency
  • Client
  • P_ARUNDMND.DOCUMENTCURRENCY == TCURC.WAERS
  • P_ARUNDMND.MANDT == TCURC.MANDT
Billing Block for Item
  • Client
  • Billing Block for Item
  • P_ARUNDMND.MANDT == TVFS.MANDT
  • P_ARUNDMND.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Client
  • Material Number
  • P_ARUNDMND.MANDT == MARA.MANDT
  • P_ARUNDMND.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_ARUNDMND.MANDT == T023.MANDT
  • P_ARUNDMND.MATERIALGROUP == T023.MATKL
Order type in order header
  • Client
  • Sales Document Type
  • P_ARUNDMND.MANDT == TVAK.MANDT
  • P_ARUNDMND.ORDERTYPE == TVAK.AUART
Division in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • Division
  • P_ARUNDMND.MANDT == TVTA.MANDT
  • P_ARUNDMND.SALESORGANIZATION == TVTA.VKORG
  • P_ARUNDMND.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • P_ARUNDMND.DIVISION == TVTA.SPART
  • P_ARUNDMND.ORGANIZATIONDIVISION == TVTA.SPART
Partner function - Document partner
  • Client
  • Partner Function
  • P_ARUNDMND.MANDT == TPAR.MANDT
  • P_ARUNDMND.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Season Year
  • Client
  • Fashion Collection
  • Season
Season
  • Season Year
  • Client
  • Season
Season Year
  • Season Year
  • Client
  • Season
Fashion Theme
  • Fashion Theme
  • Season Year
  • Client
  • Fashion Collection
  • Season
  • P_ARUNDMND.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • P_ARUNDMND.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • P_ARUNDMND.MANDT == FSH_THEMES.MANDT
  • P_ARUNDMND.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • P_ARUNDMND.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
Sales District
  • Client
  • Sales District
  • P_ARUNDMND.MANDT == T171.MANDT
  • P_ARUNDMND.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • P_ARUNDMND.MANDT == TVPT.MANDT
  • P_ARUNDMND.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • P_ARUNDMND.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • P_ARUNDMND.MANDT == TVAG.MANDT
Sales group
  • Sales group
  • Client
  • Sales office
  • P_ARUNDMND.SALESGROUP == TVBVK.VKGRP
  • P_ARUNDMND.MANDT == TVBVK.MANDT
  • P_ARUNDMND.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • P_ARUNDMND.MANDT == TVKO.MANDT
  • P_ARUNDMND.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Shipping Conditions
  • Client
  • P_ARUNDMND.SHIPPINGCONDITION == TVSB.VSBED
  • P_ARUNDMND.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • P_ARUNDMND.MANDT == TVST.MANDT
  • P_ARUNDMND.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Plant (Own or External)
  • Client
  • Storage location
  • P_ARUNDMND.PLANT == T001L.WERKS
  • P_ARUNDMND.MANDT == T001L.MANDT
  • P_ARUNDMND.STORAGELOCATION == T001L.LGORT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales Organization
  • Distribution Channel
  • Division
  • Division
  • Sales office
  • P_ARUNDMND.MANDT == TVKBZ.MANDT
  • P_ARUNDMND.SALESORGANIZATION == TVKBZ.VKORG
  • P_ARUNDMND.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • P_ARUNDMND.DIVISION == TVKBZ.SPART
  • P_ARUNDMND.ORGANIZATIONDIVISION == TVKBZ.SPART
  • P_ARUNDMND.SALESOFFICE == TVKBZ.VKBUR