I_ProdAllocCharcCtlgPathTP

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_ProdAllocCharcCtlgPathTP.
-- 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_PATHTP

CREATE VIEW I_ProdAllocCharcCtlgPathTP AS
SELECT
  Document.ProdAllocCharcCtlgPathUUID AS ProdAllocCharcCtlgPathUUID,
  Document.ProdAllocCharcCtlgPathIntID AS ProdAllocCharcCtlgPathIntID,
  Document.ProdAllocCharcCatalogType AS ProdAllocCharcCatalogType,
  Document.ProdAllocCharcCatalogUseType AS ProdAllocCharcCatalogUseType,
  Document.ProdAllocCharcCatalogUUID AS ProdAllocCharcCatalogUUID,
  Document.ProdAllocCharcCtlgParPathIntID AS ProdAllocCharcCtlgParPathIntID,
  Document.CharacteristicUnitPathIntID AS CharacteristicUnitPathIntID,
  Document.ProdAllocCharcCatalogCharcType AS ProdAllocCharcCatalogCharcType,
  Document.ProdAllocCharcCatalogPathType AS ProdAllocCharcCatalogPathType,
  Document.ClfnCharacteristicUseType AS ClfnCharacteristicUseType,
  Document.CharcCatalogPathHierarchyType AS CharcCatalogPathHierarchyType,
  Document.ABAPDataElement AS ABAPDataElement,
  Document.ProdAllocCharcCtlgPathSelName AS ProdAllocCharcCtlgPathSelName,
  Document.ProdAllocCharcCtlgPathSel AS ProdAllocCharcCtlgPathSel,
  Document.ProdAllocCharcCatalogPath AS ProdAllocCharcCatalogPath,
  Document.ProdAllocCharcCtlgAltvPath AS ProdAllocCharcCtlgAltvPath,
  Document.ProdAllocCharcCtlgLegacyTable AS ProdAllocCharcCtlgLegacyTable,
  Document.ProdAllocCharcCtlgLegacyPath AS ProdAllocCharcCtlgLegacyPath,
  Document.ProdAllocCharcValueHelp AS ProdAllocCharcValueHelp,
  Document.ProdAllocCharcValHelpTblField AS ProdAllocCharcValHelpTblField,
  Document.ProdAllocCharcValHelpTextLink AS ProdAllocCharcValHelpTextLink,
  Document.ProdAllocCharcValHelpTxtTblFld AS ProdAllocCharcValHelpTxtTblFld,
  Document.ProdAllocCharcCtlgCharc AS ProdAllocCharcCtlgCharc,
  Document.ProdAllocCharcCtlgPathIsHidden AS ProdAllocCharcCtlgPathIsHidden,
  Document.ProdAllocCharcCtlgPathIsRoot AS ProdAllocCharcCtlgPathIsRoot,
  Document.CharcValExistenceCheckType AS CharcValExistenceCheckType,
  Document.ABAPDictionaryDataType AS ABAPDictionaryDataType,
  Document.ABAPDictionaryDataTypeLength AS ABAPDictionaryDataTypeLength,
  Document.ABAPDictionaryDataTypeDecimals AS ABAPDictionaryDataTypeDecimals,
  Document.ABAPOutputLengthValue AS ABAPOutputLengthValue,
  Document.CharcValueIsCaseSensitive AS CharcValueIsCaseSensitive,
  Document.CharcValueConversionRoutine AS CharcValueConversionRoutine,
  Document.CharcInternalID AS CharcInternalID,
  Document.CharacteristicUnit AS CharacteristicUnit,
  Document.CharacteristicValueGroupUnit AS CharacteristicValueGroupUnit,
  Document.CharacteristicValueGroupType AS CharacteristicValueGroupType,
  Document.CharcIsOnlyUsableInValueGroups AS CharcIsOnlyUsableInValueGroups,
  Document.CharcCatalogCharacteristicName AS CharcCatalogCharacteristicName
FROM I_ProdAllocCharcCatalogPath AS Document
LEFT OUTER JOIN I_ProdAllocCharcCatalogTP AS _ProdAllocCharcCatalogTP ON _ProdAllocCharcCatalogTP.ProdAllocCharcCatalogUUID = ProdAllocCharcCatalogUUID  -- association [1..1]
LEFT OUTER JOIN I_AllocCharcCtlgPathTTP AS _AllocCharcCtlgPathTTP ON _AllocCharcCtlgPathTTP.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathRefTP AS _ProdAllocCharcCtlgPathRefTP ON _ProdAllocCharcCtlgPathRefTP.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocCharcCtlgValGrpValTP AS _AllocCharcCtlgValGrpValTP ON _AllocCharcCtlgValGrpValTP.ProdAllocCharcCtlgPathUUID = 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 _ProdAllocCharcCtlgUseType.ProdAllocCharcCatalogUseType = ProdAllocCharcCatalogUseType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCtlgCharcType AS _ProdAllocCharcCtlgCharcType ON _ProdAllocCharcCtlgCharcType.ProdAllocCharcCatalogCharcType = ProdAllocCharcCatalogCharcType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathType AS _ProdAllocCharcCtlgPathType ON _ProdAllocCharcCtlgPathType.ProdAllocCharcCatalogPathType = ProdAllocCharcCatalogPathType  -- association [0..1]
LEFT OUTER JOIN I_ProdAllocCharcCatalogPath AS _NextLvlProdAllocCharcCtlgPath ON _NextLvlProdAllocCharcCtlgPath.ProdAllocCharcCtlgParPathIntID = ProdAllocCharcCtlgPathIntID  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathTP AS _ParProdAllocCharcCtlgPathTP ON ProdAllocCharcCtlgParPathIntID = _ParProdAllocCharcCtlgPathTP.ProdAllocCharcCtlgPathIntID  -- association [0..1]
LEFT OUTER JOIN I_DataElementLabelText AS _DataElementLabelText ON _DataElementLabelText.ABAPDataElement = ABAPDataElement  -- association [0..*]
LEFT OUTER JOIN I_PartnerFunctionText AS _PartnerFunctionText ON _PartnerFunctionText.PartnerFunction = ProdAllocCharcCtlgPathSel  -- association [0..*]
LEFT OUTER JOIN I_ProdAllocCharcCtlgPathRefTP AS _MainCharcCtlgPathRefTP ON _MainCharcCtlgPathRefTP.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID AND _MainCharcCtlgPathRefTP.ProdAllocCharcCatalogIsMain = 'X'  -- association [0..1]
LEFT OUTER JOIN I_AllocCharcCtlgPathTTP AS _GrpAllocCharcCtlgPathTTP ON _GrpAllocCharcCtlgPathTTP.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID  -- association [0..*]
LEFT OUTER JOIN I_AllocCharcCtlgPathTTP AS _ClfnAllocCharcCtlgPathTTP ON _ClfnAllocCharcCtlgPathTTP.ProdAllocCharcCtlgPathUUID = ProdAllocCharcCtlgPathUUID  -- association [0..*]
LEFT OUTER JOIN I_CharcValExistenceCheckType AS _CharcValExistenceCheckType ON _CharcValExistenceCheckType.CharcValExistenceCheckType = CharcValExistenceCheckType  -- association [0..1]
LEFT OUTER JOIN I_CharacteristicValueGroupType AS _CharacteristicValueGroupType ON _CharacteristicValueGroupType.CharacteristicValueGroupType = CharacteristicValueGroupType  -- 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]
;