rfm_scc_stocktransfer_basic_V

Get Stock Transfer Order Details | view: RFMSCCSTOBASICV | 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
💰 Amounts
∑ Quantities (1)
📅 Dates (1)
☰ Categorical (3)
Other (30)
🔗 Relations (14)

Column Name	Description

Column Name	Description

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

Column Name	Description
eindt	Item delivery date

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
ebeln	Purchasing Document Number	EBELN
ebelp	Item Number of Purchasing Document	EBELP
sgt_rcat	Requirement Segment	SGT_SRCA
sgt_scat	Stock Segment	SGT_SRCA
fsh_season_year	Season Year	FSH_CJAHR
fsh_season	Season	RFM_SAISO
fsh_collection	Fashion Collection	FSH_COLLECTION
fsh_theme	Fashion Theme	FSH_THEME
vkorg_vtxtk	Name	TEXT20
vtweg_vtxtk	Name	TEXT20
spart_vtxtk	Name	TEXT20
werks_name1	Name	TEXT30
reswk_name1	Name	TEXT30
rfm_season_text	Name of Season, Collection, or Theme	FSH_DPRG_TEXT
rfm_collection_text	Name of Season, Collection, or Theme	FSH_DPRG_TEXT
rfm_theme_text	Name of Season, Collection, or Theme	FSH_DPRG_TEXT
season_priority	Priority	RFM_PRIORITY
seasoncategory_text	Season Category Text	RFM_SEASON_CATEGORY_TEXT
seasoncompletenessindicatortxt	Short Text for Fixed Values	DDTEXT
size1	Characteristic Value for Main Sizes of Variants	WRF_ATWRT
size2	Characteristic Value for Second Size for Variants	WRF_ATWRT
color	Characteristic Value for Colors of Variants	WRF_ATWRT
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
maktx	Product Description	TEXT40
mtart_mtbez	Description of product type	TEXT25
attyp_text	Product Category Text	DDTEXT
matkl_wgbez	Product Group Description	TEXT20
bsart_batxt	Short Description of Purchasing Document Type	TEXT20

Master Data Relations	Join Conditions
Purchasing Document Type Purchasing Document Type Client Purchasing Document Category	`RFM_SCC_STOCKTRANSFER_BASIC_V.BSART == T161.BSART` `RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == T161.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.BSTYP == T161.BSTYP`
Characteristic Value (Seasonal Procurement) Client ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement)	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == WRF_CHARVAL.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_STOCKTRANSFER_BASIC_V.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_BASIC_V.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_BASIC_V.COLOR_DESC == WRF_CHARVAL.ATWRT`
Material Group Client Material Group	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == T023.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.MATKL == T023.MATKL`
Material Number Material Number Client	`RFM_SCC_STOCKTRANSFER_BASIC_V.MATNR == MARA.MATNR` `RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == MARA.MANDT`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == T006.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.MEINS == T006.MSEHI`
Material type Client Material type	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == T134.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.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_BASIC_V.MANDT == T001W.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.RESWK == T001W.WERKS`
Season Category Client Season Category	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == RFM_SEA_CATGRY.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.SEASONCATEGORY == RFM_SEA_CATGRY.RFM_SEASON_CATEGORY`
Characteristic Value (Seasonal Procurement) Client ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement)	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == WRF_CHARVAL.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_STOCKTRANSFER_BASIC_V.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_BASIC_V.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_BASIC_V.COLOR_DESC == WRF_CHARVAL.ATWRT`
Characteristic Value (Seasonal Procurement) Client ? Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement) Characteristic Value (Seasonal Procurement)	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == WRF_CHARVAL.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.[column in domain "ATINN"] == WRF_CHARVAL.ATINN` `RFM_SCC_STOCKTRANSFER_BASIC_V.SIZE1_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_BASIC_V.SIZE2_DESC == WRF_CHARVAL.ATWRT` `RFM_SCC_STOCKTRANSFER_BASIC_V.COLOR_DESC == WRF_CHARVAL.ATWRT`
Division Client Division	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == TSPA.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.SPART == TSPA.SPART`
Sales Organization Client Sales Organization	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == TVKO.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.VKORG == TVKO.VKORG`
Distribution Channel Client Distribution Channel	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == TVTW.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.VTWEG == TVTW.VTWEG`
Plant Client Plant	`RFM_SCC_STOCKTRANSFER_BASIC_V.MANDT == T001W.MANDT` `RFM_SCC_STOCKTRANSFER_BASIC_V.WERKS == T001W.WERKS`