I_LCMUserAddressAssignment

DDL: I_LCMUSERADDRESSASSIGNMENT SQL: ILCMUSRADDRASSGN Type: view BASIC

User Name/Address Key Assignment

I_LCMUserAddressAssignment is a Basic CDS View that provides data about "User Name/Address Key Assignment" in SAP S/4HANA. It reads from 1 data source (usr21) and exposes 6 fields with key field ContactCardID.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
usr21 _User from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ILCMUSRADDRASSGN view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label User Name/Address Key Assignment view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID usr21 bname
Person usr21 persnumber
BusinessPartnerUUID usr21 bpperson
AddressID usr21 addrnumber
FullName usr21 techdesc
UserID usr21 bname 
@AbapCatalog.sqlViewName: 'ILCMUSRADDRASSGN'
@AbapCatalog.preserveKey:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY //#CHECK //

@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'User Name/Address Key Assignment'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API


define view I_LCMUserAddressAssignment
  as select from usr21 as _User
{
      @Semantics.contact.type: #PERSON
  key _User.bname      as ContactCardID,

      _User.persnumber as Person,

      _User.bpperson   as BusinessPartnerUUID,

      _User.addrnumber as AddressID,

      _User.techdesc   as FullName,

      _User.bname      as UserID
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"USR21"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More