C_CASrvcReconnectionReq

DDL: C_CASRVCRECONNECTIONREQ Type: view_entity CONSUMPTION
34 Fields 1 Data Sources 1 Associations 1 OData Services 1 Fiori Apps

Service Reconnection Request

C_CASrvcReconnectionReq is a Consumption CDS View that provides data about "Service Reconnection Request" in SAP S/4HANA. It reads from 1 data source (I_CASrvcReconnectionReqEnhcd) and exposes 34 fields with key fields CAServiceReconnectionRequest, CAServiceDisconnectionRequest, CASrvcReconncnReqIsInvalid, CASrvcReconncnReqIsObsolete. It has 1 association to related views. It is exposed through 1 OData service (UI_CADISCONNCNRECONNCN_MNT). It is used in 1 Fiori application: Monitor Disconnection Requests.

Data Sources (1)

SourceAliasJoin Type
I_CASrvcReconnectionReqEnhcd I_CASrvcReconnectionReqEnhcd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_CAInvcgUserContact _CreatedByContact $projection.CreatedByUser = _CreatedByContact.ContactCardID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Service Reconnection Request view
Metadata.ignorePropagatedAnnotations false view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
UI_CADISCONNCNRECONNCN_MNT UI_CADISCONNCNRECONNCN_MNT 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 (34)

KeyFieldSource TableSource FieldDescription
KEY CAServiceReconnectionRequest CAServiceReconnectionRequest
KEY CAServiceDisconnectionRequest CAServiceDisconnectionRequest
KEY CASrvcReconncnReqIsInvalid CASrvcReconncnReqIsInvalid
KEY CASrvcReconncnReqIsObsolete CASrvcReconncnReqIsObsolete
CASrvcReconncnReqStatus CASrvcReconncnReqStatus Validity
CASrvcReconncnReqStatusText
CASrvcReconncnReqSendStatus CASrvcReconncnReqSendStatus Send Status
CASrvcReconncnReqSendStsText
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName _BusinessPartner BusinessPartnerFullName Broker Name
ContractAccount ContractAccount Contract Acct
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CADunningAmount CADunningAmount
TransactionCurrency TransactionCurrency Transaction Currency
CAClearingAmountInClearingCrcy CAClearingAmountInClearingCrcy Clearing Amount
CAClearingCurrency CAClearingCurrency Clearing Curr.
CreatedByUser CreatedByUser User Name
PersonFullName _CreatedByContact FullName Name
CreationDate CreationDate Created On
CreationTime CreationTime Created At
RequestSendDate RequestSendDate Sent On
RequestSendTime RequestSendTime Sent At
_CreatedByContact _CreatedByContact
_BusinessPartner _BusinessPartner
_CAProviderContract _CAProviderContract
_CASrvcReconncnReqSendStatus _CASrvcReconncnReqSendStatus
_CASrvcReconncnReqStatus _CASrvcReconncnReqStatus
_CASrvcReconnectionReqLog _CASrvcReconnectionReqLog
_CASubApplication _CASubApplication
_ClearingCurrency _ClearingCurrency
_ContractAccount _ContractAccount
_ContractAccountPartner _ContractAccountPartner
_TransactionCurrency _TransactionCurrency

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_CASrvcReconnectionReq.
-- 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_CASrvcReconnectionReq AS
SELECT
  CAServiceReconnectionRequest,
  CAServiceDisconnectionRequest,
  CASrvcReconncnReqIsInvalid,
  CASrvcReconncnReqIsObsolete,
  CASrvcReconncnReqStatus,
  _CASrvcReconncnReqStatus._Text[1: Language=$session.system_language].CASrvcReconncnReqStatusText AS CASrvcReconncnReqStatusText,
  CASrvcReconncnReqSendStatus,
  _CASrvcReconncnReqSendStatus._Text[1: Language=$session.system_language].CASrvcReconncnReqSendStsText AS CASrvcReconncnReqSendStsText,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerName,
  ContractAccount,
  CAContract,
  CASubApplication,
  CADunningAmount,
  TransactionCurrency,
  CAClearingAmountInClearingCrcy,
  CAClearingCurrency,
  CreatedByUser,
  _CreatedByContact.FullName AS PersonFullName,
  CreationDate,
  CreationTime,
  RequestSendDate,
  RequestSendTime
FROM I_CASrvcReconnectionReqEnhcd
LEFT OUTER JOIN C_CAInvcgUserContact AS _CreatedByContact ON CreatedByUser = _CreatedByContact.ContactCardID  -- association [0..1]
;

Learn More