Which tables does C_MngCharcCtlgPathTreeTP use?

C_MngCharcCtlgPathTreeTP reads from 1 data source(s): I_ProdAllocCharcCtlgPathTP.

How many fields does C_MngCharcCtlgPathTreeTP have?

C_MngCharcCtlgPathTreeTP has 17 fields. Key fields: ProdAllocCharcCtlgPathUUID.

C_MngCharcCtlgPathTreeTP

DDL: C_MNGCHARCCTLGPATHTREETP SQL: CMNGCCTLGPTRTP Type: view CONSUMPTION

Manage Characteristic Catalog Path Tree

C_MngCharcCtlgPathTreeTP is a Consumption CDS View that provides data about "Manage Characteristic Catalog Path Tree" in SAP S/4HANA. It reads from 1 data source (I_ProdAllocCharcCtlgPathTP) and exposes 17 fields with key field ProdAllocCharcCtlgPathUUID. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_ProdAllocCharcCtlgPathTP	I_ProdAllocCharcCtlgPathTP	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	C_MngCharcCtlgPathPicker	_MngCharcCtlgPathPicker	`$projection.ProdAllocCharcCtlgPathIntID = _MngCharcCtlgPathPicker.ProdAllocCharcCtlgPathIntID`
[1..1]	C_MngCharcCtlgTreeTP	_ProdAllocCharcCatalogTP	`$projection.ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalogTP.ProdAllocCharcCatalogUUID`

Annotations (14)

Name	Value	Level
EndUserText.label	Manage Characteristic Catalog Path Tree	view
VDM.viewType	#CONSUMPTION	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.sqlViewName	CMNGCCTLGPTRTP	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MASTER	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.transactionalProcessingDelegated	true	view
ObjectModel.representativeKey	ProdAllocCharcCtlgPathUUID	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view

Fields (17)

Key	Field	Source Table	Source Field
KEY	ProdAllocCharcCtlgPathUUID	I_ProdAllocCharcCtlgPathTP	ProdAllocCharcCtlgPathUUID
	ProdAllocCharcCtlgPathDesc	_MngCharcCtlgPathPicker	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
	ClfnCharacteristicUseType	I_ProdAllocCharcCtlgPathTP	ClfnCharacteristicUseType
	_ProdAllocCharcCatalogTP		_ProdAllocCharcCatalogTP

@EndUserText.label: 'Manage Characteristic Catalog Path Tree'
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'CMNGCCTLGPTRTP'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
    transactionalProcessingDelegated: true,
    semanticKey:  ['ProdAllocCharcCatalogType', 
                   'ProdAllocCharcCatalogUseType',
                   'ProdAllocCharcCtlgPathSelName', 
                   'ProdAllocCharcCtlgPathSel', 
                   'ProdAllocCharcCatalogPath'],
    representativeKey: 'ProdAllocCharcCtlgPathUUID',
    createEnabled : false,
    updateEnabled : false,
    deleteEnabled : false
}

define view C_MngCharcCtlgPathTreeTP
  as select from I_ProdAllocCharcCtlgPathTP

  association [1..1] to C_MngCharcCtlgPathPicker as _MngCharcCtlgPathPicker on $projection.ProdAllocCharcCtlgPathIntID = _MngCharcCtlgPathPicker.ProdAllocCharcCtlgPathIntID
  association [1..1] to C_MngCharcCtlgTreeTP     as _ProdAllocCharcCatalogTP on $projection.ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalogTP.ProdAllocCharcCatalogUUID

{
      // 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
      _MngCharcCtlgPathPicker.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.ClfnCharacteristicUseType                      as ClfnCharacteristicUseType,
      
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      @UI.hidden
      _ProdAllocCharcCatalogTP
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_MNGCHARCCTLGPATHPICKER",
"I_PRODALLOCCHARCCTLGPATHTP"
],
"ASSOCIATED":
[
"C_MNGCHARCCTLGPATHPICKER",
"C_MNGCHARCCTLGTREETP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_MngCharcCtlgPathTreeTP view

I_ProdAllocCharcCtlgPathTP view