I_EvtBsdRevnRecgnClsgRunRslt

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_EvtBsdRevnRecgnClsgRunRslt.
-- 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: IEBRRCLSGRUNRSLT

CREATE VIEW I_EvtBsdRevnRecgnClsgRunRslt AS
SELECT
  guid AS ClosingTaskUUID,
  rsltln AS EvtBsdRevnRecgnClsgRunRsltItem,
  lognumber AS ApplicationLog,
  acc_principle AS AccountingPrinciple,
  pspid AS Project,
  pspnr AS WBSElementInternalID,
  vbeln AS SalesDocument,
  posnr AS SalesDocumentItem,
  auart AS SalesDocumentType,
  service_doc_type AS ServiceDocumentType,
  service_doc_id AS ServiceDocument,
  service_doc_item_id AS ServiceDocumentItem,
  vtkey AS ProviderContract,
  vtpos AS ProviderContractItem,
  bukrs AS CompanyCode,
  objnr AS ControllingObject,
  gjahr AS FiscalYear,
  perio AS FiscalPeriod,
  Ledger,
  abgsl AS ResultAnalysisInternalID,
  periv AS FiscalYearVariant,
  prctr AS ProfitCenter,
  msg_cnt_e AS NumberOfOpenErrorMessages,
  timestamp AS CreationDateTime,
  rhcur AS CompanyCodeCurrency,
  actualcostamount AS ActlCostAmt,
  actualrevenueamount AS ActlRevnAmt,
  RecognizedCOGSAmount,
  RecognizedRevenueAmount,
  recognizedmarginamt AS RecognizedMarginAmtInCCCrcy,
  AccruedCOGSAmount,
  AccruedRevenueAmount,
  DeferredCOGSAmount,
  DeferredRevenueAmount,
  RevenueAdjustmentAmount,
  COGSAdjustmentAmount,
  unbilledrevenueamount AS UnbilledRevnInCoCodeCrcy,
  accruedrevenuecapamount AS AccruedRevenueCapAmtInCCCrcy,
  downpaymentamount AS DownPaymentAmtInCCCrcy,
  immlossresamount AS ImminentLossRsrvAmtInCCCrcy,
  immlossadjresamount AS ImmntLossRsrvAdjmtAmtInCCCrcy
FROM fins_trr_pecrslt
;