Arun_So_Reqmt

Sales Order Requirement | view: ARUN_V_SO_REQMT | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAP, VBAK, VBEP, VBPA, ARUN_BDBS, MARA, MARC, FSH_VASS_TL, KNVV, TVAK
Column Name Description
vbeln Sales Document
posnr Sales Document Item
etenr Schedule Line Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (meins):
menge Required quantity for mat.management in stockkeeping units
ralloc_qty null
kwmeng null
Column Name Description
erdat Date on which the record was created
audat Document Date (Date Received/Sent)
vdatu Requested Delivery Date
eindt Item delivery date
fsh_candate Cancellation Date
hfsh_candate Cancellation Date
stdat Key date of the bill of material
edatu Schedule line date
mbdat Material Staging/Availability Date
tddat Transportation Planning Date
lddat Loading Date
wadat Goods Issue Date
Column Name Description
vbtyp SD Document Category Show values
cmgst Overall Status of Credit Checks Show values
fsh_cq_check Requirement Relevance for Contract Show values
lfstk Delivery Status (All Items) Show values
fixmg Delivery Date and Quantity Fixed Show values
kowrr Statistical Values Show values
fsh_vas_rel VAS Relevant Show values
lfsta Delivery Status (Item) Show values
xchpf Batch Management Requirement Indicator for Plant Show values
sgt_stk_prt Stock Protection Indicator [Obsolete] Show values
fsh_req_rel Requirement Relevancy Flag for VAS Material Show values
Column Name Description Domain name
aufnr Sales Document VBELN
bstnk Customer Reference BSTNK
ernam Name of Person Responsible for Creating the Object USNAM
werks Plant (Own or External) WERKS
sgt_rcat Requirement Segment SGT_SRCA
stlnr Bill of Material STNUM
sposn BOM Item Number SPOSN
fsh_vas_prnt_id Item number of the SD document POSNR
fsh_transaction Transaction Number FSH_TRANSACTION
fsh_item_group Item Group FSH_ITEM_GROUP
fsh_item Item Number FSH_ITEM
bdart null
color_atinn Internal Charactieristic Number for Color Characteristics ATINN
size1_atinn Internal Char. Number for Characteristics for Main Sizes ATINN
size2_atinn Internal Char. Number for Characteristics for Second Sizes ATINN
color Characteristic Value for Colors of Variants WRF_ATWRT
size1 Characteristic Value for Main Sizes of Variants WRF_ATWRT
size2 Characteristic Value for Second Size for Variants WRF_ATWRT
fsh_increment VAS Increment FSH_VAS_INCREMENT
VBFA null
BDBS null
fsh_os_id Order Scheduling Group ID FSH_OS_ID
fsh_grid_cond_rec Grid Condition Record Number CHAR32
Master Data Relations Join Conditions
Order type in order header
  • Client
  • Sales Document Type
  • ARUN_SO_REQMT.MANDT == TVAK.MANDT
  • ARUN_SO_REQMT.AUART == TVAK.AUART
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • ARUN_SO_REQMT.AUGRU == TVAU.AUGRU
  • ARUN_SO_REQMT.MANDT == TVAU.MANDT
Requirements type
  • Client
  • Requirements type
  • ARUN_SO_REQMT.MANDT == T459A.MANDT
  • ARUN_SO_REQMT.BEDAE == T459A.BEDAE
Batch Number
  • Client
  • Plant (Own or External)
  • Batch Number
  • Material Number
  • ARUN_SO_REQMT.MANDT == MCHA.MANDT
  • ARUN_SO_REQMT.WERKS == MCHA.WERKS
  • ARUN_SO_REQMT.CHARG == MCHA.CHARG
  • ARUN_SO_REQMT.MATNR == MCHA.MATNR
Schedule line category
  • Client
  • Schedule line category
  • ARUN_SO_REQMT.MANDT == TVEP.MANDT
  • ARUN_SO_REQMT.ETTYP == TVEP.ETTYP
Fashion Collection
  • Season
  • Client
  • Fashion Collection
  • Season Year
Grouping Rule
  • Grouping Rule
  • Client
Customer Group 10
  • Customer Group 10
  • Client
  • Sales Organization
Customer Group 6
  • Customer Group 6
  • Client
  • Sales Organization
Customer Group 7
  • Client
  • Customer Group 7
  • Sales Organization
Customer Group 8
  • Client
  • Customer Group 8
  • Sales Organization
Customer Group 9
  • Customer Group 9
  • Client
  • Sales Organization
Release Rule
  • Client
  • Release Rule
Season
  • Season
  • Client
  • Season Year
Season Year
  • Season
  • Client
  • Season Year
Fashion Theme
  • Season
  • Client
  • Fashion Collection
  • Season Year
  • Fashion Theme
  • ARUN_SO_REQMT.FSH_SEASON == FSH_THEMES.FSH_SEASON
  • ARUN_SO_REQMT.MANDT == FSH_THEMES.MANDT
  • ARUN_SO_REQMT.FSH_COLLECTION == FSH_THEMES.FSH_COLLECTION
  • ARUN_SO_REQMT.FSH_SEASON_YEAR == FSH_THEMES.FSH_SEASON_YEAR
  • ARUN_SO_REQMT.FSH_THEME == FSH_THEMES.FSH_THEME
Customer - Document Customer
  • Client
  • Customer Number
  • Customer Number
  • Customer Number
  • Sold-to Party
  • ARUN_SO_REQMT.MANDT == KNA1.MANDT
  • ARUN_SO_REQMT.KUNWE == KNA1.KUNNR
  • ARUN_SO_REQMT.IKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.HKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.KUNNR == KNA1.KUNNR
Customer - Document Customer
  • Client
  • Customer Number
  • Customer Number
  • Customer Number
  • Sold-to Party
  • ARUN_SO_REQMT.MANDT == KNA1.MANDT
  • ARUN_SO_REQMT.KUNWE == KNA1.KUNNR
  • ARUN_SO_REQMT.IKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.HKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.KUNNR == KNA1.KUNNR
Customer Group
  • Client
  • Customer Group
  • ARUN_SO_REQMT.MANDT == T151.MANDT
  • ARUN_SO_REQMT.KDGRP == T151.KDGRP
Sold-to Party
  • Client
  • Customer Number
  • Customer Number
  • Customer Number
  • Sold-to Party
  • ARUN_SO_REQMT.MANDT == KNA1.MANDT
  • ARUN_SO_REQMT.KUNWE == KNA1.KUNNR
  • ARUN_SO_REQMT.IKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.HKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.KUNNR == KNA1.KUNNR
Customer - Document Customer
  • Client
  • Customer Number
  • Customer Number
  • Customer Number
  • Sold-to Party
  • ARUN_SO_REQMT.MANDT == KNA1.MANDT
  • ARUN_SO_REQMT.KUNWE == KNA1.KUNNR
  • ARUN_SO_REQMT.IKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.HKUNNR == KNA1.KUNNR
  • ARUN_SO_REQMT.KUNNR == KNA1.KUNNR
Customer Group 1
  • Customer Group 1
  • Client
  • ARUN_SO_REQMT.KVGR1 == TVV1.KVGR1
  • ARUN_SO_REQMT.MANDT == TVV1.MANDT
Customer Group 2
  • Client
  • Customer Group 2
  • ARUN_SO_REQMT.MANDT == TVV2.MANDT
  • ARUN_SO_REQMT.KVGR2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • ARUN_SO_REQMT.KVGR3 == TVV3.KVGR3
  • ARUN_SO_REQMT.MANDT == TVV3.MANDT
Customer Group 4
  • Client
  • Customer Group 4
  • ARUN_SO_REQMT.MANDT == TVV4.MANDT
  • ARUN_SO_REQMT.KVGR4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • ARUN_SO_REQMT.MANDT == TVV5.MANDT
  • ARUN_SO_REQMT.KVGR5 == TVV5.KVGR5
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • ARUN_SO_REQMT.MANDT == T001L.MANDT
  • ARUN_SO_REQMT.WERKS == T001L.WERKS
  • ARUN_SO_REQMT.LGORT == T001L.LGORT
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • ARUN_SO_REQMT.MANDT == TVLS.MANDT
  • ARUN_SO_REQMT.LIFSK == TVLS.LIFSP
Schedule Line Blocked for Delivery
  • Client
  • Schedule Line Blocked for Delivery
  • ARUN_SO_REQMT.MANDT == TVLS.MANDT
  • ARUN_SO_REQMT.LIFSP == TVLS.LIFSP
Delivery Priority
  • Client
  • Delivery Priority
  • ARUN_SO_REQMT.MANDT == TPRIO.MANDT
  • ARUN_SO_REQMT.LPRIO == TPRIO.LPRIO
Material Group
  • Client
  • Material Group
  • ARUN_SO_REQMT.MANDT == T023.MANDT
  • ARUN_SO_REQMT.MATKL == T023.MATKL
Material: order item
  • Client
  • Material Number
  • ARUN_SO_REQMT.MANDT == MARA.MANDT
  • ARUN_SO_REQMT.MATNR == MARA.MATNR
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • ARUN_SO_REQMT.MEINS == T006.MSEHI
  • ARUN_SO_REQMT.MANDT == T006.MANDT
Division
  • Client
  • Division
  • Division
  • ARUN_SO_REQMT.MANDT == TSPA.MANDT
  • ARUN_SO_REQMT.MSPART == TSPA.SPART
  • ARUN_SO_REQMT.SPART == TSPA.SPART
Material Group 1
  • Client
  • Material Group 1
  • ARUN_SO_REQMT.MANDT == TVM1.MANDT
  • ARUN_SO_REQMT.MVGR1 == TVM1.MVGR1
Sales document item category
  • Sales document item category
  • Client
  • ARUN_SO_REQMT.PSTYV == TVPT.PSTYV
  • ARUN_SO_REQMT.MANDT == TVPT.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • ARUN_SO_REQMT.MANDT == MARA.MANDT
  • ARUN_SO_REQMT.SATNR == MARA.MATNR
Segmentation Strategy
  • ?
  • Client
  • Segmentation Strategy
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • ARUN_SO_REQMT.MANDT == T148.MANDT
  • ARUN_SO_REQMT.SOBKZ == T148.SOBKZ
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Division
  • Sales Organization
  • ARUN_SO_REQMT.MANDT == TVTA.MANDT
  • ARUN_SO_REQMT.VTWEG == TVTA.VTWEG
  • ARUN_SO_REQMT.MSPART == TVTA.SPART
  • ARUN_SO_REQMT.SPART == TVTA.SPART
  • ARUN_SO_REQMT.VKORG == TVTA.VKORG
Sales group
  • Sales group
  • Client
  • Sales office
  • ARUN_SO_REQMT.VKGRP == TVBVK.VKGRP
  • ARUN_SO_REQMT.MANDT == TVBVK.MANDT
  • ARUN_SO_REQMT.VKBUR == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • ARUN_SO_REQMT.MANDT == TVKO.MANDT
  • ARUN_SO_REQMT.VKORG == TVKO.VKORG
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • ARUN_SO_REQMT.VSTEL == TVST.VSTEL
  • ARUN_SO_REQMT.MANDT == TVST.MANDT
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • ARUN_SO_REQMT.MANDT == TVKOV.MANDT
  • ARUN_SO_REQMT.VTWEG == TVKOV.VTWEG
  • ARUN_SO_REQMT.VKORG == TVKOV.VKORG
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Distribution Channel
  • Sales office
  • Division
  • Division
  • Sales Organization
  • ARUN_SO_REQMT.MANDT == TVKBZ.MANDT
  • ARUN_SO_REQMT.VTWEG == TVKBZ.VTWEG
  • ARUN_SO_REQMT.VKBUR == TVKBZ.VKBUR
  • ARUN_SO_REQMT.MSPART == TVKBZ.SPART
  • ARUN_SO_REQMT.SPART == TVKBZ.SPART
  • ARUN_SO_REQMT.VKORG == TVKBZ.VKORG