rfm_scc_stocktransfer_data

Get Stock Transfer Order Details | view: RFMSCCSTOV | Extraction: Not supported | Component: Season

Tables used: EKET, EKKO, EKPO, EKPV, T002, MAKT, T023T, T134T, T161T, WRF_CHARVALT, RFM_SEASONS, RFM_SEASONS_T, RFM_SEASONS, RFM_SEA_CATGRY_T, MARA, T001W, TSPAT, TVKOT, TVTWT

🔑 Keys (45)
💰 Amounts
∑ Quantities (1)
📅 Dates (1)
☰ Categorical (3)
Other
🔗 Relations (14)

Column Name	Description
ebeln	Purchasing Document Number
ebelp	Item Number of Purchasing Document
bsart FK	Purchasing Document Type
bstyp	Purchasing Document Category	Show values
matnr FK	Material Number
fsh_season_year	Season Year
fsh_season	Season
fsh_collection	Fashion Collection
fsh_theme	Fashion Theme
vkorg FK	Sales Organization
vkorg_vtxtk	Name
vtweg_vtxtk	Name
vtweg FK	Distribution Channel
spart FK	Division
spart_vtxtk	Name
werks FK	Plant
werks_name1	Name
reswk FK	Supplying (issuing) plant in case of stock transport order
reswk_name1	Name
menge	Purchase Order Quantity
meins FK	Purchase Order Unit of Measure
rfm_season_text	Name of Season, Collection, or Theme
rfm_collection_text	Name of Season, Collection, or Theme
rfm_theme_text	Name of Season, Collection, or Theme
season_priority	Priority
seasoncategory FK	Season Category
seasoncategory_text	Season Category Text
seasoncompletenessindicator	Season Completeness Indicator	Show values
seasoncompletenessindicatortxt	Short Text for Fixed Values
size1	Characteristic Value for Main Sizes of Variants
size2	Characteristic Value for Second Size for Variants
color	Characteristic Value for Colors of Variants
mtart FK	Material type
matkl FK	Material Group
attyp	Material Category	Show values
maktx	Product Description
color_desc FK	Characteristic Value (Seasonal Procurement)
size1_desc FK	Characteristic Value (Seasonal Procurement)
size2_desc FK	Characteristic Value (Seasonal Procurement)
mtart_mtbez	Description of product type
attyp_text	Product Category Text
matkl_wgbez	Product Group Description
bsart_batxt	Short Description of Purchasing Document Type
sgt_rcat	Requirement Segment
sgt_scat	Stock Segment

Column Name	Description

Column Name	Description
📏 Purchase Order Unit of Measure (meins):
menge	Purchase Order Quantity

Column Name	Description
eindt	null

Column Name	Description
bstyp	Purchasing Document Category	Show values
seasoncompletenessindicator	Season Completeness Indicator	Show values
attyp	Material Category	Show values

Column Name	Description	Domain name

Master Data Relations	Join Conditions
Purchasing Document Type Purchasing Document Category Client Purchasing Document Type	`RFM_SCC_STOCKTRANSFER_DATA.BSTYP == T161.BSTYP` `RFM_SCC_STOCKTRANSFER_DATA.MANDT == T161.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.BSART == T161.BSART`
Characteristic Value (Seasonal Procurement) ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Client	`RFM_SCC_STOCKTRANSFER_DATA.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_STOCKTRANSFER_DATA.COLOR_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.MANDT == WRF_CHARVAL.MANDT`
Material Group Material Group Client	`RFM_SCC_STOCKTRANSFER_DATA.MATKL == T023.MATKL` `RFM_SCC_STOCKTRANSFER_DATA.MANDT == T023.MANDT`
Material Number Client Material Number	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == MARA.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.MATNR == MARA.MATNR`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == T006.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.MEINS == T006.MSEHI`
Material type Client Material type	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == T134.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.MTART == T134.MTART`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == T001W.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.RESWK == T001W.WERKS`
Season Category Season Category Client	`RFM_SCC_STOCKTRANSFER_DATA.SEASONCATEGORY == RFM_SEA_CATGRY.RFM_SEASON_CATEGORY` `RFM_SCC_STOCKTRANSFER_DATA.MANDT == RFM_SEA_CATGRY.MANDT`
Characteristic Value (Seasonal Procurement) ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Client	`RFM_SCC_STOCKTRANSFER_DATA.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_STOCKTRANSFER_DATA.COLOR_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.MANDT == WRF_CHARVAL.MANDT`
Characteristic Value (Seasonal Procurement) ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Client	`RFM_SCC_STOCKTRANSFER_DATA.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_STOCKTRANSFER_DATA.COLOR_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_DATA.MANDT == WRF_CHARVAL.MANDT`
Division Client Division	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == TSPA.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.SPART == TSPA.SPART`
Sales Organization Client Sales Organization	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == TVKO.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.VKORG == TVKO.VKORG`
Distribution Channel Client Distribution Channel	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == TVTW.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.VTWEG == TVTW.VTWEG`
Plant Client Plant	`RFM_SCC_STOCKTRANSFER_DATA.MANDT == T001W.MANDT` `RFM_SCC_STOCKTRANSFER_DATA.WERKS == T001W.WERKS`