I_CARvslTsk

DDL: I_CARVSLTSK SQL: ICAINVREV_T Type: view BASIC
16 Fields 1 Data Sources

Stornomaßnahme

I_CARvslTsk is a Basic CDS View that provides data about "Stornomaßnahme" in SAP S/4HANA. It reads from 1 data source (dfkkinv_revt) and exposes 16 fields with key field CARvslTsk.

Data Sources (1)

SourceAliasJoin Type
dfkkinv_revt invrev_t from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICAINVREV_T view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Stornomaßnahme view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CARvslTsk revtask Reversal Task
CARvslTskStatus revstatus Status
CARvslTskCreationUser crname Last Changed By
CARvslTskCreationDate crdate Sizing Date
CARvslTskHasBllbleItm xcreate_rev_bit Bill.Item Rev.
CARvslTskHasBillgDoc xcreate_rev_bill Bill.Doc. Rev.
CARvslTskHasInvcgDoc xcreate_rev_inv Inv. Doc. Rev.
CARvslTskHasRerating xcreate_rev_rerate Rerating Req.
CARvslTskName revtask_desc Name
CARvslTskExternalReference revtask_ref Ext. Reference
CARvslTskCreationTime crtime Time Created
CARvslTskChangeName chname Changed By
CARvslTskChangeDate chdate Date Changed
CARvslTskChangeTime chtime Time Changed
CARvslTskIsLocked xrevlocked Locked
CADeletionDate loedt Deletion date

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 I_CARvslTsk.
-- 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.
-- SQL view name: ICAINVREV_T

CREATE VIEW I_CARvslTsk AS
SELECT
  revtask AS CARvslTsk,
  revstatus AS CARvslTskStatus,
  crname AS CARvslTskCreationUser,
  crdate AS CARvslTskCreationDate,
  xcreate_rev_bit AS CARvslTskHasBllbleItm,
  xcreate_rev_bill AS CARvslTskHasBillgDoc,
  xcreate_rev_inv AS CARvslTskHasInvcgDoc,
  xcreate_rev_rerate AS CARvslTskHasRerating,
  revtask_desc AS CARvslTskName,
  revtask_ref AS CARvslTskExternalReference,
  crtime AS CARvslTskCreationTime,
  chname AS CARvslTskChangeName,
  chdate AS CARvslTskChangeDate,
  chtime AS CARvslTskChangeTime,
  xrevlocked AS CARvslTskIsLocked,
  loedt AS CADeletionDate
FROM dfkkinv_revt AS invrev_t
;

Learn More