C_CABillgDocReversalRequest

DDL: C_CABILLGDOCREVERSALREQUEST Type: view_entity CONSUMPTION
27 Fields 1 Data Sources 2 Associations

Stornoauftrag für Abrechnungsbelege

C_CABillgDocReversalRequest is a Consumption CDS View that provides data about "Stornoauftrag für Abrechnungsbelege" in SAP S/4HANA. It reads from 1 data source (I_CABillgDocReversalRequest) and exposes 27 fields with key fields CABillgDocument, CABillgDocReversalTask. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CABillgDocReversalRequest _CABillgDocReversalRequest from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ContractAccountPartner _ContractAccountPartner $projection.ContractAccount = _ContractAccountPartner.ContractAccount and $projection.BusinessPartner = _ContractAccountPartner.BusinessPartner
[0..1] I_ContractAccountHeader _ContractAccountHeader $projection.ContractAccount = _ContractAccountHeader.ContractAccount

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Stornoauftrag für Abrechnungsbelege view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CABillgDocument I_CABillgDocReversalRequest CABillgDocument Billing Doc.
KEY CABillgDocReversalTask I_CABillgDocReversalRequest CABillgDocReversalTask Reversal Task
CAReversalRequestStatus I_CABillgDocReversalRequest CAReversalRequestStatus Workflow Status
CABillgDocumentReversalReason I_CABillgDocReversalRequest CABillgDocumentReversalReason Reversal Reason
CABillgDocOriginProcess I_CABillgDocReversalRequest CABillgDocOriginProcess Origin
CABillgProcess I_CABillgDocReversalRequest CABillgProcess Billing Process
CABillgType I_CABillgDocReversalRequest CABillgType Billing Type
CreatedByUser I_CABillgDocReversalRequest CreatedByUser User Name
CreationDate I_CABillgDocReversalRequest CreationDate Time Stamp
CreationTime I_CABillgDocReversalRequest CreationTime Time of Change
BusinessPartner I_CABillgDocReversalRequest BusinessPartner Issuing Authority
BusinessPartnerFullName
ContractAccount I_CABillgDocReversalRequest ContractAccount Contract Acct
ContractAccountName _ContractAccountHeader ContractAccountName Cont. acct name
CAInvcgMasterDataType I_CABillgDocReversalRequest CAInvcgMasterDataType MasterData Type
CABillgDocCreationDate I_CABillgDocReversalRequest CABillgDocCreationDate Billed On
CABillgDocCreationTime I_CABillgDocReversalRequest CABillgDocCreationTime Billed At
CADeletionDate I_CABillgDocReversalRequest CADeletionDate Deletion date
CAReversalRequestStatusText
CAInvcgMasterDataTypeText
CABillgDocReversalReasonText
CABillgDocOriginProcessText
CABillgProcessText
CABillgTypeText
_CABillgDocHeader _CABillgDocHeader
_ContractAccountPartner _ContractAccountPartner
_ContractAccountHeader _ContractAccountHeader

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_CABillgDocReversalRequest.
-- 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_CABillgDocReversalRequest AS
SELECT
  _CABillgDocReversalRequest.CABillgDocument AS CABillgDocument,
  _CABillgDocReversalRequest.CABillgDocReversalTask AS CABillgDocReversalTask,
  _CABillgDocReversalRequest.CAReversalRequestStatus AS CAReversalRequestStatus,
  _CABillgDocReversalRequest.CABillgDocumentReversalReason AS CABillgDocumentReversalReason,
  _CABillgDocReversalRequest.CABillgDocOriginProcess AS CABillgDocOriginProcess,
  _CABillgDocReversalRequest.CABillgProcess AS CABillgProcess,
  _CABillgDocReversalRequest.CABillgType AS CABillgType,
  _CABillgDocReversalRequest.CreatedByUser AS CreatedByUser,
  _CABillgDocReversalRequest.CreationDate AS CreationDate,
  _CABillgDocReversalRequest.CreationTime AS CreationTime,
  _CABillgDocReversalRequest.BusinessPartner AS BusinessPartner,
  _ContractAccountPartner._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _CABillgDocReversalRequest.ContractAccount AS ContractAccount,
  _ContractAccountHeader.ContractAccountName AS ContractAccountName,
  _CABillgDocReversalRequest.CAInvcgMasterDataType AS CAInvcgMasterDataType,
  _CABillgDocReversalRequest.CABillgDocCreationDate AS CABillgDocCreationDate,
  _CABillgDocReversalRequest.CABillgDocCreationTime AS CABillgDocCreationTime,
  _CABillgDocReversalRequest.CADeletionDate AS CADeletionDate,
  _CAReversalRequestStatus._CAReversalRequestStatusText[1: Language=$session.system_language].CAReversalRequestStatusText AS CAReversalRequestStatusText,
  _CAInvcgMasterDataType._CAInvcgMasterDataTypeText[1: Language=$session.system_language].CAInvcgMasterDataTypeText AS CAInvcgMasterDataTypeText,
  _CABillgDocReversalReason._CABillgDocReversalReasonText[1: Language=$session.system_language].CABillgDocReversalReasonText AS CABillgDocReversalReasonText,
  _CABillgDocOriginProcess._CABillgDocOriginProcessText[1: Language=$session.system_language].CABillgDocOriginProcessText AS CABillgDocOriginProcessText,
  _CABillgProcess._CABillgProcessText[1: Language=$session.system_language].CABillgProcessText AS CABillgProcessText,
  _CABillgType._CABillgTypeText[1: Language=$session.system_language].CABillgTypeText AS CABillgTypeText
FROM I_CABillgDocReversalRequest AS _CABillgDocReversalRequest
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [0..1]
;

Learn More