C_ProdAllocCharcCtlgPathTree

DDL: C_PRODALLOCCHARCCTLGPATHTREE Type: view_entity CONSUMPTION Package: PROD_ALLOC_CHARC_CATALOG

Product Allocation Characteristic Catalog Path Tree

C_ProdAllocCharcCtlgPathTree is a Consumption CDS View that provides data about "Product Allocation Characteristic Catalog Path Tree" in SAP S/4HANA. It reads from 1 data source (I_ProdAllocCharcCtlgPathTP) and exposes 18 fields with key field ProdAllocCharcCtlgPathUUID. It has 2 associations to related views. Part of development package PROD_ALLOC_CHARC_CATALOG.

Data Sources (1)

SourceAliasJoin Type
I_ProdAllocCharcCtlgPathTP I_ProdAllocCharcCtlgPathTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ProdAllocCharcCtlgTree _ProdAllocCharcCatalogTP $projection.ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalogTP.ProdAllocCharcCatalogUUID
[1..1] C_ProdAllocCharcCtlgPathPicker _ProdAllocCharcCtlgPathPicker $projection.ProdAllocCharcCtlgPathIntID = _ProdAllocCharcCtlgPathPicker.ProdAllocCharcCtlgPathIntID

Annotations (12)

NameValueLevelField
EndUserText.label Product Allocation Characteristic Catalog Path Tree view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.representativeKey ProdAllocCharcCtlgPathUUID view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
Analytics.technicalName CPACTLG_PATHTREE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocCharcCtlgPathUUID I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgPathUUID
ProdAllocCharcCtlgPathDesc _ProdAllocCharcCtlgPathPicker ProdAllocCharcCtlgPathDesc
ProdAllocCharcCtlgPathIntID I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgPathIntID
ProdAllocCharcCatalogType I_ProdAllocCharcCtlgPathTP ProdAllocCharcCatalogType
ProdAllocCharcCatalogUseType I_ProdAllocCharcCtlgPathTP ProdAllocCharcCatalogUseType
ProdAllocCharcCatalogUUID I_ProdAllocCharcCtlgPathTP ProdAllocCharcCatalogUUID
ProdAllocCharcCtlgParPathIntID I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgParPathIntID
ProdAllocCharcCatalogCharcType I_ProdAllocCharcCtlgPathTP ProdAllocCharcCatalogCharcType
ProdAllocCharcCatalogPathType I_ProdAllocCharcCtlgPathTP ProdAllocCharcCatalogPathType
ProdAllocCharcCtlgPathSelName I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgPathSelName
ProdAllocCharcCtlgPathSel I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgPathSel
ProdAllocCharcCatalogPath I_ProdAllocCharcCtlgPathTP ProdAllocCharcCatalogPath
ProdAllocCharcCtlgPathIsHidden I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgPathIsHidden
ProdAllocCharcCtlgPathIsRoot I_ProdAllocCharcCtlgPathTP ProdAllocCharcCtlgPathIsRoot
CharcIsOnlyUsableInValueGroups I_ProdAllocCharcCtlgPathTP CharcIsOnlyUsableInValueGroups
BaseCharcCatalogPathIntID
ClfnCharacteristicUseType ClfnCharacteristicUseType
_ProdAllocCharcCatalogTP _ProdAllocCharcCatalogTP
@EndUserText.label: 'Product Allocation Characteristic Catalog Path Tree'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER
@ObjectModel: {
    transactionalProcessingDelegated: true,
    semanticKey:  ['ProdAllocCharcCatalogType', 
                   'ProdAllocCharcCatalogUseType',
                   'ProdAllocCharcCtlgPathSelName', 
                   'ProdAllocCharcCtlgPathSel', 
                   'ProdAllocCharcCatalogPath'],
    representativeKey: 'ProdAllocCharcCtlgPathUUID',
    createEnabled : false,
    updateEnabled : false,
    deleteEnabled : false
}
@Analytics.technicalName: 'CPACTLG_PATHTREE'

define view entity C_ProdAllocCharcCtlgPathTree
  as select from I_ProdAllocCharcCtlgPathTP

  // association [1..1] to I_ProdAllocCharcCtlgPathPicker as _ProdAllocCharcCtlgPathPicker on $projection.ProdAllocCharcCtlgPathIntID = _ProdAllocCharcCtlgPathPicker.ProdAllocCharcCtlgPathIntID

  association [1..1] to C_ProdAllocCharcCtlgTree       as _ProdAllocCharcCatalogTP      on $projection.ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalogTP.ProdAllocCharcCatalogUUID
  association [1..1] to C_ProdAllocCharcCtlgPathPicker as _ProdAllocCharcCtlgPathPicker on $projection.ProdAllocCharcCtlgPathIntID = _ProdAllocCharcCtlgPathPicker.ProdAllocCharcCtlgPathIntID
{
      // Key fields

      @ObjectModel.readOnly: true
      @UI.hidden
  key I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathUUID                     as ProdAllocCharcCtlgPathUUID,

      //  @ObjectModel.readOnly: true

      //  @UI.hidden

      //  key I_ProdAllocCharcCtlgPathWD.ActiveAllocCharcCtlgPathUUID as ActiveAllocCharcCtlgPathUUID,

      //


      // Fields

      @ObjectModel.readOnly: true
      _ProdAllocCharcCtlgPathPicker.ProdAllocCharcCtlgPathDesc                  as ProdAllocCharcCtlgPathDesc,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathIntID                    as ProdAllocCharcCtlgPathIntID,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogType                      as ProdAllocCharcCatalogType,
      
      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogUseType                   as ProdAllocCharcCatalogUseType,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogUUID                      as ProdAllocCharcCatalogUUID,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgParPathIntID                 as ProdAllocCharcCtlgParPathIntID,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogCharcType                 as ProdAllocCharcCatalogCharcType,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogPathType                  as ProdAllocCharcCatalogPathType,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathSelName                  as ProdAllocCharcCtlgPathSelName,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathSel                      as ProdAllocCharcCtlgPathSel,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCatalogPath                      as ProdAllocCharcCatalogPath,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathIsHidden                 as ProdAllocCharcCtlgPathIsHidden,

      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathIsRoot                   as ProdAllocCharcCtlgPathIsRoot,
      
      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP.CharcIsOnlyUsableInValueGroups                 as CharcIsOnlyUsableInValueGroups,
      
      @ObjectModel.readOnly: true
      @UI.hidden
      I_ProdAllocCharcCtlgPathTP._MainCharcCtlgPathRefTP.BaseCharcCatalogPathIntID                         as BaseCharcCatalogPathIntID,
      
      @ObjectModel.readOnly: true
      @UI.hidden
      ClfnCharacteristicUseType                                                 as ClfnCharacteristicUseType,
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      @UI.hidden
      _ProdAllocCharcCatalogTP
      
}
// Only the PAL application specific characteristic catalog instances are required.

where ProdAllocCharcCatalogUseType = '01' //IF_PRODALLOCCHARCCTLGUSETYPE_C=>SC_PAL

 and ProdAllocCharcCtlgPathIsHidden <> 'X'
// and ClfnCharacteristicUseType <> 'VC'