P_EvtBsdRevRecSalesOrderAppLog

DDL: P_EVTBSDREVRECSALESORDERAPPLOG SQL: PSDDOCISSERRSUM Type: view CONSUMPTION
13 Fields 1 Data Sources

Headers of application log

P_EvtBsdRevRecSalesOrderAppLog is a Consumption CDS View that provides data about "Headers of application log" in SAP S/4HANA. It reads from 1 data source (balhdr) and exposes 13 fields with key field ApplicationLog.

Data Sources (1)

SourceAliasJoin Type
balhdr balhdr from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PSDDOCISSERRSUM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Headers of application log view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLog lognumber UUID
Object object TRFM Object
ApplicationLogHandle Migration Log Handle
SubObject subobject Triggering obj.
ExternalNumber extnumber External ID
CompanyCode
AccountingPrinciple
Prefix
SDDocument
SDDocumentItem
FiscalYear
FiscalPeriod
NumberOfOpenErrorMessages Error Msg

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 P_EvtBsdRevRecSalesOrderAppLog.
-- 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: PSDDOCISSERRSUM

CREATE VIEW P_EvtBsdRevRecSalesOrderAppLog AS
SELECT
  lognumber AS ApplicationLog,
  Object,
  cast(log_handle as abap.sstring(22)) AS ApplicationLogHandle,
  SubObject,
  extnumber AS ExternalNumber,
  cast( substring( extnumber, 1, 4) as bukrs preserving type ) AS CompanyCode,
  cast( substring( extnumber, 6, 4) as accounting_principle preserving type) AS AccountingPrinciple,
  substring( extnumber, 11, 2) AS Prefix,
  cast( substring( extnumber, 13, 10) as vbeln preserving type ) AS SDDocument,
  cast( substring( extnumber, 23, 6) as kdpos ) AS SDDocumentItem,
  cast( substring( extnumber, 34, 4) as gjahr) AS FiscalYear,
  cast( substring( extnumber, 39, 3) as poper) AS FiscalPeriod,
  cast(msg_cnt_e as abap.int4) AS NumberOfOpenErrorMessages
FROM balhdr
;

Learn More