What is I_ProdAllocCharcCatalogPath in SAP S/4HANA?

I_ProdAllocCharcCatalogPath is a basic CDS view in SAP S/4HANA. Product Allocation Characteristic Catalog Path It contains 54 fields.

Which tables does I_ProdAllocCharcCatalogPath read from?

I_ProdAllocCharcCatalogPath reads data from: pactlg_path.

What VDM layer is I_ProdAllocCharcCatalogPath?

I_ProdAllocCharcCatalogPath is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_ProdAllocCharcCatalogPath

DDL: I_PRODALLOCCHARCCATALOGPATH SQL: IPACTLG_PATH Type: view BASIC

54 Fields 1 Data Sources 16 Associations

Product Allocation Characteristic Catalog Path

I_ProdAllocCharcCatalogPath is a Basic CDS View that provides data about "Product Allocation Characteristic Catalog Path" in SAP S/4HANA. It reads from 1 data source (pactlg_path) and exposes 54 fields with key field ProdAllocCharcCtlgPathUUID. It has 16 associations to related views.

Data Sources (1)

Source	Alias	Join Type
pactlg_path	pactlg_path	from

Associations (16)

Cardinality	Target	Alias	Condition
[1..1]	I_ProdAllocCharcCatalog	_ProdAllocCharcCatalog	`$projection.ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalog.ProdAllocCharcCatalogUUID`
[0..*]	I_ProdAllocCharcCtlgPathText	_Text	`$projection.ProdAllocCharcCtlgPathUUID = _Text.ProdAllocCharcCtlgPathUUID`
[0..*]	I_ProdAllocCharcCtlgPathRef	_ProdAllocCharcCtlgPathRef	`$projection.ProdAllocCharcCtlgPathUUID = _ProdAllocCharcCtlgPathRef.ProdAllocCharcCtlgPathUUID`
[0..*]	I_AllocCharcCtlgValGrpVal	_AllocCharcCtlgValGrpVal	`$projection.ProdAllocCharcCtlgPathUUID = _AllocCharcCtlgValGrpVal.ProdAllocCharcCtlgPathUUID`
[0..1]	I_ProdAllocCharcCatalogType	_ProdAllocCharcCatalogType	`$projection.ProdAllocCharcCatalogType = _ProdAllocCharcCatalogType.ProdAllocCharcCatalogType`
[0..1]	I_ProdAllocCharcCtlgUseType	_ProdAllocCharcCtlgUseType	`$projection.ProdAllocCharcCatalogUseType = _ProdAllocCharcCtlgUseType.ProdAllocCharcCatalogUseType`
[0..1]	I_ProdAllocCharcCtlgCharcType	_ProdAllocCharcCtlgCharcType	`$projection.ProdAllocCharcCatalogCharcType = _ProdAllocCharcCtlgCharcType.ProdAllocCharcCatalogCharcType`
[0..1]	I_ProdAllocCharcCtlgPathType	_ProdAllocCharcCtlgPathType	`$projection.ProdAllocCharcCatalogPathType = _ProdAllocCharcCtlgPathType.ProdAllocCharcCatalogPathType`
[0..*]	I_ProdAllocCharcCatalogPath	_NextLvlProdAllocCharcCtlgPath	`$projection.ProdAllocCharcCtlgPathIntID = _NextLvlProdAllocCharcCtlgPath.ProdAllocCharcCtlgParPathIntID`
[0..1]	I_ProdAllocCharcCatalogPath	_ParentProdAllocCharcCtlgPath	`$projection.ProdAllocCharcCtlgParPathIntID = _ParentProdAllocCharcCtlgPath.ProdAllocCharcCtlgPathIntID`
[0..*]	I_DataElementLabelText	_DataElementLabelText	`$projection.ABAPDataElement = _DataElementLabelText.ABAPDataElement`
[0..*]	I_PartnerFunctionText	_PartnerFunctionText	`$projection.ProdAllocCharcCtlgPathSel = _PartnerFunctionText.PartnerFunction`
[0..1]	I_CharcValExistenceCheckType	_CharcValExistenceCheckType	`$projection.CharcValExistenceCheckType = _CharcValExistenceCheckType.CharcValExistenceCheckType`
[0..1]	I_ProdAllocCharcCtlgPathRef	_MainCharcCtlgPathRef	`_MainCharcCtlgPathRef.ProdAllocCharcCtlgPathUUID = $projection.ProdAllocCharcCtlgPathUUID and _MainCharcCtlgPathRef.ProdAllocCharcCatalogIsMain = 'X'`
[0..1]	I_UnitOfMeasure	_CharacteristicUnitOfMeasure	`$projection.CharacteristicUnit = _CharacteristicUnitOfMeasure.UnitOfMeasure`
[0..1]	I_UnitOfMeasure	_ValueGroupUnitOfMeasure	`$projection.CharacteristicValueGroupUnit = _ValueGroupUnitOfMeasure.UnitOfMeasure`

Annotations (11)

Name	Value	Level
EndUserText.label	Product Allocation Characteristic Catalog Path	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
AbapCatalog.sqlViewName	IPACTLG_PATH	view
ObjectModel.representativeKey	ProdAllocCharcCtlgPathUUID	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.dataClass	#MASTER	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Search.searchable	true	view

Fields (54)

Key	Field	Source Field	Description
KEY	ProdAllocCharcCtlgPathUUID	prodalloccharcctlgpathuuid	Product Allocation Characteristic Catalog Path UUID
	ProdAllocCharcCtlgPathIntID	prodalloccharcctlgpathintid	Catalog Path Internal ID
	ProdAllocCharcCatalogType	prodalloccharccatalogtype	Catalog Type
	ProdAllocCharcCatalogUseType	prodalloccharccatalogusetype	Catalog Use Type
	ProdAllocCharcCatalogUUID	prodalloccharccataloguuid	UUID
	ProdAllocCharcCtlgParPathIntID	prodalloccharcctlgparpathintid	Catalog Parent Path Internal ID
	CharacteristicUnitPathIntID	characteristicunitpathintid	Unit Internal Identifier
	ProdAllocCharcCatalogCharcType	prodalloccharccatalogcharctype	Characteristic Type
	ProdAllocCharcCatalogPathType	prodalloccharccatalogpathtype	Characteristic Path Type
	ClfnCharacteristicUseType	clfncharacteristicusetype	Type
	CharcCatalogPathHierarchyType	charccatalogpathhierarchytype	Hierarchy Type
	ABAPDataElement	abapdataelement	Data Element
	ProdAllocCharcCtlgPathSelName	prodalloccharcctlgpathselname	Path Selection Name
	ProdAllocCharcCtlgPathSel	prodalloccharcctlgpathsel	Characteristic Catalog Path Selection
	ProdAllocCharcCatalogPath	prodalloccharccatalogpath	Charc Catalog Path
	ProdAllocCharcCtlgAltvPath	prodalloccharcctlgaltvpath	Alternative Path
	ProdAllocCharcCtlgLegacyTable	prodalloccharcctlglegacytable	Legacy Table
	ProdAllocCharcCtlgLegacyPath	prodalloccharcctlglegacypath	Legacy Path
	ProdAllocCharcValueHelp	prodalloccharcvaluehelp	Value Help
	ProdAllocCharcValHelpTblField	prodalloccharcvalhelptblfield	Value Help Field
	ProdAllocCharcValHelpTextLink	prodalloccharcvalhelptextlink	Value Help Text Link
	ProdAllocCharcValHelpTxtTblFld	prodalloccharcvalhelptxttblfld	Value Help Text Field
	ProdAllocCharcCtlgCharc	prodalloccharcctlgcharc	Characteristic
	ProdAllocCharcCtlgPathIsHidden	prodalloccharcctlgpathishidden	Catalog Characteristic Path Is Hidden
	ProdAllocCharcCtlgPathIsRoot	prodalloccharcctlgpathisroot	Catalog Characteristic Path Is Root
	CharcValExistenceCheckType	charcvalexistencechecktype	Value Existence Check Type
	ABAPDictionaryDataType	abapdictionarydatatype	Data Type
	ABAPDictionaryDataTypeLength	abapdictionarydatatypelength	No. of Characters
	ABAPDictionaryDataTypeDecimals	abapdictionarydatatypedecimals	Decimal Places
	ABAPOutputLengthValue	abapoutputlengthvalue	Output Length
	CharcValueIsCaseSensitive	charcvalueiscasesensitive	Case Sensitive
	CharcValueConversionRoutine	charcvalueconversionroutine	Conversion Routine
	CharcInternalID	charcinternalid	Characteristic Internal ID
	CharacteristicUnit	characteristicunit	Characteristic Unit
	CharacteristicValueGroupUnit	characteristicvaluegroupunit	Value Group Unit
	CharacteristicValueGroupType	characteristicvaluegrouptype	Value Group Type
	CharcIsOnlyUsableInValueGroups	charcisonlyusableinvaluegroups	Value Group Only
	CharcCatalogCharacteristicName	charccatalogcharacteristicname	Characteristic Name
	_ProdAllocCharcCatalog	_ProdAllocCharcCatalog
	_Text	_Text
	_ProdAllocCharcCtlgPathRef	_ProdAllocCharcCtlgPathRef
	_AllocCharcCtlgValGrpVal	_AllocCharcCtlgValGrpVal
	_ProdAllocCharcCatalogType	_ProdAllocCharcCatalogType
	_MainCharcCtlgPathRef	_MainCharcCtlgPathRef
	_ProdAllocCharcCtlgUseType	_ProdAllocCharcCtlgUseType
	_ProdAllocCharcCtlgCharcType	_ProdAllocCharcCtlgCharcType
	_ProdAllocCharcCtlgPathType	_ProdAllocCharcCtlgPathType
	_NextLvlProdAllocCharcCtlgPath	_NextLvlProdAllocCharcCtlgPath
	_ParentProdAllocCharcCtlgPath	_ParentProdAllocCharcCtlgPath
	_CharcValExistenceCheckType	_CharcValExistenceCheckType
	_DataElementLabelText	_DataElementLabelText
	_PartnerFunctionText	_PartnerFunctionText
	_CharacteristicUnitOfMeasure	_CharacteristicUnitOfMeasure
	_ValueGroupUnitOfMeasure	_ValueGroupUnitOfMeasure

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_ProdAllocCharcCatalogPath.
-- 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.
-- SQL view name: IPACTLG_PATH

CREATE VIEW I_ProdAllocCharcCatalogPath AS
SELECT
  ProdAllocCharcCtlgPathUUID,
  ProdAllocCharcCtlgPathIntID,
  ProdAllocCharcCatalogType,
  ProdAllocCharcCatalogUseType,
  ProdAllocCharcCatalogUUID,
  ProdAllocCharcCtlgParPathIntID,
  CharacteristicUnitPathIntID,
  ProdAllocCharcCatalogCharcType,
  ProdAllocCharcCatalogPathType,
  ClfnCharacteristicUseType,
  CharcCatalogPathHierarchyType,
  ABAPDataElement,
  ProdAllocCharcCtlgPathSelName,
  ProdAllocCharcCtlgPathSel,
  ProdAllocCharcCatalogPath,
  ProdAllocCharcCtlgAltvPath,
  ProdAllocCharcCtlgLegacyTable,
  ProdAllocCharcCtlgLegacyPath,
  ProdAllocCharcValueHelp,
  ProdAllocCharcValHelpTblField,
  ProdAllocCharcValHelpTextLink,
  ProdAllocCharcValHelpTxtTblFld,
  ProdAllocCharcCtlgCharc,
  ProdAllocCharcCtlgPathIsHidden,
  ProdAllocCharcCtlgPathIsRoot,
  CharcValExistenceCheckType,
  ABAPDictionaryDataType,
  ABAPDictionaryDataTypeLength,
  ABAPDictionaryDataTypeDecimals,
  ABAPOutputLengthValue,
  CharcValueIsCaseSensitive,
  CharcValueConversionRoutine,
  CharcInternalID,
  CharacteristicUnit,
  CharacteristicValueGroupUnit,
  CharacteristicValueGroupType,
  CharcIsOnlyUsableInValueGroups,
  CharcCatalogCharacteristicName
FROM pactlg_path
LEFT OUTER JOIN I_ProdAllocCharcCatalog AS _ProdAllocCharcCatalog ON ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalog.ProdAllocCharcCatalogUUID  -- association [1..1]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathText AS _Text ON ProdAllocCharcCtlgPathUUID = _Text.ProdAllocCharcCtlgPathUUID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathRef AS _ProdAllocCharcCtlgPathRef ON ProdAllocCharcCtlgPathUUID = _ProdAllocCharcCtlgPathRef.ProdAllocCharcCtlgPathUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocCharcCtlgValGrpVal AS _AllocCharcCtlgValGrpVal ON ProdAllocCharcCtlgPathUUID = _AllocCharcCtlgValGrpVal.ProdAllocCharcCtlgPathUUID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocCharcCatalogType AS _ProdAllocCharcCatalogType ON ProdAllocCharcCatalogType = _ProdAllocCharcCatalogType.ProdAllocCharcCatalogType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCtlgUseType AS _ProdAllocCharcCtlgUseType ON ProdAllocCharcCatalogUseType = _ProdAllocCharcCtlgUseType.ProdAllocCharcCatalogUseType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCtlgCharcType AS _ProdAllocCharcCtlgCharcType ON ProdAllocCharcCatalogCharcType = _ProdAllocCharcCtlgCharcType.ProdAllocCharcCatalogCharcType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathType AS _ProdAllocCharcCtlgPathType ON ProdAllocCharcCatalogPathType = _ProdAllocCharcCtlgPathType.ProdAllocCharcCatalogPathType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _NextLvlProdAllocCharcCtlgPath ON ProdAllocCharcCtlgPathIntID = _NextLvlProdAllocCharcCtlgPath.ProdAllocCharcCtlgParPathIntID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _ParentProdAllocCharcCtlgPath ON ProdAllocCharcCtlgParPathIntID = _ParentProdAllocCharcCtlgPath.ProdAllocCharcCtlgPathIntID  -- association [0..1]
LEFT OUTER JOIN I_DataElementLabelText AS _DataElementLabelText ON ABAPDataElement = _DataElementLabelText.ABAPDataElement  -- association [0..*]
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctionText ON ProdAllocCharcCtlgPathSel = _PartnerFunctionText.PartnerFunction  -- association [0..*]
LEFT OUTER JOIN I_CharcValExistenceCheckType AS _CharcValExistenceCheckType ON CharcValExistenceCheckType = _CharcValExistenceCheckType.CharcValExistenceCheckType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathRef AS _MainCharcCtlgPathRef ON _MainCharcCtlgPathRef.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID AND _MainCharcCtlgPathRef.ProdAllocCharcCatalogIsMain = 'X'  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CharacteristicUnitOfMeasure ON CharacteristicUnit = _CharacteristicUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ValueGroupUnitOfMeasure ON CharacteristicValueGroupUnit = _ValueGroupUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Depth:

I_ProdAllocCharcCatalogPath view

pactlg_path