I_CACnsmpnItmExceptionHistory

DDL: I_CACNSMPNITMEXCEPTIONHISTORY Type: view_entity BASIC Package: FKKINV_VDM_CIT
22 Fields 1 Data Sources 7 Associations

Historie für Ausnahmen Verbr. pos.

I_CACnsmpnItmExceptionHistory is a Basic CDS View that provides data about "Historie für Ausnahmen Verbr. pos." in SAP S/4HANA. It reads from 1 data source (dfkkbixcit_hist) and exposes 22 fields with key fields CACnsmpnItmClass, CACnsmpnItmPackageUUID, CACnsmpnItmPackNo, CACnsmpnItmExceptionDate, CACnsmpnItmExceptionTime. It has 7 associations to related views. Part of development package FKKINV_VDM_CIT.

Data Sources (1)

SourceAliasJoin Type
dfkkbixcit_hist dfkkbixcit_hist from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_CACnsmpnItmClass _CACnsmpnItmClass _CACnsmpnItmClass.CACnsmpnItmClass = $projection.CACnsmpnItmClass
[0..1] I_CACnsmpnItmExcptnReason _CACnsmpnItmExcptnReason _CACnsmpnItmExcptnReason.CACnsmpnItmExceptionReason = $projection.CACnsmpnItmExceptionReason
[0..1] I_CACnsmpnItmExcptnRvslReason _CACnsmpnItmExcptnRvslReason _CACnsmpnItmExcptnRvslReason.CACnsmpnItmExcptnRvslReason = $projection.CACnsmpnItmExcptnRvslReason
[0..1] I_User _CACnsmpnItmExceptionUserName _CACnsmpnItmExceptionUserName.UserID = $projection.CACnsmpnItmExceptionUserName
[0..1] I_User _CACnsmpnItmExcptnRvslUserName _CACnsmpnItmExcptnRvslUserName.UserID = $projection.CACnsmpnItmExcptnRvslUserName
[0..1] I_CACnsmpnItmIDType _CACnsmpnItmIDType _CACnsmpnItmIDType.CACnsmpnItmIDType = $projection.CACnsmpnItmIDType
[0..1] I_CACnsmpnItmStatus _CACnsmpnItmStatus _CACnsmpnItmStatus.CACnsmpnItmStatus = $projection.CACnsmpnItmStatus

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Historie für Ausnahmen Verbr. pos. view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CACnsmpnItmClass citcat Class
KEY CACnsmpnItmPackageUUID citpackuuid Cons.Item Pkg.
KEY CACnsmpnItmPackNo citpackcno Sequence Number
KEY CACnsmpnItmExceptionDate excdate Exception Date
KEY CACnsmpnItmExceptionTime exctime Exception Time
CACnsmpnItmExceptionReason excreason Ausnahmegrund
CACnsmpnItmExceptionUserName excusnam Exception User
CACnsmpnItmExcptnRvslDate excrevdate Date Restored
CACnsmpnItmExcptnRvslTime excrevtime Time Restored
CACnsmpnItmExcptnRvslReason excrevreason Restorn Reason
CACnsmpnItmExcptnRvslUserName excrevusnam Restoring User
statusgroup
CACnsmpnItmIDType citidtype ConsItem IDType
CACnsmpnItmID citid Cons. Item ID
CACnsmpnItmStatus citstatus Status
_CACnsmpnItmClass _CACnsmpnItmClass
_CACnsmpnItmExcptnReason _CACnsmpnItmExcptnReason
_CACnsmpnItmExcptnRvslReason _CACnsmpnItmExcptnRvslReason
_CACnsmpnItmExceptionUserName _CACnsmpnItmExceptionUserName
_CACnsmpnItmExcptnRvslUserName _CACnsmpnItmExcptnRvslUserName
_CACnsmpnItmIDType _CACnsmpnItmIDType
_CACnsmpnItmStatus _CACnsmpnItmStatus

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_CACnsmpnItmExceptionHistory.
-- 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 I_CACnsmpnItmExceptionHistory AS
SELECT
  citcat AS CACnsmpnItmClass,
  citpackuuid AS CACnsmpnItmPackageUUID,
  citpackcno AS CACnsmpnItmPackNo,
  excdate AS CACnsmpnItmExceptionDate,
  exctime AS CACnsmpnItmExceptionTime,
  excreason AS CACnsmpnItmExceptionReason,
  excusnam AS CACnsmpnItmExceptionUserName,
  excrevdate AS CACnsmpnItmExcptnRvslDate,
  excrevtime AS CACnsmpnItmExcptnRvslTime,
  excrevreason AS CACnsmpnItmExcptnRvslReason,
  excrevusnam AS CACnsmpnItmExcptnRvslUserName,
  citidtype AS CACnsmpnItmIDType,
  citid AS CACnsmpnItmID,
  citstatus AS CACnsmpnItmStatus
FROM dfkkbixcit_hist
LEFT OUTER JOIN I_CACnsmpnItmClass AS _CACnsmpnItmClass ON _CACnsmpnItmClass.CACnsmpnItmClass = CACnsmpnItmClass  -- association [0..1]
LEFT OUTER JOIN I_CACnsmpnItmExcptnReason AS _CACnsmpnItmExcptnReason ON _CACnsmpnItmExcptnReason.CACnsmpnItmExceptionReason = CACnsmpnItmExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_CACnsmpnItmExcptnRvslReason AS _CACnsmpnItmExcptnRvslReason ON _CACnsmpnItmExcptnRvslReason.CACnsmpnItmExcptnRvslReason = CACnsmpnItmExcptnRvslReason  -- association [0..1]
LEFT OUTER JOIN I_User AS _CACnsmpnItmExceptionUserName ON _CACnsmpnItmExceptionUserName.UserID = CACnsmpnItmExceptionUserName  -- association [0..1]
LEFT OUTER JOIN I_User AS _CACnsmpnItmExcptnRvslUserName ON _CACnsmpnItmExcptnRvslUserName.UserID = CACnsmpnItmExcptnRvslUserName  -- association [0..1]
LEFT OUTER JOIN I_CACnsmpnItmIDType AS _CACnsmpnItmIDType ON _CACnsmpnItmIDType.CACnsmpnItmIDType = CACnsmpnItmIDType  -- association [0..1]
LEFT OUTER JOIN I_CACnsmpnItmStatus AS _CACnsmpnItmStatus ON _CACnsmpnItmStatus.CACnsmpnItmStatus = CACnsmpnItmStatus  -- association [0..1]
;

Learn More