RFM_MD_ARTICLE_SEA_ASSIGN

DDL: RFM_MD_ARTICLE_SEA_ASSIGN SQL: RFMARTSEA_V Type: view
18 Fields 1 Data Sources

RFM Article Season Assign View

RFM_MD_ARTICLE_SEA_ASSIGN is a CDS View that provides data about "RFM Article Season Assign View" in SAP S/4HANA. It reads from 1 data source (fsh_seasons_mat) and exposes 18 fields.

Data Sources (1)

SourceAliasJoin Type
fsh_seasons_mat sea from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName RFMARTSEA_V view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label RFM Article Season Assign View view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (18)

KeyFieldSource TableSource FieldDescription
matnr mat matnr Vehicle Model
fsh_season fsh_seasons_mat fsh_season Season
fsh_theme fsh_seasons_mat fsh_theme Theme
fsh_sgt fsh_seasons_mat fsh_sgt Req. Segment
rfm_keyitem fsh_seasons_mat rfm_keyitem Key Item
rfm_priority sd rfm_priority Priority
sd_dldt_from sd sd_dldt_from Deliv.Date From
sd_dldt_to sd sd_dldt_to Deliv. Date To
sd_ordt_from sd sd_ordt_from Order Date From
sd_ordt_to sd sd_ordt_to Order Date To
regio sd regio Resident Region
vkorg sd vkorg SD Sales Org.
vtweg sd vtweg RefDistCh-Cust/Mat.
bzirk sd bzirk Sales District
land1 sd land1 Trip Ctry/Reg
kdgrp sd kdgrp Customer group
kunnr sd kunnr Stock customer
parvw sd parvw Task Processor

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view RFM_MD_ARTICLE_SEA_ASSIGN.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: RFMARTSEA_V

CREATE VIEW RFM_MD_ARTICLE_SEA_ASSIGN AS
SELECT
  mat.matnr AS matnr,
  sea.fsh_season AS fsh_season,
  sea.fsh_theme AS fsh_theme,
  sea.fsh_sgt AS fsh_sgt,
  sea.rfm_keyitem AS rfm_keyitem,
  sd.rfm_priority AS rfm_priority,
  sd.sd_dldt_from AS sd_dldt_from,
  sd.sd_dldt_to AS sd_dldt_to,
  sd.sd_ordt_from AS sd_ordt_from,
  sd.sd_ordt_to AS sd_ordt_to,
  sd.regio AS regio,
  sd.vkorg AS vkorg,
  sd.vtweg AS vtweg,
  sd.bzirk AS bzirk,
  sd.land1 AS land1,
  sd.kdgrp AS kdgrp,
  sd.kunnr AS kunnr,
  sd.parvw AS parvw
FROM fsh_seasons_mat AS sea
;

Learn More