I_CABillgDocSource

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 I_CABillgDocSource.
-- 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: ICAINVBILL_S

CREATE VIEW I_CABillgDocSource AS
SELECT
  billdocno AS CABillgDocument,
  billdocsrcitem AS CABillgDocSourceItem,
  src_group AS CABillgGroupingSourceItems,
  billdocrectype AS CABillgRecordType,
  simulated AS CABillgIsDocumentSimulated,
  crdate AS CABillgDocCreationDate,
  cast(citcat as citcat_gfn_kk preserving type) AS CACnsmpnItmClass,
  bitcat AS CABllbleItmClass,
  bitstatus AS CABllbleItmStatus,
  bitrectype AS CABllbleItmRecordType,
  cast(bit_dbtab as bit_dbtab_gfn_kk preserving type) AS CABllbleItmDatabaseTable,
  bit_grpno AS CABillgGroupingBillableItem,
  subprocess AS CABillgSubprocess,
  bittype AS CABllbleItmType,
  cast(srctatype as srctatype_gfn_kk preserving type) AS CABllbleItmSourceTransType,
  srcreftype AS CABillgSourceTransRefType,
  cast(srcref as bill_srcref_kk_badi preserving type) AS CABillgSourceTransRef,
  xprimary AS CABllbleItmPrimary,
  reltype_primary AS CABllbleItmPrimaryType,
  cast(bitmonth as bitmonth_no_conv_kk preserving type) AS CABllbleItmOriginMonth,
  cast(bitcrmonth as bitcrmonth_no_conv_kk preserving type) AS CABllbleItmCreationMonth,
  bit_amount AS CABllbleItmAmount,
  bit_curr AS CABllbleItmCurrency,
  cast(bit_number as bit_number_gfn_kk preserving type) AS CABllbleItmNumber
FROM dfkkinvbill_s AS invbill_s
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgDocHeader ON CABillgDocument = _CABillgDocHeader.CABillgDocument  -- association [1..1]
LEFT OUTER JOIN I_CACnsmpnItmClass AS _CACnsmpnItmClass ON CACnsmpnItmClass = _CACnsmpnItmClass.CACnsmpnItmClass  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmClass AS _CABllbleItmClass ON CABllbleItmClass = _CABllbleItmClass.CABllbleItmClass  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmType AS _CABllbleItmType ON CABllbleItmType = _CABllbleItmType.CABllbleItmType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmSrceTransType AS _CABllbleItmSrceTransType ON CABllbleItmSourceTransType = _CABllbleItmSrceTransType.CABllbleItmSourceTransType  -- association [0..1]
LEFT OUTER JOIN I_CABillgSubProcess AS _CABillgSubprocess ON CABillgSubprocess = _CABillgSubprocess.CABillgSubprocess  -- association [0..1]
LEFT OUTER JOIN I_CABillgRecordType AS _CABillgRecordType ON CABillgRecordType = _CABillgRecordType.CABillgRecordType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmStatus AS _CABllbleItmStatus ON CABllbleItmStatus = _CABllbleItmStatus.CABllbleItmStatus  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmRecordType AS _CABllbleItmRecordType ON CABllbleItmRecordType = _CABllbleItmRecordType.CABllbleItmRecordType  -- association [0..1]
LEFT OUTER JOIN I_CABillgSourceTransRefTyp AS _CABillgSourceTransRefTyp ON CABillgSourceTransRefType = _CABillgSourceTransRefTyp.CABillgSourceTransRefType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmPrimaryType AS _CABllbleItmPrimaryType ON CABllbleItmPrimaryType = _CABllbleItmPrimaryType.CABllbleItmPrimaryType  -- association [0..1]
;