Arun_Reqsrt_Sd

Requirement sorting - SD | view: V_ARUN_SRT_SD | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, KNVV, MARA, MARC
Column Name Description
Column Name Description
Column Name Description
Column Name Description
erdat Date on which the record was created
audat Document Date (Date Received/Sent)
vdatu Requested Delivery Date
bstdk Customer Reference Date
fsh_candate Cancellation Date
Column Name Description
vbtyp SD Document Category Show values
shkzg Returns Item Show values
xchpf Batch Management Requirement Indicator for Plant Show values
sgt_stk_prt Stock Protection Indicator [Obsolete] Show values
Column Name Description Domain name
vbeln Sales Document VBELN
aufnr Sales Document VBELN
bstnk Customer Reference BSTNK
posnr Sales Document Item POSNR
werks Plant (Own or External) WERKS
sgt_rcat Requirement Segment SGT_SRCA
grkor Delivery Group (Items are delivered together) GRKOR
uepos Higher-Level Item in Bill of Material Structures POSNR
Master Data Relations Join Conditions
Order type in order header
  • Sales Document Type
  • Sales Document Type
  • Client
  • ARUN_REQSRT_SD.BSART == TVAK.AUART
  • ARUN_REQSRT_SD.AUART == TVAK.AUART
  • ARUN_REQSRT_SD.MANDT == TVAK.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • ARUN_REQSRT_SD.AUGRU == TVAU.AUGRU
  • ARUN_REQSRT_SD.MANDT == TVAU.MANDT
Order type in order header
  • Sales Document Type
  • Sales Document Type
  • Client
  • ARUN_REQSRT_SD.BSART == TVAK.AUART
  • ARUN_REQSRT_SD.AUART == TVAK.AUART
  • ARUN_REQSRT_SD.MANDT == TVAK.MANDT
Batch Number
  • Plant (Own or External)
  • Batch Number
  • Material Number
  • Client
  • ARUN_REQSRT_SD.WERKS == MCHA.WERKS
  • ARUN_REQSRT_SD.CHARG == MCHA.CHARG
  • ARUN_REQSRT_SD.MATNR == MCHA.MATNR
  • ARUN_REQSRT_SD.MANDT == MCHA.MANDT
Fashion Collection
  • Season
  • Season Year
  • Client
  • Fashion Collection
Customer Group 10
  • Customer Group 10
  • Sales Organization
  • Client
Customer Group 6
  • Customer Group 6
  • Sales Organization
  • Client
  • ARUN_REQSRT_SD.FSH_KVGR6 == FSH_TVV6.KVGR6
  • ARUN_REQSRT_SD.VKORG == FSH_TVV6.VKORG
  • ARUN_REQSRT_SD.MANDT == FSH_TVV6.MANDT
Customer Group 7
  • Sales Organization
  • Client
  • Customer Group 7
  • ARUN_REQSRT_SD.VKORG == FSH_TVV7.VKORG
  • ARUN_REQSRT_SD.MANDT == FSH_TVV7.MANDT
  • ARUN_REQSRT_SD.FSH_KVGR7 == FSH_TVV7.KVGR7
Customer Group 8
  • Customer Group 8
  • Sales Organization
  • Client
  • ARUN_REQSRT_SD.FSH_KVGR8 == FSH_TVV8.KVGR8
  • ARUN_REQSRT_SD.VKORG == FSH_TVV8.VKORG
  • ARUN_REQSRT_SD.MANDT == FSH_TVV8.MANDT
Customer Group 9
  • Sales Organization
  • Customer Group 9
  • Client
  • ARUN_REQSRT_SD.VKORG == FSH_TVV9.VKORG
  • ARUN_REQSRT_SD.FSH_KVGR9 == FSH_TVV9.KVGR9
  • ARUN_REQSRT_SD.MANDT == FSH_TVV9.MANDT
Release Rule
  • Release Rule
  • Client
Season
  • Season
  • Season Year
  • Client
Season Year
  • Season
  • Season Year
  • Client
Fashion Theme
  • Season
  • Season Year
  • Client
  • Fashion Collection
  • Fashion Theme
  • ARUN_REQSRT_SD.FSH_SEASON == FSH_THEMES.FSH_SEASON
  • ARUN_REQSRT_SD.FSH_SEASON_YEAR == FSH_THEMES.FSH_SEASON_YEAR
  • ARUN_REQSRT_SD.MANDT == FSH_THEMES.MANDT
  • ARUN_REQSRT_SD.FSH_COLLECTION == FSH_THEMES.FSH_COLLECTION
  • ARUN_REQSRT_SD.FSH_THEME == FSH_THEMES.FSH_THEME
Customer Group
  • Customer Group
  • Client
  • ARUN_REQSRT_SD.KDGRP == T151.KDGRP
  • ARUN_REQSRT_SD.MANDT == T151.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • ARUN_REQSRT_SD.KUNNR == KNA1.KUNNR
  • ARUN_REQSRT_SD.MANDT == KNA1.MANDT
Customer Group 1
  • Client
  • Customer Group 1
  • ARUN_REQSRT_SD.MANDT == TVV1.MANDT
  • ARUN_REQSRT_SD.KVGR1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • ARUN_REQSRT_SD.KVGR2 == TVV2.KVGR2
  • ARUN_REQSRT_SD.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • ARUN_REQSRT_SD.KVGR3 == TVV3.KVGR3
  • ARUN_REQSRT_SD.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • ARUN_REQSRT_SD.KVGR4 == TVV4.KVGR4
  • ARUN_REQSRT_SD.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • ARUN_REQSRT_SD.MANDT == TVV5.MANDT
  • ARUN_REQSRT_SD.KVGR5 == TVV5.KVGR5
Storage location
  • Plant (Own or External)
  • Client
  • Storage location
  • ARUN_REQSRT_SD.WERKS == T001L.WERKS
  • ARUN_REQSRT_SD.MANDT == T001L.MANDT
  • ARUN_REQSRT_SD.LGORT == T001L.LGORT
Delivery Priority
  • Delivery Priority
  • Client
  • ARUN_REQSRT_SD.LPRIO == TPRIO.LPRIO
  • ARUN_REQSRT_SD.MANDT == TPRIO.MANDT
Material Group
  • Material Group
  • Client
  • ARUN_REQSRT_SD.MATKL == T023.MATKL
  • ARUN_REQSRT_SD.MANDT == T023.MANDT
Material: order item
  • Material Number
  • Client
  • ARUN_REQSRT_SD.MATNR == MARA.MATNR
  • ARUN_REQSRT_SD.MANDT == MARA.MANDT
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • ARUN_REQSRT_SD.MANDT == T006.MANDT
  • ARUN_REQSRT_SD.MEINS == T006.MSEHI
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • ARUN_REQSRT_SD.MANDT == MARA.MANDT
  • ARUN_REQSRT_SD.SATNR == MARA.MATNR
Segmentation Strategy
  • ?
  • Client
  • Segmentation Strategy
  • ARUN_REQSRT_SD.[column in domain "WERKS_D"] == SGT_COVS_T.WERKS
  • ARUN_REQSRT_SD.MANDT == SGT_COVS_T.MANDT
  • ARUN_REQSRT_SD.SGT_COVS == SGT_COVS_T.SGT_COVS
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • ARUN_REQSRT_SD.SOBKZ == T148.SOBKZ
  • ARUN_REQSRT_SD.MANDT == T148.MANDT
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • ARUN_REQSRT_SD.SPART == TVTA.SPART
  • ARUN_REQSRT_SD.VKORG == TVTA.VKORG
  • ARUN_REQSRT_SD.MANDT == TVTA.MANDT
  • ARUN_REQSRT_SD.VTWEG == TVTA.VTWEG
Sales organization in order header
  • Sales Organization
  • Client
  • ARUN_REQSRT_SD.VKORG == TVKO.VKORG
  • ARUN_REQSRT_SD.MANDT == TVKO.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • ARUN_REQSRT_SD.VKORG == TVKOV.VKORG
  • ARUN_REQSRT_SD.MANDT == TVKOV.MANDT
  • ARUN_REQSRT_SD.VTWEG == TVKOV.VTWEG