/PF1/C_OBJREL_BCM_BATCH

DDL: /PF1/C_OBJREL_BCM_BATCH SQL: /PF1/C_OR_BCM Type: view

BCM Batch

/PF1/C_OBJREL_BCM_BATCH is a CDS View that provides data about "BCM Batch" in SAP S/4HANA. It reads from 1 data source (/pf1/db_obj_rel) and exposes 8 fields with key field guid.

Data Sources (1)

SourceAliasJoin Type
/pf1/db_obj_rel /pf1/db_obj_rel from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName /PF1/C_OR_BCM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BCM Batch view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY guid guid UUID 22 char.
ClearingArea clearing_area Clearing Area
ObjectCategory object_category Object Category
PaymentOrderDate obj_date Object Date
PaymentOrderNumber obj_no Object Number
BcmBatchNumber
ExternalSystem ext_system Log. Source Syst.
RelationState relation_state Relation State

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 /PF1/C_OBJREL_BCM_BATCH.
-- 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: /PF1/C_OR_BCM

CREATE VIEW /PF1/C_OBJREL_BCM_BATCH AS
SELECT
  guid,
  clearing_area AS ClearingArea,
  object_category AS ObjectCategory,
  obj_date AS PaymentOrderDate,
  obj_no AS PaymentOrderNumber,
  cast(ltrim(obj_ext_rel, '0') as /pf1/dte_ui_bcm_batch_desc) AS BcmBatchNumber,
  ext_system AS ExternalSystem,
  relation_state AS RelationState
FROM /pf1/db_obj_rel
;