I_ProdAllocCharcCtlgPathRef

DDL: I_PRODALLOCCHARCCTLGPATHREF SQL: IPACTLG_PATHREF Type: view BASIC

Product Allocation Characteristic Catalog Path Reference

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

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
pactlg_pathref pactlg_pathref from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ProdAllocCharcCatalog _ProdAllocCharcCatalog $projection.ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalog.ProdAllocCharcCatalogUUID
[1..1] I_ProdAllocCharcCatalogPath _ProdAllocCharcCatalogPath $projection.ProdAllocCharcCtlgPathUUID = _ProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID
[0..1] I_ProdAllocCharcCatalogType _ProdAllocCharcCatalogType $projection.BaseCharacteristicCatalogType = _ProdAllocCharcCatalogType.ProdAllocCharcCatalogType
[0..1] I_ProdAllocCharcCatalogPath _BaseProdAllocCharcCatalogPath $projection.BaseCharcCatalogPathUUID = _BaseProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPACTLG_PATHREF view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Product Allocation Characteristic Catalog Path Reference view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocCharcCtlgPathRefUUID prodalloccharcctlgpathrefuuid
ProdAllocCharcCatalogUUID prodalloccharccataloguuid
ProdAllocCharcCtlgPathUUID prodalloccharcctlgpathuuid
ProdAllocCharcCatalogIsMain prodalloccharccatalogismain
BaseCharacteristicCatalogType basecharacteristiccatalogtype
BaseCharcCatalogPathUUID basecharccatalogpathuuid
BaseCharcCatalogPathIntID basecharccatalogpathintid
_ProdAllocCharcCatalog _ProdAllocCharcCatalog
_ProdAllocCharcCatalogPath _ProdAllocCharcCatalogPath
_BaseProdAllocCharcCatalogPath _BaseProdAllocCharcCatalogPath
_ProdAllocCharcCatalogType _ProdAllocCharcCatalogType 
@AbapCatalog.sqlViewName: 'IPACTLG_PATHREF'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #NOT_REQUIRED  //or #NOT_REQUIRED #CHECK

@EndUserText.label: 'Product Allocation Characteristic Catalog Path Reference'
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_ProdAllocCharcCtlgPathRef as select from pactlg_pathref 
  association [1..1] to I_ProdAllocCharcCatalog       as _ProdAllocCharcCatalog  on $projection.ProdAllocCharcCatalogUUID = _ProdAllocCharcCatalog.ProdAllocCharcCatalogUUID
  association [1..1] to I_ProdAllocCharcCatalogPath   as _ProdAllocCharcCatalogPath  on $projection.ProdAllocCharcCtlgPathUUID = _ProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID
  association [0..1] to I_ProdAllocCharcCatalogType   as _ProdAllocCharcCatalogType     on $projection.BaseCharacteristicCatalogType = _ProdAllocCharcCatalogType.ProdAllocCharcCatalogType
  association [0..1] to I_ProdAllocCharcCatalogPath   as _BaseProdAllocCharcCatalogPath  on $projection.BaseCharcCatalogPathUUID = _BaseProdAllocCharcCatalogPath.ProdAllocCharcCtlgPathUUID
{
key prodalloccharcctlgpathrefuuid as ProdAllocCharcCtlgPathRefUUID,
    @ObjectModel.foreignKey.association: '_ProdAllocCharcCatalog'
    prodalloccharccataloguuid as ProdAllocCharcCatalogUUID,
    @ObjectModel.foreignKey.association: '_ProdAllocCharcCatalogPath'
    prodalloccharcctlgpathuuid as ProdAllocCharcCtlgPathUUID,
    prodalloccharccatalogismain as ProdAllocCharcCatalogIsMain,
    @ObjectModel.foreignKey.association: '_ProdAllocCharcCatalogType'
    basecharacteristiccatalogtype as BaseCharacteristicCatalogType,
    @ObjectModel.foreignKey.association: '_BaseProdAllocCharcCatalogPath'
    basecharccatalogpathuuid as BaseCharcCatalogPathUUID,
    basecharccatalogpathintid as BaseCharcCatalogPathIntID,

    @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
    _ProdAllocCharcCatalog,
    @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
    _ProdAllocCharcCatalogPath,
    _BaseProdAllocCharcCatalogPath,
    _ProdAllocCharcCatalogType
}

Learn More