P_ProdAllocCharcCtlgPathRef

DDL: P_PRODALLOCCHARCCTLGPATHREF Type: view_entity COMPOSITE

Charc. Catalog Path Reference with Draft

P_ProdAllocCharcCtlgPathRef is a Composite CDS View that provides data about "Charc. Catalog Path Reference with Draft" in SAP S/4HANA. It reads from 2 data sources (I_ProdAllocCharcCtlgPathRef, pactlg_pathrefd) and exposes 18 fields with key field ProdAllocCharcCtlgPathRefUUID. It has 1 association to related views.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
I_ProdAllocCharcCtlgPathRef Active from
pactlg_pathrefd Draft union_all

Associations (1)

CardinalityTargetAliasCondition
[0..1] sdraft_admin _DraftAdmin _DraftAdmin.draft_key = $projection.ProdAllocCharcCatalogUUID and _DraftAdmin.draft_entity = 'I_PRODALLOCCHARCCATALOGTP' and _DraftAdmin.created_by = $session.user

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Charc. Catalog Path Reference with Draft view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProdAllocCharcCtlgPathRefUUID ProdAllocCharcCtlgPathRefUUID
ProdAllocCharcCatalogUUID ProdAllocCharcCatalogUUID
ProdAllocCharcCtlgPathUUID ProdAllocCharcCtlgPathUUID
ProdAllocCharcCatalogIsMain ProdAllocCharcCatalogIsMain
BaseCharacteristicCatalogType BaseCharacteristicCatalogType
BaseCharcCatalogPathUUID BaseCharcCatalogPathUUID
BaseCharcCatalogPathIntID BaseCharcCatalogPathIntID
IsActiveEntity
IsMyDraft
ProdAllocCharcCatalogUUID prodalloccharccataloguuid
ProdAllocCharcCtlgPathUUID prodalloccharcctlgpathuuid
ProdAllocCharcCatalogIsMain prodalloccharccatalogismain
BaseCharacteristicCatalogType basecharacteristiccatalogtype
BaseCharcCatalogPathUUID basecharccatalogpathuuid
BaseCharcCatalogPathIntID basecharccatalogpathintid
IsActiveEntity
IsMyDraft
DraftEntityOperationCode draftentityoperationcode 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Charc. Catalog Path Reference with Draft'
@Metadata.ignorePropagatedAnnotations: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MASTER
}
define view entity P_ProdAllocCharcCtlgPathRef
  as select from I_ProdAllocCharcCtlgPathRef as Active
{
  key ProdAllocCharcCtlgPathRefUUID,
      ProdAllocCharcCatalogUUID,
      ProdAllocCharcCtlgPathUUID,
      ProdAllocCharcCatalogIsMain,
      BaseCharacteristicCatalogType,
      BaseCharcCatalogPathUUID,
      BaseCharcCatalogPathIntID,
      'X' as IsActiveEntity,
      ''  as IsMyDraft,
      ''  as DraftEntityOperationCode
}
union all select from pactlg_pathrefd as Draft
association [0..1] to sdraft_admin as _DraftAdmin on  _DraftAdmin.draft_key    = $projection.ProdAllocCharcCatalogUUID
                                                  and _DraftAdmin.draft_entity = 'I_PRODALLOCCHARCCATALOGTP'
                                                  and _DraftAdmin.created_by   = $session.user
{
  key prodalloccharcctlgpathrefuuid as ProdAllocCharcCtlgPathRefUUID,
      prodalloccharccataloguuid     as ProdAllocCharcCatalogUUID,
      prodalloccharcctlgpathuuid    as ProdAllocCharcCtlgPathUUID,
      prodalloccharccatalogismain   as ProdAllocCharcCatalogIsMain,
      basecharacteristiccatalogtype as BaseCharacteristicCatalogType,
      basecharccatalogpathuuid      as BaseCharcCatalogPathUUID,
      basecharccatalogpathintid     as BaseCharcCatalogPathIntID,
      ''                            as IsActiveEntity,
      'X'                           as IsMyDraft,
      draftentityoperationcode      as DraftEntityOperationCode
}
where
  Draft.prodalloccharccataloguuid = _DraftAdmin.draft_key
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PRODALLOCCHARCCTLGPATHREF",
"PACTLG_PATHREFD",
"SDRAFT_ADMIN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More