C_EvtBsdProdnCostError

DDL: C_EVTBSDPRODNCOSTERROR SQL: CEBPOSTGERROR Type: view CONSUMPTION
27 Fields 1 Data Sources 5 Associations

Manage Event-Based Posting Errors

C_EvtBsdProdnCostError is a Consumption CDS View that provides data about "Manage Event-Based Posting Errors" in SAP S/4HANA. It reads from 1 data source (R_EvtBsdProdnCostError) and exposes 27 fields with key fields EventBasedProdnCostErrorUUID, EvtBsdProdnCostErrorObject, LogNumber, Ledger, CompanyCode. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_EvtBsdProdnCostError R_EvtBsdProdnCostError from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_UserContactCard _CreatedByUserContactCard $projection.CreatedByUser = _CreatedByUserContactCard.ContactCardID
[0..1] I_OrderCategoryText _OrderCategoryText $projection.OrderCategory = _OrderCategoryText.OrderCategory
[1..1] I_Ledger _Ledger $projection.Ledger = _Ledger.Ledger
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_Plant _Plant $projection.Plant = _Plant.Plant

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CEBPOSTGERROR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manage Event-Based Posting Errors view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY EventBasedProdnCostErrorUUID EventBasedProdnCostErrorUUID Unique identification of an entry in DBTABLOG
KEY EvtBsdProdnCostErrorObject EvtBsdProdnCostErrorObject
KEY LogNumber LogNumber UUID
KEY Ledger Ledger Ledger
KEY CompanyCode CompanyCode Receiver Company Code
LedgerName
CompanyCodeName _CompanyCode CompanyCodeName Company Name
EventBasedProdnCostRefProcess EventBasedProdnCostRefProcess Source Transaction
EvtBsdProdnCostRefProcessName EvtBsdProdnCostRefProcessName
LogHandle LogHandle LogsHandle
EvtBsdProdnCostErrObjectType EvtBsdProdnCostErrObjectType Object Type
EvtBsdProdnCostErrObjTypeName EvtBsdProdnCostErrObjTypeName
BusinessTransactionCategory BusinessTransactionCategory Error Category
BusTransactionCategoryName BusTransactionCategoryName
OrderCategory OrderCategory Order Category
OrderCategoryName
OrderType OrderType Order Type
LogMessageText LogMessageText Error
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
OrderID OrderID Order ID
Product Product Product Sold
SalesOrder SD Document
SalesOrderItem Sales Order Item
CreatedByUser CreatedByUser User Name
CreationDate Time Stamp
_CreatedByUserContactCard _CreatedByUserContactCard

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_EvtBsdProdnCostError.
-- 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: CEBPOSTGERROR

CREATE VIEW C_EvtBsdProdnCostError AS
SELECT
  EventBasedProdnCostErrorUUID,
  EvtBsdProdnCostErrorObject,
  LogNumber,
  Ledger,
  CompanyCode,
  _Ledger._Text[1: Language = $session.system_language].LedgerName AS LedgerName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  EventBasedProdnCostRefProcess,
  EvtBsdProdnCostRefProcessName,
  LogHandle,
  EvtBsdProdnCostErrObjectType,
  EvtBsdProdnCostErrObjTypeName,
  BusinessTransactionCategory,
  BusTransactionCategoryName,
  OrderCategory,
  _OrderCategoryText[1: Language = $session.system_language].OrderCategoryName AS OrderCategoryName,
  OrderType,
  LogMessageText,
  Plant,
  _Plant.PlantName AS PlantName,
  OrderID,
  Product,
  cast(SalesOrder as co_kdauf ) AS SalesOrder,
  cast(SalesOrderItem as co_kdpos) AS SalesOrderItem,
  CreatedByUser,
  cast(CreationDate as fis_auferfdat) AS CreationDate
FROM R_EvtBsdProdnCostError
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_OrderCategoryText AS _OrderCategoryText ON OrderCategory = _OrderCategoryText.OrderCategory  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
;

Learn More