P_UserContactCard

DDL: P_USERCONTACTCARD SQL: PPUSRCONCARD Type: view CONSUMPTION

User details

P_UserContactCard is a Consumption CDS View that provides data about "User details" in SAP S/4HANA. It reads from 1 data source (I_MaterialDocumentRecord) and exposes 4 fields with key fields MaterialDocument, MaterialDocumentItem. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_MaterialDocumentRecord _MaterialDocumentRecord from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UserContactCard _UserContactCard $projection.CreatedByUser = _UserContactCard.ContactCardID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PPUSRCONCARD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label User details view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MaterialDocument I_MaterialDocumentRecord MaterialDocument
KEY MaterialDocumentItem I_MaterialDocumentRecord MaterialDocumentItem
CreatedByUser CreatedByUser
_UserContactCard _UserContactCard 
@AbapCatalog.sqlViewName: 'PPUSRCONCARD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'User details'
@AccessControl.privilegedAssociations: ['_UserContactCard']

define view P_UserContactCard
  as select from I_MaterialDocumentRecord as _MaterialDocumentRecord

  association [1..1] to I_UserContactCard as _UserContactCard on $projection.CreatedByUser = _UserContactCard.ContactCardID
{

  key _MaterialDocumentRecord.MaterialDocument,
  key _MaterialDocumentRecord.MaterialDocumentItem,

      CreatedByUser,
      _UserContactCard
}

Learn More