I_AsstmtMdlMDGenerationError_2

DDL: I_ASSTMTMDLMDGENERATIONERROR_2 Type: view_entity BASIC

Error During Assortment Postprocessing

I_AsstmtMdlMDGenerationError_2 is a Basic CDS View that provides data about "Error During Assortment Postprocessing" in SAP S/4HANA. It reads from 2 data sources (I_Product, rfm_asm_error2) and exposes 16 fields with key fields AssortmentModuleUser, Product, ProductOfSuprordLstgCondition. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_Product I_Product inner
rfm_asm_error2 rfm_asm_error2 from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.Product = _Product.Product
[0..1] I_Site _Site $projection.AssortmentModuleUser = _Site.SiteCustomer
[0..1] I_UserContactCard _Processor _Processor.ContactCardID = $projection.Processor

Annotations (6)

NameValueLevelField
EndUserText.label Error During Assortment Postprocessing view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUser rfm_asm_error2 asm_user Assortment User
KEY Product rfm_asm_error2 article Material
KEY ProductOfSuprordLstgCondition rfm_asm_error2 structured_article Material
SystemMessageClass rfm_asm_error2 message_id Msg ID
SystemMessageNumber rfm_asm_error2 message_number Message Number
SystemMessageVariable1 rfm_asm_error2 message_var1 Message var.
SystemMessageVariable2 rfm_asm_error2 message_var2 Message var.
SystemMessageVariable3 rfm_asm_error2 message_var3 Message var.
SystemMessageVariable4 rfm_asm_error2 message_var4 Message var.
LatestMasterDataGenerationDate rfm_asm_error2 latest_md_gen_date Latest MD Gen. Date
Processor rfm_asm_error2 processor User Name
LastChangeDateTime rfm_asm_error2 last_changed_at Timestamp
MasterDataGenerationIsRunning rfm_asm_error2 md_gen_is_running MD Gnrtn Is Running
_Product _Product
_Site _Site
_Processor _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 I_AsstmtMdlMDGenerationError_2.
-- 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.

CREATE VIEW I_AsstmtMdlMDGenerationError_2 AS
SELECT
  rfm_asm_error2.asm_user AS AssortmentModuleUser,
  rfm_asm_error2.article AS Product,
  rfm_asm_error2.structured_article AS ProductOfSuprordLstgCondition,
  rfm_asm_error2.message_id AS SystemMessageClass,
  rfm_asm_error2.message_number AS SystemMessageNumber,
  rfm_asm_error2.message_var1 AS SystemMessageVariable1,
  rfm_asm_error2.message_var2 AS SystemMessageVariable2,
  rfm_asm_error2.message_var3 AS SystemMessageVariable3,
  rfm_asm_error2.message_var4 AS SystemMessageVariable4,
  rfm_asm_error2.latest_md_gen_date AS LatestMasterDataGenerationDate,
  rfm_asm_error2.processor AS Processor,
  rfm_asm_error2.last_changed_at AS LastChangeDateTime,
  rfm_asm_error2.md_gen_is_running AS MasterDataGenerationIsRunning
FROM rfm_asm_error2
INNER JOIN I_Product ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_Site AS _Site ON AssortmentModuleUser = _Site.SiteCustomer  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _Processor ON _Processor.ContactCardID = Processor  -- association [0..1]
;