I_VarConfignTableLine

DDL: I_VARCONFIGNTABLELINE Type: view COMPOSITE
10 Fields 2 Data Sources 1 Associations

Line of Variant Table

I_VarConfignTableLine is a Composite CDS View that provides data about "Line of Variant Table" in SAP S/4HANA. It reads from 2 data sources (I_VarConfignTableLineBasic, I_VarConfignTableBasic) and exposes 10 fields with key fields VarConfignTblID, VarConfignTblLineNumber, TimeIntervalNumber. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_VarConfignTableLineBasic Line inner
I_VarConfignTableBasic Table from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_VarConfignTableValue _Value $projection.VarConfignTblID = _Value.VarConfignTblID and $projection.VarConfignTblValCombinationID = _Value.VarConfignTblValCombinationID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IVARCNFTBLLINE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Line of Variant Table view
ObjectModel.representativeKey VarConfignTblID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY VarConfignTblID I_VarConfignTableLineBasic VarConfignTblID Int. table no.
KEY VarConfignTblLineNumber I_VarConfignTableLineBasic VarConfignTblLineNumber Row Number
KEY TimeIntervalNumber I_VarConfignTableLineBasic TimeIntervalNumber Int. counter
VarConfignTblName I_VarConfignTableBasic VarConfignTblName Table
VarConfignTblValCombinationID I_VarConfignTableLineBasic VarConfignTblValCombinationID Comb. no.
ChangeNumber I_VarConfignTableLineBasic ChangeNumber Change Number
IsDeleted I_VarConfignTableLineBasic IsDeleted TRUE
ValidityStartDate I_VarConfignTableLineBasic ValidityStartDate Validity Start Date
ValidityEndDate I_VarConfignTableLineBasic ValidityEndDate ValidTo
_Value _Value

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_VarConfignTableLine.
-- 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_VarConfignTableLine AS
SELECT
  Line.VarConfignTblID AS VarConfignTblID,
  Line.VarConfignTblLineNumber AS VarConfignTblLineNumber,
  Line.TimeIntervalNumber AS TimeIntervalNumber,
  Table.VarConfignTblName AS VarConfignTblName,
  Line.VarConfignTblValCombinationID AS VarConfignTblValCombinationID,
  Line.ChangeNumber AS ChangeNumber,
  Line.IsDeleted AS IsDeleted,
  Line.ValidityStartDate AS ValidityStartDate,
  Line.ValidityEndDate AS ValidityEndDate
FROM I_VarConfignTableBasic AS Table
INNER JOIN I_VarConfignTableLineBasic AS Line ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VarConfignTableValue AS _Value ON VarConfignTblID = _Value.VarConfignTblID AND VarConfignTblValCombinationID = _Value.VarConfignTblValCombinationID  -- association [0..*]
;

Learn More