C_CABllbleItmReversalRequest

DDL: C_CABLLBLEITMREVERSALREQUEST Type: view_entity CONSUMPTION
32 Fields 1 Data Sources 1 Associations

Stornoauftrag für Abr. Positionen

C_CABllbleItmReversalRequest is a Consumption CDS View that provides data about "Stornoauftrag für Abr. Positionen" in SAP S/4HANA. It reads from 1 data source (I_CABllbleItmReversalRequest) and exposes 32 fields with key fields CABllbleItmRvslReqStatus, ContractAccount, CABllbleItmSourceTransType, CABllbleItmSourceTransId, CABllbleItmRvslReqUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CABllbleItmReversalRequest _CABllbleItmReversalRequest from

Associations (1)

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

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Stornoauftrag für Abr. Positionen view
UI.headerInfo.typeName Stornoauftrag für Abrechenbare Position view
UI.headerInfo.typeNamePlural Stornoaufträge für Abr. Positionen view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY CABllbleItmRvslReqStatus I_CABllbleItmReversalRequest CABllbleItmRvslReqStatus Workflow Status
KEY ContractAccount I_CABllbleItmReversalRequest ContractAccount Contract Acct
KEY CABllbleItmSourceTransType I_CABllbleItmReversalRequest CABllbleItmSourceTransType SrcTransType
KEY CABllbleItmSourceTransId I_CABllbleItmReversalRequest CABllbleItmSourceTransId Source Trans.ID
KEY CABllbleItmRvslReqUUID I_CABllbleItmReversalRequest CABllbleItmRvslReqUUID UUID
CARvslTsk I_CABllbleItmReversalRequest CARvslTsk Reversal Task
CABllbleItmSourceTransIDTo I_CABllbleItmReversalRequest CABllbleItmSourceTransIDTo SrceTransID To
CABllbleItmExceptionReason I_CABllbleItmReversalRequest CABllbleItmExceptionReason Excepn/Revrsl Rsn
CABllbleItmClass I_CABllbleItmReversalRequest CABllbleItmClass Class
CABllbleItmRvslReqStartDate I_CABllbleItmReversalRequest CABllbleItmRvslReqStartDate Reversal From
CreatedByUser I_CABllbleItmReversalRequest CreatedByUser User Name
CreationDate I_CABllbleItmReversalRequest CreationDate Time Stamp
CreationTime I_CABllbleItmReversalRequest CreationTime Time of Change
CABllbleItmStatus I_CABllbleItmReversalRequest CABllbleItmStatus Status
CACnvChrgSnapshotIDDate I_CABllbleItmReversalRequest CACnvChrgSnapshotIDDate Snapshot ID
CABllbleItmSrceTransIDIsSingle I_CABllbleItmReversalRequest CABllbleItmSrceTransIDIsSingle Single SrcTrans
CABllbleItmReratgReqUUID I_CABllbleItmReversalRequest CABllbleItmReratgReqUUID Rerating ID
BusinessPartner I_CABllbleItmReversalRequest BusinessPartner Issuing Authority
CAContract I_CABllbleItmReversalRequest CAContract Contract
CASubApplication I_CABllbleItmReversalRequest CASubApplication Subapplication
CABllbleItmPackageUUID I_CABllbleItmReversalRequest CABllbleItmPackageUUID Pkg Bill.Items
CADeletionDate I_CABllbleItmReversalRequest CADeletionDate Deletion date
CABllbleItmSrceTransTypeText
CABllbleItmRvslReqStatusText
CABllbleItmClassText
CABllbleItmExceptionReasonText
CABllbleItmStatusText
CASubApplicationText
_ContractAccountHeader _ContractAccountHeader
_ContractAccountPartner _ContractAccountPartner
_BusinessPartner _BusinessPartner
_CAInvcgUserContact _CAInvcgUserContact

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_CABllbleItmReversalRequest.
-- 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_CABllbleItmReversalRequest AS
SELECT
  _CABllbleItmReversalRequest.CABllbleItmRvslReqStatus AS CABllbleItmRvslReqStatus,
  _CABllbleItmReversalRequest.ContractAccount AS ContractAccount,
  _CABllbleItmReversalRequest.CABllbleItmSourceTransType AS CABllbleItmSourceTransType,
  _CABllbleItmReversalRequest.CABllbleItmSourceTransId AS CABllbleItmSourceTransId,
  _CABllbleItmReversalRequest.CABllbleItmRvslReqUUID AS CABllbleItmRvslReqUUID,
  _CABllbleItmReversalRequest.CARvslTsk AS CARvslTsk,
  _CABllbleItmReversalRequest.CABllbleItmSourceTransIDTo AS CABllbleItmSourceTransIDTo,
  _CABllbleItmReversalRequest.CABllbleItmExceptionReason AS CABllbleItmExceptionReason,
  _CABllbleItmReversalRequest.CABllbleItmClass AS CABllbleItmClass,
  _CABllbleItmReversalRequest.CABllbleItmRvslReqStartDate AS CABllbleItmRvslReqStartDate,
  _CABllbleItmReversalRequest.CreatedByUser AS CreatedByUser,
  _CABllbleItmReversalRequest.CreationDate AS CreationDate,
  _CABllbleItmReversalRequest.CreationTime AS CreationTime,
  _CABllbleItmReversalRequest.CABllbleItmStatus AS CABllbleItmStatus,
  _CABllbleItmReversalRequest.CACnvChrgSnapshotIDDate AS CACnvChrgSnapshotIDDate,
  _CABllbleItmReversalRequest.CABllbleItmSrceTransIDIsSingle AS CABllbleItmSrceTransIDIsSingle,
  _CABllbleItmReversalRequest.CABllbleItmReratgReqUUID AS CABllbleItmReratgReqUUID,
  _CABllbleItmReversalRequest.BusinessPartner AS BusinessPartner,
  _CABllbleItmReversalRequest.CAContract AS CAContract,
  _CABllbleItmReversalRequest.CASubApplication AS CASubApplication,
  _CABllbleItmReversalRequest.CABllbleItmPackageUUID AS CABllbleItmPackageUUID,
  _CABllbleItmReversalRequest.CADeletionDate AS CADeletionDate,
  _CABllbleItmSrceTransType._CABllbleItmSrceTransTypeText[1: Language=$session.system_language].CABllbleItmSrceTransTypeText AS CABllbleItmSrceTransTypeText,
  _CABllbleItmRvslReqStatus._CABllbleItmRvslReqStatusText[1: Language=$session.system_language].CABllbleItmRvslReqStatusText AS CABllbleItmRvslReqStatusText,
  _CABllbleItmClass._CABllbleItmClassText[1: Language=$session.system_language].CABllbleItmClassText AS CABllbleItmClassText,
  _CABllbleItmExcptnReason._CABllbleItmExcptnReasonText[1: Language=$session.system_language].CABllbleItmExceptionReasonText AS CABllbleItmExceptionReasonText,
  _CABllbleItmStatus._CABllbleItmStatusText[1: Language=$session.system_language].CABllbleItmStatusText AS CABllbleItmStatusText,
  _CASubApplication._CASubApplicationText[1: Language=$session.system_language].CASubApplicationText AS CASubApplicationText
FROM I_CABllbleItmReversalRequest AS _CABllbleItmReversalRequest
LEFT OUTER JOIN C_CAInvcgUserContact AS _CAInvcgUserContact ON CreatedByUser = _CAInvcgUserContact.ContactCardID  -- association [0..1]
;

Learn More