P_CFD_ASSOCIABLE_BO

DDL: P_CFD_ASSOCIABLE_BO SQL: PCFDASSOCIABLEBO Type: view Package: S_CFD_REPOSITORY_HANDLER

Associable Business Objects

P_CFD_ASSOCIABLE_BO is a CDS View that provides data about "Associable Business Objects" in SAP S/4HANA. It reads from 3 data sources (I_scbo_association, cfd_w_std_bo, cfd_w_std_bo_t) and exposes 16 fields with key field BusinessObjectID. Part of development package S_CFD_REPOSITORY_HANDLER.

Data Sources (3)

SourceAliasJoin Type
I_scbo_association CustomBusinessObject from
cfd_w_std_bo StdBusinessObject union
cfd_w_std_bo_t StdDescription left_outer

Annotations (4)

NameValueLevelField
EndUserText.label Associable Business Objects view
AbapCatalog.sqlViewName PCFDASSOCIABLEBO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectID BusinessObjectID Business Object ID
BusinessObjectName Well Code Des.
BusinessObjectKind
ScenarioID ScenarioID
ReleaseStatus Status
Availability Pkg. Release Status
DataSubjectIdType Data Subject
BadiImplForDataSubject BAdI Implementation
BusinessObjectName cfd_w_std_bo_t description Well Code Des.
BusinessObjectKind
ScenarioID
ReleaseStatus cfd_w_std_bo release_status Status
Availability cfd_w_std_bo availability Pkg. Release Status
DataSubjectIdType cfd_w_std_bo irf_data_subject_id_type Data Subject
BadiImplForDataSubject cfd_w_std_bo badi_impl_for_data_subject BAdI Implementation
CustomBusinessObjectVersion

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_CFD_ASSOCIABLE_BO.
-- 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: PCFDASSOCIABLEBO

CREATE VIEW P_CFD_ASSOCIABLE_BO AS
SELECT
  BusinessObjectID,
  cast( BusinessObjectName as cfd_asso_target_description ) AS BusinessObjectName,
  cast( 'C' as cfd_business_object_kind ) AS BusinessObjectKind,
  ScenarioID,
  cast( '' as cfd_release_status ) AS ReleaseStatus,
  cast( '' as cfd_availability ) AS Availability,
  cast( '' as cfd_irf_data_subject_id_type ) AS DataSubjectIdType,
  cast( '' as cfd_badi_implementation_name ) AS BadiImplForDataSubject,
  cast( '' as abap.char(4) ) AS CustomBusinessObjectVersion
FROM I_scbo_association AS CustomBusinessObject
LEFT OUTER JOIN cfd_w_std_bo_t AS StdDescription ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): cfd_w_std_bo
;