P_ReferenceTable

DDL: P_REFERENCETABLE Type: view_entity BASIC Package: ODATA_EBW_ORDER_INSPECTOR
10 Fields 1 Data Sources

Reference table

P_ReferenceTable is a Basic CDS View that provides data about "Reference table" in SAP S/4HANA. It reads from 1 data source (fcot_evtbsd_ref) and exposes 10 fields with key fields Ledger, PrecReferenceDocumentType, PrecReferenceDocumentContext, PrecReferenceDocument, PrecDocumentNumber. Part of development package ODATA_EBW_ORDER_INSPECTOR.

Data Sources (1)

SourceAliasJoin Type
fcot_evtbsd_ref refTable from

Parameters (1)

NameTypeDefault
P_FiscalPeriodEndDate budat

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Reference table view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #BASIC view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Ledger fcot_evtbsd_ref ledger Ledger
KEY PrecReferenceDocumentType fcot_evtbsd_ref prec_awtyp PrecRefTransact
KEY PrecReferenceDocumentContext fcot_evtbsd_ref prec_aworg PrecRefOrgUnit
KEY PrecReferenceDocument fcot_evtbsd_ref prec_awref PrecRefDocument
KEY PrecDocumentNumber fcot_evtbsd_ref prec_belnr PrecJE DocNo
EventBasedReferenceDocument fcot_evtbsd_ref evtbsd_awref Reference Doc.
ControllingObject fcot_evtbsd_ref object_number Object number
EventBasedBTType fcot_evtbsd_ref evtbsd_bttype Bus. Trans. Category
OrderID fcot_evtbsd_ref order_id Order ID
OrderItem fcot_evtbsd_ref order_item SO Item

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_ReferenceTable.
-- 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.
-- Parameters: P_FiscalPeriodEndDate : budat

CREATE VIEW P_ReferenceTable AS
SELECT
  refTable.ledger AS Ledger,
  refTable.prec_awtyp AS PrecReferenceDocumentType,
  refTable.prec_aworg AS PrecReferenceDocumentContext,
  refTable.prec_awref AS PrecReferenceDocument,
  refTable.prec_belnr AS PrecDocumentNumber,
  refTable.evtbsd_awref AS EventBasedReferenceDocument,
  refTable.object_number AS ControllingObject,
  refTable.evtbsd_bttype AS EventBasedBTType,
  refTable.order_id AS OrderID,
  refTable.order_item AS OrderItem
FROM fcot_evtbsd_ref AS refTable
;

Learn More