R_CACnsmpnItmErrorTP

DDL: R_CACNSMPNITMERRORTP Type: view_entity TRANSACTIONAL
41 Fields 1 Data Sources 3 Associations

Consumption Item Error - TP

R_CACnsmpnItmErrorTP is a Transactional CDS View that provides data about "Consumption Item Error - TP" in SAP S/4HANA. It reads from 1 data source (I_CACnsmpnItmError) and exposes 41 fields with key fields CACnsmpnItmClass, CACnsmpnItmIDType, CACnsmpnItmID, CAErrorUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CACnsmpnItmError I_CACnsmpnItmError from

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_CAInvcgUserContact _CreatedByUser _CreatedByUser.ContactCardID = $projection.CreatedByUser
[0..*] I_CASystemMessage _CASystemMessage _CASystemMessage.SystemMessageClass = $projection.SystemMessageIdentification and _CASystemMessage.SystemMessageNumber = $projection.SystemMessageNumber
[0..1] I_CASystemMessageLastChangedBy _CASystemMessageLastChangedBy _CASystemMessageLastChangedBy.SystemMessageClass = $projection.SystemMessageIdentification and _CASystemMessageLastChangedBy.SystemMessageNumber = $projection.SystemMessageNumber

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Consumption Item Error - TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name ContrAcctgConsumptionItemError view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY CACnsmpnItmClass CACnsmpnItmClass
KEY CACnsmpnItmIDType CACnsmpnItmIDType
KEY CACnsmpnItmID CACnsmpnItmID Cons. Item ID
KEY CAErrorUUID CAErrorUUID Err. Message ID
CACnsmpnItmStatus CACnsmpnItmStatus Status
CACnsmpnItmProcess CACnsmpnItmProcess Settlement ID
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
CACnsmpnItmPackageUUID CACnsmpnItmPackageUUID
CACnsmpnItmDataPackageID CACnsmpnItmDataPackageID
CARatingDate CARatingDate Rating Date
CARatingInternalNumber CARatingInternalNumber Rating Run No.
CARatingGroup CARatingGroup Rating Group
CACnsmpnItmCreationDate CACnsmpnItmCreationDate Created On
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CAMassRunInternalID CAMassRunInternalID Valuation Run ID No.
LogHandle LogsHandle
SystemMessageType SystemMessageType Message type
SystemMessageIdentification SystemMessageIdentification Message ID
SystemMessageNumber SystemMessageNumber Message Number
SystemMessageVariable1 SystemMessageVariable1 Variable 1
SystemMessageVariable2 SystemMessageVariable2 Variable 2
SystemMessageVariable3 SystemMessageVariable3 Variable 3
SystemMessageVariable4 SystemMessageVariable4 Variable 4
CAExternalErrorCode CAExternalErrorCode External Error Key
CAExternalErrorVariable1Text CAExternalErrorVariable1Text
_CACnsmpnItmStatus _CACnsmpnItmStatus
_BusinessPartner _BusinessPartner
_CACnsmpnItmClass _CACnsmpnItmClass
_CACnsmpnItmIDType _CACnsmpnItmIDType
_CACnsmpnItmProcess _CACnsmpnItmProcess
_CASubApplication _CASubApplication
_CASystemMessage _CASystemMessage
_CASystemMessageLastChangedBy _CASystemMessageLastChangedBy
_ContractAccountHeader _ContractAccountHeader
_ContractAccountPartner _ContractAccountPartner
_CreatedByUser _CreatedByUser

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 R_CACnsmpnItmErrorTP.
-- 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 R_CACnsmpnItmErrorTP AS
SELECT
  CACnsmpnItmClass,
  CACnsmpnItmIDType,
  CACnsmpnItmID,
  CAErrorUUID,
  CACnsmpnItmStatus,
  CACnsmpnItmProcess,
  BusinessPartner,
  ContractAccount,
  CAContract,
  CASubApplication,
  CACnsmpnItmPackageUUID,
  CACnsmpnItmDataPackageID,
  CARatingDate,
  CARatingInternalNumber,
  CARatingGroup,
  CACnsmpnItmCreationDate,
  CreatedByUser,
  CreationDate,
  CreationTime,
  CAMassRunInternalID,
  cast(LogHandle as apl_log_handle) AS LogHandle,
  SystemMessageType,
  SystemMessageIdentification,
  SystemMessageNumber,
  SystemMessageVariable1,
  SystemMessageVariable2,
  SystemMessageVariable3,
  SystemMessageVariable4,
  CAExternalErrorCode,
  CAExternalErrorVariable1Text
FROM I_CACnsmpnItmError
LEFT OUTER JOIN C_CAInvcgUserContact AS _CreatedByUser ON _CreatedByUser.ContactCardID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_CASystemMessage AS _CASystemMessage ON _CASystemMessage.SystemMessageClass = SystemMessageIdentification AND _CASystemMessage.SystemMessageNumber = SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_CASystemMessageLastChangedBy AS _CASystemMessageLastChangedBy ON _CASystemMessageLastChangedBy.SystemMessageClass = SystemMessageIdentification AND _CASystemMessageLastChangedBy.SystemMessageNumber = SystemMessageNumber  -- association [0..1]
;

Learn More