I_Variant_Intf

DDL: I_VARIANT_INTF SQL: IVARIANTINTF Type: view COMPOSITE
13 Fields 4 Data Sources 3 Associations

Variant Data To Node

I_Variant_Intf is a Composite CDS View that provides data about "Variant Data To Node" in SAP S/4HANA. It reads from 4 data sources (I_VariantHeader, I_VariantHistlData, I_VariantMaterial, I_VariantText) and exposes 13 fields with key fields ProductStructureVariantUUID, ProdStrucVariantChgStateIntID. It has 3 associations to related views.

Data Sources (4)

SourceAliasJoin Type
I_VariantHeader _variantHeader from
I_VariantHistlData _VariantHistlData left_outer
I_VariantMaterial _VariantMaterial left_outer
I_VariantText _VariantText left_outer

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_LogAccMObjectTypeActive _LogAccMObjectTypeActive _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPV' or _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPIV'
[0..*] I_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt $projection.ProdStrucVariantUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID and ( _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPV' or _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPIV' )
[0..*] I_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn $projection.ProdStrucVariantUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID and ( _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPV' or _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPIV' ) and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPV' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPIV' ) and ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' or _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) and _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' and ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user or _LogAccMObjectUserAuthzn.UserID = $session.user )

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IVARIANTINTF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Variant Data To Node view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProductStructureVariantUUID I_VariantHeader ProductStructureVariantUUID Internal Number
KEY ProdStrucVariantChgStateIntID I_VariantHistlData ProdStrucVariantChgStateIntID Counter
ProdStrucVariantUniqueID I_VariantHeader ProdStrucVariantUniqueID
ProductStructureVariantName ProductStructureVariantName Variant
ProdStructureVariantParentUUID ProdStructureVariantParentUUID Line Network GUID
ProductStructureVariantType ProductStructureVariantType Variant Type
ProdStrucVariantChangeNumber I_VariantHistlData ProdStrucVariantChangeNumber Change Number
ProdStrucVarChgNmbrDescription I_VariantHistlData ProdStrucVarChgNmbrDescription Visa Profession Txt
Material I_VariantMaterial Material Vehicle Model
MaterialName I_VariantMaterial MaterialName Material Description
_LogAccMObjectTypeActive _LogAccMObjectTypeActive
_LogAccMObjSecureIDAssgmt _LogAccMObjSecureIDAssgmt
_LogAccMObjectUserAuthzn _LogAccMObjectUserAuthzn

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_Variant_Intf.
-- 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: IVARIANTINTF

CREATE VIEW I_Variant_Intf AS
SELECT
  _variantHeader.ProductStructureVariantUUID AS ProductStructureVariantUUID,
  _VariantHistlData.ProdStrucVariantChgStateIntID AS ProdStrucVariantChgStateIntID,
  _variantHeader.ProdStrucVariantUniqueID AS ProdStrucVariantUniqueID,
  ProductStructureVariantName,
  ProdStructureVariantParentUUID,
  ProductStructureVariantType,
  _VariantHistlData.ProdStrucVariantChangeNumber AS ProdStrucVariantChangeNumber,
  _VariantHistlData.ProdStrucVarChgNmbrDescription AS ProdStrucVarChgNmbrDescription,
  _VariantMaterial.Material AS Material,
  _VariantMaterial.MaterialName AS MaterialName
FROM I_VariantHeader AS _variantHeader
LEFT OUTER JOIN I_VariantHistlData AS _VariantHistlData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VariantText AS _VariantText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VariantMaterial AS _VariantMaterial ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_LogAccMObjectTypeActive AS _LogAccMObjectTypeActive ON _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPV' OR _LogAccMObjectTypeActive.LogAccMObjectType = 'PLM_PPEPIV'  -- association [0..1]
LEFT OUTER JOIN I_LogAccMObjSecureIDAssgmt AS _LogAccMObjSecureIDAssgmt ON ProdStrucVariantUniqueID = _LogAccMObjSecureIDAssgmt.LogAccMObjectID AND ( _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPV' OR _LogAccMObjSecureIDAssgmt.LogAccMObjectType = 'PLM_PPEPIV' )  -- association [0..*]
LEFT OUTER JOIN I_LogAccMObjectUserAuthzn AS _LogAccMObjectUserAuthzn ON ProdStrucVariantUniqueID = _LogAccMObjectUserAuthzn.LogAccMObjectID AND ( _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPV' OR _LogAccMObjectUserAuthzn.LogAccMObjectType = 'PLM_PPEPIV' ) AND ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPV' OR _LogAccMObjectUserAuthzn.LogAccMUserAuthznObject = 'PLM_PPEPIV' ) AND ( _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '03' OR _LogAccMObjectUserAuthzn.LogAccMUserAuthznFrom = '*' ) AND _LogAccMObjectUserAuthzn.LogAccMUserAuthznField = 'ACTVT' AND ( _LogAccMObjectUserAuthzn.LogAccMUserEntityID = $session.user OR _LogAccMObjectUserAuthzn.UserID = $session.user )  -- association [0..*]
;

Learn More