C_CAMasterDataDistributionItem

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 C_CAMasterDataDistributionItem.
-- 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: CCAMSTRDATAITMS

CREATE VIEW C_CAMasterDataDistributionItem AS
SELECT
  I_CAMasterDataDistrSequence.CAMasterDataDistrObjectRef AS CAMasterDataDistrObjectRef,
  I_CAMasterDataDistrSequence.CAMasterDataDistrSqncObjType AS CAMasterDataDistrSqncObjType,
  I_CAMstrDataDistrRecdWthObject.CARatingArea AS CARatingArea,
  I_CAMasterDataDistrSequence.CAMasterDataDistrSqncObject AS CAMasterDataDistrSqncObject,
  I_CAMasterDataDistrSequence.BusinessPartner AS BusinessPartner,
  I_CAMasterDataDistrSequence.ContractAccount AS ContractAccount,
  I_CAMasterDataDistrSequence.CAProviderContract AS CAProviderContract,
  I_CAMasterDataDistrSequence.CAPrepaidAccount AS CAPrepaidAccount,
  cast ('' as vtkey_kk ) AS CAMasterDataDepdntDistrObj,
  cast ('' as objky_kk) AS CAMasterDataParentDistrObjRef,
  I_CAMstrDataDistrRecdWthObject.CreationDate AS CreationDate,
  I_CAMstrDataDistrRecdWthObject.CreationTime AS CreationTime,
  I_CAMstrDataDistrRecdWthObject.CAMasterDataDistrRecord AS CAMasterDataDistrRecord,
  I_CAMstrDataDistrRecdWthObject.CAMasterDataDistrRecordType AS CAMasterDataDistrRecordType,
  cast ( '' as abap.char(100) ) AS CAMstrDataDistrItemProcgStsTxt,
  cast ( '' as abap.char(100) ) AS CAMstrDataDistrItemDistrStsTxt,
  cast ( 'Information' as abap.char(20) ) AS CAMstrDataDistrItemStsCritlty,
  cast ( '' as abap.char(1) ) AS SystemMessageText,
  I_CAMasterDataDistrSequence.CAMasterDataDistrObjProcStatus AS CAMasterDataDistrObjProcStatus,
  I_CAMasterDataDistrSequence.CASequenceNumber AS CASequenceNumber,
  cast ( '' as asuac_kk ) AS CAAlternativeSubscriberAccount,
  cast ( 0 as int2 ) AS ProcessFlowNodePosition,
  cast ( 0 as int2 ) AS ProcessFlowLane,
  cast ( 0 as int2 ) AS ProcessFlowNode,
  cast ( 0 as int2 ) AS ProcessFlowNodeChild,
  cast ( 0 as int2 ) AS ProcessFlow1stParameterField,
  cast ( 'Neutral' as abap.char(20) ) AS ProcessFlowStatus,
  cast ( '' as abap.char(50) ) AS ProcessFlowNodeFirstTextField,
  cast ( '' as bpf_label_popover_switch ) AS ProcessFlowHasLabelPopOver
FROM I_CAMasterDataDistrSequence
LEFT OUTER JOIN I_CAMstrDataDistrRecdWthObject ON /* join condition not captured in parsed metadata */
;