I_VarConfignTable

DDL: I_VARCONFIGNTABLE Type: view COMPOSITE Package: VCH_VDM_MD_VT
23 Fields 3 Data Sources 5 Associations

Variant Table

I_VarConfignTable is a Composite CDS View that provides data about "Variant Table" in SAP S/4HANA. It reads from 3 data sources (I_VarConfignTableAdmin, I_VarConfignTableBasic, I_VarConfignTblCstmStorBasic) and exposes 23 fields with key field VarConfignTblID. It has 5 associations to related views. Part of development package VCH_VDM_MD_VT.

Data Sources (3)

SourceAliasJoin Type
I_VarConfignTableAdmin VarConfignTblAdmin inner
I_VarConfignTableBasic VarConfignTblBasic from
I_VarConfignTblCstmStorBasic VarConfignTblCstmStorBasic inner

Associations (5)

CardinalityTargetAliasCondition
[1..*] I_VarConfignTableText _Text $projection.VarConfignTblID = _Text.VarConfignTblID
[0..*] I_VarConfignTableColumn _Column $projection.VarConfignTblID = _Column.VarConfignTblID
[0..*] I_VarCnfTblValAssgmtAltv _ValAssgmtAltv $projection.VarConfignTblID = _ValAssgmtAltv.VarConfignTblID
[0..*] I_VarConfignTableStatusText _StatusText _StatusText.VarConfignTblStatus = $projection.VarConfignTblStatus
[0..*] I_VarConfignTableGroupText _GroupText _GroupText.VarConfignTblGroup = $projection.VarConfignTblGroup

Annotations (12)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY VarConfignTblID I_VarConfignTableBasic VarConfignTblID Int. table no.
VarConfignTblName I_VarConfignTableBasic VarConfignTblName Table
VarConfignTblStatus I_VarConfignTableBasic VarConfignTblStatus Status
VarConfignTblGroup I_VarConfignTableBasic VarConfignTblGroup Group
VarConfignTblCustomStorageName I_VarConfignTblCstmStorBasic VarConfignTblCustomStorageName
VarConfignTblCstmStorIsActive I_VarConfignTableBasic VarConfignTblCstmStorIsActive Active link
VarConfignTblStrucAuthGroup I_VarConfignTableBasic VarConfignTblStrucAuthGroup Auth. Grp Str.
VarConfignTblContentAuthGroup I_VarConfignTableBasic VarConfignTblContentAuthGroup Auth. grp conts
VarConfignTblIsDecisionTable I_VarConfignTableBasic VarConfignTblIsDecisionTable Decision Table
EngineProcessingMode I_VarConfignTableBasic EngineProcessingMode Processing Mode
CreationDate I_VarConfignTableAdmin CreationDate Time Stamp
CreatedByUser I_VarConfignTableAdmin CreatedByUser User Name
LastChangeDate I_VarConfignTableAdmin LastChangeDate Time Stamp
LastChangedByUser I_VarConfignTableAdmin LastChangedByUser User Name
VarCnfTblCstmStorLnkLstChgDate I_VarConfignTableAdmin VarCnfTblCstmStorLnkLstChgDate Date
VarCnfTblCstmStorLnkLstChgTime I_VarConfignTableAdmin VarCnfTblCstmStorLnkLstChgTime Time
VarCnfTblCstmStorLnkLastChgdBy I_VarConfignTableAdmin VarCnfTblCstmStorLnkLastChgdBy Activated by
VarConfignTblLstChgDateTime I_VarConfignTableAdmin VarConfignTblLstChgDateTime Date/Time of last Change to Table Struc.
_Text _Text
_Column _Column
_ValAssgmtAltv _ValAssgmtAltv
_StatusText _StatusText
_GroupText _GroupText

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_VarConfignTable.
-- 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_VarConfignTable AS
SELECT
  VarConfignTblBasic.VarConfignTblID AS VarConfignTblID,
  VarConfignTblBasic.VarConfignTblName AS VarConfignTblName,
  VarConfignTblBasic.VarConfignTblStatus AS VarConfignTblStatus,
  VarConfignTblBasic.VarConfignTblGroup AS VarConfignTblGroup,
  VarConfignTblCstmStorBasic.VarConfignTblCustomStorageName AS VarConfignTblCustomStorageName,
  VarConfignTblBasic.VarConfignTblCstmStorIsActive AS VarConfignTblCstmStorIsActive,
  VarConfignTblBasic.VarConfignTblStrucAuthGroup AS VarConfignTblStrucAuthGroup,
  VarConfignTblBasic.VarConfignTblContentAuthGroup AS VarConfignTblContentAuthGroup,
  VarConfignTblBasic.VarConfignTblIsDecisionTable AS VarConfignTblIsDecisionTable,
  VarConfignTblBasic.EngineProcessingMode AS EngineProcessingMode,
  VarConfignTblAdmin.CreationDate AS CreationDate,
  VarConfignTblAdmin.CreatedByUser AS CreatedByUser,
  VarConfignTblAdmin.LastChangeDate AS LastChangeDate,
  VarConfignTblAdmin.LastChangedByUser AS LastChangedByUser,
  VarConfignTblAdmin.VarCnfTblCstmStorLnkLstChgDate AS VarCnfTblCstmStorLnkLstChgDate,
  VarConfignTblAdmin.VarCnfTblCstmStorLnkLstChgTime AS VarCnfTblCstmStorLnkLstChgTime,
  VarConfignTblAdmin.VarCnfTblCstmStorLnkLastChgdBy AS VarCnfTblCstmStorLnkLastChgdBy,
  VarConfignTblAdmin.VarConfignTblLstChgDateTime AS VarConfignTblLstChgDateTime
FROM I_VarConfignTableBasic AS VarConfignTblBasic
INNER JOIN I_VarConfignTableAdmin AS VarConfignTblAdmin ON /* join condition not captured in parsed metadata */
INNER JOIN I_VarConfignTblCstmStorBasic AS VarConfignTblCstmStorBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_VarConfignTableText AS _Text ON VarConfignTblID = _Text.VarConfignTblID  -- association [1..*]
LEFT OUTER JOIN I_VarConfignTableColumn AS _Column ON VarConfignTblID = _Column.VarConfignTblID  -- association [0..*]
LEFT OUTER JOIN I_VarCnfTblValAssgmtAltv AS _ValAssgmtAltv ON VarConfignTblID = _ValAssgmtAltv.VarConfignTblID  -- association [0..*]
LEFT OUTER JOIN I_VarConfignTableStatusText AS _StatusText ON _StatusText.VarConfignTblStatus = VarConfignTblStatus  -- association [0..*]
LEFT OUTER JOIN I_VarConfignTableGroupText AS _GroupText ON _GroupText.VarConfignTblGroup = VarConfignTblGroup  -- association [0..*]
;

Learn More