C_CAInvcgUserContact

DDL: C_CAINVCGUSERCONTACT Type: view_entity COMPOSITE Package: FKKINV_VDM_UTILS

Benutzerkontaktdaten

C_CAInvcgUserContact is a Composite CDS View that provides data about "Benutzerkontaktdaten" in SAP S/4HANA. It reads from 1 data source (I_UserContactCard) and exposes 6 fields with key field ContactCardID. It is exposed through 9 OData services (ASQL_F3068, ASQL_F4443, ASQL_F4522, ...). It is used in 1 Fiori application: Monitor Disconnection Requests. Part of development package FKKINV_VDM_UTILS.

Data Sources (1)

SourceAliasJoin Type
I_UserContactCard _User from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
EndUserText.label Benutzerkontaktdaten view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.representativeKey ContactCardID view
Analytics.technicalName CCAUSERCONTACT view

OData Services (9)

ServiceBindingVersionContractRelease
ASQL_F3068 ASQL_F3068 C2 NOT_RELEASED
ASQL_F4443 ASQL_F4443 C2 NOT_RELEASED
ASQL_F4522 ASQL_F4522 C2 NOT_RELEASED
ASQL_F4531 ASQL_F4531 C2 NOT_RELEASED
ASQL_F4824 ASQL_F4824 C2 NOT_RELEASED
ASQL_F4943 ASQL_F4943 C2 NOT_RELEASED
UI_CADISCONNCNRECONNCN_MNT UI_CADISCONNCNRECONNCN_MNT V2 C1 NOT_RELEASED
UI_CADISPUTECASE UI_CADISPUTECASE V2 C1 NOT_RELEASED
UI_O2C_FICA_DSPSTVALADJ UI_O2C_FICA_DSPSTVALADJ_O2 V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4943 Monitor Disconnection Requests Transactional An Application to monitor the status of disconnection requests

Monitor Disconnection Requests

Business Role: Administrator - Accounts Payable and Receivable (FI-CA)

The Monitor Disconnection Requests app enables you to follow up on disconnection requests wether they are sent correctly or already invalidated.With this now the entire process is provided to trigger disconnection of services from dunning of overdue items or vice versa trigger service reconnection upon posted payments to items involved in service disconnections.

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ContactCardID ContactCardID User name
FullName I_UserContactCard FullName Name
Department I_UserContactCard Department Department
FunctionalTitleName I_UserContactCard FunctionalTitleName Unit Func.
PhoneNumber I_UserContactCard PhoneNumber Telephone no.
EmailAddress I_UserContactCard EmailAddress E-Mail Address

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_CAInvcgUserContact.
-- 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_CAInvcgUserContact AS
SELECT
  ContactCardID,
  _User.FullName AS FullName,
  _User.Department AS Department,
  _User.FunctionalTitleName AS FunctionalTitleName,
  _User.PhoneNumber AS PhoneNumber,
  _User.EmailAddress AS EmailAddress
FROM I_UserContactCard AS _User
;