C_JournalEntryUserContactCard

DDL: C_JOURNALENTRYUSERCONTACTCARD Type: view CONSUMPTION Package: ODATA_INSPECT_ITEMS_CHNGLOG
9 Fields 1 Data Sources 3 OData Services

Journal Entry User Contact Card

C_JournalEntryUserContactCard is a Consumption CDS View that provides data about "Journal Entry User Contact Card" in SAP S/4HANA. It reads from 1 data source (I_UserContactCard) and exposes 9 fields with key field ContactCardID. It is exposed through 3 OData services (ASQL_F2681, ASQL_F7795, ASQL_F7796). Part of development package ODATA_INSPECT_ITEMS_CHNGLOG.

Data Sources (1)

SourceAliasJoin Type
I_UserContactCard _UserContactCard from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CDOCUSRCNTCT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Journal Entry User Contact Card view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
VDM.private false view
Consumption.ranked true view
Search.searchable true view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F2681 ASQL_F2681 C2 NOT_RELEASED
ASQL_F7795 ASQL_F7795 C2 NOT_RELEASED
ASQL_F7796 ASQL_F7796 C2 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID I_UserContactCard ContactCardID User name
FirstName I_UserContactCard FirstName First Name
LastName I_UserContactCard LastName Last Name
FullName I_UserContactCard FullName Name
PhoneNumber I_UserContactCard PhoneNumber Telephone no.
MobilePhoneNumber I_UserContactCard MobilePhoneNumber Telephone
FaxNumber I_UserContactCard FaxNumber Fax Number
EmailAddress I_UserContactCard EmailAddress Email
Department I_UserContactCard Department Department

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_JournalEntryUserContactCard.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_JournalEntryUserContactCard AS
SELECT
  _UserContactCard.ContactCardID AS ContactCardID,
  _UserContactCard.FirstName AS FirstName,
  _UserContactCard.LastName AS LastName,
  _UserContactCard.FullName AS FullName,
  _UserContactCard.PhoneNumber AS PhoneNumber,
  _UserContactCard.MobilePhoneNumber AS MobilePhoneNumber,
  _UserContactCard.FaxNumber AS FaxNumber,
  _UserContactCard.EmailAddress AS EmailAddress,
  _UserContactCard.Department AS Department
FROM I_UserContactCard AS _UserContactCard
;

Learn More