P_CFD_STD_BO_KEY_COMPONENT

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_STD_BO_KEY_COMPONENT.
-- 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: P_CFD_STBO_KCP

CREATE VIEW P_CFD_STD_BO_KEY_COMPONENT AS
SELECT
  association_target_name AS BusinessObjectIdentifier,
  component_identifier AS ComponentIdentifier,
  sequence_number AS SequenceNumber,
  component_text_element AS ComponentTextElement,
  _Domain.datatype AS DataType,
  cast ( _Domain.leng as integer ) AS Length,
  cast ( _Domain.decimals as integer ) AS Scale,
  _BusinessObject.availability AS Availability,
  _BusinessObject.release_status AS ReleaseStatus
LEFT OUTER JOIN cfd_w_std_bo AS _BusinessObject ON _BusinessObject.association_target_name = BusinessObjectIdentifier  -- association [1]
LEFT OUTER JOIN dd01l AS _Domain ON _Domain.domname = Sbo.domain_name AND _Domain.as4local = 'A' AND _Domain.as4vers = '0000'  -- association [1]
;