P_PDRELATION

DDL: P_PDRELATION SQL: PPDRELATION Type: view BASIC Package: VDM_SHCM_EMPLOYEE

PD Relation

P_PDRELATION is a Basic CDS View that provides data about "PD Relation" in SAP S/4HANA. It reads from 2 data sources (hrp1001, t77s0) and exposes 10 fields with key fields PlanVersion, ObjectType, ObjectID, RelationShipDirection, ReleationShip. Part of development package VDM_SHCM_EMPLOYEE.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
hrp1001 relation from
t77s0 systemtable inner

Annotations (3)

NameValueLevelField
VDM.private true view
AbapCatalog.sqlViewName PPDRELATION view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PlanVersion hrp1001 plvar
KEY ObjectType hrp1001 otype
KEY ObjectID hrp1001 objid
KEY RelationShipDirection hrp1001 rsign
KEY ReleationShip hrp1001 relat
RelationStatus hrp1001 istat
StartDate hrp1001 begda
EndDate hrp1001 endda
RelatedObjectType hrp1001 sclas
RelatedObjectID hrp1001 sobid 
@VDM.private: true
@AbapCatalog.sqlViewName: 'PPDRELATION'
@VDM.viewType: #BASIC
define view P_PDRELATION
  as select from hrp1001 as relation
    inner join   t77s0   as systemtable on  grpid = 'PLOGI'
                                        and semid = 'PLOGI'
                                        and gsval = relation.plvar
{
  key relation.plvar as PlanVersion,
  key relation.otype as ObjectType,
  key relation.objid as ObjectID,
  key relation.rsign as RelationShipDirection,
  key relation.relat as ReleationShip,

      relation.istat as RelationStatus,



      relation.begda as StartDate,
      relation.endda as EndDate,

      relation.sclas as RelatedObjectType,
      relation.sobid as RelatedObjectID
}
where
  endda = '99991231'

//  as select from P_PDRELATION_001

//{

//  key PlanVersion,

//  key ObjectType,

//  key ObjectID,

//  key RelationShipDirection,

//  key ReleationShip,

//

//      RelationStatus,

//      StartDate,

//      EndDate,

//

//      RelatedObjectType,

//      RelatedObjectID

//}



// as select from hrp1001 as relation

//inner join t77s0 as systemtable on grpid = 'PLOGI' and semid = 'PLOGI' and gsval = relation.plvar

//{

//    key relation.plvar  as PlanVersion,

//    key relation.otype  as ObjectType,

//    key relation.objid  as ObjectID,

//    key relation.rsign  as RelationShipDirection,

//    key relation.relat  as ReleationShip,

//

//    relation.istat     as RelationStatus,

//

//

//

//    relation.begda     as StartDate,

//    relation.endda     as EndDate,

//

//    relation.sclas     as RelatedObjectType,

//    relation.sobid     as RelatedObjectID

//  }

//    where endda = '99991231'

//

Learn More