arun_i_so_reqmt

Sales Order requirement seletion with ARUN_BDBS join | view: ARUN_V_I_SO_REQ | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAP, VBAK, VBAP, EKES, EKKO, VBAK, VBKD, VBPA, VBEP, VBEP, MAKT, MARA, MARC, TMVF, MARA, MARC, ARUN_BDBS, KNA1, KNVV, LFA1, TVAK, TVEP
Column Name Description
vbeln Sales Document
posnr Sales Document Item
Column Name Description
💲 SD Document Currency (waerk):
netpr Net Price
netwr Net Value of the Order Item in Document Currency
Column Name Description
req_conf_qty null
kwmeng null
alloc_qty Assigned Quantity by ARun
pfmenge Assigned Quantity by ARun
phmenge Assigned Quantity by ARun
prmenge Assigned Quantity by ARun
fmenge Assigned Quantity by ARun
hmenge Assigned Quantity by ARun
rmenge Assigned Quantity by ARun
omenge Assigned Quantity by ARun
pomenge Assigned Quantity by ARun
dmenge null
cmenge Assigned Quantity by ARun
wmeng null
klmeng Cumulative Confirmed Quantity in Base Unit
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
eindt Item delivery date
fsh_candate Cancellation Date
hfsh_candate Cancellation Date
stdat Key date of the bill of material
req_dlvdate null
cnf_dlvdate null
material_avail_date Material Staging/Availability Date
delivery_date_po Confirmed Delivery Date for Future Receipts
mat_avail_date_mrp Material Staging/Availability Date
requested_date null
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
kowrr Statistical Values Show values
fsh_vas_rel VAS Relevant Show values
lfsta Delivery Status (Item) Show values
fsh_mg_arun_req Supply Assignment (ARun) Show values
attyp Material Category Show values
fixmg Delivery Date and Quantity Fixed Show values
xchpf Batch Management Requirement Indicator for Plant Show values
sgt_stk_prt Stock Protection Indicator [Obsolete] Show values
arun_status ARun Status Show values
stock_source ARun Stock Source Show values
arun_mode Allocation Run Mode Show values
ilfgsa Overall Delivery Status (Item) Show values
iuvall Incompletion Status (Item) Show values
iuvvlk Delivery Incompletion Status (Item) Show values
iuvfak Billing Incompletion Status (Item) Show values
lfgsk Overall Delivery Status (All Items) Show values
abstk Rejection Status (All Items) Show values
spstg Overall Block Status (Header) Show values
uvall Incompletion Status (Header) Show values
uvvlk Delivery Incompletion Status (Header) Show values
uvfak Billing Incompletion Status (Header) Show values
uvals Incompletion Status (All Items) Show values
uvvls Delivery Incompletion Status (All Items) Show values
uvfas Billing Incompletion Status (All Items) Show values
sgt_scope Segmentation Strategy Scope Show values
arun_fix_batch Assign Batches in Supply Assignment (ARun) 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
grkor Delivery Group (Items are delivered together) GRKOR
batch Batch Number CHARG
plant Plant (Own or External) WERKS
storage_location Storage location LGORT
req_segment Requirement Segment SGT_SRCA
salesdoc_num Sales Document VBELN
salesdoc_item Sales Document Item POSNR
req_ind null
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
maktg Material Description in Uppercase for Matchcodes CHAR40
rfm_psst_group PSST Group RFM_PSST_GROUP_ID
berid MRP Area BERID
stlnr Bill of Material STNUM
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
uepos Higher-Level Item in Bill of Material Structures POSNR
fsh_grid_cond_rec Grid Condition Record Number CHAR32
arunid ARun GUID SYSUUID
purchdoc_num Purchasing requirement document EBELN
reserv_num Number of reservation/dependent requirements RSNUM
purchdoc_item Item Number of STO/Return PO EBELP
reserv_item Item number of Reservation RSPOS
purchord_num Purchase Order number (Stock) EBELN
prodord_num Production number (Stock) AUFNR
purchord_item Item number of Purchase Order EBELP
prodord_item Item number of Production Order CO_POSNR
purchord_sch Schedule Line number of Purchase Order ETENR
confirmation_no Sequential Number of Supplier Confirmation for ARun NUM04
consignment_num Special stock consignment number CHAR10
creation_time UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
changed_by Name of Person Who Changed Object USNAM
zterm Terms of payment key ZTERM
stk_segment Stock Segment SGT_SRCA
bstkd Customer Reference BSTKD
prreg null
rereg null
shipto Customer Number KUNNR
soldto Customer Number KUNNR
payer Customer Number KUNNR
billto Customer Number KUNNR
land1 Country/Region Key LAND1
ibd_num Delivery VBELN
ibd_itm Delivery Item POSNR
uecha Higher-Level Item of Batch Split Item POSNR
Master Data Relations Join Conditions
Order type in order header
  • Sales Document Type
  • Client
  • ARUN_I_SO_REQMT.AUART == TVAK.AUART
  • ARUN_I_SO_REQMT.MANDT == TVAK.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • ARUN_I_SO_REQMT.AUGRU == TVAU.AUGRU
  • ARUN_I_SO_REQMT.MANDT == TVAU.MANDT
Batch Number
  • Batch Number
  • Plant (Own or External)
  • Client
  • Material Number
  • ARUN_I_SO_REQMT.BATCH_REQ == MCHA.CHARG
  • ARUN_I_SO_REQMT.PLANT == MCHA.WERKS
  • ARUN_I_SO_REQMT.MANDT == MCHA.MANDT
  • ARUN_I_SO_REQMT.MATERIAL == MCHA.MATNR
Requirements type
  • Requirements type
  • Client
  • ARUN_I_SO_REQMT.BEDAE == T459A.BEDAE
  • ARUN_I_SO_REQMT.MANDT == T459A.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • ARUN_I_SO_REQMT.BUKRS == T001.BUKRS
  • ARUN_I_SO_REQMT.MANDT == T001.MANDT
Agreed Delivery Time
  • Agreed Delivery Time
  • Client
  • ARUN_I_SO_REQMT.DELCO == TVDC.DELCO
  • ARUN_I_SO_REQMT.MANDT == TVDC.MANDT
MRP type
  • MRP Type
  • Client
  • ARUN_I_SO_REQMT.DISMM == T438A.DISMM
  • ARUN_I_SO_REQMT.MANDT == T438A.MANDT
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • ARUN_I_SO_REQMT.FAKSK == TVFS.FAKSP
  • ARUN_I_SO_REQMT.MANDT == TVFS.MANDT
Fashion Collection
  • Fashion Collection
  • Season
  • Season Year
  • Client
Grouping Rule
  • Grouping Rule
  • Client
Release Rule
  • Release Rule
  • Client
Season
  • Season
  • Season Year
  • Client
Season Year
  • Season
  • Season Year
  • Client
Fashion Theme
  • Fashion Collection
  • Season
  • Season Year
  • Fashion Theme
  • Client
  • ARUN_I_SO_REQMT.FSH_COLLECTION == FSH_THEMES.FSH_COLLECTION
  • ARUN_I_SO_REQMT.FSH_SEASON == FSH_THEMES.FSH_SEASON
  • ARUN_I_SO_REQMT.FSH_SEASON_YEAR == FSH_THEMES.FSH_SEASON_YEAR
  • ARUN_I_SO_REQMT.FSH_THEME == FSH_THEMES.FSH_THEME
  • ARUN_I_SO_REQMT.MANDT == FSH_THEMES.MANDT
Division in order header
  • Sales Organization
  • Distribution Channel
  • Division
  • Division
  • Client
  • ARUN_I_SO_REQMT.VKORG == TVTA.VKORG
  • ARUN_I_SO_REQMT.VTWEG == TVTA.VTWEG
  • ARUN_I_SO_REQMT.SPART == TVTA.SPART
  • ARUN_I_SO_REQMT.HSPART == TVTA.SPART
  • ARUN_I_SO_REQMT.MANDT == TVTA.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • ARUN_I_SO_REQMT.INCO1 == TINC.INCO1
  • ARUN_I_SO_REQMT.MANDT == TINC.MANDT
Customer Group
  • Customer Group
  • Client
  • ARUN_I_SO_REQMT.KDGRP == T151.KDGRP
  • ARUN_I_SO_REQMT.MANDT == T151.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • ARUN_I_SO_REQMT.KUNNR == KNA1.KUNNR
  • ARUN_I_SO_REQMT.MANDT == KNA1.MANDT
Customer Group 1
  • Customer Group 1
  • Client
  • ARUN_I_SO_REQMT.KVGR1 == TVV1.KVGR1
  • ARUN_I_SO_REQMT.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • ARUN_I_SO_REQMT.KVGR2 == TVV2.KVGR2
  • ARUN_I_SO_REQMT.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • ARUN_I_SO_REQMT.KVGR3 == TVV3.KVGR3
  • ARUN_I_SO_REQMT.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • ARUN_I_SO_REQMT.KVGR4 == TVV4.KVGR4
  • ARUN_I_SO_REQMT.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • ARUN_I_SO_REQMT.KVGR5 == TVV5.KVGR5
  • ARUN_I_SO_REQMT.MANDT == TVV5.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • ARUN_I_SO_REQMT.LIFNR == LFA1.LIFNR
  • ARUN_I_SO_REQMT.MANDT == LFA1.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • ARUN_I_SO_REQMT.LIFSK == TVLS.LIFSP
  • ARUN_I_SO_REQMT.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • ARUN_I_SO_REQMT.LPRIO == TPRIO.LPRIO
  • ARUN_I_SO_REQMT.MANDT == TPRIO.MANDT
Material: order item
  • Client
  • Material Number
  • ARUN_I_SO_REQMT.MANDT == MARA.MANDT
  • ARUN_I_SO_REQMT.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • ARUN_I_SO_REQMT.MANDT == T023.MANDT
  • ARUN_I_SO_REQMT.MATKL == T023.MATKL
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • ARUN_I_SO_REQMT.MTVFP == TMVF.MTVFP
  • ARUN_I_SO_REQMT.MANDT == TMVF.MANDT
Material Group 1
  • Client
  • Material Group 1
  • ARUN_I_SO_REQMT.MANDT == TVM1.MANDT
  • ARUN_I_SO_REQMT.MVGR1 == TVM1.MVGR1
Sales document item category
  • Sales document item category
  • Client
  • ARUN_I_SO_REQMT.PSTYV == TVPT.PSTYV
  • ARUN_I_SO_REQMT.MANDT == TVPT.MANDT
Route
  • Route
  • Client
  • ARUN_I_SO_REQMT.ROUTE == TVRO.ROUTE
  • ARUN_I_SO_REQMT.MANDT == TVRO.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • ARUN_I_SO_REQMT.SATNR == MARA.MATNR
  • ARUN_I_SO_REQMT.MANDT == MARA.MANDT
Segmentation Strategy
  • ?
  • Client
  • Segmentation Strategy
  • ARUN_I_SO_REQMT.[column in domain "WERKS_D"] == SGT_COVS_T.WERKS
  • ARUN_I_SO_REQMT.MANDT == SGT_COVS_T.MANDT
  • ARUN_I_SO_REQMT.SGT_COVS == SGT_COVS_T.SGT_COVS
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • ARUN_I_SO_REQMT.SLOC_REQ == T001L.LGORT
  • ARUN_I_SO_REQMT.PLANT == T001L.WERKS
  • ARUN_I_SO_REQMT.MANDT == T001L.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • ARUN_I_SO_REQMT.SOBKZ == T148.SOBKZ
  • ARUN_I_SO_REQMT.MANDT == T148.MANDT
Division
  • Division
  • Division
  • Client
  • ARUN_I_SO_REQMT.SPART == TSPA.SPART
  • ARUN_I_SO_REQMT.HSPART == TSPA.SPART
  • ARUN_I_SO_REQMT.MANDT == TSPA.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • ARUN_I_SO_REQMT.VKBUR == TVBVK.VKBUR
  • ARUN_I_SO_REQMT.VKGRP == TVBVK.VKGRP
  • ARUN_I_SO_REQMT.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • ARUN_I_SO_REQMT.VKORG == TVKO.VKORG
  • ARUN_I_SO_REQMT.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • ARUN_I_SO_REQMT.VSTEL == TVST.VSTEL
  • ARUN_I_SO_REQMT.MANDT == TVST.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • ARUN_I_SO_REQMT.VKORG == TVKOV.VKORG
  • ARUN_I_SO_REQMT.VTWEG == TVKOV.VTWEG
  • ARUN_I_SO_REQMT.MANDT == TVKOV.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • ARUN_I_SO_REQMT.WAERK == TCURC.WAERS
  • ARUN_I_SO_REQMT.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales Organization
  • Distribution Channel
  • Division
  • Division
  • Client
  • ARUN_I_SO_REQMT.VKBUR == TVKBZ.VKBUR
  • ARUN_I_SO_REQMT.VKORG == TVKBZ.VKORG
  • ARUN_I_SO_REQMT.VTWEG == TVKBZ.VTWEG
  • ARUN_I_SO_REQMT.SPART == TVKBZ.SPART
  • ARUN_I_SO_REQMT.HSPART == TVKBZ.SPART
  • ARUN_I_SO_REQMT.MANDT == TVKBZ.MANDT