I_RU_SecondaryEventBasic

DDL: I_RU_SECONDARYEVENTBASIC SQL: IRUSECEVNTBSC Type: view BASIC
14 Fields 1 Data Sources

RU Secondary Events

I_RU_SecondaryEventBasic is a Basic CDS View that provides data about "RU Secondary Events" in SAP S/4HANA. It reads from 1 data source (j_3rtse) and exposes 14 fields with key fields CompanyCode, AccountingDocument, PostingDate, AccountingDocumentItem, RU_SecondaryCompanyCode.

Data Sources (1)

SourceAliasJoin Type
j_3rtse j_3rtse from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUSECEVNTBSC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label RU Secondary Events view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode bukrs Value
KEY AccountingDocument initdoc Document Number
KEY PostingDate initdate Posting Date
KEY AccountingDocumentItem initbuzei Item
KEY RU_SecondaryCompanyCode secbukrs Company Code
KEY RU_SecondaryDocument secdoc Document Number
KEY RU_SecondaryEventDate secdate Document Date
KEY RU_SecondaryDocumentItem secbuzei Item
KEY RU_SecondaryEventOrigin origin Task Origin
RU_ImprtNotifInternalNumber import_notification Imp Notif Int Number
RU_ImportNotificationItem import_notification_item Import Notif Item
CustomsDeclaration ccd_beln Cus. Decl. No.
RU_ExprtCustomsDeclarationItem ccd_item CDec Item No.
CustomsDeclarationSubitem ccd_subitm Subitem Number

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_RU_SecondaryEventBasic.
-- 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: IRUSECEVNTBSC

CREATE VIEW I_RU_SecondaryEventBasic AS
SELECT
  bukrs AS CompanyCode,
  initdoc AS AccountingDocument,
  initdate AS PostingDate,
  initbuzei AS AccountingDocumentItem,
  secbukrs AS RU_SecondaryCompanyCode,
  secdoc AS RU_SecondaryDocument,
  secdate AS RU_SecondaryEventDate,
  secbuzei AS RU_SecondaryDocumentItem,
  origin AS RU_SecondaryEventOrigin,
  import_notification AS RU_ImprtNotifInternalNumber,
  import_notification_item AS RU_ImportNotificationItem,
  ccd_beln AS CustomsDeclaration,
  ccd_item AS RU_ExprtCustomsDeclarationItem,
  ccd_subitm AS CustomsDeclarationSubitem
FROM j_3rtse
;

Learn More