I_LCMUSERADDRESSASSIGNMENT

CDS View

User Name/Address Key Assignment

I_LCMUSERADDRESSASSIGNMENT is a CDS View in S/4HANA. User Name/Address Key Assignment. It contains 4 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 4 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_LCMUserContactCard view from COMPOSITE Basic view for LCM User Contact Card
I_LglCntntMUserDetails view from COMPOSITE User Details

Fields (4)

KeyField CDS FieldsUsed in Views
KEY ContactCardID ContactCardID 2
AddressID AddressID 2
BusinessPartnerUUID BusinessPartnerUUID 2
Person Person 2 
@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