I_VarConfignTableColumn

DDL: I_VARCONFIGNTABLECOLUMN Type: view COMPOSITE

Columns of Variant Table

I_VarConfignTableColumn is a Composite CDS View that provides data about "Columns of Variant Table" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharcTimeIndep, I_VarConfignTableBasic, I_VarConfignTableColumnBasic) and exposes 6 fields with key fields VarConfignTblID, CharcInternalID.

3 data source(s) 6 fields

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharcTimeIndep CharcTimeIndep inner
I_VarConfignTableBasic VarConfignTblBasic from
I_VarConfignTableColumnBasic VarConfignTblColumnBasic inner

Annotations (12)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY VarConfignTblID I_VarConfignTableColumnBasic VarConfignTblID
KEY CharcInternalID I_VarConfignTableColumnBasic CharcInternalID
VarConfignTblName I_VarConfignTableBasic VarConfignTblName
Characteristic I_ClfnCharcTimeIndep Characteristic
VarConfignTblColumnPosition I_VarConfignTableColumnBasic VarConfignTblColumnPosition
VarConfignTblCstmStorFieldName I_VarConfignTableColumnBasic VarConfignTblCstmStorFieldName 
@AbapCatalog: {
  sqlViewName: 'IVARCNFTBLCOL',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Columns of Variant Table'

@ObjectModel: {
  representativeKey: 'VarConfignTblID',
  alternativeKey: [{
    id: 'VarConfignTblName',
    element: ['VarConfignTblName', 'Characteristic']
  }],
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #L
  }
}
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_VarConfignTableColumn
  as select from I_VarConfignTableBasic       as VarConfignTblBasic

    inner join   I_VarConfignTableColumnBasic as VarConfignTblColumnBasic on VarConfignTblBasic.VarConfignTblID = VarConfignTblColumnBasic.VarConfignTblID
    inner join   I_ClfnCharcTimeIndep         as CharcTimeIndep           on VarConfignTblColumnBasic.CharcInternalID = CharcTimeIndep.CharcInternalID
{
  key VarConfignTblColumnBasic.VarConfignTblID,
  key VarConfignTblColumnBasic.CharcInternalID,

      VarConfignTblBasic.VarConfignTblName,
      CharcTimeIndep.Characteristic,

      VarConfignTblColumnBasic.VarConfignTblColumnPosition,
      VarConfignTblColumnBasic.VarConfignTblCstmStorFieldName
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCTIMEINDEP",
"I_VARCONFIGNTABLEBASIC",
"I_VARCONFIGNTABLECOLUMNBASIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More