C_CACnsmpnItmExceptionHistory

DDL: C_CACNSMPNITMEXCEPTIONHISTORY Type: view_entity CONSUMPTION Package: ODATA_O2C_CI_CIT
26 Fields 1 Data Sources 2 Associations

Historie für Ausnahmen Verbr. pos.

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

Data Sources (1)

SourceAliasJoin Type
I_CACnsmpnItmExceptionHistory I_CACnsmpnItmExceptionHistory from

Associations (2)

CardinalityTargetAliasCondition
[0..1] C_CAInvcgUserContact _CACnsmpnItmExceptionUserName _CACnsmpnItmExceptionUserName.ContactCardID = $projection.CACnsmpnItmExceptionUserName
[0..1] C_CAInvcgUserContact _CACnsmpnItmExcptnRvslUserName _CACnsmpnItmExcptnRvslUserName.ContactCardID = $projection.CACnsmpnItmExcptnRvslUserName

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Historie für Ausnahmen Verbr. pos. view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CACnsmpnItmClass CACnsmpnItmClass Class
KEY CACnsmpnItmPackageUUID CACnsmpnItmPackageUUID Cons.Item Pkg.
KEY CACnsmpnItmPackNo CACnsmpnItmPackNo Sequence Number
KEY CACnsmpnItmExceptionDate CACnsmpnItmExceptionDate Exception Date
KEY CACnsmpnItmExceptionTime CACnsmpnItmExceptionTime Exception Time
CACnsmpnItmExceptionReason CACnsmpnItmExceptionReason Excepn/Revrsl Rsn
CACnsmpnItmExceptionUserName CACnsmpnItmExceptionUserName Exception User
CACnsmpnItmExcptnRvslDate CACnsmpnItmExcptnRvslDate Date Restored
CACnsmpnItmExcptnRvslTime CACnsmpnItmExcptnRvslTime Time Restored
CACnsmpnItmExcptnRvslReason CACnsmpnItmExcptnRvslReason Restorn Reason
CACnsmpnItmExcptnRvslUserName CACnsmpnItmExcptnRvslUserName Restoring User
CACnsmpnItmIDType CACnsmpnItmIDType ConsItem IDType
CACnsmpnItmID CACnsmpnItmID Cons. Item ID
CACnsmpnItmStatus CACnsmpnItmStatus Status
_CACnsmpnItmExceptionUserName _CACnsmpnItmExceptionUserName
_CACnsmpnItmExcptnRvslUserName _CACnsmpnItmExcptnRvslUserName
CACnsmpnItmClassText
CACnsmpnItmExceptionReasonText
CACnsmpnItmExcptnRvslRsnText
CACnsmpnItmIDTypeText
CACnsmpnItmStatusText
_CACnsmpnItmClass _CACnsmpnItmClass
_CACnsmpnItmExcptnReason _CACnsmpnItmExcptnReason
_CACnsmpnItmExcptnRvslReason _CACnsmpnItmExcptnRvslReason
_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 C_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 C_CACnsmpnItmExceptionHistory AS
SELECT
  CACnsmpnItmClass,
  CACnsmpnItmPackageUUID,
  CACnsmpnItmPackNo,
  CACnsmpnItmExceptionDate,
  CACnsmpnItmExceptionTime,
  CACnsmpnItmExceptionReason,
  CACnsmpnItmExceptionUserName,
  CACnsmpnItmExcptnRvslDate,
  CACnsmpnItmExcptnRvslTime,
  CACnsmpnItmExcptnRvslReason,
  CACnsmpnItmExcptnRvslUserName,
  CACnsmpnItmIDType,
  CACnsmpnItmID,
  CACnsmpnItmStatus,
  _CACnsmpnItmClass._CACnsmpnItmClassText[1: Language=$session.system_language].CACnsmpnItmClassText AS CACnsmpnItmClassText,
  _CACnsmpnItmExcptnReason._CACnsmpnItmExcptnReasonText[1: Language=$session.system_language].CACnsmpnItmExceptionReasonText AS CACnsmpnItmExceptionReasonText,
  _CACnsmpnItmExcptnRvslReason._CACnsmpnItmExcptnRvslRsnText[1: Language=$session.system_language].CACnsmpnItmExcptnRvslRsnText AS CACnsmpnItmExcptnRvslRsnText,
  _CACnsmpnItmIDType._CACnsmpnItmIDTypeText[1: Language=$session.system_language].CACnsmpnItmIDTypeText AS CACnsmpnItmIDTypeText,
  _CACnsmpnItmStatus._CACnsmpnItmStatusText[1: Language=$session.system_language].CACnsmpnItmStatusText AS CACnsmpnItmStatusText
FROM I_CACnsmpnItmExceptionHistory
LEFT OUTER JOIN C_CAInvcgUserContact AS _CACnsmpnItmExceptionUserName ON _CACnsmpnItmExceptionUserName.ContactCardID = CACnsmpnItmExceptionUserName  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _CACnsmpnItmExcptnRvslUserName ON _CACnsmpnItmExcptnRvslUserName.ContactCardID = CACnsmpnItmExcptnRvslUserName  -- association [0..1]
;

Learn More