C_PurOrdMaintainUserDetail

DDL: C_PURORDMAINTAINUSERDETAIL SQL: CPOMAINTUSRDET Type: view CONSUMPTION

PO Maintenance: User Detail

C_PurOrdMaintainUserDetail is a Consumption CDS View that provides data about "PO Maintenance: User Detail" in SAP S/4HANA. It reads from 2 data sources (I_Address, I_UserContactCard) and exposes 13 fields with key field UserID.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_Address _Address left_outer
I_UserContactCard _UserContactCard from

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName CPOMAINTUSRDET view
EndUserText.label PO Maintenance: User Detail view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY UserID I_UserContactCard ContactCardID
FullName I_UserContactCard FullName
MobilePhoneNumber I_UserContactCard MobilePhoneNumber
PhoneNumber I_UserContactCard PhoneNumber
EmailAddress I_UserContactCard EmailAddress
AddressName I_Address BusinessPartnerName1
PostalCode I_Address PostalCode
CityName I_Address CityName
StreetName I_Address StreetName
HouseNumber I_Address HouseNumber
Region I_Address Region
Country I_Address Country
Department I_UserContactCard Department 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'CPOMAINTUSRDET'
@EndUserText.label: 'PO Maintenance: User Detail'
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY

define view C_PurOrdMaintainUserDetail 

  as select from I_UserContactCard as _UserContactCard

    left outer join I_Address as _Address on _UserContactCard.AddressID = _Address.AddressID and _Address.Nation = ' '

{
   key _UserContactCard.ContactCardID     as UserID,
       _UserContactCard.FullName          as FullName,
       _UserContactCard.MobilePhoneNumber as MobilePhoneNumber,
       _UserContactCard.PhoneNumber       as PhoneNumber,
       _UserContactCard.EmailAddress      as EmailAddress,
       _Address.BusinessPartnerName1      as AddressName,
       _Address.PostalCode                as PostalCode,
       _Address.CityName                  as CityName,
       _Address.StreetName                as StreetName,
       _Address.HouseNumber               as HouseNumber,
       _Address.Region                    as Region,
       _Address.Country                   as Country,
       _UserContactCard.Department        as Department
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_USERCONTACTCARD"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More