P_PRODALLOCCHARCCTLGPATH

DDL: P_PRODALLOCCHARCCTLGPATH SQL: PPACTLG_PATH Type: view COMPOSITE
40 Fields 2 Data Sources 2 Associations

P_PRODALLOCCHARCCTLGPATH is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ProdAllocCharcCatalogPath, pactlg_pathd) and exposes 40 fields with key field ProdAllocCharcCtlgPathUUID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_ProdAllocCharcCatalogPath ActiveDocument from
pactlg_pathd DraftDocument union_all

Associations (2)

CardinalityTargetAliasCondition
[0..1] sdraft_admin _DraftAdmin _DraftAdmin.draft_key = $projection.prodalloccharccataloguuid and _DraftAdmin.draft_entity = 'I_PRODALLOCCHARCCATALOGTP' and _DraftAdmin.created_by = $session.user
[0..1] pactlg_pathrefd _DraftMainCharcCtlgPathRef _DraftMainCharcCtlgPathRef.prodalloccharcctlgpathuuid = $projection.prodalloccharcctlgpathuuid and _DraftMainCharcCtlgPathRef.prodalloccharccatalogismain = 'X'

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPACTLG_PATH view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocCharcCtlgPathUUID I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgPathUUID Product Allocation Characteristic Catalog Path UUID
ActiveAllocCharcCtlgPathUUID I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgPathUUID UUID
ProdAllocCharcCtlgPathIntID I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgPathIntID Catalog Path Internal ID
ProdAllocCharcCatalogType I_ProdAllocCharcCatalogPath ProdAllocCharcCatalogType Catalog Type
ProdAllocCharcCatalogUseType I_ProdAllocCharcCatalogPath ProdAllocCharcCatalogUseType Catalog Use Type
ProdAllocCharcCatalogUUID I_ProdAllocCharcCatalogPath ProdAllocCharcCatalogUUID UUID
ProdAllocCharcCtlgParPathIntID I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgParPathIntID Catalog Parent Path Internal ID
ProdAllocCharcCatalogCharcType I_ProdAllocCharcCatalogPath ProdAllocCharcCatalogCharcType Characteristic Type
ProdAllocCharcCatalogPathType I_ProdAllocCharcCatalogPath ProdAllocCharcCatalogPathType Characteristic Path Type
ClfnCharacteristicUseType I_ProdAllocCharcCatalogPath ClfnCharacteristicUseType Type
ABAPDataElement I_ProdAllocCharcCatalogPath ABAPDataElement Data Element
ProdAllocCharcCtlgPathSelName I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgPathSelName Path Selection Name
ProdAllocCharcCtlgPathSel I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgPathSel Characteristic Catalog Path Selection
ProdAllocCharcCatalogPath I_ProdAllocCharcCatalogPath ProdAllocCharcCatalogPath Charc Catalog Path
ProdAllocCharcCtlgAltvPath I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgAltvPath Alternative Path
ProdAllocCharcCtlgLegacyTable I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgLegacyTable Legacy Table
ProdAllocCharcCtlgLegacyPath I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgLegacyPath Legacy Path
ProdAllocCharcValueHelp I_ProdAllocCharcCatalogPath ProdAllocCharcValueHelp Value Help
ProdAllocCharcValHelpTblField I_ProdAllocCharcCatalogPath ProdAllocCharcValHelpTblField Value Help Field
ProdAllocCharcValHelpTextLink I_ProdAllocCharcCatalogPath ProdAllocCharcValHelpTextLink Value Help Text Link
ProdAllocCharcValHelpTxtTblFld I_ProdAllocCharcCatalogPath ProdAllocCharcValHelpTxtTblFld Value Help Text Field
ProdAllocCharcCtlgCharc I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgCharc Characteristic
CharcInternalID I_ProdAllocCharcCatalogPath CharcInternalID Characteristic Internal ID
ProdAllocCharcCtlgPathIsRoot I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgPathIsRoot Catalog Characteristic Path Is Root
ABAPDictionaryDataType I_ProdAllocCharcCatalogPath ABAPDictionaryDataType Data Type
ABAPDictionaryDataTypeLength I_ProdAllocCharcCatalogPath ABAPDictionaryDataTypeLength No. of Characters
ABAPDictionaryDataTypeDecimals I_ProdAllocCharcCatalogPath ABAPDictionaryDataTypeDecimals Decimal Places
ABAPOutputLengthValue I_ProdAllocCharcCatalogPath ABAPOutputLengthValue Output Length
CharcValueIsCaseSensitive I_ProdAllocCharcCatalogPath CharcValueIsCaseSensitive Case Sensitive
CharacteristicUnitPathIntID I_ProdAllocCharcCatalogPath CharacteristicUnitPathIntID Unit Internal Identifier
CharcValExistenceCheckType I_ProdAllocCharcCatalogPath CharcValExistenceCheckType Value Existence Check Type
ProdAllocCharcCtlgPathIsHidden I_ProdAllocCharcCatalogPath ProdAllocCharcCtlgPathIsHidden Catalog Characteristic Path Is Hidden
IsActiveEntity
IsMyDraft
BaseCharcCatalogPathIntID Catalog Path Internal ID
ActiveAllocCharcCtlgPathUUID pactlg_pathd activeuuid UUID
IsActiveEntity
IsMyDraft
BaseCharcCatalogPathIntID _DraftMainCharcCtlgPathRef basecharccatalogpathintid Catalog Path Internal ID
DraftEntityOperationCode pactlg_pathd draftentityoperationcode Draft - Operation Code

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 P_PRODALLOCCHARCCTLGPATH.
-- 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: PPACTLG_PATH

CREATE VIEW P_PRODALLOCCHARCCTLGPATH AS
SELECT
  ActiveDocument.ProdAllocCharcCtlgPathUUID AS ProdAllocCharcCtlgPathUUID,
  ActiveDocument.ProdAllocCharcCtlgPathUUID AS ActiveAllocCharcCtlgPathUUID,
  ActiveDocument.ProdAllocCharcCtlgPathIntID AS ProdAllocCharcCtlgPathIntID,
  ActiveDocument.ProdAllocCharcCatalogType AS ProdAllocCharcCatalogType,
  ActiveDocument.ProdAllocCharcCatalogUseType AS ProdAllocCharcCatalogUseType,
  ActiveDocument.ProdAllocCharcCatalogUUID AS ProdAllocCharcCatalogUUID,
  ActiveDocument.ProdAllocCharcCtlgParPathIntID AS ProdAllocCharcCtlgParPathIntID,
  ActiveDocument.ProdAllocCharcCatalogCharcType AS ProdAllocCharcCatalogCharcType,
  ActiveDocument.ProdAllocCharcCatalogPathType AS ProdAllocCharcCatalogPathType,
  ActiveDocument.ClfnCharacteristicUseType AS ClfnCharacteristicUseType,
  ActiveDocument.ABAPDataElement AS ABAPDataElement,
  ActiveDocument.ProdAllocCharcCtlgPathSelName AS ProdAllocCharcCtlgPathSelName,
  ActiveDocument.ProdAllocCharcCtlgPathSel AS ProdAllocCharcCtlgPathSel,
  ActiveDocument.ProdAllocCharcCatalogPath AS ProdAllocCharcCatalogPath,
  ActiveDocument.ProdAllocCharcCtlgAltvPath AS ProdAllocCharcCtlgAltvPath,
  ActiveDocument.ProdAllocCharcCtlgLegacyTable AS ProdAllocCharcCtlgLegacyTable,
  ActiveDocument.ProdAllocCharcCtlgLegacyPath AS ProdAllocCharcCtlgLegacyPath,
  ActiveDocument.ProdAllocCharcValueHelp AS ProdAllocCharcValueHelp,
  ActiveDocument.ProdAllocCharcValHelpTblField AS ProdAllocCharcValHelpTblField,
  ActiveDocument.ProdAllocCharcValHelpTextLink AS ProdAllocCharcValHelpTextLink,
  ActiveDocument.ProdAllocCharcValHelpTxtTblFld AS ProdAllocCharcValHelpTxtTblFld,
  ActiveDocument.ProdAllocCharcCtlgCharc AS ProdAllocCharcCtlgCharc,
  ActiveDocument.CharcInternalID AS CharcInternalID,
  ActiveDocument.ProdAllocCharcCtlgPathIsRoot AS ProdAllocCharcCtlgPathIsRoot,
  ActiveDocument.ABAPDictionaryDataType AS ABAPDictionaryDataType,
  ActiveDocument.ABAPDictionaryDataTypeLength AS ABAPDictionaryDataTypeLength,
  ActiveDocument.ABAPDictionaryDataTypeDecimals AS ABAPDictionaryDataTypeDecimals,
  ActiveDocument.ABAPOutputLengthValue AS ABAPOutputLengthValue,
  ActiveDocument.CharcValueIsCaseSensitive AS CharcValueIsCaseSensitive,
  ActiveDocument.CharacteristicUnitPathIntID AS CharacteristicUnitPathIntID,
  ActiveDocument.CharcValExistenceCheckType AS CharcValExistenceCheckType,
  ActiveDocument.ProdAllocCharcCtlgPathIsHidden AS ProdAllocCharcCtlgPathIsHidden,
  'X' AS IsActiveEntity,
  '' AS IsMyDraft,
  ActiveDocument._MainCharcCtlgPathRef.BaseCharcCatalogPathIntID AS BaseCharcCatalogPathIntID,
  DraftDocument.draftentityoperationcode AS DraftEntityOperationCode
FROM I_ProdAllocCharcCatalogPath AS ActiveDocument
LEFT OUTER JOIN sdraft_admin AS _DraftAdmin ON _DraftAdmin.draft_key = prodalloccharccataloguuid AND _DraftAdmin.draft_entity = 'I_PRODALLOCCHARCCATALOGTP' AND _DraftAdmin.created_by = $session.user  -- association [0..1]
LEFT OUTER JOIN pactlg_pathrefd AS _DraftMainCharcCtlgPathRef ON _DraftMainCharcCtlgPathRef.prodalloccharcctlgpathuuid = prodalloccharcctlgpathuuid AND _DraftMainCharcCtlgPathRef.prodalloccharccatalogismain = 'X'  -- association [0..1]
-- UNION ALL with additional select branch(es): pactlg_pathd
;

Learn More