ARUN_BDBS_FULL

DDL: ARUN_BDBS_FULL SQL: ARUN_V_BDBSF Type: view
20 Fields 1 Data Sources

Supply Assignment view with semantic key

ARUN_BDBS_FULL is a CDS View that provides data about "Supply Assignment view with semantic key" in SAP S/4HANA. It reads from 1 data source (arun_bdbs) and exposes 20 fields.

Data Sources (1)

SourceAliasJoin Type
arun_bdbs arun_bdbs from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName ARUN_V_BDBSF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Supply Assignment view with semantic key view

Fields (20)

KeyFieldSource TableSource FieldDescription
arunid arunid ARun ID
material material Vehicle Model
plant plant Valuation Area
req_ind req_ind Requirement Type
stock_source stock_source Stock Source
arun_status arun_status ARun Status
alloc_qty alloc_qty Assigned Qty
salesdoc_num salesdoc_num Sales Document
purchdoc_num purchdoc_num STO/RPO
reserv_num reserv_num Reservation
reserv_item reserv_item Reservation Item
batch batch Lot No.
purchord_num purchord_num PO number
prodord_num prodord_num Prod. Ord
prodord_item prodord_item Prod. Ord Item
purchord_sch purchord_sch PO Schedule Line
arun_mode arun_mode ARun Mode
changed_by changed_by User Name
req_segment req_segment Req. Segment
stk_segment stk_segment Stock Segment

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 ARUN_BDBS_FULL.
-- 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: ARUN_V_BDBSF

CREATE VIEW ARUN_BDBS_FULL AS
SELECT
  arunid,
  material,
  plant,
  req_ind,
  stock_source,
  arun_status,
  alloc_qty,
  salesdoc_num,
  purchdoc_num,
  reserv_num,
  reserv_item,
  batch,
  purchord_num,
  prodord_num,
  prodord_item,
  purchord_sch,
  arun_mode,
  changed_by,
  req_segment,
  stk_segment
FROM arun_bdbs
;

Learn More